You have chosen to sponsor your bid up to a maximum amount of .
IT inventory database build on sql and asp. A database is needed for keeping records of computers monitors and software purchased and the users that use them.
We should be able to add:
-user information (Name, Username, Cost Center, Department, Building, phone number, comments)
-Computer information (Brand-model, serial number, purchase date, warranty expiration date)
-Docking Station information (model, serial number)
-Monitor Information (Brand-model, serial number, dimension)
-Mobile device information (phone number, date of renewal 1, date of renewal 2, device model, imei, pin1,pin2,puk1,puk2)
-Software information (we should be able to add software purchased like MS windows, ms office, adobe photoshop etc etc)
-Attach files to users (pdf,images)
After updating all entries mentioned above with real data I should be able to link users with the computer-monitor-software-docking station they use.
Some users might have more that one computers or monitors and some hardware might not be used by a user.
Additionally reports should be generated regarding:
-what hardware (computers/monitors) each department has (filtered by user department of user cost center)
-which hardware will be out of warranty on a date that i will choose.
-which users have a certain software (eg: list of all windows 7 users)
If it is possible to import all user data from active directory would be great. The webpage should be password protected. Only certain users will have access.
Additional Project Description:
02/18/2014 at 20:45 JST
computer information should include "Computer name" field.
Additionally a search field should be included, which will search computer names, users, usernames and user phone numbers.