question

mdautomation avatar image
0 Votes"
mdautomation asked saldana-msft edited

SCCMContentLib consuming more than double the space of total size of all actual sources

Hi,

We have Standalone Primary and DP role configured on Primary site server.
It's a Virtual Server and SCCMContentLib is on SAN disks.

I found total size of all packages using SMSPackages_G.SourceSize and it came out as 1.6 TB.
Whereas when I see the actual space consumed by SCCMContentLib on Primary site server, then it's 4.3 TB.

I already executed ContentLibraryCleanup.exe and deleted all orphaned content.

I am unable to understand how can the size of SCCMContentLib be more than double than that of total size of actual sources.

Any pointers on this would be great.


mem-cm-generalwindows-server-storage
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AllenLiu-MSFT avatar image
0 Votes"
AllenLiu-MSFT answered AllenLiu-MSFT commented

Hi, @muditbahedia
Thank you for posting in Microsoft Q&A forum.

First, it's recommended to query view instead of table in database, we can query the view v_PackageStatusRootSummarizer to get the source size.
Select SUM(SourceSize) from v_PackageStatusRootSummarizer

Then, I compared the source size in database of mine with the size of SCCMContentLib, they are almost the same size.
But I haven’t figured out their specific differences, I will do more research, if I have further discovery, I will post it here.


If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi, Thanks for the reply.
I just queried from the view as well and the size is still the same of what I had got from table.

Thank you!

0 Votes 0 ·

When you run contentlibraryexplorer.exe from %SCCM installation path%\tools\ServerTools, can you see any package ID grayed out?

0 Votes 0 ·
LimitlessTechnology-2700 avatar image
0 Votes"
LimitlessTechnology-2700 answered mdautomation commented

Hello Mudit,

Firstly I would recommend you to download the Microsoft tool System Center Configuration Manager Toolkit from: https://www.microsoft.com/en-us/download/details.aspx?id=50012
This application will help you navigate and find orphaned content.

Otherwise, you can perform a cleanup using the SCCM Content Library Cleanup Tool, distributed with all Current Branch since version 1612. Look for ContentLibraryCleanup.exe in %program files%\CD.Latest\SMSSETUP\TOOLS\ContentLibraryCleanup

First you can run the detection command as: ContentLibraryCleanup.exe /dp DP FQDN /log <folder path> (this will show you cleanup potential)
Then the Delete mode to complete the cleanup based on the findings: ContentLibraryCleanup.exe /delete /dp <DP FQDN> /log <log file path>

As a point of reference you can read how the content library works here: https://techcommunity.microsoft.com/t5/configuration-manager-archive/understanding-the-configuration-manager-content-library/ba-p/273349

Hope this helps with your request,
Best regards,

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi, Thanks for the reply. As I already mentioned in my initial post, I have already executed and deleted all orphaned packages using ContentLibraryCleanup.exe

0 Votes 0 ·