The CreatorCon Call for Content is officially open! Get started here.

How to retrieve Last Activity/LastHeartBeat (not LastHWScan) for a computer from SCCM.

Aswin2
Tera Contributor

‎06-02-2023 06:27 AM

We are currently pulling the LastHWScan from the view v_GS_WORKSTATION_STATUS in SCCM.

 

Looking to pull Last Activity/Last Heartbeat, as it is more accurate. Can anyone help with the view name column name ?

0 Helpfuls
  • 2,454 Views
1 REPLY 1

Saurav11
Kilo Patron
Kilo Patron

‎06-03-2023 12:35 AM

Hello,

 

It will be in v_CombinedDeviceResources view.

 

Please find the below articles:-

 

https://forum.howtomanagedevices.com/endpointmanager/configuration-manager/sql-query-to-get-the-last...

 

https://learn.microsoft.com/en-us/answers/questions/925339/create-report-on-sccm-columns

 

Please mark my answer as correct based on Impact.

0 Helpfuls