ImNishat · L2 Support Engineer - SolarWinds · ✭✭✭✭✭

Somehow, I'm manage to develop one MD for Node Down and now i am working on Interface down. I hope i will finish this too.

Hi @"obaid.rahman" Can you please explain me little bit more. How can i implement below alert in real environment \"status\": \"resolved\ or something like this in the reset condition \"severity\": \"OK\", \"status\": 4

Not installed, I am testing the query directly in the Modern dashboard query section. Below mentioned query is almost showing all the data which i required, except Active alert time and Acknowledge status is not showing. SELECT o.AlertConfigurations.Name AS [ALERT NAME]…

It's showing data, if i remove Where clause or if I add this "WHERE o.AlertActive.TriggeredMessage <> '' But, I need only those active alerts which is related to node down and node ownership is FT

As a reference i paste that SQWL query and the same query i tried in the Modern dashboard but it's not working. I tried a new swql query as mentioned below and it's not giving any error neither any data is not showing.

Oh Okay, No Issue.

I tried using your given idea, but it's now working and showing error as shown below

Hi @"adam.beedell" from where i can get this slides to learn more about the alerts and it's reset conditions.

Sure @"stuartd" I will check the suggested urls and update you. I also did not the coding, but trying to learn SWQL. But the bad things is that i hardly found any resources about the SWQL. Last few days, I am checking your last post which you post almost 3 years back and going through the resources which were shared by…

Hi @"stuartd" , I'm experiencing difficulties in writing a query. Could you assist me by providing a SWQL query that I can use in my Modern Dashboard table widget? On one Modern dashboard, I need to display two types of active alerts as mentioned below: 1. The dashboard should display active alerts for nodes that are down,…

Hi @"Zion.Lamasan" Can you please help me to get the below query works for me as per requirements, I want alert count of Ack & Un-Ack alerts for the specific items like Node down only and with those nodes whose ownership is like =FK Team. How can i do this? SELECT COUNT (AlertObjectID) AS Quantity FROM Orion.AlertActive…

Thanks a lot @"edwinhoekman" it's work as expected.

Thanks for your response.

Hi @"edwinhoekman" Can you please guide me on the below SWQL query. I want to add one customer property in the below query like Ownership = FKT. Using this i want to show only those ICMP nodes whose ownership belongs to FKT. SELECT [n].Caption,[n].IP_Address,[n].Status,[n].DetailsUrl, TOLOCAL([n].LastSystemUpTimePollUtc)…

Yes, Like this as shown in the below Snapshot. But in one table widget and status will change time to time as per ICMP link status. I am able to make, as i shown to you in my earlier response. but the issue is data is not matching as per down or UP status.

I perform this task In Modern Dashboard, for managing node status with clickable link. For this you have to made this type of widget in your Orion page summary. 1st Screenshot. To made this, you have to add status summary widget in the Orion summary page as shown below and edit. Edit the above widget as per your terms…

You wanted to click on Down, critical and warning sections as per your requirement and it should open different page and shows all the related links, Is it?

Thanks @"edwinhoekman" I will review this and provide an update as soon as possible. Apologies for not mentioning earlier that I am attempting to implement this on the Modern Dashboard, and the previous query and results I shared pertain to the Modern Dashboard as well.

Noted...!!! select n.caption, n.IP_Address, si.StatusName, e.EventTime as [Down at] from orion.Events e left join orion.nodes n on n.nodeid = e.nodes.nodeid left join orion.Statusinfo si on si.StatusId = n.Status where e.EventType = 1 and n.status in( 2,1,3,14) Using above query i am able to see, but noticing time…

Hi @"edwinhoekman" I have tried the above query but it's not showing any data, Plz see the below screenshot FYR.

Hi @"edwinhoekman" Thanks for your quick response and it's working as expected. Need one more modification in this, please see the snapshot of the result as shown below. I would like to add an additional column immediately following the 'Node Status' column. This new column should display the last date and time for the…

Hi @"edwinhoekman" I am stuck in SWQL query as mentioned below. I am not good in query. Can u please help to fix the below query. SELECT n.Caption,n.IP_Address,n.Status,n.DetailsUrl FROM Orion.Nodes n WHERE (Caption LIKE '%GRCRY%') I want to monitor those nodes which is polling through the ICMP only.

Sorry for the confusion. SELECT n.Caption AS [Node], n.MachineType, n.DetailsURL AS [_linkfor_Node], -- n.CustomProperties.Environment, --Use this to add in your own custom property n.IP_Address, TOLOCAL(n.LastSystemUpTimePollUtc) AS [LastUptimeLocal] FROM Orion.Nodes n WHERE n.ObjectSubType <> 'ICMP' AND n.Status = 1 AND…

I have validated the few nodes in which showing credentials are failing but when I try to add the same node using the same credentials it's working. 

Yes, and the widget is showing the correct info. My question is how can I fix the credentials issue?

Oh Okay. I will do.

Thank you for your response, It's working as expected.

Indeed, that's correct. However, they have requested an additional column following the status column, where they can view the date and time from which a specific node has been in a warning, critical, or down state. For example, if the node 160.22.x.x is down, they would like the subsequent column to display the time and…

Yes, you're correct. I raised this issue with the support team and they confirmed that it's not supported. I'm not sure if the Aruba switch stack is supported either; I am checking on this.

Thanks for the response@"adam.beedell" The query is currently working and providing results, but it's more suitable for reporting purposes. Could you please review and assist me in creating a query that I can use in a modern dashboard to display the last UP and DOWN status?