Home Analytics

Dashboard with Department from Analytics DB

Tim_VottaTim_Votta Customer Adept IT Monkey ✭✭

Is it possible to get the department of a requestor into a dashboard at all? I have my query showing everything that I want, but the manager requested I bring in department as well. This is just for reporting on IR and SR, but it appears department data does not come into the Analytics DB. Any idea how I could make this happen or if it is even possible?

Answers

  • Simon_ZeinhoferSimon_Zeinhofer Customer Advanced IT Monkey ✭✭✭

    You could make JOIN to the Servicemanagement CI$User Table.

    We use that to get Incidents from certain departments from the Analytics DB - I have to admit I don't know if this has some impact on the performance of the portal, as you make a JOIN to another database, but for us it works fine.

  • Tim_VottaTim_Votta Customer Adept IT Monkey ✭✭

    I will give it a try thanks for the pointer. I am sure that from efficiency standpoint of things it is probably not the best but I am just kind of ham fistedly writing SQL here in the first place. Efficiency is secondary to function as long as it doesn't break something :)

Sign In or Register to comment.