Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

Implementer field in "Changes Scheduled This Month" report

Created: 12 Mar 2013 • Updated: 13 Mar 2013 | 3 comments
Lark's picture
This issue has been solved. See solution.

I'm wanting to add the Implementer to the report "Changes Scheduled This Month"  using the report builder but I can't seem to find it in the list of available fields.

I've seen this article that shows how to include custom data through a view:

http://www.symantec.com/connect/articles/using-custom-sql-servicedesk-report-builder-and-still-use-parameters

Alternatively I know I could write a custom SQL report but I'd really like to retain the process links in the report that you only get through building the report in the report builder.

Is there an easier way?

Operating Systems:

Comments 3 CommentsJump to latest comment

TGiles's picture

It appears that we don't expose that field in our list of available fields when we defined the filters used for Change Management reporting. 

You could create a Profile Definition for the CMChangeTicket table in the database having it include just the SessionID & Implementor field to keep things simple. Then you could use this profile in the report builder along with the other data sources. This would allow you to retain the process link functionality

SOLUTION
Lark's picture

Ok thanks for confirming its not just me being a terrible user of the report builder :-)

I'll log an idea for this.  Its also tied in with requesting the implementer be allowed to be a group rather than an individual.

Lark's picture

Just in case anyone is wondering, TGiles is talking about is following the link below from step 3.  I didn't need to create a view because the information is all stored in the existing CMChangeTicket table.  You'd only need a view if your data was in multiple tables.

http://www.symantec.com/connect/articles/using-custom-sql-servicedesk-report-builder-and-still-use-parameters