/build/static/layout/Breadcrumb_cap_w.png

How to handle reporting with multiple versions of software on client

I am trying to determine which machines in our environment have only Outlook 2010 installed. There are machines here which have only Office 2010 installed, only Office 2013 installed, and a certain number with a blending of the two (don't ask, lol). I'm not a complete MySQL noob but this one has baffled me. (Might need more caffeine too!) I can list all machines with Outlook 2010 installed, but those machines ALSO may have Outlook 2013 on them. (I've chosen a couple machines at random to see if they do have Office 2013 on them, and they do.)

I can run this query and get installed machines:

select
    M.NAME as MACHINE_NAME,
    S.DISPLAY_NAME as SOFTWARE_NAME,
    S.DISPLAY_VERSION as VERSION,
    M.USER_FULLNAME as LAST_USER
from
    SOFTWARE S
        left join
    MACHINE_SOFTWARE_JT MSJ ON S.ID = MSJ.SOFTWARE_ID
        left join
    MACHINE M ON MSJ.MACHINE_ID = M.ID
where
    S.DISPLAY_NAME like '%Outlook MUI (English) 2010%'
        and not IS_PATCH
order by S.DISPLAY_NAME , S.DISPLAY_VERSION , M.NAME

Of course, I change the '2010' value to '2013' for Outlook 2013. I can run that above query once for each value (2010, 2013), export the resulting table, and use Excel or Access to get my results, but I was hoping there was a way via MySQL.

Thanks in advance for the help! 

Michelle

0 Comments   [ + ] Show comments

Answers (1)

Posted by: SMal.tmcc 8 years ago
Red Belt
0
you can create smart labels for the combinations of software and report using the labels
 
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