Report on Systems not in Use in X Days in MECM

shockoMS 256 Reputation points
2022-10-05T19:57:09.627+00:00

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
    2022-10-06T07:13:02.427+00:00

    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.
    247939-1.png


    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
    2022-10-06T12:42:44.643+00:00

    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