Share via

User Device Affinity CM 2002 Question

Kunal Mehra 21 Reputation points
2020-12-28T17:14:56.767+00:00

Hello Guys,

QQ...... We have automatic User Device Affinity enabled in CM 2002. We also need to feed-in manual bulk information via CSV file....

  • Will Automatic UDA overwrite Manual Fed Information ?
  • How can we identify via reports / query or any other means..... which UDA information is filled Automatically and which one manually...?
Microsoft Security | Intune | Configuration Manager | Other
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jason Sandys 31,421 Reputation points Microsoft Employee Moderator
    2020-12-28T19:15:44.407+00:00

    UDA info is additive so if you add manual info it will just get added to what is already there.

    The sources attribute of the WMI SMS_UserMachineRelationship class will tell you the source. See https://learn.microsoft.com/en-us/mem/configmgr/develop/reference/core/clients/manage/sms_usermachinerelationship-server-wmi-class for info on this class.

    Within SQL, you can use the v_UserMachineRelationship view.

    Was this answer helpful?

    1 person found this answer helpful.
  2. Jason Sandys 31,421 Reputation points Microsoft Employee Moderator
    2020-12-30T02:20:13.633+00:00

    Then you need to first remove the manual UDA info.

    As for source info, use WMI then and a console-based query. v_UserMachineSourceRelation appears to have the source info but you'll have to join that with v_UserMachineRelationship it appears -- I don't know for sure what the relationship for these two views is so you're better off using WMI as noted.

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.