Query to create a collection for XP machines that have not been rebooted for last 15 days

[Alok]

Hi

 

Please help me to create a collection for XP machines that have not been rebooted for last 15 .

[fhdsubz]

SELECT DISTINCT SMS_R_System.Name, SMS_G_System_OPERATING_SYSTEM.LastBootUpTime,
SMS_R_System.ResourceDomainORWorkgroup,
SMS_G_System_OPERATING_SYSTEM.Caption
FROM SMS_R_System INNER JOIN SMS_G_System_OPERATING_SYSTEM ON SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId
WHERE (SMS_G_System_OPERATING_SYSTEM.Caption like "%xp%" and (DateDiff(day, SMS_G_System_OPERATING_SYSTEM.LastBootUpTime, GetDate()) >15)

 

Hope this helps.