Tariscope 4.x. Administrator's guide
Chapter 3. Tariscope configuration
3.21. Monitoring changes in the database tables
Tariscope can monitor changes in any table of the Tariscope database. To do this, you must determine which of the tables in the database you want to monitor and select the Change monitoring configuration page. The Tariscope window will be as shown in Figure 3.21.1.
Figure 3.21.1
A list of all tables, their purpose and description are given in the document "Tariscope 4.x Database schema".
Typically, Tariscope administrators are interested the following tables: subscribers, rate plans and rates.
Do not recommend to set monitoring on the tables of calls or IP traffic, since adding each call records (IP traffic data) will be monitored by that will lead to a substantial increase of the log of monitoring and increase the load on the processor.
The monitoring log is stored in the History table of the Tariscope database. The Change monitoring page displays only the last 1000 entries in this log, although the log contains all the data. If you need to search information across the entire History table, create the appropriate report form or use Microsoft SQL Server Management Studio. You can clear this table the same ways.
The right part of the window (Figure 3.21.1) the table is displayed that contains a list of events associated with changes of tracked database tables. When you initially enter this mode, this table will be empty.
To set the monitoring, click on the Install audit trigger for table icon on the toolbar. A window appears where you should enter a table name you need to monitor. Then click OK.
Repeat these actions for all tables you want to monitor.
