Access Database Design

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Newbie here....I have a task assigned to me to track the equipment associated
with digital imaging here at my hospital. At the PC level I need to track
down to hardware/OS/software configuration as well as it's assigned location,
IP, switch, etc. I envision a database that allows me to track service
activity on these systems and be able to supply a report to my supervisor.
I've looked at the templates available on-line and while close, not close
enough. I don't need to track hours and costs, just activity and
configuration. Any thoughts where to start? Thanks!
 
I find this to be a highly worth while project.

Do you want the database to activly search the network and return data to
you or do you just want a way to manually enter data and relate all the
info.

example. Are you looking for a way to ping a whole subnet and return the IP
and mac address and return those values into a database? I can probably help
with that much but you may want to actually query into a DNS Database to
return more information on this.

Are you a systems Admin where you work that has access to these features?

retrieve network interface
http://www.vbip.com/iphelper/default.asp

http://www.windowsitpro.com/Windows/Articles/ArticleID/562/pg/2/2.html

http://www.tek-tips.com/viewthread.cfm?qid=886788



These might be some starter resources for you regarding ip's , Pinging and
what you can actually return with what given protocol
 
Back
Top