Before migrating a 2010 Farm to 2016, I want to create cleaner library so I want to eliminate the fields that stopped being used on 2010.

Is there a tool of PowerShell script I can run to tell me which optional fields do not have value in items made lately?

Thanks in advance

1 Answer 1


Assuming your lists or libraries are fairly standardized, You could try exporting a library or list to excel. Then use Excel to filter and sort the data to determine columns with highest number of blanks, etc. That could help you determine which fields are being ignored the most.

  • I have about 100 site collections with the same set of libraries.
    – Ofer Gal
    Commented Jan 19, 2017 at 22:16

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.