How to remove analytics logs in mobilefirst 6.3

Question

We are working in a mobilefirst 6.3 project, and our .war is installed in a liberty profile server.

We didn't configure the TTL on the analytics before. is there any way (tool, rest service or file-system) that I can remove the analytics logs in mobilefirst.

What do you mean by "remove"? Remove the analytics service? Remove the data? I think you need to clarify your question. — Andrew Ferrier, Jun 24 '15 at 13:23
Which .war are you referring to? There are *many* WARs involved in a MobileFirst installation. — Andrew Ferrier, Jun 24 '15 at 13:23
the war im refering is my project war, and yes, i want to wipe all my old logs, from my analytics, not my analytics war — user2449016, Jun 24 '15 at 13:30

score 3 · Answer 1 · edited May 23 '17 at 10:34

MobileFirst Platform Foundation Analytics uses ElasticSearch and Lucene at its core - there is nothing special to be done from a MobileFirst perspective.

If you want to remove everything, the whole Analytics store:

Stop the Analytics server
Delete the "analyticsData" folder which is under servers/<server-name>/ in the Liberty installation
Restart the server

Otherwise, using either CURL or Postman you can invoke the DELETE query.
You can find the ElasticSearch API here: https://www.elastic.co/guide/en/elasticsearch/reference/current/docs-delete-by-query.html

Some additional questions about this topic in Stack Overflow:

Example steps:

Open the ES port - MobileFirst uses port 9500,
In the Analytics server set the JNDI property http.enabled=true and restart the Analytics server (if it's a cluster, you still only need to open the port on one of the cluster members)
The default "index" to use in your query is "worklight", and the mappings are documented in the user documentation, and are shown on the admin tab in the Analytics console
The endpoint for your delete query would need to be the Analytics server

Postman example query:

DELETE
http://your-analytics-server:9500/worklight/network_transactions/_query
{
  "query": {
    "range": {
      "worklight_data.timestamp": {
        "to": 1432313605000
      }
    }
  }
}

CURL example query:

curl -X DELETE 'http://server:9500/worklight/network_transactions/_query' (http://server:9500/worklight/network_transactions/_query%27)  -d '{ "query" : { "range" : { "timestamp" : { "lte" : "1432222333424" } } } }'

How to remove analytics logs in mobilefirst 6.3

1 Answers1