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

Comments

Please log in to comment

Answers

0
you can create smart labels for the combinations of software and report using the labels
Answered 12/01/2015 by: SMal.tmcc
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity