Having worked for various companies either as consultant or for their internal IT department, I again and again came across the fact that proper IT documentation, asset management and IP address management for the network is not documented at all or in various text, Microsoft Word or Excel files up to expensive solutions.
Another challenge I faced a lot is proper network and system monitoring, while there are great tools out there – one of the challenges remains thought there are solutions for this as well but nothing I saw so far that was free and giving me the chance to see in detail What changed in my Active Directory?
Due to my experience with developing software (thought I am not a professional developer) I several times developed an in-house solution on various platforms. Partly deeply integrated in their ERP system or other systems they had in place. This code was sometimes developed in an .NET language – but there is always that one downside to it – who will support the application in the long run – especially if there are no other developers in the company.
Out of this issue I started the Microsoft Access based project that you will find here. It is an simple structure SQL database with an Microsoft Access front end. For the most part it is very simple to understand if you at least have some VBScript or VBA experience and basic database knowledge.
The whole application might likely already cover most of your needs – some of the highlights are
- automated history entries for changes to data records
- toner inventory management
- LDAP change reporting
- LDAP compare against the assets in the database
- IP address management / IPAM based on the assets in the database
The feature list is actually pretty long already. You still can add, remove or modify the database. If you don’t want to use certain features, just use the internal rights management for the application users and disable them so they do not appear.
My goal was to have a more generic approach while keeping everything wide open so I could re-use it and share it with others as well.
Comments and suggestions are always welcome, just use the contact form.