| BuildDate |
datetime2 |
OctoSAM build date |
| BuildVersion |
nvarchar |
OctoSAM build version |
| CatalogConflicts |
bigint |
Number of conflicts in the software catalog at last catalog update |
| Created |
datetime2 |
Date/Time this statistics summary was created |
| CustomCounter1 |
bigint |
Not used by OctoSAM |
| CustomCounter2 |
bigint |
Not used by OctoSAM |
| CustomCounter3 |
bigint |
Not used by OctoSAM |
| CustomCounter4 |
bigint |
Not used by OctoSAM |
| CustomField1 |
nvarchar |
Not used by OctoSAM |
| CustomField2 |
nvarchar |
Not used by OctoSAM |
| CustomField3 |
nvarchar |
Not used by OctoSAM |
| CustomField4 |
nvarchar |
Not used by OctoSAM |
| Date |
date |
Date this entity got created |
| ErrorsLast24Hrs |
bigint |
Number of logged errors in the last 24 hrs |
| EsxMachines |
bigint |
Number of ESX hosts |
| ID |
bigint |
Internal ID for the StatisticsSummary entity (Primary Key) |
| ImportsLast24Hrs |
bigint |
Total number of imports in the last 24 hrs |
| IncompleteScanFileErrorsLast24Hrs |
bigint |
Number of logged incomplete scan file errors in the last 24 hrs |
| JavaInstallations |
bigint |
Total number of detected Java installations of any type |
| JavaPackages |
bigint |
Number of different Java packages installed |
| LastHousekeepingEnd |
datetime2 |
Date/Time the last housekeeping ended |
| LastHousekeepingStart |
datetime2 |
Date/Time the last housekeeping got started |
| LicenseGraceUnits |
bigint |
Grace license that allow operation of OctoSAM even if the license units are exceeded |
| LicenseManagerServersErrorsLast24Hrs |
bigint |
Number of logged license manager server observer errors in the last 24 hrs |
| LicenseOptions |
nvarchar |
License options |
| LicenseReadOnlyAfter |
datetime2 |
After this date, OctoSAM can only be used in read-only mode |
| LicenseServerGraceUnits |
bigint |
Grace server license units |
| LicenseServerUnits |
bigint |
Assigned server license units |
| LicenseUnits |
bigint |
Assigned license units (machines) |
| LicenseValidThru |
datetime2 |
License expiry date |
| LinuxImportsLast24Hrs |
bigint |
Number of imported Linux scans in the last 24 hrs |
| LinuxMachines |
bigint |
Number of Linux machines |
| Machines |
bigint |
Number of machines |
| MachinesDeletedInDirectory |
bigint |
Number of machines that we detected as deleted in directory |
| MachineSoftwareSignatures |
bigint |
Size of the machine to software signature relation |
| MacImportsLast24Hrs |
bigint |
Number of imported Mac scans in the last 24 hrs |
| MacMachines |
bigint |
Number of Macs |
| OracleJavaApprovedJavaInstallations |
bigint |
Number of approved Oracle Java SE installations that might consume a license |
| OracleJavaLicensingRelevantInstallations |
bigint |
Number of Oracle Java SE installations that require a paid subscription |
| OracleJavaMsiInstallations |
bigint |
Number of Oracle Java SE installations that were made using a .MSI installaion that may require a paid license |
| OrganizationID |
bigint |
Internal ID that references the Organization entity (Foreign Key) |
| Res1 |
nvarchar |
Reserved for future use |
| Res2 |
nvarchar |
Reserved for future use |
| Res3 |
nvarchar |
Reserved for future use |
| ResCounter1 |
bigint |
Reserved for future use |
| ResCounter2 |
bigint |
Reserved for future use |
| ResCounter3 |
bigint |
Reserved for future use |
| ResCounter4 |
bigint |
Reserved for future use |
| ScannerErrorsLast24Hrs |
bigint |
Number of reported scanner errors in the last 24 hrs |
| ScannerWarningsLast24Hrs |
bigint |
Number of reported scanner warnings in the last 24 hrs |
| Servers |
bigint |
Number of machines with a server operating system |
| ServersDeletedInDirectory |
bigint |
Number of servers that we detected as deleted in directory |
| SoftwarePackages |
bigint |
Number of software packages in the database |
| SoftwarePackageUsageDetails |
bigint |
Number of software package metering records |
| SoftwareSignatures |
bigint |
Number of software signatures in the database |
| UsageDetails |
bigint |
Number of software metering detail records |
| Users |
bigint |
Number of users |
| WarningsLast24Hrs |
bigint |
Number of logged warnings in the last 24 hrs |
| WindowsMachines |
bigint |
Number of Windows machines |
| WindowsServers |
bigint |
Number of Windows servers |
| WindowsWorkstations |
bigint |
Number of Windows Workstations |
| WmiInstanceProperties |
bigint |
Number of WMI instance properties |