`CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vwactivity` AS select ‘Activity’ AS `QueryType`,`stats`.`ID` AS `LogID`,date_format(str_to_date(`stats`.`LogStamp`,‘%Y-%m-%d %k:%i:%s.%f’),‘%Y-%m-%dT%H:%i:%s’) AS `LogStamp`,`stats`.`TaskID` AS `TaskID`,(case `stats`.`TaskID` when 100 then ‘*** Sync Preview ***’ else `taskruns`.`TaskName` end) AS `TaskName`,`stats`.`Node` AS `Node`,date_format(str_to_date(`stats`.`NominalStart`,‘%Y-%m-%d %k:%i:%s.%f’),‘%Y-%m-%dT%H:%i:%s’) AS `ScheduledTime`,`stats`.`NominalStart` AS `NominalStart`,`stats`.`Action` AS `Action`,(case `stats`.`Action` when ‘get’ then `stats`.`SourceNBytes` when ‘send’ then `stats`.`NBytes` else NULL end) AS `TransferBytes`,`stats`.`SourceHost` AS `SourceHost`,`stats`.`SourceFilename` AS `SourcePath`,`stats`.`SourceFilenameOnly` AS `SourceFile`,`stats`.`SourceFileID` AS `SourceFileID`,`stats`.`SourceNBytes` AS `SourceBytes`,`stats`.`SourceDuration` AS `SourceDuration`,`stats`.`SourceMsgID` AS `SourceASxMsgID`,`stats`.`SourceMDN` AS `SourceASxMDN`,date_format(str_to_date(`stats`.`SourceStamp`,‘%Y-%m-%d %k:%i:%s.%f’),‘%Y-%m-%dT%H:%i:%s’) AS `SourceStamp`,`stats`.`DestHost` AS `DestHost`,`stats`.`DestFilename` AS `DestPath`,`stats`.`DestFilenameOnly` AS `DestFile`,`stats`.`DestFileID` AS `DestFileID`,`stats`.`NBytes` AS `DestBytes`,`stats`.`DestDuration` AS `DestDuration`,`stats`.`DestMsgID` AS `DestASxMsgID`,`stats`.`DestMDN` AS `DestASxMDN`,`stats`.`ErrCode` AS `StatusCode`,`stats`.`Message` AS `StatusMsg`,`taskruns`.`Success` AS `Status`,date_format(str_to_date(`taskruns`.`TimeStarted`,‘%Y-%m-%d %k:%i:%s.%f’),‘%Y-%m-%dT%H:%i:%s’) AS `StartTime` from (`stats` join `taskruns` on(((`stats`.`NominalStart` = `taskruns`.`NominalStart`) and (`stats`.`TaskID` = `taskruns`.`TaskID`))))