Interested in a ServiceNow event built for developers? Registration for now[dev]26 is officially open!

How to inactive reports that are not run in the last 6 months?

Manasa Reddy Li
Tera Contributor

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

1 ACCEPTED SOLUTION

@Manasa Reddy Li 

something like this

report delete after 1 month.gif

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 10x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

View solution in original post

9 REPLIES 9

Ankur Bawiskar
Tera Patron

@Manasa Reddy Li 

what do you mean not run in last 6 months?

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 10x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

Hi Ankur,

 

I mean the Reports that were not used in the last 6 months.

 

 

@Manasa Reddy Li 

you already know the table, filter condition

Run a scheduled job or flow and use Lookup records

Then for each record inactivate the report

Then have a wait for duration of 1 month and then delete that

where are you stuck?

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 10x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

Hi @Ankur Bawiskar ,

I am new to reporting area. I have written the below script to make the reports inactive. How to delete these reports after one month?

 

Thanks
Manasa