Looking for examples of integrating LP into this workflow:
- A SQL server event indicates IIS tossed an error.
- SQL parses the body of the error message and generates an LP commandline that queries IIS logs to collect more information.
- An email is dispatched to tech support with a link to an html (or .aspx) page that would run and present LP's output.
So i think the question boils down to:
How do i hook LP upto IIS7?
EDIT: Ok...re-boiling the question. When an IIS exception is triggered I want to see all the other log rows where the session cookie is the same as the session cookie found in the error event. Yes, I could live with polling IIS logs via a scheduled task - that takes ELMAH/SQL out of the equation.
But now the question becomes: Find all log rows where session cookie = the session cookie found in a row that had an error