Report on Systems not in Use in X Days in MECM

Question

I'm looking to find machines in my Windows 10 estate that are not being used. I'm going to enable device affinity but we also have a lot of machines with shared usage amongst numerous users and device affinity/primary users falls down there to a degree. Looking through the DB Tables/Views I see some tables/views that might be tracking console logon usage. I'm trying to decipher the schema (Schema Overview - Configuration Manager | Microsoft Learn) but not having much luck. Should I be looking at WMI for this (SMS_SystemConsoleUsage Class - Configuration Manager | Microsoft Learn) or the equivalent DBO table ? the view v_GS_SYSTEM_CONSOLE_USAGE_MAXGROUP has some useful information but is this the same info as the WMI class?

Answer 1

Hi, @shockoMS

Thank you for posting in Microsoft Q&A forum.

The view v_GS_SYSTEM_CONSOLE_USAGE_MAXGROUP have the same info to WMI class SMS_SystemConsoleUsage.
The difference is that the info in v_GS_SYSTEM_CONSOLE_USAGE_MAXGROUP is collected by hardware inventory, and the schedule for hardware inventory is 7 days once by default. So this could be date from a few days ago, it's not very accurate.
The data in WMI class SMS_SystemConsoleUsage is more real-time and accurate.

---

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.

Answer 2

Personally, I would start with the power management reports for this. They will show you when user is "using" the device.