IT Inventory Database

CLOSED
Bids
22
Avg Bid (USD)
$174
Project Budget (USD)
$10 - $100

Project Description:
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
Update:
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.

Skills required:
ASP, HTML, IIS, SQL
Hire desosav360
Project posted by:
desosav360 United Kingdom
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 412
in 20 days
$ 500
in 9 days
$ 210
in 10 days
$ 159
in 10 days
$ 100
in 8 days
$ 210
in 5 days
Hire mituld
$ 93
in 4 days
$ 90
in 3 days
Hire jawadaman
$ 111
in 1 days
$ 80
in 10 days