Question to PowerShell

PowerShell Help
1

Hi all,

I have one issue, i build this code in powershell

gwmi win32_computersystem | Select-Object -Property Devicename,Driverversion, Manufacturer, Model
gwmi Win32_PnPSignedDriver | select Devicename,Driverversion, Manufacturer | where {$.DeviceName -like “Bios”}
gwmi Win32_PnPSignedDriver | select Devicename,Driverversion, Manufacturer | where {$.DeviceName -like “Wireless”}
gwmi Win32_PnPSignedDriver | select Devicename,Driverversion, Manufacturer | where {$.DeviceName -like “HD Graphics”}
gwmi Win32_PnPSignedDriver | select Devicename,Driverversion, Manufacturer | where {$.DeviceName -like “Realtek High”}
gwmi Win32_PnPSignedDriver | select Devicename,Driverversion, Manufacturer | where {$.DeviceName -like “Ethernet”}
gwmi Win32_PnPSignedDriver | select Devicename,Driverversion, Manufacturer | where {$.DeviceName -like “Camera”}
gwmi Win32_PnPSignedDriver | select Devicename,Driverversion, Manufacturer | where {$_.DeviceName -like “Sierra”}

and my issue is when i try convert this all information to .CSV the file is all black can you help me for resolved my issue?
The objective is catch all this information and put in sharepoint it’s possible or not?

2

"Tis should get you going

 gwmi Win32_PnPSignedDriver | select Devicename,Driverversion, Manufacturer | where {
 $_.DeviceName -like "*Bios*" -or
 $_.DeviceName -like "*Wireless*" -or
 $_.DeviceName -like "*HD Graphics*" -or
 $_.DeviceName -like "*Realtek High*" -or
 $_.DeviceName -like "*Ethernet*" -or
 $_.DeviceName -like "*Camera*" -or
 $_.DeviceName -like "*Sierra*" }| export-csv g:\test.csv
3

Thanks that’s works :D.
Can you tell me if when i export this information to csv i can put online in sharepoint automatically?

4

You can shorten the above with a bit of regex:

 Get-WmiObject -Class Win32_PnPSignedDriver | Select-Object Devicename, Driverversion, Manufacturer | 
    Where-Object {
        $_.DeviceName -match "Bios|Wireless|HD Graphics|Realtek High|Ethernet|Camera|Sierra" 
    } | Export-Csv -Path 'g:\test.csv'