Tip of the day: List of machines with Adobe ColdFusion MX

Posted in Reports and Queries, SCCM 2007, SCCM 2012, System Center Configuration Manager

This query lists all the machines with a copy of Adobe ColdFusion by Version and Edition using a class provided by Normalize CM.

WQL:

select System.Name, Software.Publisher, Software.Family, Software.SoftwareName, Software.Component, Software.MinorVersion, Software.MajorVersion, Software.Edition, Software.Category1, Software.Category2 from  SMS_R_System inner join SMS_G_System_BDNA_BDNASOFTWAREDATA_1_1 as Software on Software.SMSUniqueIdentifier = SMS_R_System.SMSUniqueIdentifier inner join SMS_R_System as System on System.SMSUniqueIdentifier = Software.SMSUniqueIdentifier where Software.Publisher = “Adobe Systems” and Software.SoftwareName = “ColdFusion MX”

SQL:

SELECT v_R_System.Name0 as Name, Software.Publisher0 as Publisher, Software.Family0 as Family, Software.SoftwareName0 as SoftwareName, Software.Component0 as Component, Software.MinorVersion0 as MinorVersion, Software.MajorVersion0 as MajorVersion, Software.Edition0 as Edition, Software.ServicePack0 as ServicePack, Software.Category10 as Category1, Software.Category20 as Category2

FROM v_R_System

INNER JOIN v_GS_BDNA_Software_Data0 Software ON Software.SMSUniqueIdentifier0 = v_R_System.SMS_Unique_Identifier0 WHERE Software.Publisher0 = ‘Adobe Systems’ AND Software.SoftwareName0 = ‘ColdFusion MX’

Sample output:

Manufacturer Product Name Edition Name Major Version
Adobe Systems ColdFusion MX Enterprise 7
Adobe Systems ColdFusion MX Standard 7
Adobe Systems ColdFusion MX Enterprise 6
Adobe Systems ColdFusion MX Standard 6

 

email

Written by , Posted .