Skip to content

Instantly share code, notes, and snippets.

@ableasdale

ableasdale/customer-search.kql

Created November 23, 2015 19:14
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save ableasdale/d00a555532db8cf2954e to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save ableasdale/d00a555532db8cf2954e to your computer and use it in GitHub Desktop.
Download ZIP
KQL Select example for customer tickets
Raw
customer-search.kql
SELECT 'Tickets.Ticket ID', 'Tickets.Priority', 'Tickets.Subject', 'Tickets.Creation Date', 'Tickets.Resolved Date', 'Tickets.User', 'Tickets.Owner', 'Tickets.Status' WHERE 'Users.User Organization' = 'MarkLogic' AND 'Tickets.Creation Date' = MONTHRANGE(October 2014, November 2015) ORDER BY 'Tickets.Creation Date'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment