Solved

How to remove the update metadata in SCCM database

Posted on 2010-08-31
4
3,568 Views
Last Modified: 2013-11-21
Hi all,
i've more than 20.000 update metadata entries in the sccm database which slows the performance on reports. Most of them (approx. 13.000 updates) are driver updates like realtek and intel which i do not need. I've already unchecked these classifications and products on the sofware update point component. How can I remove the unneeded entries?
Is there a sccm maintenance task which removes those entries after some time?
I've already waited almost two weeks, but the number is still the same.
Thanks a lot
0
Comment
Question by:merowinger
  • 3
4 Comments
 
LVL 3

Expert Comment

by:mankster
ID: 33573883
This will be taken care of the 'Delete Aged Configuration Management Data Task' task.
http://technet.microsoft.com/en-us/library/bb693964.aspx

Let me know if you have any questions.
0
 
LVL 31

Author Comment

by:merowinger
ID: 33574058
Are you sure? It sounds a little bit that the client specific data for updates management is deleted.e.g. the status reports which updates are needeed and so on, but not the updates metadata itself.
0
 
LVL 31

Author Comment

by:merowinger
ID: 33575659
I've reinstalled the SUP and WSUS and now all updates except of them i want to be synced are set to expired. The question is now if the expired updates are removed from the sccm database?!
0
 
LVL 31

Accepted Solution

by:
merowinger earned 0 total points
ID: 33585448
I could solve it.
Here is it step by step:

1. Choose all Classifications, Products and Languages in SCCM which you need
2. Reinstall WSUS and SUP -> All Updates in SCCM are set to Expired=1
3. After Resync all Updates which are still synced get the state Expired=0 all others remain on Expired=1
4. All these Updates will automatically get removed during 14 days.
0

Featured Post

Easy, flexible multimedia distribution & control

Coming soon!  Ideal for large-scale A/V applications, ATEN's VM3200 Modular Matrix Switch is an all-in-one solution that simplifies video wall integration. Easily customize display layouts to see what you want, how you want it in 4k.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
In this article, I will show you HOW TO: Perform a Physical to Virtual (P2V) Conversion the easy way from a computer backup (image).
This Micro Tutorial will give you a basic overview of Windows DVD Burner through its features and interface. This will be demonstrated using Windows 7 operating system.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

766 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question