SMA reports
There are multiple reports available via SMA. Can please help to check if my understanding regarding these are correct and is there a way to get these reports through some OOTB tables or such.
Database Class Report - System-wide
Database Name Report - System-wide
Database Table Report - System-wide
Lookup List Size Report - node-specific
Lock Report - System-wide
Declarative Report - ?
Localization Cache Report - ?
***Edited by moderator, Maryrita: moved to Product Support from Applications***
Accepted Solution
EPAM Systems, Inc.
ES
Hi Amit,
The Database Class Report gives you information about each PRPC class known to the system. For each class, this includes:
- the class's ancestor chain;
- the SQL which the system uses to open, save, and delete instances of the class;
- and a listing of the class's column-to-property mappings.
This report will contain every class in the system, but some of the columns in the report might not be populated, as PRPC does not figure out certain pieces of information for a class until that information is needed.
The Database Name Report gives you information about each database (Data-Admin-DB-Name) known to the system, including the names and versions of the database and the database drivers.
All of the databases should be listed here, but some of the information for each database might not be populated until the database is first used.
The Database Table Report gives you information about all of the database tables known to PRPC. In particular, there is one row for every column for every table. Information includes the column's table's schema and the type of the column.
The information in this report might not be complete, in that the information for a particular table is calculated only when that table is first used.
Hi Amit,
The Database Class Report gives you information about each PRPC class known to the system. For each class, this includes:
- the class's ancestor chain;
- the SQL which the system uses to open, save, and delete instances of the class;
- and a listing of the class's column-to-property mappings.
This report will contain every class in the system, but some of the columns in the report might not be populated, as PRPC does not figure out certain pieces of information for a class until that information is needed.
The Database Name Report gives you information about each database (Data-Admin-DB-Name) known to the system, including the names and versions of the database and the database drivers.
All of the databases should be listed here, but some of the information for each database might not be populated until the database is first used.
The Database Table Report gives you information about all of the database tables known to PRPC. In particular, there is one row for every column for every table. Information includes the column's table's schema and the type of the column.
The information in this report might not be complete, in that the information for a particular table is calculated only when that table is first used.
Kindly refer to this link, it contains all the reference guides of SMA for different Pega version.
https://collaborate.pega.com/discussion/configure-system-management-application-sma
Kindly notify if it helps and assist in understanding the concept behind.
Regards,
Asif
IN
Hi Amith,
As stated, from SMA, Please follow these steps to get the required reports.
SMA --> Node --> Advance Tab --> Reports and download respectively.
- Database Class Report
- Database Name Report
- Database Table Report etc.
With regard to the getting these table from OOTB, let me take a look and come back to you soon.
Accepted Solution
EPAM Systems, Inc.
ES
Hi Amit,
The Database Class Report gives you information about each PRPC class known to the system. For each class, this includes:
- the class's ancestor chain;
- the SQL which the system uses to open, save, and delete instances of the class;
- and a listing of the class's column-to-property mappings.
This report will contain every class in the system, but some of the columns in the report might not be populated, as PRPC does not figure out certain pieces of information for a class until that information is needed.
The Database Name Report gives you information about each database (Data-Admin-DB-Name) known to the system, including the names and versions of the database and the database drivers.
All of the databases should be listed here, but some of the information for each database might not be populated until the database is first used.
The Database Table Report gives you information about all of the database tables known to PRPC. In particular, there is one row for every column for every table. Information includes the column's table's schema and the type of the column.
The information in this report might not be complete, in that the information for a particular table is calculated only when that table is first used.
Hi Amit,
The Database Class Report gives you information about each PRPC class known to the system. For each class, this includes:
- the class's ancestor chain;
- the SQL which the system uses to open, save, and delete instances of the class;
- and a listing of the class's column-to-property mappings.
This report will contain every class in the system, but some of the columns in the report might not be populated, as PRPC does not figure out certain pieces of information for a class until that information is needed.
The Database Name Report gives you information about each database (Data-Admin-DB-Name) known to the system, including the names and versions of the database and the database drivers.
All of the databases should be listed here, but some of the information for each database might not be populated until the database is first used.
The Database Table Report gives you information about all of the database tables known to PRPC. In particular, there is one row for every column for every table. Information includes the column's table's schema and the type of the column.
The information in this report might not be complete, in that the information for a particular table is calculated only when that table is first used.
Kindly refer to this link, it contains all the reference guides of SMA for different Pega version.
https://collaborate.pega.com/discussion/configure-system-management-application-sma
Kindly notify if it helps and assist in understanding the concept behind.
Regards,
Asif