Help with getting Script to run

PowerShell Help
1

I am a complete newbie. I am unable to get this script running which I copy and pasted from Holger SCHWICHTENBERG’s book - Powershell 7 und Windows Powershell 5.

Einstellungen

$InputFileName = “computernamen.txt“
$OutputFileName = “softwareinventar.csv“
$Query = “SELECT * FROM Win32_Product where not Vendor like ‘%Microsoft%’”

Eingabedatei auslesen

$Computers = Get-Content $InputFileName

Schleife über alle Computer

$Software = $Computers | foreach { Get-CimInstance -query $Query -computername $_ }

Ausgabe in CSV

$Software | select Name, Description, IdentifyingNumber, InstallDate,
InstallLocation, InstallState, SKUNumber, Vendor, Version | export-csv
$OutputFileName -notypeinformation

I put it into Powershell ISE and created the input and output file into a folder. computernamen.txt was put into the system32 folder.

I would appreciate your help to get this running.

Thank you.

2

Hello and welcome to the forum. Please remember to format any shared code/output as “preformatted text” so that it maintains code syntax.
Guide to posting code

Looking at the code that’s there nothing immediately jumps out at me as wrong.
It might be time to break this down a bit and try something one at a time. If you’re already in ISE you can use F8, or the “Run Selection” button at the top.
Execute your variable definitions, and the line defining $Computers. Then manually down in the shell maybe try something like this:

# load the first computer from your list in to a new variable
PS> $Computer = $Computers[0]
# manually run your ciminstance command against just this one computer
PS> Get-CimInstance -Query $Query -ComputerName $Computer

If that successfully produced output then you can proceed with running the whole line that defines $Software. When it’s done you can then call $Software from the shell below and make sure it contains objects. If it does, you can export to CSV.

3

Win32_product is evil! Dont use it.

2 Likes
4

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.