Report Showing all Printers with a Particular Custom Field Populated

[Jono]

Hello,

SQL is a weak area for me, so I need some help writing a report. I would like to see a report of all of our printers that have a particular custom field populated, regardless of what's in the field. If that particular custom field is anything but blank, I'd like it to be in the report.

And just for information, how would I write the same report for all assets, not just printers?

Thanks for any help you can provide.

Jono

[Susan_A]

FYI for everyone: from Lansweeper 5.2 onwards, it is possible to add clickable links to reports.

[Jono]

Also, it would be very helpful if I could click on each printer's HTTP link right from the report. Is there a way to add a column that would give me that link, rather than clicking on each printer and then clicking the HTTP link to go to its web interface?

[Jono]

I have figured it out, but it might be a bit rudimentary.

Select Top 1000000 tblAssets.AssetName,
  tblAssetCustom.Location,
  tblAssetCustom.AssetID,
  tblAssets.Assettype,
  tblAssetCustom.Custom12 As [Toshiba ID]
From tblAssetCustom
  Inner Join tblAssets On tblAssets.AssetID = tblAssetCustom.AssetID
Where tblAssets.Assettype = 16 And tblAssetCustom.Custom12 <> ''
Order By tblAssetCustom.Location

I figured out by accident that the printer asset type is type #16. Is there a place where I can find a list of asset types so that I can do similar reports?

Thanks,
Jono

[Hemoco · Accepted solution]

Jono wrote:
I figured out by accident that the printer asset type is type #16. Is there a place where I can find a list of asset types so that I can do similar reports?

You can link tsysAssetTypes to tblAssets on the AssetType field and check AssetTypename in tsysAssetTypes. This will allow you to use the asset type name in the report instead of a code.

It is not currently possible to create clickable URLs in reports.