Is there a way to get month-wise count report of provisioning requests

[mridulutkarsh]

Hi,

Is there a way to get month-wise count report of provisioning/deprovisioning requests. I want to fetch report of this year :

1st Jan - 31st Jan

1st Feb - 28th Feb

1st Mar - 31st March  likewise...

Thank you,

Mridul

__PRESENT

[rushikeshvartak]

select label,count(label) as data
from
(
SELECT DISTINCT AR.JBPMPROCESSINSTANCEID,concat(left(monthname(REQUESTDATE),3)," ",year(REQUESTDATE)) as label,
AR.REQUESTKEY,MONTH(REQUESTDATE)Month_Num,
AR.REQUESTTYPE AS ARREQUESTYPE,RA.REQUESTTYPE,AR.STATUS,AR.REQUESTOR,RA.USERKEY,AR.REQUESTDATE,AR.DUEDATE
FROM ARS_REQUESTS AR, REQUEST_ACCESS RA, ACCESS_APPROVERS AA
WHERE AR.REQUESTKEY = RA.REQUESTKEY AND AA.REQUEST_ACCESS_KEY = RA.REQUEST_ACCESSKEY and AR.REQUESTDATE >= CAST(DATE_FORMAT(DATE_SUB(curdate(), INTERVAL 4 MONTH),'%Y-%m-01') as DATE)
) as A group by label order by month_num asc limit 5

[mridulutkarsh]

Thank you Rushikesh. This is giving count of all requests created during a month? Is there way to further split it into count of provisioning requests  and count of deprovisioning requests for access.