Is there any option available to find the contacts imported via pdm_ldap_import into SDM?

Document ID : KB000009744
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

How can the contacts imported from LDAP, via pdm_ldap_import, be identified?

Background:

In an environment where Service Desk is integrated with LDAP, there could be the need to identify the contacts that have been imported via pdm_ldap_import.

Environment:
CA Service Desk Manager 12.9CA Service Desk Manager 14.1
Instructions:

The 'creation user' column in ca_contact table could be a good reference to use.

If the contact has been created via Web Interface, the 'creation_user' column will have the value of the 'userid' of the user, connected to the Web Interface, who created the contact. 

The above is valid when the contact is created via Web Interface using: 'New Contact ...' and 'New Contact from LDAP ...'

The 'creation_user' column contains a NULL value when the contact is created automatically during the installation phase.

If instead the contact has been imported via pdm_ldap_import functionality, the 'creation_user' column has an empty value.

It is always better to verify directly in the environment what is the behavior and what is the value of column 'creation_user' when a new user is imported via pdm_ldap_import.