Powershell Remote Server info

mcb · 2019-03-08T16:39:20.000Z

Hi all, hope all is well. Hoping someone can assist with a simple powershell report. I am trying to gather a report of server info such as Processor,Memory,Disks, & OS. Issue i am having is the Disks information. Every report i run is able to give me all the other info in a nice csv but once disk info is asked using Get-WmiObject -Class Win32_LogicalDisk it does not follow the formatting of the CSV. Wanted to see if anyone else has ran into this and has any suggestions

matt234 · 2019-03-08T16:45:13.000Z

You should just modify the output of the command to fit how you want it to be in the csv.

How do you want it? By default it looks like

DeviceID     : E:
DriveType    : 3
ProviderName :
FreeSpace    : 1722846179328
Size         : 4000750497792
VolumeName   : Elements

DeviceID     : G:
DriveType    : 4
ProviderName : \\app01\shares\userdata
FreeSpace    : 329769316352
Size         : 1073605505024
VolumeName   : DataShares

You can easily change this by doing a Select

PS C:\Users\me> Get-WmiObject -Class Win32_LogicalDisk | select DeviceID,ProviderName,Size,Freespace

DeviceID ProviderName                              Size     Freespace
-------- ------------                              ----     ---------
C:                                         159446462464   57483800576
D:
E:                                        4000750497792 1722846179328
G:       \\app01\shares\userdata          1073605505024  329769472000

mcb · 2019-03-08T16:47:45.000Z

Thank you. This part I have. Issue now is having one CSV that also includes memory,processor, & OS for multiple servers.

dancrane · 2019-03-08T17:50:00.000Z

Why not post the script you’re working with so we can see how to make suggestions? Chances are, you’ll just need to add a few things to a PSObject to store them, but the data could be presented in a number of different ways before the Export-CSV call.

mcb · 2019-03-08T17:52:57.000Z

I have been using the below.

<#
.SYNOPSIS
  Name: Get-PCInfo.ps1
  The purpose of this script is to retrieve basic information of a PC.

.DESCRIPTION
  This is a simple script to retrieve basic information of domain joined computers.
  It will gather hardware specifications and Operating System and present them on the screen.

.RELATED LINKS
  Home

.PARAMETER Computer
  This is the only parameter that is needed to provide the name of the computer either
  in as computer name or DNS name.

.NOTES
  Updated: 08-02-2018   Testing the connection before the information gathering.
  
  Release Date: 05-02-2018
  
  Author: Stephanos Constantinou

.EXAMPLE
  Run the Get-PCInfo script to retrieve the information.
  
  Get-PCInfo.ps1 -Computer test-pc
#>

Param( [string]$Computer )

$Connection = Test-Connection $Computer -Count 1 -Quiet

if ($Connection -eq "True") {

    $ComputerHW = Get-WmiObject -Class Win32_ComputerSystem -ComputerName $Computer |
        select Manufacturer,Model | FT -AutoSize

    $ComputerCPU = Get-WmiObject win32_processor -ComputerName $Computer |
        select DeviceID,Name | FT -AutoSize

    $ComputerRam_Total = Get-WmiObject Win32_PhysicalMemoryArray -ComputerName $Computer |
        select MemoryDevices,MaxCapacity | FT -AutoSize

    $ComputerRAM = Get-WmiObject Win32_PhysicalMemory -ComputerName $Computer |
        select DeviceLocator,Manufacturer,PartNumber,Capacity,Speed | FT -AutoSize

    $ComputerDisks = Get-WmiObject -Class Win32_LogicalDisk -Filter "DriveType=3" -ComputerName $Computer |
        select DeviceID,VolumeName,Size,FreeSpace | FT -AutoSize

    $ComputerOS = (Get-WmiObject Win32_OperatingSystem -ComputerName $Computer).Version

    switch -Wildcard ($ComputerOS) {
        "6.1.7600" {$OS = "Windows 7"; break}
        "6.1.7601" {$OS = "Windows 7 SP1"; break}
        "6.2.9200" {$OS = "Windows 8"; break}
        "6.3.9600" {$OS = "Windows 8.1"; break}
        "10.0.*" {$OS = "Windows 10"; break}
        default {$OS = "Unknown Operating System"; break}
    }
    
    Write-Host "Computer Name: $Computer"
    Write-Host "Operating System: $OS"
    Write-Output $ComputerHW
    Write-Output $ComputerCPU
    Write-Output $ComputerRam_Total
    Write-Output $ComputerRAM
    Write-Output $ComputerDisks
}
else {

    Write-Host -ForegroundColor Red @"
Computer is not reachable or does not exists.
"@
}

craigduff · 2019-03-08T22:37:25.000Z

What output are you seeing vs wanting to see? Because, that script just outputs text to the console and doesn’t create a CSV at all.

Are you trying to copy and paste that into Excel or another spreadsheet program?

Keep in mind a CSV file has only one type of item and fields at the top to match, but you are outputting multiple types of data?

You might be better off generating an html file for each computer using convertto-html -fragment if you are trying to create a formatted report rather than a csv abused for that purpose to be viewable in excel.