Comments
-
Dear Thanks , CAn we get the data in milliseconds format please ?? Appreciate your help in this regard.
-
can u pls help me to mofiy the same below query to fetch the last 7 days transaction please .. SELECT TOP 50 n.Caption,n.PercentMemoryUsed,n.LastBoot,n.Status,n.CPULoad,n.DetailsUrl FROM Orion.Nodes n WHERE (Caption LIKE '%FYHA-WLEF%' OR Caption LIKE '%FYHA-WAPC%' OR Caption LIKE '%FYHA-WSER%' OR Caption LIKE '%FYHA-WSPN%'…
-
Or Same Data which happend last 7 days time , thatsalso fine.
-
Thanks , Yes Percentmemoryused and cPU load for last 7 days , that will be good enough , Can you please help me with the Modified Query .
-
I have 26235 Entries .
-
Dear i had tried your query , when i executed urs which include nodeid i am getting errror as bleow , using previous query not getting any error , can you please advice .
-
i am new to this platform , can u help me with the complete query pls
-
can u pls help with the query pls wher to add this entitynetobjectid in the above query ?
-
Attached the output of the above query
-
Thanks , This shows severity of the active alerts , How do we modify the query as the below , Historical severity data of alerts happened in last 1 week or weekly basis ? CAn you please help
-
attached the snapshot of the existing query to fetch severity. attachment fyi. Once i get aggregated data ......i can feed ito create pie chart .
-
Dear Christopher , Thanks for the response , I have the below query to fetch the severity of the active alerts , SELECT o.AlertActive.TriggeredDateTime AS [ALERT TRIGGER TIME] ,CASE WHEN o.AlertConfigurations.Severity = 1 then 'Critical' WHEN o.AlertConfigurations.Severity = 2 then 'Serious' WHEN…
-
Can you also share the sQL query to fetch severity of all ACtive Alarms
-
Thanks for your response , Can you share the SWQL Query for fetching the active alerts - weekly basis pls
-
dears , Can you please help me on this ?
-
Dear , Thank you so much for this information , One query , Can you help me with the query which gives total no of active alerts in numbers ? so that i can feed that to grafana , Thanks a ton in advnace .
-
This is the seperate query gives node region , SELECT TOP 1000 NodeID, Building, City, Comments, Department, Device_Severity, Device_Type, GPS, HW_EOL_DATE, Network_Segment, OS, OS_VERSION, PRODUCT_ID, RACK_Location, Region, Site_Type, Technology_Group FROM Orion.NodesCustomProperties how do we incorporate and make it in…
-
OBserving Error as attached , CAn you please look into it brother
-
how do i incorporate custom property (node region ) with this existing query
-
Thanks a ton brother, How can i add node region in the query ? need to fetch node region details along with the existing data , can u advice please
-
Dear Christopher , Using this query (generated from SWQL studio) , able to fetch active alerts in the system , SELECT TOP 1000 AlertActiveID, AlertObjectID, Acknowledged, AcknowledgedBy, AcknowledgedDateTime, AcknowledgedNote, TriggeredDateTime, TriggeredMessage, NumberOfNotes, LastExecutedEscalationLevel FROM…
-
Thanks for the information , what i failed to fetch is Active Alert and its severity in the same query ? i am stuck with this, Can you please help me with some query fetching active alerts and its severity and node pls
-
Any Documentation reference to follow these similar integration with Grafana ?
-
Hi , Thanks for the info , How about the severity ?
-
Thanks Christopher for the info , Can you give some sample query format ..for alert active and severity and node id please ?
-
Thanks a ton for the valuable information , I am trying to query the below parameters (Active Alarms , relevant Node details , its Severity and Region etc.) ...From the documentation active alerts can be fetched from this details [Orion.AlertActive ] in the above table , i am not able to query relevant node details ,…