Tip of the day: List of machines with Microsoft Office Word

This query lists all the machines with a copy of Microsoft Office Word by Version, Edition and Service Pack.

*Requires Normalize CM

Manufacturer	Family	Product Name	Edition	Service Pack	Major Version
Microsoft	Office	Word	Home and Student	SP1	2010
Microsoft	Office	Word	Home and Student		2010
Microsoft	Office	Word	Standard	SP1	2010
Microsoft	Office	Word	Standard		2010
Microsoft	Office	Word	Starter	SP1	2010
Microsoft	Office	Word	Starter		2010
Microsoft	Office	Word	Home and Student	SP2	2007
Microsoft	Office	Word	Home and Student	SP1	2007
Microsoft	Office	Word	Home and Student		2007
Microsoft	Office	Word	Standard	SP1	2007
Microsoft	Office	Word	Standard		2007
Microsoft	Office	Word	Starter	SP1	2007
Microsoft	Office	Word	Starter		2007
Microsoft	Office	Word	Home and Student	SP2	2003
Microsoft	Office	Word	Home and Student	SP1	2003
Microsoft	Office	Word	Home and Student		2003
Microsoft	Office	Word	Standard	SP2	2003
Microsoft	Office	Word	Standard	SP1	2003
Microsoft	Office	Word	Standard	SP1	2003
Microsoft	Office	Word	Starter	SP2	2003
Microsoft	Office	Word	Starter	SP1	2003
Microsoft	Office	Word	Starter		2003
Microsoft	Office	Word	Standard		2000
Microsoft	Office	Word	Standard		97
Microsoft	Office	Word	Standard		95

*The list above is not exhaustive, and only provided a sample of the data that are available within CM.

Using the new CM class BDNA_SOFTWARE_DATA, all your inventoried software are now available into a single table. You can query this table using WQL or SQL.

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_2 as Software on Software.SMSUniqueIdentifier = SMS_R_System.SMSUniqueIdentifier inner join SMS_R_System as System on System.SMSUniqueIdentifier = Software.SMSUniqueIdentifier where Software.Publisher = “Microsoft” and Software.Family = “Office” and Software.SoftwareName = “Word”

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 = ‘Microsoft’ AND Software.Family0 = ‘Office’ AND Software.SoftwareName0 = ‘Word’