ScheduledJob for getting overview of site content usage

In one of my current project which we are going to upgrade from Optimizely 11 I needed to get an overview of the content and which content types we have, are some unused etc.

In order to do that I did a scheduled job that will go through the sites content types, check for usage and if a content type id is specified render links to edit mode for all content instances for that type.

Everything is wrapped up into a CSV file that are easily imported into excell for easy filtering and send that as an attached file via SMTP.

In the code you can change sender, recipients and after an initial run and you also want to get the links to the content instances for one or more content types that can be set as well.

The collumns you get is the following:

I expected some content types with zero content instances but to my suprise the number was bigger than I expected.

Nothing advanced but a simple way to identify content types that could be removed or find all instances of a content type that you might be able to remove after you actually check the content.

You can find the content over at my gist. ScheduledJob content usage Gist