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:
M.NAME as MACHINE_NAME,
S.DISPLAY_NAME as SOFTWARE_NAME,
S.DISPLAY_VERSION as VERSION,
M.USER_FULLNAME as LAST_USER
MACHINE_SOFTWARE_JT MSJ ON S.ID = MSJ.SOFTWARE_ID
MACHINE M ON MSJ.MACHINE_ID = M.ID
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!