In Assets I've built out a Software Catalog. One of the attributes is "Last Access Audit" as a Date type value. I'm attempting to setup a global automation that runs daily and will look for any software objects with a Last Access Audit value greater than 180 days.
"Last Access Audit" is EMPTY
Works on all objects where the field is empty. No issues with this.
"Last Access Audit" >= -3d
No results found after putting in a date several months old. Simplifying by looking for older than 3 days instead of 180 to start out. I've also tried just =
AQL does not have the same functions for dates as JQL, but if you use this it should work:
"Last Access Audit" < now(-180d)
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.