Dear All, I need your support to execute an SQL code to view the sizes of each category to follow up periodically to ensure that the category is not exceeding the agreed size by the moderators. We executed the following code but the result is displayed in bytes and we need it to be displayed in GB…

I think you just need to change the calcs to reflect your units. for example, for GB -- Query to estimate the data size for each category in GB SELECT c.id AS category_id, c.name AS category_name, COUNT(DISTINCT t.id) AS topics_count, COUNT(p.id) AS posts_count, ROUND(SUM(LENGT…

[image] Lilly: for GB Very 101 level question… mine is showing practically zero sizes. Will that come from S3 use or isn’t images counted as an upload? Sure, those are relatively small, as are some PDFs and e-books, but still those should be bigger than 0.001 GB.

Support to Extract a Report using Data Explorer Plugin

Product Support

Eman_Ahmed (Emy) November 25, 2024, 11:46am 3

Noted, thank you !

Topic		Replies	Views
Get all data of topics from categories such as images, links, contents etc General	0	767	December 7, 2022
View total topics per category/sub category Product Support moderation	9	3193	November 18, 2015
List of all uploaded files Feature planned	15	4970	February 20, 2023
Aggregate dashboard report data by time interval Data & reporting sql-query	4	1240	September 24, 2022
Data Explorer: Posts by Category (Including Subcategories) Product Support data-explorer	1	1151	November 28, 2021

Support to Extract a Report using Data Explorer Plugin

Related topics