Difference between revisions of "MDB:Development/Devices"
Jump to navigation
Jump to search
m (→devices) |
m (→device) |
||
| (13 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | == | + | ==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 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 | ||
*record_update_date | *record_update_date | ||
*record_remove_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 | ||
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