Re you looking for something like:
EXEC sys.sp_readerrorlog @p1 = 0, @p2 = 1, @p3 = N'max server memory (MB)';
?
Where @p1 = 0
is the current log, I just read this myself from here (https://dba.stackexchange.com/questions/89815/when-was-a-database-taken-offline), from what i understand you can not search all available logs. you have to step through them...