SELECT SMS_R_System.ResourceID,SMS_R_System.ResourceType,SMS_R_System.Name,
 SMS_R_System.SMSUniqueIdentifier,
 SMS_R_System.ResourceDomainORWorkgroup,SMS_R_System.Client
FROM SMS_R_System
WHERE (DateDiff(day, CreationDate, GetDate()) < 1)

 

Leave a Reply

Your email address will not be published. Required fields are marked *