Hello everyone, I want to create an automation rule that will do the following: * Periodically check if there are Certificate objects whose expiration date is lower than 30 days * For those that fit this condition I want to create a ticket with some information:* The project must be the correct project (Certificates have inbound relationship with Host objects in which there is an attribute with JSM projects filled in) - I have no idea how to pull this information in a smart value or something similar so that it is dynamic for each found Certificate * In an Asset field save the related Certificate * Update the "Status" attribute of the related Certificate to "UNDER RENEWAL" I have found this community post which helped me get started, but I got stuck quickly: https://community.atlassian.com/t5/Jira-Service-Management/Automation-loops-with-Assets-Objects/qaq-p/2267068 Now, what I did (as suggested in the post I linked) was I added a branch on AQL component with the following AQL: objecttype = "SSL Certificates" and "Expiry Date" = now(-1d) This finds the correct objects which I confirmed with a log component. Now my problem is how do I reference the linked "Host" object where the correct JSM project is stored in an attribute called "Related Project". If anyone is wondering, our JSM structure is 1 project per client, that is why we have this attribute in Host objects. Thank you!

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Automation to create 1 issue for every found object in the correct project based on object attribute

Danilo Simic_skxcoi

Hello everyone,

I want to create an automation rule that will do the following:

Periodically check if there are Certificate objects whose expiration date is lower than 30 days
For those that fit this condition I want to create a ticket with some information:
1. The project must be the correct project (Certificates have inbound relationship with Host objects in which there is an attribute with JSM projects filled in) - I have no idea how to pull this information in a smart value or something similar so that it is dynamic for each found Certificate
2. In an Asset field save the related Certificate
Update the "Status" attribute of the related Certificate to "UNDER RENEWAL"

I have found this community post which helped me get started, but I got stuck quickly:

https://community.atlassian.com/t5/Jira-Service-Management/Automation-loops-with-Assets-Objects/qaq-p/2267068

Now, what I did (as suggested in the post I linked) was I added a branch on AQL component with the following AQL:
objecttype = "SSL Certificates" and "Expiry Date" < now(30d) AND "Expiry Date" >= now(-1d)

This finds the correct objects which I confirmed with a log component.

Now my problem is how do I reference the linked "Host" object where the correct JSM project is stored in an attribute called "Related Project".

If anyone is wondering, our JSM structure is 1 project per client, that is why we have this attribute in Host objects.

Thank you!

Accepted answers

Kevin Patterson_u4sm4w

Hi @Danilo Simic

If I understand your assets structure it sounds like you have an inbound relationship on your SSL Certificates objects from objects in an object type called Hosts that contains the JSM Project relationship? If my understanding is correct you will need to add a Lookup Objects Action inside of your current Branch on AQL that retrieves the related object. It might look something like this:

objectType = “Host" AND object HAVING outboundReferences(objectType = “SSL Certificates AND key = “{{object.key}}”)

You might need to adjust the AQL statement above to get the results you are looking for, here is a link to some reference material I use when writing AQL statements: https://support.atlassian.com/jira-service-management-cloud/docs/use-assets-query-language-aql/

while inside the branch you’ll be able to reference your Related project or any other attribute of your hosts object type via “LookupObject.ATTRIBUTE” in your example I think you’ll want to use “LookupObjects.Related Project”

All comments

Kevin Patterson_u4sm4w

Hi @Danilo Simic

objectType = “Host" AND object HAVING outboundReferences(objectType = “SSL Certificates AND key = “{{object.key}}”)

Danilo Simic_skxcoi

Hello Kevin,

Your understanding is correct.

One concern here, if I use the lookup object as you described, will I get only the one host for the one certificate? I am asking because you are calling key = “{{object.key}}”, it should only use the 1 certificate that is currently running through the branch, correct?

Kevin Patterson_u4sm4w

Hi @Danilo Simic

Yes. Each object that is returned through your branch AQL will have the certificate retrieved by the lookupobjects action . If your end goal is to create an individual ticket for each expiring certificate you will want to have the action that creates the ticket inside the branch. I hope this helps.

Danilo Simic_skxcoi

Hello,

I was able to find the correct objects using this method. Later I will see if 1 tickets with information from 1 object is created while running the rule for every object found.

Thank you!

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

automation

jira-service-management-cloud

jira-service-management

assets