So I am trying to create a script that will show me what servers haven't been patched in 60 days The script works wonderfully. The problem is that some of the nodes have not updated in a long time, and in order for this report to be effective, they need to be updating
We got this gathered up by way of a nifty little swql query that goes like this.
SELECT n.AssetInventory.ServerInformation.HostName, n.IPAddress, n.StatusDescription, n.MachineType, n.Engine.ServerName AS PollingEngineName, n.AssetInventory.LastPollDateTime, MINUTEDIFF(n.AssetInventory.LastPollDateTime, GETUTCDATE()) / 1440 AS DaysSinceLastPolled FROM Orion.Nodes AS n WHERE n.MachineType LIKE '%Windows%' -- Windows machines only AND MINUTEDIFF(n.AssetInventory.LastPollDateTime, GETUTCDATE()) / 1440 > 1 -- It's been over 1 day since it was last polled AND n.Engine.ServerName = 'POL02' ORDER BY n.Engine.ServerName, n.AssetInventory.LastPollDateTime
So one of my ape has 327 nodes that are out of date for inventory collection. Anyone have a solution to this quandary?
Thanks
Trilobite_Rex
