Hardware/software Request System / inventory mgmt/ usage & historical report tracking
$100-200 USD
Teslim sırasında ödenir
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
## Deliverables
Table and data that could come in handy
Employee
Name
Phone
Title
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
Password
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 ? ? ?
server_component_id
softwareinstalled
status ? ? ? active ??"
?
server_components??" need to be able to add to server
vendor_nameqlogic
product_type??" fiber channel card
product_model??" qle2462
?
?
vendors ??"a vendor could offer multiple products
name ??"qlogic
product ??"fiber channel hba
product_category??" hardware
?
?
vendor_contacts??" each company could have multiple products or multiple contacts
company_name
product ??"
contact_name
phone
notes
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
?
?
Geography ??"
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.
?
Software
? ? ? ? ? ? ? ? ? ? ? Operatingsystem
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? linux,solaris sparc, solaris x86,windows
?
storage
?
xtras
? ? ? ? ? ? ? ? ? ? ? oracle
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ilm,dm
?
?
Database
Oracle, mssql,db2,mysql
Versions
?
?
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
Proje NO: #3552246