Difference between revisions of "MDB:Development/Devices"

From WolfTech
Jump to navigation Jump to search
m (New page: ==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...)
 
 
(14 intermediate revisions by the same user not shown)
Line 1: Line 1:
−
==devices==
+
==device==
 
*id -- auto_inc, primary key
 
*id -- auto_inc, primary key
 
*unit -- basic unit information (ECE, CNR, etc); used to determine which devices each unit can see.  
 
*unit -- basic unit information (ECE, CNR, etc); used to determine which devices each unit can see.  
Line 19: Line 19:
 
*service_pack_minor
 
*service_pack_minor
 
*kernel
 
*kernel
−
*purchase_date
 
 
*installation_date
 
*installation_date
 
*last_boot_date
 
*last_boot_date
Line 25: Line 24:
 
*processor_count
 
*processor_count
 
*processor_type
 
*processor_type
 +
*processor_speed
 +
*
 
*vpro
 
*vpro
−
 
+
*
−
*location
+
*location_building
 +
*location_room
 
*asset_tag
 
*asset_tag
 
*cams_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
  
−
*record_create_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
 
*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

Latest revision as of 13: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"