Jump to content

Katie Negri

Hornbill Users
  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Katie Negri

  • Rank
  1. I am having a hard time building a report to identify which users are actively using Hornbill. We have several users who are assigned a full-user account and would be able to revoke those licenses for new employees onboarding who may utilize them more. Any help would be greatly appreciated.
  2. @Victor We are having trouble pulling time into the SQL query mentioned in my original post.
  3. 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.
  • Create New...