bluefunelemental

We, and I suspect many here, have scaled our Solarwinds to multiple sites globally. We have three "instances" of Solarwinds which had been split based on organizational need and not locational. One instance is polling globally and all additional pollers are in one location split up by function, say npm vs SAM etc. Another…

I spent this past week working on sdk invoke for alert custom property values. I think I'll be able to read in SN values such as locations or team names and modify or create custom property look values with them. That said I'm getting a message size error on modifying the values. Anyway- much better then doing it in the DB.

‌so calling a soap.exe is easy and so is returning a value in a variable. The challege, and why I choose to use invoke-WebRequest below is that the soap.exe expects the body data to be presented like -data @filename.xml this presents no issue on the command line but in a SAM monitor I cannot figure out the root execution…

Peter told me to do it. No seriously I would fail back to adding http or snmp monitors to accomplish the same result. Now in dev I'm interested what happens if I change entity types. In dev. Maybe even eval. Not production. Nope.

Did you add a delay between the two actions? The script needs time to run Thanks, Christian

Michal, We cannot have engineers pick open network ports to use based on shutdown in Solarwinds since they see both shutdown end devices and ports both as just unplugged. Instead we still have to go through switch console to pull port status and which are free to use. Just looking for the engineers to be able to rely on…

Yup - I guess I mistyped or just have the wrong path- please do share so I can get schooled proper like.

‌I did not get the icons for sql last run status in a report - would you be willing to provide what the generic icon path would be if that works or a general edumacasion on how to get icons beyond statusLED and simple statusinfo enumerated ones?

I agree about more documentation around machinetypes. However I have found as I learned more about them that having more nuanced machinetypes is always preferred. So for me I would prefer a hyper-v and VMWare machinetype. This is not an easy method but you could set up a SQL UX monitor to query the Orion DB for…

Researched IIS and SQL synchronization. Decided on SQL management studio connection to a source management such as TFS,Svn, Git to help us recreate queries quickly. Investigating the same for Visual Studio but I have yet to connect VS to SWIS which was my goal. At the end of the day even if you use a spreadsheet of changes…

This would be a script for the SAM windows powershell monitor component. Get it running in powershell from the main or remote poller first , Google is your friend, then create a new SAM template, manual add new component, and copy powershell script into the monitor.

‌since Orion runs on windows, powershell is my scripting language of choice. This includes a simple example of checking an SMTP server, though I think it emails a message. PowerShell emulate telnet session and test output - Tom's Blog and this provides some background on testing mail servers through telnet How to check an…

You wanted to know which subnets were in IPAM but not in a discovery profile? This takes all IPAM ips, looks in the discovery profile xml text string for them and returns where there was no match.

@tdanner It looks to me like unsuccessful discoveries stay behind in the discovery profiles table whereas successful ones are deleted. Is that true?

Broke it? On update of IPnodeAttr and status? I assume based on locks if its running the subnet scan at the same time- I'll check if there's a jobs table then check for running jobs on subnet before update. Time for an API guys if you want people out of SQL. Thanks, Christian

I guess my question is would you expect it to show on an NPM node details page or an IP node details page? Since you want to filter it to a specific node or Mac address you will need to pick a page then see what page variables are available - for example I only see caption (which is usually the same as IPAddress) returning…

npm 11.5 production now monitors all our nexus hardware health without issue I was happy to remove these custom props and charts.

I wonder if thats new - it used to work Re: How to insert the status icon for interfaces into SWQL resource Re: Custom SWQL Query Resource Help

Does sql evaluate the where clauses in order? If so having that first might return fewer results into the wildcard message search. Neither are indexed so I don't know if it would make any difference.

Peter.Cooper‌ - never mind - got it to work as expected with $tableref}.NodeID IS NOT NULL That said should I expect the systemUuid GUID to ever get recalculated on upgrades? Wondering if it's safer to key in on the combination of stack, category, and entity type.

Negative on that query working -would I be better off trying an IIS reset or resetting this and setting all nodes to IsServer?

I am not sure how I missed that table but it's a goldmine. I like the fact that it includes a stack column. Just saying. I'll stick with this and disable the sql agent job but my dev system is about to have some really strange Appstack categories

So I meant dbo.websites but it looks like you knew that Mine is fqdn or whatever dns name you want people to use under server name followed by ssl enabled =1 for port 443 and 0 for port 80.

Excellent - what about adding the instance name? , 'SolarwindsServerA' AS [Instance] …etc Then you could group by instance if needed. I just wish my version of EOC supported full SWQL custom resource...

Any active feature requests or plans for alert custom properties?

You can try to use this but mileage may vary Blah blah as ,' ' + nodes.caption AS

I am polling both by VIP, and physical addresses the FI and still do not see the FI power supplies - I just snmpwalked it with support and the oid's on the 6200 series looks different from what Solarwinds developed the resource against for 6100 series. Unless I am mistaken this means the information is just being ignored.

Bump - it looks like this is still the case with 10.6 It makes sense to me that unplugged ports that are admin shutdown should inherit the admin shutdown icon until they are admin up.

What do you get if your changed the two is null to AND and (v1.volumeid is null AND v2.volumeid is null) order by n.caption

As I build more custom queries I'll post any that are expensive queries. In the meantime, can I audit my above wish list in that exporting out of a Custom Query (much like we do with reports using "…&dataformat=xls") would be paramount for making these better audit and reporting tools. I don't see reports as useful without…