Finding drivers in one boot image that aren’t in another

-- Drivers in XXX00005 and not in XXX00334

SELECT distinct bip.CI_ID

FROM BootImgPkg_References as bip

INNER JOIN CI_ConfigurationItems as cc ON cc.CI_ID = bip.CI_ID

INNER JOIN v_CI_DriversCIs as drv ON drv.CI_ID = bip.CI_ID WHERE bip.PkgID = 'XXX00005'

and bip.CI_ID not in (

SELECT distinct bip.CI_ID

FROM BootImgPkg_References as bip

INNER JOIN CI_ConfigurationItems as cc ON cc.CI_ID = bip.CI_ID

INNER JOIN v_CI_DriversCIs as drv ON drv.CI_ID = bip.CI_ID WHERE bip.PkgID = 'XXX00334'

)

-- Drivers in XXX00334 and not in XXX00005

SELECT distinct bip.CI_ID

FROM BootImgPkg_References as bip

INNER JOIN CI_ConfigurationItems as cc ON cc.CI_ID = bip.CI_ID

INNER JOIN v_CI_DriversCIs as drv ON drv.CI_ID = bip.CI_ID WHERE bip.PkgID = 'XXX00334'

and bip.CI_ID not in (

SELECT distinct bip.CI_ID

FROM BootImgPkg_References as bip

INNER JOIN CI_ConfigurationItems as cc ON cc.CI_ID = bip.CI_ID

INNER JOIN v_CI_DriversCIs as drv ON drv.CI_ID = bip.CI_ID WHERE bip.PkgID = 'XXX00005'

)

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s