We have about 600 site collections and I believe only about 1/3 of them are in use. I need to find out which ones are no longer in use (or, a list of which sites ARE in use would be fine). Any way to get a list of these sites would be great.
I know I can go to each site collection one-by-one and look at the usage to see if it has been used recently, but doing that with 600 sites isn't an option. It would take forever.
I also know that I can turn on Site use confirmation and deletion, but bombarding users with strange e-mails about sites they've long forgotten about and waiting for a response is also not an option. I don't want any automatic deletion, I just want
to see a list of the sites.
Is there any way I can quickly/easily view the site usage for every site collection? I want to get an idea of which sites would be deleted, how many are unused, etc.