Create report on SCCM columns

Question

Hi all,

Would anyone know what fields I would need to query in the SCCM DB to get a report on these 2 fields in the console "Last Activity" & "Currently Logged on User"?

We are trying to link them to our Service Now environment, so need to find out what is being called in the DB.

Thanks

Answer 1

look at the SQL view "v_CombinedDeviceResources". This will have most of the client details that you see it in the console.

Thanks,
Eswar
www.eskonr.com

Answer 2

@Kevin Hawkins
I found the following in my lab and I want to share with you to confirm whether it is helpful.
New query in my lab to request the Currently Logged on User and Last Activity:

Query Language:

select SMS_R_System.Name, SMS_R_System.LastLogonTimestamp, SMS_R_System.LastLogonUserName, SMS_R_System.ClientVersion from  SMS_R_System  

Also we could request the status in DB by SSMS:

Query Language:

select Name0,Last_Logon_Timestamp0,User_Name0  from dbo.vSMS_R_System   

I'm not an expert in SQL. The above finding are just for your reference. Hope the above will be helpful. Please let me know if there are any questions or updates of the above.

Best regards,
Rita

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.