wlipford

#!/usr/local/bin/perl use strict; use Net::SNMP; use GenericODBC; #my $profile = $ARGV[0]; my $profile = 'Lipford - Testing'; my $search = $ARGV[1]; my $pattern = $ARGV[2]; my $outfile = "Log$ARGV[0].txt"; my $dbusername = '######'; my $dbpassword = '######'; my $server = '#######'; my $database = 'SolarwindsOrion'; if ((!…

Whoops, sorry it was about cbQoS - I started a new thread in case you want to delete me thread here.

And here is the debug print statements along with the response code. NodeID is 141 NodeUri is swis://airwpnmsswp01.win2k.corp.tnsi.com/Orion/Orion.Nodes/NodeID=141 NodeName is shf02.... swis://airwpnmsswp01.win2k.corp.tnsi.com/Orion/Orion.Nodes/NodeID=141/CustomProperties Response code: 200 JSON response document: null…

exactly, and when you are doing thousands of devices then selecting what interfaces to ignore is very cumbersome. I guess what I was really griping about is the fact that the system doesn't have a way to set reg-ex templates of some sort. It is also VERY annoying that you can't exclude devices from being imported into NPM.…

Here is the code, but again the response code is 200. #!/usr/bin/perl ################################################################ ## Program Name:Solarwinds Custom Property Enrichment All R3 Estate ## Version:1.1 ## ## Description: Enrich entire estate SW estate ## ## ## Usage: ## ## Author: Will Lipford Date:…

Which one to I apply: Orion Network Performance Monitor SL100-11.5.2 or Orion Network Performance Monitor SLX-11.5.2 ?

It is around 50-60 million records. Which with the beef under the hood with this SQL Server shouldn't be a problem, but we do have 30k nodes being polled every 300 seconds. Like you said the query plan looks fine, what baffles me is the tempdb filling up just running this query alone, our TempDB is 180GB

This isn't a cry for help with my current issue. I am simply making the point that Solarwinds needs to start officially supporting the API. We were told a few years back that it was on the roadmap. The forums is really great so it has nothing to do with my post.

I am on my final piece of the puzzle for my automation to give next week, the last piece is something I skipped over a few months back and had asked on Thwack which I believe you answered but in Python. I am not much a python guy but I have it a whirl to convert today. Any way you can have a look and tell me what’s wrong?…

Turns out the "Generic Juniper" Template and my Custom Juniper Template were both being applied. Once I turned off the Auto detect for the Generic one and made sure the Custom template was set for the Juniper devices in question it worked. I still see duplicate commands being sent, just the correct ones. I don't have time…

Can you try and SNMP walk a node from your polling engine? ICMP a node from polling engine?

Jay, Did you have more then one Orion server you were reverse proxy too? We have multiple Orion instances we point to. Now my issue I am facing is this. Proxy 1: /OrionNA -> serverA.com Proxy 2: /Orion -> serverB.com I see all javascript/css & other assets are a relative path of /orion - well since both instances both have…

The TempDB issue is a bug?

Here is the message back in a little cleaner format. $VAR1 = { 'FullException' => 'System.NullReferenceException: Object reference not set to an instance of an object. at SolarWinds.InformationService.Core.SwisUriResolver.BuildQuery(IEnumerable`1 uris, Dictionary`2 queryParameters, IEnumerable`1 properties) at…

Would QoS be considered a component setting ? 

Here is a snipped from the log in verbose mode. Nothing really pops out to me on why its failing. ******************************************** 2019-11-05 03:22:27,546 [287] DEBUG SolarWinds.InformationService.DataProviders.SqlDataProvider - (null) (null) } Update exited 2019-11-05 03:22:27,546 [287] DEBUG…

Hi Jan, I would be very interested in your powershell script, I will be converting the script to Perl and uploading to my GitHub. We have device upgrades about 20-30 times a week and run into these orphaned interfaces each time.

When can we expect a API guide? I heard rumors that this might come to fruition very soon.

Just checking in to see if this option may be coming soon or ?

Can I get an example of a discovery profile that has multiple community strings and also one that uses SNMP v3. Can't find anything on Thwack or documents displaying this.

Go to the new poller and launch a dos prompt. Try and ping the node you are adding, if that works then do a command line SNMP walk and make sure you can do that. It will allow you to verify SNMP,ICMP protocol communication.

This is all good, but you would bring in everything and filter out on views. Not ideal with a large estate. We have over 30k nodes in NPM, I am doing a import of 5000 right now, so I only want 3 interfaces per node and I can't bring everything in.

This was working for almost 2 months before I started getting this error. Here is my version details. Orion Platform Details Server Web ServerASBWPNMSSWP01Operating SystemWindows Server 2012 R2OS Version6.3.9600.0Service PackNone Network Elements Total Count38534Nodes9687Interfaces28082Volumes765 Version Info…

I did see the underlying mess in the view of underlying view source table query with the unions. So I guess the answer is that nothing is going to speed this up without like you stated using a NodeID or DateTime. BTW - I just limited this to a WHERE ([DailyNodeAvailability].[DateTime] >= '3/23/2015 00:00:00.000') and still…

Hello, Nothing has changed. Not sure what I could debug. rest response code is 200. Response content is blank since 200 is success code. Nothing in my infov3 logs either.

Hi and thanks for the reply. This is an external integration to a Customer portal where we are providing signal strength reports using our BI tool. We are going to have quite a bit more queries coming down the pipeline regarding this integration, we are eventually going to stand up a dedicated reporting instance but its…

Ah ok, I was just going to do it from SQL Server Query, but I will make this a API script and do it as you demonstrated. Thanks Tim.

I can see the connection being made via SNMP. So there is no firewall issue, and I can ping from the polling engine so ICMP should be ok.

Bumping this, buller ..... buller.... anyone?

Well from our perspective we are approaching a point where we have 200k in SQL Server costs and SW being the only application we have that runs in MS world vs utilizing our Oracle Enterprise site license, Oracle DW, Oracle OBIEE Reporting, etc....