I had a quick look to this, and yes unfortunately cases are stored as saved objects
But definetly you can get cases metadata reindexed to a new index for Analytics
GET .kibana/_search
{
"query": {
"bool": {
"must": [
{
"exists": {
"field": "cases-user-actions"
}
}
]
}
}
}
You will just need a small ingest pipeline to serialize case metadata, as they are stred in a json field
PUT _ingest/pipeline/read_siem_cases
{
"description": "Serialize case attributes",
"processors": [
{
"json": {
"field": "cases-user-actions.new_value",
"target_field": "case_metadata"
}
}
]
}
And here is how to reindex only cases
POST _reindex
{
"source": {
"index": ".kibana",
"query": {
"bool": {
"must": [
{
"exists": {
"field": "cases-user-actions"
}
}
]
}
}
},
"dest": {
"index": "siem_cases",
"pipeline": "read_siem_cases"
}
}
The new index will looks like this
{
"_index" : "siem_cases",
"_type" : "_doc",
"_id" : "cases-user-actions:419c6d60-7556-11eb-a3ff-3f54f568a988",
"_score" : 1.0,
"_source" : {
"migrationVersion" : {
"cases-user-actions" : "7.10.0"
},
"references" : [
{
"name" : "associated-cases",
"id" : "4177a750-7556-11eb-a3ff-3f54f568a988",
"type" : "cases"
}
],
"updated_at" : "2021-02-22T21:38:09.336Z",
"cases-user-actions" : {
"action_by" : {
"full_name" : null,
"email" : null,
"username" : "elastic"
},
"action_field" : [
"description",
"status",
"tags",
"title",
"connector",
"settings"
],
"action" : "create",
"old_value" : null,
"action_at" : "2021-02-22T21:38:09.087Z",
"new_value" : """{"title":"My Case Name","tags":["My Case Tag1","My Case Tag2","My Case Tag3"],"description":"My Case Description","connector":{"id":"none","name":"none","type":".none","fields":null},"settings":{"syncAlerts":true}}"""
},
"type" : "cases-user-actions",
"case_metadata" : {
"settings" : {
"syncAlerts" : true
},
"connector" : {
"name" : "none",
"id" : "none",
"type" : ".none",
"fields" : null
},
"description" : "My Case Description",
"title" : "My Case Name",
"tags" : [
"My Case Tag1",
"My Case Tag2",
"My Case Tag3"
]
}
}
}