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

Does an Incident always have a Submitter in the ReportProcessContact table?

Created: 06 Dec 2012 • Updated: 12 Dec 2012 | 1 comment
This issue has been solved. See solution.

I need some help. The background is that I'm concerned about data corruption, and trying to get an idea of what has happened. In doing so, I came across  4,000+ Incidents in the ServiceDeskIncidentManagement table with no submitter record in the ReportProcessContact table.  When I say "submitter", I mean the ReportProcessContact.ContactType is either "Submitter", "Affected User and Submitter", or "Email Submitter". 

My question is this: Will a "Submitter" record be created in the ReportProcessContact table for each and every Incident that is created (in the ServiceDeskIncidentManagement table)?

I'm looking for some reassurance that I'm actually looking at a problem, or if this normal behavior?

Thanks, any comments are appreciated.

Discussion Filed Under:

Comments 1 CommentJump to latest comment

toomas's picture

In general yes, there should be one of these submitter type contacts for each Incident.

From your post you seem to keep that in mind already but ReportProcessContact does not hold only Incident but all process' information.

SOLUTION