cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
TurboGFF
Engaged Sweeper III
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
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
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

View solution in original post

12 REPLIES 12
Srikanth08
Engaged Sweeper II
In this report..i tried it said no data available..
first how to scan the cell phones?
Regards, Srikanth08
TurboGFF
Engaged Sweeper III
This did it. Thank you very much
Hemoco
Lansweeper Alumni
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