Good afternoon everyone!

I was wondering if you could help me with this. Here is my code (Using Quest) that pulls computer names from a csv file and queries AD for DN, LASTLOGONTIMESTAMP and IP information.  (It works well)

$ip = @{name="IP";expression={[System.Net.Dns]::GetHostByName($_.name).AddressList[0].IPAddressToString}}
Import-Csv C:\scripts\AVlist.csv | Get-QADComputer -Identity {$_.Name} -IncludedProperties lastLogonTimeStamp | Select-Object DisplayName,DN,LastLogonTimeStamp,$ip | export-csv c:\scripts\kevin.csv –noType

Here is an entry that gets serial numbers (If computer is on) in powershell….

Get-WMIObject -Class "Win32_BIOS" -Computer WSNR11840 | select SerialNumber
 
How would you integrate that command into the script? I want to do something like:

$SN = Get-WMIObject -Class "Win32_BIOS" -Computer WSNR11840 | select SerialNumber

But I want to change that computer name to ($_.name) so I can pull it from that CSV file. Can I do that? I then would add $SN to my export just like $ip was done…exporting it to a csv file…

Kevin

Just like you did with $ip ;-)

$ip = @{name="IP";expression={[System.Net.Dns]::GetHostByName($_.name).AddressList[0].IPAddressToString}}
$sn= @{name="SerialNumber";expression={(Get-WMIObject -Class Win32_BIOS -Computer $_.name).SerialNumber}}

Import-Csv C:\scripts\AVlist.csv | Get-QADComputer -Identity {$_.Name} -IncludedProperties lastLogonTimeStamp | Select-Object DisplayName,DN,LastLogonTimeStamp,$ip,$sn | export-csv c:\scripts\kevin.csv –noType