V_PIM_CRED_DETAILS_DB_RSRC view
This view shows the details of credentials that are checked in and checked out for the database resource type.
Note: This view does not follow the First Normal Form.
| Column | Description | "" |
|---|---|---|
| L_DN | Credential distinguished name in data store. | No |
| ACCOUNT_UID | Credential user name. | No |
| USE_GLOBAL_SETTINGS | Whether the credential uses global settings or its own custom settings. | No |
| IS_EXCLUSIVE | Whether or not an entitled user has to check out this credential to see its password. | No |
| RESET_PASSWORD | Whether or not the credential password will be reset when it is checked in (for exclusive credentials only). | Yes |
| PWD_ROTATION_INTERVAL | Number of days between automatic password resets. | Yes |
| PSWD_LAST_CHANGED | Time when the credential password was last reset. | Yes |
| CREDENTIAL_TAG | One of the credential's tags, if any. | Yes |
| L_RESOURCE_DN | Credential resource distinguished name. | No |
| RESOURCE_UID | Credential resource unique ID. | No |
| RESOURCE_NAME | Credential resource name. | No |
| RESOURCE_TYPE | Credential resource type: "winad", "winlocal", "database", or "" (generic). | No |
| DB_IP_ADDRESS | Database IP address. | No |
| DB_PORT | Database port. | No |
| DB_TYPE | Database type. | No |
| DB_HOST_NAME | Database host name. | Yes |
| RESOURCE_ALIAS | One of the credential resource's aliases, if any. | Yes |
| RESOURCE_TAGS | One of the credential resource's tags, if any. | Yes |
| ERLESSEENAME | User name of the person that is currently using the credential. | Yes |
| ERLEASEEXPIRATIONTIME | Time when the current lease expires. | Yes |
| ERJUSTIFICATION | Justification for the current usage of the credential. | Yes |
| ERLEASESTATUS | Status of the current lease. | Yes |
| L_BU_DN | Distinguished name of the organization container where the credential is in. | No |
| BU_NAME | Name of the organization container (e.g. admin domain) where the credential is in. | No |
| LEASE_DN | Distinguished name of the current lease. | Yes |
| LESSEE_DN | Distinguished name of the user who is currently using the credential. | Yes |