granicus.if.org Git - icinga2/blob - lib/livestatus/hoststable.cpp

   1 /* Icinga 2 | (c) 2012 Icinga GmbH | GPLv2+ */
   2
   3 #include "livestatus/hoststable.hpp"
   4 #include "livestatus/hostgroupstable.hpp"
   5 #include "livestatus/endpointstable.hpp"
   6 #include "icinga/host.hpp"
   7 #include "icinga/service.hpp"
   8 #include "icinga/hostgroup.hpp"
   9 #include "icinga/checkcommand.hpp"
  10 #include "icinga/eventcommand.hpp"
  11 #include "icinga/timeperiod.hpp"
  12 #include "icinga/macroprocessor.hpp"
  13 #include "icinga/icingaapplication.hpp"
  14 #include "icinga/compatutility.hpp"
  15 #include "icinga/pluginutility.hpp"
  16 #include "base/configtype.hpp"
  17 #include "base/objectlock.hpp"
  18 #include "base/json.hpp"
  19 #include "base/convert.hpp"
  20 #include "base/utility.hpp"
  21 #include <boost/tuple/tuple.hpp>
  22 #include <boost/algorithm/string/replace.hpp>
  23
  24 using namespace icinga;
  25
  26 HostsTable::HostsTable(LivestatusGroupByType type)
  27         :Table(type)
  28 {
  29         AddColumns(this);
  30 }
  31
  32 void HostsTable::AddColumns(Table *table, const String& prefix,
  33         const Column::ObjectAccessor& objectAccessor)
  34 {
  35         table->AddColumn(prefix + "name", Column(&HostsTable::NameAccessor, objectAccessor));
  36         table->AddColumn(prefix + "host_name", Column(&HostsTable::NameAccessor, objectAccessor)); //ugly compatibility hack
  37         table->AddColumn(prefix + "display_name", Column(&HostsTable::DisplayNameAccessor, objectAccessor));
  38         table->AddColumn(prefix + "alias", Column(&HostsTable::DisplayNameAccessor, objectAccessor));
  39         table->AddColumn(prefix + "address", Column(&HostsTable::AddressAccessor, objectAccessor));
  40         table->AddColumn(prefix + "address6", Column(&HostsTable::Address6Accessor, objectAccessor));
  41         table->AddColumn(prefix + "check_command", Column(&HostsTable::CheckCommandAccessor, objectAccessor));
  42         table->AddColumn(prefix + "check_command_expanded", Column(&HostsTable::CheckCommandExpandedAccessor, objectAccessor));
  43         table->AddColumn(prefix + "event_handler", Column(&HostsTable::EventHandlerAccessor, objectAccessor));
  44         table->AddColumn(prefix + "notification_period", Column(&Table::EmptyStringAccessor, objectAccessor));
  45         table->AddColumn(prefix + "check_period", Column(&HostsTable::CheckPeriodAccessor, objectAccessor));
  46         table->AddColumn(prefix + "notes", Column(&HostsTable::NotesAccessor, objectAccessor));
  47         table->AddColumn(prefix + "notes_expanded", Column(&HostsTable::NotesExpandedAccessor, objectAccessor));
  48         table->AddColumn(prefix + "notes_url", Column(&HostsTable::NotesUrlAccessor, objectAccessor));
  49         table->AddColumn(prefix + "notes_url_expanded", Column(&HostsTable::NotesUrlExpandedAccessor, objectAccessor));
  50         table->AddColumn(prefix + "action_url", Column(&HostsTable::ActionUrlAccessor, objectAccessor));
  51         table->AddColumn(prefix + "action_url_expanded", Column(&HostsTable::ActionUrlExpandedAccessor, objectAccessor));
  52         table->AddColumn(prefix + "plugin_output", Column(&HostsTable::PluginOutputAccessor, objectAccessor));
  53         table->AddColumn(prefix + "perf_data", Column(&HostsTable::PerfDataAccessor, objectAccessor));
  54         table->AddColumn(prefix + "icon_image", Column(&HostsTable::IconImageAccessor, objectAccessor));
  55         table->AddColumn(prefix + "icon_image_expanded", Column(&HostsTable::IconImageExpandedAccessor, objectAccessor));
  56         table->AddColumn(prefix + "icon_image_alt", Column(&HostsTable::IconImageAltAccessor, objectAccessor));
  57         table->AddColumn(prefix + "statusmap_image", Column(&Table::EmptyStringAccessor, objectAccessor));
  58         table->AddColumn(prefix + "long_plugin_output", Column(&HostsTable::LongPluginOutputAccessor, objectAccessor));
  59         table->AddColumn(prefix + "initial_state", Column(&Table::EmptyStringAccessor, objectAccessor));
  60         table->AddColumn(prefix + "max_check_attempts", Column(&HostsTable::MaxCheckAttemptsAccessor, objectAccessor));
  61         table->AddColumn(prefix + "flap_detection_enabled", Column(&HostsTable::FlapDetectionEnabledAccessor, objectAccessor));
  62         table->AddColumn(prefix + "check_freshness", Column(&Table::OneAccessor, objectAccessor));
  63         table->AddColumn(prefix + "process_performance_data", Column(&HostsTable::ProcessPerformanceDataAccessor, objectAccessor));
  64         table->AddColumn(prefix + "accept_passive_checks", Column(&HostsTable::AcceptPassiveChecksAccessor, objectAccessor));
  65         table->AddColumn(prefix + "event_handler_enabled", Column(&HostsTable::EventHandlerEnabledAccessor, objectAccessor));
  66         table->AddColumn(prefix + "acknowledgement_type", Column(&HostsTable::AcknowledgementTypeAccessor, objectAccessor));
  67         table->AddColumn(prefix + "check_type", Column(&HostsTable::CheckTypeAccessor, objectAccessor));
  68         table->AddColumn(prefix + "last_state", Column(&HostsTable::LastStateAccessor, objectAccessor));
  69         table->AddColumn(prefix + "last_hard_state", Column(&HostsTable::LastHardStateAccessor, objectAccessor));
  70         table->AddColumn(prefix + "current_attempt", Column(&HostsTable::CurrentAttemptAccessor, objectAccessor));
  71         table->AddColumn(prefix + "last_notification", Column(&HostsTable::LastNotificationAccessor, objectAccessor));
  72         table->AddColumn(prefix + "next_notification", Column(&HostsTable::NextNotificationAccessor, objectAccessor));
  73         table->AddColumn(prefix + "next_check", Column(&HostsTable::NextCheckAccessor, objectAccessor));
  74         table->AddColumn(prefix + "last_hard_state_change", Column(&HostsTable::LastHardStateChangeAccessor, objectAccessor));
  75         table->AddColumn(prefix + "has_been_checked", Column(&HostsTable::HasBeenCheckedAccessor, objectAccessor));
  76         table->AddColumn(prefix + "current_notification_number", Column(&HostsTable::CurrentNotificationNumberAccessor, objectAccessor));
  77         table->AddColumn(prefix + "pending_flex_downtime", Column(&Table::ZeroAccessor, objectAccessor));
  78         table->AddColumn(prefix + "total_services", Column(&HostsTable::TotalServicesAccessor, objectAccessor));
  79         table->AddColumn(prefix + "checks_enabled", Column(&HostsTable::ChecksEnabledAccessor, objectAccessor));
  80         table->AddColumn(prefix + "notifications_enabled", Column(&HostsTable::NotificationsEnabledAccessor, objectAccessor));
  81         table->AddColumn(prefix + "acknowledged", Column(&HostsTable::AcknowledgedAccessor, objectAccessor));
  82         table->AddColumn(prefix + "state", Column(&HostsTable::StateAccessor, objectAccessor));
  83         table->AddColumn(prefix + "state_type", Column(&HostsTable::StateTypeAccessor, objectAccessor));
  84         table->AddColumn(prefix + "no_more_notifications", Column(&HostsTable::NoMoreNotificationsAccessor, objectAccessor));
  85         table->AddColumn(prefix + "check_flapping_recovery_notification", Column(&Table::ZeroAccessor, objectAccessor));
  86         table->AddColumn(prefix + "last_check", Column(&HostsTable::LastCheckAccessor, objectAccessor));
  87         table->AddColumn(prefix + "last_state_change", Column(&HostsTable::LastStateChangeAccessor, objectAccessor));
  88         table->AddColumn(prefix + "last_time_up", Column(&HostsTable::LastTimeUpAccessor, objectAccessor));
  89         table->AddColumn(prefix + "last_time_down", Column(&HostsTable::LastTimeDownAccessor, objectAccessor));
  90         table->AddColumn(prefix + "last_time_unreachable", Column(&HostsTable::LastTimeUnreachableAccessor, objectAccessor));
  91         table->AddColumn(prefix + "is_flapping", Column(&HostsTable::IsFlappingAccessor, objectAccessor));
  92         table->AddColumn(prefix + "scheduled_downtime_depth", Column(&HostsTable::ScheduledDowntimeDepthAccessor, objectAccessor));
  93         table->AddColumn(prefix + "is_executing", Column(&Table::ZeroAccessor, objectAccessor));
  94         table->AddColumn(prefix + "active_checks_enabled", Column(&HostsTable::ActiveChecksEnabledAccessor, objectAccessor));
  95         table->AddColumn(prefix + "check_options", Column(&Table::EmptyStringAccessor, objectAccessor));
  96         table->AddColumn(prefix + "obsess_over_host", Column(&Table::ZeroAccessor, objectAccessor));
  97         table->AddColumn(prefix + "modified_attributes", Column(&Table::ZeroAccessor, objectAccessor));
  98         table->AddColumn(prefix + "modified_attributes_list", Column(&Table::ZeroAccessor, objectAccessor));
  99         table->AddColumn(prefix + "check_interval", Column(&HostsTable::CheckIntervalAccessor, objectAccessor));
 100         table->AddColumn(prefix + "retry_interval", Column(&HostsTable::RetryIntervalAccessor, objectAccessor));
 101         table->AddColumn(prefix + "notification_interval", Column(&HostsTable::NotificationIntervalAccessor, objectAccessor));
 102         table->AddColumn(prefix + "first_notification_delay", Column(&Table::EmptyStringAccessor, objectAccessor));
 103         table->AddColumn(prefix + "low_flap_threshold", Column(&HostsTable::LowFlapThresholdAccessor, objectAccessor));
 104         table->AddColumn(prefix + "high_flap_threshold", Column(&HostsTable::HighFlapThresholdAccessor, objectAccessor));
 105         table->AddColumn(prefix + "x_3d", Column(&EmptyStringAccessor, objectAccessor));
 106         table->AddColumn(prefix + "y_3d", Column(&EmptyStringAccessor, objectAccessor));
 107         table->AddColumn(prefix + "z_3d", Column(&EmptyStringAccessor, objectAccessor));
 108         table->AddColumn(prefix + "x_2d", Column(&Table::EmptyStringAccessor, objectAccessor));
 109         table->AddColumn(prefix + "y_2d", Column(&Table::EmptyStringAccessor, objectAccessor));
 110         table->AddColumn(prefix + "latency", Column(&HostsTable::LatencyAccessor, objectAccessor));
 111         table->AddColumn(prefix + "execution_time", Column(&HostsTable::ExecutionTimeAccessor, objectAccessor));
 112         table->AddColumn(prefix + "percent_state_change", Column(&HostsTable::PercentStateChangeAccessor, objectAccessor));
 113         table->AddColumn(prefix + "in_notification_period", Column(&HostsTable::InNotificationPeriodAccessor, objectAccessor));
 114         table->AddColumn(prefix + "in_check_period", Column(&HostsTable::InCheckPeriodAccessor, objectAccessor));
 115         table->AddColumn(prefix + "contacts", Column(&HostsTable::ContactsAccessor, objectAccessor));
 116         table->AddColumn(prefix + "downtimes", Column(&HostsTable::DowntimesAccessor, objectAccessor));
 117         table->AddColumn(prefix + "downtimes_with_info", Column(&HostsTable::DowntimesWithInfoAccessor, objectAccessor));
 118         table->AddColumn(prefix + "comments", Column(&HostsTable::CommentsAccessor, objectAccessor));
 119         table->AddColumn(prefix + "comments_with_info", Column(&HostsTable::CommentsWithInfoAccessor, objectAccessor));
 120         table->AddColumn(prefix + "comments_with_extra_info", Column(&HostsTable::CommentsWithExtraInfoAccessor, objectAccessor));
 121         table->AddColumn(prefix + "custom_variable_names", Column(&HostsTable::CustomVariableNamesAccessor, objectAccessor));
 122         table->AddColumn(prefix + "custom_variable_values", Column(&HostsTable::CustomVariableValuesAccessor, objectAccessor));
 123         table->AddColumn(prefix + "custom_variables", Column(&HostsTable::CustomVariablesAccessor, objectAccessor));
 124         table->AddColumn(prefix + "filename", Column(&Table::EmptyStringAccessor, objectAccessor));
 125         table->AddColumn(prefix + "parents", Column(&HostsTable::ParentsAccessor, objectAccessor));
 126         table->AddColumn(prefix + "childs", Column(&HostsTable::ChildsAccessor, objectAccessor));
 127         table->AddColumn(prefix + "num_services", Column(&HostsTable::NumServicesAccessor, objectAccessor));
 128         table->AddColumn(prefix + "worst_service_state", Column(&HostsTable::WorstServiceStateAccessor, objectAccessor));
 129         table->AddColumn(prefix + "num_services_ok", Column(&HostsTable::NumServicesOkAccessor, objectAccessor));
 130         table->AddColumn(prefix + "num_services_warn", Column(&HostsTable::NumServicesWarnAccessor, objectAccessor));
 131         table->AddColumn(prefix + "num_services_crit", Column(&HostsTable::NumServicesCritAccessor, objectAccessor));
 132         table->AddColumn(prefix + "num_services_unknown", Column(&HostsTable::NumServicesUnknownAccessor, objectAccessor));
 133         table->AddColumn(prefix + "num_services_pending", Column(&HostsTable::NumServicesPendingAccessor, objectAccessor));
 134         table->AddColumn(prefix + "worst_service_hard_state", Column(&HostsTable::WorstServiceHardStateAccessor, objectAccessor));
 135         table->AddColumn(prefix + "num_services_hard_ok", Column(&HostsTable::NumServicesHardOkAccessor, objectAccessor));
 136         table->AddColumn(prefix + "num_services_hard_warn", Column(&HostsTable::NumServicesHardWarnAccessor, objectAccessor));
 137         table->AddColumn(prefix + "num_services_hard_crit", Column(&HostsTable::NumServicesHardCritAccessor, objectAccessor));
 138         table->AddColumn(prefix + "num_services_hard_unknown", Column(&HostsTable::NumServicesHardUnknownAccessor, objectAccessor));
 139         table->AddColumn(prefix + "hard_state", Column(&HostsTable::HardStateAccessor, objectAccessor));
 140         table->AddColumn(prefix + "pnpgraph_present", Column(&Table::ZeroAccessor, objectAccessor));
 141         table->AddColumn(prefix + "staleness", Column(&HostsTable::StalenessAccessor, objectAccessor));
 142         table->AddColumn(prefix + "groups", Column(&HostsTable::GroupsAccessor, objectAccessor));
 143         table->AddColumn(prefix + "contact_groups", Column(&HostsTable::ContactGroupsAccessor, objectAccessor));
 144         table->AddColumn(prefix + "services", Column(&HostsTable::ServicesAccessor, objectAccessor));
 145         table->AddColumn(prefix + "services_with_state", Column(&HostsTable::ServicesWithStateAccessor, objectAccessor));
 146         table->AddColumn(prefix + "services_with_info", Column(&HostsTable::ServicesWithInfoAccessor, objectAccessor));
 147         table->AddColumn(prefix + "check_source", Column(&HostsTable::CheckSourceAccessor, objectAccessor));
 148         table->AddColumn(prefix + "is_reachable", Column(&HostsTable::IsReachableAccessor, objectAccessor));
 149         table->AddColumn(prefix + "cv_is_json", Column(&HostsTable::CVIsJsonAccessor, objectAccessor));
 150         table->AddColumn(prefix + "original_attributes", Column(&HostsTable::OriginalAttributesAccessor, objectAccessor));
 151
 152         /* add additional group by values received through the object accessor */
 153         if (table->GetGroupByType() == LivestatusGroupByHostGroup) {
 154                 /* _1 = row, _2 = groupByType, _3 = groupByObject */
 155                 Log(LogDebug, "Livestatus")
 156                         << "Processing hosts group by hostgroup table.";
 157                 HostGroupsTable::AddColumns(table, "hostgroup_", std::bind(&HostsTable::HostGroupAccessor, _1, _2, _3));
 158         }
 159 }
 160
 161 String HostsTable::GetName() const
 162 {
 163         return "hosts";
 164 }
 165
 166 String HostsTable::GetPrefix() const
 167 {
 168         return "host";
 169 }
 170
 171 void HostsTable::FetchRows(const AddRowFunction& addRowFn)
 172 {
 173         if (GetGroupByType() == LivestatusGroupByHostGroup) {
 174                 for (const HostGroup::Ptr& hg : ConfigType::GetObjectsByType<HostGroup>()) {
 175                         for (const Host::Ptr& host : hg->GetMembers()) {
 176                                 /* the caller must know which groupby type and value are set for this row */
 177                                 if (!addRowFn(host, LivestatusGroupByHostGroup, hg))
 178                                         return;
 179                         }
 180                 }
 181         } else {
 182                 for (const Host::Ptr& host : ConfigType::GetObjectsByType<Host>()) {
 183                         if (!addRowFn(host, LivestatusGroupByNone, Empty))
 184                                 return;
 185                 }
 186         }
 187 }
 188
 189 Object::Ptr HostsTable::HostGroupAccessor(const Value& row, LivestatusGroupByType groupByType, const Object::Ptr& groupByObject)
 190 {
 191         /* return the current group by value set from within FetchRows()
 192          * this is the hostgrouo object used for the table join inside
 193          * in AddColumns()
 194          */
 195         if (groupByType == LivestatusGroupByHostGroup)
 196                 return groupByObject;
 197
 198         return nullptr;
 199 }
 200
 201 Value HostsTable::NameAccessor(const Value& row)
 202 {
 203         Host::Ptr host = static_cast<Host::Ptr>(row);
 204
 205         if (!host)
 206                 return Empty;
 207
 208         return host->GetName();
 209 }
 210
 211 Value HostsTable::DisplayNameAccessor(const Value& row)
 212 {
 213         Host::Ptr host = static_cast<Host::Ptr>(row);
 214
 215         if (!host)
 216                 return Empty;
 217
 218         return host->GetDisplayName();
 219 }
 220
 221 Value HostsTable::AddressAccessor(const Value& row)
 222 {
 223         Host::Ptr host = static_cast<Host::Ptr>(row);
 224
 225         if (!host)
 226                 return Empty;
 227
 228         return host->GetAddress();
 229 }
 230
 231 Value HostsTable::Address6Accessor(const Value& row)
 232 {
 233         Host::Ptr host = static_cast<Host::Ptr>(row);
 234
 235         if (!host)
 236                 return Empty;
 237
 238         return host->GetAddress6();
 239 }
 240
 241 Value HostsTable::CheckCommandAccessor(const Value& row)
 242 {
 243         Host::Ptr host = static_cast<Host::Ptr>(row);
 244
 245         if (!host)
 246                 return Empty;
 247
 248         CheckCommand::Ptr checkcommand = host->GetCheckCommand();
 249         if (checkcommand)
 250                 return CompatUtility::GetCommandName(checkcommand) + "!" + CompatUtility::GetCheckableCommandArgs(host);
 251
 252         return Empty;
 253 }
 254
 255 Value HostsTable::CheckCommandExpandedAccessor(const Value& row)
 256 {
 257         Host::Ptr host = static_cast<Host::Ptr>(row);
 258
 259         if (!host)
 260                 return Empty;
 261
 262         CheckCommand::Ptr checkcommand = host->GetCheckCommand();
 263         if (checkcommand)
 264                 return CompatUtility::GetCommandName(checkcommand) + "!" + CompatUtility::GetCheckableCommandArgs(host);
 265
 266         return Empty;
 267 }
 268
 269 Value HostsTable::EventHandlerAccessor(const Value& row)
 270 {
 271         Host::Ptr host = static_cast<Host::Ptr>(row);
 272
 273         if (!host)
 274                 return Empty;
 275
 276         EventCommand::Ptr eventcommand = host->GetEventCommand();
 277         if (eventcommand)
 278                 return CompatUtility::GetCommandName(eventcommand);
 279
 280         return Empty;
 281 }
 282
 283 Value HostsTable::CheckPeriodAccessor(const Value& row)
 284 {
 285         Host::Ptr host = static_cast<Host::Ptr>(row);
 286
 287         if (!host)
 288                 return Empty;
 289
 290         TimePeriod::Ptr checkPeriod = host->GetCheckPeriod();
 291
 292         if (!checkPeriod)
 293                 return Empty;
 294
 295         return checkPeriod->GetName();
 296 }
 297
 298 Value HostsTable::NotesAccessor(const Value& row)
 299 {
 300         Host::Ptr host = static_cast<Host::Ptr>(row);
 301
 302         if (!host)
 303                 return Empty;
 304
 305         return host->GetNotes();
 306 }
 307
 308 Value HostsTable::NotesExpandedAccessor(const Value& row)
 309 {
 310         Host::Ptr host = static_cast<Host::Ptr>(row);
 311
 312         if (!host)
 313                 return Empty;
 314
 315         MacroProcessor::ResolverList resolvers {
 316                 { "host", host },
 317                 { "icinga", IcingaApplication::GetInstance() }
 318         };
 319
 320         return MacroProcessor::ResolveMacros(host->GetNotes(), resolvers);
 321 }
 322
 323 Value HostsTable::NotesUrlAccessor(const Value& row)
 324 {
 325         Host::Ptr host = static_cast<Host::Ptr>(row);
 326
 327         if (!host)
 328                 return Empty;
 329
 330         return host->GetNotesUrl();
 331 }
 332
 333 Value HostsTable::NotesUrlExpandedAccessor(const Value& row)
 334 {
 335         Host::Ptr host = static_cast<Host::Ptr>(row);
 336
 337         if (!host)
 338                 return Empty;
 339
 340         MacroProcessor::ResolverList resolvers {
 341                 { "host", host },
 342                 { "icinga", IcingaApplication::GetInstance() }
 343         };
 344
 345         return MacroProcessor::ResolveMacros(host->GetNotesUrl(), resolvers);
 346 }
 347
 348 Value HostsTable::ActionUrlAccessor(const Value& row)
 349 {
 350         Host::Ptr host = static_cast<Host::Ptr>(row);
 351
 352         if (!host)
 353                 return Empty;
 354
 355         return host->GetActionUrl();
 356 }
 357
 358 Value HostsTable::ActionUrlExpandedAccessor(const Value& row)
 359 {
 360         Host::Ptr host = static_cast<Host::Ptr>(row);
 361
 362         if (!host)
 363                 return Empty;
 364
 365         MacroProcessor::ResolverList resolvers {
 366                 { "host", host },
 367                 { "icinga", IcingaApplication::GetInstance() }
 368         };
 369
 370         return MacroProcessor::ResolveMacros(host->GetActionUrl(), resolvers);
 371 }
 372
 373 Value HostsTable::PluginOutputAccessor(const Value& row)
 374 {
 375         Host::Ptr host = static_cast<Host::Ptr>(row);
 376
 377         if (!host)
 378                 return Empty;
 379
 380         String output;
 381         CheckResult::Ptr cr = host->GetLastCheckResult();
 382
 383         if (cr)
 384                 output = CompatUtility::GetCheckResultOutput(cr);
 385
 386         return output;
 387 }
 388
 389 Value HostsTable::PerfDataAccessor(const Value& row)
 390 {
 391         Host::Ptr host = static_cast<Host::Ptr>(row);
 392
 393         if (!host)
 394                 return Empty;
 395
 396         String perfdata;
 397         CheckResult::Ptr cr = host->GetLastCheckResult();
 398
 399         if (!cr)
 400                 return Empty;
 401
 402         return PluginUtility::FormatPerfdata(cr->GetPerformanceData());
 403 }
 404
 405 Value HostsTable::IconImageAccessor(const Value& row)
 406 {
 407         Host::Ptr host = static_cast<Host::Ptr>(row);
 408
 409         if (!host)
 410                 return Empty;
 411
 412         return host->GetIconImage();
 413 }
 414
 415 Value HostsTable::IconImageExpandedAccessor(const Value& row)
 416 {
 417         Host::Ptr host = static_cast<Host::Ptr>(row);
 418
 419         if (!host)
 420                 return Empty;
 421
 422         MacroProcessor::ResolverList resolvers {
 423                 { "host", host },
 424                 { "icinga", IcingaApplication::GetInstance() }
 425         };
 426
 427         return MacroProcessor::ResolveMacros(host->GetIconImage(), resolvers);
 428 }
 429
 430 Value HostsTable::IconImageAltAccessor(const Value& row)
 431 {
 432         Host::Ptr host = static_cast<Host::Ptr>(row);
 433
 434         if (!host)
 435                 return Empty;
 436
 437         return host->GetIconImageAlt();
 438 }
 439
 440 Value HostsTable::LongPluginOutputAccessor(const Value& row)
 441 {
 442         Host::Ptr host = static_cast<Host::Ptr>(row);
 443
 444         if (!host)
 445                 return Empty;
 446
 447         String long_output;
 448         CheckResult::Ptr cr = host->GetLastCheckResult();
 449
 450         if (cr)
 451                 long_output = CompatUtility::GetCheckResultLongOutput(cr);
 452
 453         return long_output;
 454 }
 455
 456 Value HostsTable::MaxCheckAttemptsAccessor(const Value& row)
 457 {
 458         Host::Ptr host = static_cast<Host::Ptr>(row);
 459
 460         if (!host)
 461                 return Empty;
 462
 463         return host->GetMaxCheckAttempts();
 464 }
 465
 466 Value HostsTable::FlapDetectionEnabledAccessor(const Value& row)
 467 {
 468         Host::Ptr host = static_cast<Host::Ptr>(row);
 469
 470         if (!host)
 471                 return Empty;
 472
 473         return Convert::ToLong(host->GetEnableFlapping());
 474 }
 475
 476 Value HostsTable::AcceptPassiveChecksAccessor(const Value& row)
 477 {
 478         Host::Ptr host = static_cast<Host::Ptr>(row);
 479
 480         if (!host)
 481                 return Empty;
 482
 483         return Convert::ToLong(host->GetEnablePassiveChecks());
 484 }
 485
 486 Value HostsTable::EventHandlerEnabledAccessor(const Value& row)
 487 {
 488         Host::Ptr host = static_cast<Host::Ptr>(row);
 489
 490         if (!host)
 491                 return Empty;
 492
 493         return Convert::ToLong(host->GetEnableEventHandler());
 494 }
 495
 496 Value HostsTable::AcknowledgementTypeAccessor(const Value& row)
 497 {
 498         Host::Ptr host = static_cast<Host::Ptr>(row);
 499
 500         if (!host)
 501                 return Empty;
 502
 503         ObjectLock olock(host);
 504         return host->GetAcknowledgement();
 505 }
 506
 507 Value HostsTable::CheckTypeAccessor(const Value& row)
 508 {
 509         Host::Ptr host = static_cast<Host::Ptr>(row);
 510
 511         if (!host)
 512                 return Empty;
 513
 514         return (host->GetEnableActiveChecks() ? 0 : 1); /* 0 .. active, 1 .. passive */
 515 }
 516
 517 Value HostsTable::LastStateAccessor(const Value& row)
 518 {
 519         Host::Ptr host = static_cast<Host::Ptr>(row);
 520
 521         if (!host)
 522                 return Empty;
 523
 524         return host->GetLastState();
 525 }
 526
 527 Value HostsTable::LastHardStateAccessor(const Value& row)
 528 {
 529         Host::Ptr host = static_cast<Host::Ptr>(row);
 530
 531         if (!host)
 532                 return Empty;
 533
 534         return host->GetLastHardState();
 535 }
 536
 537 Value HostsTable::CurrentAttemptAccessor(const Value& row)
 538 {
 539         Host::Ptr host = static_cast<Host::Ptr>(row);
 540
 541         if (!host)
 542                 return Empty;
 543
 544         return host->GetCheckAttempt();
 545 }
 546
 547 Value HostsTable::LastNotificationAccessor(const Value& row)
 548 {
 549         Host::Ptr host = static_cast<Host::Ptr>(row);
 550
 551         if (!host)
 552                 return Empty;
 553
 554         return CompatUtility::GetCheckableNotificationLastNotification(host);
 555 }
 556
 557 Value HostsTable::NextNotificationAccessor(const Value& row)
 558 {
 559         Host::Ptr host = static_cast<Host::Ptr>(row);
 560
 561         if (!host)
 562                 return Empty;
 563
 564         return CompatUtility::GetCheckableNotificationNextNotification(host);
 565 }
 566
 567 Value HostsTable::NextCheckAccessor(const Value& row)
 568 {
 569         Host::Ptr host = static_cast<Host::Ptr>(row);
 570
 571         if (!host)
 572                 return Empty;
 573
 574         return static_cast<int>(host->GetNextCheck());
 575 }
 576
 577 Value HostsTable::LastHardStateChangeAccessor(const Value& row)
 578 {
 579         Host::Ptr host = static_cast<Host::Ptr>(row);
 580
 581         if (!host)
 582                 return Empty;
 583
 584         return static_cast<int>(host->GetLastHardStateChange());
 585 }
 586
 587 Value HostsTable::HasBeenCheckedAccessor(const Value& row)
 588 {
 589         Host::Ptr host = static_cast<Host::Ptr>(row);
 590
 591         if (!host)
 592                 return Empty;
 593
 594         return Convert::ToLong(host->HasBeenChecked());
 595 }
 596
 597 Value HostsTable::CurrentNotificationNumberAccessor(const Value& row)
 598 {
 599         Host::Ptr host = static_cast<Host::Ptr>(row);
 600
 601         if (!host)
 602                 return Empty;
 603
 604         return CompatUtility::GetCheckableNotificationNotificationNumber(host);
 605 }
 606
 607 Value HostsTable::TotalServicesAccessor(const Value& row)
 608 {
 609         Host::Ptr host = static_cast<Host::Ptr>(row);
 610
 611         if (!host)
 612                 return Empty;
 613
 614         return host->GetTotalServices();
 615 }
 616
 617 Value HostsTable::ChecksEnabledAccessor(const Value& row)
 618 {
 619         Host::Ptr host = static_cast<Host::Ptr>(row);
 620
 621         if (!host)
 622                 return Empty;
 623
 624         return Convert::ToLong(host->GetEnableActiveChecks());
 625 }
 626
 627 Value HostsTable::NotificationsEnabledAccessor(const Value& row)
 628 {
 629         Host::Ptr host = static_cast<Host::Ptr>(row);
 630
 631         if (!host)
 632                 return Empty;
 633
 634         return Convert::ToLong(host->GetEnableNotifications());
 635 }
 636
 637 Value HostsTable::ProcessPerformanceDataAccessor(const Value& row)
 638 {
 639         Host::Ptr host = static_cast<Host::Ptr>(row);
 640
 641         if (!host)
 642                 return Empty;
 643
 644         return Convert::ToLong(host->GetEnablePerfdata());
 645 }
 646
 647 Value HostsTable::AcknowledgedAccessor(const Value& row)
 648 {
 649         Host::Ptr host = static_cast<Host::Ptr>(row);
 650
 651         if (!host)
 652                 return Empty;
 653
 654         ObjectLock olock(host);
 655         return host->IsAcknowledged();
 656 }
 657
 658 Value HostsTable::StateAccessor(const Value& row)
 659 {
 660         Host::Ptr host = static_cast<Host::Ptr>(row);
 661
 662         if (!host)
 663                 return Empty;
 664
 665         return host->IsReachable() ? host->GetState() : 2;
 666 }
 667
 668 Value HostsTable::StateTypeAccessor(const Value& row)
 669 {
 670         Host::Ptr host = static_cast<Host::Ptr>(row);
 671
 672         if (!host)
 673                 return Empty;
 674
 675         return host->GetStateType();
 676 }
 677
 678 Value HostsTable::NoMoreNotificationsAccessor(const Value& row)
 679 {
 680         Host::Ptr host = static_cast<Host::Ptr>(row);
 681
 682         if (!host)
 683                 return Empty;
 684
 685         return (CompatUtility::GetCheckableNotificationNotificationInterval(host) == 0 && !host->GetVolatile()) ? 1 : 0;
 686 }
 687
 688 Value HostsTable::LastCheckAccessor(const Value& row)
 689 {
 690         Host::Ptr host = static_cast<Host::Ptr>(row);
 691
 692         if (!host)
 693                 return Empty;
 694
 695         return static_cast<int>(host->GetLastCheck());
 696 }
 697
 698 Value HostsTable::LastStateChangeAccessor(const Value& row)
 699 {
 700         Host::Ptr host = static_cast<Host::Ptr>(row);
 701
 702         if (!host)
 703                 return Empty;
 704
 705         return static_cast<int>(host->GetLastStateChange());
 706 }
 707
 708 Value HostsTable::LastTimeUpAccessor(const Value& row)
 709 {
 710         Host::Ptr host = static_cast<Host::Ptr>(row);
 711
 712         if (!host)
 713                 return Empty;
 714
 715         return static_cast<int>(host->GetLastStateUp());
 716 }
 717
 718 Value HostsTable::LastTimeDownAccessor(const Value& row)
 719 {
 720         Host::Ptr host = static_cast<Host::Ptr>(row);
 721
 722         if (!host)
 723                 return Empty;
 724
 725         return static_cast<int>(host->GetLastStateDown());
 726 }
 727
 728 Value HostsTable::LastTimeUnreachableAccessor(const Value& row)
 729 {
 730         Host::Ptr host = static_cast<Host::Ptr>(row);
 731
 732         if (!host)
 733                 return Empty;
 734
 735         return static_cast<int>(host->GetLastStateUnreachable());
 736 }
 737
 738 Value HostsTable::IsFlappingAccessor(const Value& row)
 739 {
 740         Host::Ptr host = static_cast<Host::Ptr>(row);
 741
 742         if (!host)
 743                 return Empty;
 744
 745         return host->IsFlapping();
 746 }
 747
 748 Value HostsTable::ScheduledDowntimeDepthAccessor(const Value& row)
 749 {
 750         Host::Ptr host = static_cast<Host::Ptr>(row);
 751
 752         if (!host)
 753                 return Empty;
 754
 755         return host->GetDowntimeDepth();
 756 }
 757
 758 Value HostsTable::ActiveChecksEnabledAccessor(const Value& row)
 759 {
 760         Host::Ptr host = static_cast<Host::Ptr>(row);
 761
 762         if (!host)
 763                 return Empty;
 764
 765         return Convert::ToLong(host->GetEnableActiveChecks());
 766 }
 767
 768 Value HostsTable::CheckIntervalAccessor(const Value& row)
 769 {
 770         Host::Ptr host = static_cast<Host::Ptr>(row);
 771
 772         if (!host)
 773                 return Empty;
 774
 775         return host->GetCheckInterval() / 60.0;
 776 }
 777
 778 Value HostsTable::RetryIntervalAccessor(const Value& row)
 779 {
 780         Host::Ptr host = static_cast<Host::Ptr>(row);
 781
 782         if (!host)
 783                 return Empty;
 784
 785         return host->GetRetryInterval() / 60.0;
 786 }
 787
 788 Value HostsTable::NotificationIntervalAccessor(const Value& row)
 789 {
 790         Host::Ptr host = static_cast<Host::Ptr>(row);
 791
 792         if (!host)
 793                 return Empty;
 794
 795         return CompatUtility::GetCheckableNotificationNotificationInterval(host);
 796 }
 797
 798 Value HostsTable::LowFlapThresholdAccessor(const Value& row)
 799 {
 800         Host::Ptr host = static_cast<Host::Ptr>(row);
 801
 802         if (!host)
 803                 return Empty;
 804
 805         return host->GetFlappingThresholdLow();
 806 }
 807
 808 Value HostsTable::HighFlapThresholdAccessor(const Value& row)
 809 {
 810         Host::Ptr host = static_cast<Host::Ptr>(row);
 811
 812         if (!host)
 813                 return Empty;
 814
 815         return host->GetFlappingThresholdHigh();
 816 }
 817
 818 Value HostsTable::LatencyAccessor(const Value& row)
 819 {
 820         Host::Ptr host = static_cast<Host::Ptr>(row);
 821
 822         if (!host)
 823                 return Empty;
 824
 825         CheckResult::Ptr cr = host->GetLastCheckResult();
 826
 827         if (!cr)
 828                 return Empty;
 829
 830         return cr->CalculateLatency();
 831 }
 832
 833 Value HostsTable::ExecutionTimeAccessor(const Value& row)
 834 {
 835         Host::Ptr host = static_cast<Host::Ptr>(row);
 836
 837         if (!host)
 838                 return Empty;
 839
 840         CheckResult::Ptr cr = host->GetLastCheckResult();
 841
 842         if (!cr)
 843                 return Empty;
 844
 845         return cr->CalculateExecutionTime();
 846 }
 847
 848 Value HostsTable::PercentStateChangeAccessor(const Value& row)
 849 {
 850         Host::Ptr host = static_cast<Host::Ptr>(row);
 851
 852         if (!host)
 853                 return Empty;
 854
 855         return host->GetFlappingCurrent();
 856 }
 857
 858 Value HostsTable::InNotificationPeriodAccessor(const Value& row)
 859 {
 860         Host::Ptr host = static_cast<Host::Ptr>(row);
 861
 862         if (!host)
 863                 return Empty;
 864
 865         for (const Notification::Ptr& notification : host->GetNotifications()) {
 866                 TimePeriod::Ptr timeperiod = notification->GetPeriod();
 867
 868                 if (!timeperiod || timeperiod->IsInside(Utility::GetTime()))
 869                         return 1;
 870         }
 871
 872         return 0;
 873 }
 874
 875 Value HostsTable::InCheckPeriodAccessor(const Value& row)
 876 {
 877         Host::Ptr host = static_cast<Host::Ptr>(row);
 878
 879         if (!host)
 880                 return Empty;
 881
 882         TimePeriod::Ptr timeperiod = host->GetCheckPeriod();
 883
 884         /* none set means always checked */
 885         if (!timeperiod)
 886                 return 1;
 887
 888         return Convert::ToLong(timeperiod->IsInside(Utility::GetTime()));
 889 }
 890
 891 Value HostsTable::ContactsAccessor(const Value& row)
 892 {
 893         Host::Ptr host = static_cast<Host::Ptr>(row);
 894
 895         if (!host)
 896                 return Empty;
 897
 898         ArrayData result;
 899
 900         for (const User::Ptr& user : CompatUtility::GetCheckableNotificationUsers(host)) {
 901                 result.push_back(user->GetName());
 902         }
 903
 904         return new Array(std::move(result));
 905 }
 906
 907 Value HostsTable::DowntimesAccessor(const Value& row)
 908 {
 909         Host::Ptr host = static_cast<Host::Ptr>(row);
 910
 911         if (!host)
 912                 return Empty;
 913
 914         ArrayData result;
 915
 916         for (const Downtime::Ptr& downtime : host->GetDowntimes()) {
 917                 if (downtime->IsExpired())
 918                         continue;
 919
 920                 result.push_back(downtime->GetLegacyId());
 921         }
 922
 923         return new Array(std::move(result));
 924 }
 925
 926 Value HostsTable::DowntimesWithInfoAccessor(const Value& row)
 927 {
 928         Host::Ptr host = static_cast<Host::Ptr>(row);
 929
 930         if (!host)
 931                 return Empty;
 932
 933         ArrayData result;
 934
 935         for (const Downtime::Ptr& downtime : host->GetDowntimes()) {
 936                 if (downtime->IsExpired())
 937                         continue;
 938
 939                 result.push_back(new Array({
 940                         downtime->GetLegacyId(),
 941                         downtime->GetAuthor(),
 942                         downtime->GetComment()
 943                 }));
 944         }
 945
 946         return new Array(std::move(result));
 947 }
 948
 949 Value HostsTable::CommentsAccessor(const Value& row)
 950 {
 951         Host::Ptr host = static_cast<Host::Ptr>(row);
 952
 953         if (!host)
 954                 return Empty;
 955
 956         ArrayData result;
 957
 958         for (const Comment::Ptr& comment : host->GetComments()) {
 959                 if (comment->IsExpired())
 960                         continue;
 961
 962                 result.push_back(comment->GetLegacyId());
 963         }
 964
 965         return new Array(std::move(result));
 966 }
 967
 968 Value HostsTable::CommentsWithInfoAccessor(const Value& row)
 969 {
 970         Host::Ptr host = static_cast<Host::Ptr>(row);
 971
 972         if (!host)
 973                 return Empty;
 974
 975         ArrayData result;
 976
 977         for (const Comment::Ptr& comment : host->GetComments()) {
 978                 if (comment->IsExpired())
 979                         continue;
 980
 981                 result.push_back(new Array({
 982                         comment->GetLegacyId(),
 983                         comment->GetAuthor(),
 984                         comment->GetText()
 985                 }));
 986         }
 987
 988         return new Array(std::move(result));
 989 }
 990
 991 Value HostsTable::CommentsWithExtraInfoAccessor(const Value& row)
 992 {
 993         Host::Ptr host = static_cast<Host::Ptr>(row);
 994
 995         if (!host)
 996                 return Empty;
 997
 998         ArrayData result;
 999
1000         for (const Comment::Ptr& comment : host->GetComments()) {
1001                 if (comment->IsExpired())
1002                         continue;
1003
1004                 result.push_back(new Array({
1005                         comment->GetLegacyId(),
1006                         comment->GetAuthor(),
1007                         comment->GetText(),
1008                         comment->GetEntryType(),
1009                         static_cast<int>(comment->GetEntryTime())
1010                 }));
1011         }
1012
1013         return new Array(std::move(result));
1014 }
1015
1016 Value HostsTable::CustomVariableNamesAccessor(const Value& row)
1017 {
1018         Host::Ptr host = static_cast<Host::Ptr>(row);
1019
1020         if (!host)
1021                 return Empty;
1022
1023         Dictionary::Ptr vars = host->GetVars();
1024
1025         ArrayData result;
1026
1027         if (vars) {
1028                 ObjectLock olock(vars);
1029                 for (const Dictionary::Pair& kv : vars) {
1030                         result.push_back(kv.first);
1031                 }
1032         }
1033
1034         return new Array(std::move(result));
1035 }
1036
1037 Value HostsTable::CustomVariableValuesAccessor(const Value& row)
1038 {
1039         Host::Ptr host = static_cast<Host::Ptr>(row);
1040
1041         if (!host)
1042                 return Empty;
1043
1044         Dictionary::Ptr vars = host->GetVars();
1045
1046         ArrayData result;
1047
1048         if (vars) {
1049                 ObjectLock olock(vars);
1050                 for (const Dictionary::Pair& kv : vars) {
1051                         if (kv.second.IsObjectType<Array>() || kv.second.IsObjectType<Dictionary>())
1052                                 result.push_back(JsonEncode(kv.second));
1053                         else
1054                                 result.push_back(kv.second);
1055                 }
1056         }
1057
1058         return new Array(std::move(result));
1059 }
1060
1061 Value HostsTable::CustomVariablesAccessor(const Value& row)
1062 {
1063         Host::Ptr host = static_cast<Host::Ptr>(row);
1064
1065         if (!host)
1066                 return Empty;
1067
1068         Dictionary::Ptr vars = host->GetVars();
1069
1070         ArrayData result;
1071
1072         if (vars) {
1073                 ObjectLock olock(vars);
1074                 for (const Dictionary::Pair& kv : vars) {
1075                         Value val;
1076
1077                         if (kv.second.IsObjectType<Array>() || kv.second.IsObjectType<Dictionary>())
1078                                 val = JsonEncode(kv.second);
1079                         else
1080                                 val = kv.second;
1081
1082                         result.push_back(new Array({
1083                                 kv.first,
1084                                 val
1085                         }));
1086                 }
1087         }
1088
1089         return new Array(std::move(result));
1090 }
1091
1092 Value HostsTable::CVIsJsonAccessor(const Value& row)
1093 {
1094         Host::Ptr host = static_cast<Host::Ptr>(row);
1095
1096         if (!host)
1097                 return Empty;
1098
1099         Dictionary::Ptr vars = host->GetVars();
1100
1101         if (!vars)
1102                 return Empty;
1103
1104         bool cv_is_json = false;
1105
1106         ObjectLock olock(vars);
1107         for (const Dictionary::Pair& kv : vars) {
1108                 if (kv.second.IsObjectType<Array>() || kv.second.IsObjectType<Dictionary>())
1109                         cv_is_json = true;
1110         }
1111
1112         return cv_is_json;
1113 }
1114
1115 Value HostsTable::ParentsAccessor(const Value& row)
1116 {
1117         Host::Ptr host = static_cast<Host::Ptr>(row);
1118
1119         if (!host)
1120                 return Empty;
1121
1122         ArrayData result;
1123
1124         for (const Checkable::Ptr& parent : host->GetParents()) {
1125                 Host::Ptr parent_host = dynamic_pointer_cast<Host>(parent);
1126
1127                 if (!parent_host)
1128                         continue;
1129
1130                 result.push_back(parent_host->GetName());
1131         }
1132
1133         return new Array(std::move(result));
1134 }
1135
1136 Value HostsTable::ChildsAccessor(const Value& row)
1137 {
1138         Host::Ptr host = static_cast<Host::Ptr>(row);
1139
1140         if (!host)
1141                 return Empty;
1142
1143         ArrayData result;
1144
1145         for (const Checkable::Ptr& child : host->GetChildren()) {
1146                 Host::Ptr child_host = dynamic_pointer_cast<Host>(child);
1147
1148                 if (!child_host)
1149                         continue;
1150
1151                 result.push_back(child_host->GetName());
1152         }
1153
1154         return new Array(std::move(result));
1155 }
1156
1157 Value HostsTable::NumServicesAccessor(const Value& row)
1158 {
1159         /* duplicate of TotalServices */
1160         Host::Ptr host = static_cast<Host::Ptr>(row);
1161
1162         if (!host)
1163                 return Empty;
1164
1165         return host->GetTotalServices();
1166 }
1167
1168 Value HostsTable::WorstServiceStateAccessor(const Value& row)
1169 {
1170         Host::Ptr host = static_cast<Host::Ptr>(row);
1171
1172         if (!host)
1173                 return Empty;
1174
1175         Value worst_service = ServiceOK;
1176
1177         for (const Service::Ptr& service : host->GetServices()) {
1178                 if (service->GetState() > worst_service)
1179                         worst_service = service->GetState();
1180         }
1181
1182         return worst_service;
1183 }
1184
1185 Value HostsTable::NumServicesOkAccessor(const Value& row)
1186 {
1187         Host::Ptr host = static_cast<Host::Ptr>(row);
1188
1189         if (!host)
1190                 return Empty;
1191
1192         int num_services = 0;
1193
1194         for (const Service::Ptr& service : host->GetServices()) {
1195                 if (service->GetState() == ServiceOK)
1196                         num_services++;
1197         }
1198
1199         return num_services;
1200 }
1201
1202 Value HostsTable::NumServicesWarnAccessor(const Value& row)
1203 {
1204         Host::Ptr host = static_cast<Host::Ptr>(row);
1205
1206         if (!host)
1207                 return Empty;
1208
1209         int num_services = 0;
1210
1211         for (const Service::Ptr& service : host->GetServices()) {
1212                 if (service->GetState() == ServiceWarning)
1213                         num_services++;
1214         }
1215
1216         return num_services;
1217 }
1218
1219 Value HostsTable::NumServicesCritAccessor(const Value& row)
1220 {
1221         Host::Ptr host = static_cast<Host::Ptr>(row);
1222
1223         if (!host)
1224                 return Empty;
1225
1226         int num_services = 0;
1227
1228         for (const Service::Ptr& service : host->GetServices()) {
1229                 if (service->GetState() == ServiceCritical)
1230                         num_services++;
1231         }
1232
1233         return num_services;
1234 }
1235
1236 Value HostsTable::NumServicesUnknownAccessor(const Value& row)
1237 {
1238         Host::Ptr host = static_cast<Host::Ptr>(row);
1239
1240         if (!host)
1241                 return Empty;
1242
1243         int num_services = 0;
1244
1245         for (const Service::Ptr& service : host->GetServices()) {
1246                 if (service->GetState() == ServiceUnknown)
1247                         num_services++;
1248         }
1249
1250         return num_services;
1251 }
1252
1253 Value HostsTable::NumServicesPendingAccessor(const Value& row)
1254 {
1255         Host::Ptr host = static_cast<Host::Ptr>(row);
1256
1257         if (!host)
1258                 return Empty;
1259
1260         int num_services = 0;
1261
1262         for (const Service::Ptr& service : host->GetServices()) {
1263                 if (!service->GetLastCheckResult())
1264                         num_services++;
1265         }
1266
1267         return num_services;
1268 }
1269
1270 Value HostsTable::WorstServiceHardStateAccessor(const Value& row)
1271 {
1272         Host::Ptr host = static_cast<Host::Ptr>(row);
1273
1274         if (!host)
1275                 return Empty;
1276
1277         Value worst_service = ServiceOK;
1278
1279         for (const Service::Ptr& service : host->GetServices()) {
1280                 if (service->GetStateType() == StateTypeHard) {
1281                         if (service->GetState() > worst_service)
1282                                 worst_service = service->GetState();
1283                 }
1284         }
1285
1286         return worst_service;
1287 }
1288
1289 Value HostsTable::NumServicesHardOkAccessor(const Value& row)
1290 {
1291         Host::Ptr host = static_cast<Host::Ptr>(row);
1292
1293         if (!host)
1294                 return Empty;
1295
1296         int num_services = 0;
1297
1298         for (const Service::Ptr& service : host->GetServices()) {
1299                 if (service->GetStateType() == StateTypeHard && service->GetState() == ServiceOK)
1300                         num_services++;
1301         }
1302
1303         return num_services;
1304 }
1305
1306 Value HostsTable::NumServicesHardWarnAccessor(const Value& row)
1307 {
1308         Host::Ptr host = static_cast<Host::Ptr>(row);
1309
1310         if (!host)
1311                 return Empty;
1312
1313         int num_services = 0;
1314
1315         for (const Service::Ptr& service : host->GetServices()) {
1316                 if (service->GetStateType() == StateTypeHard && service->GetState() == ServiceWarning)
1317                         num_services++;
1318         }
1319
1320         return num_services;
1321 }
1322
1323 Value HostsTable::NumServicesHardCritAccessor(const Value& row)
1324 {
1325         Host::Ptr host = static_cast<Host::Ptr>(row);
1326
1327         if (!host)
1328                 return Empty;
1329
1330         int num_services = 0;
1331
1332         for (const Service::Ptr& service : host->GetServices()) {
1333                 if (service->GetStateType() == StateTypeHard && service->GetState() == ServiceCritical)
1334                         num_services++;
1335         }
1336
1337         return num_services;
1338 }
1339
1340 Value HostsTable::NumServicesHardUnknownAccessor(const Value& row)
1341 {
1342         Host::Ptr host = static_cast<Host::Ptr>(row);
1343
1344         if (!host)
1345                 return Empty;
1346
1347         int num_services = 0;
1348
1349         for (const Service::Ptr& service : host->GetServices()) {
1350                 if (service->GetStateType() == StateTypeHard && service->GetState() == ServiceUnknown)
1351                         num_services++;
1352         }
1353
1354         return num_services;
1355 }
1356
1357 Value HostsTable::HardStateAccessor(const Value& row)
1358 {
1359         Host::Ptr host = static_cast<Host::Ptr>(row);
1360
1361         if (!host)
1362                 return Empty;
1363
1364         if (host->GetState() == HostUp)
1365                 return HostUp;
1366         else if (host->GetStateType() == StateTypeHard)
1367                 return host->GetState();
1368
1369         return host->GetLastHardState();
1370 }
1371
1372 Value HostsTable::StalenessAccessor(const Value& row)
1373 {
1374         Host::Ptr host = static_cast<Host::Ptr>(row);
1375
1376         if (!host)
1377                 return Empty;
1378
1379         if (host->HasBeenChecked() && host->GetLastCheck() > 0)
1380                 return (Utility::GetTime() - host->GetLastCheck()) / (host->GetCheckInterval() * 3600);
1381
1382         return 0.0;
1383 }
1384
1385 Value HostsTable::GroupsAccessor(const Value& row)
1386 {
1387         Host::Ptr host = static_cast<Host::Ptr>(row);
1388
1389         if (!host)
1390                 return Empty;
1391
1392         Array::Ptr groups = host->GetGroups();
1393
1394         if (!groups)
1395                 return Empty;
1396
1397         return groups;
1398 }
1399
1400 Value HostsTable::ContactGroupsAccessor(const Value& row)
1401 {
1402         Host::Ptr host = static_cast<Host::Ptr>(row);
1403
1404         if (!host)
1405                 return Empty;
1406
1407         ArrayData result;
1408
1409         for (const UserGroup::Ptr& usergroup : CompatUtility::GetCheckableNotificationUserGroups(host)) {
1410                 result.push_back(usergroup->GetName());
1411         }
1412
1413         return new Array(std::move(result));
1414 }
1415
1416 Value HostsTable::ServicesAccessor(const Value& row)
1417 {
1418         Host::Ptr host = static_cast<Host::Ptr>(row);
1419
1420         if (!host)
1421                 return Empty;
1422
1423         std::vector<Service::Ptr> rservices = host->GetServices();
1424
1425         ArrayData result;
1426         result.reserve(rservices.size());
1427
1428         for (const Service::Ptr& service : rservices) {
1429                 result.push_back(service->GetShortName());
1430         }
1431
1432         return new Array(std::move(result));
1433 }
1434
1435 Value HostsTable::ServicesWithStateAccessor(const Value& row)
1436 {
1437         Host::Ptr host = static_cast<Host::Ptr>(row);
1438
1439         if (!host)
1440                 return Empty;
1441
1442         std::vector<Service::Ptr> rservices = host->GetServices();
1443
1444         ArrayData result;
1445         result.reserve(rservices.size());
1446
1447         for (const Service::Ptr& service : rservices) {
1448                 result.push_back(new Array({
1449                         service->GetShortName(),
1450                         service->GetState(),
1451                         service->HasBeenChecked() ? 1 : 0
1452                 }));
1453         }
1454
1455         return new Array(std::move(result));
1456 }
1457
1458 Value HostsTable::ServicesWithInfoAccessor(const Value& row)
1459 {
1460         Host::Ptr host = static_cast<Host::Ptr>(row);
1461
1462         if (!host)
1463                 return Empty;
1464
1465         std::vector<Service::Ptr> rservices = host->GetServices();
1466
1467         ArrayData result;
1468         result.reserve(rservices.size());
1469
1470         for (const Service::Ptr& service : rservices) {
1471                 String output;
1472                 CheckResult::Ptr cr = service->GetLastCheckResult();
1473
1474                 if (cr)
1475                         output = CompatUtility::GetCheckResultOutput(cr);
1476
1477                 result.push_back(new Array({
1478                         service->GetShortName(),
1479                         service->GetState(),
1480                         service->HasBeenChecked() ? 1 : 0,
1481                         output
1482                 }));
1483         }
1484
1485         return new Array(std::move(result));
1486 }
1487
1488 Value HostsTable::CheckSourceAccessor(const Value& row)
1489 {
1490         Host::Ptr host = static_cast<Host::Ptr>(row);
1491
1492         if (!host)
1493                 return Empty;
1494
1495         CheckResult::Ptr cr = host->GetLastCheckResult();
1496
1497         if (cr)
1498                 return cr->GetCheckSource();
1499
1500         return Empty;
1501 }
1502
1503 Value HostsTable::IsReachableAccessor(const Value& row)
1504 {
1505         Host::Ptr host = static_cast<Host::Ptr>(row);
1506
1507         if (!host)
1508                 return Empty;
1509
1510         return host->IsReachable();
1511 }
1512
1513 Value HostsTable::OriginalAttributesAccessor(const Value& row)
1514 {
1515         Host::Ptr host = static_cast<Host::Ptr>(row);
1516
1517         if (!host)
1518                 return Empty;
1519
1520         return JsonEncode(host->GetOriginalAttributes());
1521 }