Looking for a report that will show devices not patched within the last 90 days
I am hoping that this hasn't already been covered. I am not good at building custom reports. I would love to have a report that shows devices that haven't patched within X number of days.
Also, I'm excited to be better at report building, so please teach me to fish!
With Kace reports, I am sure you know this, but there are two main ways to make reports> The wizard is awesome for anyone, even if you know little of what you are doing. Patch detect and deployments may be a good topic to start with on the wizard (in the first step of creating the report with the wizard you choose the topic). It gives you the choice of any of these fields:
Deploy Attempts Remaining
Max Deploy Attempts Possible
Stage Status Date
Number of Records Analyzed
So go through the wizard with that and see if you can do what you are wanting and get good results using the wizard: then on the last step "filters" you would just filter on whichever date field you want in within the last 90 days.
The other really powerful way to make reports is SQL. If you google what you are looking for in a Kace report, someone has probably already made something similar you can start with - but this is not great or helpful if you do not know SQL. If you DO know SQL, this is also super helpful: schema_bootkamp.jpg (2690×1867) (foreignkid.net)