1 person found this helpful
The user container holds any content specific to the user, such as personal blogs, and in 4.0, personal documents.
Based on your response:
I assume that all containers (container table) with of container_type 37 are space or group blogs - correct?
I assume that the blogpost table contains both space/group and personal blogs, correct? Therefore the blog_id could point to container types 37 and 2020 in the container table?
A Blog itself is a container. A blogpost can only belong to a Blog container (container type 37)
The Blog containers themselves belong to another container. However, blog containers can belong to any container type such as spaces, social groups, user containers or even custom containers (e.g. from a plugin).
So your assumption is incorrect. If you see a container type 37 in the container table, all you know is that it is a blog. To find out if it's a space blog or user blog you would need to retrieve it's parent container id. Unfortunately this is not currenty available in analytics.
The blog_id in the blogpost table will only refer to the container_ids in the container table that have container type of 37 (blog).
Also, to answer your original question, if you just want to find out what blogs have been created (irrespective of whether they are social groups, space or user blogs), you can just check the container table for container type 37. Alternatively you can also check the jivedw_object table for object type 37 since the entry is also there.
Hope that helps.