InventoryReport Table

The InventoryReport table contains a record of every user and computer that has reported hardware or software inventory. It details the date and time when the hardware or software tracking was performed.

Note: To cater for multi-tenant mode, this table may contain data for multiple tenants. Access requires that the database TenantID has been set in the SQL Server connection context information. That setting filters an underlying table to produce this view of data for the single, selected tenant.
Table 1. Database columns for InventoryReport table

Database Column

Details

ComputerID

Type: integer. Key

The computer that the inventory was tracked on. This is a foreign key into the Computer table.

UserID

Type: integer. Key

The user for whom inventory was tracked. For computer inventory, the UserID is 1 (system user). This is a foreign key into the User table.

SWDate

Type: datetime. Nullable

The time software was tracked, or is NULL if no tracking is recorded.

HWDate

Type: datetime. Nullable

The time hardware was tracked, or is NULL if no tracking is recorded.

FilesDate

Type: datetime. Nullable

The time files were tracked, or is NULL if no tracking is recorded.

ServicesDate

Type: datetime. Nullable

The time Oracle services were tracked, or is NULL if no tracking is recorded.

VMwareServicesDate

Type: datetime. Nullable

The time VMware services were tracked, or is NULL if no tracking is recorded.

SequenceNumber

Type: integer. Nullable

Used when generating a differential inventory.

OVMMDate

Type: datetime. Nullable

The time Oracle VM manager was interrogated, or is NULL if no interrogation is recorded.

AccessDate

Type: datetime. Nullable

Access time information was tracked, or is NULL if no tracking is recorded.

AgentVersion

Type: text (max 32 characters). Nullable

The version of the agent which generated the inventory package.