Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 4033
  • Last Modified:

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
0
merowinger
Asked:
merowinger
  • 3
1 Solution
 
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
 
merowingerAuthor 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

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now