extracting user info from an mssql blackboard database using powershell

Thu, Jun 21, 2012

Having spent a few days installing Blackboard 9.1 SP8 onto Windows Server 2008 R2 and MSSQL Server 2008 I need to do a nightly export of courses to a central location. An ideal opportunity to add a new language to my portfolio, Powershell. I thought I’d flex my fledgling Powershell wings with getting user info from the database first and here’s the script in full as a gist. It connects to the Blackboard database and extracts username, names, emails and last login times.

Powershell to extract user information from MSSQL Blackboard database

comments powered by Disqus