Is there a way to generate a single Collaborate Ultra attendance report for more than one session? Currently I can only view attendance reports for individual sessions.
We are self hosted, so I am not able to follow the steps outlined in this previous post: https://community.blackboard.com/message/13587-re-steps-for-pulling-collaborate-ultra-reports?commentID=13587#comment-13…
Hey Donald,
It's been a long time since I've supported Collaborate, I could be wrong.
Your Blackboard Learn is self-hosted, but Collaborate is hosted off-prem I'm pretty sure. Check with the guys in ICT whether they can log in to the SAS management platform and can find those reports.
If any Collab. related data is stored locally and my former colleagues are willing to help with custom reporting, the BB_COL_* prefixed tables are where they'll find it.
Regards,
Ashley
Thanks Ash, this is what I was looking for. Your former colleagues were able to produce a dump of data in MS Excel format, which I am sorting through now. There are some challenges with the data as it stores dates in Unix time format, but I think everything I need is in there.
No worries, for future reference, MSSQL has a date conversion function they can use to make it a bit more usable. I'm pretty sure the timestamps in all tables are stored as Unix timestamps, something like this should help out tremendously for any reporting: SQL Server CONVERT() Function.
There were a couple of times I made some reports for you guys where the DATEPART() function came in really handy as well (SQL Server DATEPART() Function). You can be string them together, if you wanted to do things like grouping by years or months:
Something similar to the following could be used to get a count of the courses created each year for example:
(Untested, I don't have MSSQL around to try)
SELECT
DATEPART(YEAR, CONVERT(VARCHAR, course_main.dtcreated, 106)),
COUNT(*)
FROM
course_main
WHERE
course_main.service_level = 'F'
GROUP BY
DATEPART(YEAR, CONVERT(VARCHAR, course_main.dtcreated, 106))
ORDER BY
DATEPART(YEAR, CONVERT(VARCHAR, course_main.dtcreated, 106)) ASC;
Edit: Without the WHERE will also include organisation information (stored alongside courses in that table). If you are only after courses, you must have the added where clause.
Thanks again Ash for taking the time to send this. The IT guys here have run both your suggested query as well as one suggested by the Behind the Blackboard team, but the results yield no 2018 course data. This is especially odd, as I requested a similar report only weeks earlier which returned 2018 courses that had made use of a Collaborate Ultra room at some point since the teaching period commenced; in other words this data is no longer present on our local databases.
So now this data is only accessible via the Collaborate Ultra SAS Manager login. The problem with this is that session reports can only be viewed individually, there is no functionality to run a report on more than one session.
As it turned out this process took so long that I've been told this report is no longer required, which is lucky because my only remaining option was to access ~25 pages of reports, with each page containing 25 session reports (so somewhere around 625 individual session reports). Hopefully this functionality has been introduced by the next time we require such a report!
To get Collaborate Ultra attendance reports, log into the scheduler with your manager account. Then select reports from the menu on the left and pick a range for the filter. You will need to open each session individually to get the attendance details. But you can see the total attendees and duration from the reports list.
Thanks Dan - this is exactly the steps required to view a report for an individual Bb Collaborate Ultra session report, however I need to get data on all Bb Collaborate Ultra sessions that took place within a date range.
I started Case #03083490 on Feb. 20th on this very topic. The current metric report in SAS while logged as with the Manager account lets you choose to include Ultra but that is for the Ultra sessions that were created with the dual B2 for Classic and Ultra before there was an Ultra specific B2. The current reports do not include information on Ultra sessions created via SAS login nor the Ultra specific B2. We should be able to display or download all of the reports with Ultra information included. Most of our users are using Ultra now either within or outside of a Bb course.
How else can we justify the cost of the product if we can't see how much it is used?
I agree Teresa that both classic and Ultra Collaborate reporting is limited. Perhaps Blackboard will introduce more Ultra reporting functionality in the future as more clients transition from Classic?
Help
Privacy
Behind the Blackboard
Blackboard.com
Hey Donald,
It's been a long time since I've supported Collaborate, I could be wrong.
Your Blackboard Learn is self-hosted, but Collaborate is hosted off-prem I'm pretty sure. Check with the guys in ICT whether they can log in to the SAS management platform and can find those reports.
If any Collab. related data is stored locally and my former colleagues are willing to help with custom reporting, the BB_COL_* prefixed tables are where they'll find it.
Regards,
Ashley