License Use Metrics

talks about Surround SCM, TestTrack Pro, TestTrack RM, TestTrack TCM on May 18, 2010

With the release of Surround SCM 2010 & TestTrack 2010.1, the Seapine License Server now supports logging license usage events. This presents an opportunity to better understand how licenses are being used across your Surround SCM and TestTrack installation.

We’ve had the TT License Monitor tool for quite a while, but it provides a very limited set of data on floating licenses and nothing on named license usage. I’ve been excited about the new logging functionality ever since I saw the first design document, and when it was code complete I immediately put “take it for a spin” on my schedule.

Delayed Gratification

The first thing you should know is that there is no historical data to “upgrade,” meaning when you first upgrade to the new version of the license server there won’t be any data to look at. But from that point forward, it will begin recording usage stats and in a few weeks you’ll be ready to dive in.

Second, if you’re not running the license server on an RDBMS you should be if you want to use this new functionality. You can manually turn on the logging for Codebase, but there is no front-end UI for the data and access to the Codebase tables outside of the license server is limited.

Reporting

No UI?! Right, for now at least there are no fancy charts or graphical tools built-in to view the data. To help you get started with analyzing license usage we have created sample queries and reports showing various slices of the data.

Download the samples:

  • SQL Report Services 2008 report (against SQL Server & MySQL)
  • Access 2007 database and Excel 2007 pivot table (against Codebase, very limited)

Here is the SSRS report included in the zip (for SQL Server and MySQL).

ludSSRS

More Questions?

If you have questions you can read the user guide, contact support, or leave a comment. Would also love to hear back from folks in the comment section, how are you using the data and how has it helped your organization?

Share on Technorati . del.icio.us . Digg . Reddit . Slashdot . Facebook . StumbleUpon

Related posts:

  1. SQL Server Reporting Services
  2. External Reporting API
  3. TestTrack Reporting Dashboards – SSRS
  4. SQL Server Reporting Services Data Models
  5. Querying TestTrack and Surround SCM Data From Excel
4 Comments

Tags: , ,

4 Comments to License Use Metrics

Udo
May 19, 2010

Is Reporting also possible when you are using a PostgreSQL Database?

Matt Harp
May 19, 2010

Certainly, see this post on Labs: http://labs.seapine.com/wiki/index.php/Third_Party_Reporting_with_PostgreSQL.

Rob C
April 4, 2011

Have you seen any issues with stale data in the usage report? Under Currently Logged In, I have have one TTP user listed as follows:

John Doe – Floating – 461 (hr)

Checking the license server and using the loicense monitor, that user is not logged in.

Matt Harp
April 4, 2011

Rob,

I have not seen that happen before, did you ping Support on that? Seems like a logoff transaction was missed or not properly logged somewhere.

Leave a comment

WP_Big_City

Leave a Reply

Your email address will not be published. Required fields are marked *

*

* Copy this password:

* Type or paste password here:

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Spam Protection by WP-SpamFree

Page optimized by WP Minify WordPress Plugin