The 3 sections below are missing data… [cid:[email protected]]
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]<mailto:[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]<mailto:[email protected]>
