User Device Affinity CM 2002

ADM-AKR7415 1 Reputation point
2020-12-21T15:21:50.8+00:00

Hello All,

At present we have enabled automatic User Device Affinity for 10000 machines in "Client Settings". We are getting the results but they do seem to be accurate. May be bcoz multiple users using multiple machines.... etc..

Now we have decided to import the User-Device Affinity information manually using File.

Questions :

How do I clean the SCCM database with all the UDA information and start from scratch.

Other than disabling the UDA in client settings, do I have to do anything else so that the manual information we feed in does not get over-write by automatic method

We just want to restrict and freeze the UDA information with manual method with no automation

What exact permissions we should give to "service desk team" in the SCCM console just to do user device affinity manually ( both via file and one-by-one )

Please treat this urgent as Management wants accurate information

Thanks,
Karan

Microsoft Configuration Manager
0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jason Sandys 31,151 Reputation points Microsoft Employee
    2020-12-21T16:58:04.033+00:00

    Please treat this urgent as Management wants accurate information

    Then you need to open a support ticket. Social forums like this provide best effort support and are not for urgent issues.

    How do I clean the SCCM database with all the UDA information and start from scratch.

    There is no direct method to remove all UDA info. You will have to script this using the RemoveSourceMethod of the SMS_UserMachineRelationship WMI class. See https://learn.microsoft.com/en-us/mem/configmgr/develop/reference/core/clients/manage/removesource-method-in-class-sms_usermachinerelationship.

    Other than disabling the UDA in client settings, do I have to do anything else so that the manual information we feed in does not get over-write by automatic method

    No

    What exact permissions we should give to "service desk team" in the SCCM console just to do user device affinity manually ( both via file and one-by-one )

    For RBA, there's an entire class named "User Device Affinities".

    1 person found this answer helpful.
  2. Jason Sandys 31,151 Reputation points Microsoft Employee
    2020-12-21T18:23:26.073+00:00

    Please let me know a safe SQL query which can be used to delete UDA information SCCM Database

    Nothing like this exists. Using SQL to directly modify the ConfigMgr DB is completely unsupported and may/will cause issues

    If I enable the Site maintenance task " Delete Aged User Device Affinity Data " and make it 1 day and parallelly disable Automatic UDA in Client Settings..... will that clear the SCCM database in automatic way ??

    Not to my knowledge. This task deletes the data but not the affinity itself. It'd be worth trying though.

    Does "Delete Aged User Device Affinity Data" also effect the UDA which we do manually via file.

    Same answer as above as I do not belive this actually deletes the affinity itself but deletes the data assoicated with the affinity. You can easily test this though.

  3. Fiona Yan-MSFT 2,311 Reputation points
    2020-12-22T09:00:16.043+00:00

    @ADM-AKR7415

    Thank you for posting in Microsoft Q&A forum.

    We should be able to achieve that by using one of the remove methods of the SMS_UserMachineRelationship class. Please refer to the following article for more details:

    Removetype-method-in-class-sms_usermachinerelationship

    If the response is helpful, please click "Accept Answer" and upvote it.
    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