search cancel

What options are available for retrieving data out of Spectrum?

book

Article ID: 190072

calendar_today

Updated On:

Products

CA Spectrum CA eHealth

Issue/Introduction

We have a need to pull data from Spectrum to fill into another database. What options are there?  We would like to use options that do not involve heavy programming, such as WebServices (REST) or command line (CLI).

Environment

Release : 10.4.1

Component : Spectrum Core / SpectroSERVER

Cause

Need to know options for pulling data out of Spectrum

Resolution

1.  The SpectroSERVER - you can use the CLI command line tools to access this data

https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/it-operations-management/spectrum/10-4-1/managing-client-applications/command-line-interface/working-with-command-line-interface.html


This allows you to pull asset type of information.  You can retrieve lists of models, create custom scripts using the commands (etc).  There are some examples of scripts in the $SPECROOT/vnmsh/sample_scripts folder

2.  The event database for the Report Manager - as noted this is a mysql db.  The construct of it is here:

https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/it-operations-management/spectrum/10-4-1/managing-client-applications/report-manager/report-manager-db-schema.html

3.  REST interface - you can use REST queries to pull data from Tomcat:

https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/it-operations-management/spectrum/10-4-1/programming/web-services-api-reference/how-to-use-the-ca-spectrum-web-services-api.html