Requestor/Technician Activity Report

Requestor/Technician Activity Report

Hi,

Please can I request a new query.  I would like to be able to report on the requesters and technicians use of the system.  How often they have logged in during a stated date range (Today, Last Week, Last Month etc), and I would also like to report how many calls they've logged, updated or closed.  Might need to be two different reports.

Request Activity Report
Date Filter on Associated Date (Today, Yesterday, last week etc.)
Fields required: Requester Name, Request Department, #Times Logged In, #Calls Logged, #Calls Updated

Technician Activity Report
Date Filter on Associated Date (Today, Yesterday, last week etc.)
Fields required: Technician Name, #Times Logged In, #Calls Logged, #Calls Updated, #Calls Closed.

Is this possible, even it it's more than one query to return the required data?

Many thanks,
Lisa

@Database Name = Microsoft SQL Server@
@Current Build = 11307@