Workstations.mdb: Difference between revisions

TOstryzniuk (talk | contribs)
mNo edit summary
mNo edit summary
 
(2 intermediate revisions by the same user not shown)
Line 5: Line 5:
* 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
*also contains who has extended desktop and works from home and what equipment in addition to laptop at home.
*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 (workstation names) 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 [[p:Trish Ostryzniuk | Manager]] or [[p:Tina Tenbergen | Tina]] for more details.
Ask the [[Database Manager]] or [[p:Tina Tenbergen | Tina]] for more details.


== Adding / removing [[Laptop identifier]]s ==
== Adding / removing [[Laptop identifier]]s ==
Line 15: 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