Update password for Servicenow integration using API

maheshtel

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

Find more posts tagged with

snow

integration

npm

Accepted answers

jm_sysadmin

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

tony.johnson

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.

maheshtel

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

All comments

jm_sysadmin

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

tony.johnson

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

maheshtel

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

tony.johnson

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