Sort by (Just show this)

[Rufinobr]

Hi Guys,

I'm trying to do something that I think it's easy. I have here a lot of different names machine like S2951, M2951, C2951 etc.

I want to list the AssetName, IP and OS. I just want to SHOW the machies that starts with S2951 in the name. How can i do it ?

I try putting something in criteria buts returns nothing in the report.
Below there's the 'code'
Sorry for my poor English

Select Top 1000000 tblAssets.AssetUnique,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblOperatingsystem.Caption,
tblAssets.AssetID
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblOperatingsystem
On tblAssets.AssetID = tblOperatingsystem.AssetID

[Hemoco · Accepted solution]

Please use the following report:

Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.IPAddress,
tblOperatingsystem.Caption
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblOperatingsystem
On tblAssets.AssetID = tblOperatingsystem.AssetID
Where tblAssets.AssetName Like 'S2951%'

[Rufinobr]

Lansweeper wrote:
Please use the following report:

Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.IPAddress,
tblOperatingsystem.Caption
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblOperatingsystem
On tblAssets.AssetID = tblOperatingsystem.AssetID
Where tblAssets.AssetName Like 'S2951%'

Thank you!!