This article provides the database query to find the count of Dataplane reports created by type of report.
\uD83D\uDCD8 Instructions
Login to the Jira instance database. If one requires information about the database, consulting with the database administrator for guidance is recommended.
Run the following Jira database query for a count of Dataplane reports created by type of report.
For non-Postgres 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;For Postgres 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;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)
Example screenshot from the DbVisualizer tool:
