Thank you Abhinav,
basically what I am doing is migrating hundreds of thousands of documents and their versions.
In one instance I migrate 150000 versions of files to Alfresco and need to verify that all 150000 were migrated.
Of course I could write a java script which writes to a log file when a file is uploaded, apply this via a rule to the target folder and then parse the logfile to verify individual files, however being able to see a direct total for the entire subtree would be great and if the count is the same then I can assume that all files are available.
We do write to a log in Excel when the tool we created fails to upload a file and we don't then upload later versions - these are all logged in the Excel file, however none of this shows the actual count in Alfresco.
I am happy to use other methods, but so far I have only created Java scripts in Alfresco to be run with rules and don't have any knowledge of using other methods to connect to any query the Alfresco DB.
Any advice here on e.g. where I can find basic instruction and tools for connecting to and querying the DB from a Windows client would be great.