building and merging SQL reports

[Katie Negri]

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.

 

[Victor]

@Katie Negri the reporting interface should allow you to build a report to get the results you need (that the SQL above should/would return). You haven't actually specified what assistance you seek more precisely... 

[Katie Negri]

@James Ainsworth

[Katie Negri]

@Victor We are having trouble pulling time into the SQL query mentioned in my original post.  

[Victor]

@Katie Negri - so, the SQL you wrote will return results (request data) from requests table based on the filter/criteria you specified. When you say "time spent" are you referring to time recorded on requests using the Timesheet Manager app functionality? Or this "time spent" refers to something else? Just wanted to clarify...