Jump to content

SQL reporting - Department field


TomC
 Share

Recommended Posts

Hi all,

Fairly new to SQL reporting but I have managed to get 99% of the data i require but i am struggling to find the Department option within the reporting filters. 

Could anyone share on how I can obtain this field please? 

Many thanks,

Tom

Link to comment
Share on other sites

Hi @TomC

Thanks for your post.

There are a number of places where reports can be created.  I'm also not sure what you are reporting on.  Users, assets, requests?

within the Reports section of the Service Manager configuration there is this option for setting filters against the information that is available within the tables that you have selected.  Is this what you are trying to set up?

image.png

Link to comment
Share on other sites

Hi James,

Yes that correct, im trying to report on overall ticket data, so requests & incidents.

I am using the reporting tool you have above.

We have the department field populated for each of our users so i would like the report to show the department listed against each user so i can do some analysis on our heavy use departments and their commonly raised tickets. 

When i use the table as exampled above, i am not able to find the filter for Department, there is Organisation but we don't have this field populated. 

Thanks, 

Link to comment
Share on other sites

50 minutes ago, TomC said:

We have the department field populated for each of our users

Could you show where the Department field is populated, as there isn't a dedicated field to indicate Department.

There are a few alternative ways to indicate Department for a User, and we'd need to know how you're doing this in your Instance to advise on where this data is held and how best to extract it.

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
 Share

×
×
  • Create New...