I am trying to pull time on our SQL query and joining two tables. I am trying to identify how much time is being spent on certain catalogs/categories to justify adding more staffing.
Please see the SQL query that we have built below:
SELECT * FROM h_itsm_requests where h_fk_team_name = 'applications' and (h_status = 'status.new' or h_status = 'status.open' or h_status = 'status.onHold' or h_status = 'status.closed' or h_status = 'status.resolved') and (h_category = 'IT Services->Hornbill' or h_category = 'IT Services->UltiPro' or h_category = 'IT Services->Financial Apps')
Ideally we would like this as a report, not a dashboard or widget, that we can refer back to if needed.
Any assistance would be greatly appreciated.