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 |
|---|---|---|
| ApprovedJavaInstallations | bigint | Number of approved Java installations that require an Oracle license |
| BuildDate | datetime2 | OctoSAM build date that did the update |
| BuildVersion | nvarchar | OctoSAM build version that did the update |
| CatalogConflicts | bigint | Number of conflicts encountered during catalog update |
| CatalogUpdateFileName | nvarchar | File name of the used catalog update file |
| CatalogUpdateStatus | nvarchar | Status returned by the central update service |
| Created | datetime2 | Date/time this record was created |
| DisplayVersion | nvarchar | OctoSAM display version that did the update |
| ErrorsLast24Hrs | bigint | Total Number of errors encountered in the last 24 hours |
| EsxMachineCount | bigint | Number of Esx machines |
| ID | bigint | Internal ID for the CatalogUpdateLog entity (Primary Key) |
| ImportsLast24Hrs | bigint | Number of imported files in the last 24 hours |
| IncompleteScanFileErrorsLast24Hrs | bigint | Number of incomplete scan file errors in the last 24 hours |
| InstallationGuid | uniqueidentifier | Installation Guid at time of update |
| JavaInstallations | bigint | Total number of found Java installations |
| JavaPackages | bigint | Number of different Java software packages |
| LastCatalogUpdate | datetime2 | Date the catalog was last updated |
| LicenseGraceUnits | bigint | Number of license grace units |
| LicenseManagerServerErrorsLast24Hrs | bigint | Number of license manager server errors in the last 24 hours |
| LicenseOptions | nvarchar | License Options at time of the update |
| LicenseReadonlyAfter | datetime2 | License read-only date |
| LicenseServerUnits | bigint | Number of server license units |
| LicenseUnits | bigint | Number of license units at time of update |
| LicenseValidThrough | datetime2 | License Valid Through Date |
| LicensingRelevantJavaInstallations | bigint | Number of found Java installations that require an Oracle license (based on version) |
| LinuxMachineCount | bigint | Number of Linux machines |
| Machine | nvarchar | Name of machine where the update was executed. Usually the OctoSAM Server machine name. |
| MachineCount | bigint | Number of machines in the inventory at time of update |
| MachinesDeletedInDirectory | bigint | Number of machines that are are found as deleted in active directory |
| MacMachineCount | bigint | Number of Macs |
| OracleJavaMsiInstallations | bigint | Number of found Oracle Java installations that seem to have used a commercial .MSI installation that requires an Oracle license. |
| ScannerErrorsLast24Hrs | bigint | Number of scanner errors encountered in the last 24 hrs |
| ScannerWarningsLast24Hrs | bigint | Number of scanner warnings encountered in the last 24 hrs |
| ServerCount | bigint | Number of machines with a server operating system |
| ServersDeletedInDirectory | bigint | Number of machines with a server operating system that are found as deleted in active directory |
| UserCount | bigint | Number of users in the inventory at time of update |
| WarningsLast24Hrs | bigint | Number of warnings encountered in the last 24 hours |
| WindowsServerCount | bigint | Number of Windows servers |
| WindowsWorkstationCount | bigint | Number of Windows workstations |