Requester name, mail, login in category report for last 6 months
Hi, I'm trying to create a report that queries the following items:
(We're on 9.3 build 9335, MSSQL Server 2008)
Requester first name
Requester login name
Requester email address
Category is: 'BS&CP - Development & Database' or 'BS&CP / SAP'
Request status is closed
Request created within last 6 months
Column that shows the number of requests grouped by requester (optional)
I'm not very firm with SQL so any assistance will be greatly appreciated!
Best regards
(We're on 9.3 build 9335, MSSQL Server 2008)
Requester first name
Requester login name
Requester email address
Category is: 'BS&CP - Development & Database' or 'BS&CP / SAP'
Request status is closed
Request created within last 6 months
Column that shows the number of requests grouped by requester (optional)
I'm not very firm with SQL so any assistance will be greatly appreciated!
Best regards