SQL query to get a list of all computers with any specific software installed

Products

• Server Management Suite
• IT Management Suite

Issue/Introduction

Is there a SQL query that can return a list of all computers with specific software installed?

Environment

ITMS 8.x

Cause

Custom query needed

Resolution

The following query is provided as an example and is not supported by Broadcom Technical Support:

Select Inv_AddRemoveProgram.DisplayName, Inv_AddRemoveProgram.DisplayVersion, Inv_AddRemoveProgram.InstallDate, vComputer.Name
From Inv_AddRemoveProgram
INNER JOIN vComputer on Inv_AddRemoveProgram._ResourceGuid=vComputer.Guid
Where DisplayName like 'Microsoft Office';

Note: Please change the "Microsoft Office" in the script above to the software you want to search.