{"id":517,"date":"2014-04-17T07:33:55","date_gmt":"2014-04-17T07:33:55","guid":{"rendered":"http:\/\/giraffeit.com\/?p=517"},"modified":"2014-04-17T07:33:55","modified_gmt":"2014-04-17T07:33:55","slug":"psfind","status":"publish","type":"post","link":"https:\/\/giraffeit.com\/index.php\/2014\/04\/17\/psfind\/","title":{"rendered":"Powershell find details about server \/ workstations"},"content":{"rendered":"

We have been scoring the net in the quest for a powershell script so we can audit easily server specs , or workstation , both , or just a series of machines on a xls spreadsheet.<\/p>\n

 <\/p>\n

Here is the code. We arent claiming the glory for it ( Jesse Hamrick handy work quoted )<\/p>\n

 <\/p>\n

# ==============================================================================================
\n#
\n# Microsoft PowerShell Source File — Created with SAPIEN Technologies PrimalScript 2007
\n#
\n# NAME: Server\/Workstation Inventory (CompInv_v2.ps1)
\n#
\n# AUTHOR: Jesse Hamrick
\n# DATE : 2\/25\/2009
\n# Web : www.PowerShellPro.com
\n# COMMENT: Script Inventories Computers and sends results to an excel file.
\n#
\n# ==============================================================================================<\/p>\n

# ==============================================================================================
\n# Functions Section
\n# ==============================================================================================
\n# Function Name ‘WMILookup’ – Gathers info using WMI and places results in Excel
\n# ==============================================================================================
\nFunction WMILookup {
\nforeach ($StrComputer in $colComputers){
\n$GenItems1 = gwmi Win32_ComputerSystem -Comp $StrComputer
\n$GenItems2 = gwmi Win32_OperatingSystem -Comp $StrComputer
\n$SysItems1 = gwmi Win32_BIOS -Comp $StrComputer
\n$SysItems2 = gwmi Win32_TimeZone -Comp $StrComputer
\n$SysItems3 = gwmi Win32_WmiSetting -Comp $StrComputer
\n$ProcItems1 = gwmi Win32_Processor -Comp $StrComputer
\n$MemItems1 = gwmi Win32_PhysicalMemory -Comp $StrComputer
\n$memItems2 = gwmi Win32_PhysicalMemoryArray -Comp $StrComputer
\n$DiskItems = gwmi Win32_LogicalDisk -Comp $StrComputer
\n$NetItems = gwmi Win32_NetworkAdapterConfiguration -Comp $StrComputer |`
\nwhere{$_.IPEnabled -eq “True”}<\/p>\n

# Populate General Sheet(1) with information
\nforeach ($objItem in $GenItems1){
\n$Sheet1.Cells.Item($intRow, 1) = $StrComputer
\nSwitch($objItem.DomainRole)
\n{
\n0{$Sheet1.Cells.Item($intRow, 2) = “Stand Alone Workstation”}
\n1{$Sheet1.Cells.Item($intRow, 2) = “Member Workstation”}
\n2{$Sheet1.Cells.Item($intRow, 2) = “Stand Alone Server”}
\n3{$Sheet1.Cells.Item($intRow, 2) = “Member Server”}
\n4{$Sheet1.Cells.Item($intRow, 2) = “Back-up Domain Controller”}
\n5{$Sheet1.Cells.Item($intRow, 2) = “Primary Domain Controller”}
\ndefault{“Undetermined”}
\n}
\n$Sheet1.Cells.Item($intRow, 3) = $objItem.Manufacturer
\n$Sheet1.Cells.Item($intRow, 4) = $objItem.Model
\n$Sheet1.Cells.Item($intRow, 5) = $objItem.SystemType
\n$Sheet1.Cells.Item($intRow, 6) = $objItem.NumberOfProcessors
\n$Sheet1.Cells.Item($intRow, 7) = $objItem.TotalPhysicalMemory \/ 1024 \/ 1024
\n}
\nforeach ($objItem in $GenItems2){
\n$Sheet1.Cells.Item($intRow, 8) = $objItem.Caption
\n$Sheet1.Cells.Item($intRow, 9) = $objItem.csdversion
\n}<\/p>\n

#Populate Systems Sheet
\nforeach ($objItem in $SysItems1){
\n$Sheet2.Cells.Item($intRow, 1) = $StrComputer
\n$Sheet2.Cells.Item($intRow, 2) = $objItem.Name
\n$Sheet2.Cells.Item($intRow, 3) = $objItem.SMBIOSbiosVersion
\n$Sheet2.Cells.Item($intRow, 4) = $objItem.SerialNumber
\n}
\nforeach ($objItem in $SysItems2){
\n$Sheet2.Cells.Item($intRow, 5) = $objItem.Caption
\n}
\nforeach ($objItem in $SysItems3){
\n$Sheet2.Cells.Item($intRow, 6) = $objItem.BuildVersion
\n}<\/p>\n

#Populate Processor Sheet
\nforeach ($objItem in $ProcItems1){
\n$Sheet3.Cells.Item($intRowCPU, 1) = $StrComputer
\n$Sheet3.Cells.Item($intRowCPU, 2) = $objItem.DeviceID+” “+$objItem.Name
\n$Sheet3.Cells.Item($intRowCPU, 3) = $objItem.Description
\n$Sheet3.Cells.Item($intRowCPU, 4) = $objItem.family
\n$Sheet3.Cells.Item($intRowCPU, 5) = $objItem.currentClockSpeed
\n$Sheet3.Cells.Item($intRowCPU, 6) = $objItem.l2cacheSize
\n$Sheet3.Cells.Item($intRowCPU, 7) = $objItem.UpgradeMethod
\n$Sheet3.Cells.Item($intRowCPU, 8) = $objItem.SocketDesignation
\n$intRowCPU = $intRowCPU + 1
\n}<\/p>\n

#Populate Memory Sheet
\n$bankcounter = 1
\nforeach ($objItem in $memItems2){
\n$MemSlots = $objItem.MemoryDevices +1<\/p>\n

foreach ($objItem in $MemItems1){
\n$Sheet4.Cells.Item($intRowMem, 1) = $StrComputer
\n$Sheet4.Cells.Item($intRowMem, 2) = “Bank ” +$bankcounter
\nif($objItem.BankLabel -eq “”){
\n$Sheet4.Cells.Item($intRowMem, 3) = $objItem.DeviceLocator}
\nElse{$Sheet4.Cells.Item($intRowMem, 3) = $objItem.BankLabel}
\n$Sheet4.Cells.Item($intRowMem, 4) = $objItem.Capacity\/1024\/1024
\n$Sheet4.Cells.Item($intRowMem, 5) = $objItem.FormFactor
\n$Sheet4.Cells.Item($intRowMem, 6) = $objItem.TypeDetail
\n$intRowMem = $intRowMem + 1
\n$bankcounter = $bankcounter + 1
\n}
\nwhile($bankcounter -lt $MemSlots)
\n{
\n$Sheet4.Cells.Item($intRowMem, 1) = $StrComputer
\n$Sheet4.Cells.Item($intRowMem, 2) = “Bank ” +$bankcounter
\n$Sheet4.Cells.Item($intRowMem, 3) = “is Empty”
\n$Sheet4.Cells.Item($intRowMem, 4) = “”
\n$Sheet4.Cells.Item($intRowMem, 5) = “”
\n$Sheet4.Cells.Item($intRowMem, 6) = “”
\n$intRowMem = $intRowMem + 1
\n$bankcounter = $bankcounter + 1
\n}
\n}<\/p>\n

#Populate Disk Sheet
\nforeach ($objItem in $DiskItems){
\n$Sheet5.Cells.Item($intRowDisk, 1) = $StrComputer
\nSwitch($objItem.DriveType)
\n{
\n2{$Sheet5.Cells.Item($intRowDisk, 2) = “Floppy”}
\n3{$Sheet5.Cells.Item($intRowDisk, 2) = “Fixed Disk”}
\n5{$Sheet5.Cells.Item($intRowDisk, 2) = “Removable Media”}
\ndefault{“Undetermined”}
\n}
\n$Sheet5.Cells.Item($intRowDisk, 3) = $objItem.DeviceID
\n$Sheet5.Cells.Item($intRowDisk, 4) = $objItem.Size\/1024\/1024
\n$Sheet5.Cells.Item($intRowDisk, 5) = $objItem.FreeSpace\/1024\/1024
\n$intRowDisk = $intRowDisk + 1
\n}<\/p>\n

#Populate Network Sheet
\nforeach ($objItem in $NetItems){
\n$Sheet6.Cells.Item($intRowNet, 1) = $StrComputer
\n$Sheet6.Cells.Item($intRowNet, 2) = $objItem.Caption+” (enabled)”
\n$Sheet6.Cells.Item($intRowNet, 3) = $objItem.DHCPEnabled
\n$Sheet6.Cells.Item($intRowNet, 4) = $objItem.IPAddress
\n$Sheet6.Cells.Item($intRowNet, 5) = $objItem.IPSubnet
\n$Sheet6.Cells.Item($intRowNet, 6) = $objItem.DefaultIPGateway
\n$Sheet6.Cells.Item($intRowNet, 7) = $objItem.DNSServerSearchOrder
\n$Sheet6.Cells.Item($intRowNet, 8) = $objItem.FullDNSRegistrationEnabled
\n$Sheet6.Cells.Item($intRowNet, 9) = $objItem.WINSPrimaryServer
\n$Sheet6.Cells.Item($intRowNet, 10) = $objItem.WINSSecondaryServer
\n$Sheet6.Cells.Item($intRowNet, 11) = $objItem.WINSEnableLMHostsLookup
\n$intRowNet = $intRowNet + 1
\n}<\/p>\n

$intRow = $intRow + 1
\n$intRowCPU = $intRowCPU + 1
\n$intRowMem = $intRowMem + 1
\n$intRowDisk = $intRowDisk + 1
\n$intRowNet = $intRowNet + 1
\n}
\n}<\/p>\n

# ==============================================================================================
\n# Function Name ‘WMILookupCred’-Uses Alternative Credential-Gathers info using WMI.
\n# ==============================================================================================
\nFunction WMILookupCred {
\nforeach ($StrComputer in $colComputers){
\n$GenItems1 = gwmi Win32_ComputerSystem -Comp $StrComputer -Credential $cred
\n$GenItems2 = gwmi Win32_OperatingSystem -Comp $StrComputer -Credential $cred
\n$SysItems1 = gwmi Win32_BIOS -Comp $StrComputer -Credential $cred
\n$SysItems2 = gwmi Win32_TimeZone -Comp $StrComputer -Credential $cred
\n$SysItems3 = gwmi Win32_WmiSetting -Comp $StrComputer -Credential $cred
\n$ProcItems1 = gwmi Win32_Processor -Comp $StrComputer -Credential $cred
\n$MemItems1 = gwmi Win32_PhysicalMemory -Comp $StrComputer -Credential $cred
\n$memItems2 = gwmi Win32_PhysicalMemoryArray -Comp $StrComputer -Credential $cred
\n$DiskItems = gwmi Win32_LogicalDisk -Comp $StrComputer -Credential $cred
\n$NetItems = gwmi Win32_NetworkAdapterConfiguration -Comp $StrComputer -Credential $cred |`
\nwhere{$_.IPEnabled -eq “True”}<\/p>\n

# Populate General Sheet(1) with information
\nforeach ($objItem in $GenItems1){
\n$Sheet1.Cells.Item($intRow, 1) = $StrComputer
\nSwitch($objItem.DomainRole)
\n{
\n0{$Sheet1.Cells.Item($intRow, 2) = “Stand Alone Workstation”}
\n1{$Sheet1.Cells.Item($intRow, 2) = “Member Workstation”}
\n2{$Sheet1.Cells.Item($intRow, 2) = “Stand Alone Server”}
\n3{$Sheet1.Cells.Item($intRow, 2) = “Member Server”}
\n4{$Sheet1.Cells.Item($intRow, 2) = “Back-up Domain Controller”}
\n5{$Sheet1.Cells.Item($intRow, 2) = “Primary Domain Controller”}
\ndefault{“Undetermined”}
\n}
\n$Sheet1.Cells.Item($intRow, 3) = $objItem.Manufacturer
\n$Sheet1.Cells.Item($intRow, 4) = $objItem.Model
\n$Sheet1.Cells.Item($intRow, 5) = $objItem.SystemType
\n$Sheet1.Cells.Item($intRow, 6) = $objItem.NumberOfProcessors
\n$Sheet1.Cells.Item($intRow, 7) = $objItem.TotalPhysicalMemory \/ 1024 \/ 1024
\n}
\nforeach ($objItem in $GenItems2){
\n$Sheet1.Cells.Item($intRow, 8) = $objItem.Caption
\n$Sheet1.Cells.Item($intRow, 9) = $objItem.csdversion
\n}<\/p>\n

#Populate Systems Sheet
\nforeach ($objItem in $SysItems1){
\n$Sheet2.Cells.Item($intRow, 1) = $StrComputer
\n$Sheet2.Cells.Item($intRow, 2) = $objItem.Name
\n$Sheet2.Cells.Item($intRow, 3) = $objItem.SMBIOSbiosVersion
\n$Sheet2.Cells.Item($intRow, 4) = $objItem.SerialNumber
\n}
\nforeach ($objItem in $SysItems2){
\n$Sheet2.Cells.Item($intRow, 5) = $objItem.Caption
\n}
\nforeach ($objItem in $SysItems3){
\n$Sheet2.Cells.Item($intRow, 6) = $objItem.BuildVersion
\n}<\/p>\n

#Populate Processor Sheet
\nforeach ($objItem in $ProcItems1){
\n$Sheet3.Cells.Item($intRowCPU, 1) = $StrComputer
\n$Sheet3.Cells.Item($intRowCPU, 2) = $objItem.DeviceID+” “+$objItem.Name
\n$Sheet3.Cells.Item($intRowCPU, 3) = $objItem.Description
\n$Sheet3.Cells.Item($intRowCPU, 4) = $objItem.family
\n$Sheet3.Cells.Item($intRowCPU, 5) = $objItem.currentClockSpeed
\n$Sheet3.Cells.Item($intRowCPU, 6) = $objItem.l2cacheSize
\n$Sheet3.Cells.Item($intRowCPU, 7) = $objItem.UpgradeMethod
\n$Sheet3.Cells.Item($intRowCPU, 8) = $objItem.SocketDesignation
\n$intRowCPU = $intRowCPU + 1
\n}<\/p>\n

#Populate Memory Sheet
\n$bankcounter = 1
\nforeach ($objItem in $memItems2){
\n$MemSlots = $objItem.MemoryDevices +1<\/p>\n

foreach ($objItem in $MemItems1){
\n$Sheet4.Cells.Item($intRowMem, 1) = $StrComputer
\n$Sheet4.Cells.Item($intRowMem, 2) = “Bank ” +$bankcounter
\nif($objItem.BankLabel -eq “”){
\n$Sheet4.Cells.Item($intRowMem, 3) = $objItem.DeviceLocator}
\nElse{$Sheet4.Cells.Item($intRowMem, 3) = $objItem.BankLabel}
\n$Sheet4.Cells.Item($intRowMem, 4) = $objItem.Capacity\/1024\/1024
\n$Sheet4.Cells.Item($intRowMem, 5) = $objItem.FormFactor
\n$Sheet4.Cells.Item($intRowMem, 6) = $objItem.TypeDetail
\n$intRowMem = $intRowMem + 1
\n$bankcounter = $bankcounter + 1
\n}
\nwhile($bankcounter -lt $MemSlots)
\n{
\n$Sheet4.Cells.Item($intRowMem, 1) = $StrComputer
\n$Sheet4.Cells.Item($intRowMem, 2) = “Bank ” +$bankcounter
\n$Sheet4.Cells.Item($intRowMem, 3) = “is Empty”
\n$Sheet4.Cells.Item($intRowMem, 4) = “”
\n$Sheet4.Cells.Item($intRowMem, 5) = “”
\n$Sheet4.Cells.Item($intRowMem, 6) = “”
\n$intRowMem = $intRowMem + 1
\n$bankcounter = $bankcounter + 1
\n}
\n}<\/p>\n

#Populate Disk Sheet
\nforeach ($objItem in $DiskItems){
\n$Sheet5.Cells.Item($intRowDisk, 1) = $StrComputer
\nSwitch($objItem.DriveType)
\n{
\n2{$Sheet5.Cells.Item($intRowDisk, 2) = “Floppy”}
\n3{$Sheet5.Cells.Item($intRowDisk, 2) = “Fixed Disk”}
\n5{$Sheet5.Cells.Item($intRowDisk, 2) = “Removable Media”}
\ndefault{“Undetermined”}
\n}
\n$Sheet5.Cells.Item($intRowDisk, 3) = $objItem.DeviceID
\n$Sheet5.Cells.Item($intRowDisk, 4) = $objItem.Size\/1024\/1024
\n$Sheet5.Cells.Item($intRowDisk, 5) = $objItem.FreeSpace\/1024\/1024
\n$intRowDisk = $intRowDisk + 1
\n}<\/p>\n

#Populate Network Sheet
\nforeach ($objItem in $NetItems){
\n$Sheet6.Cells.Item($intRowNet, 1) = $StrComputer
\n$Sheet6.Cells.Item($intRowNet, 2) = $objItem.Caption+” (enabled)”
\n$Sheet6.Cells.Item($intRowNet, 3) = $objItem.DHCPEnabled
\n$Sheet6.Cells.Item($intRowNet, 4) = $objItem.IPAddress
\n$Sheet6.Cells.Item($intRowNet, 5) = $objItem.IPSubnet
\n$Sheet6.Cells.Item($intRowNet, 6) = $objItem.DefaultIPGateway
\n$Sheet6.Cells.Item($intRowNet, 7) = $objItem.DNSServerSearchOrder
\n$Sheet6.Cells.Item($intRowNet, 8) = $objItem.FullDNSRegistrationEnabled
\n$Sheet6.Cells.Item($intRowNet, 9) = $objItem.WINSPrimaryServer
\n$Sheet6.Cells.Item($intRowNet, 10) = $objItem.WINSSecondaryServer
\n$Sheet6.Cells.Item($intRowNet, 11) = $objItem.WINSEnableLMHostsLookup
\n$intRowNet = $intRowNet + 1
\n}<\/p>\n

$intRow = $intRow + 1
\n$intRowCPU = $intRowCPU + 1
\n$intRowMem = $intRowMem + 1
\n$intRowDisk = $intRowDisk + 1
\n$intRowNet = $intRowNet + 1
\n}
\n}<\/p>\n

# =============================================================================================
\n# Function Name ‘ListComputers’ – Enumerates ALL computer objects in AD
\n# ==============================================================================================
\nFunction ListComputers {
\n$strCategory = “computer”<\/p>\n

$objDomain = New-Object System.DirectoryServices.DirectoryEntry<\/p>\n

$objSearcher = New-Object System.DirectoryServices.DirectorySearcher
\n$objSearcher.SearchRoot = $objDomain
\n$objSearcher.Filter = (“(objectCategory=$strCategory)”)<\/p>\n

$colProplist = “name”
\nforeach ($i in $colPropList){$objSearcher.PropertiesToLoad.Add($i)}<\/p>\n

$colResults = $objSearcher.FindAll()<\/p>\n

foreach ($objResult in $colResults)
\n{$objComputer = $objResult.Properties; $objComputer.name}
\n}<\/p>\n

# ==============================================================================================
\n# Function Name ‘ListServers’ – Enumerates ALL Servers objects in AD
\n# ==============================================================================================
\nFunction ListServers {
\n$strCategory = “computer”
\n$strOS = “Windows*Server*”<\/p>\n

$objDomain = New-Object System.DirectoryServices.DirectoryEntry<\/p>\n

$objSearcher = New-Object System.DirectoryServices.DirectorySearcher
\n$objSearcher.SearchRoot = $objDomain
\n$objSearcher.Filter = (“(&(objectCategory=$strCategory)(OperatingSystem=$strOS))”)<\/p>\n

$colProplist = “name”
\nforeach ($i in $colPropList){$objSearcher.PropertiesToLoad.Add($i)}<\/p>\n

$colResults = $objSearcher.FindAll()<\/p>\n

foreach ($objResult in $colResults)
\n{$objComputer = $objResult.Properties; $objComputer.name}
\n}<\/p>\n

# ========================================================================
\n# Function Name ‘ListTextFile’ – Enumerates Computer Names in a text file
\n# Create a text file and enter the names of each computer. One computer
\n# name per line. Supply the path to the text file when prompted.
\n# ========================================================================
\nFunction ListTextFile {
\n$strText = Read-Host “Enter the path for the text file”
\n$colComputers = Get-Content $strText
\n}<\/p>\n

# ========================================================================
\n# Function Name ‘SingleEntry’ – Enumerates Computer from user input
\n# ========================================================================
\nFunction ManualEntry {
\n$colComputers = Read-Host “Enter Computer Name or IP”
\n}<\/p>\n

# ==============================================================================================
\n# Script Body
\n# ==============================================================================================
\n$erroractionpreference = “SilentlyContinue”
\n#Gather info from user.
\nWrite-Host “********************************” -ForegroundColor Green
\nWrite-Host “Computer Inventory Script” -ForegroundColor Green
\nWrite-Host “By: Jesse Hamrick” -ForegroundColor Green
\nWrite-Host “Created: 04\/15\/2009” -ForegroundColor Green
\nWrite-Host “Contact: www.PowerShellPro.com” -ForegroundColor Green
\nWrite-Host “********************************” -ForegroundColor Green
\nWrite-Host ” ”
\nWrite-Host “Admin rights are required to enumerate information.” -ForegroundColor Green
\nWrite-Host “Would you like to use an alternative credential?” -ForegroundColor Green
\n$credResponse = Read-Host “[Y] Yes, [N] No”
\nIf($CredResponse -eq “y”){$cred = Get-Credential DOMAINUSER}
\nWrite-Host ” ”
\nWrite-Host “Which computer resources would you like in the report?” -ForegroundColor Green
\n$strResponse = Read-Host “[1] All Domain Computers, [2] All Domain Servers, [3] Computer names from a File, [4] Choose a Computer manually”
\nIf($strResponse -eq “1”){$colComputers = ListComputers | Sort-Object}
\nelseif($strResponse -eq “2”){$colComputers = ListServers | Sort-Object}
\nelseif($strResponse -eq “3”){. ListTextFile}
\nelseif($strResponse -eq “4”){. ManualEntry}
\nelse{Write-Host “You did not supply a correct response, `
\nPlease run script again.” -foregroundColor Red}
\nWrite-Progress -Activity “Getting Inventory” -status “Running…” -id 1<\/p>\n

#New Excel Application
\n$Excel = New-Object -Com Excel.Application
\n$Excel.visible = $True<\/p>\n

# Create 6 worksheets
\n$Excel = $Excel.Workbooks.Add()
\n$Sheet = $Excel.Worksheets.Add()
\n$Sheet = $Excel.Worksheets.Add()
\n$Sheet = $Excel.Worksheets.Add()<\/p>\n

# Assign each worksheet to a variable and
\n# name the worksheet.
\n$Sheet1 = $Excel.Worksheets.Item(1)
\n$Sheet2 = $Excel.WorkSheets.Item(2)
\n$Sheet3 = $Excel.WorkSheets.Item(3)
\n$Sheet4 = $Excel.WorkSheets.Item(4)
\n$Sheet5 = $Excel.WorkSheets.Item(5)
\n$Sheet6 = $Excel.WorkSheets.Item(6)
\n$Sheet1.Name = “General”
\n$Sheet2.Name = “System”
\n$Sheet3.Name = “Processor”
\n$Sheet4.Name = “Memory”
\n$Sheet5.Name = “Disk”
\n$Sheet6.Name = “Network”<\/p>\n

#Create Heading for General Sheet
\n$Sheet1.Cells.Item(1,1) = “Device_Name”
\n$Sheet1.Cells.Item(1,2) = “Role”
\n$Sheet1.Cells.Item(1,3) = “HW_Make”
\n$Sheet1.Cells.Item(1,4) = “HW_Model”
\n$Sheet1.Cells.Item(1,5) = “HW_Type”
\n$Sheet1.Cells.Item(1,6) = “CPU_Count”
\n$Sheet1.Cells.Item(1,7) = “Memory_MB”
\n$Sheet1.Cells.Item(1,8) = “Operating_System”
\n$Sheet1.Cells.Item(1,9) = “SP_Level”<\/p>\n

#Create Heading for System Sheet
\n$Sheet2.Cells.Item(1,1) = “Device_Name”
\n$Sheet2.Cells.Item(1,2) = “BIOS_Name”
\n$Sheet2.Cells.Item(1,3) = “BIOS_Version”
\n$Sheet2.Cells.Item(1,4) = “HW_Serial_#”
\n$Sheet2.Cells.Item(1,5) = “Time_Zone”
\n$Sheet2.Cells.Item(1,6) = “WMI_Version”<\/p>\n

#Create Heading for Processor Sheet
\n$Sheet3.Cells.Item(1,1) = “Device_Name”
\n$Sheet3.Cells.Item(1,2) = “Processor(s)”
\n$Sheet3.Cells.Item(1,3) = “Type”
\n$Sheet3.Cells.Item(1,4) = “Family”
\n$Sheet3.Cells.Item(1,5) = “Speed_MHz”
\n$Sheet3.Cells.Item(1,6) = “Cache_Size_MB”
\n$Sheet3.Cells.Item(1,7) = “Interface”
\n$Sheet3.Cells.Item(1,8) = “#_of_Sockets”<\/p>\n

#Create Heading for Memory Sheet
\n$Sheet4.Cells.Item(1,1) = “Device_Name”
\n$Sheet4.Cells.Item(1,2) = “Bank_#”
\n$Sheet4.Cells.Item(1,3) = “Label”
\n$Sheet4.Cells.Item(1,4) = “Capacity_MB”
\n$Sheet4.Cells.Item(1,5) = “Form”
\n$Sheet4.Cells.Item(1,6) = “Type”<\/p>\n

#Create Heading for Disk Sheet
\n$Sheet5.Cells.Item(1,1) = “Device_Name”
\n$Sheet5.Cells.Item(1,2) = “Disk_Type”
\n$Sheet5.Cells.Item(1,3) = “Drive_Letter”
\n$Sheet5.Cells.Item(1,4) = “Capacity_MB”
\n$Sheet5.Cells.Item(1,5) = “Free_Space_MB”<\/p>\n

#Create Heading for Network Sheet
\n$Sheet6.Cells.Item(1,1) = “Device_Name”
\n$Sheet6.Cells.Item(1,2) = “Network_Card”
\n$Sheet6.Cells.Item(1,3) = “DHCP_Enabled”
\n$Sheet6.Cells.Item(1,4) = “IP_Address”
\n$Sheet6.Cells.Item(1,5) = “Subnet_Mask”
\n$Sheet6.Cells.Item(1,6) = “Default_Gateway”
\n$Sheet6.Cells.Item(1,7) = “DNS_Servers”
\n$Sheet6.Cells.Item(1,8) = “DNS_Reg”
\n$Sheet6.Cells.Item(1,9) = “Primary_WINS”
\n$Sheet6.Cells.Item(1,10) = “Secondary_WINS”
\n$Sheet6.Cells.Item(1,11) = “WINS_Lookup”<\/p>\n

$colSheets = ($Sheet1, $Sheet2, $Sheet3, $Sheet4, $Sheet5, $Sheet6)
\nforeach ($colorItem in $colSheets){
\n$intRow = 2
\n$intRowCPU = 2
\n$intRowMem = 2
\n$intRowDisk = 2
\n$intRowNet = 2
\n$WorkBook = $colorItem.UsedRange
\n$WorkBook.Interior.ColorIndex = 20
\n$WorkBook.Font.ColorIndex = 11
\n$WorkBook.Font.Bold = $True
\n}<\/p>\n

If($credResponse -eq “y”){WMILookupCred}
\nElse{WMILookup}<\/p>\n

#Auto Fit all sheets in the Workbook
\nforeach ($colorItem in $colSheets){
\n$WorkBook = $colorItem.UsedRange
\n$WorkBook.EntireColumn.AutoFit()
\nclear
\n}
\nWrite-Host “*******************************” -ForegroundColor Green
\nWrite-Host “The Report has been completed.” -ForeGroundColor Green
\nWrite-Host “*******************************” -ForegroundColor Green
\n# ========================================================================
\n# END of Script
\n# ========================================================================<\/p>\n","protected":false},"excerpt":{"rendered":"

We have been scoring the net in the quest for a powershell script so we can audit easily server specs , or workstation , both , or just a series of machines on a xls spreadsheet.   Here is the code. We arent claiming the glory for it ( Jesse Hamrick handy work quoted ) … <\/p>\n

Continue reading “Powershell find details about server \/ workstations”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"class_list":["post-517","post","type-post","status-publish","format-standard","hentry","category-bog"],"_links":{"self":[{"href":"https:\/\/giraffeit.com\/index.php\/wp-json\/wp\/v2\/posts\/517","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/giraffeit.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/giraffeit.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/giraffeit.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/giraffeit.com\/index.php\/wp-json\/wp\/v2\/comments?post=517"}],"version-history":[{"count":0,"href":"https:\/\/giraffeit.com\/index.php\/wp-json\/wp\/v2\/posts\/517\/revisions"}],"wp:attachment":[{"href":"https:\/\/giraffeit.com\/index.php\/wp-json\/wp\/v2\/media?parent=517"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/giraffeit.com\/index.php\/wp-json\/wp\/v2\/categories?post=517"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/giraffeit.com\/index.php\/wp-json\/wp\/v2\/tags?post=517"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}