Product key of an installed license from Key ID

Situation: The ISV sells the software in retail market and no information about the customer is available. Now in case an end user faces any issue with the license, the ISV wants to get information about the product key installed on the machine so that an update can be generated. Only information available is the end-user’s ACC page.

 

Follow these steps to get the Product Key-

  1. Get the KeyID as displayed in ACC and get the C2V
  2. After checking-in the C2V, execute these queries in SQL Management Studio for EMS Database:

SELECT * FROM dbo.T_ENT_LICENSE
where FutureC2V like ‘%xxxxxxxxxxxxxxxxxx%’;
SELECT PRODUCTKEYID FROM dbo.T_ENT_ACTIVATION
where ActivationID=’yy’;
SELECT PKID FROM dbo.T_ENT_PRODUCT_KEY
where PRODUCTKEYID=’zz’;

Here, xxxxxxxxxxxxxxxxxx is the KEY-ID from client’s ACC page

yy is the result of first query

zz is the result of second query

The result of third query gives the desired product key.