Get all software updates present in software update package through SQL

Hello All,

I have a small question, and i am getting a bit stuck here.

Indeed, I am looking to retrrieve all Software updates present in a Software update package in order to be able to copy it.

So i managed to write a query that would (what i though) send me back all the CI_UniqueId's from the software updates present in a software update package.

Indeed, it sends me ID's Back, but they dont seem to be CI_uniqueIDs.

Here is the query : 

SELECT CI_UniqueID FROM  v_UpdatePrograms join v_UpdateCIs on v_UpdatePrograms.UpdateID = v_UpdateCIs.CI_ID  Where PackageID = 'CBD0004D'

There is probably an error in the join, but i have to admit that SQL is a bit out of my confort zone.. ;)

Thanks in advance for your answers ! :)

January 7th, 2014 6:24pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics