Latitude and Longitude of device - Spectrum

[Santhosh B]

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

cheers

Santhosh

[Catalin Farcasanu]

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
------------------------------