search cancel

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

book

Article ID: 228306

calendar_today

Updated On:

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 a specific software installed.

Cause

Custom query

Environment

ITMS 8.x

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".