Logger::msg("error", array('message' => 'what I got back from the API call was not XML'));
Logger::msg("info", array('report_template_xml' => $report_template_xml));
exit;
}
// Delete the current report templates in the table for this account
$delete_templates = DB::query(Database::DELETE, "DELETE FROM " . REPORT_TEMPLATE_TABLE . " WHERE ACCOUNT = :account")->bind(":account", $account_name)->execute();
Logger::msg("info", array("message" => "deleted report templates", "table" => REPORT_TEMPLATE_TABLE, "account" => $account_name, "rows_deleted" => $delete_templates));
// Put the report template list in the DB
$insert = $insert_model->report_templates($report_template_xml, $account_name);
Logger::msg("info", array("message" => "report templates inserted for account", "table" => REPORT_TEMPLATE_TABLE, "account" => $account_name, "rows_inserted" => $insert));
// Now lets download our reports defined in config/vulndb.php
// Get the reports defined in config/vulndb.php
$report_ids = $vdb_config['adr_reports'][$account_name];
// Go get 'em
$adr_xml = "";
foreach ($report_ids as $report_id) {
Logger::msg("info", array("message" => "downloading asset data report", "report_id" => $report_id, "account" => $account_name, "api_call" => "asset_data_report", "api_version" => 1));
$adr_xml = $api1->asset_data_report($url1, $username, $password, array("template_id" => $report_id));
// Check that we got valid XML
if (!$vulndb->is_xml($adr_xml)) {
Logger::msg("error", array('message' => 'what I got back from the API call was not XML'));
Logger::msg("info", array("asset_data_report_xml" => $adr_xml));
exit;
}
Logger::msg("info", array("message" => "asset data report download sucessful", "report_id" => $report_id, "account" => $account_name, "api_call" => "asset_data_report", "api_version" => 1));
Logger::msg("info", array("message" => "inserting asset data report into vulnDB", "report_id" => $report_id, "account" => $account_name, "api_call" => "asset_data_report", "api_version" => 1));
$insert = $insert_model->asset_data_report($adr_xml, array("account_name" => $account_name, "report_template_id" => $report_id));
Logger::msg("info", array("message" => "asset data report inserted", "report_id" => $report_id, "account" => $account_name, "rows_inserted" => $insert));
}
}
Logger::msg("info", array("message" => "asset data report updater is complete"));
