IPAS Resource Utilisation Data

SORRY, THIS IS NO LONGER CONNECTED TO CRIS SERVERS :(

\n"; $connection = oci_connect("APDS","12345678","localhost:1521/PDBORCL"); If (!$connection) { echo "Failed to connect to Oracle
\n"; } else { echo "Succesfully connected with Oracle DB
\n"; } $SD = $_GET['r_u_start']; $ED = $_GET['r_u_end']; echo "$SD AS Start Date $ED AS End Date
\n"; /* $first_name = $_POST['fname']; $last_name = $_POST['lname']; */ /* $sqlget = 'SELECT * FROM ORCL_RESOURCE_UTILISATION WHERE DATE_ID > SD AND DATE_ID < ED'; */ $stid = oci_parse($connection, "SELECT * FROM RESOURCE_UTILISATION_DATA WHERE CPU_USAGE>10"); /* The defines MUST be done before executing */ oci_define_by_name($stid, 'CPU_USAGE', $CPU_USAGE); oci_define_by_name($stid, 'DISK_USAGE', $DISK_USAGE); oci_define_by_name($stid, 'MEMORY_USAGE', $MEMORY_USAGE); oci_define_by_name($stid, 'LOAD_UASAGE', $LOAD_USAGE); oci_define_by_name($stid, 'DATE_ID', $DATE_ID); oci_execute($stid); echo "\n"; echo"\n"; echo"\n"; echo" "; echo" "; echo" "; echo" "; echo" "; echo"\n"; echo"\n"; echo"\n"; /* while ($row = oci_fetch_array($stid, OCI_ASSOC+OCI_RETURN_NULLS)) { echo "\n"; foreach ($row as $item) { echo " \n"; } echo "\n"; } */ echo"\n"; echo "

Date	CPU %	Disk %	Load %	Memory %
" . ($item !== null ? htmlentities($item, ENT_QUOTES) : " ") . "

\n"; echo "$row rows fetched
\n"; ?>