Queries/

Get subscription-based applications that have not been opened for the last 30 days

Kelvin Oghenerhoro Omereshone

Returns applications that are subscription-based and have not been opened for the last 30 days. You can replace the list of applications with those specific to your use case.

To learn more about queries, check this guide.

Query PowerShellNEW BashNEW

SELECT * FROM apps WHERE path LIKE '/Applications/%' AND name IN ("Photoshop.app", "Adobe XD.app", "Sketch.app", "Illustrator.app") AND last_opened_time < (( SELECT unix_time FROM time ) - 2592000000000 );