This documentation supports the 20.02 version of Remedy with Smart IT.

To view an earlier version, select the version from the Product version menu.

Configuring BMC Remedy Smart Reporting in Smart IT

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

Note

Remedy with Smart IT 18.05 and onward 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. For information about the onboarding process in Smart Reporting, see "Onboarding users and importing content in BMC Remedy Smart Reporting" in the Related topics.
Related topics

Onboarding users and importing content in BMC Remedy Smart Reporting Open link

Error rendering macro 'link-window'

Failed to transform the HTML macro template for display. Nested message: The XML content could not be parsed. There is a problem at line 4, column 154. Parser message: Duplicate attribute 'bmc'. at [row,col {unknown-source}]: [4,154]

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.

    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/Service Name

    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 BMC Remedy 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

    Note

    If both the Smart Reporting server and the CCS are configured for a tenant, the Smart Reporting server information is considered for opening BMC Remedy Smart Reporting from 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 IT menu 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.
Was this page helpful? Yes No Submitting... Thank you

Comments

  1. Shekhar Raj

    Is this utility supported to be run using a windows domain DB account? We do not have a SQL authenticated DB user as DB owner of SmartIT_Business.

    Currently with domain DB account, it is giving error Login failed for

    Sep 10, 2020 11:56
    1. Nilay Agambagis

      Hello Shekhar,

      Thanks a lot for your comment.

      You need to set:

      -dbv sql -dbh clm-pun-002598.bmc.com -dbt 1433 -dbs MyITSM;integratedSecurity=true.

      Login with SmartIT schema user on the machine and run utility.

      For more information, please refer to the readme file in the  configuration.zip.

      Regards,

      Nilay Agambagis

      Nov 04, 2020 01:53
  2. Suchin Ramesh baabu

    Would it be possible to mention the parameters that need to configured using the CCS parameters, rather than taking to a whole list of CCS Settings to go through

    Sep 11, 2020 01:22
    1. Nilay Agambagis

      Hello Suchin,

      Thanks a lot for your comment.

      The utility configures Smart Reporting related parameters required for launching Smart Reporting from Smart IT. You need to run the utility to do this and the parameters are configured automatically.

      Regards,

      Nilay Agambagis

      Nov 04, 2020 01:50
  3. Ivan Mastropasqua

    but should I connect automatically with current user in Smart Reporting like happens calling it from Midtier? because from my side Smart Reporting require login and password.

    Dec 02, 2021 03:24
    1. Dhanya Menon

      Hello Ivan,

      Thank you for your comment.

      I will check about this with an SME and revert.

      Regards,

      Dhanya

      Dec 13, 2021 09:39
    1. Dhanya Menon

      Hello Ivan,

      I checked with the SME about your query. Smart Reporting should launch seamlessly after the administrator runs the configuration utility and configures Centralized configuration.

      Please check if all necessary configurations have been performed.

      Thanks,

      Dhanya

      Jan 25, 2022 03:53