Jump to content
yelyah.nodrog

Reporting on Catalog items

Recommended Posts

Afternoon,

One of our Mangers has requested a report for a specific catalog item that calls are logged under.

This is what he has requested:

SO…  I need a Hornbill report

For the MS SQL Server Support Team.  - For the Service "Database Support" then the catalog item "Database Migration"

Please Include

Raised On, Date Closed, Reference, Owner, Customer, Request Category & Closure Category, Summary, Description Text, … Ordered by Reference category and then Raised on

I am struggling to get this report to pick up the catalog item, is there a obvious way to do this that I'm just overlooking?

 

Many thanks

Hayley.

 

 

 

Share this post


Link to post
Share on other sites
Guest

Hi @yelyah.nodrog

Have you got a screenshot of what you have configured so far?

I've just created a report on my test system based on the Team ("1st Line Support"), Service ("Home Working") and Catalog Item ("VPN Access") and its working as expected. The filter is as follows:

Screenshot_4.png

 

Does this help at all?

Kind Regards

Bob

 

Share this post


Link to post
Share on other sites

Hey bob this is what I have so far, But its not picking anything up I have checked the team name and the catalog item to make sure spelt right etc...

 

SS1.PNG

SS2.PNG

SS3.PNG

SS4.PNG

Share this post


Link to post
Share on other sites
Guest

Hi @yelyah.nodrog

Looking at your base data, it appears some of the naming conventions in your system are different to what you are providing into the report. 

Try the following
Team: MS SQL Server Support (not "MS SQL Server Support Team")
Service Name: Database Support
Catalog: 
Database Migrations (Service Desk) (not "Database Migrations")

Hopefully this will work....let me know how you get on

Kind Regards

Bob

Share this post


Link to post
Share on other sites

Sorry bob, Yes it did thank you very much, clearly it was just me being a numpty :) 

Share this post


Link to post
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...