When a machine checks into the K1000 you might want to set an aggressive patch schedule to get the patches installed after a scripted installation. In the K1000 we need to define what machines have been imaged recently and then we can set a patch schedule to run more frequently on that group of machines. This SQL statement should allow you to identify machines that have been imaged within the past 2 days. Create a smart label with any criteria...then edit the label using the old editor (not the one that created it) and paste in this SQL code.
select * from MACHINE where OS_INSTALLED_DATE >= (CURRENT_TIMESTAMP()-INTERVAL 2 DAY)
It's the small things you overlook when you try to make this stuff.
That's a dandy Label to have in the big picture of things, and those new PC's often need special attention :) - Wildwolfay 11 years ago