DX NetOps

Expand all | Collapse all

Latitude and Longitude of device - Spectrum

Jump to Best Answer
  • 1.  Latitude and Longitude of device - Spectrum

    Posted 11-21-2019 12:11 AM
    Dear Team

    Can you please help me on how to fetch the latitude and longitude of the devices along with the status of the device from CA spectrum database

    Need some query to get this information

    Thanks for all the help



  • 2.  RE: Latitude and Longitude of device - Spectrum
    Best Answer

    Posted 11-21-2019 02:15 AM
    Latitude and longitude are not OOTB attributes available in Spectrum.

    If these are custom attributes set on your system, you should identify the attribute handles. There are at least 2 possibilities for identifying the attribute id for an attribute:
    - using CLI (https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/it-operations-management/spectrum/10-4/managing-client-applications/command-line-interface.html) with combination of "show models" and  "show attributes".
    - using OneClick Console. Under Component Detail Panel, there's a section "Attributes" where you can see all the attributes defined (including attribute id) for the selected model and all their values.

    Once you established the attribute handles for all required attributes, you can get the information from the SSdb using either CLI (https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/it-operations-management/spectrum/10-4/managing-client-applications/command-line-interface/sample-scripts.html) or Restful API (https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/it-operations-management/spectrum/10-4/programming/web-services-api-reference/java-code-and-xml-examples.html).

    Senior Consultant
    SolvIT Networks