Monitoring ClearCase License Usage

One of the SCM daily tasks is to monitor the ClearCase license usage. I wrote a simple script to gather the data periodically and generate an excel chart as the report.

The recent reports showed that the license usage hit our max licenses on peak hours. It means that some developers would get a "no license" error when trying ClearCase operations. The reason is that the development team started a new project and many new hires started to join the team. Based on this, we purchased new licenses to accommodate more concurrent ClearCase access.