Update 3/13/13 - Updated report download link and moved report to TechNet Gallery.
The sample Group Chat dashboard* provides administrators with an overview of relevant information about their Group Chat environment. This report is similar to the OCS Archiving Report, in that it is an example of some of the information that can be pulled out of the OCS databases and presented in an easy to understand view. Below is an example of what the Group Chat dashboard looks like. It has been tested against OCS 2007 R2 Group Chat and SQL Reporting Services 2008. You will need to have a functioning SQL Reporting Services server before trying to deploy this report.
The reports are now linked to the data source and ready to be used.
Using the Report
The dashboard is made up of 4 separate reports (the main dashboard report, a group details report, new users report, and a user details report). The main dashboard report gives you an overview of all the information contained in the reports. In this dashboard you can see the numbers of posts on a monthly basis broken down by the type of post that it is (post, story, attachment, alert). You can also see the number of new users added to Group Chat, the most active and least active chat rooms, largest and smallest chat rooms and the most active users based on number of posts.
The group details report shows you the list of users assigned to a particular chat room and whether or not they are a manager of that chat room or a member. You can access this report by click on the Chatroom Member Details link on the Group Chat dashboard or by clicking on one of the hyperlinked chat room names.
The new users report shows you new users that were added to Group Chat and what day they were added on. You can access this report by clicking on the New Users bar graph on the Group Chat dashboard.
Clicking on a hyperlinked username will bring up the user details report for that user. This report shows you a consolidated view of information for that user. You can find when the user was added to Group Chat, and what chat rooms and membership levels they are assigned.
If you have drilled into one of the reports and need to navigate back to the Group Chat dashboard, you can click on the report name in the title bar.
This report is an example* of some of the information that you can get out of the Group Chat database. Feel free to modify the report to fit your needs. The latest version of the report is attached to this post. Please use the comments to give feedback on what you like, don't like, or what you would like to see in a future version.
Click here to download the latest version of the report.
A big Thank You to Rich Thorp for helping me put together this report!
I have followed the steps and the reports run great in my test lab which has minimal data. I tried running the report on production and I am getting this error. Would you know what it might be?
An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for dataset 'Chat_Counts'. (rsErrorExecutingCommand)
Cannot find either column "dbo" or the user-defined function or aggregate "dbo.fnDateToTicks", or the name is ambiguous.
Is it possible to see how many people have logged into Group Chat?
I'll have to go back and look at the database. It's probably possible, but it's been awhile since I've played with the report. It's something I'll put on the list of ideas for new features for an updated version of the report. Thanks for the feedback!
That would be great! One other thing that I think would be helpful, when listing the chatroom memberships, I realize the report references explicit members, it would be helpful if it also listed any AD groups which have access or are assigned as managers. I understand displaying the members of those AD groups could be troublesome depending on various permissions, but at least seeing the group listed would be helpful. Right now when I see a chatroom listed as most active with 12 sessions but I only see one user it's a little odd. I have to go into the administrator and display memberships. Those changes would be most helpful! Thanks for considering them
I agree with Stephen on both additions. Looking forward to hearing back!