How to determine which agents have not requested a new configuration in the last x days.

Article:HOWTO83875  |  Created: 2013-02-26  |  Updated: 2013-03-04  |  Article URL http://www.symantec.com/docs/HOWTO83875
Article Type
How To



This query can be used to search for managed machines that have not requested a new configuration in the last 14 days.

select (COUNT (distinct lr.ResourceGuid) + 1.0) / (select COUNT (distinct Guid) from vRM_Computer where IsManaged = 1 and Deleted = 0)from (
SELECT ccr.ResourceGuid, MAX(StartTime) AS LastRequestTime
FROM Evt_NS_Client_Config_Request ccr
where ccr.StartTime > GETDATE () - 14
group by ccr.ResourceGuid
) as lr
HAVING (COUNT (distinct lr.ResourceGuid) + 1.0) / (select COUNT (distinct Guid) from vRM_Computer where IsManaged = 1 and Deleted = 0) !> 1.0

If needed, a filter can be created with this query and used as the target for the Altiris Agent auto push install schedule.



Article URL http://www.symantec.com/docs/HOWTO83875


Terms of use for this information are found in Legal Notices