marlief22 · SolarWinds Specialist · ✭✭✭✭✭

Hi there, Cloning a SolarWinds system is as simple as taking a database back-up and restoring it to a new SQL server. All the nodes, alerts, dashboards, everything is stored on the DB. The application servers in fact don't store anything to do with the running of SolarWinds, and are simply just dumb services that read and…

Hi there, I have created this query that does I believe what you are looking for: Currently it is using the percentage usage, but can be changed to bps if needed. Just take the code below and put it in a Custom Query widget on your group details page and it should work for whichever group you are looking for. (Follow these…

Hi there, Yes, you can add multiple conditions on the 'Trigger Condition' tab of the alert configuration: Make sure that it's set to AND and not OR otherwise it won't work correctly. Kind regards, Marlie Fancourt | SolarWinds Pre-Sales Manager Prosperon Networks | SolarWinds Partner since 2006 If this helps answer your…

Hmm, I definitely see what you're saying now. Unfortunately, anything you put into the PERL script, even if it were to be encrypted by the script itself would just be obfuscating it and not really keeping it "secret" as such. The best solution here is to simply make the account you are running it as able to run the script,…

Is there any reason you can't add this as a Credential? It would be encrypted in the DB. 

Hi there, Un-managing is definitely one way to do this, although you may want to see how the agent is polling (even if it's down) without the alerts triggering. In this case the "Mute Alerts" is a much better way to achieve this: That means that you can make all the changes you need, and even if some of the installs fail…

Hi there, Yes, you can absolutely do this, the variable you need is ${CREDENTIALS}. This will pull the credentials from the drop-down just above it named "Credential for Monitoring". I use this in the Script Arguments section, than apply it to a variable in the script body. You can see me using this in the script below…

Hi there, Do you have any network discovery jobs that are scheduled to run regularly? These would automatically add back poller that have been removed previously. If that isn't the case, it could be that there is some issue with the way that the request is being sent to the database, I would check to see if the database…

Hi John, you should be able to edit the report after you have imported it. First, go to All Reports, then use the 'Manage Reports' link in the top right: You can then find the report in question, tick it and press 'Edit Report': Then, go to the section that is having the problem and press 'Edit': Then you can click on the…

Hi there, You might be having problems with queued jobs on the platform? I would recommend repairing the job engine and collector as that might resolve things for you: https://support.solarwinds.com/SuccessCenter/s/article/Repair-a-failing-Job-Engine-Collector-and-Information-service-in-Orion-Platform?language=en_US Kind…

Hi there, Please have a read through the following as I believe it's the best guide for PowerShell script monitors in SolarWinds: https://blog.kmsigma.com/2017/09/08/sam-powershell-scripting-template/ Kind regards, Marlie Fancourt | SolarWinds Pre-Sales Manager Prosperon Networks | SolarWinds Partner since 2006 If this…

Hi there, Just so you know, there is a whole section of the forum for you to share your creations: Orion Content Exchange Make sure you post here so that it gets the most visibility! Kind regards, Marlie Fancourt | SolarWinds Pre-Sales Manager Prosperon Networks | SolarWinds Partner since 2006 If this helps answer your…

Hi there, Here's a report that I exported from our platform that should help get you started, screenshot below: It uses the intrinsic property 'IsServer' to differentiate between Network and Server Nodes, and uses a Custom Property that I've called ServiceTier (1 = Critical, 2/3 = Production, 4 = Dev, 5 = Test) to…

Hi there, Have you tried adjusting this with a custom poller instead? It should be a better way of doing things compared to updating .DLLs and system tables, as they will change every time the configuration wizard is ran. There's a helpful KB article on this that should get you…

If you are running from SMSS you may have to prepend '[SolarWindsOrion].' to each of the the table names, or you can use the SW Database Manager like I did to run the queries: https://support.solarwinds.com/SuccessCenter/s/article/How-to-Run-a-SQL-Query-in-Orion-Database-Manager-on-Windows-Server-2008?language=en_US

Hi there, I've exported one of the reports that we use that might be a good starting point for you? A screenshot is below: [View:/cfs-file/__key/communityserver-discussions-components-files/4/Interface_2B0025002B00_Traffic_2B002D002B002B00_Last_2B00_7_2B00_Days.xml:640:480] Kind regards, Marlie Fancourt | SolarWinds…

Hi there, the 'p' is a pretty common alias format in SQL, where are you checking this? You can add 'AS' between the table name and p if you prefer: UPDATE [dbo].[Pollers] AS p Read more: dba.stackexchange.com/.../95777

Hi there, Yes, technically the polling will stop but we are essentially trying to do things as cleanly as possible by removing anything left over from the DB too, as otherwise you may run into issues later down the line. 

Hi there, If the packet loss is only on the agent port, then it would definitely be worth checking that you have the 'Status and Response Time' pollers set to ICMP, rather than Agent. You can access this by going to the node and going to 'List Resources': This is the most reliable way to monitor status and response time…

Hi there, You can un-manage these by running these queries in order: PLEASE RUN THESE AT YOUR OWN RISK AFTER TESTING, NOT LIABLE FOR ANY PROBLEMS THAT OCCUR First, un-tick all of the pollers whose volumes don't match the name 'Swap Space': --Make a backup of your DB before running ANY UPDATE/DELETE commands UPDATE…

Hi there, @"jm_sysadmin" has done a good job explaining the way that NetPath works and why it's not the right answer here. Looking at your requirements from a higher level, it seems that you want a way to avoid the devices that are having regular packet drops creating too many alerts. We can do this 2 ways,…

SolarWinds is simply returning values from the database based on the query you've created through the UI, I'd be curious to see if the same issue happens when you run the query directly? I've made the SWQL query as close as possible to what you've shown me: SELECT if.Node.Caption as [Node Name],…

Hi there, If you want to get the node custom properties when you are filtering on interfaces you can do the following: First, select Interface in the Dynamic Query Builder and make sure 'Advanced Selector' is on. Then press 'Select field' and in the new window, use the drop down to change from 'Interface' to 'Node': After…

Hi there, I'm not 100% sure of what SolarWinds uses to generate auto-dependencies but I do know that, as a rule of thumb, allowing SolarWinds to tell YOU about your environment is a recipe for dissatisfaction, especially when it comes to something like dependencies that can stop alerts from firing. Based on the original…

Hi there, First off, from your images it looks like you are using the Network Atlas mapping software that is currently in the process of being deprecated by the developers. Depending on your version, you should have the Orion Maps option in the All Settings page which will allow you to create maps entirely through the web…

Hi, Strange question but if you type everything in the User Name field in capital letters does it work? Kind regards, Marlie Fancourt | SolarWinds Pre-Sales Manager Prosperon Networks | SolarWinds Partner since 2006 If this helps answer your question please mark my answer as confirmed to help other users, thank you!

Hi there, SWQL supports the ISNULL function for this exact use case, could you try the following for me: SELECT ISNULL(count(1), '0') as app_count from orion.apm.Application a where a.Node.CustomProperties.Device_Prio LIKE 'Prio1%' and a.Status = '14' This query (with my custom property names replaced) works fine to show…

Hi there, If your goal is simply to have users connect to the web console with their domain accounts, have you tried just creating the domain user in the 'User Accounts' page - for most of our customers this is enough to have everything working without problems:…

Hi there, Looks great to me - don't forget to post this on the Content Exchange section too! https://thwack.solarwinds.com/content-exchange/the-orion-platform/m/reports Kind regards, Marlie Fancourt | SolarWinds Pre-Sales Manager Prosperon Networks | SolarWinds Partner since 2006

Hi there, glad to hear you got it sorted - could you mark my answer above as confirmed as it will help other Thwack Users find their way to the correct answer. Thanks!