Please use layout from [url removed, login to view]
Need a online server request system that displays? availability? via calendar. ? A user will select server type and what software is needed a start date and finish date. ? a confirmation email needs to be sent. ? in admin section I will add the components and confirm. ? once confirmed available inventory needs to reflect change via calendar and relevant information needs to be sent to? requester.
there needs to be differnt requests, servers that are already built. ? they can view whats already in built queue, or request for a fresh build
This will be phase 1
phase 2 and onward will be enhancements and more functionality
Need coder to build database tables and relationships, will include table examples and data
Table and data that could come in handy
Geo ??" drop down choices
Area ??" drop down, only selected areas displayed pending whatgeo was selected
Region ??" drop down, only selected regions displayed pendingwhat area was selected
Access ??" access to administration type pages
**Server_info ??" When auser is requesting a server they should be able to see availability by protocol(FC,NFS,ISCSI) ??" This should be viewed when user clicks on calendar that hasavailable servers.? They should seemore info that shows server_type and what protocols those free server haveavailable**
server_name? ? ? sunshine ??" will always be assigned to same physical server
server_vendor ? ? ? Sun
server_model ? ? ? Sun Fire X4600 M2
server_type ? ? ? x86_64
server_ram ? ? ? 16 -
cpu_qty ? ? ? 4
proc_type ? ? ? AMD Opteron dual core
nfs ? ? ? yes ??" need to use as lookup
fc ? ? ? yes ??" need to use as lookup
iscsi no??" need to use as lookup
10ge ? ? ? no ??" need to use as lookup
os ? ? ? Enterprise Linux AS release 4 (October Update 6) ??" willchange pending what os is requested
public_ip ? ? ? [url removed, login to view]
dnfs1 ? ? ? [url removed, login to view]
dnfs2 ? ? ? [url removed, login to view]
priv ? ? ? [url removed, login to view]
vip ? ? ? [url removed, login to view]
wwpn1 ? ? ? 2100001b420eb520 ??" just like ip once assigned it willalways stay the same by server name
wwpn2 ? ? ? 2001001b242eb520
wwpn3 ? ? ?
wwpn4 ? ? ?
10ge1 ? ? ?
10ge2 ? ? ?
status ? ? ? active ??"
server_components??" need to be able to add to server
product_type??" fiber channel card
vendors ??"a vendor could offer multiple products
product ??"fiber channel hba
vendor_contacts??" each company could have multiple products or multiple contacts
Ip_info ??" Need to assign ip from group to a server, can bemore than 1.? Need to track whatips have been used and what server they where assigned. 99% of the time once aip has been assigned it will always be associated to a server by server name (hardcodedDNS)
Public [url removed, login to view] ??" 230
Vip ??" uses public but? ip needs to be assign under vip
Dnfs1 ??" 172.31.40.5 ??" 230
Dnfs2 ??" 172.31.50.5 ??" 230
Priv ??" 172.31.9.5 ??" 230
Ilom ??" can be any of the ips
Geo ??" americas for 1 geo there are many areas
Area ??" east ??" for 1 area there are many regions
Region ??" southeast
Software ??" all software needs to be attached to a serverbuild, I should be able to add as much software as needed.? All information on a server buildrequest needs to be saved in history table for long term reports.
? ? ? ? ? ? ? ? ? ? ? Operatingsystem
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? linux,solaris sparc, solaris x86,windows
? ? ? ? ? ? ? ? ? ? ? oracle
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ilm,dm
There needs to be a compatibility matrix onhardware/software/components.? Example:? I can not choosesolaris sparc OS to run on a x86_64 server. OR I can not run a x86_64 Fiberchannel with linux 4u5 or less