Does the assigned to field in cmdb_ci_computer table shows the last logged in users information from sccm

[Madhura5]

Hi All,

We have recently set up SCCM in our environment to get the workstation data. I wanted to understand what value is displayed in the assigned to field in cmdb_ci_computer table. Does it show the last logged in users name or is it the name of the person to whom the workstation is assigned

[asifnoor]

Hi,

assigned_to field will basically store the user to whom that particular item is assigned to. It will not show the last logged in user's name.

[hiranmayeesahoo · Accepted solution]

From sccm, the assigned to field gets populated with the user to whom the computer is assigned to.

The assigned to logic is OOB for sccm integration, you may alter the logic if it has a different value

[Community Alums]

Hi MK,

As per above comments 'Assigned To' signifies the user the CI is assigned to.

However, SCCM sends the values of 'Last Logged In' user and 'Last Login Time' as well which can be captured if you create couple of custom fields on your CI table.

Let me know if you have any more queries.

[adamtrent]

Hi Hardit,

Could you expand on this please:

What does the query for last logged on user look like?

Do you edit the OOB SCCM 2016 Computer Identity datasource query to include last logged on user?

Grateful or any help with this

Thanks