→ 🚀What's New? Explore Lansweeper's Fall 2024 Updates! Fall Launch Blog !

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Adriano_Ferreir
Engaged Sweeper
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?
2 REPLIES 2
Adriano_Ferreir
Engaged Sweeper
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
Engaged Sweeper
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