Cisco-Prime 2.1

[thusharadennis]

Dear Experts,

What is the database schema and the table format  which is used in cisco prime 2.1 for storing the logs.

•       Which table/views Live Events are storing/inserting in cisco prime database

-Hostname/Asset Name

-Alert/Alarm Description

-Alert Title

-Domain {SERVER, NETWORK, MSSQL, ORACLE…}

-Mon parameter {CPU, Memory, HDD, Availability, Services,Router, Processes….}

-Alert Type {Down, Threshold, UP}

-Alert Severity {High, Medium, Low, Information, Critical}

Reagrds

TD

[Marvin Rhoads]

PI uses Oracle to store the received syslog messages (and many other things).

Cisco no longer supports querying the db directly and instead offers a REST API for querying PI programmatically. Because of this, the database schema and table format are not published.

You can see the REST API and in particular the bit for querying syslog info is found on your PI server as follows:

https://<your server name or address>/webacs/api/v1/data/Syslogs?_docs

(filling in your server name in the URL).