<div>
Thanks Ji and David. &nbsp;It appears that running Powershell scripts is disabled. &nbsp;However, the script below does produce an Output.csv file with two named columns, but no actual data.<br />

<pre><code id="code-20-41018329-1">@echo off
 set HostList=C:\Hostnames.txt

 Echo Hostname,IP&gt;Output.csv
 setlocal enabledelayedexpansion

 for /f “usebackq tokens=*” %%A in (“%HostList%”) do (
 for /f “tokens=3” %%B in (‘ping -n 1 -l 1 %%A ^|findstr Reply’) do (
 set IPadd=%%B
 echo %%A,!IPadd:~0,-1!&gt;&gt;Output.csv
 ))</code></pre>
</div>


Thanks Ji and David.  It appears that running Powershell scripts is disabled.  However, the script below does produce an Output.csv file with two named columns, but no actual data.


@echo off
 set HostList=C:\Hostnames.txt

 Echo Hostname,IP>Output.csv
 setlocal enabledelayedexpansion

 for /f “usebackq tokens=*” %%A in (“%HostList%”) do (
 for /f “tokens=3” %%B in (‘ping -n 1 -l 1 %%A ^|findstr Reply’) do (
 set IPadd=%%B
 echo %%A,!IPadd:~0,-1!>>Output.csv
 ))

<div>
<div class="content wysiwyg-content">
I need a command that will look at file hostname.txt and produce an ip.txt from it. &nbsp;Assistance is greatly appreciated.
</div>
</div>


I need a command that will look at file hostname.txt and produce an ip.txt from it.  Assistance is greatly appreciated.

Syntax to resolve hostname

The term 'shell' refers to a general class of text-based command interpreters most often associated with the UNIX and Linux operating systems. Popular shells include Bourne, Debian Almquist (dash), Korn (ksh), Bourne Again (bash) and the C shell family (csh). Some view the DOS 'cmd' prompt as a minimal shell of sorts. It is also possible to install Cygwin on Windows and emulate a full Unix environment with complete shell capabilities. Terminal emulators, such as xterm, GNOME Terminal and OS X Terminal, can be used to access shell.

Shell Scripting

Windows PowerShell is a task automation and configuration management framework from Microsoft, consisting of a command-line shell and associated scripting language built on the .NET Framework. PowerShell provides full access to the Component Object Model (COM) and Windows Management Instrumentation (WMI), enabling administrators to perform administrative tasks on both local and remote Windows systems as well as WS-Management and Common Information Model (CIM) enabling management of remote Linux systems and network devices.

Powershell

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.