Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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:

Version history
Revision #:
1 of 1
Last update:
‎01-19-2011 01:00 AM
Updated by:
 
Everyone's tags (3)