Wondering if anyone can help me with the following:I am trying to use the Discovery results to create a report of all machines on our network. The problem is that we do not install the Kace Agent on any servers. I'd like to have the report only show the OS and count of machines with that OS installed.
I created a simple report of the inventoried machines:
SELECT CHASSIS_TYPE, OS_NAME, COUNT(OS_NAME) as COUNT FROM MACHINE GROUP BY CHASSIS_TYPE, OS_NAME
Something similar using Discovery results would be ideal, right now I have list of >1,000 host names and OS's