Report from specific Hostnames from a .txt file.

[Adriano_Ferreir]

Hello everyone.
I have an old .txt file here with hostnames only.
How can i generate a report from specific Hostnames from this .txt file?

[Adriano_Ferreir]

OK, now i know the correct IP Adress based on this report.
How can i deploy software using this report?
That´s the plan.

[Adriano_Ferreir]

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