Difference between revisions of "MDB:Development/Devices"

From WolfTech
Jump to navigation Jump to search
 
(7 intermediate revisions by the same user not shown)
Line 39: Line 39:
 
*flag_count_warning
 
*flag_count_warning
 
*flag_count_error
 
*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.  
+
*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_create_date
Line 61: Line 62:
 
*driver_version
 
*driver_version
 
*driver_date
 
*driver_date
−
*record_create_date
 
 
*record_update_date
 
*record_update_date
  
Line 68: Line 68:
  
 
==device_monitors==
 
==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_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==
 
==device_memory==
 
*id
 
*id
 
*device_id
 
*device_id
−
*slot -- reported name/slot
+
*slot -- "BankLabel"
−
*type -- DDR, SDRAM, DDR2, etc
+
*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
 
*speed -- in Mhz
 +
*status
 
*current_size -- (/1GB)
 
*current_size -- (/1GB)
 
*max_size -- (/1GB)
 
*max_size -- (/1GB)
 +
*record_update_date
 +
 +
 +
 +
http://msdn.microsoft.com/en-us/library/aa394347(v=vs.85).aspx
  
 
==device_comments==
 
==device_comments==

Latest revision as of 12:57, 4 January 2011

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
Retrieved from "https://tools.wolftech.ncsu.edu/support/index.php?title=MDB:Development/Devices&oldid=10128"