Pls provide me a query for the access details (User details and level of access) for all the folders

[jpotts]

There is nothing available out of the box that does exactly what you want so you're going to have to roll up your sleeves and do the work.

Axel gave you a great answer detailing how to do it. Please try it out and report back with the specific area that gives you trouble.