jasonf1971 ✭✭

Thats what i was after - thank you very much

hi was after a physical list rather than some swql - there was a list on here somewhere but i couldnt find it - many thanjs

Thank you

Can you share the swql for hardware health please - thanks 

Thank you 

Thank you 

Thank you 

Thank you 

ok - so i need an amendment to the swql for nodes down to not include the following - CoreProductionSystem Noat the moment the swql is pickining up nodes and i only need Live nodes (CoreProductionSystem Yes)thanks 

Any help on the swql for hardware health overview would be really appreciated thanks 

SWQL does not work - query is not valid 

SWQL does not work - query is not valid 

Could i have the swql for this please - thanks 

sorted it - thanks 

hi - i might be having a moment here but it doesnt like the code for the ticket status

Also which widgets should i be using for this - thanks 

this is what the report looks like using the above This is what it looks like when re-verted back 

Its a strange one i have gone back 300 hours and it still not picking up the meraki devices down but no issues with the other 2 alerts 

Yep i changed the time to 48 hours just to test 

Have tried the above but for some reason it just not picking up the alert count for meraki device down

i have tried adding the alert triggered table to the report, but it is only picking up one of the alert names instead of 3 

Hi - have tried the above but its not giving me any alert count 

anyway we can add the alert Count to the following swql - Count( AH.AlertHistoryID) as [Alerts Triggered] SELECT AH.AlertObjects.AlertConfigurations.DisplayName as [Alert Name], AH.AlertHistoryID, AH.EventType, AH.Message, AH.TimeStamp, AH.AlertObjects.EntityCaption, AH.AlertObjects.EntityDetailsUrl,…

Works a treat - thank you 

so basically, it will report on 3 alerts 

sorry i didnt make it clear enough i need the following alert added into the swql as well Meraki Device Interface Down (P3)

Need to add also the following alert name - Meraki Device Interface Down (P3) Not sure on swql structure for this 

Just how many times over the past 24 hours the alert triggered 

SELECT [Nodes].Caption , [Nodes].DetailsUrl , [Nodes].VendorInfo.Icon , [ResponseTime].Day , [ResponseTime].Availability , [Downtime].MinutesDown , [Downtime].CalcAvailability , [Events].RebootCount -- To add Node Custom Properties use: -- , [Node].CustomProperties. FROM Orion.Nodes AS [Nodes] INNER JOIN ( SELECT…

Please see below codes [View:/cfs-file/__key/communityserver-discussions-components-files/46/ITEM_2B002D002B00_H_2600_B_2B00_Stores_2B00_Currently_2B00_Down.xml:640:480]