I have came across one requirement to provide usage report with last modified date for all subsites and site collection in a webapplication in Sharepoint 2010.
I have written a script to perform the same activity.
Usage report for all subsites including last modified date
This script will provide the details for all subsites and site collection in a webapp with storage and last modified date