I want to produce a spreadsheet containing a list of all the K2 processes and for each process the activity. I would prefer TSQL to generate this but don't mind using SmartObject reporting if necessary.
To be clear I don't want information about active instances but the same list you get in the ManagementConsole when you expand each process tree view.