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

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

book

Article ID: 228306

calendar_today

Updated On:

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.