Client Management Suite

I need query all our network printers with Printer name, IP address, subnetmask, gateway, I don't know where is the table name has all this info

Thanks

Lillian

Hi,

Try Inv_AeX_AC_TCPIP and Inv_AeX_AC_TCPIPv6 - these tables contain all the info about known network devices.

Thank you,

Alex.

I just run the query

selct * from inv_Aex_AC_TCPIP, it only show all my computers devices, not priter.

Thanks

Lillian

Hi,

Actually there is built-in report "All Network Printers" in NS console - do you see any data in it?

Thank you,

Alex.

More info: there are at least two ways to detect printers in the network:

1. Run Network Discovery task (Home -> Discovery and Inventory -> Network Discovery) in your network.

2. Import corresponding resources from AD (Action -> Discover -> Import Microsoft Active Directory, select "Import Print Queue resources...")

There are several views in the database which contain data about discovered printers like: vNetworkPrinter, vNetworkPrinterResource, vRM_Network_Printer_Item

Priners inventory information stored in the tabel: "Inv_ID_Network_Printer".

HTH,

Alex.

Alex,

    I run all the table you gave to me, it look good, but can I have those printer name with IP address, subnet mask, default gateway?

   where are this table?

Thanks

Lillian

Hi Lillian,

Please try following query:

SELECT [Name], [IP Address], [Subnet Mask], [Subnet], [Default Gateway] FROM Inv_ID_Network_Printer
LEFT JOIN Inv_AeX_AC_TCPIP ON Inv_ID_Network_Printer._ResourceGuid = Inv_AeX_AC_TCPIP._ResourceGuid

Thank you,

Alex.