Workstations.mdb: Difference between revisions
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
| (5 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
Workstations.mdb is where we keep track of the PCs | Workstations.mdb is where we keep track of the PCs, laptops, monitors, mice, chairs, desktop risers, footstool, used by the Critical Care and Medicine Database. It is located in '''[[Regional Server]]\Maintenance\workstations.mdb''' | ||
*also includes list of staff with permissions to [[Working from home|work from Home]]. | |||
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 13: | 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 | ||