Navigation:  Admin Panel > Adapters >

HP Service Manager 7

Previous pageReturn to chapter overviewNext page
Show/Hide Hidden Text

The HP Service Manager adapter can communicate with the HP Service Manager web services. Please check the supported platforms to see which version of Service Manager are supported.



Orb-Blue-Minus-24Manage Fields

The fields that are available for communicating with HPSM7, can be viewed and updated when clicking on this link.


This form gives the possibility to rename web service field names and make them available or not for mapping in SM7 process steps and if the field value should be displayed in detail screens. Use the weight field to set the order of the fields on the detail screens.

Orb-Blue-Minus-24Web Service URL

This is the URL where the WebServices of SM7 can be found. This URL is used to read and write to the Web Services. Example value: http://hostname:13080/SM/7/ws

Orb-Blue-Minus-24WSDL Location path

This URL is used to read the available fields of web services. Example value: http://hostname:13080/SM/7

Orb-Blue-Minus-24Web Service Username

Username of an operator that has read and write access to the Web Services.

Orb-Blue-Minus-24Web Service Password

Password of the username.

Orb-Blue-Minus-24Retry count

Use this setting to define how often SSP7 should try to create an entity in HPSM7. When this value is set to 5, SSP7 will try, in case of failure, for an additional 5 times to create the entity. After 5 attempts the step will show red as failed. While the retry is pending, the step is shown in orange. The time between retries depends on the interval set for the task that manages these retries. For more information on this task, visit the tasks section of this admin guide.

Orb-Blue-Minus-24SCRelation object name

The SCRelation object name must be known to read related items from interactions. By default this object is called screlation.

Orb-Blue-Minus-24Database Connection String

This connection string is used to get direct access to the SM7 database, in order to run the queries defined under SM7 Database User Query and SM7 Database Synchronization query.

For Oracle the connection string format looks like this:
data source=ORCL_TNS;user id=ORCL;password=ORCL;persist security info=false

For Microsoft SQL Service the connection string looks like this:
data source=servername;initial catalog=SMTXSSP7;User ID=SMTXSSP7;Password=SMTXSSP7;persist security info=False;packet size=4096

Orb-Blue-Minus-24Database Type

Select here if Oracle or SQL Server is used as database server.

Orb-Blue-Minus-24SM 7 Database user query

The query defined here is used to map the LDAP username to a contact record in SM7. Please note that this query should retrieve all the fields defined on the User Data tab. The query MUST contain the variable {0}.

In case SM7 authentication or SSP Internal authentication is used, the {0} variable is replaced with the used login name.
When LDAP is used for authentication, the field defined as LDAP unique ID field on the LDAP tab, is used to replace this variable.

This query is executed every time a user logs into SSP and every time a user is selected as the requested for person in a submitted request form.

An example query is:
SELECT c.[FIRST_NAME], c.[LAST_NAME], c.[EMAIL], c.[CONTACT_NAME], m.[FIRST_NAME]+' '+m.[LAST_NAME] ManagerFullname, m.[EMAIL] ManagerEmail, m.[CONTACT_NAME] ManagerContactName FROM [dbo].[CONTCTSM1] AS c LEFT JOIN [dbo].[CONTCTSM1] AS m ON c.[MANAGER] = m.[CONTACT_NAME] where = '{0}'

Orb-Blue-Minus-24SM 7 Database synchronization query

The query defined here is used to synchronize the person information in SSP with the Contacts in SM7. This query should only retrieve the basic user information like first name, last name and Email address. The other user fields defined on the User Data tab, are retrieved by the User Query mentioned above.

This query is executed by the SSP Scheduler application, which is triggered by Tasks. Please refer to the chapter about Tasks to learn more about the scheduler.

Orb-Blue-Minus-24SM 7 Date format

Set here the date format as required by SM7. This setting is used to write date values to SM7.

Example: dd/MM/yyyy

Orb-Blue-Minus-24SM 7 datetime format

Set here the datetime format as required by SM7. This setting is used to write date/time values to SM7.

Example: dd/MM/yyyy hh:mm