How to remove the update metadata in SCCM database

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
LVL 31
merowingerAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
merowingerConnect With a Mentor Author Commented:
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
 
manksterCommented:
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
 
merowingerAuthor Commented:
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
 
merowingerAuthor Commented:
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
All Courses

From novice to tech pro — start learning today.