Get subscription-based applications that have not been opened for the last 30 days
Get subscription-based applications that have not been opened for the last 30 days
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
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 );
PowerShell commands are currently work in progress, contributions welcome.
Platform
Edit
SOC2 Type 2
© 2025 Fleet Inc.
Privacy
