You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to report on Archived incidents sent with Attachments?

edited Oct 27, 2017 3:59PM in Reporting & Analytics for B2C Service 4 comments

Content

Hi everyone, wishing you a nice weekend. I have a requirement to report on all Incidents sent from OSvC with an attachment in January 2017.

I checked and the Archived Incidents has a column called File Directory (file_dir) which is supposed to show: "The name of the directory the incident's file attachments are stored in." With this however, I still seem to be getting all incidents, not just the ones with an attachment and the directory look something like 2017/212aa/16.5.0.1.0.**** - not sure what that stands for.

When I add a column from the File Attachments (fattach) table the Archived incidents report does not return anything at all.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!