Ok i made it based on another i found here in the forum using IP.
Select Top 1000000 tblassets.AssetName,
tblassets.IPAddress
From tblassets
Inner Join tblassetcustom On tblassets.AssetID = tblassetcustom.AssetID
Inner Join tsysassettypes On tsysassettypes.AssetType = tblassets.Assettype
Where tblassets.AssetName In ('MCGH1NT120', 'SCBMDK015', 'SVLADK010',
'SCBMNT001', 'MCBMDK001', 'SVLADK009', 'SMOANT007', 'MCGH1NT200', 'MMOANT003',
'SVLADK014', 'SVLADK003') And tblassetcustom.State = 1