mesverrum · Observability Architect · ✭✭✭✭✭

*edit, it looks like im responding to the person who made that suggestion. You are correct, there is nothing built into the GUI to set the standard method of status collection to use the SNMP poller. It was mentioned upthread, you can script up a method to disable the ICMP status poller and enable the SNMP status poller on…

Need to look at the resource properties table for resourced 5219 and 5179, the resource files are the generic base stuff for all custom HTML resources

you want to add and n.customproperties.owner = 'Systems' before the order by

Per aLTeReGo's post here, Re: APM script variables , those variables are only available in the script body, not as args. Try moving them into the body and see how they do?

Crossing the midnight threshold makes it a bit more complicated, but still doable. In this case lets assume I am monitoring something 12 hours east of the Solarwinds server time zone, so my server is in California and I'm building a report for a system in Dubai. I would just tweak it like below. Solarwinds in general does…

This thread shows how to set up a sam monitor for a reg value, Monitoring Windows Registry Value Then you could script something up in SQL or via the API to take whatever the current value of that SAM monitor is, and use it to set the location on the nodes table. I've never done this whole scheme so I'm not 100% sure off…

If you want to see it from the wireless controller page just add a custom query to the view and use this query. SELECT--n.caption as [Wireless Controller],--ap.displayname as [AP],c.SSID, count(ssid) as [Client Count]FROM Orion.Wireless.Clients cjoin orion.wireless.accesspoints ap on ap.id=c.accesspointidjoin orion.nodes n…

the _linkfor_ and _iconfor_ syntax only works in the custom query resource, and this particular report tweaks those to use as hidden columns to organize the layout better. You can just add a custom query resource to your report though, they don't only have to use the custom table and custom charts resources

Thats due to the order of operations in SQL, despite being at the top of the code the select statement is actually one of the last things that SQL runs so that rename hasn't happened when the group by code runs.

Post a screenshot of exactly how you have it set up and the result when it runs, when the whole query displays it usually indicates a syntax mistake was made somewhere.

and p.status != 9 p being the table the with parentnodes, and is the code for unmanaged status

My mistake then, never noticed that non admin/non customize page type users had that option before. Another way around it that I've used in the past is to just build tabs with for example a 7 day view and another with 30 day or 1 year views, that way they don't really have any need to change the values since they have…

Then I would hope they appreciate the cost benefit comparison of the time it will take your team to learn how to integrate PowerBI to the tool and learn the DB schema well enough to generate their desired reports versus just using the tool as is. I actually know that one of my colleagues, jamesatloop1 has done a custom…

it passes the variable into the command line when it launches your script, think something like running cmd > ping 192.168.1.1 Ping is our executable, 192.168.1.1 would be the argument to tell the ping program where to try to reach. You could set that up as an alert action by doing something to the effect of ping…

and audit.message not like '%snmp%'

The counters roll over few gb and start from zero again, it is possible that when zoomed out as far as you are the graph is comparing the counter at the start of the segment to the counter at the end of the interval, or possibly some subset of them like only once an hour instead of adding up every 10 minute interval within…

I fully agree with your assessment there. In cases where you have the time and knowledge to design it correctly you want each node to be a child if it's direct parent device, but in many cases people either do not know ahead of time which switch (or switches if you have proper redundancy) connects the node, so its just…

Oh yeah full automation of dependencies would be nice

I can't find a source for this anymore but I recall seeing that enabling netflow on a router was supposed to use something like 1-3% of the actual amount of traffic that goes through the interfaces. Basically for an entire packet stream we would only need to extract the basic packet header info and can ignore the rest of…

Oh that has got to be frustrating when something you need works for everyone else and you have some kind of weird issue. I'm really at a loss, I use this technique in different sites every week. And your alerts are otherwise fine with sending emails to the DL's when you hard code them in without the properties?

Between the ) and group by put in a line like And I.customproperties.<yourproperty> = '<yourvalue>'

So the root question to that is, does Cisco record who made that change? Since they don't normally record it on their end we don't normally have a way to track it in Orion either. Optionally you can enable full config logging in Cisco like so: https://blog.ipspace.net/2006/11/log-configuration-commands-entered-on.html Then…

This should work as a custom swql query SELECT distinct i.interfaceid , min(tolocal(i.DateTime)) as [Earliest Timestamp] , sum(i.InTotalBytes) as [InBytesTotal] , sum(i.OutTotalBytes) as [OutBytesTotal] from orion.npm.InterfaceTraffic i where tolocal(i.DateTime) >= DATETRUNC('month',GETDATE()) --datetrunc gets us the start…

I've done similar types of custom templates and config types before, makes sense to me. I'm not 100% certain about the device template being in the trace, but i know I've seen it show up before somewhere when debugging log files for templates, so if the trace isn't the spot maybe hit up support and have them confirm if…

if you poll vcenter, and have vman integrated, then you would get some metrics about the hosts even when they aren't managed as nodes. If you don't have vman then all you get when you click on the hosts that aren't in NPM is a prompt to add them

You would use the same responsetime view are you are looking at, IIRC there is a column called archive i believe will be 0 for raw data, then it increments up as they go through the various phases of rollup.

Like I mentioned I was just winging that one based on some educated guesses, probably some syntax hangups. Would want to load it into the database manager or into SSMS to validate the syntax. Pick a single interface and hard code this into the ${interfaceid} placeholder while you are testing to make sure you can get back a…

Try removing the period from the rule you pasted in there and the *, in regex the * is not a wildcard, it means "the previous value 0 or more times" So in the example jkrenzien gave you the \s* means 0 or more white spaces. Whenever NCM is giving me a hard time I find it can be helpful to load up RegExr: Learn, Build, &…

The columns you added break it since you mix aggregated and non-aggregated data. Cut it down to just what I showed and it will show the most recent update, you won't be able to include details because there is no meaningful way to max() those strings If you get into fancy SQL you can correlate the max timestamp with…

I'm not sure it can be done this way. The poll now, rediscover, and maintenance all kick off javascript bits like this one and I don't think the SWQL _linkfor_ function can parse them <a href="javascript:;" onclick="return showPollNowDialog(['N:21']);" id="pollNowLnk"><img src="/Orion/images/pollnow_16x16.gif" alt=""> Poll…