Abstract:
The article presents an approach to automated inventory of system parameters of computers in the Windows domain. The developed solution uses a PowerShell script, run according to group policies, to collect information about the characteristics of computers, such as the processor model, memory capacity, installed operating system, and other parameters. The collected data is stored in the MS SQL database. The implementation of the hash recording mechanism allows tracking changes in computer characteristics and optimizing the frequency of writing data to the database. The proposed approach provides efficient and automated management of the OT infrastructure, significantly reducing labor costs and increasing the efficiency of decision-making. The article describes the architecture of the system, the algorithms of the script, and the structure of the database, providing practical guidance on the implementation of automated inventory.
Keywords:inventory of system parameters, Windows domain, PowerShell, MSSQL