basilfernandaz

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 ,…