MDB:Development/Devices
Jump to navigation
Jump to search
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
- 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