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

Madhura5
Tera Contributor

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

1 ACCEPTED SOLUTION

hiranmayeesahoo
Kilo Expert

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

View solution in original post

6 REPLIES 6

Community Alums
Not applicable

It depend on the query which is being used. Can you share more details about your integration and your issue?

Hi Hardit,

 

Could you please explain me what is "Assigned" field on cmdb_ci_computer table.

 

Regards,

Imam.