| 29 |
jtweddle |
1 |
/* Common Database Server Products - Solaris */
|
|
|
2 |
|
|
|
3 |
SELECT distinct pv.pv_id, pkg.pkg_name, pkg.sunos_electronic_name, pv.patch_electronic_name, pv.pkg_version, count(1) AS NUM
|
|
|
4 |
--nn.node_name, --nn.node_name, pv.pv_id, pkg.*, pv.patch_electronic_name, pkg_version
|
|
|
5 |
FROM boms bm,
|
|
|
6 |
bom_contents bc,
|
|
|
7 |
network_nodes nn,
|
|
|
8 |
operating_systems os,
|
|
|
9 |
os_contents osc,
|
|
|
10 |
PACKAGES pkg,
|
|
|
11 |
package_versions pv,
|
|
|
12 |
bos_types bt
|
|
|
13 |
WHERE bm.bom_id = :bom_id
|
|
|
14 |
AND bm.bom_id = bc.bom_id
|
|
|
15 |
AND nn.node_id = bc.node_id
|
|
|
16 |
AND nn.node_type_id IN (1) -- For Database Servers
|
|
|
17 |
AND os.node_id = nn.node_id
|
|
|
18 |
AND osc.os_id = os.os_id
|
|
|
19 |
AND osc.prod_id = pv.pv_id
|
|
|
20 |
AND pkg.pkg_id = pv.pkg_id
|
|
|
21 |
AND bt.bos_id IN (2) -- Solaris only
|
|
|
22 |
AND os.not_xml IS NULL
|
|
|
23 |
AND osc.not_xml IS NULL
|
|
|
24 |
group by pv.pv_id, pkg.pkg_name, pkg.sunos_electronic_name, pv.patch_electronic_name, pv.pkg_version
|
|
|
25 |
order by pkg.pkg_name
|