Report on Systems not in Use in X Days

Iron Contributor

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? 

6 Replies
Personally, I would start with the power management reports for this. They will show you when user is "using" the device.
These are not populated in my environment.

@shocko What do you mean by that? Are these computers VMs?

Yes to a large degree.
VM doesn't have/show Power Manager inventory.
Yes hence my interest in the interactive logon date that MECM collects as per my initial post.