Skip to content

IT-LAIG

Established Members
  • Joined

  • Last visited

  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

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.