NCM Global Device Defaults Table & Connection Profile in SWQL

Never mind on the GlobalSettings question.  Figures as soon as I post it, after looking for several hours over several days, there it is.  Found at Cirrus.GlobalSettings.  Was looking previously under NCM.  Still would like the other question answered if possible.

There is a search function. It’s easy to overlook:

Wow clarv02​... LOL.  I searched through all the menus and found nothing.  Now you point it out and it is plain as day, right in front of my face.  Thanks.

Bump...  See middle paragraph from original post for still unanswered question.  TIA

sorry about the massive screenshot. I didn't look nearly that huge on my phone.

when you searched SWQL Stuido for connectionprofile, there should have been a few hits.

Hits reveal columns in Cirrus.NodeProperties, Cirrus.Nodes and NCM.NodeProperties as well as verbs in CirrusNodes.  However all of those just hold the integer referencing the Connection Profile and none show the details of that Connection Profile.  I want the ability to translate from the integer to the name of the Connection Profile.

I see what you mean. I recommend invoking the verb: GetAllConnectionProfiles

Try this in Python:

profiles = swis.invoke('Cirrus.Nodes', 'GetAllConnectionProfiles')

Then print out the results and manipulate the data as needed.

Cheers

Appreciate the help @clarv02!!!

In PowerShell I used:

          $Profiles = Invoke-SwisVerb $OrnSwis Cirrus.Nodes GetAllConnectionProfiles @()

and piping to Out-String gives me:

          Id                              : 1

          Size                          : 1

          xmlns                        : http://schemas.datacontract.org/2004/07/SolarWinds.InformationService.Contract

          d1p1                          : http://schemas.solarwinds.com/2007/08/informationservice/propertybag

          i                                 : http://www.w3.org/2001/XMLSchema-instance

          z                                : http://schemas.microsoft.com/2003/10/Serialization/

          ConnectionProfile      : ConnectionProfile

However I am not seeing the Profile "Name" there which is what I am trying to get to.  Also not seeing the other columns seen through SQL in NCM.ConnectionProfiles.

Will admit that I am new to manipulating XmlElement as well.  Maybe that is why I am not seeing what I am looking for.

Have also been trying to figure out how to extract from an XmlElement with no luck.  Everything I have been able to find on working with XmlElement is assuming you know the Xml structure because you have a file you imported to PowerShell to do what they are  talking about.  Obviously this XmlElement did not come from a file.

If you can help me out with these challenges, I would be greatly appreciated.

sorry my PowerShell skills are beginner, and all the SolarWinds API work I've done has been in Python. Here's what I get back from invoking GetAllConnectionProfiles in Python:

(scrubbed of course)

a list of dictionaries, each one representing a Connection Profile, like this one:

{'EnableLevel': '<No Enable Login>',

  'EnablePassword': 'someCrypticPwd',

  'ExecuteScriptProtocol': 'SSH auto',

  'ID': 4,

  'Name': 'theProfileName',

  'Password': 'someCrypticPwd',

  'RequestConfigProtocol': 'SSH auto',

  'SSHPort': 22,

  'TelnetPort': 23,

  'TransferConfigProtocol': 'SSH auto',

  'UseForAutoDetect': False,

  'UserName': 'some_user'}