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.
Imported Document Id
This is machine translated content
Login to Subscribe
Please login to set up your
For security reasons, your link to this document has expired. Please click on the attachment link to access this file.
The attachment that you are looking for no longer exists.
There has been an issue retrieving your attachment. Please try again.
Currently server is down.
Didn't find the article you were looking for? Try these resources.