PowerShell 学习感悟——2021年3月21日

最新推荐文章于 2024-09-07 16:48:31 发布

独行侠丶龙龙

最新推荐文章于 2024-09-07 16:48:31 发布

阅读量161

点赞数

分类专栏： PowerShell 文章标签： powershell windows csv

本文链接：https://blog.csdn.net/Lumiadragon/article/details/115038069

版权

PowerShell 专栏收录该内容

10 篇文章 0 订阅

订阅专栏

Powershell

多数据查询，单个文件产出

>_. PowerShell 数据查询，文件导出
数据综合查询，合并csv文件，单个文件产出。

2021年3月21日 00点33分
-----观感-----
回首观往事
世间已千日
樑下看农夫
不觉已麦熟

------------------代码如下------------------

话不多说，直接上源码

命令一览


$AllCsv = New-Object System.Collections.ArrayList 

"127.0.0.1","localhost","192.168.0.105" | ForEach-Object { 

    $WmiA = Get-WmiObject -Class win32_bios -Cn $_ -Property Name,SerialNumber,Version | 
        Select-Object -Property @{ Name = "BIOSName" ; Expression = { $_.Name } } ,
                                @{ Name = "BIOSSeralNumber" ; Expression = { $_.SerialNumber } } ,
                                @{ Name = "BIOSVersion" ; Expression = { $_.Version } }

    $WmiB = Get-WmiObject -Class win32_operatingsystem -Property RegisteredUser,BuildNumber,SerialNumber | 
        Select-Object -Property RegisteredUser,BuildNumber,SerialNumber

    $WmiA | Add-Member -MemberType NoteProperty -Name OSRegisteredUser -Value $WmiB.RegisteredUser -Force
    $WmiA | Add-Member -MemberType NoteProperty -Name OSBuildNumber -Value $WmiB.BuildNumber -Force
    $WmiA | Add-Member -MemberType NoteProperty -Name OSSerialNumber -Value $WmiB.SerialNumber -Force

    $WmiA | ForEach-Object { 

                $AllCsv.add($_) 

            } 
} 

$AllCsv | 
ConvertTo-Csv -NoTypeInformation | 
Out-File -FilePath C:\Intel\Test\Test.csv -Force

单行脚本，酣畅淋漓

$AllCsv = New-Object System.Collections.ArrayList ; "127.0.0.1","localhost","192.168.0.105" | ForEach-Object { $WmiA = Get-WmiObject -Class win32_bios -Cn $_ -Property Name,SerialNumber,Version | Select-Object -Property @{ Name = "BIOSName" ; Expression = { $_.Name } } , @{ Name = "BIOSSeralNumber" ; Expression = { $_.SerialNumber } } , @{ Name = "BIOSVersion" ; Expression = { $_.Version } } ; $WmiB = Get-WmiObject -Class win32_operatingsystem -Property RegisteredUser,BuildNumber,SerialNumber | Select-Object -Property RegisteredUser,BuildNumber,SerialNumber ; $WmiA | Add-Member -MemberType NoteProperty -Name OSRegisteredUser -Value $WmiB.RegisteredUser -Force ; $WmiA | Add-Member -MemberType NoteProperty -Name OSBuildNumber -Value $WmiB.BuildNumber -Force ; $WmiA | Add-Member -MemberType NoteProperty -Name OSSerialNumber -Value $WmiB.SerialNumber -Force ; $WmiA | ForEach-Object { $AllCsv.add($_) } } ; $AllCsv | ConvertTo-Csv -NoTypeInformation | Out-File -FilePath C:\Intel\Test\Test.csv -Force