MDB:Development/Devices

devices

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
purchase_date
installation_date
last_boot_date
memory -- should be generated from total/1GB in device_memory sub table.
processor_count
processor_type
vpro