Workstations.mdb: Difference between revisions
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
| (3 intermediate revisions by 2 users not shown) | |||
| Line 4: | Line 4: | ||
It has two tables of interest: | It has two tables of interest: | ||
* table ''purchaseds'' is manually maintained and contains information on when a laptop was bought, when it warranty ends, where it is | * table ''purchaseds'' is manually maintained and contains information on when a laptop was bought, when it warranty ends, where it is | ||
* table ''workstations'' automatically extracts the computer | *also contains who has extended desktop and works from home and what equipment in addition to laptop at home. | ||
* table ''workstations'' automatically extracts the [[computer name]]s ([[host name]]s) from the A_Info tables of all the backup data files. | |||
Ask | Ask the [[Database Manager]] or [[p:Tina Tenbergen | Tina]] for more details. | ||
== Adding / removing [[Laptop identifier]]s == | == Adding / removing [[Laptop identifier]]s == | ||
| Line 14: | Line 15: | ||
for structure or programming, not each data update | for structure or programming, not each data update | ||
* 2021-07-05 | |||
** update to reflect new [[Computer_name#naming_convention]] (added query to change link from 7 to 6 digits) | |||
* 2020-02-24 | * 2020-02-24 | ||
** removed OAK_MICU ''Laptop location'' entry from all_computer_names | ** removed OAK_MICU ''Laptop location'' entry from all_computer_names | ||