my $query="SELECT severity, source, displayname 
FROM alert 
WHERE displayname LIKE '%$displayname%' 
ORDER BY severity DESC
LIMIT 1";

my ($severity, $source, $displayname) = $dbh->selectrow_array($query);