Workstations.mdb: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m (m)
mNo edit summary
Line 2: Line 2:


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 ''purchased'' 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.  
* table ''workstations'' automatically extracts the computer names (workstation names) from the A_Info tables of all the backup data files.  



Revision as of 13:32, 2018 June 15

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 purchased 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.

change log

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)