/
Metrics

Metrics

From this section the Administrator can create Custom Metrics by clicking on the button “New Metric” and filling the following form, providing the Metric Name and Description:

From this section the Administrator can create Custom Metrics clicking on the button “New Metric” and filling the following form, providing the Metric Name and Description.

After the Metric creation, you have to specify the relative Query, by clicking on the Edit button.

Here you can find the Edit Metric Section that shows:

1. General Settings, where you can edit the following Metric parameters:

  • Name: The Metric Name, assigned in the creation form
  • Description: The Metric Description, assigned in the creation form
  • Tables for join: The tables of your database that you want to join for the query

2. Query, where you can define and type your SQL Query:

3. Help, where you can find a list of the Asterisk’s tables columns in the database, really useful to build your own Query

The created Metrics can be used in the Report section, also combined with other queries, to obtain interesting and complex reports.

Examples:

Related content

Using a metric to get the SLA
Using a metric to get the SLA
Read with this
Reports
More like this
V3 Metrics
More like this
Motion DB Tables
Motion DB Tables
More like this
V3 Motion DB Tables
V3 Motion DB Tables
More like this
Create the recordings rating report
Create the recordings rating report
More like this