View NCM Connection Profiles

Question

Hi All, I need an easy way to confirm all the usernames in use within my NCM connection profiles. I can manually go through all my connection profiles via the web front end, however due to the amount this would take quite a bit of time to complete. When I attempt to view the username in the NCM_ConnectionProfiles DB table it shows a hashed value. I've found that all information (including unhashed details) can be pulled via SWIS using the following: 
 Import-Module SwisPowerShell
$hostname = "NCMserverIP"
$username = "myusername"
$password = "mypassword"
$swis = Connect-Swis -Hostname $hostname -Username $username -Password $password
$result = Invoke-SwisVerb $swis Cirrus.Nodes GetAllConnectionProfiles @()
Write-Host $result.InnerXml 
 https://github.com/solarwinds/OrionSDK/wiki/NCM-Connection-Profiles Unfortunately the &ldquo;Write-Host $result.InnerXml&rdquo; command results in a very difficult to read output on the console. Does anyone know if there's a way to output these results to an easy to read format? Thanks.

KMSigma.SWI · Accepted Answer

You can do this as your last step: 
 $Results.ConnectionProfile | Select-Object -Property @{ Name = "Profile Name"; Expression = { $_.Name.InnerText } }, @{ Name = "Username"; Expression = { $_.Username.InnerText } }, @{ Name = "Enable Level"; Expression = { $_.EnableLevel.InnerText } } 
 This is because the results are returned in an XML format. It's not always the easiest to work with or understand.

View NCM Connection Profiles

Top Replies