How can I get the attachment version number at a given point of time ?

[Clemens Linowski]

for example: AttchmentA has versions: 1. from Jan 9, 2. from Jan 12, 3. from Jan 16. 4. from Jan 19.
I now want to know the actual Version at a given date "Jan 14" for example? (answer here would be version=2, because at January 14 this is the actual version)
Access then should be included into a reporting-generator.

Thanks and best regards, Clemens.

[manthony · Accepted solution]

You could query the Confluence database. Here is an article from 2010 but the concepts are sound:

http://www.divingintothedetails.com/confluence/use-sql-to-quickly-get-information-out-of-confluence/