Groups | Blog | Home
all groups > sql server new users > june 2007 >

sql server new users : Help with database design.


rhaazy
6/15/2007 6:50:23 PM
I am working on a server/client application where the client scans a
computer for all available mac addresses and stores the information
in
a database, associating mac addresses to assets. I see problems
occuring in terms of NICs being removed, changes to different
machines
on the network, new NICs being added, etc, etc. I am trying to
figure
out what tables, methods, etc I could use to avoid any possible
situations that could arise as I'm trying to store this information.
Any suggestions would be wonderful.
Mac
6/15/2007 8:45:06 PM
I suppose the minimum you will need to do is ensure you record to-from dates

[quoted text, click to view]
Mac
6/15/2007 11:09:45 PM
As in to-from asset, used, to-from mac

[quoted text, click to view]
AddThis Social Bookmark Button