Printer report

[MikeInLa]

I need to pull a report on printers with the following criteria:

AssetName
IP
Model
Serial

Can someone help me with the proper code to produce this report? I would very much appreciate any help. Thanks 🙂

[MikeInLa]

that's perfect! Thanks!
🙂

[cdonizetti]

Hi,

try this :

Select Top 1000000 tblAssets.AssetName,
tblAssets.IPAddress,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssetCustom.Serialnumber,
tsysAssetTypes.AssetTypeIcon10 As icon
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType
Where tblAssets.Assettype = 16 And tblAssetCustom.State = 1