Setting Up Asset/Data Tables

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)