Customize Agent Check-in Time
Our agent check-in time is set to daily. We have over 7000 computers so that is fine. After we newly image and rename a system or 40 systems we would llike the agent to check in hourly until it has everything loaded or for at at least the first 48 hours then have them use the set time of daily checkin.
I think I can use the date created field but if someone has a query out there it would be very helpful.
Community Chosen Answer
select *, UNIX_TIMESTAMP(now())-UNIX_TIMESTAMP(LAST_SYNC) as LAST_SYNC_TIME, UNIX_TIMESTAMP(MACHINE.LAST_SYNC) as LAST_SYNC_SECONDS from ORG1.MACHINE LEFT JOIN KBSYS.KUID_ORGANIZATION ON KUID_ORGANIZATION.KUID = MACHINE.KUID LEFT JOIN KBSYS.SMMP_CONNECTION ON SMMP_CONNECTION.KUID = MACHINE.KUID AND KUID_ORGANIZATION.ORGANIZATION_ID = 1 where ((DATEDIFF(NOW(),OS_INSTALLED_DATE) <= 2))