IT Asset Management Database – Free Download

Web based PHP and MySQL Asset Management database for fast easy access, updates and CSV generated reports.  The application is designed to manage IT assets from a Desktop Services perspective: computers and associated hardware, printers and software.  I’m offering the software for free here to anyone who has a use for it.

IT Enterprise Asset Management Database
View the demo here
username: eam
password: eam123


Update – Version 3.0 – 04/13/2013

  • PHP 5.3+ support – addresses “Function session_register() is deprecated” error
  • Added – Asset Tag field
  • Added – Purchase Order field
  • Fixed and updated – Search and Search Results pages
  • Fixed – Login and Logout pages
  • Existing install upgrades – download package and follow Upgrade Steps in the Readme.
    Quick and easy: import SQL update, replace 8 files.


  • PHP, MySQL, Apache, MySQL management tool. WAMP on Windows or LAMP on Linux
  • Follow ten step setup – Create a database, use supplied SQL dump file to populate.
  • Dreamweaver – Only needed if you wish to modify the application as it was written.

Download source code and all assets

  • Application files for version 3.0
  • SQL code, logo file and assets in the Assets folder
  • 10 step setup doc in the root of the site  1-README.txt
  • Download password:  assets
This entry was posted in Computer and tagged , , , , , , , , . Bookmark the permalink. Post a comment or leave a trackback: Trackback URL.


  1. Posted 05/16/2012 at 5:02 pm | Permalink

    Hi, I keep getting an error when running this script:

    Notice: A session had already been started – ignoring session_start() in C:\wamp\www\eam\includes\header.php on line 38
    Call Stack
    # Time Memory Function Location
    1 0.0007 362480 {main}( ) ..\Admin.php:0
    2 0.0037 390400 include( ‘C:\wamp\www\eam\includes\header.php’ ) ..\Admin.php:82
    3 0.0039 390440 session_start ( ) ..\header.php:38

    if you can spare time to help I’d be very grateful.



  2. Brijesh Patel
    Posted 08/25/2012 at 2:15 am | Permalink

    I like to use this application but can we implement to Add some unique no to each asset & we can Print Bar coded Asset Label with unique Asset No,content Make,Model,User,Division & Location , this will help to identifiy the asset easily….

  3. gfisk
    Posted 11/04/2012 at 11:11 pm | Permalink

    Hi Brijesh – I’ll work to add ‘Asset Tag’ in the next release.

  4. Brijesh Patel
    Posted 11/04/2012 at 11:38 pm | Permalink

    & also try to release new version with report printing option & instead of csv please try to fetch report in PDF…

  5. Posted 01/23/2013 at 6:07 pm | Permalink

    I really like what you have done here. Nice simple interface and out of the box usability. Like some of the other before me have mentioned so updated features would be really nice to see implemented as well.

    The HTML reports would be a big one, and the ability to create and generate reports dynamically would be great. I have done this kind of thing more times than I want to count in MS Access, but everybody want their databases web accessible now a days so you are doing well.

  6. Another IT Guy
    Posted 02/18/2013 at 5:17 am | Permalink

    Id like to download this program file using ssh, where do I find the link?

  7. alexa
    Posted 02/24/2013 at 12:05 pm | Permalink

    Hi, i use xampp for the webserver and I don’t why i still got an error in the beginning: Fatal error: Call to undefined function session_is_registered() in C:\xampp\htdocs\eam\includes\header.php on line 39

    would you please help me? Thank’s

  8. Posted 03/22/2013 at 11:21 am | Permalink

    Hi gfisk,

    Can you look at following error and how to overcome it, please reply its is very great project for me, you great support and effort appreciated.

    ! ) Deprecated: Function session_is_registered() is deprecated in C:\wamp\www\eam\includes\header.php on line 39
    Call Stack
    # Time Memory Function Location
    1 0.0008 417224 {main}( ) ..\index.php:0
    2 0.0034 450384 include( ‘C:\wamp\www\eam\includes\header.php’ ) ..\index.php:98

  9. gfisk
    Posted 04/13/2013 at 1:12 pm | Permalink

    Updated to version 3.0 – bug fixes, PHP 5.3 support, added Asset Tag and Purchase Order fields. Simple upgrade for existing installs.

  10. Brijesh
    Posted 04/15/2013 at 12:26 am | Permalink

    It would be great if someone can Generate Report’s in PDF Format instead of csv.

  11. gfisk
    Posted 04/15/2013 at 10:06 pm | Permalink

    Hi Brijesh – If there’s a compelling reason to create PDFs I can look into it. Exporting to PDF requires additional components such as TCPDF or FPDF and configuration. CSV can be opened by any application, works with Google Docs, MS Excel, Open Office Calc and can be converted to PDF using those apps or free PDF print software such as PDFCreator, BullZip, PDF995 or CutePDF.

  12. Posted 05/14/2013 at 10:30 pm | Permalink

    I don’t see the 10 step setup document. Where is that to download?

  13. gfisk
    Posted 05/14/2013 at 10:42 pm | Permalink

    Hi Draco, 1-README.txt in the root of the site. Thanks for highlighting that, I’ve added the information to this page.

  14. Pemin
    Posted 05/31/2013 at 2:18 am | Permalink

    My CSV-reports showing htmal tags. please help

  15. anwar
    Posted 07/12/2013 at 4:58 am | Permalink

    how to upload csv data

  16. Another IT Guy 2
    Posted 07/16/2013 at 9:26 am | Permalink

    Hi gfisk,

    found your script a few days ago.
    Looks very good so far.

    A few suggestions:

    – Search for Status (Inventory/Deployed/Retired)
    – Possibility to add License Keys
    – Edit/Add Licensce Type
    – Delete Multiple entries
    – Sort Lists
    – Create a Userlist
    – Assign User to Hardware via dropdown menu
    – Import User/Hardware


  17. Aidan
    Posted 07/20/2013 at 5:28 am | Permalink

    I’m not sure if I am doing something wrong.

    I got my installation running, however there are a heap of tables missing from the database.

    Mainly the software tables.

    if you could help, that would be fantastic

    the project looks great though, good job :)



  18. gfisk
    Posted 07/20/2013 at 8:14 am | Permalink

    Hi Aidan, if you haven’t added any data I would suggested “dropping” all the tables in the database and importing “/Assets/eam.sql” again. If it’s a fresh install make sure you’re not importing the database update file “DatabaseUpdate2-3.sql”

  19. gfisk
    Posted 07/20/2013 at 8:17 am | Permalink

    Thanks for the feedback IT Guy, all good stuff that time allowing I will look to add in the future.

  20. gfisk
    Posted 07/20/2013 at 8:24 am | Permalink

    HI Anwar, at this time the only way to import would be via phpMyAdmin or similar database tool. If you’re comfortable with that you can create a CSV file that matches the database tables, populate the file with data and use the import function. You can find many good articles such as this:

  21. gfisk
    Posted 07/20/2013 at 8:26 am | Permalink

    Hi Pemin, not sure what would cause that to happen. Review step 6 in the setup instructions and perhaps try a different browser.

  22. Rajdip
    Posted 08/08/2013 at 2:26 am | Permalink

    Hello Dear,

    I think your tutorial save lots my time and it’s easy to understand. Please keep it alwys up . great work done by you. :) :)



  23. Leo
    Posted 08/24/2013 at 12:58 pm | Permalink


    Would be really great to have a way to modify the Php fields inside of the web front end.

    I want to change Serial number to something else…

    Any tips would highly appreciated.



  24. Leo Rudolph
    Posted 09/14/2013 at 3:12 am | Permalink

    Hi, Please ignore my last comment. Figured out how to do most of it now.

    The only problem I could not sort yet is:

    HardwareList.php Works the way it was designed. List my 399 devices in few pages.
    50 item on each page.

    javascipt:getsupport(‘Desktop’) This does not work properly

    Records 1 to 50 of 117

    But I can see only the first page = 50 itens

    Page two shows Records 51 to 100 of 117 but no items are displayed.
    Page Three shows Records 101 to 117 of 117 but no items are displayed.

    Would appreciate any pointers.



  25. Chris
    Posted 10/31/2013 at 3:22 pm | Permalink

    is there an updated version of this? it seems like there are some broken links/missing pages?

    any way to sort the data on the hardware and software lists.. only showing 50 at a time on those lists, i’d like to sort the individual columns if possible.

  26. gfisk
    Posted 11/02/2013 at 8:15 am | Permalink

    Hi Chris – Thanks for the feedback, if you can add any detail per missing links and pages I can check it out! I’ll look to add column sort capability in any future update. For now you can use the search views to filter by type or export your data and sort in Excel.

  27. gfisk
    Posted 11/02/2013 at 8:25 am | Permalink

    @Leo – thank you for the feedback and apologies to all as the Search results page pagination is indeed broken. Sorry I missed that, I’ll work to get an update.

  28. Jack
    Posted 11/03/2013 at 7:53 am | Permalink

    Hi your database would really work for me but infortunatley I am not in It but electronic, mechanical and marine equipment. Would it be possible to change the entering and search fields for our use. I like it because its simple and easy to use for my operators. If possible please contact me urgently. Thank you

  29. Jack
    Posted 11/03/2013 at 7:55 am | Permalink

    Hi does it come in a different version for not being an it business. I really like this database but I am into electronics, mechanical and marine equipment.

  30. Santhosh
    Posted 12/03/2013 at 3:39 am | Permalink

    When I run , login.php , I get this error “No database Selected”

  31. Posted 01/23/2014 at 11:57 am | Permalink

    it would have been lovely if you can add an image field or space for each asset submited

  32. Brijesh Patel
    Posted 04/30/2014 at 11:36 pm | Permalink


    One more suggestion that can we add asset assign and unassigned functionality and also should generate track record of all asset until it disposed in this application than it would be great because normally Laptop’s, Desktop and printers will assign so some of the user’s and now a day’s it’s necessary to know which asset is assigned to whom as a IT Responsible.

  33. Posted 05/15/2014 at 7:40 pm | Permalink

    Hi Mr. Fisk

    I have been playing with your code to see if it would be adaptable for my needs. So far it looks pretty good except for the searchResults.php page. I was running into a problem with the pagination that I just couldn’t figure out. I then set up a new subdomain and database and then installed the source again fresh. Rather than change the page row limits, I left everything alone and added more laptop records to bring it over 50. The pagination doesn’t work there but it is perfect in the HardwareList.php. Is there an updated version of searchResults.php?

  34. Posted 05/15/2014 at 7:42 pm | Permalink

    PS thanks for the awesome product and your time!!

  35. Dave Reid
    Posted 06/09/2014 at 11:01 am | Permalink

    Does the downloadable version work with XAMPP?

  36. gfisk
    Posted 06/11/2014 at 8:58 pm | Permalink

    The app works with PHP and MySQL

  37. James
    Posted 06/30/2014 at 3:47 pm | Permalink

    Is there a way to have a data field archived like under computers, (assigned to) so when I have change that data another table has the history so I know who has had it in the past?

  38. James
    Posted 07/01/2014 at 1:09 pm | Permalink

    Can the report export be changed to a different format?

  39. New User
    Posted 10/08/2014 at 4:15 pm | Permalink

    Will this work on SQL Server Express or Just MYSQL

  40. Jason
    Posted 10/17/2014 at 3:38 pm | Permalink

    Looks great! How can we add a “computer name” to an asset? Also, can we assign a user to a computer? What about assigning software to a computer? Its good to know I have 5 seats, but where are they installed?

  41. AJ
    Posted 10/23/2014 at 5:08 pm | Permalink


    Thanks for taking the time and making such a useful tool with a very simple interface.

    Question I have is that, can we import an existing inventory sheets made in excel into the database and have them show up on the interface.

    It’s very tedious to have to manually enter 100+ items one-by-one.

    I can tweak the excel sheet to match the fields available but how do I import it?


  42. Jarrod
    Posted 11/10/2014 at 6:33 pm | Permalink

    Hi gfisk,
    Thanks for making a fantastic and useful application. Great work.

    I have one quick question if you get a minute. When I export to CSV file, the files are blank when I open them. No information in them at all even though I have lots of records. Not getting any errors, so I’m not sure where to start.


  43. Will
    Posted 11/25/2014 at 1:20 pm | Permalink

    I would love to give this a spin but there is no download link.

  44. gfisk
    Posted 11/25/2014 at 3:06 pm | Permalink

    Thanks Will, a recent update to the file manager broke downloads. Should be good now.

  45. Ziko
    Posted 12/21/2014 at 5:00 am | Permalink

    Hi gfisk,

    It’s good work. I use the 1-README.txt for configuration but when I start it gives below error.

    Thanks in advance.

    ( ! ) Deprecated: mysql_pconnect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in C:\wamp\www\eam\Connections\eam.php on line 10
    Call Stack
    # Time Memory Function Location
    1 0.0025 274936 {main}( ) ..\index.php:0
    2 0.0029 277776 require_once( ‘C:\wamp\www\eam\Connections\eam.php’ ) ..\index.php:1
    3 0.0030 278528 mysql_pconnect ( ) ..\eam.php:10
    No database selected

  46. gfisk
    Posted 12/22/2014 at 8:01 pm | Permalink

    @Ziko, it looks like the mysql_pconnect(): extension isn’t fully compatible with MySQL 5.5.0 and higher.

    I have a quick fix which disables PHP Error Reporting on screen, meanwhile I’ll work for a fix and post an update when I have it.

    Quick fix – add this code to line #1 of /Connections/eam.php
    < ?php
    error_reporting(0); // Turn off all error reporting

  47. Ziko
    Posted 12/23/2014 at 3:27 pm | Permalink

    Thanks for reply. I did it and the error is solved. But when I run, index.php, I get this error “No database Selected”.
    eam.php content like below.
    Thanks in advance.

  48. Ziko
    Posted 12/23/2014 at 3:30 pm | Permalink

    // Enterprise Asset Management – Graham Fisk – – 2012 //
    # FileName=”Connection_php_mysql.htm”
    # Type=”MYSQL”
    # HTTP=”true”
    error_reporting(0); // Turn off all error reporting
    $hostname_eam = “localhost”; // MYSQL database host adress – do not Change!
    $database_eam = “eam”; // MYSQL database name
    $username_eam = “eam”; // Mysql Datbase user
    $password_eam = “”; // Mysql Datbase password
    $eam = mysql_pconnect($hostname_eam, $username_eam, $password_eam) or trigger_error(mysql_error(),E_USER_ERROR);

  49. mushrif ali
    Posted 01/07/2015 at 1:07 am | Permalink

    link is expired

  50. gfisk
    Posted 01/07/2015 at 10:44 pm | Permalink

    Thanks Mushrif – another issue with the download software after their major upgrade.
    * Until resolved – Download or dismiss the link expired text file then wait aprox 2-3+ minutes and you will be able to download by clicking the download button again.

  51. Posted 01/08/2015 at 6:12 am | Permalink

    Download ling is not working Please guide to me where i can get this software

  52. gfisk
    Posted 01/08/2015 at 8:30 pm | Permalink

    Download link is fixed, apologies for the issue

    Posted 02/02/2015 at 5:43 am | Permalink

    working fine, please update the product for product management.

Post a Comment

Your email is never published nor shared. Required fields are marked *


You may use these HTML tags and attributes <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>