SHARE
TWEET

last_hardware_scan_WQL

vidockq Mar 17th, 2015 247 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT SMS_R_System.ResourceID FROM SMS_R_System INNER JOIN SMS_G_System_WORKSTATION_STATUS ON SMS_G_System_WORKSTATION_STATUS.ResourceID = SMS_R_System.Resourceid WHERE datediff(DAY,SMS_G_System_WORKSTATION_STATUS.LastHardwareScan,getdate()) < '2'
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top