App Control: How to Retrieve Local CLI Password from the DAS Database

App Control: How to Retrieve Local CLI Password from the DAS Database

Environment

App Control Server: All Versions

Objective

To locate the local CLI password of any agent using a SQL query.

Resolution

  1. Login to App Control SQL Server
  2. Open SQL Management Studio
  3. 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


Labels (1)
Tags (2)
Was this article helpful? Yes No
No ratings
Article Information
Author:
Creation Date:
‎04-05-2018
Views:
2188
Contributors