Report by Category

Updated: 21 May 2010 | 1 comment

JoeBolster

0 0 Votes

This issue has been solved. See solution.

Im looking for a report by a specific category that gives me the created date and status of open. Im looking to get started and then add some columns to it as I go along and and see what else I need. Thank you..

discussion Filed Under:

Endpoint Management, Helpdesk Solution, Reporting

Comments RSS Feed

Comments

Oct

2009

0 Votes 0

MBHarmon

Trusted Advisor

Try this: Select

Try this:

Select hd.Workitem_number AS 'Incident',    
 hd.Workitem_category_tree_value AS 'Category',    
 hd.Workitem_status_lookup_value AS 'Status',    
 hd.Workitem_created_on AS 'Date Created'   
From hd_Workitem_current_view hd   
Where hd.Workitem_Category_tree_Value Like '%_category%'
 AND hd.workitem_status_lookup_value != 'Closed'

It includes a Parameter for Category since I assume you'll be wanting to prompt for that. Also our business process has multiple status types for "open" so I just made it all of them that were not closed. Hope that helps.

- Matt

SOLUTION

Report by Category

Comments

Try this: Select

Would you like to reply?

Links

Technical Support

Symantec.com

Store

Community Stats