• Replies 9 replies
  • Subscribers 10 subscribers
  • Views 13228 views
  • Users 0 members are here
Options
Related

How can I find orphaned files in the Vault?

AngelaIp
Hi, I want to track the amount of Files that are not related to a Document or Change Processes anymore. I noticed that these unrelated files are somehow assigned to the SystemFileContainer Orphaned Files Container. SystemFielContainer is used as PolySource in FileContainerItems. But I have some trouble to find the right query, to detect all of my orphaned Files. Does somebody have an example query for finding orphaned files? Or maybe just some hints, how these different ItemTypes stick together? Thanks and best regards! Angela
Parents
  • Offline
    Hi Angela, You are correct about the behavior of Files and Containers expect for one thing. Files that are related to ECOs, Documents, etc. do have a container which corresponds to the ID of the relationship item. So a File related to a Document will have it's container set to the ID of the Document File relationship. In terms of recommendations for cleaning up older conversion server files, there's no "correct" way to do this. It's entirely dependent on your specific needs. If the amount of conversion server files is not a problem, you could not worry about cleaning them up at all. However, if it does eventually become a problem, one solution could be to periodically run a method that checks the age of the file using the created_on property and removes it if it is older than some amount. Chris
    Christopher Gillis Aras Labs Software Engineer
Reply
  • Offline
    Hi Angela, You are correct about the behavior of Files and Containers expect for one thing. Files that are related to ECOs, Documents, etc. do have a container which corresponds to the ID of the relationship item. So a File related to a Document will have it's container set to the ID of the Document File relationship. In terms of recommendations for cleaning up older conversion server files, there's no "correct" way to do this. It's entirely dependent on your specific needs. If the amount of conversion server files is not a problem, you could not worry about cleaning them up at all. However, if it does eventually become a problem, one solution could be to periodically run a method that checks the age of the file using the created_on property and removes it if it is older than some amount. Chris
    Christopher Gillis Aras Labs Software Engineer
Children
No Data