Database query to find the count of Dataplane reports created by type of report.

This article provides the database query to find the count of Dataplane reports created by type of report.

 Instructions

1. Login to the Jira instance database.
   Consulting with the database administrator for guidance is recommended if one requires information about the database.

2. Run the following Jira database query for a count of Dataplane reports created by type of report.

3. For non-PostgreSQL databases:-
   
   

   SELECT REPLACE(REPORT_KEY, 'reportKey.', '') as report_type, COUNT(1) as saved_reports FROM AO_6714C7_SAVED_REPORT_RECORD GROUP BY report_type ORDER BY saved_reports DESC;

4. For PostgreSQL databases:

   SELECT REPLACE("REPORT_KEY", 'reportKey.', '') as report_type, COUNT(1) as saved_reports FROM "AO_6714C7_SAVED_REPORT_RECORD" GROUP BY report_type ORDER BY saved_reports DESC;

5. Example output:

   report_type | saved_reports ----------------------------------+--------------- currentIssueValuesReport | 5378 issuesByDateReport | 4871 currentStatSumReport | 2053 pivotTableReport | 2049 historicalSnapshotReport | 1797 issuesTableReport | 1793 projectLinksReport | 1153 timeFromStatusIndirectToStatus | 899 statSumByDateReport | 896 closureTimeReport | 640 issuesEnteringStatusByDateReport | 514 issuesResolvedByDateReport | 514 issuesWorkLogReport | 513 timeInStatusReport | 258 historicalFlowReport | 256 issuesCreatedByDateReport | 256 issueFixVersionsReport | 128 issueComponentsReport | 128 workLoggedByDateReport | 3 issueReportersReport | 2 issuePrioritiesReport | 1 (21 rows)

6. Example screenshot from a third-party DB tool, DbVisualizer tool:
   
   

   Open