Comments by jan Meeling (Top 2 by date)

Hi Pete

Thanks for the quick response.

This is the data with it:
backup_server_data_id beheer_server_id backup_server_data_date storage_c_used storage_c_total storage_c_label storage_d_used storage_d_total storage_d_label storage_e_used storage_e_total storage_e_label storage_f_used storage_f_total storage_f_label storage_g_used storage_g_total storage_g_label
1 23 8/25/2020 13:00 24,8 80 OS 80,2 1 SFTP01 36,9 500 SFTP02
2 24 8/25/2020 13:00 24,1 80 OS 63,6 750 SFTP01 55,3 500 SFTP02
3 14 8/25/2020 13:00 56,5 80 OS 72,7 400 WSUS 18,1 200 SFTP
4 27 8/25/2020 13:00 23,1 80 OS 60,0 850 MSFTP
5 29 8/25/2020 13:00 25,5 80 OS 53,4 850 MSFTP
6 33 8/25/2020 13:00 22 100 OS 77 750 SFTP
7 34 8/25/2020 13:00 65.2 80 OS 66.9 500 SFTP

This is the code behind it:
if(strlen($aFetchServerPagina['storage_c_total']) > 0)
{
$oTpl->newBlock("SERVER_DRIVE");
$oTpl->assign(array(
"DATA_DRIVE" => 'C',
"DATA_LABEL" => $oUbb->parse($aFetchServerPagina['storage_c_label']),
"DATA_TOTAL" => $oUbb->parse($aFetchServerPagina['storage_c_total']),
"DATA_USED" => str_replace (',','.',$aFetchServerPagina['storage_c_used'])
));

if($aFetchServerPagina['storage_c_used'] > 75)
{
if($aFetchServerPagina['storage_c_used'] > 90)
{

$oTpl->newBlock("SERVER_DRIVE_CRITICAL");
$oTpl->assign(array(
"DATA_INFO" => $aFetchServerPagina['storage_c_used']
));
}
else{
$oTpl->newBlock("SERVER_DRIVE_WARNING");
$oTpl->assign(array(
"DATA_INFO" => $aFetchServerPagina['storage_c_used']
));
}
}
else{
$oTpl->newBlock("SERVER_DRIVE_OK");
$oTpl->assign(array(
"DATA_INFO" => $aFetchServerPagina['storage_c_used']
));
}
}
and it gets true to drive f
Can this done this class

This is the SQL query:
sQueryServerPagina = "SELECT *,
CONCAT(DATE_FORMAT(backup_server_data_date, '%d'), '-',
DATE_FORMAT(backup_server_data_date, '%m'), '-',
DATE_FORMAT(backup_server_data_date, '%Y'), ' ',
DATE_FORMAT(backup_server_data_date, '%H'), ':',
DATE_FORMAT(backup_server_data_date, '%i')) AS date_check
FROM
backup_server_data
INNER JOIN
beheer_servers
ON
backup_server_data.beheer_server_id = beheer_servers.beheer_servers_id";

Thanks