Hi,

we need to have the schemas and tables which ADDM discovers also in the CMDB because of different application usage based on schemas.

My start was

mapping from SoftwareInstance_SoftwareServer.softwareinstance as softwareinstance
traverse ElementWithDetail:Detail:Detail:DatabaseDetail where logical_database_type defined as detail
schema -> BMC_DataBaseStorage;
end traverse;

But I don’t know how to access the tables and schemas bacause there are one level deeper as I understand.

Are they any templates which can help me or is there anyone who dealt with this issus before?

I would appreciated any help!

BR

Ramon

Hi,
You have to replace the where clause in the traverse:

For example:
traverse ElementWithDetail:Detail:Detail:DatabaseDetail where type=“SQL Database Schema” or type=“Oracle Tablespace” as detail

Lionel

Guys, I’m also interested in this thing,maid that pattern help?
Thanks in advance, Marco

Hi,

my problem was mostly solved by this pattern

https://kb.bmc.com/infocenter/index?page=content&id=KA370816&actp=search&viewlocale=en_US&searchid=1345194903953