Hi
I have a report that shows all of the mobile devices in the company, how can I get it to show the related info for the SIM card in the device. Bellow is what I have so far, just basic but can't work out how to link the SIM details
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssetCustom.Model,
tblAssetCustom.Custom1 As IMEI
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tsysAssetTypes.AssetTypename = 'Mobile phone' And tblAssetCustom.State = 1
Cheers in Advanced
