asked on

Inventory of servers/pcs

Hi There

I'm in the process of creating an Inventory using POwershell of our servers and have so far found various bits and pieces that i've been able to use from the web to get done what i need. I've now hit a sticking point.

I need 3 more types of information they are:
* The Physical Disk sizes and free space left on them on the server
* The Speed of the Processor(s)
* The version of a certain piece of software that is installed on them all

As you'll see from the code attached I'm also getting this info into a Excel Spreadsheet so we can save it for reference. As you'll see from the code lines 56 and 60 are for the Drives/processor info and i still need to the add the software data. Of course I'll no doubt re-arrange the layout of the columns once i have the information outputting correctly

Thank You

$a = New-Object -comobject Excel.Application
$a.visible = $True

$b = $a.Workbooks.Add()
$c = $b.Worksheets.Item(1)

$c.Cells.Item(1,1) = "Server Name"
$c.Cells.Item(1,2) = "Operating System"
$c.Cells.Item(1,3) = "IP Address"
$c.Cells.item(1,4) = "Subnet"
$c.Cells.item(1,5) = "Default Gateway"
$c.Cells.item(1,6) = "MAC Address"
$c.Cells.Item(1,7) = "Service Packs"
$c.Cells.Item(1,8) = "System Type"
$c.Cells.Item(1,9) = "Install Date"
$c.Cells.Item(1,10) = "Manufacturer"
$c.Cells.Item(1,11) = "Model"
$c.Cells.Item(1,12) = "Service Tag"
$c.Cells.Item(1,13) = "Drives"
$c.Cells.Item(1,14) = "Number of Processors"
$c.Cells.Item(1,15) = "Total Phsyical Memory (GB)"
$c.Cells.Item(1,16) = "Last Reboot Time"
$c.Cells.Item(1,17) = "Processor Speed"
$c.Cells.Item(1,18) = "Report Time Stamp"

$d = $c.UsedRange
$d.Interior.ColorIndex = 19
$d.Font.ColorIndex = 11
$d.Font.Bold = $True

$intRow = 2

$colComputers = get-content C:\ServerList.txt
foreach ($strComputer in $colComputers)
{
$OS = get-wmiobject Win32_OperatingSystem -computername $strComputer
$Computer = get-wmiobject Win32_computerSystem -computername $strComputer
$Bios =get-wmiobject Win32_bios -computername $strComputer
$NICCard=Get-WmiObject win32_networkadapterconfiguration -computername $strComputer
foreach($NIC in $NICCard){
if($NIC.ipenabled -eq $true)
{

$c.Cells.Item($intRow,1) = $strComputer.Toupper()
$c.Cells.Item($intRow,2) = $OS.Caption
$c.Cells.Item($intRow,3) = $NIC.IPaddress[0]
$c.Cells.Item($intRow,4) = $NIC.IPSubnet
$c.Cells.Item($intRow,5) = $NIC.DefaultIPGateway
$c.Cells.Item($intRow,6) = $NIC.MACAddress
$c.Cells.Item($intRow,7) = $OS.CSDVersion
$c.Cells.Item($intRow,8) = $Computer.SystemType
$c.Cells.Item($intRow,9) = [System.Management.ManagementDateTimeconverter]::ToDateTime($OS.InstallDate)
$c.Cells.Item($intRow,10) = $Computer.Manufacturer
$c.Cells.Item($intRow,11) = $Computer.Model
$c.Cells.Item($intRow,12) = $Bios.serialnumber
$c.Cells.Item($intRow,13) = 
$c.Cells.Item($intRow,14) = $Computer.NumberOfProcessors
$c.Cells.Item($intRow,15) = "{0:N0}" -f ($computer.TotalPhysicalMemory/1GB)
$c.Cells.Item($intRow,16) = [System.Management.ManagementDateTimeconverter]::ToDateTime($OS.LastBootUpTime)
$c.Cells.Item($introw,17) = 



$c.Cells.Item($intRow,18) = Get-date

$intRow = $intRow + 1
$d.EntireColumn.AutoFit()
}}}

Open in new window

myhc

Sorry i can't help with the code above but thought you might want to know of some software called spiceworks that does just this. It's free and has a lot more to it like licences, HDD history, Wannings, Print ink low warning. Easy to setup. I would recommend a look, even if it just gives you some more idea's.

www.spiceworks.com

One thing i would say is once installed, it's a lot quicker to navigate pages using anything but IE. (recommend: firefox)