How to analyse data from logs sent to Outlook

This is one way of analysing data received in notification emails. Basically using One Note to combine many emails togther then manipulating the result via Cgywin and loading it into a database.

Highlight all applicable emails in Outlook. Right click, Send to One Note. In One Note they will appear in the ‘Unfiled Notes’ tab. Edit this to only include items of interest. Right click Save as Word document to save all the entries. Open the resulting document in Word and save as MS-Dos text.

Trim to the text of interest using Cgywin. Cut to the columns required.

$ cat BIS_2.txt | cut -c26-70 > a.txt

Filter on a string i.e. install then gssc

$ cat a.txt | sed -n '/install/p' > b.txt $ cat b.txt | sed -n '/gssc/p' > c.txt

Remove duplicates

$ sort –u c.txt > d.txt

For a word count: Paste into Wordle. Menu: Language - Show word Counts. The UNIX wc command does not show numbers of word occurrences.

Amend the output so that we can load it into a table. Add text at the start and end of each line.

sed 's+^+Insert Into Analysis (Build, Env) Values (+' e.txt > f.txt sed ‘s/$/end_text/’ f.txt > g.txt

Do other text substitution in Wordpad.

In a database create a simple table.

Create Table Analysis ( Build Varchar2(30), Env Varchar2(20));

Execute the loading table

@c:\g.sql

Analyse the data

Select Distinct Build, Env From analysis Where Build Not In (Select Build From Bis Where Env In( 'EBSGLD5','EBSPRD1')) order by 1;