adam.beedell · SRE/Machine Learning Student · ✭✭✭✭✭

I've used the Network Discovery pathway and can confirm that works fine in bulk. Looks like it should be possible through SWQL, there's some details here: AppInsight for IIS assing to node API

Hi There, Very few threads on this sort of question - Any other pratical advice you've come across since you were troubleshooting this? I've got a query i'd like to graph, i've got my time column and a statistic, however I want to COUNT DISTINCT and so i've already got a rollup in place, I think this is what's causing me…

Why not do something like this?

Haha I love the evil solution! Above/below a bounding latitude works decently for north/south (kinda, London throws stuff off), but the local engineer areas are all over the place and that's a bit more complicated. No solid data available so far for jurisdiction that I could use to place things in groups (for these…

That timestamp format will be a pain Custom SWQL or SQL alert using datediff and getUTCdate or equivalent verbs will work. if that's actually how the timestamp comes out you might need to break it up and reassemble it. Looks doable but a faff. Maybe ask a DBA for assistance if you've got a favour spare

The HTTP POST action via the alert menu comes in an old, bad format. My money's on that. It is not JSON. If your endpoint needs JSON, you want to instead use the "execute an external program/script", pick powershell or similar, passing data in using arguments, and then generate the POST/GET request in powershell. Executing…

dunky2k​efosshaug​ This does it, stick it in a customhtml element: <script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script> <div> <script> var swql="SELECT SI.StatusName AS Status, COUNT(Status) AS Total FROM Orion.Nodes N INNER JOIN Orion.StatusInfo SI ON SI.StatusId = N.Status GROUP BY…

Well worth a shot - It's a weird one!

That alert logic looks weird but probably fine (the 3 conditions could all be alone without the extra "AND" blocks, and a single nodename under an OR condition is odd) Is it that the alert didn't fire, or the email didn't arrive? The event you've listed suggests the powershell is fine The "will trigger on one object"…

I've not put any locations for AWS/Azure but we have a cloud DC in a particular country i've assigned some co-ordinates to. The team who care about that service don't really need a world map view so it's not been relevant, but if it was i'd absolutely stick em in the sea off the coast

Step 1 -> roll out agents and/or add agents to SLW though automated means Step 2 -> manage nodes -> sort by polling method -> agent Step 3 -> Select all Step 4 -> Edit properties to do all at once Step 5 -> Enable dependency mapping and hit save No hundreds of clicks needed, should be way faster than trying to code anything

Still got the problem? Not a clue what that error is referring to, but generally i'd start with a website rebuild (Backup, delete site in IIS, rerun configuration wizard, redo certificate stuff or HTTPS forward if need be) If that doesn't sort your problem it'd be straight to solarwinds customer support to figure out what…

Hi mesverrum​, I was about to open a similar thread but this seems like a good place to start I'd like to add netflow information into my interface utilisation alerts. One of these charts perhaps, or even just a text variable/table for who's likely causing the problem It's one of those things you'd think would be…

That is everything I was after, much appreciated!

Hi There, Here's a hidden fix to something that's been a headache of mine for a while - Looks like you've not signed in for a while, but if you happen to still get these notifications i'd love to know more about how this workaround gets formatted

Ah ty again for the code then!

Hi dgsmith80, Same information each time is fine - I was thinking of hardcoding the chart settings in as part of the URL I've never been sure how the "LinkFor" stuff actually works though i've used them from other's code before, Not sure if the hyperlink presented there can be edited, the view it would link to as default…

You can alert on LastUptimePollUTC in the alert UI now (used to have to be custom, not sure exactly which version it was patched in) The name if that value is misleading IMO, but represents the last statistics poll, IE not pings You'll find it gets noisy fast during a solarwinds fault, beware or design that in

Hi @"serena", (Been a while!) I'm trying here first as I don't get the impression there's all that many people who know about the solarwinds API poller details - Are Solarwinds Variables allowed to evaluate in BODY, or other non-URL sections of the API poller? If not, is there a way of using the URL or similar for what…

Hi Kwilson, NTA software installs on the web server/pollers, the DB server becomes just a repository

The old timey installer process was a nightmare in a multi-server environment. The "new" installer cleared that right up and I'm very grateful for it! The pre-flight checks have been getting better and better too, and take much of the work out, again much appreciated there. Generally speaking the UI is straightforward,…

Hi there, not my thread but seems like a good time to chime in and complete the chain: 3 actions that'd cover most of the my use case for netflow alerting: * Alert me when traffic between x and y is more than 40% application/port z (w/ standard deviation support perhaps?) (Alert me when traffic is mostly backups/netflix in…

Hi Team, Running an install at the moment - General experience is excellent meech​ Had a bug during when connecting to the SQL database - Servername, username, password details were well known and set in stone. Connection to the DB failed however due to an authentication problem. Thought that was strange, rechecked and…

Good god get your job weight down on the SLC poller it's at like twice capacity!

Hi Leon, I've been wanting to do something similar to this on Summary pages - The [_linkfor_x] method gets somewhere but more's always better. I've seen some code for using a customHTML element to call the SLW API to produce the data, and then that should be able to do whatever formatting, but I'm not familiar with how…

Awesome, thanks Mark!

Hi Mark, me again, i've downloaded the updated attachment and it does have some script to delete temp folder docs but the lines 2->91 or so about updating the Alert Note with the content deleted and such are missing Sorry to ask again, but got that bit in the archive anywhere? (or could you link me to a similar example?)

Hi m_roberts​, this looks really useful but I'm struggling to find the mentioned .PS1, do you still have that anywhere or am i missing something obvious?

Make a new alert, set it to custom SQL, copy and paste this in: where datediff(minute,lastsystemuptimepollutc, getutcdate())>=3*StatCollection and objectsubtype<>'ICMP' and status<>2 and status<>9 and status<>11 and status<>12 and (vendor like 'Windows' or vendor like 'VMware Inc.' or vendor like 'net-snmp') That's for…

Hi there, I've also been working with some of these google chart integrations off of wluther​'s post, could you talk about how to arranged the SWQL query component in a way Google was happy with? "select…