I have this SQL query:
SELECT time,targetuser, count(targetuser),ipaddress FROM `test_index` WHERE `event_id`=4444 AND `status`=`0x10` GROUP BY ipaddress,targetuser ORDER BY TIME DESC;
How convert this SQL query to Elasticsearch query? is it possible?