CA Client Automation

  • 1.  Asset LDAP Distinguished Name in Reporter

    Posted Dec 04, 2017 12:19 PM

    Hi,  I want to create a report from EM that includes asset's LDAP Distinguised Name.   Active Directory LDAP is configured at EM level & DM levels.  

     

    LDAP information seems to be there as Directory [Computer] >AssetDescription from is pulling in data from AD.   Either I can't find DN field from Reporter or not there. 

     

    Thanks, 



  • 2.  Re: Asset LDAP Distinguished Name in Reporter
    Best Answer

    Broadcom Employee
    Posted Dec 06, 2017 12:29 PM

    You need to create a custom directory schema mapping. You can then map one of the

     

    Basic steps:

     

    In the DSM Explorer/control panel/Directory Integration, take the option to add a new directory.

    Follow the Wizard and on step 7 select “Define New mapping”

    Enter a Schema name, then scroll down and select Uniqueuserfields1 and enter “distinguishedName” in the mapping field.

     

     

     

    Click next, flowed by cancel to not create the new directory link.

    Select “Configured Directories” and then right click on your directory and take properties.

    Change the schema name to the one you just created and click OK.

     

     

    Go to you report and add the Directory Synchronization/User-defined/uniqueComputerField1 to your report

     

     

    Run your report and you should now have the DN in your report.

     

     



  • 3.  Re: Asset LDAP Distinguished Name in Reporter

    Posted Dec 06, 2017 10:20 PM

    Thanks Steve,  That worked.  Trick if don't want to kill your directory setup is to configure another directory, define the new schema, then cancel out at last screen of directory configuration wizard.   New schema will be created and can then configure your existing directory to use newly created schema.    

     

    Oddly the distinguishedName seems to be mapped already in assetDN & userDN fields, but not selectable field if Reporter.   Running  this SQL query can see the mapping is defined in default CA AD schema.  

     

    select * from ca_directory_schema_map where dir_schema_map_name = 'CADefaultActiveDirectory'

     

    Also ca_discovered_hardware.directory_url has some data could be useful in queries.