i just ran the query ,it is missing the below said columns.i tried running the report using BIDS/Visual studio,seems like it as multiple select statements in one dataset but these values are used to in different tables and they are not union as well ..just separate SQL queries in one dataset.Ok,i ran the report using visual studio and it failed with error msg: The size necessary to buffer the xml content exceeded the buffer quota. You must create separate data set for each table for the data missing.try that one and see if that works or not.i can try later how it works.,
RegardsEswar Koneti www.eskonr.com From: [email protected] To: [email protected] Subject: RE: [mssms] Updated all-in-one machine details report? Date: Wed, 3 Dec 2014 00:14:25 +0000 The 3 sections below are missing data… From: [email protected] [mailto:[email protected]] On Behalf Of Todd Hemsell Sent: Tuesday, December 2, 2014 8:27 AM To: [email protected] Subject: Re: [mssms] Updated all-in-one machine details report? it works fine in CM12. What data is missing? I am guessing it is missing installed apps. If so you need to edit it to look at installed software, not AR Programs. select v_GS_ADD_REMOVE_PROGRAMS.Publisher0, v_GS_ADD_REMOVE_PROGRAMS.DisplayName0, v_GS_ADD_REMOVE_PROGRAMS.Version0 from v_R_System, v_GS_ADD_REMOVE_PROGRAMS where v_R_System.Name0 like @machineName and v_R_System.ResourceID = v_GS_ADD_REMOVE_PROGRAMS.ResourceID order by v_GS_ADD_REMOVE_PROGRAMS.DisplayName0 On Mon, Dec 1, 2014 at 11:36 AM, Murray, Mike <[email protected]> wrote: I have a report that ran great on CM 2007 that includes a ton of information about a selected computer, including hardware and software, OS, IP, etc. When run in 2012, it’s missing a lot of data. Before I dig through the SQL, I thought I’d see if anyone has an updated version of this report they would be willing to share. I’m attaching the old one. Best Regards, Mike Murray Desktop Management Coordinator - IT Support Services California State University, Chico 530.898.4357 [email protected]
