This documentation supports the 22.1 version of BMC Helix ITSM: Smart IT. To view an earlier version, select the version from the Product version menu.The documentation for BMC Helix ITSM 23.3.00 has changed. To understand the changed documentation structure see, Where did the Smart IT documentation go?

Configuring Smart Reporting in Smart IT

If BMC Helix ITSM: Smart IT is installed on BMC Helix ITSM, universal client users can access BMC Helix ITSM: Smart Reporting (Smart Reporting) from Smart IT. To do so, the administrator must configure Smart Reporting in the Centralized-configuration.

Note

Smart IT 18.05 and later versions are a single tenant application.

Before you begin

The administrator must first ensure the following:

  • The Smart Reporting server or the Centralized Configuration server (CCS) that is configured with the Smart Reporting server is available.
  • Smart IT users who will access Smart Reporting from Smart IT must be onboarded to the Smart Reporting server. 
  • While integrating Smart Reporting with Smart IT application, if you use Windows authentication on Smart IT database, make sure to set integratedSecurity=true. For more information and example, refer to the readme.txt file available inside the utility folder.

Related topics

Onboarding

Configuring Mid Tier to access Smart Reporting

Centralized-configuration

To run the configuration utility

To configure Smart Reporting settings, the administrator runs the configuration utility.

Notes

  • Run Configuration.bat -h to display help for running the configuration utility.
  • Run Configuration.bat -v to display the utility version.
  • You can connect to the Oracle DB by using the SID or the ServiceName.
  1. Extract configuration.zip from the SmartIT/SmartITonboardingTool folder, to a folder on the Smart IT server (for example, c:\utility\). 
    For more information, see the readme file in the configuration.zip file.

  2. Provide the Smart IT DB and Smart Reporting server information, and run configuration.bat.

    Example: Run the following command to configure Smart Reporting parameters.
    c:\utility\configuration.bat -dbv oracle -dbh 009876.calbro.com -dbt 1521 -dbs UNIVERSE -dbu system -dbsc MyITSM_BUSINESS -dbp dbpassword -T 000000000000001 -rsh http://009876.calbro.com:8181/SmartReporting -rsu siadmin -rsp siadmin -rsc bmc -garh svr-cal-007878 -gart 0 -garu Demo -garp demo

    In this example, the following definitions apply:

    dbv = SmartIT DB vendor (sql/oracle)

    dbh = SmartIT DB host name

    dbt = SmartIT DB TCP port 

    dbs = SmartIT DB SID/ServiceName

    dbu = SmartIT_System user name (Available in <tomcat>/conf/Catalina/localhost/smartit.xml file)

    dbp = SmartIT_System password (Available in <tomcat>/conf/Catalina/localhost/smartit.xml file)

    dbsc = Smart IT System DB schema name 

    T = Tenant ID (the default value is 000000000000001)

    rsh = Report server URL

    rsu = Report server Admin user, this is the admin user of Smart Reporting, usually the siadmin.

    rsp = Report server Admin password

    rsc = Report server Customer Name, this is the customer name against which the Smart Reporting users are onboarded.

    garh = Common AR host

    gart = Common AR Port

    garu = Common AR Admin User

    garp = Common AR Admin Password


    If the CCS is configured and Smart Reporting information is present in the CCS (in Mid Tier, you can configure Smart Reporting and CCS. You can use CCS information for a tenant instead of the Smart Reporting server information, for example: 

    c:\utility\configuration.bat -dbv sql -dbh 009988.calbro.com -dbt 1433 -dbs MyITSM -dbu sa -dbsc MyITSM_BUSINESS -dbp dbpassword9 -ccsh svr-cal-007878 -ccsu Allen -ccsp password -ccst 0 -ccsc bmc -garh svr-cal-007878 -gart 0 -garu Demo -garp demo

    In this example, the following definitions apply:

    ccsh = Centralized Configuration server host

    ccsu = Centralized Configuration server Admin user

    ccsp = Centralized Configuration server Admin password

    ccst = Centralized Configuration server TCP port

    ccsc = Centralized Configuration server cluster ID (if multiple tenants exist, each tenant name must be passed.)

    garh = Common AR host

    gart = Common AR Port

    garu = Common AR Admin User

    garp = Common AR Admin Password

    For more information, see Configuring Mid Tier to access Smart Reporting and Onboarding a new tenant.

    Note

    If both the Smart Reporting server and the CCS are configured for a tenant, the Smart Reporting server information is considered for opening Smart Reportingfrom Smart IT.

    The configuration utility generates a log file in the format configuration_yyyymmdd_currenttime.log (for example, configuration_2015714_1436877229476.log) in the same folder. A message confirming successful execution is displayed on the console.

    Thirty minutes after successful configuration, the Reports menu is displayed on the Smart IT menu bar. Similarly, any configuration activity involving adding, removing, or updating the Smart Reporting server or CCS is reflected in Smart IT after 30 minutes. If the information does not appear within that time frame, clear the browser cache and log on to Smart IT. If you configure Smart Reporting in Smart IT by providing CCS info or Smart Reporting info at the time of tenant onboarding, or if you refresh the Smart IT server cache, the Reports menu is displayed immediately on the Smart ITmenu bar.

  3. To access Smart Reporting, click Reports.

Additional configuration for iOS

After you have successfully run the configuration utility, complete the following configuration if you are going to use Smart Reporting on the iOS platform

  1. On the Smart Reporting server, edit the web.xml file located at smartReportinginstallDir/appserver/webapps/ROOT/WEB-INF/.
  2. Search for CSRFFilter.

  3. In the CSRF filter, add iPhone to the Ignore list.

    <filter>
           <filter-name>CSRFFilter</filter-name>
          <filter-class>com.hof.servlet.CSRFFilter</filter-class>  <init-param>
              <param-name>AllowedEntry</param-name>         <param-value>/logout.jsp,/reporting_custom_index.jsp,/SmartReporingHeader.jsp</param-value>  </init-param> <init-param>
              <param-name>Ignore</param-name>
            <param-value>/info.jsp, /info_threads.jsp, /iPhone.i4</param-value>
      </init-param>

  4. Save the file, and start the Smart Reporting service.

 

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