Distill Alphabetically Sorted Unique User List From Essbase Logs
Summary
Distill Alphabetically Sorted Unique User List From Essbase LogsContent
Creating user lists from logfiles using Perl, UNIX/Cygwin commands 'awk', 'sort' and 'uniq'
Process to distill unique user names from logfiles using Hyperion Essbase Log Search Suite (showsearch.pl)
http://www.oracle.com/technetwork/middleware/bi-foundation/utilities-code-sampleapps-096275.htm
1. Run showsearch.pl (0 before 1 after) search for "from user", take generated file for processing.
In UNIX/Cygwin:
2. Take generated user file and sort to cull duplicates quickly:
3. sort showsearch.txt | uniq -d >> noduplicates.txt
4. awk '/Received/{print $NF}' noduplicates.txt >> newest.txt
5. strip duplicates from "newest.txt"
6. sort newest.txt | uniq -d >> nonewduplicates.txt
0