Is there any way to get attribute value from database? There is no info about attributes on db schema.
I'm able to get them through REST and CLI, however, another team would like get it from database.
REST, CLI or the development API.
Hi Joseph, do you know which table stores attribute values?
There are no tables. SpectroSERVER database (the one that contains all the attributes for all existing model) is Berkeley Db. The only way to get information out is the way that Joe just mentioned.
Dear Marcio and Josephs.
This was informational. I do see some information related to CLI usage in the docops, but I need to see the data from Berkley DB from the specific table.
Is it possible for any of you to share the specifics on how to use the CLI to retrieve information from the Berkley DB?
Thanks in Advance.
CLI does retrieve the information from the Berkley (SpectroSERVER) DB.
What specific information are you trying to retrieve?
I am looking for all the information about all the distinct Model Class, which is present in the DB.
For example :
Model Class = X where X is a numeric value and represents Switch/Router/Firewall or any other network type.
We are in need of this information.
The Model_Class attribute id 0x11ee8 is an enumerated integer. For that you would use the "show enumerations" CLI command show - Displays Object - CA Spectrum - 10.3 - CA Technologies Documentation
For example, I ran the following command where mth=0x3d0002 is the GnSNMPDev model type:
./show enumerations attr=0x11ee8 mth=0x3d0002
The following is a sample of the output:
./show enumerations attr=0x11ee8 mth=0x3d0002Id String Value0x11ee8 Unknown 00x11ee8 Other 10x11ee8 Switch 20x11ee8 Router 30x11ee8 Switch-Router 40x11ee8 Hub 50x11ee8 Link 70x11ee8 Network 80x11ee8 Workstation-Server 90x11ee8 Container a0x11ee8 Chassis b0x11ee8 Pingable c0x11ee8 MAC d0x11ee8 SNMP e0x11ee8 Port f0x11ee8 User 100x11ee8 Application 110x11ee8 Component 120x11ee8 Landscape 130x11ee8 Router Application 140x11ee8 Switch Application 15
Thanks Joseph. It really helped.
Glad I could help.
Retrieving data ...