Custom Cell phone report

[TurboGFF]

Hey, I'd like to create the following report

Asset type is cell phones, I would like to see "Asset Name, Model, Location, and custom fields 12,13, and 14. (Phone number, IMIE, and SIM card respectively)

Could anyone help me build it?

Thanks

[Srikanth08]

In this report..i tried it said no data available..
first how to scan the cell phones?

[TurboGFF]

This did it. Thank you very much

[Hemoco · Accepted solution]

Try:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssetCustom.Model,
tblAssetCustom.Location,
tblAssetCustom.Custom12,
tblAssetCustom.Custom13,
tblAssetCustom.Custom14,
tblAssets.Lastseen
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tsysAssetTypes.AssetTypename = 'cell phone' And tblAssetCustom.State = 1