I've been putting together some content and usage reports using SSRS. I've found the tables which contain sections, folders and resources, which is great because I can now run reports of what kind of content teachers are creating.
One thing I can't seem to find is the table or tables which associates a resource with a folder or section (i.e. placing it within said folder).
Can anyone help ?