Input Parameter: Key Id
Output :
- Customer Name (CSTMRName)
- Entitlement ID (ENTId, EId)
- Start date of Entitlement (StartDate)
- End date of Entitlement (EndDate)
- Reference ID 1 (RefId1)
- Reference ID 2 (RefId2)
- Key Type (KeyTypeId)
- Hasp ID (HASPId)
- Product ID (PrdId)
- Product Name (PRDName)
- Product Version (productVersion)
- Feature ID (FTRId)
- Feature Name (FTRName)
- License Model (LMName)
Note: The exact ‘Column Names’ (from the below mentioned EMSDB Tables) are mentioned in bracket(s), as above.
- T_ENT
- T_ENT_LINE_ITEM
- T_ENT_ACTIVATION
- T_TARGET
- T_ENT_LINE_ITEM_PRD_SUITE
- T_ENT_FTR_LM
- T_LM
- T_PRD
- T_PRD_FTR_REF
- T_FTR
SQL-Query is as follows :
DECLARE @KEY_ID varchar(255);
SET @KEY_ID = ‘Enter Key Id’;
SELECT Top 1 CSTMRName, te.ENTId, EId, te.Descr, te.StartDate, te.EndDate, te.RefId1, te.RefId2, tt.KeyTypeId, tt.HASPId, telips.PrdId, PRDName, tp.Ver AS productVersion, tf.FTRId,FTRName, LMName FROM dbo.T_CSTMR tc
JOIN dbo.T_ENT te ON te.CSTMRId = tc.CSTMRId
JOIN dbo.T_ENT_LINE_ITEM teli ON teli.ENTId = te.ENTId
JOIN dbo.T_ENT_ACTIVATION tea ON tea.LineItemId = teli.LineItemId
JOIN dbo.T_TARGET tt ON tt.TargetId = tea.TargetId
JOIN dbo.T_ENT_LINE_ITEM_PRD_SUITE telips ON telips.LineItemId = teli.LineItemId
JOIN dbo.T_ENT_FTR_LM tefl ON tefl.PrdSuiteLineItemId = telips.PrdSuiteLineItemId
JOIN dbo.T_LM tl ON tl.LMId = tefl.LMId
JOIN dbo.T_PRD tp ON tp.PRDId = telips.PrdId
JOIN dbo.T_PRD_FTR_REF tpfr ON tpfr.PRDId = tp.PRDId
JOIN dbo.T_FTR tf ON tf.FTRId = tpfr.FTRId
WHERE (tt.HASPId = @KEY_ID)