I'm looking for a good query/report to find System Center Operations Manager installations. I'm currently using the following query, but it includes computers which have just the council installed: SELECT r1.Name0, r1.User_Name0, InstallDate0 FROM v_GS_INSTALLED_SOFTWARE i1 LEFT JOIN v_R_System r1 ON i1.ResourceID = r1.ResourceID WHERE ARPDisplayName0 = 'System Center Operations Manager 2007'

Hi Eathen, are you trying to identify OpsMgr agents or OpsMgr components installation. In the latter your query is right. In the former you can query on services with HealthService: SELECT TOP 1000 SYS.Netbios_Name0, SVC .[ResourceID] ,[GroupID] ,[RevisionID] ,[AgentID] ,[TimeStamp] ,[DisplayName0] ,[Name0] ,[PathName0] ,[ServiceType0] ,[Started0] ,[StartMode0] ,[StartName0] ,[State0] ,[Status0] FROM v_GS_SERVICE SVC inner join v_R_System_Valid SYS on SYS.ResourceID=SVC.ResourceID where SVC.name0 = 'HealthService'- Daniele, Microsoft MVP OpsMgr This posting is provided "AS IS" with no warranties, and confers no rights. http://nocentdocent.wordpress.com http://www.progel.it

I'm looking to inventory Ops Managers installations. I'm having trouble identifying a council install verse a server install. Both the council and server install have similar entries in v_gs_installed_software. There are different registry values for a full server install which I can pull into CM, but I'm wondering if I need to go that far.

I fear you should- Daniele, Microsoft MVP OpsMgr This posting is provided "AS IS" with no warranties, and confers no rights. http://nocentdocent.wordpress.com http://www.progel.it