While it's true, as Bill stated, that there is no admin tool that
would allow you to do this and code would have to be created, you
can access this information directly from the database for each of
your portal instances. In your _Sites database, execute the
following SQL code:
SELECT dbo.Webs.Title, dbo.Webs.Description, dbo.Webs.FullUrl,
dbo.UserInfo.tp_Title AS Owner, dbo.Webs.TimeCreated, DATEADD(d,
dbo.Webs.DayLastAccessed + 65536, CONVERT
(datetime, '1/1/1899', 101)) AS [Day Last Accessed],
'http://your.PortalURL.com/' +
dbo.Webs.FullUrl + '/_layouts/1033/deleteweb.aspx' AS [Delete Link],
dbo.UserInfo.tp_Email, dbo.Webs.WebTemplate,
dbo.Webs.RequestAccessEmail
FROM dbo.Webs INNER JOIN
dbo.UserInfo ON dbo.Webs.Author =
dbo.UserInfo.tp_ID
WHERE (DATEADD(d, dbo.Webs.DayLastAccessed + 65536, CONVERT
(datetime, '1/1/1899', 101)) < CONVERT(DATETIME, '2078-01-01
00:00:00', 102))
I have an Access database template that I dump these query results
in (along with data from my Audit Docs and Audit Users query
results). Then, I turn the Access db over to our portal community
administrators. I've pre-populated that database with a number of
queries to help them manage their communities.