/build/static/layout/Breadcrumb_cap_w.png

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

Answers (1)

Posted by: JasonEgg 6 days ago
Red Belt
0

Try this:

SELECT DISTINCT
    MACHINE.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')

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ