Database table that stores system details of a record
Article ID: KB0078635
Updated On:
| Products | Versions |
|---|---|
| TIBCO MDM | 9.0.1 and 9.1.0 |
Description
Where can we find system details of a record like Last Confirmed Version, Owner, Checksum, Active, Modified by, Version Number in backend/database table?
Issue/Introduction
Database-table-that-stores-system-details-of-a-record
Environment
All
Resolution
The system details of a record can be viewed from PRINCIPALKEY table of MDM database. Please find below the query.
select TOP 1 * from PRINCIPALKEY where PRODUCTKEYID = (select ID from PRODUCTKEY where NAME='Record id of the Record for which you want the system details') order by LASTCONFIRMEDVERSION desc
For example : select TOP 1 * from PRINCIPALKEY where PRODUCTKEYID = (select ID from PRODUCTKEY where NAME='34494') order by LASTCONFIRMEDVERSION desc
The above query returns the latest confirmed version record. Please run the below query for all the record versions.
select * from PRINCIPALKEY where PRODUCTKEYID = (select ID from PRODUCTKEY where NAME='34494')
select TOP 1 * from PRINCIPALKEY where PRODUCTKEYID = (select ID from PRODUCTKEY where NAME='Record id of the Record for which you want the system details') order by LASTCONFIRMEDVERSION desc
For example : select TOP 1 * from PRINCIPALKEY where PRODUCTKEYID = (select ID from PRODUCTKEY where NAME='34494') order by LASTCONFIRMEDVERSION desc
The above query returns the latest confirmed version record. Please run the below query for all the record versions.
select * from PRINCIPALKEY where PRODUCTKEYID = (select ID from PRODUCTKEY where NAME='34494')
Feedback
Yes
No
Powered by
