How do I get a list of my Logic App Recurrence Triggers across all of my Logic Apps?

Recently I saw Kent commenting on Jays post about the scheduler feature in the Power Automate toolkit which looks pretty awesome.

https://www.linkedin.com/posts/jpadimiti_scheduler-activity-7031751499391094784-dzCG?utm_source=share&utm_medium=member_desktop

https://microsoft.github.io/powercat-automation-kit/features/scheduler/

As a Logic Apps user it gave me the idea that I bet I could write a kusto query for Azure Resource Graph which would tell me a list of all Logic Apps which use the recurrence trigger and then I could project out the details of the trigger to see what runs daily, weekly and the start time and also if the Logic App is enabled or not.

I end up with the below table

Below is the query I used. You might need to tweak the filter for your resource group.

resources
| where type == "microsoft.logic/workflows"
| where resourceGroup == tolower("mikes-rg")
| where properties contains "recurrence"
| extend state = properties.state
| extend trigger = properties.definition.triggers
| extend triggerType = properties.definition.triggers.Recurrence.type
| where isnotnull(triggerType)
| extend startTime = properties.definition.triggers.Recurrence.recurrence.startTime
| extend frequency = properties.definition.triggers.Recurrence.recurrence.frequency
| extend interval = properties.definition.triggers.Recurrence.recurrence.interval
| extend timeZone = properties.definition.triggers.Recurrence.recurrence.timeZone
| project name, state, startTime, frequency, interval, timeZone