MDB:Development/Devices

From WolfTech
Jump to navigation Jump to search

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
  • system_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.
  • user_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_processor

http://msdn.microsoft.com/en-us/library/aa394373(v=vs.85).aspx


device_cdrom

  • id
  • device_id
  • name
  • media_type
  • drive
  • manufacturer
  • serial_number
  • error_code
  • record_update_date


http://msdn.microsoft.com/en-us/library/aa394081(v=vs.85).aspx

device_sound

  • id
  • device_id
  • name
  • manufacturer
  • error_code
  • record_update_date

http://msdn.microsoft.com/en-us/library/aa394463(v=vs.85).aspx

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