Creating automated notifications for 30 days before expiry dates in Insight

[Bradley O'Reilly]

Hey guys

I've created an Object Type for all our organisations subscriptions & am looking to setup an automated notification that sends to our Service Desk when a subscription has 30 days before expiry.

I have created an attribute "Subscription Expiry Date" set as a Date Type Value & each object has a status attribute "Subscription Status" (which is just the inbuilt status type)

See below -

Basically in shortened terms we'd like -

* If the subscription is due on 1/1/2023

* Insight automatically sends a notification to our Jira service desk on 1/12/2022 allowing us to keep track of subscriptions.

I've had a look in the global automation admin - but the query language is foreign to me.

If anyone could help that'd be great.

Cheers

[Bradley O'Reilly]

Update - 

Unfortunately no assistance of yet - it appears there are no capable triggers for what I'm asking of as Global Automation only offers triggers if an object is created, modified or deleted.

Work around is running the following IQL through a trial of dashboard hub & checking manually -

"ObjectType" = "Subscriptions" AND "Subscription Expiry Date" <= now(30d) AND "Subscription Status" = "Active"

Does anyone know if there will be a broader variety of triggers added for insight objects in the future?