Find all files in SharePoint that are over 1 year old

%3CLINGO-SUB%20id%3D%22lingo-sub-1050404%22%20slang%3D%22en-US%22%3EFind%20all%20files%20in%20SharePoint%20that%20are%20over%201%20year%20old%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1050404%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20have%20a%20single%20document%20library%20that%20has%20a%20lot%20of%20flles%20%2F%20folders%20in%20and%20we%20would%20like%20to%20run%20a%20script%20that%20shows%20us%20how%20many%20of%20these%20files%20haven't%20been%20modified%20for%20a%20year%20or%20so.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnyone%20know%20how%20to%20do%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1050404%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDocument%20Library%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFiles%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1051710%22%20slang%3D%22en-US%22%3ERe%3A%20Find%20all%20files%20in%20SharePoint%20that%20are%20over%201%20year%20old%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1051710%22%20slang%3D%22en-US%22%3EThe%20easiest%20way%20would%20be%20to%20export%20your%20document%20library%20to%20excel.%20Then%20just%20apply%20an%20age%20filter%20to%20the%20modified%20column%20and%20you'll%20have%20a%20count%20of%20records%20(files)%20that%20are%20older%20than%20a%20year.%3C%2FLINGO-BODY%3E
Highlighted
Contributor

Hi 

 

We have a single document library that has a lot of flles / folders in and we would like to run a script that shows us how many of these files haven't been modified for a year or so.

 

Anyone know how to do this?

 

Thanks

1 Reply
Highlighted
The easiest way would be to export your document library to excel. Then just apply an age filter to the modified column and you'll have a count of records (files) that are older than a year.