StatisticsSummary¶
This table contains summary statistics about the current state of the OctoSAM Inventory installation. It is updated by the OctoSAM Inventory housekeeping process.
Fields¶
| Field | Type | Description |
|---|---|---|
| AndroidMachines | numeric | Number of Android machines |
| AndroidTablets | numeric | Number of Android tablets |
| BuildDate | datetime | OctoSAM build date |
| BuildVersion | string | OctoSAM build version |
| CatalogConflicts | numeric | Number of conflicts in the software catalog at last catalog update |
| Created | datetime | Date/Time this statistics summary was created |
| CustomCounter1 | numeric | Not used by OctoSAM |
| CustomCounter2 | numeric | Not used by OctoSAM |
| CustomCounter3 | numeric | Not used by OctoSAM |
| CustomCounter4 | numeric | Not used by OctoSAM |
| CustomField1 | string | Not used by OctoSAM |
| CustomField2 | string | Not used by OctoSAM |
| CustomField3 | string | Not used by OctoSAM |
| CustomField4 | string | Not used by OctoSAM |
| Date | date | Date this entity got created |
| ErrorsLast24Hrs | numeric | Number of logged errors in the last 24 hrs |
| EsxMachines | numeric | Number of ESX hosts |
| ID | numeric | Internal ID for the StatisticsSummary entity (Primary Key) |
| ImportPendingFiles | numeric | Number of scan files that are pending import. Not yet implemented. |
| ImportsLast24Hrs | numeric | Total number of imports in the last 24 hrs |
| ImportTimeAvgMillisLast24Hrs | numeric | Average import time in milliseconds for imports in the last 24 hrs |
| ImportTimedFilesLast24Hrs | numeric | Number of timed imports in the last 24 hrs |
| ImportTimeLowerMillisLast24Hrs | numeric | Lower 5 percentile of import times in milliseconds for imports in the last 24 hrs |
| ImportTimeMaxMillisLast24Hrs | numeric | Upper 5 percentile of import times in milliseconds for imports in the last 24 hrs |
| ImportTimeMedianMillisLast24Hrs | numeric | Median import time in milliseconds for imports in the last 24 hrs |
| ImportTimeMinMillisLast24Hrs | numeric | Minimum import time in milliseconds for imports in the last 24 hrs |
| ImportTimeQ1MillisLast24Hrs | numeric | 1st quartile of import times in milliseconds for imports in the last 24 hrs |
| ImportTimeQ3MillisLast24Hrs | numeric | 3rd quartile of import times in milliseconds for imports in the last 24 hrs |
| ImportTimeUpperMillisLast24Hrs | numeric | Upper 5 percentile of import times in milliseconds for imports in the last 24 hrs |
| IncompleteScanFileErrorsLast24Hrs | numeric | Number of logged incomplete scan file errors in the last 24 hrs |
| IosMachines | numeric | Number of iOS machines |
| IpadOsMachines | numeric | Number of IpadOS machines |
| JavaInstallations | numeric | Total number of detected Java installations of any type |
| JavaPackages | numeric | Number of different Java packages installed |
| LastHousekeepingEnd | datetime | Date/Time the last housekeeping ended |
| LastHousekeepingStart | datetime | Date/Time the last housekeeping got started |
| LicenseGraceUnits | numeric | Grace license that allow operation of OctoSAM even if the license units are exceeded |
| LicenseManagerServersErrorsLast24Hrs | numeric | Number of logged license manager server observer errors in the last 24 hrs |
| LicenseOptions | string | License options |
| LicenseReadOnlyAfter | datetime | After this date, OctoSAM can only be used in read-only mode |
| LicenseServerGraceUnits | numeric | Grace server license units |
| LicenseServerUnits | numeric | Assigned server license units |
| LicenseUnits | numeric | Assigned license units (machines) |
| LicenseValidThru | datetime | License expiry date |
| LinuxImportsLast24Hrs | numeric | Number of imported Linux scans in the last 24 hrs |
| LinuxMachines | numeric | Number of Linux machines |
| Machines | numeric | Number of machines |
| MachinesDeletedInDirectory | numeric | Number of machines that we detected as deleted in directory |
| MachineSoftwareSignatures | numeric | Size of the machine to software signature relation |
| MacImportsLast24Hrs | numeric | Number of imported Mac scans in the last 24 hrs |
| MacMachines | numeric | Number of Macs |
| OracleJavaApprovedJavaInstallations | numeric | Number of approved Oracle Java SE installations that might consume a license |
| OracleJavaLicensingRelevantInstallations | numeric | Number of Oracle Java SE installations that require a paid subscription |
| OracleJavaMsiInstallations | numeric | Number of Oracle Java SE installations that were made using a MSI installation that may require a paid license |
| OrganizationID | numeric | Internal ID that references the Organization entity (Foreign Key) |
| Res1 | string | Reserved for future use |
| Res2 | string | Reserved for future use |
| Res3 | string | Reserved for future use |
| ResCounter1 | numeric | Reserved for future use |
| ResCounter2 | numeric | Reserved for future use |
| ResCounter3 | numeric | Reserved for future use |
| ResCounter4 | numeric | Reserved for future use |
| ScannerErrorsLast24Hrs | numeric | Number of reported scanner errors in the last 24 hrs |
| ScannerWarningsLast24Hrs | numeric | Number of reported scanner warnings in the last 24 hrs |
| Servers | numeric | Number of machines with a server operating system |
| ServersDeletedInDirectory | numeric | Number of servers that we detected as deleted in directory |
| SoftwarePackages | numeric | Number of software packages in the database |
| SoftwarePackageUsageDetails | numeric | Number of software package metering records |
| SoftwareSignatures | numeric | Number of software signatures in the database |
| UsageDetails | numeric | Number of software metering detail records |
| Users | numeric | Number of users |
| WarningsLast24Hrs | numeric | Number of logged warnings in the last 24 hrs |
| WindowsMachines | numeric | Number of Windows machines |
| WindowsServers | numeric | Number of Windows servers |
| WindowsServersNotScannedFromActiveDirectory | numeric | Number of Windows Servers not found in Active Directory scans |
| WindowsWorkstations | numeric | Number of Windows Workstations |
| WindowsWorkstationsNotScannedFromActiveDirectory | numeric | Number of Windows Workstations not found in Active Directory scans |
| WmiInstanceProperties | numeric | Number of WMI instance properties |