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