question

yannara avatar image
0 Votes"
yannara asked ·

How to clean SUSDB from 3rd party updates

I have 3rd party updates metadata only synced, and they are still have a blue icon. I need those to get expired and then deleted. Currently well known SUSDB powershell and SQL query scripts to clean the database are not effecting the entities with blue icon. Any idea?

I have 3300 items synced from Lenovo 3rd party and it breakes by OSD because of max round trip exeeded in WSUS.

mem-cm-generalmem-cm-updates
10 |1000 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.

SherryKissinger-ECM avatar image
0 Votes"
SherryKissinger-ECM answered ·

A possibility only; it's at least something to look at maybe.

I'm assuming that perhaps you utilized "System Center Updates Publisher" to originally publish those updates into CM as metadata only?

Run SCUP as Admin.

Option 1:
If this scup instance is referencing the original scup database, you might be lucky that you'll see all the lenovo updates you had previously sync'd. You should be able to expire there within SCUP there, and sync.

Option 2 (if none of the lenovo things are listed in scup):
Go to the pull-down upper left, Options, Advanced.
click on "Start" within the Software Update Cleanup Wizard box there.

If you are super lucky... the updates you want to expire will be listed there; and you can follow the directions to expire them there.

· 2 ·
10 |1000 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.

This is not scup. This is Third Party Updates. These updates are not found via WSUS console either, so no chance to expire them or delete.

0 Votes 0 ·

sorry, then I have no suggestions; other than to open a case with Microsoft; for them to work through how to expire those updates correctly.

1 Vote 1 ·
yannara avatar image
0 Votes"
yannara answered ·

The solution I found is that you unscribe, de-select all catagories and products and re-sync.

· 1 ·
10 |1000 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.

That didn't clear the metadata brought from 3rd party updates.

0 Votes 0 ·