View NCM Connection Profiles

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 “Write-Host $result.InnerXml” 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.

Find more posts tagged with

swis

ncm

xml

Accepted answers

KMSigma.SWI

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.

All comments

KMSigma.SWI

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.

NightEdition

Great, this is exactly what I was looking for. Thank you!