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


Authors : Innocent Nsabimana; Dr. Bugingo Emmanuel

Volume/Issue : Volume 10 - 2025, Issue 4 - April


Google Scholar : https://tinyurl.com/mrtkwf7b

Scribd : https://tinyurl.com/y6fc53by

DOI : https://doi.org/10.38124/ijisrt/25apr1009

Google Scholar

Note : A published paper may take 4-5 working days from the publication date to appear in PlumX Metrics, Semantic Scholar, and ResearchGate.

Note : Google Scholar may take 15 to 20 days to display the article.


Abstract : 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)

Keywords : Power Shell, Laravel, CPU, Operating System.

References :

  1. Andy , D., Dipankar, D., Paul , D., & Brenna , S. (2023). Maximizing IT Asset Performance with Real-Time Management Systems. Deloitte.
  2. 19770-1:2017, I. (2017). Information technology — IT asset management . .
  3. Ali, R., & Ahmed, S. (2021). Integrating Modern Frameworks for IT Asset Management. International Journal of IT Systems, 45-59. Retrieved 08 03, 2024
  4. Bank, A. D. (2022). Digital Transformation Strategy for Africa (2020–2030). Retrieved 10 20, 2024, from www.afdb.org
  5. Barney, J. (1991). Firm resources and sustained competitive advantage (Vol. 17(1)). doi:https://doi.org/10.1177/014920639101700108
  6. Braun, V., & Clerke, V. (2006). Using thematic analysis in psychology. doi:http://dx.doi.org/10.1191/1478088706qp063oa
  7. Brinkmann, S. (2014). Unstructured and Semi-Structured Interviewing. doi:https://doi.org/10.1093/oxfordhb/9780199811755.013.030
  8. Brown, A., & Green, T. (2019). Evolution of Asset Management Technology. 45-59.
  9. Buttazo, G. C. (2011). Hard Real-Time Computing Systems: Predictable Scheduling Algorithms and Applications. Springer.
  10. C.Laudon, K., & P.Laudon, J. (2020). Management Information Systems: Managing the Digital Firm. Pearson. Retrieved from https://repository.dinus.ac.id/docs/ajar/Kenneth_C.Laudon,Jane_P_.Laudon_-_Management_Information_Sysrem_13th_Edition_.pdf
  11. Chen, R., Lee, S., & Kang, Y. (2022). Automation IT Processes with PowerShell. Journal of Autmation in Systems. Retrieved from https://doi.org/10.1016/j.jaits.2022.03.001
  12. Codd, E. (1970). A relational model of data for large shared data banks. Communication of Acm.
  13. Creswell, J., & Plano Clark, V. L. (2019). Designing and conducting mixed methods research (3rd ed.). SAGE Publications. doi:https://doi.org/10.1177/1937586719832223
  14. Davis, M., & Gracia, R. (2023). Scalability in IT Asset Management System. Jounal of Information Technology, 35(2), 87-101.
  15. Davis, R. (2021). Reducing Downtime with Proactive Asset Management. Maintenance Techology Journal, 18(3), 90-102.
  16. Gartner. (2020). IT Asset Management Key Initiative Overview. Retrieved 2024, from Gartner: https://www.gartner.com/en/documents/2519015
  17. Gartner. (2024). . Retrieved from https://www.gartner.com: https://www.gartner.com/en/information-technology/insights/cybersecurity
  18. Guest, G., Bunce, A., & Johnson , L. (2006). How Many Interviews Are Enough . doi:https://doi.org/10.1177/1525822X05279903
  19. Guest, G., Bunce, A., & Johnson, L. (2006). How Many Interviews Are Enough. Sage Publications, 59-82. doi:https://doi.org/10.1177/1525822X05279903
  20. Hagaman, A., & Wutich, A. (2017). How Many Interviews Are Enough to Identify Metathemes in Multisited and Cross-cultural Research? Another Perspective on Guest, Bunce, and Johnson’s (2006) Landmark Study. Thousand Oaks, CA: Sage., 29, 23-41. doi:https://doi.org/10.1177/1525822X16640447
  21. Hussain, A., & Awan, S. A. (2021). Leveraging Automation for IT Asset Management. Journal of Advanced IT Research, 45-67.
  22. IBM. (2024). https://www.ibm.com/topics/data-loss-prevention. Retrieved from https://www.ibm.com.
  23. Joseph, L., & Jenkins, A. (2019). Automated IT Asset Management: Tools and Techniques. Jounal of Information Technology Management, 45-60.
  24. Kallio, H., Pietila, A.-M., Martin, J., & Mari Kangasniemi, D. (2016). Systematic methodological review: developing a framework for a qualitative semi-structured interview guide (Vol. 72). Journal of Advanced Nursing. doi:https://doi.org/10.1111/jan.13031
  25. Kim, H., & Lee, J. (2022). RFID-based Asset Management in Hospital. Healthcare Management Rewiew. 28(2), 132-135.
  26. KPMG. (2023). Navigating-the-digital-frontier-asset-intensive-organisations.pdf. Retrieved from https://assets.kpmg.com/content/dam/kpmg/au/pdf/2023/navigating-the-digital-frontier-asset-intensive-organisations.pdf
  27. Lee, C., & Park, S. (2020). RFID-based Real time asset Tracking in Healthcare. 26(3),233-245.
  28. Malik, P., Zhang, Q., & Lee, J. (2023). Scalability and Security in Relational Databases for Real-Time System. Database Management Quarterly. 78-90.
  29. Patel, R., & Nguyen, T. (2022). User Experience and Satisfaction in IT Asset Management Systems. Journal of User Experience.
  30. Patricia, L. (. (2014). The Oxford Handbook of Qualitative Research. Oxford University Press. doi:https://doi.org/10.1093/oxfordhb/9780199811755.001.0001
  31. Patton, & Michael , Q. (2002). Qualitative research and evaluation methods. Thousand Oaks, Calif. : Sage Publications.
  32. Patton, M. Q. (n.d.).
  33. RRA. (2024, 11 10). Retrieved from RRA Website: https://www.rra.gov.rw/en/about-us/rra-profile#:~:text=Mission%20and%20Vision%20statement&text=%E2%80%9CTo%20be%20a%20model%20revenue%20administration%20optimally%20financing%20national%20needs.%E2%80%9D&text=%E2%80%9CTo%20efficiently%20mobilize%20revenue
  34. RRA. (2024). Mission and Vision statement. Retrieved from www.rra.gov.rw: https://www.rra.gov.rw/en/details?tx_news_pi1%5Baction%5D=detail&tx_news_pi1%5Bcontroller%5D=News&tx_news_pi1%5Bnews%5D=1062&cHash=b69f99b9f1809e20a67532ee4a5ed2f8
  35. Shavah, V., & Rao, N. (2020). Modern Approaches in Inventory Systems Using Real-Time Data. IT Systems Journal, 29-42.
  36. Smith, P., & Jones, M. (2021). Automating IT Asset Discovery for Improved IT Governance. International Journal of IT Management, 8(2), 34-50.
  37. Wang, X., Patel, N., & Singh, S. (2022). Addressing Scalability in Real-Time Inventory Systems. Journal of IT Scalability, 123-137.

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)

Keywords : Power Shell, Laravel, CPU, Operating System.

Never miss an update from Papermashup

Get notified about the latest tutorials and downloads.

Subscribe by Email

Get alerts directly into your inbox after each post and stay updated.
Subscribe
OR

Subscribe by RSS

Add our RSS to your feedreader to get regular updates from us.
Subscribe