Difference between revisions of "MDB:Development/Devices"
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...) |
m (→devices) |
||
| Line 19: | Line 19: | ||
*service_pack_minor | *service_pack_minor | ||
*kernel | *kernel | ||
| − | |||
*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_building |
| + | *location_room | ||
*asset_tag | *asset_tag | ||
*cams_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_create_date | ||
*record_update_date | *record_update_date | ||
| + | *record_remove_date | ||
Revision as of 20:07, 3 January 2011
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 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