Hello
First off sorry for question about powershell, I have small issue , where I script to gather inventory but i am finding difficult to output to the CSV for IP address and other network details, if you can see below script $row shows full information but when i export to the it shows only one IP address where as server has multiple Ip address for multiple adaper
Kindly respond if you have any solution for this
$Hardware =@()
ForEach-Object {
$i=$env:computername
$MB= Get-WmiObject Win32_BaseBoard | Select Name,Manufacturer,Product,SerialNumber,Status
$OS=get-WmiObject Win32_OperatingSystem | select-object CSName,OSArchitecture,@{Name="FreePhysicalMemory";Expression={ "{0:N0}" -f ($_.FreePhysicalMemory / 1MB)}},caption,@{Name="TotalVirtualMemorySize";Expression={ "{0:N0}" -f ($_.TotalVirtualMemorySize / 1MB)}},ServicePackMajorVersion
$BI =Get-WmiObject win32_bios | Select Manufacturer,Name,BIOSVersion,PrimaryBIOS,SMBIOSBIOSVersion,SMBIOSMajorVersion,SMBIOSMinorVersion
$SY= Get-WmiObject Win32_ComputerSystemProduct | Select Vendor,Version,Name,IdentifyingNumber,UUID
$HD= Get-WmiObject win32_diskDrive | select Model,SerialNumber,InterfaceType,@{Name="Size";Expression={ "{0:N0}" -f ($_.FileSize / 1MB)}},Partitions
$NIC=Get-WmiObject win32_networkadapter | Select Name,Manufacturer,Description ,AdapterType,Speed,MACAddress,NetConnectionID,IPaddress
$Mem=Get-WmiObject Win32_PhysicalMemory | select BankLabel,DeviceLocator,Capacity,Manufacturer,PartNumber,SerialNumber,Speed
$PROC=Get-WmiObject Win32_Processor | Select Caption,DeviceID,NumberOfCores,NumberOfLogicalProcessors
$CS=Get-WmiObject Win32_ComputerSystem | select-object Name,@{Name="TotalPhysicalMemory";Expression={ "{0:N0}" -f ($_.TotalPhysicalMemory / 1MB)}},SystemType,Domain,DNSHostName
$PF=Get-WmiObject -Class Win32_pagefileusage | select-object Caption,@{Name="AllocatedBaseSize";Expression={ "{0:N0}" -f ($_.AllocatedBaseSize / 1MB)}}
$NW=Get-WmiObject -class "Win32_NetworkAdapterConfiguration" | Where {$_.IPEnabled -Match "True"} | Select-object IPaddress,IPSubnet,DefaultIPgateway,DNSServerSearchOrder,Description,DNSDomainSuffixSearchOrder
$reg = [Microsoft.Win32.RegistryKey]::OpenRemoteBaseKey('LocalMachine', $i)
$regKey= $reg.OpenSubKey("SYSTEM\\CurrentControlSet\\Services\\Netlogon\\Parameters",$true)
$regvalue=$regkey.GetValue('DynamicSiteName')
$Report = "" | Select-Object ComputerName,OSName,ServicePack,TotalPhysicalMemory,TotalVirtualMemory,SystemType,Domain,DNSHostName,BIManufacturer,BISerialNumber,BIOSVersion,SMBIOSBIOSVersion,SVersion,ModuleName,MBSerialNumber,UUID,Descriptions,MACAddres,NWIPaddress,NWIPSubnet,NWDefaultIPgateway,NWDNSServerSearchorder,NWDescription,NWDNSDomainSuffixSearchorder,PCaption,PDeviceID,NumberOfCores,NumberOfLogicalProcessors,sitename
$Report.ComputerName = $OS.CSNAME
$Report.OSName= $OS.caption
$Report.ServicePack= $OS.ServicePackMajorVersion
$Report.TotalPhysicalMemory = $CS.TotalPhysicalMemory
$Report.TotalVirtualMemory =$OS.TotalVirtualMemorySize
$Report.SystemType =$CS.SystemType
$Report.Domain=$CS.Domain
$Report.DNSHostname=$CS.DNSHostName
$Report.BIManufacturer = $BI.Manufacturer
$Report.BISerialNumber= $BI.MSerialNumber
$Report.BIOSVersion= [string]::Join(',',$BI.BIOSVersion)
$Report.SMBIOSBIOSVersion= $BI.SMBIOSBIOSVersion
$Report.SVersion= $SY.Version
$Report.ModuleName= $SY.Name
$Report.MBSerialNumber= $SY.IdentifyingNumber
$Report.UUID= $SY.UUID
$Netinfo = @()
ForEach ($Adapter in (Get-WmiObject Win32_NetworkAdapter -Filter "NetEnabled='True'"))
{ $Config = Get-WmiObject Win32_NetworkAdapterConfiguration -Filter "Index = '$($Adapter.Index)'"
$row = New-Object System.Object
$row | Add-Member -MemberType NoteProperty -Name "Name" -Value $Adapter.Name
$row | Add-Member -MemberType NoteProperty -Name "IP" -Value $Config.IPAddress
$row | Add-Member -MemberType NoteProperty -Name "MAC" -Value $Config.MacAddress
$row | Add-Member -MemberType NoteProperty -Name "Subnet" -Value $Config.IPSubnet[0]
$row | Add-Member -MemberType NoteProperty -Name "DG" -Value $Config.DefaultIPGateway
$row | Add-Member -MemberType NoteProperty -Name "DNSS" -Value $Config.DNSServerSearchOrder
$row | Add-Member -MemberType NoteProperty -Name "DNSuf" -Value $Config.DNSDomainSuffixSearchorder
$row
$Report.MACAddres = [string]::Join(',',$row.MAC)
$Report.Descriptions =[string]::Join(',',$row.Name)
$Report.NWIPaddress =[string]::Join(',',$row.IP)
$Report.NWIPSubnet =[string]::Join(',',$row.Subnet)
$Report.NWDefaultIPgateway = [string]::Join(',',$row.DG)
$Report.NWDNSServerSearchorder = [string]::Join(',',$row.DNSS)
$Report.NWDNSDomainSuffixSearchorder= [string]::Join(',',$row.DNSuf)
}
$Report.PCaption= [string]::Join(',',$PROC.Caption)
$Report.PDeviceID= $PROC.DeviceID
$Report.NumberOfCores= [string]::Join(',',$PROC.NumberOfCores)
$Report.NumberOfLogicalProcessors= [string]::Join(',',$PROC.NumberOfLogicalProcessors)
$Report.Sitename =$regvalue
$Hardware += $Report
}
$Hardware | export-csv "c:\windows\temp\script\$i.csv" -NoTypeInformation
one of error message
Exception calling "Join" with "2" argument(s): "Value cannot be null.
Parameter name: value"
At line:48 char:36
+ $Report.NWIPaddress =[string]::Join <<<< (',',$row.IP)
+ CategoryInfo : NotSpecified: (:) [], MethodInvocationException
+ FullyQualifiedErrorId : DotNetMethodException
Message was edited by: dhanu2k7
