逗号分隔WMIC命令

Question

我做了这个脚本，使用WMIC从远程计算机

set /p "user=write UserName=" 
set /p "password=write Password=" 


for /f "tokens=*" %%a in (ip.txt) do ( 

    wmic /node:%%a /user:%user% /password:%password% computersystem get Name /format:table 
    wmic /node:%%a /user:%user% /password:%password% computersystem get Model /format:table 
    wmic /node:%%a /user:%user% /password:%password% computersystem get totalphysicalmemory /format:table 
    wmic /node:%%a /user:%user% /password:%password% cpu get Name /format:table 
    wmic /node:%%a /user:%user% /password:%password% path Win32_VideoController get Name /format:table 
    wmic /node:%%a /user:%user% /password:%password% os get Caption /format:table 
    wmic /node:%%a /user:%user% /password:%password% csproduct get identifyingnumber /format:table 
    wmic /node:%%a /user:%user% /password:%password% desktopmonitor get screenheight /format:table 
    wmic /node:%%a /user:%user% /password:%password% desktopmonitor get screenwidth /format:table 

)>>a.csv 

获得信息，但输出是有点不可思议它的方式隔开“中输入”知道怎样使用逗号分隔？

Answer 1

你可以试试下面的代码片段：

@echo off 
setlocal EnableDelayedExpansion 
set /P "user=write UserName=" 
set /P "password=write Password=" 
> "a.csv" (
    for /F "usebackq tokens=*" %%a in ("ip.txt") do (
     set "lineString=" 
     for /F "tokens=1,* delims==" %%A in ('wmic /node:%%a /user:%user% /password:%password% computersystem    get Name    /value') do for /F "delims=" %%Z in ("%%B") do set "lineString=!lineString!,%%Z" 
     for /F "tokens=1,* delims==" %%A in ('wmic /node:%%a /user:%user% /password:%password% computersystem    get Model    /value') do for /F "delims=" %%Z in ("%%B") do set "lineString=!lineString!,%%Z" 
     for /F "tokens=1,* delims==" %%A in ('wmic /node:%%a /user:%user% /password:%password% computersystem    get totalphysicalmemory /value') do for /F "delims=" %%Z in ("%%B") do set "lineString=!lineString!,%%Z" 
     for /F "tokens=1,* delims==" %%A in ('wmic /node:%%a /user:%user% /password:%password% cpu      get Name    /value') do for /F "delims=" %%Z in ("%%B") do set "lineString=!lineString!,%%Z" 
     for /F "tokens=1,* delims==" %%A in ('wmic /node:%%a /user:%user% /password:%password% path Win32_VideoController get Name    /value') do for /F "delims=" %%Z in ("%%B") do set "lineString=!lineString!,%%Z" 
     for /F "tokens=1,* delims==" %%A in ('wmic /node:%%a /user:%user% /password:%password% os       get Caption    /value') do for /F "delims=" %%Z in ("%%B") do set "lineString=!lineString!,%%Z" 
     for /F "tokens=1,* delims==" %%A in ('wmic /node:%%a /user:%user% /password:%password% csproduct     get identifyingnumber /value') do for /F "delims=" %%Z in ("%%B") do set "lineString=!lineString!,%%Z" 
     for /F "tokens=1,* delims==" %%A in ('wmic /node:%%a /user:%user% /password:%password% desktopmonitor    get screenheight  /value') do for /F "delims=" %%Z in ("%%B") do set "lineString=!lineString!,%%Z" 
     for /F "tokens=1,* delims==" %%A in ('wmic /node:%%a /user:%user% /password:%password% desktopmonitor    get screenwidth   /value') do for /F "delims=" %%Z in ("%%B") do set "lineString=!lineString!,%%Z" 
     if defined lineString echo(!lineString:~1! 
    ) 
) 
endlocal 
exit /B 

的wmic输出存储到, - 分隔字符串中的变量lineString。为了捕获命令的输出，for /F循环是完美的。但是，wmic命令会生成Unicode输出，因此需要两个嵌套的for /F循环才能进行适当的Unicode/ANSI转换;单个循环会在字符串中留下孤立的尾随回车符。

的wmic输出格式已从/format:table改变为/value得到这样的输出：Caption=Microsoft Windows 7 Enterprise，所以for /F环可以采取=作为分隔符，并得到所需的值。

除了这一切，我也改变了以下内容：

在代码中，你分别重定向每一个循环迭代的输出。为避免这种情况，()已放在（最外面的）for /F循环中，因此整个数据被重定向到a.csv。因此，重定向操作符已从追加类型>>更改为（over）写入类型>。

Delayed expansion已启用哪些修改和()之间读取内for回路或代码块的变量（lineString）时是必需的。