KS-Soft

For information i am using this at the moment for logging every test and also for midnight logging with the backup log option.

so now here comes the view DROP VIEW IF EXISTS `hostmonitor`.`hostmon_complete`; CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `hostmonitor`.`hostmon_complete` AS select `agent`.`Agent` AS `Agent`,`mastertest`.`mastertest` AS `mastertest`,`servicecomp`.`servicecomp` AS `se...

At the first i will post all the tables that i have created: DROP TABLE IF EXISTS `hostmonitor`.`agent`; CREATE TABLE `hostmonitor`.`agent` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `Agent` varchar(45) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 ROW_F...