bobmarley ✭✭✭✭✭

Probably NPM and Netflow would be a starting place. Take a look at this online demo SolarWinds Hybrid Cloud Observability Demo Login | SolarWinds Demo MY DASHBOARDS -> NETFLOW -> NTA Summary to look at the network items For File Systems on the main page expand some of the groups out under All Nodes and click on a node to…

It is still failing. If I run this SWQL Query here are the results. SELECT TOLOCAL(EventTime) AS LocalEventTime, Message, EventType FROM Orion.Events Where Message LIKE '%Starting Nightly Maintenance%' OR Message LIKE '%Nightly maintenance failed%' OR Message LIKE '%Nightly Maintenance Completed%' Order by EventTime DESC…

Thanks! I will look into that. 

On mine the icon is in the upper right of the Node Details page But if you click on it you get this. So the feature is there but not functional. Maybe they will update it. 

Maybe check the Orion.Events table and see if each individual component monitor output is logging into the table. If they are perhaps you could create a custom SWQL alert to include multiple events. 

Maybe try this. GO to your Manage Nodes Screen. Change Show Nodes to Interfaces Type in Loop in the search bar and click Search Put a checkbox on several loopback interfaces and click Edit Properties Check Bandwidth, then Custom Bandwidth, then enter whatever number you want. When you are done click Submit

Where [OAH].TimeStamp >= GETUTCDATE() - 14Change above to - 7 for a single week, mine was for 2 weeks.

I got most of this somewhere off Thwack. It may get you started. SELECT --TOP 25 COUNT( AlertHistoryID ) AS [Alert Count] , oah.AlertObjects.AlertConfigurations.DisplayName AS [Alert Name] , oah.AlertObjects.RelatedNodeCaption AS [Node Name] , oah.AlertObjects.EntityCaption AS [Alert Entity Name] ,…

This should include the URL SELECT Groups.Name AS Name, Groups.DetailsURL AS [_LinkFor_Name], Groups.UnManaged --[Groups].CustomProperties.DisplayName FROM Orion.Groups Where Unmanaged <> False

Setting up the custom widget is on the right hand side of the URL I posted above

Maybe this? Groups.CustomProperties.Group_Under_Maintenance like 'Yes' My All Groups resource doesn't support SWQL filters so maybe you are on another resource? I don't have Groups custom properties set up but this query may get you started if you want to try creating a custom query widget instructions are on the right…

Nodes.CustomProperties.Group_Under_Maintenance NOT LIKE 'Yes'

If you are looking for a graph over a period of time you may want to try adding the widget called Custom Chart. It would appear like this. You can select the time period and interfaces. 

Maybe take a look at this Adjusting the SWIS execution time out values (solarwinds.com)

You are missing a closing } on what you posted above. That may be a cut/paste error. There are a few examples you could download in the Content Exchange here. There are also several examples on your local system under Admin - Settings- Sam Settings - Component Monitor Library There are some logs you can check if you enable…

This may get you started. Try putting your switch name in the query below. This is for the Inlet Temp. There are several other sensors on the switch that measure temperature as well. SELECT TOP 1 hib.FullyQualifiedName, ((hivs.AvgValue*9)/5)+32 AS AvgFValue FROM Orion.HardwareHealth.HardwareItemValueStatistics hivs JOIN…

Give this a try. Select Count(n.status) AS Cnt, s.StatusName, [n].CustomProperties.CloudTeamDevice FROM Orion.Nodes n RIGHT Join Orion.StatusInfo s ON n.Status = s.StatusID WHERE s.StatusID IN (1,2,3,9) AND [n].CustomProperties.CloudTeamDevice LIKE '%YES%' GROUP By n.Status,s.StatusName,s.StatusId,…

A couple comments: There should be an unmanage utility on your Solarwinds server under Start - Solarwinds Orion - Unmanage Scheduling Utility which could accomplish some of what you need. There are several unmanage examples on Thwack, this may help you get going. How To: Powershell - Unmanage Nodes with future unmanage and…

I asked support if it would be ok to manually remove these from the DB using a SQL command. Waiting for a reply. This worked in my Test environment but waiting for Support to verify it's ok before doing it in Production. --DELETE FROM [dbo].[Events] SELECT TOP 1000 * FROM [dbo].[Events] Where Message LIKE '%Background…

Yes it does.

Doesn't seem to be an issue. "This is known issue or bug in 2023.1 and hopefully will be fixed at 2023.2 version. Looks like it continues getting events. No source or affected application monitor. It's just events that continues pop up causing false information. Workaround: - open the database manager from your SolarWinds…

I am getting the same opened up support case #01303434

Hubble may be of interest to you (1) Find code behind existing widgets - Orion SDK - The Orion Platform - THWACK (solarwinds.com) Also in SWQL Studio if you use with QUERYSTATS in your From statement you will get an extra tab that shows the SQL query. Example: SELECT TOP 100 name, description FROM…

This should work for you :) Good point on the non-english installs. FROM Orion.Events Where Message LIKE '%Starting Nightly Maintenance%' OR Message LIKE '%Nightly Maintenance Completed%' OR Message LIKE '%Nightly Maintenance Failed%' Or EventType LIKE '5100' Or EventType LIKE '5101' Or EventType LIKE '5102' Order By…

I was using this as version 2020.2.6 had a bug and couldn't use the GUI to upload the CP's. Really didn't care about the speed as it runs on our automation server which sits there full time syncing Orion with our other tools. If you rewrite it to run faster please upload the code used. 

Using the API is very slow, but it can be done. Here are the sanitized versions of what I use to first Export all of the custom properties then Import them back in. Try this in a TEST environment first and work out any bugs first before using in your production environment. You will need to enter your Orion server name and…

SELECT Distinct TOLOCAL(ST.EventTime) AS [Start Time] ,TOLOCAL(ET.EventTime) AS [Finish Time] ,CONCAT(--Downtime formatted (CASE WHEN (SECONDDIFF(ST.EventTime,ISNULL(ET.EventTime, GETUTCDATE()))/60/60) >= 1 --Hours THEN CONCAT(SECONDDIFF(ST.EventTime,ISNULL(ET.EventTime, GETUTCDATE()))/60/60%24, 'h ') ELSE '' END), (CASE…

Something to note, the event ID's changed on version 2023.1 so if you had SWQL queries that used them you will need to make that change to them. SELECT TOP 1000 TOLOCAL (EventTime)as EventTime, Message, EventType FROM Orion.Events Where Message LIKE '%Starting Nightly Maintenance%' OR Message LIKE '%Nightly Maintenance…

Something to note, the event ID's changed on version 2023.1 They are now 5100 and 5102 so you will need to change the query to reflect those values. Nightly Maintenance Completed5101Starting Nightly Maintenance5100

Upgraded ours this week and everything went fine. The only issue so far is the database maintenance errors.