8 Replies Latest reply on Jul 8, 2011 9:11 PM by Daniel Tuczapski

Record of Destroyed Files

Ashkan Sardari Jul 5, 2011 9:24 PM

Is there a way to keep a record of when, by whom and what files are destroyed from the EPDM recycle bin?

Re: Record of Destroyed Files

Joy Garon Jul 7, 2011 3:18 PM (in response to Ashkan Sardari)

Hello Ashkan,

I am not aware of any method to accomplish this.

Best Regards,
Joy
Like Show 0 Likes(0)

Actions
Re: Record of Destroyed Files

Daniel Tuczapski Jul 8, 2011 6:40 AM (in response to Ashkan Sardari)

Hello

You can write a trigger on table documents which will log every deleted records from this table

Best regards
Daniel
Like Show 0 Likes(0)

Actions
- Re: Record of Destroyed Files
  
  Joy Garon Jul 8, 2011 7:52 AM (in response to Daniel Tuczapski)
  
  Hi Gentleman,
  
  Maybe I misunderstood, the question asked about 'destroy' - which is not recorded.
  
  Best Regards,
  Joy
  
  Like Show 0 Likes(0)
  
  Actions
  - Re: Record of Destroyed Files
    
    Daniel Tuczapski Jul 8, 2011 8:13 AM (in response to Joy Garon)
    
    Hi Joy
    
    When you delete file from localview this file is marked in database Deleted = 1
    When you destroy this file record is deleted from database and trigger can catch this action (from deleted table) and make new entry in your log table.
    
    I try to make this trigger and let you know
    
    Best regards
    Daniel
    
    Like Show 0 Likes(0)
    
    Actions
    - Re: Record of Destroyed Files
      
      Joy Garon Jul 8, 2011 8:31 AM (in response to Daniel Tuczapski)
      
      Hi Daniel -
      
      Cool - I'm assuming you are talking about creating a SQL trigger on the table?
      Will that work if the user does not do a Delete, but, rather a Destroy right away?
      
      Cheers,
      Joy
      
      Like Show 0 Likes(0)
      
      Actions
      - Re: Record of Destroyed Files
        
        Daniel Tuczapski Jul 8, 2011 8:46 AM (in response to Joy Garon)
        
        Hi Joy
        
        Exactly, i was talkin about SQL trigger. I was not precise sorry
        
        I thought to create a table i.e.named LOG in the EPDM database. To DOCUMENTS table add a trigger which can catch any deleted record.
        This deleted record are de facto destroyed files. Information about deleted record trigger will put in LOG database.
        For Report feature from EPDM i can create query to the SQL database to view those deleted records/destroyed files.
        
        I think it would work
        
        Best regards
        Daniel
        
        Like Show 0 Likes(0)
        
        Actions
        
        Re: Record of Destroyed Files
        
        Joy Garon Jul 8, 2011 9:36 AM (in response to Daniel Tuczapski)
        
        Hi Daniel,
        
        After conferring with the experts here is some advice:
        
        Do not put custom tables in the vault database – it is not supported and will lead to problems.
        
        You could probably sort it out with a view from another custom database.
        Triggers can be tricky as well since they could add overhead.
        Triggers with dependencies could also cause future upgrades to fail because of constraints kicking in.
        
        Best Regards,
        Joy
        
        Like Show 0 Likes(0)
        
        Actions
        
        Re: Record of Destroyed Files
        
        Daniel Tuczapski Jul 8, 2011 9:11 PM (in response to Joy Garon)
        
        Hi Joy
        
        Thanks for advice i will keep it in mind
        
        Best regards
        Daniel
        
        Like Show 0 Likes(0)
        
        Actions

Go to original post