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 ?
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 ?
Issue/Introduction
How to find MemberId and EnterpriseID to use purge utility
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
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
