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?
Thanks & Regards
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
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.
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).
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
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process. Learn more today by joining now.