Debian Codegraph @

src/database/sap/hana/mode/blockedtransactions.pm

raw
1 #
2 # Copyright 2024 Centreon (http://www.centreon.com/)
3 #
4 # Centreon is a full-fledged industry-strength solution that meets
5 # the needs in IT infrastructure and application monitoring for
6 # service performance.
7 #
8 # Licensed under the Apache License, Version 2.0 (the "License");
9 # you may not use this file except in compliance with the License.
10 # You may obtain a copy of the License at
11 #
12 # http://www.apache.org/licenses/LICENSE-2.0
13 #
14 # Unless required by applicable law or agreed to in writing, software
15 # distributed under the License is distributed on an "AS IS" BASIS,
16 # WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
17 # See the License for the specific language governing permissions and
18 # limitations under the License.
19 #
20
21 package database::sap::hana::mode::blockedtransactions;
22
23 use base qw(centreon::plugins::templates::counter);
24
25 use strict;
26 use warnings;
27
28 sub set_counters {
29 my ($self, %options) = @_;
30
31 $self->{maps_counters_type} = [
32 { name => 'global', type => 0 },
33 ];
34 $self->{maps_counters}->{global} = [
35 { label => 'blocked-transactions', nlabel => 'transactions.blocked.count', set => {
36 key_values => [ { name => 'total' } ],
37 output_template => 'Current Total Blocked Transactions : %s',
38 perfdatas => [
39 { label => 'total_blocked_transactions', value => 'total', template => '%s', min => 0 },
40 ],
41 }
42 },
43 ];
44 }
45
46 sub new {
47 my ($class, %options) = @_;
48 my $self = $class->SUPER::new(package => __PACKAGE__, %options);
49 bless $self, $class;
50
51 $options{options}->add_options(arguments =>
52 {
53 });
54
55 return $self;
56 }
57
58 sub manage_selection {
59 my ($self, %options) = @_;
60 $options{sql}->connect();
61
62 my $query = q{
63 SELECT COUNT(*) AS total FROM M_BLOCKED_TRANSACTIONS
64 };
65 $options{sql}->query(query => $query);
66
67 $self->{global} = { total => 0 };
68 if (my $row = $options{sql}->fetchrow_hashref()) {
69 $self->{global}->{total} = $row->{total} if (defined($row->{total}));
70 }
71 }
72
73 1;
74
75 __END__
76
77 =head1 MODE
78
79 Check total blocked transactions.
80
81 =over 8
82
83 =item B<--warning-*>
84
85 Warning threshold.
86 Can be: 'blocked-transactions'.
87
88 =item B<--critical-*>
89
90 Critical threshold.
91 Can be: 'blocked-transactions'.
92
93 =back
94
95 =cut