[u-u] Asset tracking...

[William Park]

Since it's key-value structure, from top of my head,

    1. spreadsheet -- simplest, but you can't do any complicated query.

    2. SQL -- probably single table would suffice.  Query is obvious.
    But, data entry can be tedious.

    3. textfile -- each line contains key/value.  Will require scripting
    skills.  Data entry is simple but tedious, because you have to make
    sure the same key is used in all files.

    4. filesystem -- filename is the key, and its content is value.
    Even simpler then textfile, but same problem with data entry.
-- 
William

On Tue, Jan 13, 2015 at 02:29:56PM -0500, Colin McGregor wrote:
> At an office staff meeting today the question of how to track servers
> came up. There are people who would like to be able to tell in seconds
> that say :
> 
> Server Fred:
> - is an HP model 1234 with 256 GB RAM, and a 5 TB RAID
> - is in data centre "Smith" cage #4 rack #102 shelf #17.
> - has two power supplies, gets its' power from PDUs 4-2-1 & 4-2-2
> - has lights out management connected to 3com switch 6 port 27
> - lights out management port has IP 10.0.0.4
> - main IP is 10.1.0.7
> - is running OS Debian 7.0 ("Wheezy") GNU/Linux
> - is a game server running "Quake" and "Quake II"
> - etc...
> 
> In summary track everything of ANY consequence about every server.
> Further be able query by all data fields, (ie: list all servers
> running "Quake II" or in cage #4, rack #102, etc).
> 
> Anyone have any suggestions as to what could handle the above
> painlessly? I have run across references to a program called "Collins"
> (https://tumblr.github.io/collins/), anyone know how well it would
> handle the above?
> 
> Thanks.
> 
> 
> Colin.
> _______________________________________________
> u-u mailing list
> u-u at unixunanimous.org
> https://unixunanimous.org/mailman/listinfo/u-u