IT Inventory Database

[TheTwist]

Can anyone recomend a good IT inventory Database?

I am currently looking for something opensource (free)  so i can catalogue large amount of hardware.

It needs to be accessable for anyone to view.

 

I'm Currently using a spreadsheet which is beginning to get messy.  

 

 

 

[kirashi]

5 minutes ago, TheTwist said:

Can anyone recomend a good IT inventory Database?

I am currently looking for something opensource (free)  so i can catalogue large amount of hardware.

It needs to be accessable for anyone to view.

 

I'm Currently using a spreadsheet which is beginning to get messy.  

While there are more robust and feature-filled PAID options out there, I'd give https://snipeitapp.com/ a look first if you're after a self-hosted open source version, or even one of their simple hosted versions. It's been a while since I've had to setup an IT Asset Management system, so their code & design seems to have changed a lot, but back about 3 years ago they were one of the best free options available.

[Radium_Angel]

33 minutes ago, TheTwist said:

Can anyone recomend a good IT inventory Database?

I am currently looking for something opensource (free)  so i can catalogue large amount of hardware.

It needs to be accessable for anyone to view.

 

I'm Currently using a spreadsheet which is beginning to get messy.  

 

 

 

Kace K1000

[TheTwist]

1 hour ago, Erik Sieghart said:

There some questions you should ask:

How much hardware are you talking about?
What kind of information do you want to store?

On what criteria do you want to be able to search it?

A simple SQL database seems more than enough so there really should be a million front-end services to use that will be able to provide a better than excel spreadsheet service.

 

Roughly 1000+ hardware

Info that I want to store:

• Name of product

• Brand

• Model

• ID

• Serial number

• PO info

• Storage Location

• Date of purchase

• Notes 

I am thinking of learning how to use Access which might be the best place to do one. If there is a good template out there it would be useful.

All it needs is to have a record.

•            Monitors

•            Graphics cards

•            Laptop

•            Motherboards

•          Printers

•           Speakers

•          Spare RAM

       

[TheTwist]

any other suggestions?

[NelizMastr]

6 minutes ago, TheTwist said:

any other suggestions?

Yes, to not use Access. Use a real database. If your database size is going over 10GB, get MySQL. Otherwise, MS SQL Express will do.

[TheTwist]

Not liking the free ones out there. Any one recommend any cheap ones.

[myselfolli]

Just use a MySQL database. It is free and open source and having a database is a million times better than having a spreadsheet.

 

Hit me up if you need help with the database design and/or setting up a MySQL server

[NelizMastr]

1 hour ago, TheTwist said:

Not liking the free ones out there. Any one recommend any cheap ones.

 

Basically, it's either a free one (mysql, potsgresql, mariadb, sql server express) or it's SQL Server ($$) or Oracle ($$$$$).

[TheTwist]

Okay I'll see how to create one. I'm a complete novice at SQL

[Guest]

That first post was good. If you host it yourself it’s free.