Environment
App Control Server: All Versions
Objective
To locate the local CLI password of any agent using a SQL query.
Resolution
- Login to App Control SQL Server
- Open SQL Management Studio
- Run Query:
USE das;
SELECT
C.Computer_Id AS "ID",
C.Computer AS "Hostname",
H.cli_code AS "CLI Code"
FROM bit9_public.ExComputers C
JOIN dbo.hostmain H with (NOLOCK) ON H.host_id = C.Computer_Id
ORDER BY C.Computer ASC
Additional Notes
Add the below addition (before ORDER BY) to only show deleted computers cli passwords
Where
C.Computer_Deleted = 'Yes'
Related Content