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
• 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_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_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