A complex report for a simple request – how many people are using PebblePad per faculty? Complex because the user data in PebblePad doesn’t contain any information beyond key, username, forename, surname, email and a few other non-pertinent bits and bobs. But I am not easily daunted.
One of these ‘non-pertinent’ bits of information is a ‘last login’ date so I was able to restrict the report to people who had logged in during the past thirty days. I ran a query on the PebblePad database to get all relevant username data for this time period, and then ran a query in Blackboard to get all user data full stop. Why? Because the ‘user’ table in Blackboard does have a field for Faculty. Well, actually it is in a different field because of the way the user accounts are imported from Active Directory, but it was sufficient. Then it was simply a case of importing both resulting CSV files into an Access database and running a join on the username.
Unsurprisingly our Faculty of Health, Community and Education Studies were the biggest users, but it wasn’t as clear cut as I had suspected. They accounted for just under half of all usage, with Engineering and Environment accounting for around a quarter, and the remaining two faculties and service departments sharing the remainder.1 Comment