How to add SCCM 2012 Custom Active Directory Attributes

Benoit LecoursSCCM10 Comments

SCCM 2012 Active Directory System Discovery brings a couple of default Active Directory attributes :

SCCM 2012 custom active directory attributes

I get often asked if it’s possible to add a SCCM 2012 custom active directory attributes.

The answer is yes, you can add any AD attribute, and it’s quite simple.

For this post, I’ll add the Description attribute from a computer account.

SCCM 2012 custom active directory attributes

 SCCM 2012 Custom Active Directory attributes Configuration

  • Natiguate to Administration / Hierarchy configuration / Discovery Method
  • Right click Active Directory System Discovery
  • Select the Active Directory Attributes tab
  • Enter or select your attribute from the Available Attributes list
  • If the wanted attribute is not listed, simply click the Custom button and enter it manually
  • Click Add
  • Ensure that your new attribute is listed in the Selected attribute list and click OK. In this example, I’ve added Description attribute.

SCCM 2012 custom active directory attributes

Once completed, initiate a Full Discovery on Active Directory System Discovery by right clicking it and choose Run Full Discovery Now

SCCM 2012 custom active directory attributes

 Validation

Wait for the scan to finish, you can monitor the process by opening adsysdis.log on your site server.

As this is discovery data, the resulting data will be stored in the V_R_System view.

Usage

Collection

With this new data you could create a new collection based on this newly collected data.

  • Create a new collection
  • Add a Query Membership Rule
  • Edit the Query Statement
  • Add a new criteria
  • Click the Select button and select System Resource under Attribute class
  • Select Description under  Attribute
  • Select the desired value (ex: like %SQL% ) and close all windows. This will add all resources having SQL in the description filed
  • Update collection membership and see the result in your collection

SCCM 2012 custom active directory attributes

SCCM 2012 custom active directory attributes

SQL/Report

You can also query this information and include it in your reports.

Select Name0,Description0 
from v_r_system

For my example I’ve run the query on the computer shown in the first screenshot.

SCCM 2012 custom active directory attributes

The description field in SCCM matches the data from Active Directory.

Use the following Technet link to know more about Active Directory system discovery.

10 Comments on “How to add SCCM 2012 Custom Active Directory Attributes”

  1. Hello All,

    It is good we can add the custom attributes to System and User Discovery. What will be the impact on SQL Database after adding this additional data? Schema has to be changed. Sync will take more network BW. Any ideas on this?

  2. Can you please tell me where I can I find the custom attributes in SCCM SQL data base. Which specific view stores the AD attribute values?

  3. Pingback: How To Add User Attributes In Active Directory | Information

  4. Same problem here. description attribute is not available in my SCCM CB 1511. When I add it as a custom attribute it gives me warnings in adsysdis.log “WARN: Failed to get following optional attributes, description”

  5. I find out the correct way, is use the custom button to import a cistom attribute “description”.
    Everything works

  6. Sorry for that question, but in my SCCM 2012 R2 isn’t the attribute description in Active Directory Attributes tab.
    Whats going wrong?

Leave a Reply

Your email address will not be published. Required fields are marked *