Are you looking for a quick way to find out what computers in your environment have the Operations Manager console for upgrades or Cumulative Update deployment? If you have Configuration Manager this query will show what systems have the executable for the Operations Manager console. (I’ve included two versions – the first which was the quick and easy one that I put together which uses a wildcard to match the name of the executable, the second cleaner version matches the actual executable name – compliments of Eric Morrison).

 

Original version:

select distinct SMS_G_System_SYSTEM.Name, SMS_G_System_SoftwareFile.FileName, SMS_G_System_SoftwareFile.FileVersion from  SMS_R_System inner join SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_SoftwareFile on SMS_G_System_SoftwareFile.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SoftwareFile.FileName like "Microsoft.MOM.UI.Console%" order by SMS_G_System_SYSTEM.Name

Cleaner version:

select distinct SMS_G_System_SYSTEM.Name, SMS_G_System_SoftwareFile.FileVersion from  SMS_R_System inner join SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_SoftwareFile on SMS_G_System_SoftwareFile.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SoftwareFile.FileName = "Microsoft.MOM.UI.Console.exe" order by SMS_G_System_SYSTEM.Name

Summary: Deploying CU4 and want to know what systems have the OpsMgr Console? Try a quick ConfigMgr query.