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  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

View solution in original post

9 REPLIES 9

Ankur Bawiskar
Tera Patron
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  ||  9x 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  ||  9x 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