Be Connected No Matter What; Day476

I am the Vine; you are the branches. Whoever lives in Me and I in him bears much (abundant) fruit. However, apart from Me [cut off from vital union with Me] you can do nothing. John 15:5

MIT (Most Important Task)
1. 40Mile Cycling
2. Pickup bike wheels from repair
3. Mail Tax Return

0700, Breakfast; journal;
0800,
0900, 40Mile Cycling
1000, 40Mile Cycling
1100, 40Mile Cycling
1200, Lunch
1300, Pickup bike wheels; Tax Return
1400, Nap
1500, Pickup Brent
1600, Brent Doctor’s appointment; Read: Log Parser Managing Log Files
1700, Cook for the kids
1800, Dinner
1900, Finalize Log Parser SQL Queries
2000, More SQL Queries
2100, Mawing-long conversation; undesirable effect of family separation. No solution in sight.
2200, Mawing-long conversation
2300, Mawing-long conversation
2400, Mawing-long conversation

ExecuteLPQuery.cmd
logparser.exe file:qeventlog.sql -i:evt -o:csv
logparser.exe file:qnovalog.sql -i:tsv -o:csv

qeventlog.slq
SELECT Top 2000 EventLog, TimeGenerated, ComputerName, EventID, EventTypeName, SourceName, Message
INTO qeventlog.csv
FROM
\\192.168.1.24\System, \\192.168.1.24\Application,
\\192.168.1.13\System, \\192.168.1.13\Application,
\\192.168.1.6\System, \\192.168.1.6\Application,
\\192.168.1.3\System, \\192.168.1.3\Application,
\\192.168.1.28\System, \\192.168.1.28\Application
WHERE EventType=1
ORDER BY TimeGenerated DESC

qnovalog.sql
SELECT Date, Time, Category, [Alarm ID], [Alarm Name], [Lot ID], [Recipe Name], [Slot Number] , [Cassette Number]
INTO qnovalog.csv
FROM ‘\\192.168.1.3\v$\lp\NSAL*.log’
WHERE [Alarm ID] = ‘ALID100’ or  [Alarm ID] = ‘ALID201’ or  [Alarm ID] = ‘ALID300’
ORDER BY Date DESC

View Summary | Journal | Life | Music | Computing | Travel | SwimBikeRun | Projects | Skydrive