For those who remember Episode 1 , SQLite semi Embedded database functionality in AutIT.
I want to introduce to you the next level of SQL integrated, on your Files System, using the MS LogParser.
Let me first give you a small introduction of what the LogParser SQL engine is about.
"Log parser is a powerful, versatile tool that provides universal query access to text-based data such as log files, XML files and CSV files, as well as key data sources on the Windows® operating system such as the Event Log, the Registry, the file system, and Active Directory®.
You tell Log Parser what information you need and how you want it processed. The results of your query can be custom-formatted in text based output, or they can be persisted to more specialty targets like SQL, SYSLOG, or a chart.
The world is your database with Log Parser."
This is a next step to the LINQ (Language Integrated Query) Concept . LINQ Concept
MS LogParSer is a standalone command line tool, as well as a fully scriptable COM API.
To get started you need to download it here : MS LogParser 2.2
The LogParser has a standard SQL syntax, extended with Expression and Functions.
It is even possible to extend the functionalities with Custom PlugIns.
Concept overview
After installing, you need to register the "regsvr32 LogParser.dll",
in order to run the examples from my next post.
It has a small footprint and for this reason, it is a perfect marriage for AutoIT.
"SQL is the name and AutoIT is the game."
Edited by ptrex, 14 September 2012 - 09:28 AM.
