flackovic · SolarWinds Engineer · ✭✭✭✭✭

Shameless plug for my old feature request - allowing upload of multiple Status Icons at once versus manually browsing for each individual status of elements on an Intelligent Map. Orion Maps - Allow Folder Import for Status Icons

Excited to finally be attending my first SWUG event since it's so close to home! It's not exactly close (1.5 hour drive), but the NC Zoo is well worth the visit if you're any bit at all interested in that sort of thing and you don't mind staying an extra day. 

I agree. I find myself using rectangles to underline titles of maps as well, since there doesn't appear to be a way to underline text, despite there being a Bold and Italics option (I'm still using 2020.2.4 though so YMMV). As a quick work around for now, I find that using rectangles set to a pretty low height (2-5 px)…

 @"nerengm" They are the same. So far, I've seen the following all used to refer to the new map style: SolarWinds Maps, Intelligent Maps, Orion Maps.

If you have access to SAM, you can use the following templates to monitor these services within SolarWinds: Orion Observability - Main Polling Engine Orion Observability - Additional Polling Engine Orion Observability - Addition Website We have ours set up to monitor each type of server and use the following SWQL to check…

Instead of: ,o.NodesCustomProperties.Department AS [RESPONSIBLE TEAM] What happens if you use:,o.Node.CustomProperties.Department AS [RESPONSIBLE TEAM] This should use the proper navigation property.

Hey, sorry for the late reply. This should work for you: SELECT Count (N.Status) as value, N.CustomProperties.Country AS Country FROM Orion.Nodes N WHERE N.Status IN ('1') AND N.CustomProperties.Country != 'Cloud' GROUP BY N.CustompProperties.Country COUNT is an "aggregate" function, so you need to tell it which field to…

This is likely going to be very difficult to troubleshoot without the full code, it looks like you've truncated some of the scripts and external calls. What I can say - I would double check your script tags. One of the ending tags is incorrect (should be "</script>" for the ajax.googleapis.com script). Look at these lines…

I think I may have found a solution that could work for this by adapting this old tutorial I've used in the past: HERE The actual post itself is pretty dated, so here is a list of steps I took to achieve the desired outcome: Step 1: Create "foo.js" On each web server, create a file called "foo.js" (or whatever you want,…

What is the intended widget for this query? It sounds like a problem using a Custom Table, perhaps within a report? It runs fine in my environment with a Custom Query widget. If you would like to use this in a Custom Table widget, it would need to be tweaked as such: SELECT n.Caption AS [Node Name] , n.DetailsURL AS…

This is what I'm currently using on one of my Modern Dashboards. I've added the 'FT' organization component, but you'll need to check and make sure the CustomProperty is updated to reflect what it is in your environment(s). Change both instances of '[Nodes].CustomProperties.Ownership' to whatever you need to. SELECT…

Did you ever figure this one out? I don't have those CustomProperties in my environment, but I believe your Global_Department criteria should be encased in parenthesis since there is an "OR" in there. (Nodes.CustomProperties.Global_Department = 'Network' OR Nodes.CustomProperties.Global_Department = 'Generating') AND…

NodesCustomProperties values are already contained within the Nodes table as a Navigation Property, so you can avoid the JOIN altogether here. Something like this should work: SELECT N.DisplayName AS NodeName, N.IPaddress AS IPAddress, N.Status AS NodeStatus, N.CustomProperties.Country AS Country FROM Orion.Nodes N WHERE…

Good luck on this endeavor! I always wished there was more SW YouTube content out there aside from the official SW channel. You've already showcased some impressive work!

Here are a few we use in our org for Nodes: * Cust_VIP - Denotes if the "customer" or users are considered VIPs. This establishes priority for alerting, outage response, etc. If Cust_VIP = True then Device_Priority = 1. * Device_Category - Usually denotes the overall category of a device such as Network or Server *…

You could potentially do this using an iframe, but I would be unable to test in my environment because my instance doesn't talk to the Internet. I have used iframes in the past to display graphs and resources from detail views on a standard dashboard where they are traditionally unavailable. The problem you might run into…

I wasn't able to find a simple solution in SWQL Studio, but you can run SQL queries using SWIS by using the Orion.Reporting ExecuteSql verb. A short example in PowerShell: $result = Invoke-SwisVerb $swis 'Orion.Reporting' 'ExecuteSql' "SELECT CachedTime FROM [dbo].[NodeListResourcesCache] WHERE NodeID = XXXX"…

What does the following query return for you? I only spot checked this against one of my devices using EIGRP, but it seemed to return the neighbors that were no longer available when compared with the "Routing Neighbors" widget on the Node Details -> Network tab. Replace line 5 with your actual custom property information.…

I think I stole this method from someone else on thwack in the past, but this is typically how I perform Day/Hour/Minute for any custom SWQL widgets of mine: SELECT n.Caption , n.LastBoot , CASE WHEN TOSTRING(FLOOR(HOURDIFF(n.LastBoot,GETUTCDATE())/24.0)) <> 0 THEN…

I was playing around with this today, but I wasn't able to get anything to show for the status icons. I'm sure the "entity" in "entity formatting" is a hint to what kinds of resources are supposed to be used with this widget, but I couldn't figure it out with limited testing. Some documentation from SW would be great on…

From what I've seen, this isn't possible right now with nested maps. This is one of the features missing from the old Atlas maps, where you could just click through to each layer. I either use the dropdown in your image, or I click on the next layer in the sidebar of the Map view.

What web report are you looking at? Is it out-of-the-box or custom? I did try your query against my database and I noticed that the query does not line up with the Availability widget on the node details screen, but I was going off of "This Month" instead of today with business hours. It's possible the SW definition of…

Fear of change and being slow to adopt new technology is the biggest roadblock in my experience. At my organization, we have processes and procedures that have been in place for decades, and engineers/management that have been here almost as long. Change can be hard, especially in an IT environment where emphasis is placed…

No worries! Glad you got it removed. Funny enough, I just ran into this yesterday in my environment. Deleted an alert that was "active" for over 3,000 days. 

Do you see this alert in your Alert log if you follow these steps? You should be able to clear the alert from there. How to clear triggered instance of alert from the Orion Web Console (solarwinds.com) Also, the name of your device is in your screenshot under the "Message" in the Alert Status Overview widget. Just in case…

Looks great! I do something similar in my environment with PowerShell and the API. My process is a bit more ad hoc since we don't routinely take down entire groups... but if I did, this would be exactly how I'd do it. Thanks for the write up! 

Hello! You could create a custom Report using a Custom Table or Custom Query resource using a query similar to this: SELECT TOP 100 Name , Description --, Enabled , AccountID , LastRun --, SchedulesData , CASE WHEN SubString(SchedulesData, (CharIndex(':', SchedulesData) + 1), 4) = 'null' THEN 'Specific Date(s)' ELSE…

Hello! Are you trying to schedule an NCM Job or a Network Discovery job? If you're attempting to run an NCM job, one solution would be to write a PowerShell/Python script using the ExecuteScript verb on the Cirrus.ConfigArchive entity, and run it via the Task Scheduler on Windows using the "Monthly" frequency: You can find…

I did some initial testing in my lab with a dummy alert I set up. Please add this to your e-mail message body: ${N=SWQL;M=SELECT VCenterName FROM Orion.VIM.VirtualDisks WHERE VirtualMachineID = ${N=SwisEntity;M=VirtualMachine.VirtualMachineID}} That should pull the VCenterName record from the Orion.VIM.VirtualDisks table…

Hello! I'd love to take a crack at this! Do you mind sharing your alert Trigger Condition page, if possible? That will let me know what you're already working with and what conditions you're looking to alert on. Feel free to PM me on thwack if you don't feel comfortable posting on this post.