Network Management
How to track actions assigned to a Windows credential in the SolarWinds Platform
Use Database Manager to identify the action records linked to a Windows credential when the Manage Windows Credentials page shows assigned actions but does not display their names.
First published date
Last published date
Overview
This article explains how to identify which actions are assigned to a specific Windows credential in the SolarWinds Platform. In some cases, the Manage Windows Credentials page shows that a credential is assigned to one or more actions, but it does not display the specific action details in the user interface. This article explains how to use Database Manager to locate the related action records so you can identify where the credential is being used before updating, replacing, or removing it.
Product section
Resolution
- Connect to the SolarWinds Platform server.
- Open Database Manager from the SolarWinds Platform folder of the start menu.
- Select Add Orion Server, then expand the SQL server in bold.
- Right-click the SolarWinds Platform database and select New Query.
- Paste the following and select Execute query to get the Windows Credential ID:
-- Scripts are not supported under any SolarWinds support program or service.
-- Scripts are provided AS IS without warranty of any kind. SolarWinds further
-- disclaims all warranties including, without limitation, any implied warranties
-- of merchantability or of fitness for a particular purpose. The risk arising
-- out of the use or performance of the scripts and documentation stays with you.
-- In no event shall SolarWinds or anyone else involved in the creation,
-- production, or delivery of the scripts be liable for any damages whatsoever
-- (including, without limitation, damages for loss of business profits, business
-- interruption, loss of business information, or other pecuniary loss) arising
-- out of the use of or inability to use the scripts or documentation.
SELECT ID, Name
FROM dbo.Credential
WHERE Name LIKE '%XX%';
-- Replace XX with the actual credential name shown in Manage Windows Credentials.
- Pull the actions using that credential:
-- Scripts are not supported under any SolarWinds support program or service. -- Scripts are provided AS IS without warranty of any kind. SolarWinds further -- disclaims all warranties including, without limitation, any implied warranties -- of merchantability or of fitness for a particular purpose. The risk arising -- out of the use or performance of the scripts and documentation stays with you. -- In no event shall SolarWinds or anyone else involved in the creation, -- production, or delivery of the scripts be liable for any damages whatsoever -- (including, without limitation, damages for loss of business profits, business -- interruption, loss of business information, or other pecuniary loss) arising -- out of the use of or inability to use the scripts or documentation. SELECT a.ActionID, a.Title AS ActionName, a.ActionTypeID, ap.PropertyName, ap.PropertyValue FROM dbo.Actions a JOIN dbo.ActionsProperties ap ON a.ActionID = ap.ActionID WHERE ap.PropertyValue = 'XX' -- replace XX with the Credential ID from step 1 ORDER BY a.ActionID, ap.PropertyName;
This will list the actions tied to that Windows credential.