SQL query to get a list of all computers with "Microsoft Office" installed

Products

• Server Management Suite
• IT Management Suite

Issue/Introduction

SQL query to get a list of all computers with "Microsoft Office" installed.

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

Environment

ITMS 8.x

Cause

Custom query

Resolution

The following query is provided as an example:

*****************
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 to the software you want to search in this case it would be "Microsoft Office".