ConfigMgr Basics - What are the differences between UDA and TopConsoleUser0 in v_GS_SYSTEM_CONSOLE_USAGE ?

Article
2016-06-14

Question

_{Tuesday, June 14, 2016 8:47 PM}

Hi Community,

So I've been putting together some reports to map primary users to devices in my organization. In doing so, I've been spending some time with the following view : v_GS_SYSTEM_CONSOLE_USAGE and I noticed that I have duplicate ResourceID records with differing TotalConsoleTime0 values. So, my first question should anyone be able to answer it is :

1) Why would there be duplicate records for a ResourceID with differing TotalConsoleTime0 values? Is it due to profile deletion or re-creation on the actual workstation?

2) As it pertains to UDA I find myself wondering what the actual distinctions are between trying to draft a report based on TopConsoleUser0 values vs. whatever underlying database values UDA leverages?

3) Does UDA leverage the TopConsoleUser0 column in the aforementioned view?

My understanding of UDA is that it is a mechanism developed to focus software deployments to a user's primary device which could be a tablet, mobile phone, or workstation. Thus UDA creates a relationship between a user and a device. In my mind this may not have anything to do with the TopConsoleUser0 column in the aforementioned view, particularly in a scenario where a user manually defines a UDA relationship. But, what about if your Client Agent settings are set to auto populate this data?

4) What does this mean when we are trying to draft reports for a device -> primary user? Is it more accurate to leverage UDA data for such a report (assuming enabling UDA in the client agent settings) produces additional views to aggregate this information from the various tables in the ConfigMgr DB?

As always I appreciate your input and guidance!

Gabe | @ConfigMgrGeek

All replies (5)

_{Wednesday, June 15, 2016 3:21 PM ✅Answered | 1 vote}

Yes there is another SQL view it is called, v_GS_SYSTEM_CONSOLE_USAGE_MAXGROUP. This view will give you the user with the MOST usage. BUT it will also have more NULLs too.

v_GS_SYSTEM_CONSOLE_USAGE gives you all user that have logon to a computer, therefore you should expect to see many computers with two or more users listed.

Use v_GS_SYSTEM_CONSOLE_USAGE_MAXGROUP for the CMDB then I would user last logon user for any NULLs, something like this.

isnull(SCUM.TopConsoleUser0, isnull(RV.User_Domain0 +'\+RV.User_Name0,'n/a')) AS 'UserName',

Garth Jones

Blog: http://www.enhansoft.com/blog Old Blog: http://smsug.ca/blogs/garth_jones/default.aspx

Twitter: @GarthMJ Book: System Center Configuration Manager Reporting Unleased

_{Wednesday, June 15, 2016 2:34 AM}

Dear Sir,

1) It should not be with user profile, but some left over in the WMI class as these information were collected from WMI Classes during hardware inventory.

2) The TopConsoleUser property, which is the user who has been logged in the most on the device. UDA is just a method of associating a user with one or more specified devices. Administrators have to manage the user device affinity so that they know the information is accurate then make use of these information.

3)Correct. Administrators need to decide if the 'Automatically configure user device affinity...' fits the environment that's what I said in 2) that administrators have to manage.

4)It bases on what you need to report.

Share via

ConfigMgr Basics - What are the differences between UDA and TopConsoleUser0 in v_GS_SYSTEM_CONSOLE_USAGE ?

Question

All replies (5)

Additional resources