cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 8

Update password for Servicenow integration using API

Jump to solution

hi,

my customer has a requirement to update service now "web admin" password in NPM on a frequent interval

can this updation of password be done by Orion API/SDK ? 

What are the tables which store the service now instance "username" and "password"?

Can the password be updated via SQL query?

@tdanner  @aLTeReGo @mesverrum @clarv02 @rschroeder 

Kindly confirm

Thanks & Regards

Mahesh

snow integrate.png

Labels (3)
Tags (3)
0 Kudos
3 Solutions

You can find them with most other Orion credentials at:

SELECT ID, Name, Description, CredentialType, CredentialOwner, C.IncidentIntegration.DisplayName, C.IncidentIntegration.Type
FROM Orion.Credential C
Where C.IncidentIntegration.Type like 'ServiceNow'

There are methods to update passwords, so I assume it can be scripted, but I haven't tried it

jm_sysadmin_0-1585661875426.png

 

View solution in original post

We do have a SWIS verb that can edit the credentials: Orion.Credential.UpdateUsernamePasswordCredentials (credId, name, username, password). It requires a Business layer restart to take effect (Orion Module Engine in service manager).

It cannot be done directly on DB, because the password is hashed.

View solution in original post

hi Tony,

 

Thank you for your response.

The service now integration user is a non-orion user.

Will the Orion verb below help update a service now integration user password?

Orion.Credential.UpdateUsernamePasswordCredentials (credId, name, username, password). It requires a Business layer restart to take effect (Orion Module Engine in service manager).

Kindly confirm

thanks

Mahesh

View solution in original post

0 Kudos
4 Replies

You can find them with most other Orion credentials at:

SELECT ID, Name, Description, CredentialType, CredentialOwner, C.IncidentIntegration.DisplayName, C.IncidentIntegration.Type
FROM Orion.Credential C
Where C.IncidentIntegration.Type like 'ServiceNow'

There are methods to update passwords, so I assume it can be scripted, but I haven't tried it

jm_sysadmin_0-1585661875426.png

 

View solution in original post

We do have a SWIS verb that can edit the credentials: Orion.Credential.UpdateUsernamePasswordCredentials (credId, name, username, password). It requires a Business layer restart to take effect (Orion Module Engine in service manager).

It cannot be done directly on DB, because the password is hashed.

View solution in original post

hi Tony,

 

Thank you for your response.

The service now integration user is a non-orion user.

Will the Orion verb below help update a service now integration user password?

Orion.Credential.UpdateUsernamePasswordCredentials (credId, name, username, password). It requires a Business layer restart to take effect (Orion Module Engine in service manager).

Kindly confirm

thanks

Mahesh

View solution in original post

0 Kudos

Yes, If the credential in question is present when running the following query "SELECT  Name, Description, CredentialType, CredentialOwner
FROM Orion.Credential" it can be updated

0 Kudos