Report for triggered alerts past 1 day for 2 specified alerts only

What Information do you need in the report? Here's something that I think is close, its SWQL. 

SELECT 
    AH.AlertObjects.AlertConfigurations.DisplayName as [Alert Name],
    AH.AlertHistoryID, 
    AH.EventType, 
    AH.Message, 
    AH.TimeStamp,
    AH.AlertObjects.EntityCaption, 
    AH.AlertObjects.EntityDetailsUrl, 
    AH.AlertObjects.RelatedNodeCaption, 
    AH.AlertObjects.RelatedNodeDetailsUrl
FROM Orion.AlertHistory AH
Where 
       (AH.AlertObjects.AlertConfigurations.DisplayName like 'Cisco Store Router Down'
    or  AH.AlertObjects.AlertConfigurations.DisplayName like 'Meraki Device Down (P3)' )
    and HOURDIFF(AH.TimeStamp , GetDate()) < 24 -- last day in hours
    and AH.EventType = 0 -- Event for alert trigger
Order By AH.TimeStamp DESC

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

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

If you want the count, then try: 

SELECT 
    Count( AH.AlertHistoryID) as [Alerts Triggered]
FROM Orion.AlertHistory AH
Where 
       (AH.AlertObjects.AlertConfigurations.DisplayName like 'Cisco Store Router Down'
    or  AH.AlertObjects.AlertConfigurations.DisplayName like 'Meraki Device Down (P3)' )
    and HOURDIFF(AH.TimeStamp , GetDate()) < 24 -- last day in hours

    and AH.EventType = 0 -- Event for alert trigger

Need to add also the following alert name - 

Not sure on swql structure for this 

SELECT
    AH.AlertObjects.AlertConfigurations.DisplayName, 
    Count( AH.AlertHistoryID) as [Alerts Triggered]
FROM Orion.AlertHistory AH
Where 
       (AH.AlertObjects.AlertConfigurations.DisplayName like 'Cisco Store Router Down'
    or  AH.AlertObjects.AlertConfigurations.DisplayName like 'Meraki Device Down (P3)' )
    and HOURDIFF(AH.TimeStamp , GetDate()) < 24 -- last day in hours
    and AH.EventType = 0 -- Event for alert trigger
Group By AH.AlertObjects.AlertConfigurations.DisplayName

Is this what you mean? Group counts by name

sorry i didnt make it clear enough i need the following alert added into the swql as well 

Meraki Device Interface Down (P3)

so basically, it will report on 3 alerts 

I missed the word interface, thought it was the same, sorry 

SELECT
    AH.AlertObjects.AlertConfigurations.DisplayName, 
    Count( AH.AlertHistoryID) as [Alerts Triggered]
FROM Orion.AlertHistory AH
Where 
       (AH.AlertObjects.AlertConfigurations.DisplayName like 'Cisco Store Router Down'
    or  AH.AlertObjects.AlertConfigurations.DisplayName like 'Meraki Device Down (P3)' 
    or  AH.AlertObjects.AlertConfigurations.DisplayName like 'Meraki Device Interface Down (P3)' )
    and HOURDIFF(AH.TimeStamp , GetDate()) < 24 -- last day in hours
    and AH.EventType = 0 -- Event for alert trigger
Group By AH.AlertObjects.AlertConfigurations.DisplayName

Works a treat - thank you 

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,
AH.AlertObjects.RelatedNodeCaption,
AH.AlertObjects.RelatedNodeDetailsUrl
FROM Orion.AlertHistory AH
Where
(AH.AlertObjects.AlertConfigurations.DisplayName like 'Cisco Store Router Down'
or AH.AlertObjects.AlertConfigurations.DisplayName like 'Meraki Device Down (P3)'
or AH.AlertObjects.AlertConfigurations.DisplayName like 'Meraki Device Interface Down (P3)' )
and HOURDIFF(AH.TimeStamp , GetDate()) < 24 -- last day in hours
and AH.EventType = 0 -- Event for alert trigger
Order By AH.TimeStamp DESC

thanks

Try adding the Count as another property. 

SELECT
AH.AlertObjects.AlertConfigurations.DisplayName as [Alert Name],
Count (AH.AlertHistoryID) as [Alerts Triggered],
AH.AlertHistoryID,
AH.EventType,
AH.Message,
AH.TimeStamp,
AH.AlertObjects.EntityCaption,
AH.AlertObjects.EntityDetailsUrl,
AH.AlertObjects.RelatedNodeCaption,
AH.AlertObjects.RelatedNodeDetailsUrl
FROM Orion.AlertHistory AH
Where
(AH.AlertObjects.AlertConfigurations.DisplayName like 'Cisco Store Router Down'
or AH.AlertObjects.AlertConfigurations.DisplayName like 'Meraki Device Down (P3)'
or AH.AlertObjects.AlertConfigurations.DisplayName like 'Meraki Device Interface Down (P3)' )
and HOURDIFF(AH.TimeStamp , GetDate()) < 24 -- last day in hours
and AH.EventType = 0 -- Event for alert trigger
Order By AH.TimeStamp DESC

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