Workstations.mdb: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 6: | Line 6: | ||
Ask Trish or Tina for more details. | Ask Trish or 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 == | ||
Revision as of 16:36, 24 February 2020
Workstations.mdb is where we keep track of the PCs and laptops used by the Critical Care and Medicine Database. It is located in Regional Server\Maintenance\workstations.mdb
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 workstations automatically extracts the computer names (workstation names) from the A_Info tables of all the backup data files.
Ask Trish 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
- 2020-02-24
- removed Laptop location entry for
- 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)