Inventory of enterprise software using Kaspersky Anti-Virus
I want to share my experience in solving the problem of inventory of programs installed on enterprise computers. Personally, I could not choose the one that suits our organization from the proposed variety of products, and wrote it myself.
It is no secret that Kaspersky Anti-Virus is quite popular, and in the corporate environment centralized management using the Administration Server is used. In Kaspersky Administration Kit 8.0, there is a Registry of Programs that collects the information we need. Why, then, duplicate this function and use something else? It remains to process the existing data.
')
The general principle: using a bunch of Apache + PHP + MySQL, we write a script that loads data from the Kaspersky DB into our table by clicking a button on the main page. Through the web interface, we can view the status at each time at which the download was made. We add functions for comparing two snapshots of states and analyzing existing licenses.
Some notes: I use FreeBSD, and I needed the freetds library to run the php function mssql_connect (). The Kaspersky Administration Server can use both a full-fledged MSSQL Server and its own DBMS, which is the same MSSQL but Express Edition. Data loading works in any case, but in EE it is necessary to enable network services in SQL Server Configuration Manager and for TCP / IP to specify the necessary port (for example, 1433). It is also desirable to create a special user to connect.
Program home page: www.dcvetkov.net/monpo.html
index.php: the main file in which we specify the database parameters (mysql and mssql) and describe the html-template. My design is as simple as possible.
upload.php: data upload script. It describes the replacement of the names of some programs according to the principle you need. For example, I delete version numbers from the names so that the same program of a different version is counted as one. I also delete driver and update data.
compare.php: snapshot comparison functions.
license.php: license accounting functions.
license.txt: a file describing existing licenses.
logons.txt: a file matching the name of the computer and the user behind it. For the convenience of analyzing reports. It may be empty.
monpo.sql: - MySQL table description.
It is necessary:
- see how many instances of each program are installed;
- be able to compare the current state and last week;
- be able to take into account the used licenses and monitor their excess.
Decision:
It is no secret that Kaspersky Anti-Virus is quite popular, and in the corporate environment centralized management using the Administration Server is used. In Kaspersky Administration Kit 8.0, there is a Registry of Programs that collects the information we need. Why, then, duplicate this function and use something else? It remains to process the existing data.
')
The general principle: using a bunch of Apache + PHP + MySQL, we write a script that loads data from the Kaspersky DB into our table by clicking a button on the main page. Through the web interface, we can view the status at each time at which the download was made. We add functions for comparing two snapshots of states and analyzing existing licenses.
Some notes: I use FreeBSD, and I needed the freetds library to run the php function mssql_connect (). The Kaspersky Administration Server can use both a full-fledged MSSQL Server and its own DBMS, which is the same MSSQL but Express Edition. Data loading works in any case, but in EE it is necessary to enable network services in SQL Server Configuration Manager and for TCP / IP to specify the necessary port (for example, 1433). It is also desirable to create a special user to connect.
Program home page: www.dcvetkov.net/monpo.html
Scripts:
index.php: the main file in which we specify the database parameters (mysql and mssql) and describe the html-template. My design is as simple as possible.
upload.php: data upload script. It describes the replacement of the names of some programs according to the principle you need. For example, I delete version numbers from the names so that the same program of a different version is counted as one. I also delete driver and update data.
compare.php: snapshot comparison functions.
license.php: license accounting functions.
license.txt: a file describing existing licenses.
logons.txt: a file matching the name of the computer and the user behind it. For the convenience of analyzing reports. It may be empty.
monpo.sql: - MySQL table description.
Source: https://habr.com/ru/post/111653/
All Articles