How to find MemberId and EnterpriseID to use purge utility
Article ID: KB0078842
Updated On:
| Products | Versions |
|---|---|
| TIBCO MDM | - |
Description
MDM is bundled with a datacleanup utility which is a command line utility to delete various objects . More information can be found in the system administrator guide of MDM.
Examples of using purge utility .
datacleanup.bat -o recordversions -a 68990 -rn ALL -d 90 -v 3 -m 20101
Which cleans record versions for all repositories in an enterprise ID 68990 and member ID 20101 with cut off date as 90 days and at least 3 versions prior to cut off date.
But how to retrieve the Member ID and enterprise ID in the above utlity ?
Resolution
To get these details, user needs to have atleast readonly access to MDM database and can run the following query.
select mem.ID from member mem where mem.enterpriseid in ( select ent.ID from enterprise ent where ent.NAME = 'ENTERPRISE_NAME') and mem.username ='admin'
Where mem.ID is the MemberID and ent.ID is the enterprise ID
select mem.ID from member mem where mem.enterpriseid in ( select ent.ID from enterprise ent where ent.NAME = 'ENTERPRISE_NAME') and mem.username ='admin'
Where mem.ID is the MemberID and ent.ID is the enterprise ID
Issue/Introduction
How to find MemberId and EnterpriseID to use purge utility
Additional Information
https://docs.tibco.com/pub/mdm/9.1.0/doc/html/GUID-DDDEDB3C-8E32-48FB-B53B-9E0FF40AB99C.html
Feedback
Yes
No
Powered by
