Hi , I am trying to know more about CA Spectrum. So looking for some detailed information.
What is the database/table names where topology related information is stored in CA Spectrum?
I do know that MySQL database named 'reporting' is present to do generate reports, but is this the table where topology related information is also stored.
This table might be not accessible from outside ,but atleast information relation to schema or structure of the table should be mentioned somewhere.
I am trying to understand that the table fields present in SpectroServer are similar to reporting or they are different.
You have to understand that the core part of Spectrum was coded in the late 1980s and is still being used today. This is why we use the Berkley Sleepycat database and why Spectrum is so different then other NMS programs.
So as I have mentioned you have the topologys that are based upon X, Y coordinates, you can use the relations to see how the devices are connected to each other.
Relation Descriptions - CA Spectrum - 10.3 - CA Technologies Documentation
You can use Topology Model Name String attribute to see how the device relates to the Universe and its Parent containers.
The relations can be queried via CLI or Java Webservices, but again as previously mentioned there is no direct database that manages all of the topology.
Another option is to export the topology via images as explained here.
Export Topology Views as Image Files - CA Spectrum - 10.3 - CA Technologies Documentation
The models are stored in the SSdb (Berkeley database).
Please take a look at these CA Spectrum guides:
SpectroSERVER and CA Spectrum Databases Overview - CA Spectrum - 10.3 - CA Technologies Documentation
Report Manager DB Schema - CA Spectrum - 10.3 - CA Technologies Documentation
Also, to add, accessing/editing the SSdb is not recommended, could corrupt it.
Topology is a visual representation of how the network is connected. So the field that would be included would be model handle, model class and model type to represent the model, x , y coordinates to represent the location, topology model name string to see how many containers deep the model is located and the relations and associations of the model to see how it is connected to the other model.
Security String isn´t used in topology except Security Strings will always roll down, meaning the child objects will inherit the parents security strings.
The reporting database does have some information such as model information and containers but these are used more for reporting purposes for assets and availability and will not contain topology information.
We do publish the schema for SRMDBAPI so you can see what is included but we do not include specific topology information such as relations, associations or x,y coordinates.
You can always use the Modeling Gateway to export the topology. There is an option in the .modelinggatewayresource.xml file to export topology with X , Y Coordinates for placement.
<!-- export_topology_layout: export devices and containers --><!-- x,y coordinates or not -->
Thanks for your patience and detailed information. I have a better understanding of the Berkley DB respective to topology and how the topology can be retrieved.
I have pulled some parts from the xml file as per the steps mentioned in the documentation.
<Topology topology_layout="" zoom_list="" group_list="" model_handle=""> <Topology_Container name="Location_Z" model_type="Network" model_handle="00000000" subnet_list="0.0.0.0" group_list="0.0.0.0.0.0.0.0" topology_layout="" zoom_list="" Security_String="String" annotation="" Value_When_Orange="3" Value_When_Yellow="1" subnet_mask="0.0.0.0" Value_When_Red="7"> <Device network_address="10.10.10.10" name="abc.company.com" model_type="GnSNMPDev" model_handle="00000000" Topology_Relocate_Model="0" TryCount="3" TimeOut="3000" Security_String="String" Hibernate_Device="1" Value_When_Orange="3" Criticality="1" Value_When_Yellow="1" poll_status="1" DeviceMemoryUtilization_Duration="300" Value_When_Red="7" DeviceCPUUtilization_Duration="300" Method_Model_Name="1" Disable_Trap_Events="0" Auto_Reconfigure_Interfaces="1" Generate_Redundancy_Alarms="1" Enable_Spectrum_Management="1" agent_port="161" Discover_Connection_After_Linkup_Trap="0" community_string="test" Device_Discovery_After_Reconfiguration="0" mdl_creat_athr="something@something" Redundancy_Admin_Status="0" poll_interval="180" mdl_creat_method="2" DeviceCPUUtilization_Threshold="85" Enable_Event_Creation="1" DeviceCPUUtilization_Reset="70" DeviceMemoryUtilization_Threshold="85" Create_Sub_Interfaces="1" DeviceMemoryUtilization_Reset="70" x_coordinate="1199" y_coordinate="842" />
Are these are different fields respective to topology? Do they have any connection with "reporting" database ,because I see some of the fields mentioned above are present in the "reporting" database as well for example security_string ?
Thanks for the info Silvio. I have gone through the link shared. Can you highlight which table schema is related to topology. I do not see any table for that purpose.
Thanks SIRHA02. I am not trying to access SSdb. I am just looking for information about the table schema where topology related information is stored.
That perfectly clarifies my query .
Appreciate your quick response and the provided information is useful for me.
Do you have the table or table schema name which stores all the information related to topology?
There are number of tables in the Spectrum respective databases and I am aware of the tables present as well, but could not find the tables which are associated with the topology related information.
The SSdb is not a RDBMS, it's doesn't have tables/views/columns. There are other methods to access it - the CLI/Rest APIs, or , as Glenn_Shoemake mentioned, you can export the topology data in XML format via Modelling Gateway.
An older post which might also help you:
More container info
Thanks Cristi for the clarification.