KanBo Usage Statistics scripts
Last modified:
We provide special database scripts, which can give you even more insights about KanBo.
Scripts will answer your questions:
- How many users were active (read/write)?
- How many users were active (read/write) in this board?
- How many activities per Board/All Boards?
- How much storage does the SP Website behind the Board use? How much storage does use the whole SC?
- List all boards with all users/number of users/lists/cards/archived cards/number of activities at time period - sortable per each result
- What's number of Activities in a board/all boards at time period?
Please contact us at support@kanboapp.com to receive scripts and manuals how to use them. As scripts need to be run on a KanBo database, please contact your IT administrator for further help in obtaining the results.
1. All active users
You should use AllActiveUsers.sql script. This script shows you active users in a chosen period of them. You can also specify a board in which these users are active.
Usage:
Set above variables for different results:
@dFromDate - DATE in neutral format ('YYYYMMDD') from which it should collect data egz. '20171122'
@dToDate - DATE in neutral format ('YYYYMMDD') to which it should collect data egz. '20171130'
@dBoard - board id for which data should be collected egz. 6
Replace database name with your database
All of them can be set to NULL, but if @dFromDate is set to NULL @dToDate will be ignored either way.
Result may differ depending on parameters.
Example:
Showing results from 01.01.2018 to 06.07.2018 in board of ID 1072.
Result in SQL:
Result in Excel:
2. All Active Users Count
You should use AllActiveUsersCount.sql script. This script is same in usage like AllActiveUsers.sql but instead of listing user names of active users this one just presents number of users that were active, presented under ActiveCount column
Example:
Showing results from 01.01.2018 to 06.07.2018 in board of ID 1072.
Result in SQL:
3. Function
You should user Function.sql script. This script will save function that will retrieve number of activities for selected board, based on given parameters.
Parameters:
@dFromDate – date in neutral format ‘YYYYMMDD’ from which activities will be counted
@dToDate – date in neutral format ‘YYYYMMDD’ to which activities will be counted
@dBoardId – id of a board for which activities will be counted
4. Get counts
Firstly, use Function.sql to prepare your database. Then, run GetCounts.sql script.
Script returns table containing board name, lists count, cards count, archived cards count, user count and activities
count.
Parameters:
@dFromDate – date in neutral format ‘YYYYMMDD’ from which activities will be counted
@dToDate – date in neutral format ‘YYYYMMDD’ to which activities will be counted
Showing results from 01.01.2017 to 06.07.2018,
Results in Excel:
5. User's Boards
Run UserBoards.sql. This script check to which boards user is added by his ID. You can check user's ID by looking into dbo.Users.
Parameters:
@dUserId – id of a user for which you want to check
Results of looking for user Alexander Kaiser (ID in KanBo is 33).
Results in SQL:
6. SharePoint size
Script userd is SharePointSize.ps1.
This is powershell script not sql script. It should be launch on the sharepoint machine because it is
using Sharepoint libraries to obtain required data. After setting proper connection string and file
path you can start a script. First script will try to read database to obtain all kanbo boards
addresses. Then it will try to count sizes for each web. Results will be shown in the powershell
window and saved as csv file in selected location. Size is presented in MB.
Parameters:
$connectionString – connection string to KanBo Content database
$filePath – path for saving csv file
Results in Powershell:
Results in .csv file: