Fyi only the query below will only find x86 SW titles.. use v_add_remove_programs to get both x86 and x64.
Sent from Surface From: Todd Hemsell<mailto:[email protected]> Sent: ?Tuesday?, ?December? ?2?, ?2014 ?11?:?32? ?AM To: [email protected]<mailto:[email protected]> 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]>
