On Habré, the methods of optimizing the process of
inventorying the IT
infrastructure of an enterprise have been repeatedly mentioned. I want to highlight the task from the other side, namely from the side of marking equipment.
In my opinion, it is important not only to have the inventory number of the operating system, but also to always have the opportunity to get comprehensive information about the object being close to it, such as: MOL, commissioning date, network parameters, etc.
In the technical implementation of this task in practice, I ran into three problems:
- The sticker is of limited size, in my case the tape is 24 mm wide and a lot of printed text cannot be placed, otherwise the text will be difficult to read
- In my case, a tape 24 mm wide and 7 m long is 1.5 kRUR, which means it must be used as efficiently as possible.
- To foresee the possibility of automating the process of reading information
The
QR code did a fine job of solving this problem (link to Wikipedia)
The advantages of a QR code:- The most effectively used square sticker
- A large amount of data is encoded in a small area.
- Read any modern smartphone. With the help of the Google service, the disc, the read data can be entered into the spreadsheet online
Actually, the method itself:
You will need:- Unloading the inventory list or from internal accounting, it is better in the xls format. It is necessary to sort the columns in advance to simplify label decal. It is not possible to apply sorting and filters to the column of the table editor containing the image.

- QR code generator . I use the Open Source utility QRCodeGui. It can be downloaded for free from the Google repository. The utility is easy to use. It is possible to adjust the pixel size and adjust the degree of error correction. Supported command line. At the output we get PNG with a QR code.


- I found it optimal not to save each generated QR code to a file, but to take a screenshot of the area with its image and paste it directly into the table through the clipboard. Utility for creating screenshots . I use Free Screen Capture. She is able to make a screenshot of the selected area with the help of hot keys.
- Label printer I use Dymo LabelManager ll. The QR code is perfectly printed even as a bitmap image. I think that a conventional laser printer will cope completely. To compare the area of text and code:

- An example of a printed sticker:

- Smartphone with QR code reader installed. For example Googles.
Action algorithm- Copy the required table fields into QRCodeGui and generate a QR code
- Take a snapshot of the screen area with a QR code
- Insert a snapshot of the QR code in the appropriate cell of the table
- We print a sticker
findingsThe method allowed to quickly create / add and encode the necessary information about the IT infrastructure (300 positions in 1 hour). Encoded information is convenient for reading, storing and inventory. Extremely economical consumption of materials. With the introduction of read automation, there is no need to re-stick labels. The purchase of special scanners and printers, as well as software is not required.
PS I am sure that this method can be further improved, but in this form it has shown its effectiveness.