Design and Implementation of an Enhanced Real- Time Computer Inventory Management System: A Case of Rwanda Revenue Authority

The continuous development of technology and increase in IT environments have created a demand for the creation of efficient systems to manage these IT assets. This research covered the design and implementation of an enhanced Real-Time Computer Inventory Management System that handles tracking, security, and optimization of resource problems of IT assets. This system uses Laravel to develop an intuitive interface and backend, while powershell scripts are utilized to automate the gathering of real-time data in hardware and software inventories (computer name once changed after manual registration, IP Address, Operating system details, RAM, storage, CPU, logged-in users, and some software information such as currently installed applications,...). This conceptual framework hence guided the research in a manner that underlined the integration of real-time data gathering, scalability, and security. The results of semi-structured interviews with IT professionals explore qualitative findings on the vulnerabilities of existing systems and the ability for real-time solutions to improve IT governance. Major findings bring out that scalable and secure inventory systems create better decision-making, the accuracy of asset records, real-time data, and operational efficiency. The thematic analysis was used to identify some of the recurring themes on stakeholder engagement, data accuracy, and automation regarding contemporary IT asset management practices. This upgrade enhanced both the quality and quantity of IT asset recording, as well as their management and maintenance processes, furthering the mission of RRA being “To efficiently mobilize revenue and facilitate trade through transparent and innovative services to drive economic growth.” (RRA, Mission and Vision statement, 2024)