Can anyone please help me with this... This is the query I have come up with so far and I am getting error when I try to run it against the user collection I have created.
SELECT SMS_R_User.UserName, SMS_R_User.Name, SMS_R_User.lastLogonTimestamp DATEADD(mi,(lastLogontimeStamp0 / 600000000) - 157258080,0) AS [Last Logon Time Stamp (UTC)] FROM SMS_R_User.UserName WHERE User_Name0 LIKE @variable
If anyone can help me fix this script, then that would be a big help.
Thanks-