mrxinu

@"mesverrum" You're a genius, sir.

What duplication did you have in mind? The SWQL you write would mostly be to limit what you're getting from the API in the way of things like node details for example. If you just want everything about the node you can GET on the Orion.Node\NodeID and get everything at once.

Any idea what the default values are for the other bits I don't want to adjust?

You are most welcome!

What does the escalation tab of the email trigger action alert look like? Any boxes checked?

Please post the actual script that you're using.

No. When you use an account limitation you can think of it as a filter - whatever devices you're limiting to are the only ones that user will be able to see with whatever permissions that user has. For example, if you limit a user to Cisco devices only and they have the node managment permission, they'll be able to manage…

Can you do an snmpwalk and maybe provide the results in a PM (or a link to somewhere with the results)? I'm wondering if you're not getting the bare minimum SNMP data from the device to qualify as valid for monitoring in SolarWinds. I believe, and someone correct me if I'm wrong, that you need data from SYSTEM-MIB, IF-MIB,…

Outstanding! Just one more thing that I'll mention is that when you're using that view you need to be aware that, depending on how far back you go, you're going to be using data across multiple precisions (detail, hourly, and daily). To make sure calculations are accurate you'll need to consider the weight of the data…

Ah, gotcha. So this is going to talk about unmanaging them using the PowerShell module, but it's similar to how you would do it with the REST endpoints. https://github.com/solarwinds/OrionSDK/wiki/Unmanaging-Entities You'll need the four things they talk about here: netObjectID (e.g., "N:123"), the start time in UTC, the…

You're very welcome.

Looks good! And no worries on the lagging GH stuff, you should see my backlog of stuff to learn right now.

Ah, good point. I hadn't thought of that. I'm thinking; give me a minute.

I created a video but it's the 'use advanced editor' link in the upper right corner. Advanced Formatting in Thwack Posts - YouTube Yeah, no relationship that I can find between the two products beyond the shared IP addresses. I'm really surprised that you got fewer rows because you're adding IP addresses by dipping into…

But you appreciate the suggestion, right? Because he was trying to help.

Here you go!

This is a nearly straight rewrite of what you had in Python. It requires the swisclient from pypi (pip install swisclient) and python3: import swisfrom datetime import datetime"""A conversion of the PowerShell script by David Shin."""def main(): date = datetime.today('%y%m%d%H') file = 'C:\{}-OS_CHECK.txt'.format(date)…

My pleasure, Jeff. =) Can you make sure you flag that reply as the answer so folks can find it when they're searching?

Actually I misread - it's RESULT_IN, not AAA. Here is the query with the updates. DECLARE @StartDate DateTime DECLARE @EndDate DateTime SET @StartDate = CAST((ROUND(CAST(GetDate() - 30 AS FLOAT), 0, 1)) as datetime) SET @EndDate = GetDate() SELECT Nodes.Caption AS NodeName, Interfaces.InterfaceName AS Interface_Name,…

You're very welcome. -- Steven W. Klassen Programmer Analyst @ Loop1 Systems http://www.loop1systems.com/ http://www.linkedin.com/in/mrxinu

Fair enough. I'll take a swing at this this afternoon when things settle down.

The REST API will work fine. Just put together a hash making up all the things you want to define about your new node and then hand it off to the Invoke-RestMethod cmdlet as the body of the request. Something like this: $properties = @{ 'IPAddress' = '192.168.21.1'; 'EngineID' = 1; # more properties here }…

Okay so status and rawstatus are returning the same value which makes sense. I'm with Andy on this one - are you sure that OID is giving you what you think you're supposed to be getting? That MIB Walk is going to shed a lot of light on this. Grab SolarWinds Engineer's Toolset and give it a spin.

This was going to be my suggestion as well. Can we see the entire script with this laid in?

Ah I see what you were asking. Sorry about that. Give this a try. You should have access to both the active alert information if you want additional fields and the alert object information so just add to the SELECT clause as needed: SELECT Alerts.AlertActiveID ,Alerts.AlertObjectID ,Alerts.TriggeredDateTime…

What's an orion alert manager?

You're very welcome. We're happy to have you!

Oh yeah, if you go the SQL route you want to come away from SWQL studio entirely (that's only for SWQL/API calls). To access the database directly (with PowerShell, for example) you'll need to use its native .NET libraries to connect and run queries. There's an example of it in this other thread: Re: SAM Alert to SQL Table

I stand corrected, it looks like WinRM uses this when it connects to systems. Check out the script attached to the article below: AppInsight for IIS: Create certificates - SolarWinds Worldwide, LLC. Help and Support Thanks to zackm​ for pointing it out to me. -- Steven W. Klassen Programmer Analyst @ Loop1 Systems…

Hi jbernstein​! Are you getting an error or some message indicating that there's a missing certificate? What component are you using where this is an issue? -- Steven W. Klassen Programmer Analyst @ Loop1 Systems http://www.loop1systems.com/ http://www.linkedin.com/in/mrxinu