Mike
asked on
Need Help with Powershell Script
Couple Days ago my boss gave me a task to scan number of computers to get a full Involuntary of software installed on each device. I created a powershell script to scan list of computers in a text file (devices.txt) and then list the software installed on there own worksheet. What my boss wants me to do now is it to scan the output file and get the full count of installed software on the network. I have a total of 2000 computers I have scanned and I need to find a way to modify my current scrip or create 2nd one to compile list of the software an a total number of each installed.
I have attached the script and sample of the output file....
I have attached the script and sample of the output file....
#Create a new Excel object using COM
$Excel = New-Object -ComObject Excel.Application
$Excel.visible = $True
$Excel.SheetsInNewWorkbook = @(get-content "C:\PS\MBSA\servers.txt").count
#Counter variable for rows
$i = 1
#Read thru the contents of the Servers.txt file
foreach ($server in get-content "C:\PS\MBSA\servers.txt")
{
$Excel = $Excel.Workbooks.Add()
$Sheet = $Excel.Worksheets.Item($i++)
$Sheet.Name = $server
$intRow = 1
# Send a ping to verify if the Server is online or not.
$ping = Get-WmiObject `
-query "SELECT * FROM Win32_PingStatus WHERE Address = '$server'"
if ($Ping.StatusCode -eq 0) {
#Create column headers
$Sheet.Cells.Item($intRow,1) = "NAME:"
$Sheet.Cells.Item($intRow,2) = $server.ToUpper()
$Sheet.Cells.Item($intRow,1).Font.Bold = $True
$Sheet.Cells.Item($intRow,2).Font.Bold = $True
$intRow++
$Sheet.Cells.Item($intRow,1) = "APPLICATION"
$Sheet.Cells.Item($intRow,2) = "VERSION"
#Format the column headers
for ($col = 1; $col –le 2; $col++)
{
$Sheet.Cells.Item($intRow,$col).Font.Bold = $True
$Sheet.Cells.Item($intRow,$col).Interior.ColorIndex = 48
$Sheet.Cells.Item($intRow,$col).Font.ColorIndex = 34
}
$intRow++
$software = Get-WmiObject `
-ComputerName $server -Class Win32_Product | Sort-Object Name
#Formatting using Excel
foreach ($objItem in $software){
$Sheet.Cells.Item($intRow, 1) = $objItem.Name
$Sheet.Cells.Item($intRow, 2) = $objItem.Version
$intRow ++
}
$Sheet.UsedRange.EntireColumn.AutoFit()
}
}
Clear
Output-File.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER