Smart Label to Show Windows Servers not on a Patch Schedule
Trying to figure out how I can monitor servers that are not on a patch schedule. How can I create a smart label that will show me list of servers that is not on any patch schedule?
Thanks!
Answers (2)
skip the smart label.
Use the report wizard and create a device report.
choose device report on page 1
choose device name on page 2
go to the last page (filters) create 2 filters
1st OS name begins with Microsoft
2nd either detect or deploy status is not null ( if they are null patching has not run on this machine)
save the filters then save at the bottom of page
create a report schedule and have that email on the schedule you want.
Then crack open the report to see the SQL used by KACE, create a new smart label, view the SQL and then paste the report SQL to run the smart label.........;o)
