→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
TRC_System_Admi
Engaged Sweeper II
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
1 ACCEPTED SOLUTION
TRC_System_Admi
Engaged Sweeper II
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

View solution in original post

1 REPLY 1
TRC_System_Admi
Engaged Sweeper II
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