# Data Types

Open iT defines data types as the way in which different sets of data are categorized, structured, and organized to accommodate specific reporting needs and analytical requirements. This includes defining how data is aggregated, grouped, and formatted to ensure accurate and meaningful representation in reporting and analysis.

ID Data Type Name Remarks Analysis Server Support
33 Windows Inventory SQL Support
117 Dongle Data Inventory 1 SQL Support
118 Product Inventory 1 SQL Support 2
135 License Subscription Inventory Deprecated SQL Support
136 License Product Assignment 1 Deprecated SQL Support
139 License Subscription Inventory v2 1 SQL Support
140 License Product Assignment v2 1 SQL Support
142 Software Catalog Query Info
LicenseAnalyzer™ - Level 0 (Inventory) Data Types

ID Data Type Name Remarks Analysis Server Support
31 Windows Periodic Summary App Usage superseded by 130 SQL Support 2
34 Windows Concurrent Usage Full Support
35 Unix Concurrent Usage
45 Total License Use v2.0 superseded by 102 SQL Support
46 Individual License Use v2.0 superseded by 94 SQL Support
47 Host License Use v2.0
49 Host User License Use 1 Full Support
50 Host User License Use Logfile
51 Total License Use Logfile
52 Denied License Use Logfile superseded by 75
53 Windows Module Usage
60 Total License Queued
61 Individual License Queued
71 Usergroup License Use v2.0 superseded by 95
72 Hostgroup License Use v2.0
75 License Logfile Events 1 Full Support 3
76 Total Queued Logfile
77 Individual Queued Logfile
79 Internet Explorer URL Use
81 Windows Host Application Concurrent Usage
82 Windows Host Executable Concurrent Usage
83 Host License Use Logfile
84 Individual License Use Logfile
85 Usergroup License Use Logfile
86 Hostgroup License Use Logfile
89 Total License Use Licenseevents 1
90 Individual License Use Licenseevents 1 Full Support
91 Usergroup License Use Licenseevents 1 Full Support
93 OLAP Raw Hourly 1 Only used in Analysis Server Full Support
94 OLAP User Concurrency 1 Full Support
95 Usergroup License Use v3.0 1 Full Support
96 OLAP Winapp Raw Hourly 1 Only used in Analysis Server SQL Support
102 OLAP Total Use 1 Full Support
103 OLAP Featureset PPU Full Support
104 License Logfile Events v2.0 1 Full Support
105 Individual Module Usage
106 Total Module Usage
107 Denied License Use Licenseevents 1 Full Support
108 Host License Use Licenseevents 1 Full Support
109 Hostgroup License Use Licenseevents 1 SQL Support
110 License Application Version
111 Total License Use Appversion
112 User License Use Appversion
113 Usergroup License Use Appversion
114 Total PPU License Use
115 Hostgroup License Use v3.0 Full Support
116 Total PPU License Use Logfile
119 Dongle License Use 1 SQL Support
124 License Model User Concurrency 1 Full Support
125 License Model Total Use 1 Full Support
126 License Peak Usage Distinct Host 1 Full Support
127 License Host User Usage Distinct Host 1 Full Support
128 Usergroup License Use Distinct Host 1 Full Support
129 FlexNet Log Events Full Support
130 Windows Application Usage 1 SQL Support
131 V-Ray License Usage 1 SQL Support
132 V-Ray License User Concurrency 1 SQL Support
137 License Token Individual Usage SQL Support
138 License Token Total Usage SQL Support
143 Normalized License Total Concurrency SQL Support 2
144 Normalized License User Host Concurrency SQL Support 2
145 Normalized License Maxed Out SQL Support 2
146 License Seat Usage SQL Support
LicenseAnalyzer™ - Level 1 (Runtime Usage) Data Types

ID Data Type Name Remarks Analysis Server Support
0 Unix Pacct SQL Support 2
32 Unix Application Usage
54 Extended Pacct
56 UsageAnalyzer Break SQL Support
57 UsageAnalyzer Work SQL Support
58 UsageAnalyzer Events SQL Support
62 License Optimizer Use SQL Support
64 License Optimizer Events 1
70 License Optimizer Total Use 1 Full Support 3
87 Process Accounting SQL Support
92 License Optimizer Action 1 Full Support
97 Olap Freeze Raw Hourly Only used in Analysis Server Full Support
98 License Optimizer Individual Usage 1 Full support
99 License Optimizer Usergroups 1 Full Support
120 Web App Browser Log 1 Full Support
121 Web App Proxy Log Unused Full Support
122 Web App Browser Activity Unused Full Support
123 Web App Total Use 1 Full Support
141 Freeze Feature Usage Only used in Analysis Server Full Support
LicenseAnalyzer™ - Level 2 (True Active Usage) Data Types

ID Data Type Name Remarks Analysis Server Support
2 LSF (Batch Jobs) SQL Support 2
3 VMstat
4 PSM-Shell Unused
5 LSF (LSF Acct) Unused
6 SAR SQL Support
27 IOstat Deprecated
28 PSM-Wrapper
36 WinSAR SQL Support
48 Grid Engine
78 LSF Pending Reason SQL Support
80 PBS Accounting
133 Azure Sign-in Events SQL Support
134 Azure Resource Usage Cost SQL Support
ComputeAnalyzer™ Data Types

ID Data Type Name Remarks Analysis Server Support
24 Filesystems Full Support 3
25 ADSM
26 Physical Disk
29 Filespace Full Support
40 Quota
59 Disk Utilization
StorageAnalyzer™ Data Types


1. Data generation is enabled by default in Core Server.

2. Data is loaded to the SQL database for the external reporting tool.

3. Data is loaded to the SQL database and processed to the OLAP cubes for advanced reporting.

We value your feedback!

Please take a few minutes to complete our survey and share your thoughts on your recent experience with our documentation.

Take survey

Close