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_drive
device_drive_history
device_videocards
- id
- device_id
- name
- video_processor
- video_mode
- horiz_resolution
- vert_resolution
- number_colors
- refresh_rate
- video_ram
- driver
- driver_version
- driver_date
- record_update_date
http://msdn.microsoft.com/en-us/library/aa394512(v=vs.85).aspx
device_monitors
- id
- device_id
- name
- monitorID -- "DeviceID" in its WMI
- screen_height
- screen_width
- monitor_manufacturer
- monitor_type
- error_code
- power_mgmt -- "powerManagementCabilities"
- record_update_date
http://msdn.microsoft.com/en-us/library/aa394122(v=vs.85).aspx
device_network
device_sound
- id
- device_id
- name
- manufacturer
- error_code
- record_update_date
device_memory
- id
- device_id
- slot -- "BankLabel"
- location -- "DeviceLocator"
- type -- DDR, SDRAM, DDR2, etc "FormFactor" or "MemoryType"
- interleave_position -- "InterleavePosition" -- may let us determine pairs. Perhaps "PositioninRow"? TypeDetail?
- manufacturer
- model
- part_number
- serial_number
- speed -- in Mhz
- status
- current_size -- (/1GB)
- max_size -- (/1GB)
- record_update_date
http://msdn.microsoft.com/en-us/library/aa394347(v=vs.85).aspx
device_comments
- id - auto_incr
- userid - userid of commenter
- device_id - id of device
- comment
- create_date
device_warranty
- id
- device_id
- desc
- start_date
- end_date
- provider
device_warranty_schedule
- id
- device_id
- last_check_date
- next_check_date
- ship_date