Workstations.mdb: Difference between revisions
Ttenbergen (talk | contribs) m m |
Ttenbergen (talk | contribs) mNo edit summary |
||
| (14 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 == | |||
When any get added, the query ''all_computer_names'' needs to be updated accordingly. | |||
== change log == | == change log == | ||
for structure or programming, not each data update | |||
* confirmed that import script checks ''all directories in data directory'' except master and test_*, instead of explicit list Ttenbergen 09:56, 2015 April 30 (CDT) | |||
* 2021-07-05 | |||
** update to reflect new [[Computer_name#naming_convention]] (added query to change link from 7 to 6 digits) | |||
* 2020-02-24 | |||
** removed OAK_MICU ''Laptop location'' entry from all_computer_names | |||
** cleaned up old connected tables that we no longer use | |||
* 2018-11-06 | |||
** updated query all_computer_names to omit VIC and add [[STB_IMCU]] | |||
* 2015-04-30 | |||
** confirmed that import script checks ''all directories in data directory'' except master and test_*, instead of explicit list Ttenbergen 09:56, 2015 April 30 (CDT) | |||
== Related articles == | |||
{{Related Articles}} | |||
[[Category:Laptop]] | [[Category:Laptop]] | ||
[[Category:IT Instructions]] | [[Category:IT Instructions]] | ||
[[Category:Data Backup Dependencies]] | [[Category:Data Backup Dependencies]] | ||