1

How can I find out the total content size in a particular publication (all Tridion items) or in the entire Tridion system (All publications)? Please suggest.

  • Are you asking what is the size of binary items or all the items in Tridion . Let me know what you are trying to do by finding the size . So we can assist accordingly. – Anand NS Jul 23 at 6:38
  • What are you looking to do with the data? – Alvin Reyes Jul 24 at 14:55
3

From your comments, I am gathering that you are not looking for the number of items in the CM, but rather the disk space the Tridion items occupy. You can't get this using the Core Service API. This is rather a SQL server question, but to get the size of the Tridion CM database, we can use the stored procedure sp_spaceused to get the size that the CM database occupies. More about this stored procedure is here: https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-spaceused-transact-sql?view=sql-server-ver15.

enter image description here

If you looking for the size of specific items you'd have to create custom queries using the DATALENGTH function that returns the size in bytes (https://docs.microsoft.com/en-us/sql/t-sql/functions/datalength-transact-sql?view=sql-server-ver15). Something like this:

SELECT (SUM(DATALENGTH([CONTENT]))/1024.0/1024.0/1024.0) as [CONTENT_SIZE_IN_GB]
  FROM [Tridion_cm].[dbo].[BINARIES]

enter image description here

| improve this answer | |
  • 1
    thanks @Sabarish. This is very helpful. Can we run sp_spaceused stored procedure for one particular publication? – Thakur Jul 23 at 19:02
  • No, the stored procedure is for the whole database. You have to write custom queries. – Sabarish Senthilnathan Jul 23 at 21:20
3

Well, there is easy way and a hard way.

Easy way is to check Tridion CM database, check number of items in ITEMS database (exclude versions and just check latest versions). Also exclude if you want local copies. Filter by publication or check all.

Hard way is to check using Core Service, and it is the only supported way. For this there are many examples and you can even find some here on stack. All you need to do is use filters, and you are good to go.

| improve this answer | |
  • thanks for your response. Is there a way to find out how many GB of data we have? – Thakur Jul 23 at 13:49
  • 1
    Regarding “the supported way”: there is no issue with database queries, but never do database changes without contacting SDL Support. In this case, database queries seem to be easiest and most effective, indeed. Don’t forget to query the BINARIES table too. – Rick Pannekoek Jul 23 at 16:09
  • thanks @RickPannekoek. Is there any sample query which I can use? – Thakur Jul 23 at 16:21
  • agreed rick. although you can read the data whichever way you see fit, you cannot alter it directly, only via apis – Marko Milic Jul 24 at 9:29
  • @Thakur, gb of data are hard to track because this is data in database. not simple filesystem. but you can export it in some format and see. afcourse binaries are different matter. – Marko Milic Jul 24 at 9:30

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.