SQLServerCentral.com / Programming / Powershell / collecting a count of errorlogs using posh / Latest PostsInstantForum.NET v99.99.99SQLServerCentral.comhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 09 Dec 2016 09:06:34 GMT20RE: collecting a count of errorlogs using poshhttp://www.sqlservercentral.com/Forums/Topic1421657-1351-1.aspxI think I may have answered my own question.It appears that the ReadErrorLog function is returning it's own error, rather than a collection of errors from the server log, which is where my confusion lay. As it is a single error, there is no collection / count for it. This happens when it connects okay to the server to return an smo object, but the function call returns an authentication error.Tue, 19 Feb 2013 08:25:05 GMTSimon D Richardscollecting a count of errorlogs using poshhttp://www.sqlservercentral.com/Forums/Topic1421657-1351-1.aspxHi, I am running a script to collect a count of all errors in the current error log using smo, as below:$sqlServer = new-object ("Microsoft.SqlServer.Management.Smo.Server") "MYSERVER"$logs = $sqlServer.ReadErrorLog() | where {($_.Text -like "Error*" -or $_.Text -like "*Fail*") -and ($_.Text -notlike "*Found 0 Errors*")};$count = $logs.Count$countand then dumping this into a monitor database.This works fine for most servers, but I have a 2005 cluster that for some reason won't return the count. If I just read the error log into console that works fine, but the .Count method disappears completely from the object. It is like, for this server, the object returned from $sqlServer.ReadErrorLog() is different to the rest of the servers.Any ideas?Thanks for reading.Tue, 19 Feb 2013 07:57:40 GMTSimon D Richards