Trello task reporting using SQL Server 2012.

Trello – let’s say you want to organize some tasks, like say anything-you-can-think-of, you can use Trello.

We use it to manage our Tasks and Projects in IT. It really is an awesome tool and the price is great, free, my type of budget that, but we need to expand it a bit so we can report it to death. In that way we can prove we are really busy and our nice fat bonuses are justified, and that new HP Elitebook 850.. and my home DSL.. and my cellphone.

So in order to see if I can get a nicer chair and bigger coffee mug we have endeavored to publish our Trello data via SSRS in SharePoint.

1. What do we need?

You will need PowerShell 3.0 on the machine you want to run this one on. You can code some hectic PS stuff and invoke a command on a remote machine with PS 3 installed if you cannot install version 3, but I doubt you will encounter an issue like that.

PS C:\Users\services> $PSVersionTable.PSVersion

Major  Minor  Build  Revision —–  —–  —–  ——– 3      0      -1     -1

You will need SQL Server any flavour, I cannot vouch for all versions, but I assume this will go from 2005 upwards, if it does not, just let me know.

2. Trello

Well, this won’t work if you don’t have it.

3. An understanding of what I am doing.

  1. Each person has a list, see mine “ANS – Adriaan Sullivan”