Polling print devices using SNMP while the printer is printing

Introduction

Print Information Collection Client

1. intercepts messages from the CUPS print service
2. saves print information to a CSV file
3. sends CSV files to a folder on the server via FTP

1. Date and time of print job
2. IP address or domain name of the computer from which the document was sent to print
3. IP address or host of the print device
4. Cups Job ID - Job ID from the CUPS Print Service
5. Job name - this is most often the file name
6. Name of user who sent to print
7. Number of pages
8. Print job size (Job size in KB)
9. Print Status (Job Status)
10. Number of copies (Number of copies)
11. The number of copies on the job file - is used to more accurately determine the number of copies;
12. Number of pages by SNMP protocol - used to more accurately determine the number of pages
13. SNMP is available - this is a sign that the device should be continuously polled using the SNMP protocol while the document is being printed
14. The counter of the printing device at the time of printing start (SNMP variable value) is the verification counter that determines the start of SNMP polling by the server

[main]
#    
app_directory = /opt/printwatcher

#  .    
#        )
stat_file_directory = /opt/printwatcher/data

# ,      
state_file = /opt/printwatcher/data/state.pickle

# ,       
command_state_file = /opt/printwatcher/data/command.state

#    
#   :
#  datetime -     ISO 8601
#  random -    8 
stat_filename_template = {random}_print_jobs.csv

#      
# (    )
max_stat_file_size_mb = 10

#  CSV.  : TAB, SPACE, SEMICOLON, COMMA
csv_delimiter = SEMICOLON

#      
start_service = start


[logging]

#   (DEBUG, INFO, TRACE)
level = DEBUG

#  
log_file = /var/log/printwatcher.log

#      
restart_log_file = /var/log/printwatcher-restart.log

#   
# (  /   logrotate)
max_log_file_size_mb = 10


[cups]

# ,      CUPS
spool_directory = /var/spool/cups/

#    CUPS    
# ( )
job_file_lifetime_hours = 48

#           
# ( )
job_info_lifetime_hours = 48


#  FTP
[ftp]

host = 192.168.1.39
user = ftpuser
password = P@ssw0rd
port = 21

#         FTP
# ( )
connection_retry_seconds = 10

#  ,       FTP
# ( )
connection_timeout_seconds = 3600

#        FTP 
# ( )
polling_interval = 30

#     ftp-
management_directory = /management

#       ftp-
response_directory = /management

#   
update_directory = /update

#      
data_directory = /data

#  SNMP
[snmp]
#      SNMP
retrieve_snmp_info = false
community = public
oid = 1.3.6.1.2.1.43.10.2.1.4.1.1
port = 161

Print Information Collection Server Architecture

1. Database Configurator is a GUI application that allows you to create and delete a database.
   The database is maximally normalized so that there are no text fields in the main statistics table to save disk space.
2. , GUI SNMP-, OID, .
   
   
   
   
3. ( Windows)

1. CSV-
2. CSV
3. CSV-
4. CSV- ( ) [ ]
5. CSV-
7. OID'
8. ,

Saving information in the database

1. SNMP polling start and end time
2. total number of lines in the CSV file
3. The number of lines with SNMP polling enabled.

1. The default group, in which there are all devices of the ricoh_dmnx base, is the name of the database of the monitoring system from the manufacturer Ricoh, from which we take the list of devices to be polled.
2. Devices that are in the ricoh_dmnx database, but not in groups
3. Devices that are in the ricoh_dmnx database and are in groups
4. Devices that are not in the ricoh_dmnx database, but are in our service database

Underwater rocks

System OIDs of Printing Devices

Reports

Monthly Print Comparison Report

Printed Jobs by User

SNMP Request Summary Report

SNMP Request Statistics

Conclusion