Get started Vitals Queries Policies Software OS settings Data tables

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

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 );