As I mentioned in a recent Blog posting, I am attempting to blog more.  With blogs postings come comments to my blog -- this is a appreciated and unfortunately sometimes overlooked.  So I have added a new report to my site that display recent blog comments.  This way when I do my daily site review I can check if I have comments that require responses.

I also have missed some feedback messages -- even though they generate an email, I do miss them so I have a report to display all the unanswered feedback messages.

You can use the Reports module to display the information or one of the several other SQL grid modules to display the report.  For obvious reasons I use SQLGridSelectedView.

The SQL is simple:

 select
    Author, Title, Comment, addeddate from dbo.Blog_Comments
where
    DateDiff(d, AddedDate, Getdate()) < 90
    and Author <> 'Host'
order by
    AddedDate desc

I also added a display of the recent blog post to using this SQL.  Inspired by this DotnetNuke Forum posting - I believe this is from mamlin at eguanasolutions.com

select top 5
    ''+ble.Title+'' as [Latest Blog Entries]
from
    blog_entries ble
    inner join blog_blogs bb on bb.Blogid = ble.Blogid
where
    ble.Published = 1
    and bb.Portalid = 2
    and bb.[public] = 1    -- ensure blog is public
order by
    ble.AddedDate desc

Lastly, I needed to see if I missed any feedback messages -- I have missed feedback and its "bad form" to not respond in a timely mannor, so here is the SQL to report on feedback.

select
    DateCreated as [Created],
    Subject,
    Message,
    CreatedbyEmail as [Email]
from
    dbo.Feedback
where
    status = 2
order by
    DateCreated desc

Hope this helps.  
Paul