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) 9.0 or later, 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 Smart IT database (DB).
The following video (4:04 min) will help you configure Smart Reporting as per the steps given in this topic:
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 Related topics.
Running the configuration utility
To configure Smart Reporting settings, the administrator runs the configuration utility.
Configuration.bat -hto display help for running the configuration utility.
Configuration.bat -vto display the utility version.
- You can connect to the Oracle DB by using the SID or the ServiceName.
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.
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 -dbo i -T 000000000000001 -rsh http://009876.calbro.com:8181/ -rsu siadmin -rsp siadmin -rsc bmc
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 = DB Admin User, this is the user which customers use to connect to the SmartIT DB (its usually the Admin user who has access to SmartIT_Business)
dbp = DB Admin password
dbsc = SmartIT DB Schema Name, this the DB Schema where the configuration_Params table exists. This is usually the SmartIT_Business.
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.
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
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.)
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 restart the Smart IT server, the Reports menu is displayed immediately on the Smart IT menu bar.
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
- On the Smart Reporting server, edit the web.xml file located at smartReportinginstallDir/appserver/webapps/ROOT/WEB-INF/.
- Search for CSRFFilter.
In the CSRF filter, add iPhone to the Ignore list.
<param-value>/info.jsp, /info_threads.jsp, /iPhone.i4</param-value>
- Save the file, and start the Smart Reporting service.