shuth · SolarWinds Consultant · ✭✭✭✭✭

Seeing as Dez featured a lot in the mission, missed an opportunity to give out a copy of Destiny 2 with the PS4!

Agreed. Always tweaking.

All good! I like the new question format but it seems a few integration items back to thwack still need to be sorted.

Fortunately when Cisco Live is here in Melbourne it's only a 10 minute walk from the office so I can dump any extra bits if needed. These are great tips when travelling for a conference though. I've been to one international conference in the US... lost my phone! That should be a tip - don't lose your phone! Although…

I missed making my own bracket. I probably would've put dragon!

I'm on call this week and it is currently slightly after 1 AM. Someone just rang our after-hours support number and initially I was very confused with his request. He was looking to leave a message to make an appointment with an orthotics company - a bit of troubleshooting (hey, I can still provide some support!) and found…

Congrats to the winners!

I'm running into this requirement a lot more now that people are upgrading NPM and moving over to Log Manager. There needs to be a way to easily reference the log variables and more specific information about the message (e.g. trap varbinds).

This could also work with a select all/deselect all option. We have a customer who has a lot of different community strings and when they create a new discovery they have to spend a lot of time removing all the irrelevant strings (by default a new discovery adds every string into the list). Their workaround is to have a…

As above, I'm not sure what else I can add to the conversation that hasn't already been mentioned. I wholeheartedly agree with your end comment though when it comes to password control, giving out information that shouldn't (more oblivious to what it could be used for not maliciousness), etc. In terms of what we have in…

Hehe tomiannelli, that reminds me of a time in school when the teacher gave out a sheet of paper containing a list of items to the entire class. The first item would read similar to "read through this list" and the last item "after reading this list, just write your name in the corner and wait". The list contained about 20…

I believe SolarWinds uses the LastBoot data - if the value in that field changes then the device has rebooted.

The module based licensing has had a massive increase as well where in a lot of cases it is more economical to move to HCO/SWOSH which I believe is the intent. The HCO/SWOSH conversion is still an insane increase over existing renewals though.

You can add one of the following. Either would work. AND n.Unmanaged = 0 AND n.Unmanaged = False If you want to filter by status you can use "AND Status <> 9" rather than only including Status = 1 nodes. The nodes going into warning/critical status have different status values (3, 14).

Can you do something like: WHERE E0.[ComponentAlert].[ComponentName] IN ( '% Processor Time' , 'Processor Queue Length' )

Messy but maybe something like this. It would trigger a node down alert for every node down in a city with more 3 or more nodes down. If 2 nodes go down in a city then no alert. If 6 nodes go down in a city, you'll get 6 alerts because it's a node alert... Custom SWQL Alert (for whatever reason I can't insert a code block…

I'm not sure of the efficiency but you could do something like this: SELECT Nodes.Caption AS [Node Name] , Nodes.Status , Nodes.DetailsUrl , Avail_30.Availability AS [Availability 30] , Avail_60.Availability AS [Availability 60] , Avail_90.Availability AS [Availability 90] FROM Orion.Nodes Nodes LEFT JOIN ( SELECT…

The SolarWinds versions need to be the same for HA to work. For your questions: * It will use the current SQL server and database. If you chose the HA option it would have pulled those details automatically. * Windows version should not matter but the SolarWinds versions need to match. Looks like you are trying to do…

As @"bobmarley" mentioned, you could run a PowerShell script. Alternatively you could use the File Count Monitor (there is an out-of-the-box template or you can add the component monitor to a new template). Specify the location and any filters and it will come back with a file count. You can set the thresholds to be…

Hmm, not off the top of my head without something messy. Could potentially split it up into 6 different queries. Feed that list of StoreNumbers into another query that excludes the other 5 captions, or something, but maybe I'm over thinking that.

I suspect this is what they have done but the problem is the alert/component monitor will show all the events collected in the last X time period. I'm not sure how they would go about it in SAM to get 1 email per user unless only 1 user was being locked out per polling collection interval. 

This is probably a starting point if you are just after the StoreNumber. Something like the following will list the StoreNumbers that have less than 6 devices with SiteType=Store. If you remove or comment out the HAVING line, it will list all the stores and the device count. SELECT StoreNumber, COUNT(NodeID) AS NodeCount…

If you edit the template, you can select the checkbox next to the component and click the Rename button.

Groups are tricky. You could use the PercentMembersAvailability column in the Orion.ContainerStatus table but that's availability of any object in that group, not necessarily the site/office being offline. The PercentAvailability column should represent the overall group status - if you use Mixed Status rollup the group…

You could try something like the below query. If it detects a Windows node, it will use the DeviceID otherwise it will use the normal caption. I added an additional check because it looks like the DeviceID is only collected on Windows with WMI/Agent - an SNMP node doesn't have the DeviceID. But you can tweak the query from…

You could try to locate that statistic in the database and delete it. Otherwise I believe the chart should reset the Y-axis once the time period moves past that data. E.g. that screenshot looks like it is pulling "Last 24 Hours" of data and showing "Today", so tomorrow it shouldn't have that spike and should go back to…

That looks more like an issue with the device not reporting the Power Supply is down. The hardware sensor brings back what the device reports so you SHOULD see the second power supply as Critical, which would trigger the alert. The alert is not triggering because, for whatever reason, SolarWinds doesn't see that power…

I just ran a quick test against a tabular poller in my lab and looks like it should work. Make sure you are selecting "I want to alert on: Custom Table Poller Current Status". I find it useful to split out the scope vs the trigger as well. I also find it useful to add ${N=SwisEntity;M=Status} to the Trigger Action Message…

Similar to this, for a client I set up a nightly scheduled task on the SW server that ran a PowerShell script to check if all the relevant pollers were assigned to particular devices.

What @"mesverrum" said - your retention settings have the data rolled up. However this would be your daily retention setting where the hourly data is rolled up into a single daily statistic, hence why you have a data point on each day. You would need to either run the report at the start of the following month (and maybe…