Basic network printer report needed (Printer Name & MAC Address)

[TRC_System_Admi]

Hello,

I'm brand spanking new to this awesome LANsweeper app.

Can someone create me a simple network printer report?

I need it to display all network printers with the below 2 fields.

- Printer Name
- MAC Address


I can not use the stock printer reports as I need to add a few custom fields.

Thanks

[TRC_System_Admi · Accepted solution]

I figured it out..

AssetName - IPAddress - Printedpages - Manufacturer - Model - Location - Mac

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssetCustom.Printedpages,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssetCustom.Location,
tblAssets.Mac
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tsysAssetTypes.AssetTypename = 'printer' And tblAssetCustom.State = 1