asked
Powershell results not showing different Server names
Hi there, I'm not a developer, but I'm trying to get into Powershell to scan logs from a list of servers (event and SQL error logs) and insert them into an SQL Server table. The command is similar to one on
www.simple-talk.com is as follows: Get-EventLog -ComputerName (Get-Content 'c:\temp\Servers.txt') -LogName Application ` -EntryType 'Error','Warning','Information' -Source '*MOVE*','*sql*' -After ((Get-Date).adddays(-1)) How do I display the server names in the results? would like to insert these results into an SQL table, but that's another issue. Thanks
You will need to pipe the command to `Select-Object` and one of the properties will be "MachineName". This should be the value of the server, but obviously in cluster scenario it would likely be the node name so you could see data from both servers. If you want to include the server name as it was passed in from your file, you would need to change your code around a little. $serverList = Get-Content 'C:\temp\Servers.txt' foreach ($s in $serverList) { Get-EventLog -ComputerName $s -LogName.... | select @{Label="ServerName";Expression={$s}}, MachineName, EventID.... }
17 People are following this question.
