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] > > > >
