Need Query/Report to show all Tickets open more than 7 days

Need Query/Report to show all Tickets open more than 7 days

Need a query/report to show all tickets (work orders) that have been open more than 7 days.  

Fields in the report

RequestID
Requester
CreatedTime
Subject
Group
Category
SubCategory
SupportRep (assigned to)
.

(MSSQL)

Thanks
                New to ADManager Plus?

                  New to ADSelfService Plus?