Converting Mongo Extended JSON format to strict JSON on MongoDB shell

[an...@cultureamp.com]

Hi there,

maybe a bit of an obvious question but can't find the answer.

I am trying to extract Server Status information from a mongodb instance to be fed it into Splunk.

At the moment I am using the following script:

mongo ... --quiet --eval "printjsononeline(db.runCommand({ serverStatus: 1 }))"

Splunk Forwarder is having issues to parse the output due to data types included in the resulting document, i.e:

"uptimeMillis" : NumberLong(522262234)

I was wondering what's the best way to convert it to MongoDB Strict format so that Splunk without having to use mongoexport or the REST API.

Thanks in advance.

Angel

[Ian Bytchek]

Did you figure out how to do that?

[an...@cultureamp.com]

Not yet...

[AlainC]

You can try this :

--eval "print(tojson(db.runCommand({ serverStatus: 1 })).replace(/NumberLong\(([0-9]*)\)/gm,'$1').replace(/(\r\n|\n|\r|\s)/gm, '')))"

Not really proud of that, but at least it seem to work...