timt ✭✭✭✭✭

Hello, I do understand that there's a reset action. In the event if I get 5 node down alerts but only 3 comes back up, which leaves 2 still down. It becomes hard to track which node came back online, in which case you would have to log into SW to find out. Just trying to skip that step to see if there's some sort of…

It's down now?

any updates on this feature? Can't fit in the column message 

I guess I may need to call in support for this. Some availability data calculated, whether it be true or not is solely up to the discretion of the user. I just want an easy way to edit this data.

That's giving it as an example. I would want to edit some node downtime when... the cause of the node down was a direct result of an ISP outtage, or the node was in maintenance as an example.

Sorry for the lack of details.... here it goes, and thanks in advance. So I run a simple availability query below, in the 'WeightedAvailability' column, I want to edit a few of them, like from 0 -> 60% as an example. Can I do this on the backend of the database and if so, where should I start? SELECT N.Caption,…

Hi Brian, Thanks for the suggestion.. Having to disable with the backend DB is not efficient. If I did need to disable this, then I would just unmanage the pool. Also, having an additional trigger condition to not alert on pools that are 'not running' does not work as well. I end up getting alerted for all App Pools.

Hey dxwhite, can you shore the web calls to monitor SAP?

It's just this query. Added this into the custom query. select parent_container_name, parent_containerid, p.parent_comments, child_container_name, child_container_id, c.Container.CustomProperties.Comments as child_comments, c.entityid as nodeid, c.name as caption, n.CustomProperties.OS_Admin as Node_Admin,…

Thank you! Mucho Gracias! This will work!

You're both correct For my workflow, I use this script for the NOC views, as it's displayed on the screen with no access to keyboard nor mouse. Within this NOC View, i added several of the same query, but each one only showing specific Node Down and Application Down from each view. This keeps the "other alerts" from out of…

m-milligan​ can you take a SS of how to do this? I have the same SWQL version, but do not have a 'right-click' to-update option.

SELECT cpName, cpValue FROM ( Select convert(varchar(50), [OWNER1]) as [Owner 1] ,convert(varchar(50), [PRIORITY]) as [Priority] FROM nodescustomproperties Where nodeid = ${NodeID} ) as ncp unpivot ( cpValue FOR cpname IN ( [Owner 1] ,[Priority] ) ) as unpvt

I would assume it applies. Is there any other way to get this into excel, since all the custom tables can be very lengthy.

Thanks for the info. I tried this below, but it's giving an invalid query. SELECT cpName, cpValue FROM ( Select convert(varchar(50), [CI_Owner] as [CI_Owner] ,convert(varchar(50), [CI_Key_Functions] as [CI_Key_Functions] FROM nodescustomproperties Where NodeID = ${NodeID} ) as ncp unpivot ( cpValue FOR cpname IN (…

Could you provide any sample of the ToLocal function or how I might add this into the current query? Sorry I'm just barely getting into this swql, and it looks complex. Thanks in advance.

That did the trick! You are the best!

TDanner, you are correct, the group gets summarized right when it gets created... so the availability for it does not work as intended. I guess my other option is to manually create them via the web writer (manually). Thanks again!

Ahh I get it! Thanks for your support, it's been very .. enlightening! SELECT o.TimeLoggedUtc, o.AccountID, o.AuditEventMessage, n.DisplayName, o.AuditingActionType.ActionTypeDisplayName, cp.OS_Environment, cp.os_admin, cp.site_name FROM Orion.AuditingEvents o left JOIN Orion.Nodes n ON o.NetworkNode=n.NodeID left join…

Select Datasource, select 'Advanced Database Query (SQL, SWQL) and choose the "SQL" radio. Then enter the SQL Query below. To create the tables, create the custom property you would like to, i.e. 'NODESCUSTOMPROPERTY_NAME1', as "NAME1", and make sure you also have the same entry as shown below. Also, make sure to change…

Is there a new version of SWQL that can update directly to the DB? I ran the query and does not have a 'right-click' option to update.

I never thought possible until now... This will work wonders, being able to show the Container names, with it's member, OS, Environment, and Availability all in 1 row. Thank you so much! zackm

Are there any work-around for this? To be able to take a snapshot of the process, just like the top xx application alerts, to display on the node detail views?

There's no options to export to excel...

I just tried this, and it looks to be triggering off some old 'muted and old scheduled muted events'. Any ideas on how I can filter this? Thanks much.

Thanks m-milligan, this will help have some immediate transparency when someone mutes the alert.

TDanner, thanks for the info/advice like always. I don't know how complicated this will get into the future if I build on this alert if possible: nodes.status = down os_admin = 'windows server' cp.mute is not true gcp.mute_group is not true Thank you for your support!

ekis can you show me that SQL code to pivot. Thanks!

Hey thanks TDanner for your help, much appreciated. Is there a way to get the query to show current Pacific Time, or exactly as recorded?

Thanks Martin, do you have a sample query to do the match based on IP%port pattern that you can share, please?