Reporting and Analytics for Service

Get Involved. Join the Conversation.

Topic

    Pavol Procka
    How to report on Archived incidents sent with Attachments?Answered
    Topic posted October 27, 2017 by Pavol ProckaSilver Crown: 22,500+ Points, last edited October 27, 2017 
    93 Views, 4 Comments
    Title:
    How to report on Archived incidents sent with Attachments?
    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.

     

    Any ideas?

    Many thanks

    Pavol

    Best Comment

    Sheri Hastings

    I'm not positive but I don't think archived incidents are stored with attachments.  I know they cannot be updated and are read only. And the table has no join to fattach which makes me think that attachments are not stored for archived incidents.


     

    Comment

     

    • Sheri Hastings

      I'm not positive but I don't think archived incidents are stored with attachments.  I know they cannot be updated and are read only. And the table has no join to fattach which makes me think that attachments are not stored for archived incidents.


       

    • Pavol Procka

      Thanks, Sheri.

      I thought the same, was just hoping someone with a lot of expertise can correct me :)
      I tried and when I try to add the fattach table to the archived incidents table, it will not join directly. It uses the contacts table as a join, however when I run the report like that no results are returned.

      Maybe Oracle will add this in the future...

    • Sheri Hastings

      Paval
      If you join attachments to contacts you are looking at attachments for contacts,... not for archived incidents. I researched it some more and I am pretty sure that unfortunately you cannot get the attachments for archived incidents.  You could submit an enhancement request to the idea lab for saving attachments of archived incidents.

       

       

    • Pavol Procka

      Hi Sheri,

      Thanks for the clarification and I have added it to the Idea Lab ;)

      Pavol