I would like to clean up the Tridion Schemas in a large implementation and remove any unused fields. I'm curious to hear how you might solve the challenge, and am not looking for a code solution at this moment.
I was thinking to write a .Net Core Service app, get the XSD Schema, update it in code to set minOccurs to 1 for every field (even if it is really optional), and then try to validate the Component XML against it.
And, then log the fields that do not contain content.
Another way would be to log each time a field does have content, and then at the end manually look at the fields and see if any are not logged (ie. never had content).
What other approaches might work? Thanks!