Computer Table (Required)
- Name
- Serial number
- Computer model (lookup to Computer Model table)
- Manufacturer
- OS version (lookup to OS Version table)
- BIOS version
- Free disk space
- Disk size
- Last sync date
- Primary user (lookup to User table)
- Location
- Department
- Status (lifecycle status)
- Source ID (from source system)
- Version ID
User Table (Required)
- Name
- First name
- Last name
- Display name
- Email/Mail
- UPN (User Principal Name)
- Employee ID
- Manager (lookup to User table)
- Department
- Location/Office location
- City
- Business phone
- Enabled status
- Password last set date
- Preferred name
Computer Model Table (Lookup List)
- Name
- Manufacturer
- Model number
- Type (desktop, laptop, etc.)
OS Version Table (Lookup List)
- Name (marketing name like "22H2")
- Version number
- Release date
Migration History/Completed Refresh Table
- Old device (lookup to Computer table)
- New device (lookup to Computer table)
- User (lookup to User table)
- Completion date
- Status
- Migration type
Application Table
- Name
- Publisher (lookup to Publisher list)
- Version
- Installation date
- Computers (multi-select lookup to Computer table)
ITSM Ticket Table
- Name
- Description
- Status
- Priority
- Assigned to (lookup to User table)
- Created date
- Resolution date
- Related assets (lookup to other asset tables)