Local printer ip

[i_kulgu]

I can see all my network printers but i need also the IP adress of them.
In the web30repSharedPrinter SP i can see the discription, name etc.
How can i add the IP adress of the printers?

[kbp · Accepted solution]

I was able to get the IP Addresses with the SQL Query below. This was done with Report Builder.

SELECT
dbo.tblPrinters.Computername,
dbo.tblPrinters.Caption,
dbo.tblPrinters.Portname,
dbo.tblPrinters.Printprocessor,
dbo.tblPrinters.Lastchanged
FROM
dbo.tblPrinters
WHERE
dbo.tblPrinters.Local = 'True'

This pulls back all local ports, not just the IP printer ports.

As long as the Portname matches the IP Address (which is the default), you can get the information that you are looking for.

[Hemoco]

This won't be possible now.
Version 4.0 will have custom device scanning (snmp,ssh) (no release data has been announced yet)