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

  1. 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

  2. In the database query panel, run the following queries based on the database type:


Where to go from here

Running-the-migration-tool.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*