Content Comparison

...

"Status" IN ("Active") AND "Renewal Date" < now(60d) AND "Renewal Date" >= now(-1d)

automation 으로 만료된 Asset 상태 업데이트하기

• https://confluence.atlassian.com/jirakb/update-asset-object-status-to-expired-using-automation-1072219008.html

1. global → automation
   

   Image Added

2. Create rule 선택
   

   Image Added

3. “New trigger”에서 Scheduled trigger 를 생성
   

   Image Added

4. 실행할 일정과 주기 선택
   

   Image Added

5. Add component 에서 “New action” 선택

   Image Added

6. component 에서 “lookup objects” 선택
   

   Image Added

7. Schema(1) 를 “IT employee Assets” 로 설정하고 Query(2) 에 다음 항목 입력하고 “publish rule”(3) 클릭
   

   Image Added

   
   

   Code Block
   language sql
   objecttype = "Cloud Subscriptions" AND "Renewal date" < now() AND "Status" != Retired

8. 2222

9. 111
   

See also

• https://support.atlassian.com/jira-service-management-cloud/docs/use-insight-query-language-iql/

• https://confluence.atlassian.com/servicemanagementserver/advanced-searching-aql-assets-query-language-1044784588.html