/build/static/layout/Breadcrumb_cap_w.png
01/13/2010 2247 views
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.



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

Comments


There are no answers at this time

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.