[SQL] UltraVNC Policy success
After deploying the UltraVNC Configuration Policy, you want to know how many machines in a label still don't have UltraVNC.
NOTE: You can easily change the text between the %%'s to match any other software item or label.
NOTE: You can easily change the text between the %%'s to match any other software item or label.
select M.IP, M.NAME
from MACHINE M
left join MACHINE_LABEL_JT MLJ on M.ID = MLJ.MACHINE_ID
left join LABEL L on L.ID = MLJ.LABEL_ID
where M.ID not in (select MACHINE.ID
from MACHINE
left join MACHINE_SOFTWARE_JT MSJ on MACHINE.ID = MSJ.MACHINE_ID
left join SOFTWARE S on S.ID = MSJ.SOFTWARE_ID
where S.DISPLAY_NAME like '%UltraVNC 1%')
and L.NAME like '%Desktops%'
order by M.NAME
0 Comments
[ + ] Show comments
Answers (0)
Please log in to answer
Be the first to answer this question

so that the conversation will remain readable.