Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

get username, password, and enable password from database

Is is possible to write a select statement that writes the usernames, passwords, and enable passwords or each device?

I need a list with this information for use in Cisco Network Collector, and obviously, NCM can extract the information in clear text but I can't figure out how to do the conversion in a select statement.

As it is now, I can make a list with a default username and password and then manually change in Cisco Network Collector for the devices that fails when using the default.

Find more posts tagged with

cleartext_cnc_ncm

Accepted answers

chris.lapoint

The passwords are encrypted by default in the NCM database. Have you tried going to Reports > Security > Login information for each device. That might provide you the info you need.

All comments

sedmo

If you just need to get the data extracted from NCM, you could create a report in NCM with the fields you need and then export it to a text file of some sort.

svindler

The format of the csv I need to create is this:

; Here are the columns of the table.
; Columns 1 and 2 are required.
; Columns 3 through 19 are optional.
; Col# = 1: Name (including domain or simply an IP)
; Col# = 2: RO community string
; Col# = 3: RW community string
; Col# = 4: Serial Number
; Col# = 5: User Field 1
; Col# = 6: User Field 2
; Col# = 7: User Field 3
; Col# = 8: User Field 4
; Col# = 9; Name = Telnet password
; Col# = 10; Name = Enable password
; Col# = 11; Name = Enable secret
; Col# = 12; Name = Tacacs user
; Col# = 13; Name = Tacacs password
; Col# = 14; Name = Tacacs enable user
; Col# = 15; Name = Tacacs enable password
; Col# = 16; Name = Local user
; Col# = 17; Name = Local password
; Col# = 18; Name = Rcp user
; Col# = 19; Name = Rcp password
; Col# = 20; Name = Enable User

Although only 1 and 2 is required, for best results in CNC, I need to put in the login credentials, like username, telnet password, and enable password. I can get username in clear text in a report but I can't find the passwords when I create a report?

chris.lapoint

The passwords are encrypted by default in the NCM database. Have you tried going to Reports > Security > Login information for each device. That might provide you the info you need.

svindler

Your answer prompted me to look for a method to disable the encryption. After disabling encryption, I can now generate the needed csv file. I am doing it in the Database Manager as this is a bit more flexible than the Reports.