Posts Tagged ‘SQL-Query’

Sort by: Most recent
 

SQL-Query to return ‘All Entitlements and their content that are assigned to a specific Key Id’

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…