How to create a filter that reports machines that have NOT sent a configuration in N days
| Article:HOWTO21549 | | | Created: 2010-01-27 | | | Updated: 2011-04-11 | | | Article URL http://www.symantec.com/docs/HOWTO21549 |
Question
You want to create a filter that automatically populates with machines that haven't sent a configuration is a specific amount of days.
Answer SELECT * from vComputer vc JOIN ( ORDER BY LastConfig The value for 'datediff(dd,MAX([StartTime]),getdate()) >=' can be changed to any amount of days desired. In this example, the filter will report all machines that have not sent a configuration in 1 day.
Create a filter and use this query:
select ResourceGuid, LastConfig = datediff(dd,MAX([StartTime]),getdate()),
LastConfigDate = MAX([StartTime]) from Evt_NS_Client_Config_Request group by ResourceGuid HAVING datediff(dd,MAX([StartTime]),getdate()) >= 1
) as a on a.ResourceGuid = vc.Guid
|
|
Legacy ID
51164
Article URL http://www.symantec.com/docs/HOWTO21549
Terms of use for this information are found in Legal Notices









Thank you.