Report on Systems not in Use in X Days in MECM

shockoMS 256 Reputation points

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?

Microsoft Configuration Manager
{count} votes

2 answers

Sort by: Most helpful
  1. AllenLiu-MSFT 41,136 Reputation points Microsoft Vendor

    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.

    0 comments No comments

  2. Garth 411 Reputation points

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

    0 comments No comments