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?
Digital Community Manager, Alfresco Software. Problem solved? Click Accept as Solution!