Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

Category Reporting

Category Reporting

How would I get a report that would give me information on Categories.  I would like to know what services are associated to what categories all if possible.  I would also like to know if we have services that don't have any categories associated at all.  We are trying to make sure that everyone is following the same rules when it comes to categories etc, thanks!

Everyone's tags (1)
2 REPLIES

Category Reporting

Wendy - MVCI
4:30am, May 27 

Hi - we have code we use to pull this information from the database. Please see below. Hope this helps - thanks - Wendy

Select

  da.name, dc.name

from

  rcuser.defcategory.da,

  rcuser.defcategoryservices db,

  rcuser.defservice dc

where

  da.categoryid = db.categoryid and

  db.serviceid = dc.serviceid and

  dc.isinactive = '0'

Category Reporting

Anthony Erickson 
8:19am, May 27 

Wendy, thanks for that - that's something we've been after for a while too!

Cheers,
Ant

Cheers,Ant

121
Views
0
Helpful
2
Replies