How do I get the tenant name and the tenant id of the Performance Management?

book

Article ID: 191760

calendar_today

Updated On:

Products

CA Infrastructure Management CA Performance Management - Usage and Administration DX NetOps

Issue/Introduction

How do I get the tenant name and the tenant id of the PM?

Environment

Release : 3.7

Component : IM Reporting / Admin / Configuration

Resolution

Directly into the Data Repository Vertica DB:

SELECT 
qn2.qname, 
ai2.attribute_instance_id, 
to_timestamp(ai2.effective_date / 1000 ),
to_timestamp(ai2.insert_date / 1000),    
ai2.string_value AS TenantName,
ai2.item_id as item_id   
FROM dauser.attribute_instance ai2
INNER JOIN dauser.attribute at2 ON ai2.attribute_id = at2.attribute_id
INNER JOIN dauser.qname qn2 ON qn2.qname_id = at2.attribute_qname_id  AND qn2.qname = '{http://im.ca.com/core}Tenant.Name'
ORDER BY ai2.string_value, ai2.item_id ASC;

OR via DataAggregator web address:

http://<DA>:8581/rest/syncabletenant/