MDB:Development/Devices

device

• id -- auto_inc, primary key
• unit -- basic unit information (ECE, CNR, etc); used to determine which devices each unit can see.
• name -- name of the computer, can remain null for non-IT
• dnsdomain -- dns domain for the device (ece.ncsu.edu, cnr.ncsu.edu)
• type -- basic type grouping (workstation, laptop, printer, nonNCSU, Instrument, Other, etc)
• uuid -- Universally Unique Identifier, if can be pulled. One of a few fields that can confirm a new report is a current machine.
• oid
• make
• model
• serialnumber
• bios
• bios_date
• ip_address
• mac_address
• os
• os_version
• service_pack_major
• service_pack_minor
• kernel
• installation_date
• last_boot_date
• memory -- should be generated from total/1GB in device_memory sub table.
• processor_count
• processor_type
• processor_speed
• vpro
• location_building
• location_room
• asset_tag
• cams_tag
• purchase_date
• purchase_price
• purchase_account
• flag_count_warning
• flag_count_error
• tags -- string of all tags associated with the device; define a character to separate them -- each tag must have this character on each side of it to allow easy search.
• record_create_date
• record_update_date
• record_remove_date

device_comments

• id - auto_incr
• userid - userid of commenter
• device_id - id of device
• comment
• create_date