Query for versions

[liluth]

Hi,

what query should i do to extract documents witch have the highest number of versions (more than 100) 

[EddieMay]

Hi @liluth,

Could you give a little more background about why and how you plan to use this query? Also, how big is your content store? How often will you run this query? Is this an ad hoc admin query or part of a reporting requirement, that would be run regularly? 

Thanks,

[liluth]

Hi,

we plan to run it manually once a month. The goal is to lighten the content store and reduce the response time. We can remove minus version. For the weight, i give an answer tomorrow

Bye

[liluth]

ContentStore : 1.93 To      3 605 447 Files