Workstations.mdb: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m (→change log) |
Ttenbergen (talk | contribs) mNo edit summary |
||
Line 7: | Line 7: | ||
* table ''workstations'' automatically extracts the [[computer name]]s ([[host name]]s) from the A_Info tables of all the backup data files. | * 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 == |
Latest revision as of 20:30, 2023 April 5
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 work from Home.
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
- 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 names (host names) from the A_Info tables of all the backup data files.
Ask the Database Manager or Tina for more details.
Adding / removing Laptop identifiers
When any get added, the query all_computer_names needs to be updated accordingly.
change log
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
- 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: |
|