Research Triangle PowerShell Users Group Extras, 14 May 2020

Previous Meeting Next Meeting

⏯

youtube image

►

From YouTube: Lightning talk: Interact with Solarwinds Orion SDK with PowerShell

Description

An intro to creating automation for Solarwinds using the Orion SDK, SWQL and PowerShell from a lightning talk demo. Lightning talks are opportunities for RTPSUG members to share interesting bits of code with one another.

David Gilbert walks through how he uses the SDK and PowerShell automate mundane tasks like dealing with NIC driver changes that cause false alerts. David discusses resources available and how to do discoveries when scripting is not an option.

A

All right, oh I, I'm monitoring and one of my pet sorry.

B

A

Don't thing that happens is if.

B

Network card gets changed, or sometimes the driver changes. Solar ones will tell you that the interface is down. It's not down is okay right, so I can fix that manually or I can write a script and if you run SolarWinds and you're out of power, so you really should know about ryan sdk, because that's what gives you power show gives you a few things got a nice wiki right there on the github.

A

Site right, it gives you slowly.

B

Cool studio, solar whisperer language.

A

B

Is exactly like sequel, which is great, except when it's not, which is terrible.

B

But with the studio, you can write your filaments query and you can get it right once you've got it right. You can go to the next great thing, which is the source.

A

Powershell module right. You see the name of the query language again, please boooo cool.

B

Idea, it's a good training class on automating SolarWinds than the guy, whose training did not a savior.

A

Alright, so this partial module.

B

Get some ice first like connect to the Swiss server, get Swiss data. You can put in your your query that you just tested in Julie and now I've got a list of all the Knicks. That I know are on servers that have working next, because they're still up write, a query does so now I'm halfway done, I can just call them verb to delete them.

B

That's what I'm paranoid and I overthink things, and sometimes the old Nick will show that it's gone, but the new Nick won't be found yet so the way you added into SolarWinds as you do a discovery discovery is a little more complicated than just a superb, but is hey? Look here's a sample spit up on github SDK on how to do you have to build a couple of different xml's and and execute right. So this is the code to do that. First, I'm, hitting the IPS of all my node objects.

A

That have badniks storing.

B

That down to unique, because it might be multiple bad on a server, then I'm, creating the XML that contains those IP addresses to discover sending an XML and when I tested this your command line. Interactively like you, do it didn't work. So this is googling or the.

A

Should do that and I found every does not add W. My nose is by credentials. Okay,.

B

So there's fixes to the XML in here that I've got being pasted into my script.

A

More XML that I've figure it out and.

B

Then invokes whisper, Ferb, see what I'm showing you because of WebEx but create interface plug-in configuration. The other think nice thing about sequel studio is.

B

You can browse objects, here's the discovery, object and it'll. Give you the verbs that you can use with invokes this verb. So in this case, I see that it just takes an xml argument right.

A

B

Prefer to start the discovery and then I am querying the data. The discovery table tape. It's done the reason I'm doing this is because I didn't read the documentation and find out that there was a get discovery, progress command that I could have been dumped. Instead, that's.

A

B

It goes through discovery finishes once I that I've imported any new network interfaces that weren't showing up before then I can go ahead and subject delete my bad old interface.

B

That's why script swiss closed I mentioned the filaments. Training class I asked him because none of his cashews was closed. So he has the developer of the interface he's like oh yeah. If you want to, you, can use it to.

A

B

Queries and they get mad at you, full indisposed.

A

Right so I I still use.

B

It and that's my script funny story about a month after I wrote that script I updated SolarWinds latest version and I got some neat new check boxes like this Leetsdale interface. So.

A

What you really.

B

Should know is that patcher stuff yeah and that's my story all right.