cancel
Showing results for 
Search instead for 
Did you mean: 
cancel

How to see which table and RDRs are used for each report

890
Views
0
Helpful
0
Comments

Probably you asked yourself sometimes how to do this, and then tried to find in user guides. Well there is a much easier way to see this.

In the installation directory go to:

(this is an example for version 3.1.5)

C:\Program Files\Cisco SCA\SCA BB Console 3.1.5\plugins\com.cisco.p3.apps.scasbbtemplates_3.1.5.16\templates

there you will have a list of all reports you can see in Reporter on SCA BB Console. If you enter the directory of specific global report, you will find a definition in xml file for each report.

If you open this file (and do not modify it) you will see at the end of xml file something like this:

SELECT

DISTINCT

...

FROM

     RPT_SUR

WHERE

...

GROUP BY

...

ORDER BY

...

Here it is very easy to see that table used for 'Subscriber Bandwidth per Service' report is RPT_SUR.
Now you can check for example by which RDRs this table is populated on this link:
and in the same link description of each RDR:

CreatePlease to create content
Content for Community-Ad

Cisco COVID-19 Survey