Restore old License Usage stats after upgrading Quality Center

Following the upgrade of Quality Center from v.9 to v.10, the client asked whether it will be possible to retain the license usage history after the upgrade.
The upgrade was performed in three main stages, as follows:
Since all the QC instances were using the same database server, we ended up with three siteadmin_db databases. (One for QC9, the second for the temporary QC10 instance and the third for the finsl QC10 instance). This meant that the license usage history of the previous installations would not be visible in the final QC10 instance. To allow them to keep this history, I imported license usage data from QC9.0 into QC10. This was done as follows (using MS SQL as the database):
The tables involved are:
Step 1. Add “QC9” column to license tables:
This was done so that we could easily differentiate between the old records from QC9 and the records created by QC10. Be sure to add the “NULL” keyword. If this is not done the database will prevent records being added if the field does not have a value, which will result in future user logins failing.
Step 2. Import license usage data:
Insert into the QC10 table the contents of the corresponding QC9 table. Note that for the last field (QC9) we insert a value of 1. The first field in both tables contains the user’s session id. Each time a user logs in a new record is added and the value of the SESSION_ID is incremented. The SESSION_ID fields have a unique constraint, which means we can’t simply copy the records from the QC9 table. If we do this, subsequent login attempts may try to add a record to the table with a SESSION_ID value that already exists, causing the login to fail. To get around this we multiply the SESSION_ID of the QC9 records with -1 and use that for the session_id in the QC10 table.
Step 3. Update project names:
In most cases the project names will remain the same when going from QC9 to QC10. However, in our case the client wanted to change some of the project names going forward. They also wanted the suffix “_interim” added to the projects while they were hosted on the temporary server. The license history in QC10 only knows about it’s own projects and will therefore ignore all license usage data for logins to projects with other names. We therefore had to update the data that we imported so that the old project names and the “_interim” projects names are changed to the new project names, as follows:
Once this was done, all historical license usage statistics was now visible in the QC10 Admin console.
Always rember that changing data directly inside a Quality Center database has the potential to cause serious problems and may compromise the integrity of your poject and/or Quality Center installation. Before making any changes be sure that you have backed up all databases and project repositories.
Tech tips from JDS

Browser Console
Read More

Glide Variables
Read More

Understanding Database Indexes in ServiceNow
Read More

Fast-track ServiceNow upgrades with Automated Testing Framework (ATF)
Read More

ServiceNow Catalog Client Scripts: G_Form Clear Values
Read More

Is DevPerfOps a thing?
Read More

The benefits of performance testing with LoadRunner
Read More

Monitoring Atlassian Suite with AppDynamics
Read More

5 quick tips for customising your SAP data in Splunk
Read More

How to maintain versatility throughout your SAP lifecycle
Read More

How to revitalise your performance testing in SAP
Read More

Reserve and import data through Micro Focus ALM
Read More

How to effectively manage your CMDB in ServiceNow
Read More

ServiceNow and single sign-on
Read More

How to customise the ServiceNow Service Portal
Read More

Integrating a hand-signed signature to an Incident Form in ServiceNow
Read More

Integrating OMi (Operations Manager i) with ServiceNow
Read More

Implementing an electronic signature in ALM
Read More

Service portal simplicity
Read More

Learning from real-world cloud security crises
Read More

Static Variables and Pointers in ServiceNow
Read More

Citrix and web client engagement on an Enterprise system
Read More

Understanding outbound web services in ServiceNow
Read More

How to solve SSL 3 recording issues in HPE VuGen
Read More

How to record Angular JS Single Page Applications (SPA)
Read More

Calculating Pacing for Performance Tests
Read More

Vugen and GitHub Integration
Read More

Filtered Reference Fields in ServiceNow
Read More

ServiceNow performance testing tips
Read More

Monitor Dell Foglight Topology Churn with Splunk
Read More

Straight-Through Processing with ServiceNow
Read More

Splunk: Using Regex to Simplify Your Data
Read More

ServiceNow Choice List Dependencies
Read More

Tips for replaying RDP VuGen scripts in BSM or LoadRunner
Read More

Incorporating iSPI metric reports into MyBSM dashboard pages
Read More

Using SV contexts to simulate stored data
Read More

Recycle Bin for Quality Center
Read More

Agile Performance Tuning with HP Diagnostics
Read More

Understanding LoadRunner Virtual User Days (VUDs)
Read More

Problems recording HTTPS with VuGen
Read More

Generating custom reports with Quality Center OTA using Python
Read More

Asynchronous Communication: Scripting For Cognos
Read More

How to fix common VuGen recording problems
Read More

URL Attachments in Quality Center
Read More

Restore old License Usage stats after upgrading Quality Center
Read More

Changing LoadRunner/VuGen log options at runtime
Read More

Restricting large attachments in Quality Center
Read More

Retrieving Quality Center user login statistics
Read More

A comparison of open source load testing tools
...
Read More

Worst practices in performance testing
Read More