Get Closer; Day309

Jam 4:8  Draw nigh to God, and he will draw nigh to you. Cleanse your hands, ye sinners; and purify your hearts, ye double minded.

MIT (Most Important Task)
1. Continue Reading-Log Parser Toolkit
2.
3.

0000, Sleep
0100, Sleep
0200, Sleep
0300, Sleep
0400, Breakfast; journal; 3Mile Time Trial
0500, Leave for work
0600, TPM Meeting
0700, At work
0800, At work
0900, At work
1000, At work
1100, At work
1200, At work
1300, At work
1400, At work
1500, At work
1600, At work
1700, At work
1800,
1900,
2000, Dinner; Read-Log Parser p40-60 +Demo
2100, Read-Log Parser p40-60
2200, Read-Log Parser p40-60
2300, Sleep
2400, Sleep

LOOKING BACK – YESTERDAY
What went well?
1. Log Parser Toolkit p30-40

select top 500 substr(text,0,22) as Date, substr(text,23,9) as Source, substr(text,32) as Message from '\\server\C$\instance\log\ERRORLOG.*' where Message not like '%Log backed up%' and Message not like '%DBCC TRACEON%' 
and Message not like '%Login failed%' and Message not like '%Database backed up%'  and Message not like '%Database log truncated%' 
and Message not like '%DBCC CHECKDB%' 

logparser.exe. "select top 500 STRCAT(STRCAT(DATE,' '), TIME) as Date, Source, Message from '\\server\C$\instance\log\ERRORLOG.*' where Message not like '%Log backed up%' and Message not like '%DBCC TRACEON%' 
and Message not like '%Login failed%' and Message not like '%Database backed up%'  and Message not like '%Database log truncated%' 
and Message not like '%DBCC CHECKDB%' " -i:TSV -iseparator::spaces -iHeaderFile:c:\formatfile.txt -nskiplines:9