DX NetOps

  • 1.  Spectrum - How to get attribute value from database?

    Posted Jun 05, 2018 04:35 PM

    Hi,

     

    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.

     

     

     

    Tks,

    Márcio



  • 2.  Re: Spectrum - How to get attribute value from database?
    Best Answer

    Posted Jun 05, 2018 04:40 PM

    REST, CLI or the development API.

     

    https://docops.ca.com/ca-spectrum/10-2-3/en/programming 



  • 3.  Re: Spectrum - How to get attribute value from database?

    Posted Jun 05, 2018 05:48 PM

    Hi Joseph, do you know which table stores attribute values?



  • 4.  Re: Spectrum - How to get attribute value from database?

    Posted Jun 06, 2018 04:39 AM

    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. 



  • 5.  Re: Spectrum - How to get attribute value from database?

    Posted Dec 13, 2018 01:54 AM

    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.

    AK



  • 6.  Re: Spectrum - How to get attribute value from database?

    Posted Dec 13, 2018 01:22 PM

    AK,

     

    CLI does retrieve the information from the Berkley (SpectroSERVER) DB.

     

    Joe



  • 7.  Re: Spectrum - How to get attribute value from database?

    Posted Dec 13, 2018 01:29 PM

    What specific information are you trying to retrieve?



  • 8.  Re: Spectrum - How to get attribute value from database?

    Posted Dec 14, 2018 05:38 AM

    Dear Joseph,

     

    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.

     

    Regards,

    AK



  • 9.  Re: Spectrum - How to get attribute value from database?

    Posted Dec 14, 2018 08:24 AM

    AK,

     

    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=0x3d0002
    Id String Value
    0x11ee8 Unknown 0
    0x11ee8 Other 1
    0x11ee8 Switch 2
    0x11ee8 Router 3
    0x11ee8 Switch-Router 4
    0x11ee8 Hub 5
    0x11ee8 Link 7
    0x11ee8 Network 8
    0x11ee8 Workstation-Server 9
    0x11ee8 Container a
    0x11ee8 Chassis b
    0x11ee8 Pingable c
    0x11ee8 MAC d
    0x11ee8 SNMP e
    0x11ee8 Port f
    0x11ee8 User 10
    0x11ee8 Application 11
    0x11ee8 Component 12
    0x11ee8 Landscape 13
    0x11ee8 Router Application 14
    0x11ee8 Switch Application 15

    .

    .

    .

    .

     

    Joe



  • 10.  Re: Spectrum - How to get attribute value from database?

    Posted Dec 18, 2018 01:44 AM

    Thanks Joseph. It really helped.

     

    Regards,

    AK



  • 11.  Re: Spectrum - How to get attribute value from database?

    Posted Dec 18, 2018 07:23 AM

    Glad I could help.

     

    Joe