Identifying license type in ALM database for metrics
Question ID: 106227
1
0

For more detailed reporting on license activity and consumption, we want to use the DB direct for some information out of site admin schema.

What I need to know is what the LS_license_type and/or LHS_license_type from the SESSION_LICENSE and SESSION_LICENSE_HISTORY values actual correspond to in terms of the actual license.

Marked as spam
Posted by (Questions: 104, Answers: 0)
Asked on July 29, 2015 7:36 pm
143 views
Answers (2)
1
Private answer

Hello,

Listed below is what HP identifies under KM articles KM01691658.

License types (''SLH_LICENSE_TYPE'') in ''SESSION_LICENSE_HISTORY'' - ALM 11,11.5.x and 12.x

**Till ALM 11:**
The meaning of the values of the column ''SLH_LICENSE_TYPE'' of the table ''SESSION_LICENSE_HISTORY'' is as follows:

01 - Defects
02 - Testplan / Testlab
03 - Requirements
12 - Dashboard
13 - BPT / Components
17 - Service Test
20 - SAP

**From ALM 11.5x:**
The meaning of the values of the column ''SLH_LICENSE_TYPE'' of the table ''SESSION_LICENSE_HISTORY'' is as follows:

100 -> DEFECTS
101 -> TESTS
102 -> REQUIREMENTS
103 -> QUALITY_CENTER_FULL
104 -> management
105 -> dashboard
106 -> components
109 -> BPT_FULL
300 -> SOA
400 -> SAP_BPT
401 -> SAP_CIT_FULL
402 -> SAP_SPI_FULL
500 -> APM
600 -> PC_FULL

Marked as spam
Posted by (Questions: 1, Answers: 116)
Answered on July 29, 2015 7:39 pm
0
Outstanding!
( at July 29, 2015 7:40 pm)
1
Private answer

Also found one more:

1007 -> Community

Marked as spam
Posted by (Questions: 1, Answers: 116)
Answered on July 29, 2015 7:54 pm
EyeOnTesting

Welcome back to "EyeOnTesting" brought to you by Orasi Software, Inc.

X
Scroll to Top