From Seapine Labs

Contents 1 Overview 2 License Server Setup 3 Reporting 3.1 Native Database 3.2 MySQL 3.2.1 SQL Server Reporting Services 3.2.1.1 Visual Studio Setup 3.3 SQL Server 3.3.1 SQL Server Reporting Services

[edit] Overview

The Seapine License Server collects metrics on license usage, allowing you to see how licenses are being used across your Surround SCM and/or TestTrack installations.

[edit] License Server Setup

Read the LS Admin Guide for more information on how to setup the logging.

[edit] Reporting

For now at least, there's no UI component to this. The server will log licensing events but doesn't provide a mechanism to display or chart any of that data.

The examples below should get you started, and in many cases I expect they'll provide more than enough information as-is.

Download Samples

[edit] Native Database

Not recommended, but if you insist you can use the TestTrack ODBC driver to connect to the License Server tables.

With that installed and working, you can connect through MS Access or Excel and do some one-off metrics on license usage.

The biggest drawback to this approach is that you can't really do real-time reports and the queries have to be pretty straight-forward. No complexities like the RDBMS options offer.

[edit] MySQL

[edit] SQL Server Reporting Services

The samples here were developed in Visual Studio 2008 and tested in SSRS 2008.

[edit] Visual Studio Setup

To create reports or edit the samples, you'll need to install Visual Studio 2008. Then you'll need to install the MySQL ODBC driver.

Once you've installed the ODBC driver, create a System DSN to connect to your TestTrack Project.

Lastly, create a shared data source connecting to the DSN you just created.

Click Test Connection to make sure everything's working!

[edit] SQL Server

[edit] SQL Server Reporting Services

The samples here were developed in Visual Studio 2008 and tested in SSRS 2008.

Note: Seapine does not provide support for sample scripts.