{{ partial "header.html" . }}
{{ partial "ad.html" . }}

Log Parser Example Queries

The following queries can be run with Log Parser. In every case (except if noted) the FROM and INTO statements should be modified based on your needs.

Query suggestions or questions are welcome, and can be emailed to strivinglife [at] gmail dot com, or submitted on the GitHub or GitLab project pages.

{{ range .Data.Pages }}

{{ .Params.name }}

{{ .Params.description }}
{{ if isset .Params "keywords" }} Keywords:
    {{ range sort .Params.keywords }}
  • {{ . }}
  • {{ end }}
{{ end }}
Statement:
logparser {{ .Params.statementParameters }} "SELECT {{ .Params.statementSelect }}{{ if isset .Params "statementusing" }} USING {{.Params.statementUsing }}{{ end }}{{ if isset .Params "statementinto" }} INTO {{.Params.statementInto }}{{ end }}{{ if isset .Params "statementfrom" }} FROM {{.Params.statementFrom }}{{ end }}{{ if isset .Params "statementwhere" }} WHERE {{.Params.statementWhere }}{{ end }}{{ if isset .Params "statementgroupby" }} GROUP BY {{.Params.statementGroupby }}{{ end }}{{ if isset .Params "statementhaving" }} HAVING {{.Params.statementHaving }}{{ end }}{{ if isset .Params "statementorderby" }} ORDER BY {{.Params.statementOrderby }}{{ end }}"
{{ if isset .Params "notes" }} Notes: {{ .Params.notes | safeHTML }} {{ end }} Leave a comment on this query.
{{ end }} {{ partial "disqus.html" . }}
{{ partial "footer.html" . }}