Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Here eHere some hints how to query elasticSearch from your web browser

...

To inspect your indexes following functions are very helpfull:

Queries

search (_search)

with "_search" you can search for specific index types. e.g. "workflow" index types:

http://172.17.2.91:9200/workflow/_search

display (?pretty)

with "?pretty" the content will be displaied in a structured way

http://172.17.2.91:9200/workflow/_search?pretty

amount of objects (&size)

if you wnat to see more than 10 objects ausgegeben use the option "size". "Size" defines the amount of ibjects to display e.g. 100

http://172.17.2.91:9200/workflow/_search?pretty&size=100

filter (&q=<feld>:<wert>)

IF you wnat want to filter the objects you can use the function "&q=" e.g. filter attribute "status" for content "11":

...

http://172.17.2.91:9200/workflow/_search?pretty&size=100&q=status:(NOT DENIED)

Load a Template

If you extend your elasticSearch with new content type you have to add a "mapping template". This is a JSON file, that discribes the content of your index. For example to load the mapping template for workflow index: 

 

curl -XPUT http://localhost:9200/_template/workflow_template -d @es_workflow-template.json
curl -XPOST http://localhost:9200/_template/workflow_template -d @es_workflow-template.json

 

boolean expression

You can use boolean expression to define a more complex query (use "\" to escape blanks in attribute names like "Object Name"):

http://uxlpdipacd00001:5151/audit-default-2020*/_search?pretty&size=1000&q=Object\%20Name:00386109914%20or%20Object\%20Name:00386109914

nodes (_node/os?pretty)

If you want to see how many nodes and cpu's are used by ES

http://172.17.2.91:9200/_nodes/os?pretty

index statistics (/<index>/_stats?pretty)

if you need statistics about your index you can use this command like

acd30.skypro.ch:3191/elasticsearch/audit*/_stats?pretty

index catalog (/_cat)

To see the catalog of all indexes with count and size (v=true to show column header):

https://sdeb-idmas-q005.sys.schwarz:3190/elasticsearch/_cat/indices/*?v=true

From version 3.x use Audit Proxy Port

Starting with version 3.x you can use the Audit Proxy using the elasticsearch endpoint to search within specific indexes.

e.g. searching a specific CN with a report index

https://acd30.skypro.ch:3190/elasticsearch/report-default-2021.09.09/_search?pretty&q=cn:1000057376

TTL

To test TTL, you should know that you cannot view the TTL field value. You need to explicitly ask for it with body request parameter fields. Look at this articel

https://makina-corpus.com/blog/metier/2015/elasticsearch-how-to-test-working-ttl-documents