1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
|
# --
# Copyright (C) 2001-2021 OTRS AG, https://otrs.com/
# --
# This software comes with ABSOLUTELY NO WARRANTY. For details, see
# the enclosed file COPYING for license information (GPL). If you
# did not receive this file, see https://www.gnu.org/licenses/gpl-3.0.txt.
# --
package Kernel::System::SupportDataCollector::Plugin::Database::OutdatedTables;
use strict;
use warnings;
use parent qw(Kernel::System::SupportDataCollector::PluginBase);
use Kernel::Language qw(Translatable);
our @ObjectDependencies = (
'Kernel::System::DB',
'Kernel::System::Package',
);
sub GetDisplayPath {
return Translatable('Database');
}
sub Run {
my $Self = shift;
my %ExistingTables = map { lc($_) => 1 } $Kernel::OM->Get('Kernel::System::DB')->ListTables();
my @OutdatedTables;
# This table was removed with OTRS 6 (if empty).
if ( $ExistingTables{gi_object_lock_state} ) {
my $SolManConnectorInstalled;
for my $Package ( $Kernel::OM->Get('Kernel::System::Package')->RepositoryList() ) {
if ( $Package->{Name}->{Content} eq 'OTRSGenericInterfaceConnectorSAPSolMan' ) {
$SolManConnectorInstalled = 1;
}
}
push @OutdatedTables, 'gi_object_lock_state' if !$SolManConnectorInstalled;
}
if ( !@OutdatedTables ) {
$Self->AddResultOk(
Label => Translatable('Outdated Tables'),
Value => '',
);
}
else {
$Self->AddResultWarning(
Label => Translatable('Outdated Tables'),
Value => join( ', ', @OutdatedTables ),
Message => Translatable("Outdated tables were found in the database. These can be removed if empty."),
);
}
return $Self->GetResults();
}
1;
|
