Assessing the BMC Helix ITSM: Smart Reporting environment
As a database administrator, before migrating the reports to BMC Helix Dashboards, assess the BMC Helix ITSM: Smart Reporting environment to count the total number of reports, the total number of private and public reports, and so on.
You can run a set of SQL queries in the Smart Reporting database to collect various metrics. If you are unable to access the Smart Reporting database, as a BMC Helix ITSM: Smart Reporting SaaS user, use Advanced Authoring to access the Smart Reporting database. For more information, see How to get a list of reports for the Conversion Tool with Advanced Authoring.
Sample queries to collect metrics
- Log in to the BMC Helix ITSM: Smart Reporting database by providing the following details:
- Database type
- Database hostname
- Database instance
- Database port
- Database name
- Database username
- Database user's password
In the database query panel, run the following queries based on the database type:
The [confluence_table-plus] macro is a standalone macro and it cannot be used inline.
Where to go from here