I have the following report/query that is a default report in KACE:
Select PUBLISHER, DISPLAY_NAME, COUNT(DISPLAY_NAME) as Deployment_Count from (SOFTWARE, MACHINE_SOFTWARE_JT)
where SOFTWARE.ID = MACHINE_SOFTWARE_JT.SOFTWARE_ID
and not IS_PATCH
GROUP BY DISPLAY_NAME
order by DISPLAY_NAME
This displays the info I am looking for but the question I have is can we have one query that will return this info for only my SERVER environment? I will also need this for all my workstations (Windows 7 ,XP ,etc ) machines.
I want to have my server’s separate from my workstations.