This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.
MyIT Digital Workplace
SmartIT 2.0 and older / MyIT 18.02 and older (bundle) For DWP 18.05 and beyond, use KA 000169175 SmartIT 18.05 and beyond
How to change AR server references in SmartIT / MyIT Application?
How to Update (encrypt) the password within SmartIT /MyIT database?
How to change SmartIT DB reference?
1) Login onto Remedy with a MyIT/SmartIT Admin user.
Step1 : Application -> BMC MyIT administration -> MyIT administration console -> Persistent Data Stores -> click on the AR server that is currently being used.
Step2 : Modify the host_name , Provide Port Number , Admin Password(provide remedy application service password) , DataStore type(Select AR Server)
Click on the application tab and do the same for rest of the three applications - BMC MyIT / MyIT-ITSM /MyIT HRCM and save the information. Make sure 'enabled' is set to Yes
**Post 18.05 This change should be done in the SMT:Administration Console form**
2) Login with the SmartIT Database.
These steps apply for
- Any SmartIT -any version from 18.05 (stand alone SmartIT) and beyond.
- Any SmartIT that is bundled with MyIT and prior.
- For DWP 18.05 and beyond, follow KA 000169175
Step1 : go to the Table - 'Configuration Parameter' with the Schema 'SmartIT_System'
Run the following query:
SELECT * FROM [SmartIT].[SmartIT_System].[CONFIGURATION_PARAMETER]
Step2 : Execute the Update query to update HostName:
UPDATE [SmartIT].[SmartIT_System].[CONFIGURATION_PARAMETER] SET Value = 'Server_Name' Where Name='connect.arsystem.hostName'
Step3 : If the password has changed then password has to be encrypted. for this you have to use SmartIT Manteinance Tool
<SmartIT Installdirectory>/SmartIT/SmartITMaintTool/SmartIT Maintenance Tool/
Execute the Update query to update password information:
UPDATE [SmartIT].[SmartIT_System].[CONFIGURATION_PARAMETER] SET Value = 'encrypted password' Where Name='connect.arsystem.password'
Step4 : Execute the Update query to update Port information
UPDATE [SmartIT].[SmartIT_System].[CONFIGURATION_PARAMETER] SET Value = '0' Where Name='connect.arsystem.port'
Step5 : Restart Application's Tomcat
Change SmartIT DB reference:
If you want to change smartIT DB reference then it has to be done in smartIT.xml file:
The smartit.xml file located at <SmartIT_Tomcat_Install_Dir>\conf\Catalina\localhost contains references to the JDBC connection to the SmartIT_System and SmartIT_Business schemas.
The following example is from a system connecting to MS SQL Server database: url=jdbc:jtds:sqlserver://mydbserver-011:1433/SmartIT