We are running SharePoint 2010 Enterprise and are not thrilled with how Site Confirmation and Deletion works out of the box and we are wondering what other firms are doing about it.
For research, I have come across this blog post:
http://thesharepointblog.com/Lists/Posts/Post.aspx?ID=16
In addition, Microsoft's documentation is vague. It says a site comes up for notices after a "period of inactivity" without stating explicitly what counts as inactivity.
http://technet.microsoft.com/en-us/library/cc262420.aspx
Our understanding is that the way the feature works is when the site is created, it sets a date and that date is not reset for any reason other than one of the site collection administrators clicking on one of these site confirmation/deletion emails.
So, what we would rather have is, a sliding expiration so that when someone uses the site, the expiration is automatically extended. In other words, we only want to cull out sites not being used.