List of SAP Printers, Corresponding Print servers and SAP print queue with Port used
If we need to check the printer, the access method used in a printer, the print server, and the SAP print queue name, then we can get all this information from T-Code SPAD. This is useful if the printer list is small, but getting this information for a large number of printers is not practical from SPAD.
SAP Print Queue and Printer details from DB level
We can get this information from the DB level via table TSP03D. Below command will give you all the required information. Below commands are specifically for Oracle DB.
# Set output format
COLUMN NAME FORMAT A15
COLUMN PALPDHOST FORMAT A20 WORD_WRAPPED
COLUMN PAMETHOD FORMAT A6
COLUMN PAPROSNAME FORMAT A15
COLUMN NAME HEADING PRINTER
COLUMN PALPDHOST HEADING PRINT-SERVER
COLUMN PALPDPORT HEADING PORT
COLUMN PAMETHOD HEADING METHOD
COLUMN PAPROSNAME HEADING PRINT-QUEUE
select Name, PAMETHOD, PAPROSNAME, PALPDHOST, PALPDPORT from SAPSR3.TSP03D;
Above command can be updated with where clause if you need information specific to one print server or any other requirement.