Review of Related Literature of Inventory System

Only available on StudyMode
  • Topic: Number, Serial number, IP address
  • Pages : 10 (791 words )
  • Download(s) : 3783
  • Published : October 26, 2011
Open Document
Text Preview
School of Informatics University of Edinburgh

Inventory System
Rollout
Ken Dawson



The importance of the inventory Typical l‘ ife cycle’ of inventory records LCFG sysinfo data Invtools Invquery Invedit Documentation













Nov 2008

Inventory System: Rollout

2

The Importance of the Inventory


Purchase details: when, cost, description, who paid, supplier Detailed record of equipment owned including changeable elements such as current location Disposal details: when, how, residual value Basis for insurance record Planning (e.g. for replacing old equipment) Legal requirements Inventory System: Rollout 3











Nov 2008

‘ Life Cycle’ of Inventory Records – DICE 1


Order placed


details of order and items ordered entered using standard form details automatically transferred to database record arrival date and serial numbers of equipment on standard order form existing item records automatically updated




Order arrives




example order: http://ordershost.inf.ed.ac.uk/xml/ikb0153.xml Nov 2008 Inventory System: Rollout 4

‘ Life Cycle’ of Inventory Records – DICE 2


Desktop installation


profile created (hostname and MAC address specified) details of hostname, serial number and MAC address (plus make and model) reported centrally to ordershost Hostname and MAC address added for system with matching serial number MAC/switch-port/location data from switches used to automatically maintain location of networked computers Inventory System: Rollout 5



twice daily client-report runs on each host




twice daily clientreporttoinfdb runs on infdb




twice daily switchtoinfdb runs on infdb


Nov 2008



Order placed


‘ Life Cycle’ of Inventory Records Networked 1

details of order and items ordered entered using standard form details automatically transferred to database record arrival date and serial numbers of equipment on standard order form existing item records automatically updated




Order arrives





example order: http://ordershost.inf.ed.ac.uk/xml/ikb0413.xml Inventory System: Rollout 6

Nov 2008

‘ Life Cycle’ of Inventory Records Networked 2


Manual update


hostname and MAC address specified via command line tool (invedit) MAC/switch-port/location data from switches used to automatically maintain location of networked computers



twice daily switchtoinfdb runs on infdb


Nov 2008

Inventory System: Rollout

7

‘ Life Cycle’ of Inventory Records Non-networked 1


Order placed


details of order and items ordered entered using standard form details automatically transferred to database record arrival date and serial numbers of equipment on standard order form existing item records automatically updated Inventory System: Rollout 8




Order arrives




Nov 2008

‘ Life Cycle’ of Inventory Records Non-networked 2


Manual update


location specified via invedit command

Note that at present this also applies to switches and servers in the server rooms because of the way switch ports are tagged

Nov 2008

Inventory System: Rollout

9

LCFG Sysinfo Data
Inventory data is now held in the LCFG profiles via sysinfo resources (e.g. sysinfo.model, sysinfo.sno, sysinfo.location, sysinfo.owner, sysinfo.allocated) Much of this is mastered in the School database and exported in per-machine header files. In the transitionary phase that we are still in this is still being overrided in the profile but this will soon be stopped. Nov 2008 Inventory System: Rollout 10

Invtools


dice-invtools rpm contains the invquery and invedit commands Available via the infdb-client.h header Similar setup as for any client machine of the School Informatics database – needs entry in live/infdb-dbiproxy.h header DBIPROXY_ADD(, INVQUERY ) Need encryption key in .../DICE/AccountManager/Infdb/Key.pm...
tracking img