<?xml version="1.0" encoding="UTF-8"?>
<!--
© Copyright 2007 Infor Global Solutions Technology GmbH and/or its affiliates and subsidiaries. All rights reserved. The 
word and design marks set forth herein are trademarks and/or registered trademarks of Infor Global Solutions 
Technology GmbH and/or its affiliates and subsidiaries. All rights reserved. All other trademarks listed herein 
are the property of their respective owners.
 
-->

<!--    *****     Update Log     *****
 
Date           By      Note
6 Jun 2013    LA        New IACM component created, BOD-2337
15th July 2013 Ajayraj BOD 2640-changed the cardinality to 0..* instead of 0..1 for the following elements:
IACM_ApplicationService,IACM_SharedFolderName,IACM_VirtualFolder,IACM_DatabaseServerDrive,IACM_DatabaseServerConfiguration,IACM_TimeConsumingDatabaseQuery
IACM_BlockedDatabaseQuery,IACM_QueryWithMostIO,IACM_DatabaseServerMemoryConsumingTable,IACM_RuleAnalysis
        *****     Update End     *****
 
-->

<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"
    xmlns="http://schema.infor.com/InforOAGIS/2"
    targetNamespace="http://schema.infor.com/InforOAGIS/2" elementFormDefault="qualified"
    attributeFormDefault="unqualified">
    
    <xsd:include schemaLocation="./Components.xsd"/>

    <xsd:complexType name="IACM_ApplicationType">
        <xsd:sequence>
            <xsd:element ref="IACM_ProductName" minOccurs="0"/>
            <xsd:element ref="IACM_ServerLastRebootedDateTime" minOccurs="0"/>
            <xsd:element ref="IACM_InstallPathFolderSize" minOccurs="0"/>
            <xsd:element ref="IACM_ApplicationServices" minOccurs="0"/>
            <xsd:element ref="IACM_Authentication" minOccurs="0"/>
            <xsd:element ref="IACM_SharedFolders" minOccurs="0"/>
            <xsd:element ref="IACM_ProxySettings" minOccurs="0"/>
            <xsd:element ref="IACM_IISSettings" minOccurs="0"/>
            <xsd:element ref="IACM_VirtualFolderSettings" minOccurs="0" />
            <xsd:element ref="IACM_DNSSettings" minOccurs="0" />
        </xsd:sequence>
    </xsd:complexType>
    
    <xsd:complexType name="IACM_DatabaseType">
        <xsd:sequence>
            <xsd:element ref="IACM_ProductName" minOccurs="0"/>
            <xsd:element ref="IACM_DatabaseServerLastRebootedDateTime" minOccurs="0"/>
            <xsd:element ref="IACM_MemoryUsedBySQLServerService" minOccurs="0"/>
            <xsd:element ref="IACM_MemoryUsedBySQLServerAgentService" minOccurs="0"/>
            <xsd:element ref="IACM_DatabaseServerLastBackupDate" minOccurs="0"/>
            <xsd:element ref="IACM_DatabaseServerLastStatisticsAndRebuildActivityDate" minOccurs="0"/>
            <xsd:element ref="IACM_UnusedPartitionCount" minOccurs="0"/>
            <xsd:element ref="IACM_FailedRequestCount" minOccurs="0"/>
            <xsd:element ref="IACM_FailedWhatifCount" minOccurs="0"/>
            <xsd:element ref="IACM_TablesWithMillionIdent" minOccurs="0"/>
            <xsd:element ref="IACM_DatabaseServerAvailableDrives" minOccurs="0"/>
            <xsd:element ref="IACM_MemoryUtilization" minOccurs="0"/>
            <xsd:element ref="IACM_DatabaseUtilization" minOccurs="0"/>
            <xsd:element ref="IACM_TempDatabaseUtilization" minOccurs="0"/>
            <xsd:element ref="IACM_DatabaseServerCurrentProcessStatus" minOccurs="0"/>
            <xsd:element ref="IACM_DatabaseServerSystemConfigurations" minOccurs="0"/>
            <xsd:element ref="IACM_DatabaseServerCPUTimeConsumingQueries" minOccurs="0"/>
            <xsd:element ref="IACM_DatabaseServerQueriesBlockedForLongTime" minOccurs="0"/>
            <xsd:element ref="IACM_DatabaseServerQueriesWithMostIO" minOccurs="0"/>
            <xsd:element ref="IACM_DatabaseServerMemoryConsumingTables" minOccurs="0"/>
            <xsd:element ref="IACM_DatabaseServerDiskUsageByRuleAnalysis" minOccurs="0"/>
        </xsd:sequence>
    </xsd:complexType>
    
    <xsd:element name="IACM_ApplicationServices" type="IACM_ApplicationServicesType">
        <xsd:annotation>
            <xsd:documentation>
                The Application's windows service name, their status, memoy consumed by service and user name under context of which service is running.
            </xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    
    <xsd:complexType name="IACM_ApplicationServicesType">
        <xsd:sequence>
            <xsd:element ref="IACM_ApplicationService" minOccurs="0" maxOccurs="unbounded"/> <!-- BOD2460 -->
        </xsd:sequence>
    </xsd:complexType>
    
    <xsd:element name="IACM_ApplicationService" type="IACM_ApplicationServiceType"/>
    
    <xsd:element name="IACM_Authentication" type="IACM_AuthenticationType">
        <xsd:annotation>
            <xsd:documentation>
                Authenrication used by product like forms, windows or custom if any and its name.
            </xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    
    <xsd:element name="IACM_SharedFolders" type="IACM_SharedFoldersType">
        <xsd:annotation>
            <xsd:documentation>
                Folders shared by Applications. These shared folder gets used during process of data extraction.
            </xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    
    <xsd:element name = "IACM_ProxySettings" type="IACM_ProxySettingsType">
        <xsd:annotation>
            <xsd:documentation>
                proxy setting like proxy client and its status. This node contains single value so max occurence will be 1.
            </xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    
    <xsd:element name="IACM_IISSettings" type="IACM_IISSettingsType">
        <xsd:annotation>
            <xsd:documentation>
                IIS setings like if SSL enabled, anonumous IIS user name or the product and its status. This node will contain single value so max occurence will be 1.
                IACM_SSLEnable gives if IIS is enabled for the HTTPS. and rest of the values contains the single value for the approva continuous monitoring.
                Duplication is not possible here.
            </xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    
    <xsd:element name="IACM_VirtualFolderSettings" type="IACM_VirtualFolderSettingsType">
        <xsd:annotation>
            <xsd:documentation>
                Name of virtual folders of application in IIS, integrated authentication status, status of SSL and anonymous IIS user status
            </xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    
    <xsd:element name="IACM_DNSSettings" type="IACM_DNSSettingsType">
        <xsd:annotation>
            <xsd:documentation>
                DNS settings like host name, IP address, full name and Accessibility
            </xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    
    <xsd:complexType name="IACM_ApplicationServiceType">
        <xsd:sequence>
            <xsd:element ref="IACM_ServiceName" minOccurs="0"/>
            <xsd:element ref="IACM_ServiceStatus" minOccurs="0"/> 
            <xsd:element ref="IACM_ServiceMemoryConsumption" minOccurs="0"/>
            <xsd:element ref="IACM_ServiceLogOnAs" minOccurs="0"/>
        </xsd:sequence>
  </xsd:complexType>
    
    <xsd:complexType name="IACM_AuthenticationType">
        <xsd:sequence>
            <xsd:element ref="IACM_AuthenticationName" minOccurs="0"/>
            <xsd:element ref="IACM_IntegratedWindowsAuthentication" minOccurs="0"/>
            <xsd:element ref="IACM_CustomAuthenticationName" minOccurs="0"/>
        </xsd:sequence>
    </xsd:complexType>
    
    <xsd:complexType name="IACM_SharedFoldersType">
        <xsd:sequence>
            <xsd:element ref="IACM_SharedFolderName" minOccurs="0" maxOccurs="unbounded"/> <!-- BOD2460 -->
        </xsd:sequence>
    </xsd:complexType>
    
    <xsd:complexType name="IACM_ProxySettingsType">
        <xsd:sequence>
            <xsd:element ref="IACM_ProxyServerClient" minOccurs="0"/>
            <xsd:element ref="IACM_ProxyServerStatus" minOccurs="0"/>
        </xsd:sequence>
    </xsd:complexType>
    
    <xsd:complexType name="IACM_IISSettingsType">
        <xsd:sequence>
            <xsd:element ref="IACM_SSLEnable" minOccurs="0"/>
            <xsd:element ref="IACM_AnonymousIISUser" minOccurs="0"/>
            <xsd:element ref="IACM_AnonymousIISUserStatus" minOccurs="0"/>
        </xsd:sequence>
    </xsd:complexType>
    
    <xsd:complexType name="IACM_VirtualFolderSettingsType">
         <xsd:sequence>
             <xsd:element ref="IACM_VirtualFolder" minOccurs="0" maxOccurs="unbounded"/><!-- BOD2460 -->
            </xsd:sequence>
    </xsd:complexType>
    <xsd:element name="IACM_VirtualFolder"  type="IACM_VirtualFolderType"/>
    
    <xsd:complexType name="IACM_VirtualFolderType">
        <xsd:sequence>
            <xsd:element ref="IACM_VirtualFolderName" minOccurs="0"/>
            <xsd:element ref="IACM_IntegratedAuthentication" minOccurs="0"/>
            <xsd:element ref="IACM_SSLEnable" minOccurs="0"/>
            <xsd:element ref="IACM_AnonymousIISUserAccess" minOccurs="0"/>
        </xsd:sequence>
    </xsd:complexType>
    
    <xsd:complexType name="IACM_DNSSettingsType">
        <xsd:sequence>
            <xsd:element ref="IACM_DNSHostName" minOccurs="0"/>
            <xsd:element ref="IACM_DNSIPAddress" minOccurs="0"/>
            <xsd:element ref="IACM_DNSFullName" minOccurs="0"/>
            <xsd:element ref="IACM_DNSAccessibility" minOccurs="0"/>
        </xsd:sequence>
    </xsd:complexType>
    
    <xsd:element name="IACM_TablesWithMillionIdent" type="IACM_TablesWithMillionIdentType">
        <xsd:annotation>
            <xsd:documentation>
                name of table and its current max identity if max identity is more than million.
            </xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:complexType name="IACM_TablesWithMillionIdentType">
        <xsd:sequence>
            <xsd:element ref="IACM_DatabaseTable" minOccurs="0"/>
        </xsd:sequence>
    </xsd:complexType>
    <xsd:element name="IACM_DatabaseTable" type="IACM_DatabaseTableType"/>
    <xsd:complexType name="IACM_DatabaseTableType">
        <xsd:sequence>
            <xsd:element ref="IACM_TableName" minOccurs="0"/>
            <xsd:element ref="IACM_TableCurrentIdentity" minOccurs="0"/>
        </xsd:sequence>
    </xsd:complexType>
    
    <xsd:element name="IACM_DatabaseServerAvailableDrives" type="IACM_DatabaseServerAvailableDrivesType">
        <xsd:annotation>
            <xsd:documentation>
                Name of drives present on the database server, space allocated to that drive and availabe space in that drive .
            </xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:complexType name="IACM_DatabaseServerAvailableDrivesType">
        <xsd:sequence>
            <xsd:element ref="IACM_DatabaseServerDrive" minOccurs="0" maxOccurs="unbounded"/><!-- BOD2460 -->
        </xsd:sequence>
    </xsd:complexType>
    
    <xsd:element name="IACM_DatabaseServerDrive" type="IACM_DatabaseServerDriveType"/>
    
    <xsd:complexType name="IACM_DatabaseServerDriveType">
        <xsd:sequence>
            <xsd:element ref="IACM_DatabaseServerDriveName" minOccurs="0"/>
            <xsd:element ref="IACM_DatabaseServerDriveTotalSpace" minOccurs="0"/>
            <xsd:element ref="IACM_DatabaseServerDriveAvailableSpace" minOccurs="0"/>
        </xsd:sequence>
    </xsd:complexType>
    
    <xsd:element name="IACM_MemoryUtilization" type="IACM_MemoryUtilizationType">
        <xsd:annotation>
            <xsd:documentation>
                Total and physical memory avilable on the database server.
            </xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:complexType name="IACM_MemoryUtilizationType">
        <xsd:sequence>
            <xsd:element ref="IACM_MemoryUtilizationTotalMemory" minOccurs="0"/>
            <xsd:element ref="IACM_MemoryUtilizationAvailableMemory" minOccurs="0"/>
        </xsd:sequence>
    </xsd:complexType>
    
    <xsd:element name="IACM_DatabaseUtilization" type="IACM_DatabaseUtilizationType">
        <xsd:annotation>
            <xsd:documentation>
                Total allocated sapce/size and available space.size of product database.
            </xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:complexType name="IACM_DatabaseUtilizationType">
        <xsd:sequence>
            <xsd:element ref="IACM_DatabaseUtilizationTotalSpace" minOccurs="0"/>
            <xsd:element ref="IACM_DatabaseUtilizationAvailableSpace" minOccurs="0"/>
        </xsd:sequence>
    </xsd:complexType>
    
    <xsd:element name="IACM_TempDatabaseUtilization" type="IACM_TempDatabaseUtilizationType">
        <xsd:annotation>
            <xsd:documentation>
                Total allocated sapce/size and available space/size of temp database.
            </xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:complexType name="IACM_TempDatabaseUtilizationType">
        <xsd:sequence>
            <xsd:element ref="IACM_TempDatabaseUtilizationTotalSpace" minOccurs="0"/>
            <xsd:element ref="IACM_TempDatabaseUtilizationAvailableSpace" minOccurs="0"/>
        </xsd:sequence>
    </xsd:complexType>
    
    <xsd:element name="IACM_DatabaseServerCurrentProcessStatus" type="IACM_DatabaseServerCurrentProcessStatusType">
        <xsd:annotation>
            <xsd:documentation>
                Number of pocesses in running, sleeping and waiting state on the database sever.
            </xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:complexType name="IACM_DatabaseServerCurrentProcessStatusType">
        <xsd:sequence>
            <xsd:element ref="IACM_DatabaseServerNumberOfProcessInRunning" minOccurs="0"/>
            <xsd:element ref="IACM_DatabaseServerNumberOfProcessInSleeping" minOccurs="0"/>
            <xsd:element ref="IACM_DatabaseServerNumberOfProcessInWaiting" minOccurs="0"/>
        </xsd:sequence>
    </xsd:complexType>
    
    <xsd:element name="IACM_DatabaseServerSystemConfigurations" type="IACM_DatabaseServerSystemConfigurationsType">
        <xsd:annotation>
            <xsd:documentation>
                Recommended setting name, recomended value and current value in the database. e.g. 'Collation Name','SQL_Latin1_General_CP1_CI_AS','SQL_Latin1_General_CP1_CI_AS'
            </xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:complexType name="IACM_DatabaseServerSystemConfigurationsType">
        <xsd:sequence>
            <xsd:element ref="IACM_DatabaseServerConfiguration" minOccurs="0" maxOccurs="unbounded"/><!-- BOD2460 -->
        </xsd:sequence>
    </xsd:complexType>
    
    <xsd:element name="IACM_DatabaseServerConfiguration" type="IACM_DatabaseServerConfigurationType"/>
    <xsd:complexType name="IACM_DatabaseServerConfigurationType">
        <xsd:sequence>
            <xsd:element ref="IACM_DatabaseServerConfigurationName" minOccurs="0"/>
            <xsd:element ref="IACM_DatabaseServerRecommendedConfiguration" minOccurs="0"/>
            <xsd:element ref="IACM_DatabaseServerCurrentConfiguration" minOccurs="0"/>
        </xsd:sequence>
    </xsd:complexType>
        
    <xsd:element name="IACM_DatabaseServerCPUTimeConsumingQueries" type="IACM_DatabaseServerCPUTimeConsumingQueriesType">
        <xsd:annotation>
            <xsd:documentation>
                Top 5 Time consuming queries on the product database
            </xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:complexType name="IACM_DatabaseServerCPUTimeConsumingQueriesType">
        <xsd:sequence>
            <xsd:element ref="IACM_TimeConsumingDatabaseQuery" minOccurs="0" maxOccurs="unbounded"/><!-- BOD2460 -->
        </xsd:sequence>
    </xsd:complexType>
    <xsd:element name="IACM_TimeConsumingDatabaseQuery" type="IACM_TimeConsumingDatabaseQueryType"/>
        <xsd:complexType name="IACM_TimeConsumingDatabaseQueryType">
        <xsd:sequence>
            <xsd:element ref="IACM_TimeConsumingDatabaseQueryText" minOccurs="0"/>
            <xsd:element ref="IACM_TimeConsumingDatabaseQueryCPUInPercentage" minOccurs="0"/>
            <xsd:element ref="IACM_TimeConsumingDatabaseQueryWaitingInPercentage" minOccurs="0"/>
            <xsd:element ref="IACM_TimeConsumingDatabaseQueryTotalCPUTime" minOccurs="0"/>
        </xsd:sequence>
    </xsd:complexType>
        
    <xsd:element name="IACM_DatabaseServerQueriesBlockedForLongTime" type="IACM_DatabaseServerQueriesBlockedForLongTimeType">
        <xsd:annotation>
            <xsd:documentation>
                top 5 queries blocked for long time in CPU
            </xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:complexType name="IACM_DatabaseServerQueriesBlockedForLongTimeType">
        <xsd:sequence>
            <xsd:element ref="IACM_BlockedDatabaseQuery" minOccurs="0" maxOccurs="unbounded"/><!-- BOD2460 -->
        </xsd:sequence>
    </xsd:complexType>
    <xsd:element name="IACM_BlockedDatabaseQuery" type="IACM_BlockedDatabaseQueryType"/>
    
    <xsd:complexType name="IACM_BlockedDatabaseQueryType">
        <xsd:sequence>
            <xsd:element ref="IACM_BlockedDatabaseQueryText" minOccurs="0"/>
            <xsd:element ref="IACM_BlockedDatabaseQueryCPUInPercentage" minOccurs="0"/>
            <xsd:element ref="IACM_BlockedDatabaseQueryWaitingInPercentage" minOccurs="0"/>
            <xsd:element ref="IACM_BlockedDatabaseQueryTotalBlockTime" minOccurs="0"/>
        </xsd:sequence>
    </xsd:complexType>
    
    <xsd:element name="IACM_DatabaseServerQueriesWithMostIO" type="IACM_DatabaseServerQueriesWithMostIOType">
        <xsd:annotation>
            <xsd:documentation>
                top 5 queries with most Input/Output operations
            </xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:complexType name="IACM_DatabaseServerQueriesWithMostIOType">
        <xsd:sequence>
            <xsd:element ref="IACM_QueryWithMostIO" minOccurs="0" maxOccurs="unbounded"/><!-- BOD2460 -->
        </xsd:sequence>
    </xsd:complexType>
    <xsd:element name="IACM_QueryWithMostIO" type="IACM_QueryWithMostIOType"/>
    <xsd:complexType name="IACM_QueryWithMostIOType">
        <xsd:sequence>
            <xsd:element ref="IACM_QueryWithMostIOQueryText" minOccurs="0"/>
            <xsd:element ref="IACM_QueryWithMostIOTotalIO" minOccurs="0"/>
        </xsd:sequence>
    </xsd:complexType>
    
    <xsd:element name="IACM_DatabaseServerMemoryConsumingTables" type="IACM_DatabaseServerMemoryConsumingTablesType">
        <xsd:annotation>
            <xsd:documentation>
                name of tables which consumes most of the database space, its total records, total spaced used, spaced used by data, space used by Index and unused space.
            </xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:complexType name="IACM_DatabaseServerMemoryConsumingTablesType">
        <xsd:sequence>
            <xsd:element ref="IACM_DatabaseServerMemoryConsumingTable" minOccurs="0" maxOccurs="unbounded"/><!-- BOD2460 -->
        </xsd:sequence>
    </xsd:complexType>
    <xsd:element name="IACM_DatabaseServerMemoryConsumingTable" type="IACM_DatabaseServerMemoryConsumingTableType"/>
    <xsd:complexType name="IACM_DatabaseServerMemoryConsumingTableType">
        <xsd:sequence>
            <xsd:element ref="IACM_DatabaseServerMemoryConsumingTableName" minOccurs="0"/>
            <xsd:element ref="IACM_DatabaseServerMemoryConsumingTableTotalRecords" minOccurs="0"/>
            <xsd:element ref="IACM_DatabaseServerMemoryConsumingTableTotalSpaceUsed" minOccurs="0"/>
            <xsd:element ref="IACM_DatabaseServerMemoryConsumingTableSpaceUsedByData" minOccurs="0"/>
            <xsd:element ref="IACM_DatabaseServerMemoryConsumingTableSpaceUsedByIndex" minOccurs="0"/>
            <xsd:element ref="IACM_DatabaseServerMemoryConsumingTableUnUsedSpace" minOccurs="0"/>
        </xsd:sequence>
    </xsd:complexType>
    
    <xsd:element name="IACM_DatabaseServerDiskUsageByRuleAnalysis" type="IACM_DatabaseServerDiskUsageByRuleAnalysisType">
        <xsd:annotation>
            <xsd:documentation>
                This contains rule Analsysis(continuous monitoring feature) details like data id, analysis name, total spaced used, spaced used by data, space used by Index and unused space.
            </xsd:documentation>
        </xsd:annotation>
    </xsd:element>
        <xsd:complexType name="IACM_DatabaseServerDiskUsageByRuleAnalysisType">
        <xsd:sequence>
            <xsd:element ref="IACM_RuleAnalysis" minOccurs="0" maxOccurs="unbounded"/><!-- BOD2460 -->
        </xsd:sequence>
    </xsd:complexType>
    <xsd:element name="IACM_RuleAnalysis" type ="IACM_RuleAnalysisType"/>
    <xsd:complexType name="IACM_RuleAnalysisType">
        <xsd:sequence>
            <xsd:element ref="IACM_RuleAnalysisDataID" minOccurs="0"/>
            <xsd:element ref="IACM_AnalysisName" minOccurs="0"/>
            <xsd:element ref="IACM_AnalysisTotalSpaceUsed" minOccurs="0"/>
            <xsd:element ref="IACM_AnalysisSpaceUsedByData" minOccurs="0"/>
            <xsd:element ref="IACM_AnalysisSpaceUsedByIndex" minOccurs="0"/>
            <xsd:element ref="IACM_AnalysisUnUsedSpace" minOccurs="0"/>
        </xsd:sequence>
    </xsd:complexType>
    
    <xsd:element name="IACM_ProductName" type="StringType">
        <xsd:annotation>
            <xsd:documentation>
                This will be name of Product like 'Continuous Monitoring' and 'Certification Manager' as both product resides on same server.
            </xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:element name="IACM_ServerLastRebootedDateTime" type="StringType">
        <xsd:annotation>
            <xsd:documentation>Time when Application server last rebooted.</xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:element name="IACM_InstallPathFolderSize" type="StringType">
        <xsd:annotation>
            <xsd:documentation>Total size of install path folders.</xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:element name="IACM_ServiceName" type="StringType">
        <xsd:annotation>
            <xsd:documentation> Name of product windows service name</xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:element name="IACM_ServiceStatus" type="StringType">
        <xsd:annotation>
            <xsd:documentation>Status of product windows services like started/stopped</xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:element name="IACM_ServiceMemoryConsumption" type="StringType">
        <xsd:annotation>
            <xsd:documentation>Memory consumed by the product windows service</xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:element name="IACM_ServiceLogOnAs"   type="StringType">
        <xsd:annotation>
            <xsd:documentation>User name under which product windows service is running</xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:element name="IACM_AuthenticationName"  type="StringType">
        <xsd:annotation>
            <xsd:documentation>Name of product authentication like AD, CMAS or siteminder</xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    
    <xsd:element name="IACM_IntegratedWindowsAuthentication"  type="StringType">
        <xsd:annotation>
            <xsd:documentation>if Integrated authentication is ON/OFF</xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:element name="IACM_CustomAuthenticationName"  type="StringType">
        <xsd:annotation>
            <xsd:documentation>If custom authentication if any like siteminder.</xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:element name="IACM_SharedFolderName" type="StringType">
        <xsd:annotation>
            <xsd:documentation>
                Name of shared folder of product because If some of the folders are not shared then extaction fails.
            </xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:element name="IACM_ProxyServerClient"  type="StringType">
        <xsd:annotation>
            <xsd:documentation>
                Name of proxy client on the application server.
            </xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:element name="IACM_ProxyServerStatus" type="StringType">
        <xsd:annotation>
            <xsd:documentation>status of proxy server enabled/disabled</xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:element name="IACM_SSLEnable" type="StringType">
        <xsd:annotation>
            <xsd:documentation>If SSL enable in IIS on app server. Max o</xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:element name="IACM_AnonymousIISUser"  type="StringType">
        <xsd:annotation>
            <xsd:documentation>Name of anonymous user for the product approva continuous monitoring</xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:element name="IACM_AnonymousIISUserStatus"  type="StringType">
        <xsd:annotation>
            <xsd:documentation>Status if anonymous user is enabled for the product approva continuous monitoring</xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:element name="IACM_VirtualFolderName" type="StringType">
        <xsd:annotation>
            <xsd:documentation>Name of virtual folders of product</xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:element name="IACM_IntegratedAuthentication"  type="StringType">
        <xsd:annotation>
            <xsd:documentation>Integrated Authentication for the virtual folder true/false</xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:element name="IACM_AnonymousIISUserAccess"  type="StringType">
        <xsd:annotation>
            <xsd:documentation>If anonymous user has access on the virtual folder true/false</xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:element name="IACM_DNSHostName"  type="StringType">
        <xsd:annotation>
            <xsd:documentation>Host name of application server</xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:element name="IACM_DNSIPAddress"  type="StringType">
        <xsd:annotation>
            <xsd:documentation>IP address of the application server</xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:element name="IACM_DNSFullName"  type="StringType">
        <xsd:annotation>
            <xsd:documentation>Full name of the application server</xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:element name="IACM_DNSAccessibility"  type="StringType">
        <xsd:annotation>
            <xsd:documentation>If the application server is accessible. true/false</xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    
    <xsd:element name="IACM_DatabaseServerLastRebootedDateTime" type="StringType">
        <xsd:annotation>
            <xsd:documentation>Time when database server last rebooted.</xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:element name="IACM_MemoryUsedBySQLServerService" type="StringType">
        <xsd:annotation>
            <xsd:documentation>Memory used by sql server service.</xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:element name="IACM_MemoryUsedBySQLServerAgentService" type="StringType">
        <xsd:annotation>
            <xsd:documentation>
                Memory used by sq server agent service.
            </xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:element name="IACM_DatabaseServerLastBackupDate" type="StringType">
        <xsd:annotation>
            <xsd:documentation>
                Last backup date of Product database.
            </xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:element name="IACM_DatabaseServerLastStatisticsAndRebuildActivityDate" type="StringType">
        <xsd:annotation>
            <xsd:documentation>
                Last Statistics and rebuild activity date of product database.
            </xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:element name="IACM_UnusedPartitionCount" type="StringType">
        <xsd:annotation>
            <xsd:documentation>
                Count of unused partitions in the product database.
            </xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:element name="IACM_FailedRequestCount" type="StringType">
        <xsd:annotation>
            <xsd:documentation>
                Count of failed Request in database. Request is one of the feature of Continuous monitoring.
            </xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:element name="IACM_FailedWhatifCount" type="StringType">
        <xsd:annotation>
            <xsd:documentation>
                Count of failed WhatIfs in database. WhatIf is one of the feature of Continuous monitoring.
            </xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:element name="IACM_TableName" type="StringType">
        <xsd:annotation>
            <xsd:documentation>
                Name of the table having identity more than 1 million
            </xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:element name="IACM_TableCurrentIdentity" type="StringType">
        <xsd:annotation>
            <xsd:documentation>
                current identity of the table
            </xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:element name="IACM_DatabaseServerDriveName" type="StringType">
        <xsd:annotation>
            <xsd:documentation>
                Name of the driver on the database server
            </xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:element name="IACM_DatabaseServerDriveTotalSpace" type="StringType">
        <xsd:annotation>
            <xsd:documentation>
                total space allocated to the drive
            </xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:element name="IACM_DatabaseServerDriveAvailableSpace" type="StringType">
        <xsd:annotation>
            <xsd:documentation>
                available space on the drive
            </xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:element name="IACM_MemoryUtilizationTotalMemory" type="StringType">
        <xsd:annotation>
            <xsd:documentation>
                total physical memory on the database server
            </xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:element name="IACM_MemoryUtilizationAvailableMemory" type="StringType">
        <xsd:annotation>
            <xsd:documentation>
                available physical memory on the database server
            </xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:element name="IACM_DatabaseUtilizationTotalSpace" type="StringType">
        <xsd:annotation>
            <xsd:documentation>
                total space allocated to the product databasde
            </xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:element name="IACM_DatabaseUtilizationAvailableSpace" type="StringType">
        <xsd:annotation>
            <xsd:documentation>
                Available space to the product databasde
            </xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:element name="IACM_TempDatabaseUtilizationTotalSpace" type="StringType">
        <xsd:annotation>
            <xsd:documentation>
                total space allocated to the temp databasde
            </xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:element name="IACM_TempDatabaseUtilizationAvailableSpace" type="StringType">
        <xsd:annotation>
            <xsd:documentation>
                available space out of total allocated space to the temp databasde
            </xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:element name="IACM_DatabaseServerNumberOfProcessInRunning" type="StringType">
        <xsd:annotation>
            <xsd:documentation>
                number of running processes in the database server
            </xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:element name="IACM_DatabaseServerNumberOfProcessInSleeping" type="StringType">
        <xsd:annotation>
            <xsd:documentation>
                number of sleeping processes in the database server
            </xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:element name="IACM_DatabaseServerNumberOfProcessInWaiting" type="StringType">
        <xsd:annotation>
            <xsd:documentation>
                number of processes in waiting mode in the database server
            </xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:element name="IACM_DatabaseServerConfigurationName" type="StringType">
        <xsd:annotation>
            <xsd:documentation>
                Confuiguration name recomended for Approva products like 'Recovery Model','CLR Enabled'
            </xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:element name="IACM_DatabaseServerRecommendedConfiguration" type="StringType">
        <xsd:annotation>
            <xsd:documentation>
                recommended value for the settings.
            </xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:element name="IACM_DatabaseServerCurrentConfiguration" type="StringType">
        <xsd:annotation>
            <xsd:documentation>
                current value for the settings.
            </xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:element name="IACM_TimeConsumingDatabaseQueryText" type="StringType">
        <xsd:annotation>
            <xsd:documentation>
                query text which takes more time to get executed.
            </xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:element name="IACM_TimeConsumingDatabaseQueryCPUInPercentage" type="StringType">
        <xsd:annotation>
            <xsd:documentation>
                CPU % to execute the query.
            </xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:element name="IACM_TimeConsumingDatabaseQueryWaitingInPercentage" type="StringType">
        <xsd:annotation>
            <xsd:documentation>
                waiting % to execute the query.
            </xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:element name="IACM_TimeConsumingDatabaseQueryTotalCPUTime" type="StringType">
        <xsd:annotation>
            <xsd:documentation>
                Total CPU time to execute the query.
            </xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:element name="IACM_BlockedDatabaseQueryText" type="StringType">
        <xsd:annotation>
            <xsd:documentation>
                query text which takes more time to get executed.
            </xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:element name="IACM_BlockedDatabaseQueryCPUInPercentage" type="StringType">
        <xsd:annotation>
            <xsd:documentation>
                CPU % to execute the query.
            </xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:element name="IACM_BlockedDatabaseQueryWaitingInPercentage" type="StringType">
        <xsd:annotation>
            <xsd:documentation>
                waiting % to execute the query.
            </xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:element name="IACM_BlockedDatabaseQueryTotalBlockTime" type="StringType">
        <xsd:annotation>
            <xsd:documentation>
                total blocked time for query to get executed.
            </xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:element name="IACM_QueryWithMostIOQueryText" type="StringType">
        <xsd:annotation>
            <xsd:documentation>
                query text which takes more IO to get executed.
            </xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:element name="IACM_QueryWithMostIOTotalIO" type="StringType">
        <xsd:annotation>
            <xsd:documentation>
                Total IO to execute the query
            </xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:element name="IACM_DatabaseServerMemoryConsumingTableName" type="StringType">
        <xsd:annotation>
            <xsd:documentation>
                table name which has consumed more memory
            </xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:element name="IACM_DatabaseServerMemoryConsumingTableTotalRecords" type="StringType">
        <xsd:annotation>
            <xsd:documentation>
                total records in the table
            </xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:element name="IACM_DatabaseServerMemoryConsumingTableTotalSpaceUsed" type="StringType">
        <xsd:annotation>
            <xsd:documentation>
                total spaced used by the table
            </xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:element name="IACM_DatabaseServerMemoryConsumingTableSpaceUsedByData" type="StringType">
        <xsd:annotation>
            <xsd:documentation>
                space used by table data
            </xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:element name="IACM_DatabaseServerMemoryConsumingTableSpaceUsedByIndex" type="StringType">
        <xsd:annotation>
            <xsd:documentation>
                space used by table index
            </xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:element name="IACM_DatabaseServerMemoryConsumingTableUnUsedSpace" type="StringType">
        <xsd:annotation>
            <xsd:documentation>
                unused space
            </xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:element name="IACM_RuleAnalysisDataID" type="StringType">
        <xsd:annotation>
            <xsd:documentation>
                data id of analysis
            </xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:element name="IACM_AnalysisName" type="StringType">
        <xsd:annotation>
            <xsd:documentation>
                Analaysis Name
            </xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:element name="IACM_AnalysisTotalSpaceUsed" type="StringType">
        <xsd:annotation>
            <xsd:documentation>
                total space used by analysis
            </xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:element name="IACM_AnalysisSpaceUsedByData" type="StringType">
        <xsd:annotation>
            <xsd:documentation>
                Space used by analysis data
            </xsd:documentation>
        </xsd:annotation>
    </xsd:element>
    <xsd:element name="IACM_AnalysisSpaceUsedByIndex" type="StringType">
        <xsd:annotation>
            <xsd:documentation>
                Space used by analysis index
            </xsd:documentation>
        </xsd:annotation>
    </xsd:element>
   <xsd:element name="IACM_AnalysisUnUsedSpace" type="StringType">
    <xsd:annotation>
        <xsd:documentation>
            unused space
        </xsd:documentation>
    </xsd:annotation>
    </xsd:element>
    
</xsd:schema>