List of random mongodb commands

Mongodb-random-scripts

Copy collection to another DB
db.getCollection('AdUnitPattern').find().forEach(function(d){ db.getSiblingDB('ebm_smartbuildingstech_website')['AdUnitPattern'].insert(d); });

# Clone celltion from dev to prod
db.cloneCollection("10.0.0.100", "SiteSettings")
db.cloneCollection("10.0.0.100", "AdUnitPattern")
db.cloneCollection("10.0.0.100", "Layout")

# Move collection from dev to prod
mongoexport  -h 10.0.0.100 -d ebm_electronicdesign_website -c AdUnitPattern --out file
mongoimport -u developer  -d ebm_electronicdesign_website -c AdUnitPattern --drop --authenticationDatabase admin --file file

mongoexport  -h 10.0.0.100 -d ebm_electronicdesign_website -c Layout --out file
mongoimport -u developer  -d ebm_electronicdesign_website -c Layout --drop --authenticationDatabase admin --file file

mongoexport  -h 10.0.0.100 -d ebm_electronicdesign_website -c SiteSettings --out file
mongoimport -u developer  -d ebm_electronicdesign_website -c SiteSettings --drop --authenticationDatabase admin --file file

// get a count to see how many match
db.getCollection('Content').aggregate([
    {
        $match: {
            by_line: { $not: {$size: 0} }
        }
    },
    { $unwind: "$by_line" },
    {
        $group: {
            _id: '$by_line',
            count: { $sum: 1 }
        }
    },
    {
        $match: {
            count: { $gte: 10 }
        }
    },
    { $sort : { count : -1} },
    { $limit : 100000 }
]);