Katie Negri Posted January 10, 2019 Share Posted January 10, 2019 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 More sharing options...
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
Already have an account? Sign in here.Sign In Now