How can I run a report showing what computers has outlook installed or not.
Is there a way to setup a report that shows if Outlook is installed under MS Office Pro Plus 2013, 2016 and 2019? We have 150 computers and some have Outlook instilled and some don't. We don't want to have to hunt and pick to see who has what. The normal reporting only show if they have Office installed or not.
2 Comments
[ + ] Show comments
-
On Windows, Mac, or both? - JasonEgg 3 years ago
-
Windows 10. - Stevenryn 3 years ago
Answers (2)
Answer Summary:
Please log in to answer
Posted by:
JasonEgg
3 years ago
Top Answer
Try this:
SELECT DISTINCTMACHINE.ID,
MACHINE.NAME,
MACHINE.USER_NAME,
CATALOG.SAM_CATALOG.NAME,
CATALOG.SAM_CATALOG.SOFTWARE_VERSION
FROM
MACHINE
JOIN
SAM_MACHINE_JT ON SAM_MACHINE_JT.MACHINE_ID = MACHINE.ID
JOIN
CATALOG.SAM_CATALOG ON SAM_MACHINE_JT.SAM_CATALOG_ID = CATALOG.SAM_CATALOG.ID
WHERE
CATALOG.SAM_CATALOG.ID IN (SELECT
ID
FROM
CATALOG.SAM_CATALOG
WHERE
NAME LIKE 'Outlook%'
AND PRODUCT_NAME = 'Outlook'
AND SOFTWARE_PLATFORM = 'Windows')