Gets last volume name from each pool group into Bacula database

bacula-last-volume-name.sql

SELECT vc1.*
FROM PoolGroup AS pg
	INNER JOIN VolumeCatalog AS vc1 ON (vc1.VolumeName LIKE pg.Filter)
WHERE vc1.VolumeName =
	(SELECT VolumeName
	FROM VolumeCatalog AS vc2
	WHERE vc2.VolumeName LIKE pg.Filter
	ORDER BY VolumeName DESC
	LIMIT 1)
;

zabbix-report-schema.sql

CREATE  TABLE `PoolGroup` (
  `Id` INT NOT NULL AUTO_INCREMENT ,
  `Name` VARCHAR(45) NOT NULL ,
  `Filter` VARCHAR(20) NOT NULL ,
  `Filter_MS` VARCHAR(20) NOT NULL ,
  PRIMARY KEY (`Id`) ,
  UNIQUE INDEX `Name_UNIQUE` (`Name` ASC) )
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;