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:

   The [confluence_table-plus] macro is a standalone macro and it cannot be used inline. Click on this message for details.
   This macro generates standalone content. As a consequence you need to make sure to use a syntax that separates your macro from the content before and after it so that it's on a line by itself. For example in XWiki Syntax 2.0+ this means having 2 newline characters (a.k.a line breaks) separating your macro from the content before and after it.
   

Where to go from here

Running-the-migration-tool.