Data Collection & Reporting
The objective of this project is to have a central repository (site) that will assist in creating decisions to questions resulting from a bigger project. Our aim is to have data entry forms to encourage collaboration and then to have various view pages (reporting) that will display the results. Because there will be library tables for lookups, we will also require “Admin” pages where we can edit the backend values. The site is to be created in VB.Net with SQL 2005 as its backend. AJAX is preferred but not required.
All code and source must be provided and explained for future development.
In Detail, we would like a database that will contain tables housing:
Servers and relevant data about them, including CPU, Disk, and other physical attributes, along with OS and version, its primary IP, if it’s a member of a cluster, application(s) it is hosting, location, vendor, support costs and expiration date.
Applications and their dependencies, version, vendor, number of users, security groups allowed access, servers hosting this application (can be more than 1), licensing and support costs.
Devices (like Cisco Routers, Switches, F5 load balancers, Riverbed appliances, etc), their OS and version, location, support costs and expiration date
We have 4 datacenters that are housing many servers, network appliances, storage devices, and applications. We want to tie everything back to the current datacenter that it resides in, along with selecting a BCP location (disaster recover). Applications will need to be tied to servers. We would also like Application dependencies to be entered at a generic level, such as IIS, Excel, SQL, etc.
Much of the data in the tables will need to be entered on several web forms that we would like created, but some tables will contain relatively constant data, such as application dependencies (IIS, Excel, SQL, Word, etc) or Vendors (Dell, Microsoft, etc). We would like the forms using the data in the application dependencies and vendors libraries presented as a dropdown menu or selection of some sort to make the relation between tables. We want the relations so that running reports will be able to present things such as total support costs for the vendor Dell, or total number of applications having the dependency of IIS, and the like.