0){
while($row = mssql_fetch_assoc($result)){
$arrayOfCustomerInformation[] = $row;
}
return $arrayOfCustomerInformation;
}
else {
return 0;
}
}
$query = "select * from wh_account where account_id = '0'";
$myArray = queryToArray($query);
if($myArray != 0 ){
$connectSuccess = 1;
$statusSummaryMessage = "Data Warehouse Connection Success!";
$statusDetailMessage = "You have successfully connected to the Data Warehouse Connection for:
".$myArray[0]['account_name']."\n";
}
else{
$connectSuccess = 0;
$statusSummaryMessage = "Something is wrong.";
$statusDetailMessage = "Please review the settings below, along with your password in connect.php.
If the issues persists, please contact Autotask Support to validate your Data Warehouse settings.";
}
$numAccounts = 0;
$numAccountContacts = 0;
$numResources = 0;
$numProd = 0;
?>
Autotask Data Warehouse Connection Test
