Rem drv: <create type="views"/>
Rem
Rem $Header: emtp/oracle_cell/cell/latest/cell/cell_views.sql /main/2 2009/03/18 13:45:28 spalapud Exp $
Rem
Rem cell_views.sql
Rem
Rem Copyright (c) 2008, 2009, Oracle and/or its affiliates.
Rem All rights reserved. 
Rem
Rem    NAME
Rem      cell_views.sql - <one-line expansion of the name>
Rem
Rem    DESCRIPTION
Rem      <short description of component this file declares/defines>
Rem
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    spalapud    03/04/09 - remove bmcConfigured
Rem    ysun        11/12/08 - Created
Rem

 ------------------ Create View: MGMT_EMX_CELL_C_CONFIG_VIEW  -----
   CREATE OR REPLACE VIEW  MGMT_EMX_CELL_C_CONFIG_VIEW AS 
  SELECT t.ECM_SNAPSHOT_ID,t.NAME,t.STATUS,t.REALMNAME,t.ID,t.MAKEMODEL,t.LOCATION,t.BMCTYPE,t.IPBLOCK,t.FANCOUNT,t.POWERCOUNT,t.METRICHISTORYDAYS,t.SNMPSUBSCRIBER,t.SMTPSERVER,t.SMTPPORT,t.IPADDRESS1,t.IPADDRESS2,t.IPADDRESS3,t.IPADDRESS4,t.KERNELVERSION,t.OSSVERSION,t.INTERCONNECTCOUNT,t.CPUCOUNT ,
    s.TARGET_GUID, s.START_TIMESTAMP, s.TARGET_NAME, s.TARGET_TYPE 
  FROM MGMT_EMX_CELL_C_CONFIG t, MGMT$ECM_CURRENT_SNAPSHOTS s
  WHERE t.ECM_SNAPSHOT_ID = s.ECM_SNAPSHOT_ID ;


 ------------------ Create View: MGMT_EMX_CELL_GD_CONFIG_VIEW  -----
   CREATE OR REPLACE VIEW  MGMT_EMX_CELL_GD_CONFIG_VIEW AS 
  SELECT t.ECM_SNAPSHOT_ID,t.NAME,t.CELLNAME,t.REALMNAME,t.STATUS,t.GDSIZE,t.CREATIONTIME,t.CELLDISK,t.OFFSET,t.ERRORCOUNT,t.AVAILABLETO, 
    s.TARGET_GUID, s.START_TIMESTAMP, s.TARGET_NAME, s.TARGET_TYPE 
  FROM MGMT_EMX_CELL_GD_CONFIG t, MGMT$ECM_CURRENT_SNAPSHOTS s
  WHERE t.ECM_SNAPSHOT_ID = s.ECM_SNAPSHOT_ID ;

 ------------------ Create View: MGMT_EMX_CELL_CD_CONFIG_VIEW  -----
  CREATE OR REPLACE VIEW  MGMT_EMX_CELL_CD_CONFIG_VIEW AS 
  SELECT t.ECM_SNAPSHOT_ID,t.NAME,t.CELLNAME,t.REALMNAME,t.STATUS,t.CDSIZE,t.LUN,t.ERRORCOUNT,t.FREESPACE,t.DEVICEPARTITION, 
    s.TARGET_GUID, s.START_TIMESTAMP, s.TARGET_NAME, s.TARGET_TYPE 
  FROM MGMT_EMX_CELL_CD_CONFIG t, MGMT$ECM_CURRENT_SNAPSHOTS s
  WHERE t.ECM_SNAPSHOT_ID = s.ECM_SNAPSHOT_ID ;

 ------------------ Create View: MGMT_EMX_CELL_L_CONFIG_VIEW  -----
  CREATE OR REPLACE VIEW  MGMT_EMX_CELL_L_CONFIG_VIEW AS 
  SELECT t.ECM_SNAPSHOT_ID,t.NAME,t.CELLNAME,t.REALMNAME,t.STATUS,t.ID,t.CELLDISK,t.ERRORCOUNT,t.RAIDLEVEL,t.DEVICENAME,t.LUNSIZE,t.LUNUID,t.LUNAUTOCREATE,t.PHYSICALDISKS, 
    s.TARGET_GUID, s.START_TIMESTAMP, s.TARGET_NAME, s.TARGET_TYPE 
  FROM MGMT_EMX_CELL_L_CONFIG t, MGMT$ECM_CURRENT_SNAPSHOTS s
  WHERE t.ECM_SNAPSHOT_ID = s.ECM_SNAPSHOT_ID ;

 ------------------ Create View: MGMT_EMX_CELL_PD_CONFIG_VIEW  -----
  CREATE OR REPLACE VIEW  MGMT_EMX_CELL_PD_CONFIG_VIEW AS 
  SELECT t.ECM_SNAPSHOT_ID,t.NAME,t.CELLNAME,t.REALMNAME,t.STATUS,t.ID,t.MAKEMODEL,t.LUNS,t.ERRORCOUNT,t.CTRLFIRMWARE,t.CTRLHWVERSION,t.PHYSINTERFACE,t.PHYSFIRMWARE,t.PHYSSIZE,t.PHYSSERIAL,t.PHYSUSETYPE,t.PHYSPORT,t.PHYSINSERTTIME, 
    s.TARGET_GUID, s.START_TIMESTAMP, s.TARGET_NAME, s.TARGET_TYPE 
  FROM MGMT_EMX_CELL_PD_CONFIG t, MGMT$ECM_CURRENT_SNAPSHOTS s
  WHERE t.ECM_SNAPSHOT_ID = s.ECM_SNAPSHOT_ID ;

 ------------------ Create View: MGMT_EMX_CELL_IORM_CONFIG_VIEW  -----
  CREATE OR REPLACE VIEW  MGMT_EMX_CELL_IORM_CONFIG_VIEW AS 
  SELECT t.ECM_SNAPSHOT_ID,t.NAME,t.CELLNAME,t.REALMNAME,t.STATUS,t.LATENCY,t.DIRECTIVETYPE,t.DBCATNAME,t.LEVEL1,t.LEVEL2,t.LEVEL3,t.LEVEL4,t.LEVEL5,t.LEVEL6,t.LEVEL7,t.LEVEL8,t.ROLE, 
    s.TARGET_GUID, s.START_TIMESTAMP, s.TARGET_NAME, s.TARGET_TYPE 
  FROM MGMT_EMX_CELL_IORM_CONFIG t, MGMT$ECM_CURRENT_SNAPSHOTS s
  WHERE t.ECM_SNAPSHOT_ID = s.ECM_SNAPSHOT_ID ;

-- End of table (re)creation for metadata Oracle Cell Configuration