- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-21-2025 03:37 AM
Hi community,
How to inactive reports that are not run in the last 6 months ? and after inactivating, we want to delete the reports after one month of inactivation.
Thanks
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-21-2025 05:32 AM
something like this
If my response helped please mark it correct and close the thread so that it benefits future readers.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-21-2025 05:22 AM
have a flow trigger on sys_report with Condition Active Changes to False
Then use Wait for Duration 1 month (30 days * 24 hours)
Then use Delete Record flow action
If my response helped please mark it correct and close the thread so that it benefits future readers.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-21-2025 05:32 AM
something like this
If my response helped please mark it correct and close the thread so that it benefits future readers.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-23-2025 04:07 AM
Hope you are doing good.
Did my reply answer your question?
If my response helped please mark it correct and close the thread so that it benefits future readers.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-21-2025 03:53 AM
You can use "report_stats" table to identify when the report was last run using 'last_run' field.
You can run a flow with scheduled trigger or a scheduled job. Flow would be simple without the need to write script.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-21-2025 10:32 AM
Hi @Manasa Reddy Li ,
You can create a scheduled job to cleanup reports that hasn't been utilized for 6 months. query the report_stats table and remove reports that hasn't been utilized in the expected time frame.