tony.johnson ✭✭✭✭✭

My bad, 100% user error and not checking what I had pasted. The updated query should work well.

This should replace everything after the WHERE clause in your query i.e lines 21, 21 & 22 in your examples to become SELECT Round(Avg(([data].[ContainerStatus].PercentAvailability)*1.00), 3) as [Average Percent Availability] , Case When MONTH( DateTrunc('Month', [data].[ContainerStatus].DateTime) ) = 1 Then 'Jan' When…

I don't have immediate access to enough historical data to test right now, but if you could validate this may work for Last Month. <span class="s19">datetime</span><span class="s0"> </span><span class="s10"><</span><span class="s0"> </span><span class="s19">DATETRUNC</span><span class="s10">(</span><span…

Is it possible that you need to include the year in the query? i.e you may be seeing values for multiple years when calculating the specific month. 

Thanks, could you help me understand this a little more? I am using the following query to create a pie chart with 6 values select Count_Items, Status from ( select top 1 1 as Count_Items, 1 as Status from orion.nodes ) UNION ALL ( select top 1 2 as Count_Items, 2 as Status from orion.nodes ) UNION ALL ( select top 1 3 as…

Could you share the details of these reports to help run these down?

Thank you for such detailed feedback. I am sorry for the problems these have caused you and the time you have invested into resolving these. We are working to fix these issues as soon as possible. I would like to share our plans for these and to understand some of your specific needs in more detail. 1. Space or / in the…

Hello, Although we do see RabbitMQ issues that vary in nature, I am not aware of any issue specific to 2020 versions exactly as you describe. There have been a number of 2020.x.x releases, do you know which version you are running? If you could share any support case number with me for reference that would also help.…

For Yesterday SELECT Availability, Status, Color FROM ( SELECT ROUND(AVG( rt.Availability),2)as Availability, 'UP - ' + SubString(tostring(DATETRUNC('day',GETDATE()-1)) ,0,12 ) as Status, '#30b230' As Color FROM Orion.ResponseTime rt WHERE rt.node.customproperties.city='Cork' AND datetime < DATETRUNC('day',GETDATE()) AND…

here is the same query for the previous day SELECT Availability, Status, Color FROM ( SELECT ROUND(AVG( rt.Availability),2)as Availability, 'UP' as Status, '#30b230' As Color FROM Orion.ResponseTime rt WHERE rt.node.customproperties.city='Cork' AND datetime < DATETRUNC('day',GETDATE()) AND datetime >…

can you show the output of the query when creating the widget data model?

If you would like to have the Avg % UpTime and Avg% Downtime for a single city on a pie chart then this query can be used to create the following chart select Availability, Status, Color FROM ( SELECT ROUND(AVG( rt.Availability),2)as Availability, 'UP' as Status, '#30b230' As Color FROM Orion.ResponseTime rt WHERE…

Pie charts cannot have multiple values which span columns, and each row in the data model typically represents a segment of data. Consider the following output Avg % UptimeAvg % DownCity1000Limerick80.0519.95Cork0100Waterford1000Kerry The pie chart can use the Avg % Uptime OR the Avg % Down for the values in the chart and…

If I understand correctly, you want to see the date for the availability this month and last month in a table? Is this then a daily report and not a monthly report? i.e Do you want to see a date for every day in the previous month and this month?

this will work for your needs here is the example for last month's data, for this month remove the -1 from the where clause. SELECT ROUND(AVG( rt.Availability),2)as AA, rt.Node.CustomProperties.city FROM Orion.ResponseTime rt WHERE rt.Node.CustomProperties.City='Cork' AND month(datetime) = month(GETDATE())-1 AND…

Where do you intend to use this data? Is it a modern dashboard or Orion web-based report? Also over what time period are you looking to get the data? Keep in mind that you will be averaging averages as you will have a value for each node which you will be grouping by City. 

Thank you for reporting this. While I am not immediately certain what has changed here, the output of your query can be adjusted query to select round(avg(orion_responseTime_availability_avg),2) as Net_Avail

This is indeed a result of HTML sanitization. We are tracking this under CORE-17460.

Discovery will only work on I.P networks. If the I.P managed device has data on other devices connected to using something like SCADA, it may be possible to see stats. 

I have resolved this by following the steps described here https://support.solarwinds.com/SuccessCenter/s/article/Resources-missing-while-attempting-to-add-them-to-Orion-Web-Console-view?language=en_US 

Alert limitation categories that are applied to the user account which is viewing the dashboards will be handled by SWIS i.e you do not need to modify your query. If you have created alert custom properties you will need a little bit more in the query to look at the alert configuration and customproperties entities and…

@"abertacca" Can you please share the case number with me? The table widget has had a number of improvements with this release including. We are aware of the visual discrepancy between the preview and the configurator when re-ordering columns which is now done via drag and drop and are working towards a fix as soon as…

Is the necessary routing in place from your workstation subnet to the server subnet What is the output of ipconfig /all from the workstation? what is the output of tracert 10.255.10.4 from your workstation. If this is a VM have you checked the configuration there to ensure everything is correct?

Hello, As a start, the service graph connector may be of interest here https://docs.servicenow.com/bundle/quebec-servicenow-platform/page/product/configuration-management/concept/cmdb-integration-solarwinds.html Is this is a new or existing deployment? Do you have any questions on deployment options or are there any…

There are a few things to check. 1. Is the Windows Firewall enabled on the server? If so it may have an enabled rule for ICMP . This alone would not prevent remote access to the web console. 2. Launch the 'Orion Web Console' from the start menu on the server and note the URL. Are you able to connect to the noted URL from…

Thanks for the context. Here is the SWQL query I used. [View:/cfs-file/__key/communityserver-discussions-components-files/4/All-Active-Alert-Dashboard-Widget.txt:320:240]

Are you creating a modern dashboard for this purpose? Would something link this work? Note, clicking the acknowledge link does not allow you to enter the notes.

This is one of those rare moments where I get to deliver good news, it is my pleasure to show you the Orion Platform 2020.2.5 Table Widget with sorting and search. And as an added bonus notice how after saving the data model, the fields are automatically added to the table configuration.…

Nodes can be in this state for a number of reasons. You may be using enhanced node status which you can learn more about here https://thwack.solarwinds.com/resources/b/product-blog/posts/orion-platform-2019-2---enhanced-node-status

NPM 10.7 is EOL since March 2017. Is there any reason you aree using such an old version?