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

Mudit 101 Reputation points
2021-09-08T14:23:41.87+00:00

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.

Microsoft Security | Intune | Configuration Manager | Other
Windows for business | Windows Server | Storage high availability | Other
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. AllenLiu-MSFT 49,316 Reputation points Microsoft External Staff
    2021-09-09T07:22:50.987+00:00

    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. Limitless Technology 39,931 Reputation points
    2021-09-09T07:48:29.893+00:00

    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,


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.