MongoDB output that was generated using emqttd analytics plugin.

mongodb_output.js

{
	"_id" : ObjectId("5806bf7f83152983d5000001"),
	"type" : "on_session_created",
	"date" : ISODate("2016-10-19T00:34:07.513Z"),
	"client_id" : "C_1476837240716",
	"username" : "admin"
}
{
	"_id" : ObjectId("5806bf7f83152983d5000002"),
	"type" : "on_client_connected",
	"date" : ISODate("2016-10-19T00:34:07.602Z"),
	"client_id" : "C_1476837240716"
}
{
	"_id" : ObjectId("5806bf7f83152983d5000003"),
	"type" : "on_client_subscribe",
	"date" : ISODate("2016-10-19T00:34:07.603Z"),
	"client_id" : "C_1476837240716",
	"username" : "admin",
	"topic_table" : [
		{
			"$client/C_1476837240716" : [
				{
					"qos" : 1
				}
			]
		},
		{
			"$user/admin" : [
				{
					"qos" : 1
				}
			]
		}
	]
}
{
	"_id" : ObjectId("5806bf7f83152983d5000004"),
	"type" : "on_session_subscribed",
	"date" : ISODate("2016-10-19T00:34:07.604Z"),
	"client_id" : "C_1476837240716",
	"username" : "admin",
	"topic_and_opts" : {
		"topic" : "$client/C_1476837240716",
		"opts" : [
			{
				"qos" : 1
			}
		]
	}
}
{
	"_id" : ObjectId("5806bf7f83152983d5000005"),
	"type" : "on_session_subscribed",
	"date" : ISODate("2016-10-19T00:34:07.605Z"),
	"client_id" : "C_1476837240716",
	"username" : "admin",
	"topic_and_opts" : {
		"topic" : "$user/admin",
		"opts" : [
			{
				"qos" : 1
			}
		]
	}
}
{
	"_id" : ObjectId("5806bf9483152983d5000006"),
	"type" : "on_client_subscribe",
	"date" : ISODate("2016-10-19T00:34:28.673Z"),
	"client_id" : "C_1476837240716",
	"username" : "admin",
	"topic_table" : [
		{
			"/World" : [
				{
					"qos" : 0
				}
			]
		}
	]
}
{
	"_id" : ObjectId("5806bf9483152983d5000007"),
	"type" : "on_session_subscribed",
	"date" : ISODate("2016-10-19T00:34:28.674Z"),
	"client_id" : "C_1476837240716",
	"username" : "admin",
	"topic_and_opts" : {
		"topic" : "/World",
		"opts" : [
			{
				"qos" : 0
			}
		]
	}
}
{
	"_id" : ObjectId("5806bf9583152983d5000008"),
	"type" : "on_message_publish",
	"date" : ISODate("2016-10-19T00:34:29.667Z"),
	"message" : {
		"id" : "\u0000\u0005?,��}fp\u0005\u0000\u0000\u0004�\u0000\u0001",
		"pktid" : null,
		"from" : {
			"client_id" : "C_1476837240716",
			"username" : "admin"
		},
		"qos" : 0,
		"retain" : false,
		"dup" : false,
		"topic" : "/World"
	}
}
{
	"_id" : ObjectId("5806bf9583152983d5000009"),
	"type" : "on_message_delivered",
	"date" : ISODate("2016-10-19T00:34:29.668Z"),
	"client_id" : "C_1476837240716",
	"username" : "admin",
	"message" : {
		"id" : "\u0000\u0005?,��}fp\u0005\u0000\u0000\u0004�\u0000\u0001",
		"pktid" : null,
		"from" : {
			"client_id" : "C_1476837240716",
			"username" : "admin"
		},
		"qos" : 0,
		"retain" : false,
		"dup" : false,
		"topic" : "/World"
	}
}