K1000 Reporting - SQL querys help
I am in need of some help with coming up with custom sql reports.
The first one I need is an OS split which which gives me the total number of machines for each OS and the percentage.
This is what I have so far (It just gives me the total numbers)
select OS_NAME, COUNT(OS_NAME) as OSCOUNT from MACHINE group by OS_NAME order by OSCOUNT desc
The next one I need is to be able to do the same as above but with all versions of Microsoft Office. Any ideas?
And the last one, I would like to be able to see the total number of how many computers have been patched this week and how many haven't?
Also, can anyone recommend any guides which will help me with this?