I like what you have going on here.  But a bit over the top IMHO.

Why PowerShell?  Since anything can execute the xp_readerrorlog from a remote box then why not much...

What if your period are 5-4-4?

Thanks guys.

All good remarks.

Just getting to the fact that you cannot do this from the simpler server level is what I was thinking as far as I need to carry...

That it is only possible at the db level is exactly not what I wanted to hear - but expected as the answer.

George. Thanks for the reply but it doesn't really give me much to go on. What I'm seeking would be some difference at the SERVER level.

What...

That's fine for the SQL Engine but what do you do about all the SQL Agent Task jobs and Maintenance Plans that are still pointing to the old name...

Bingo!

Client_Interface_Name from sys.dm_exec_sessions

Here is a sample from the column:

.Net SqlClient Data Provider

OLEDB

ODBC

NULL

ODBC

.Net SqlClient Data Provider

.Net SqlClient Data Provider

Thanks.