---
title: Device app inventory: MI_DEVICE_APP_INVENTORY
slug: rdb/essentials-guide/device-app-inventory-mideviceappinventory
createdAt: 2026-11-05T09:24:41.844Z
---

The MI\_DEVICE\_APP\_INVENTORY table contains a record for each app/device association, based on the app inventory detected on registered devices.

| Name          | Data type   | Not Null? | Primary key? | Description                                                   |
| ------------- | ----------- | --------- | ------------ | ------------------------------------------------------------- |
| etl\_run\_ts  | timestamp   | Yes       | No           | Timestamp at which the ETL process has run                    |
| vsp\_id       | integer     | No        | No           | The identifier of VSP from which this policy got exported     |
| id            | integer     | No        | No           | Identifier of this row                                        |
| client\_id    | bigint      | No        | No           | Maps to mi\_device.client\_id                                 |
| inventory\_id | bigint      | No        | No           | Maps to mi\_app\_inventory.app\_id                            |
| created\_at   | timestamp   | No        | No           | the association created for the first time on the Ivanti EPMM |
| modified\_at  | timestamp   | No        | No           | Last change timestamp                                         |
| status        | varchar(64) | No        | No           | Managed app status                                            |

