CA Client Automation

Hello,

I am aware that the query:

select * from ca_discovered_hardware WHERE dis_hw_uuid IN (select dis_hw_uuid from ca_server where label not in (select label from ca_manager))

will search for and limit the hits to scalability servers. I would like to understand it a little further.

uuid stands for universally unique identifyer. Okay.

hw obviously in this case stands for hardware.

dis points to distribution and somehow it denotes scalability servers?

ca_manager is points to domain managers? What is label exactly?

When you select the server labels that are not managers at the same time you get the scalability servers. Okay.

But I would like to be able to create such queries myself and would need documentation on these terms.

Where do I find documentation that demystifies this language, this code?

I would like get a little smarter in this.

I know select query language. But these are special terms, it seems.

Thank you.

Discovered hardware uuid

Richard Lechner

Principal Engineering Services Architect

CA Technologies

Mobile: +1 703 655 7161 | Richard.Lechner@ca.com

<mailto:Richard.Lechner@ca.com>[CA]<http://www.ca.com/us/default.aspx>[Twitter]<http://twitter.com/CAInc>[Slideshare]<http://www.slideshare.net/cainc>[Facebook]<https://www.facebook.com/CATechnologies>[YouTube]<http://www.youtube.com/user/catechnologies>[LinkedIn]<http://www.linkedin.com/company/1372?goback=.cps_1244823420724_1>[Google]<https://plus.google.com/CATechnologies>[Google+]<http://www.ca.com/us/rss.aspx?intcmp=footernav>

ca_discovered_hardware:

This is all computers (discovered hardware).  The dis_hw_uuid (discovered hardware UUID) is the primary key.

ca_server:

This is all scalability servers.  The list includes the DM, since the DM is also a scalability server by design.  Each record has a server_uuid, and there's a referential column (foreign key) for dis_hw_uuid, to match each server with it's discovered_hardware record in ca_discovered_hardware

ca_manager:

This is all ITCM managers, domain or enterprise.  On a DM, there will be only one record there, for the DM itself.  On an Enterprise, there will be one record for the Enterprise, plus additional records for each DM linked to the Enterprise.

ca_n_tier:

Dual purpose table.  Firstly, it holds the database configuration (connection details) for the ITCM manager.  Additionally if the DM is linked to an Enterprise, there will be a record in there for the Enterprise manager, so the DM can lookup it's database configuration for the purposes of replication.  On an Enterprise, there will be one record for each DM as well, containing the database connection details for each manager.  Including one record for the Enterprise itself.  Also if you have a SQL bridge, there will be a record in the database with the connection details as well.

You can use this website (it's really old) as a guide:

Computer Associates International, Inc. Table List for MDB 1.4 

Recommend you use the "Alphabetic" tab, and lookup by table name.  Just realize this website is 10+ years old, and has not been updated.  But still an excellent reference, nevertheless.

The query you reference:

select * from ca_discovered_hardware WHERE dis_hw_uuid IN (select dis_hw_uuid from ca_server where label not in (select label from ca_manager))

This returns the agent record for every scalability server, filtering out the domain manager from the list.  So all scalability servers, minus the domain manager itself.

Thank you very much. It helped me twice.
However, I tried to open the link to the "Table List for MDB 1.4" and it dit not work (under Firefox). I would have liked to have a  look.