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-
- Get the KeyID as displayed in ACC and get the C2V
- 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
SELECT PKID FROM dbo.T_ENT_PRODUCT_KEY
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.