Jump to content


IT-LAIG

Established Members
  • Posts

    2
  • Joined

  • Last visited

IT-LAIG's Achievements

Newbie

Newbie (1/14)

0

Reputation

  1. 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-
  2. I am a SCCM newbie with no SQL query background and need help with this task. I have been asked in SCCM 2012 to create custom report that shows user login information. They want to be able to see all users and their login timestamp (in a readable form). I really need help with how get this accomplished in Configuration Manager and how do I go about in creating a query. Can somebody please help me with this task
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.