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

Update password for Servicenow integration using API

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

 

Product Manager
Product Manager

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.

Level 8

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

0 Kudos
Product Manager
Product Manager

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