Need help tweaking report that will list computers with multiple versions of SEP installed.
I am trying to create a report that will list machines with both SEP 11 and SEP 12 installed. We have multiple versions and I thought I had my SQL correct but it is returning 0 results and I know for a fact that there are machines in our environment that have both versions listed as being installed.
Here is what I have so far. Any help would be greatly appreciated.
S.DISPLAY_NAME AS SOFTWARE_NAME,
S.DISPLAY_VERSION AS VERSION,
M.`NAME` AS MACHINE_NAME,
M.USER_FULLNAME AS LAST_USER,
SOFTWARE AS S
JOIN MACHINE_SOFTWARE_JT AS MSJ ON S.ID = MSJ.SOFTWARE_ID
LEFT JOIN MACHINE AS M ON MSJ.MACHINE_ID = M.ID
where S.DISPLAY_NAME like 'symantec endpoint protection%'
and S.DISPLAY_VERSION like '12.1.2015.2015%'
or S.DISPLAY_VERSION like '12.1.2100.2093%'
and S.DISPLAY_VERSION like '11.0.5002.333%'
or S.DISPLAY_VERSION like '11.0.4202.75%'
or S.DISPLAY_VERSION like '11.0.6100.645%'
and not IS_PATCH
order by S.DISPLAY_NAME, S.DISPLAY_VERSION, M.NAME