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.
`EbsServicesDate`	Type: datetime. Nullable The time Oracle EBS 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.