gscattolin · August 15, 2016 05:38
diff --git a/MongoCommonCommands.txt b/MongoCommonCommands.txt
 db.audit.remove({"reqTime" : { $lt : new Date('01/01/2016').getTime()}}) #remove everything is older than (bad performance)
 db.audit.find().sort({"createdAt" : -1}).limit(1) #get latest created
 db.collection.stats() #info about collection

 export collection mongo in cvs file
 mongoexport -h host -d dbname -c collectionname --type=csv -f name,side,type,field --out ~/export20160426.csv
 
 db.fs.files.aggregate([{$group: {_id: "$contentType", total : { $sum: 1 }}}]) # count type on FS Grid
	db.audit.remove({"reqTime" : { $lt : new Date('01/01/2016').getTime()}}) #remove everything is older than (bad performance)
	db.audit.find().sort({"createdAt" : -1}).limit(1) #get latest created
	db.collection.stats() #info about collection

	export collection mongo in cvs file
	mongoexport -h host -d dbname -c collectionname --type=csv -f name,side,type,field --out ~/export20160426.csv

	db.fs.files.aggregate([{$group: {_id: "$contentType", total : { $sum: 1 }}}]) # count type on FS Grid