Difference between revisions of "MDB:Development/Devices"
Jump to navigation
Jump to search
m (→devices) |
m |
||
| 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 44: | Line 44: | ||
*record_update_date | *record_update_date | ||
*record_remove_date | *record_remove_date | ||
| + | |||
| + | ==device_drive== | ||
| + | ==device_drive_history== | ||
| + | ==device_videocards== | ||
| + | ==device_monitors== | ||
| + | ==device_network== | ||
| + | ==device_memory== | ||
| + | ==device_comments== | ||
| + | *id - auto_incr | ||
| + | *userid - userid of commenter | ||
| + | *device_id - id of device | ||
| + | *comment | ||
| + | *create_date | ||
Revision as of 20:20, 3 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
- 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
device_monitors
device_network
device_memory
device_comments
- id - auto_incr
- userid - userid of commenter
- device_id - id of device
- comment
- create_date