Edit D:\app\Administrator\product\11.2.0\dbhome_1\j2ee\OC4J_EM\applications\em\em\ecm\search\searchOSHWSummaries.uix
<!-- * Copyright (c) 2001, 2004, Oracle. All rights reserved. * * NAME * searchOSHWSummaries.uix * * NOTES * search Host OS and Hardware Summaries * * MODIFIED (MM/DD/YY) VERSION * asaras 06/29/04 - fix for bug 3468243 * awarka 12/03/03 - Bug Fix For Issue#3280397 * kchias 11/18/03 - bugfix 3259449 * kchias 10/27/03 - bugfix 3211721 * kchias 10/08/03 - add login to title * shuber 09/30/03 - Use group_flat_memberships * asaras 09/23/03 - fixing bug 3150920 * asaras 07/11/03 - * kchias 03/25/03 - bugfix csv name * kchias 10/29/02 - bugfix 2635634 * kchias 10/14/02 - ui review cleanup * kchias 10/02/02 - ADA compliant * kchias 09/30/02 - * kchias 08/27/02 - kchiasso_ecm_search_aug1902 * * * @author kChiasson * --> <page xmlns="http://bali.us.oracle.com/cabo/baja" xmlns:baja="http://bali.us.oracle.com/cabo/baja" xmlns:marlin="http://bali.us.oracle.com/cabo/marlin" xmlns:uix="http://bali.us.oracle.com/cabo/marlin" xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:data="http://bali.us.oracle.com/cabo/marlin"> <baja:head xmlns="http://bali.us.oracle.com/cabo/marlin" xmlns:uix="http://bali.us.oracle.com/cabo/marlin" xmlns:html="http://www.w3.org/TR/REC-html40"> <dataScope> <contents> <head> <boundAttribute name="title"> <concat> <dataObject select="loginTitle" source="getLoginTitle"/> <fixed javaType="string"> - </fixed> <dataObject select="TITLE_SEARCHOSHWSUMMARIES" source="ResourceBundle"/> </concat> </boundAttribute> </head> </contents> <provider> <data name="getLoginTitle"> <method class="oracle.sysman.eml.ecm.util.EcmSessionUtil" method="getLoginTitle"/> </data> <data name="ResourceBundle"> <bundle class = "oracle.sysman.eml.ecm.search.util.SearchResourceBundle"/> </data> </provider> </dataScope> </baja:head> <!-- special handler to load help topic --> <handlers> <event name="null"> <method class="oracle.sysman.eml.ecm.OnlineHelp" method="loadSearchHelpTopic"/> </event> </handlers> <baja:content xmlns="http://bali.us.oracle.com/cabo/marlin"> <dataScope> <contents> <script> <contents> // clear out the previous selections function clearParams() { with(document.searchOSHWSummaries) { hostNameText.value = ""; domainText.value = ""; OSNameVersionText.value = ""; OSVendorText.value = ""; OSDistVersionText.value = ""; HWSystemConfigText.value = ""; HWMachineArchitectureText.value = ""; HWVendorText.value = ""; HWMemoryText.value = ""; HWDiskText.value = ""; HWClockText.value = ""; HWNumCPUText.value = ""; groupMembershipText.value = ""; } } </contents> </script> <form name="searchOSHWSummaries" > <contents> <formValue name="blockStart" uix:value="blockStart@patchList"/> <formValue name="anchor" uix:value="anchor@patchList"/> <pageLayout xmlns="http://bali.us.oracle.com/cabo/marlin" uix:title="TITLE_SEARCHOSHWSUMMARIES@ResourceBundle"> <mediumAdvertisement> <include baja:node="../../oemBanner" /> </mediumAdvertisement> <marlin:globalButtons> <include baja:node="../../globalButtonBar" /> </marlin:globalButtons> <marlin:tabs> <include baja:node="../../globalTabs" /> </marlin:tabs> <marlin:location> <include baja:node="../../breadCrumbs" /> </marlin:location> <marlin:pageHeader> <include baja:node="../../globalHeader" /> </marlin:pageHeader> <copyright> <include baja:node="../../copyright" /> </copyright> <pageButtons> <pageButtonBar> <contents> <submitButton name="event" value="doSQLSearch" uix:text="BTN_SEARCHSQL@ResourceBundle"/> </contents> </pageButtonBar> </pageButtons> <contents> <messageBox automatic="true" /> <!-- make sure valid patch data --> <switcher uix:childName="status@searchList" childName="success"> <case name="failure"> <messageBox automatic="false" uix:text="errHdr@searchList" uix:message="errMsg@searchList" messageType="error" /> </case> <case name="success"> <stackLayout> <contents> <include baja:node="../../targetTime" /> <header uix:text="HDR_SEARCHCRITERIA@ResourceBundle"> <contents> <tableLayout width="65%" align="center"> <contents> <rowLayout> <contents> <rowLayout hAlign="right"> <contents> <cellFormat wrappingDisabled="true"> <contents> <spacer width="10"/> <styledText labeledNodeId="hostNameID" styleClass="OraPromptText" uix:text="LBL_HOSTNAME@ResourceBundle"/> </contents> </cellFormat> </contents> </rowLayout> <rowLayout hAlign="right"> <contents> <spacer width="10"/> <choice name="hostNameQuery" id="hostNameID" uix:selectedValue="hostNameQuery@searchData"> <contents > <option uix:text="OPT_CONTAINS@ResourceBundle" value="OPT_CONTAINS"/> <option uix:text="OPT_EXACT@ResourceBundle" value="OPT_EXACT"/> <option uix:text="OPT_NOTEXACT@ResourceBundle" value="OPT_NOTEXACT"/> <option uix:text="OPT_NOTCONTAINS@ResourceBundle" value="OPT_NOTCONTAINS"/> </contents> </choice> </contents> </rowLayout> <rowLayout hAlign="left"> <contents> <spacer width="20"/> <textInput required="no" name="hostNameText" id="hostNameID" uix:text="hostNameText@searchData" columns="20"/> </contents> </rowLayout> </contents> </rowLayout> <rowLayout> <contents> <rowLayout hAlign="right"> <contents> <cellFormat wrappingDisabled="true"> <contents> <spacer width="10"/> <styledText labeledNodeId="domainID" styleClass="OraPromptText" uix:text="LBL_DOMAIN@ResourceBundle"/> </contents> </cellFormat> </contents> </rowLayout> <rowLayout hAlign="right"> <contents> <spacer width="10"/> <choice name="domainQuery" id="domainID" uix:selectedValue="domainQuery@searchData"> <contents > <option uix:text="OPT_CONTAINS@ResourceBundle" value="OPT_CONTAINS"/> <option uix:text="OPT_EXACT@ResourceBundle" value="OPT_EXACT"/> <option uix:text="OPT_NOTEXACT@ResourceBundle" value="OPT_NOTEXACT"/> <option uix:text="OPT_NOTCONTAINS@ResourceBundle" value="OPT_NOTCONTAINS"/> </contents> </choice> </contents> </rowLayout> <rowLayout hAlign="left"> <contents> <spacer width="20"/> <textInput required="no" name="domainText" id="domainID" uix:text="domainText@searchData" columns="20"/> </contents> </rowLayout> </contents> </rowLayout> <rowLayout vAlign="top"> <contents> <rowLayout hAlign="right"> <contents> <cellFormat wrappingDisabled="true"> <contents> <spacer width="10"/> <styledText labeledNodeId="groupMembershipID" styleClass="OraPromptText" uix:text="LBL_GROUPNAME@ResourceBundle"/> </contents> </cellFormat> </contents> </rowLayout> <rowLayout hAlign="right"> <contents> <spacer width="10"/> <choice name="groupMembershipQuery" id="groupMembershipID" uix:selectedValue="groupMembershipQuery@searchData"> <contents> <option uix:text="OPT_CONTAINS@ResourceBundle" value="OPT_CONTAINS"/> <option uix:text="OPT_EXACT@ResourceBundle" value="OPT_EXACT"/> <option uix:text="OPT_NOTEXACT@ResourceBundle" value="OPT_NOTEXACT"/> <option uix:text="OPT_NOTCONTAINS@ResourceBundle" value="OPT_NOTCONTAINS"/> </contents> </choice> </contents> </rowLayout> <rowLayout hAlign="left"> <contents> <spacer width="18"/> <messageTextInput required="no" uix:tip="LBL_HOSTGROUPHINT@ResourceBundle" name="groupMembershipText" id="groupMembershipID" uix:text="groupMembershipText@searchData" columns="20"/> </contents> </rowLayout> </contents> </rowLayout> <rowLayout> <contents> <rowLayout hAlign="right"> <contents> <cellFormat wrappingDisabled="true"> <contents> <spacer width="10"/> <styledText labeledNodeId="OSNameVersionID" styleClass="OraPromptText" uix:text="LBL_OSNAMEVERSION@ResourceBundle"/> </contents> </cellFormat> </contents> </rowLayout> <rowLayout hAlign="right"> <contents> <spacer width="10"/> <choice name="OSNameVersionQuery" id="OSNameVersionID" uix:selectedValue="OSNameVersionQuery@searchData"> <contents > <option uix:text="OPT_CONTAINS@ResourceBundle" value="OPT_CONTAINS"/> <option uix:text="OPT_EXACT@ResourceBundle" value="OPT_EXACT"/> <option uix:text="OPT_NOTEXACT@ResourceBundle" value="OPT_NOTEXACT"/> <option uix:text="OPT_NOTCONTAINS@ResourceBundle" value="OPT_NOTCONTAINS"/> </contents> </choice> </contents> </rowLayout> <rowLayout hAlign="left"> <contents> <spacer width="20"/> <textInput required="no" name="OSNameVersionText" id="OSNameVersionID" uix:text="OSNameVersionText@searchData" columns="20"/> </contents> </rowLayout> </contents> </rowLayout> <!--AKS: OS vendor--> <rowLayout> <contents> <rowLayout hAlign="right"> <contents> <cellFormat wrappingDisabled="true"> <contents> <spacer width="10"/> <styledText labeledNodeId="OSVendorID" styleClass="OraPromptText" uix:text="LBL_OSVENDOR@ResourceBundle"/> </contents> </cellFormat> </contents> </rowLayout> <rowLayout hAlign="right"> <contents> <spacer width="10"/> <choice name="OSVendorQuery" id="OSVendorID" uix:selectedValue="OSVendor@searchData"> <contents > <option uix:text="OPT_CONTAINS@ResourceBundle" value="OPT_CONTAINS"/> <option uix:text="OPT_EXACT@ResourceBundle" value="OPT_EXACT"/> <option uix:text="OPT_NOTEXACT@ResourceBundle" value="OPT_NOTEXACT"/> <option uix:text="OPT_NOTCONTAINS@ResourceBundle" value="OPT_NOTCONTAINS"/> </contents> </choice> </contents> </rowLayout> <rowLayout hAlign="left"> <contents> <spacer width="20"/> <textInput required="no" name="OSVendorText" id="OSVendorID" uix:text="OSVendorText@searchData" columns="20"/> </contents> </rowLayout> </contents> </rowLayout> <!--AKS: OS distributor version--> <rowLayout> <contents> <rowLayout hAlign="right"> <contents> <cellFormat wrappingDisabled="true"> <contents> <spacer width="10"/> <styledText labeledNodeId="OSDistVersionID" styleClass="OraPromptText" uix:text="LBL_OSDISTVERSION@ResourceBundle"/> </contents> </cellFormat> </contents> </rowLayout> <rowLayout hAlign="right"> <contents> <spacer width="10"/> <choice name="OSDistVersionQuery" id="OSDistVersionID" uix:selectedValue="OSDistVersionQuery@searchData"> <contents > <option uix:text="OPT_CONTAINS@ResourceBundle" value="OPT_CONTAINS"/> <option uix:text="OPT_EXACT@ResourceBundle" value="OPT_EXACT"/> <option uix:text="OPT_NOTEXACT@ResourceBundle" value="OPT_NOTEXACT"/> <option uix:text="OPT_NOTCONTAINS@ResourceBundle" value="OPT_NOTCONTAINS"/> </contents> </choice> </contents> </rowLayout> <rowLayout hAlign="left"> <contents> <spacer width="20"/> <textInput required="no" name="OSDistVersionText" id="OSDistVersionID" uix:text="OSDistVersionText@searchData" columns="20"/> </contents> </rowLayout> </contents> </rowLayout> <!--AKS: hardware system config--> <rowLayout> <contents> <rowLayout hAlign="right"> <contents> <cellFormat wrappingDisabled="true"> <contents> <spacer width="10"/> <styledText labeledNodeId="HWSystemConfigID" styleClass="OraPromptText" uix:text="HARDWARE_DETAILS.SYSTEM_CONFIGURATION@HCResourceBundle"/> </contents> </cellFormat> </contents> </rowLayout> <rowLayout hAlign="right"> <contents> <spacer width="10"/> <choice name="HWSystemConfigQuery" id="HWSystemConfigID" uix:selectedValue="HWSystemConfigQuery@searchData"> <contents > <option uix:text="OPT_CONTAINS@ResourceBundle" value="OPT_CONTAINS"/> <option uix:text="OPT_EXACT@ResourceBundle" value="OPT_EXACT"/> <option uix:text="OPT_NOTEXACT@ResourceBundle" value="OPT_NOTEXACT"/> <option uix:text="OPT_NOTCONTAINS@ResourceBundle" value="OPT_NOTCONTAINS"/> </contents> </choice> </contents> </rowLayout> <rowLayout hAlign="left"> <contents> <spacer width="20"/> <textInput required="no" name="HWSystemConfigText" id="HWSystemConfigID" uix:text="HWSystemConfigText@searchData" columns="20"/> </contents> </rowLayout> </contents> </rowLayout> <!--AKS: Hardware Machine Architecture Query--> <rowLayout> <contents> <rowLayout hAlign="right"> <contents> <cellFormat wrappingDisabled="true"> <contents> <spacer width="10"/> <styledText labeledNodeId="HWMachineArchitectureID" styleClass="OraPromptText" uix:text="HARDWARE_DETAILS.MACHINE_ARCHITECTURE@HCResourceBundle"/> </contents> </cellFormat> </contents> </rowLayout> <rowLayout hAlign="right"> <contents> <spacer width="10"/> <choice name="HWMachineArchitectureQuery" id="HWMachineArchitectureID" uix:selectedValue="HWMachineArchitectureQuery@searchData"> <contents > <option uix:text="OPT_CONTAINS@ResourceBundle" value="OPT_CONTAINS"/> <option uix:text="OPT_EXACT@ResourceBundle" value="OPT_EXACT"/> <option uix:text="OPT_NOTEXACT@ResourceBundle" value="OPT_NOTEXACT"/> <option uix:text="OPT_NOTCONTAINS@ResourceBundle" value="OPT_NOTCONTAINS"/> </contents> </choice> </contents> </rowLayout> <rowLayout hAlign="left"> <contents> <spacer width="20"/> <textInput required="no" name="HWMachineArchitectureText" id="HWMachineArchitectureID" uix:text="HWMachineArchitectureText@searchData" columns="20"/> </contents> </rowLayout> </contents> </rowLayout> <!--AKS: Hardware Vendor Query--> <rowLayout> <contents> <rowLayout hAlign="right"> <contents> <cellFormat wrappingDisabled="true"> <contents> <spacer width="10"/> <styledText labeledNodeId="HWVendorID" styleClass="OraPromptText" uix:text="HARDWARE_DETAILS.HARDWARE_PROVIDER@HCResourceBundle"/> </contents> </cellFormat> </contents> </rowLayout> <rowLayout hAlign="right"> <contents> <spacer width="10"/> <choice name="HWVendorQuery" id="HWVendorID" uix:selectedValue="HWVendorQuery@searchData"> <contents > <option uix:text="OPT_CONTAINS@ResourceBundle" value="OPT_CONTAINS"/> <option uix:text="OPT_EXACT@ResourceBundle" value="OPT_EXACT"/> <option uix:text="OPT_NOTEXACT@ResourceBundle" value="OPT_NOTEXACT"/> <option uix:text="OPT_NOTCONTAINS@ResourceBundle" value="OPT_NOTCONTAINS"/> </contents> </choice> </contents> </rowLayout> <rowLayout hAlign="left"> <contents> <spacer width="20"/> <textInput required="no" name="HWVendorText" id="HWVendorID" uix:text="HWVendorText@searchData" columns="20"/> </contents> </rowLayout> </contents> </rowLayout> <!--AKS: HW memory size Query--> <rowLayout> <contents> <rowLayout hAlign="right"> <contents> <cellFormat wrappingDisabled="true"> <contents> <spacer width="10"/> <styledText labeledNodeId="HWMemoryID" styleClass="OraPromptText" uix:text="HARDWARE_DETAILS.MEMORY_SIZE_IN_MB@HCResourceBundle"/> </contents> </cellFormat> </contents> </rowLayout> <rowLayout hAlign="right"> <contents> <spacer width="10"/> <choice name="HWMemoryQuery" id="HWMemoryID" uix:selectedValue="HWMemoryQuery@searchData"> <contents > <option uix:text="OPT_LTE@ResourceBundle" value="OPT_LTE"/> <option uix:text="OPT_GTE@ResourceBundle" value="OPT_GTE"/> <option uix:text="OPT_EQ@ResourceBundle" value="OPT_EQ"/> <option uix:text="OPT_NE@ResourceBundle" value="OPT_NE"/> </contents> </choice> </contents> </rowLayout> <rowLayout hAlign="left"> <contents> <spacer width="20"/> <textInput required="no" name="HWMemoryText" id="HWMemoryID" uix:text="HWMemoryText@searchData" columns="20"/> </contents> </rowLayout> </contents> </rowLayout> <!--AKS: HW disk size Query--> <rowLayout> <contents> <rowLayout hAlign="right"> <contents> <cellFormat wrappingDisabled="true"> <contents> <spacer width="10"/> <styledText labeledNodeId="HWDiskID" styleClass="OraPromptText" uix:text="HARDWARE_DETAILS.TOTAL_LOCAL_DISK_SPACE_IN_GB@HCResourceBundle"/> </contents> </cellFormat> </contents> </rowLayout> <rowLayout hAlign="right"> <contents> <spacer width="10"/> <choice name="HWDiskQuery" id="HWDiskID" uix:selectedValue="HWDiskQuery@searchData"> <contents > <option uix:text="OPT_LTE@ResourceBundle" value="OPT_LTE"/> <option uix:text="OPT_GTE@ResourceBundle" value="OPT_GTE"/> <option uix:text="OPT_EQ@ResourceBundle" value="OPT_EQ"/> <option uix:text="OPT_NE@ResourceBundle" value="OPT_NE"/> </contents> </choice> </contents> </rowLayout> <rowLayout hAlign="left"> <contents> <spacer width="20"/> <textInput required="no" name="HWDiskText" id="HWDiskID" uix:text="HWDiskText@searchData" columns="20"/> </contents> </rowLayout> </contents> </rowLayout> <!--AKS: HW clock frequency--> <rowLayout> <contents> <rowLayout hAlign="right"> <contents> <cellFormat wrappingDisabled="true"> <contents> <spacer width="10"/> <styledText labeledNodeId="HWClockID" styleClass="OraPromptText" uix:text="HARDWARE_DETAILS.CLOCK_FREQUENCY_IN_MHZ@HCResourceBundle"/> </contents> </cellFormat> </contents> </rowLayout> <rowLayout hAlign="right"> <contents> <spacer width="10"/> <choice name="HWClockQuery" id="HWClockID" uix:selectedValue="HWClockQuery@searchData"> <contents > <option uix:text="OPT_LTE@ResourceBundle" value="OPT_LTE"/> <option uix:text="OPT_GTE@ResourceBundle" value="OPT_GTE"/> <option uix:text="OPT_EQ@ResourceBundle" value="OPT_EQ"/> <option uix:text="OPT_NE@ResourceBundle" value="OPT_NE"/> </contents> </choice> </contents> </rowLayout> <rowLayout hAlign="left"> <contents> <spacer width="20"/> <textInput required="no" name="HWClockText" id="HWClockID" uix:text="HWClockText@searchData" columns="20"/> </contents> </rowLayout> </contents> </rowLayout> <!--AKS: HW number of CPUS--> <rowLayout> <contents> <rowLayout hAlign="right"> <contents> <cellFormat wrappingDisabled="true"> <contents> <spacer width="10"/> <styledText labeledNodeId="HWNumCPUID" styleClass="OraPromptText" uix:text="SUBCOMPONENT.CPU@HCResourceBundle"/> </contents> </cellFormat> </contents> </rowLayout> <rowLayout hAlign="right"> <contents> <spacer width="10"/> <choice name="HWNumCPUQuery" id="HWNumCPUID" uix:selectedValue="HWNumCPUQuery@searchData"> <contents > <option uix:text="OPT_LTE@ResourceBundle" value="OPT_LTE"/> <option uix:text="OPT_GTE@ResourceBundle" value="OPT_GTE"/> <option uix:text="OPT_EQ@ResourceBundle" value="OPT_EQ"/> <option uix:text="OPT_NE@ResourceBundle" value="OPT_NE"/> </contents> </choice> </contents> </rowLayout> <rowLayout hAlign="left"> <contents> <spacer width="20"/> <textInput required="no" name="HWNumCPUText" id="HWNumCPUID" uix:text="HWNumCPUText@searchData" columns="20"/> </contents> </rowLayout> </contents> </rowLayout> </contents> </tableLayout> </contents> </header> <tableLayout width="45%" > <contents> <spacer height="5"/> <rowLayout hAlign="right"> <contents> <cellFormat wrappingDisabled="true"> <contents> <submitButton name="event" value="doSearch" uix:text="BTN_SEARCH@ResourceBundle"/> <spacer width="8"/> <button uix:text="BTN_CLEAR@ResourceBundle" onClick="clearParams();" /> <spacer width="8"/> </contents> </cellFormat> </contents> </rowLayout> </contents> </tableLayout> <header uix:text="HDR_RESULTS@ResourceBundle"> <contents> <rowLayout hAlign="right"> <contents> <button uix:text="BTN_SAVETOFILE@ResourceBundle" destination="export/exportSearch$searchType=HostOperatingSystemandHardwareSummaries"/> </contents> </rowLayout> <html:br></html:br> <spacer height="5"/> <table name="resultsTable" width="100%" formSubmitted="true" minValue="1" uix:value="value@searchList" uix:maxValue="maxValue@searchList" uix:blockSize="blockSize@searchList" uix:alternateText="MSG_PRESSSEARCH@ResourceBundle" uix:tableData="tabledata@searchList" uix:summary="TBLSUM_RESULTSTABLE@PatchResourceBundle"> <tableFormat tableBanding="rowBanding"/> <columnHeaderStamp> <sortableHeader data:text="text" uix:value="value" uix:sortable="sort"> <boundAttribute name="sortable"> <defaulting> <dataObject data:source="(value)@sortColumnHeader"/> <dataObject select="sort"/> </defaulting> </boundAttribute> </sortableHeader> </columnHeaderStamp> <columnHeaderData> <col id="hdrhostname" uix:text="LBL_HOSTNAME@ResourceBundle" uix:sort="SORT_HOSTNAME@searchList" value="LBL_HOSTNAME"/> <col id="hdrdomain" uix:text="LBL_DOMAIN@ResourceBundle" uix:sort="SORT_DOMAIN@searchList" value="LBL_DOMAIN"/> <col id="hdrosname" uix:text="LBL_OSNAMEVERSION@ResourceBundle" uix:sort="SORT_OSNAMEVERSION@searchList" value="LBL_OSNAMEVERSION"/> <col id="hdrhwconfig" uix:text="LBL_HWCONFIG@ResourceBundle" value="LBL_HWCONFIGMA"/> </columnHeaderData> <contents> <link headers="hdrhostname" uix:text="LBL_HOSTNAME" uix:destination="LBL_HOSTNAME^"/> <styledText headers="hdrdomain" uix:text="LBL_DOMAIN"/> <styledText headers="hdrosname" uix:text="LBL_OSNAMEVERSION"/> <styledText headers="hdrhwconfig" uix:text="LBL_HWCONFIGMA"/> </contents> </table> </contents> </header> </contents> </stackLayout> </case> </switcher> </contents> </pageLayout> </contents> </form> </contents> <provider> <data name="searchCallbackText"> <inline innerQuery="select p.host_name as LBL_HOSTNAME, p.domain as LBL_DOMAIN, (p.OS_SUMMARY || ' ' || decode (p.distributor_version, 'N/A', '', p.distributor_version)) as LBL_OSNAMEVERSION, p.system_config as LBL_HWCONFIG, (p.system_config || ' ' || p.ma || ', ' || p.mem || 'MB RAM' || ', ' || p.disk || 'GB HD' || ', ' || NVL2(p.freq, p.freq || 'MHz FSB, ', '') || p.cpu_count || ' CPUs') as LBL_HWCONFIGMA, p.ma as LBL_MA, p.mem as LBL_MEM, p.disk as LBL_DISK, p.freq as LBL_CLOCK, p.cpu_count as LBL_NUMCPU, p.vendor_name as LBL_VENDOR, p.os_vendor as LBL_OSVENDOR, p.distributor_version as LBL_DISTVERSION from mgmt$os_hw_summary p" distinct="true" /> </data> <data name="columnListInfo"> <inline> <column displayName="LBL_HOSTNAME" destLink="monitoring/hostOverview$target=LBL_HOSTNAME$ctxType=All Targets$type=host?event=doLoad" filterOp="hostNameQuery" filterVal="hostNameText"/> <column displayName="LBL_DOMAIN" filterOp="domainQuery" filterVal="domainText"/> <column displayName="LBL_OSNAMEVERSION" filterOp="OSNameVersionQuery" filterVal="OSNameVersionText"/> <column displayName="LBL_HWCONFIG" filterOp="HWSystemConfigQuery" filterVal="HWSystemConfigText"/> <column displayName="LBL_HWCONFIGMA"/> <column displayName="LBL_MA" selectColumn="false" filterOp="HWMachineArchitectureQuery" filterVal="HWMachineArchitectureText"/> <column displayName="LBL_MEM" selectColumn="false" filterOp="HWMemoryQuery" filterVal="HWMemoryText"/> <column displayName="LBL_DISK" selectColumn="false" filterOp="HWDiskQuery" filterVal="HWDiskText"/> <column displayName="LBL_CLOCK" selectColumn="false" filterOp="HWClockQuery" filterVal="HWClockText"/> <column displayName="LBL_NUMCPU" selectColumn="false" filterOp="HWNumCPUQuery" filterVal="HWNumCPUText"/> <column displayName="LBL_VENDOR" selectColumn="false" filterOp="HWVendorQuery" filterVal="HWVendorText"/> <column displayName="LBL_OSVENDOR" selectColumn="false" filterOp="OSVendorQuery" filterVal="OSVendorText"/> <column displayName="LBL_DISTVERSION" selectColumn="false" filterOp="OSDistVersionQuery" filterVal="OSDistVersionText"/> <column displayName="LBL_GROUPNAME" selectColumn="false" filterOp="groupMembershipQuery" filterVal="groupMembershipText" OPT_CONTAINS="membershipContainsOperator" OPT_NOTCONTAINS="membershipNotContainsOperator" OPT_EXACT="membershipExactOperator" OPT_NOTEXACT="membershipNotExactOperator"/> </inline> </data> <data name="predicateOperatorOverrides"> <inline> <condition name="membershipContainsOperator" predicate="exists (select * from mgmt$group_flat_memberships where disjunction and member_target_name = LBL_HOSTNAME and member_target_type = 'host')" disjunction="NLS_UPPER( composite_target_name ) like NLS_UPPER( '%filterVal%' ) {escape '#'} " /> <condition name="membershipNotContainsOperator" predicate="not exists (select * from mgmt$group_flat_memberships where disjunction and member_target_name = LBL_HOSTNAME and member_target_type = 'host' )" disjunction="NLS_UPPER( composite_target_name ) like NLS_UPPER( '%filterVal%' ) {escape '#'} " /> <condition name="membershipExactOperator" predicate="exists (select * from mgmt$group_flat_memberships where disjunction and member_target_name = LBL_HOSTNAME and member_target_type = 'host')" disjunction="composite_target_name = 'filterVal'" /> <condition name="membershipNotExactOperator" predicate="not exists (select * from mgmt$group_flat_memberships where disjunction and member_target_name = LBL_HOSTNAME and member_target_type = 'host')" disjunction="composite_target_name = 'filterVal'" /> </inline> </data> <data name="ResourceBundle"> <bundle class = "oracle.sysman.eml.ecm.search.util.SearchResourceBundle"/> </data> <data name="PatchResourceBundle"> <bundle class = "oracle.sysman.eml.ecm.patch.util.PatchResourceBundle"/> </data> <data name="HCResourceBundle"> <bundle class="oracle.sysman.eml.ecm.resources.HCResourceBundle"/> </data> <data name="searchData"> <method class="oracle.sysman.eml.ecm.search.SearchData" method="populateSearchData"/> </data> <data xmlns="http://bali.us.oracle.com/cabo/marlin" name="searchList"> <method class="oracle.sysman.eml.ecm.search.SearchData" method="populateResultsTable"/> </data> <data name="sortColumnHeader"> <method class="oracle.sysman.eml.ecm.search.SearchData" method="getSortColumnHeader"/> </data> </provider> </dataScope> </baja:content> <handlers> <event name="sort"> <method class="oracle.sysman.eml.ecm.search.SearchHandler" method="doSort"/> </event> <event name="doSearch"> <method class="oracle.sysman.eml.ecm.search.SearchHandler" method="doSearch"/> </event> <event name="doSQLSearch"> <method class="oracle.sysman.eml.ecm.search.SearchHandler" method="doSQLSearch"/> </event> <!-- This handles the next/prev buttons in the results table --> <event name="goto"> <method class="oracle.sysman.eml.ecm.search.SearchHandler" method ="tableGoto"/> </event> </handlers> </page>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de