ServiceGrid Article - Report Database
The Report Database is a dedicated database with direct access for your Reporting tool where you can process the data outside the ServiceGrid environment.
A dedicated reporting database can be provided for one or multiple companies. This reporting database consists of a flat ticket table with about 600 fields. This table contains all ticket and ticket history records of the assigned companies.
As far as the setup for your company is ready and you receive the access data (URL, Username, and Password), you are able to connect to your report database using the standard encrypted PostgreSQL connection protocol which means you can connect through ODBC, JDBC or others.
In your report database, all tickets are available, which were created or updated after your report database setup was created. The replication of the ticket data from the production in to the report database is almost real-time.
Both the ticket and ticket history are stored in this table. To distinguish between these kinds of records, the field recordtype is implemented. For each ticket, one record with recordtype=’c’ exists and an arbitrary number of history record with recordtype=’h’ exists.
Please send a service request to the Cisco ServiceGrid Support Team to enable the Report Database.
NOTE: Private Cloud customers might need another server-instance for the Report Database depending on their Server hardware capacities.
The ServiceGrid team will setup your Report Database and hand over the access data (URL, Username and Password) to you. You can retrieve your real-time ticket data directly into your tool after you have setup the access data in it.
Starting release 7.3, in addition to the ticket table, a new table “activities” has been created for storing the ticket activities in the Reporting Database. This table can be used to create reports based on the entity “activities”.
For a complete list of Cisco ServiceGrid Articles, go to the List of Articles page.