There are two different ways of getting the desired result
The first method is iterating through each collection using for loop and displaying the result
cols = db.getCollectionNames();
for (index = 0; index < cols.length; index++) {
var coll = db.getCollection(cols[index]);
var stats = coll.stats();
print(stats.ns, stats.count, stats.size, stats.totalIndexSize); }
OR
The second method is iterating through each collection using cursor which in turns call function
var stats;db.getCollectionNames().forEach(function(x) { stats=db.getCollection(x).stats(); print(stats.ns, stats.count, stats.size, stats.totalIndexSize); });
Like this:
Like Loading...
About Prashanth Jayaram
I’m a Database technologist having 11+ years of rich, hands-on experience on Database technologies. I am Microsoft Certified Professional and backed with a Degree in Master of Computer Application. My expertise lies in T-SQL programming, Replication and PowerShell
You can connect me via
https://social.technet.microsoft.com/profile/prashanth jayaram/
http://www.sqlshack.com/author/prashanth/
https://www.tumblr.com/blog/prashantjayaram
http://www.sqlservercentral.com/blogs/powersql-by-prashanth-jayaram/
http://www.toadworld.com/members/prashanthjayaram/
My Articles are published in following sites
http://www.ssas-info.com/analysis-services-articles/
http://db-pub.com/
http://www.sswug.org/sswugresearch/community/
