 |
 |
Hi I'm in the process of building a custom reporting system and have stumbled across a few issues. Mainly to do with not knowing what table the data is stored in. Hopefully someone maybe able to help me or point me in the right direction. I am having difficulties finding the following data: Wiki details I'm trying to generate a report that lists all wiki's and the total number of pages within each wiki. Also the total number of contributors per wiki and the number of views per wiki. Does anyone know of an sql that may help me? Or the name of the tables the details of Wiki's are stored in? Blog's Does anyone know what tables blog details are stored in as I need to generate a similar report as the Wiki above. Group Access This sql will be slightly different as the report will need the total hits for different roles. I believe the Activity_Accumulator stores user activity. But how do I distinguish that Group details have been accessed? Track-able Items I need to create an sql that lists all track-able items in the system and also a count of the role activity. What table is track-able items stored in? Many thanks for your help. Regards, Mark Petty Senior Application Developer Information Systems / IT Services Bournemouth University Tel: 01202 968137 The UK's no. 1 new university The Guardian University Guide 2009 This email is intended only for the person to whom it is addressed and may contain confidential information. If you have received this email in error, please notify the sender and delete this email, which must not be copied, distributed or disclosed to any other person. Any views or opinions presented are solely those of the author and do not necessarily represent those of Bournemouth University or its subsidiary companies. Nor can any contract be formed on behalf of the University or its subsidiary companies via email.