Jump to content

building and merging SQL reports

Katie Negri

Recommended Posts

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.


Link to comment
Share on other sites

@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...

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...