截屏视频帮助

Report Help! Need to have an audit of where a ticket has been.

创建时间: 13 9 月 2012 | 2 条评论

Hi,

   SD 7.1.2

   I need a report in ServiceDesk to show when a ticket was assigned.    When a ticket is reassigned (or even resolved), they would like to know who did it and where did it go (and possibly where it was.)   I am open to ideas as we have had a few SQL people look at this and run for the hills.   Thank you in advance.

Thanks,

Jamie

讨论 归类至以下社区:

评论 条评论跳转至最新评论

toomas 的图片

As far as I remember assignment history is not explicitly saved anywhere in the database on 7.1

The easiest (and probably the only) way to get this would be to have customizations to add additional comments/messages to the process history. Or alternatively, a custom component writing into some kind of audit table.

Aryanos 的图片

You can find the reassignment comments in the ReportProcessComments table and filter it by looking at 'Reassignment' in the CommentBrief column. You'll have to join it to the ReportProcess table to get the IM number. I'd create a view for this, then create a profile and then create a report using that profile but this would only show you the reassignments. 

If you wanted to know who resolved it then you would have to join to the ServiceDeskIncidentManagement table as well.

I like my beats fast and my bass down low