search cancel

What options are available for retrieving data out of Spectrum?


Article ID: 190072


Updated On:


CA Spectrum CA eHealth


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


Release : 10.4.1

Component : Spectrum Core / SpectroSERVER


Need to know options for pulling data out of Spectrum


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

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:

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