CatalogUpdateLog¶
Information about OctoSAM catalog updates and statistics sent to the central update service. The table also keeps a license history and log statistics used for Java consolidation projects.
Fields¶
| Field | Type | Description |
|---|---|---|
| AndroidMachines | numeric | Number of Android machines in the inventory at time of update |
| AndroidTablets | numeric | Nubmer of Android tablets in the inventory at time of update |
| ApprovedJavaInstallations | numeric | Number of approved Java installations that require an Oracle license |
| BuildDate | datetime | OctoSAM build date that did the update |
| BuildVersion | string | OctoSAM build version that did the update |
| CatalogConflicts | numeric | Number of conflicts encountered during catalog update |
| CatalogUpdateFileName | string | File name of the used catalog update file |
| CatalogUpdateStatus | string | Status returned by the central update service |
| Created | datetime | Date/time this record was created |
| DisplayVersion | string | OctoSAM display version that did the update |
| ErrorsLast24Hrs | numeric | Total Number of errors encountered in the last 24 hours |
| EsxMachineCount | numeric | Number of Esx machines |
| ID | numeric | Internal ID for the CatalogUpdateLog entity (Primary Key) |
| ImportsLast24Hrs | numeric | Number of imported files in the last 24 hours |
| IncompleteScanFileErrorsLast24Hrs | numeric | Number of incomplete scan file errors in the last 24 hours |
| InstallationGuid | guid | Installation Guid at time of update |
| IosMachines | numeric | Number of IOS machines (iPhones) in the inventory at time of update |
| IpadOsMachines | numeric | Number of IPadOS machines (iPads) in the inventory at time of update |
| JavaInstallations | numeric | Total number of found Java installations |
| JavaPackages | numeric | Number of different Java software packages |
| LastCatalogUpdate | datetime | Date the catalog was last updated |
| LicenseGraceUnits | numeric | Number of license grace units |
| LicenseManagerServerErrorsLast24Hrs | numeric | Number of license manager server errors in the last 24 hours |
| LicenseOptions | string | License Options at time of the update |
| LicenseReadonlyAfter | datetime | License read-only date |
| LicenseServerUnits | numeric | Number of server license units |
| LicenseUnits | numeric | Number of license units at time of update |
| LicenseValidThrough | datetime | License Valid Through Date |
| LicensingRelevantJavaInstallations | numeric | Number of found Java installations that require an Oracle license (based on version) |
| LinuxMachineCount | numeric | Number of Linux machines |
| Machine | string | Name of machine where the update was executed. Usually the OctoSAM Server machine name. |
| MachineCount | numeric | Number of machines in the inventory at time of update |
| MachinesDeletedInDirectory | numeric | Number of machines that are are found as deleted in active directory |
| MacMachineCount | numeric | Number of Macs |
| OracleJavaMsiInstallations | numeric | Number of found Oracle Java installations that seem to have used a commercial .MSI installation that requires an Oracle license. |
| ScannerErrorsLast24Hrs | numeric | Number of scanner errors encountered in the last 24 hrs |
| ScannerWarningsLast24Hrs | numeric | Number of scanner warnings encountered in the last 24 hrs |
| ServerCount | numeric | Number of machines with a server operating system |
| ServersDeletedInDirectory | numeric | Number of machines with a server operating system that are found as deleted in active directory |
| UserCount | numeric | Number of users in the inventory at time of update |
| WarningsLast24Hrs | numeric | Number of warnings encountered in the last 24 hours |
| WindowsServerCount | numeric | Number of Windows servers |
| WindowsServersNotScannedFromActiveDirectory | numeric | |
| WindowsWorkstationCount | numeric | Number of Windows workstations |
| WindowsWorkstationsNotScannedFromActiveDirectory | numeric |