1
BEGIN
2
-- This stored procedure is intended to keep the cacheeventdates tables with the least amount of records as possible while still keeping at least one entry per eventsource type.
3
DROP TEMPORARY TABLE IF EXISTS `tempCacheEventDates`;
4
CREATE TEMPORARY TABLE `tempCacheEventDates` (EventSource VARCHAR(50),eventdate TIMESTAMP);
5
INSERT INTO `tempCacheEventDates` SELECT 'Agents', MAX(EventDate) FROM CacheEventDates WHERE EventSource='Agents';
6
INSERT INTO `tempCacheEventDates` SELECT 'Apps', MAX(EventDate) FROM CacheEventDates WHERE EventSource='Apps';
7
INSERT INTO `tempCacheEventDates` SELECT 'AuditActions', MAX(EventDate) FROM CacheEventDates WHERE EventSource='AuditActions';
8
INSERT INTO `tempCacheEventDates` SELECT 'CCommands', MAX(EventDate) FROM CacheEventDates WHERE EventSource='CCommands';
9
INSERT INTO `tempCacheEventDates` SELECT 'Clients', MAX(EventDate) FROM CacheEventDates WHERE EventSource='Clients';
10
INSERT INTO `tempCacheEventDates` SELECT 'CMenus', MAX(EventDate) FROM CacheEventDates WHERE EventSource='CMenus';
11
INSERT INTO `tempCacheEventDates` SELECT 'Computers', MAX(EventDate) FROM CacheEventDates WHERE EventSource='Computers';
12
INSERT INTO `tempCacheEventDates` SELECT 'Config', MAX(EventDate) FROM CacheEventDates WHERE EventSource='Config';
13
INSERT INTO `tempCacheEventDates` SELECT 'ConfigOutlook', MAX(EventDate) FROM CacheEventDates WHERE EventSource='ConfigOutlook';
14
INSERT INTO `tempCacheEventDates` SELECT 'Contacts', MAX(EventDate) FROM CacheEventDates WHERE EventSource='Contacts';
15
INSERT INTO `tempCacheEventDates` SELECT 'ControlCenterConfig', MAX(EventDate) FROM CacheEventDates WHERE EventSource='ControlCenterConfig';
16
INSERT INTO `tempCacheEventDates` SELECT 'DataViewFolders', MAX(EventDate) FROM CacheEventDates WHERE EventSource='DataViewFolders';
17
INSERT INTO `tempCacheEventDates` SELECT 'DataViews', MAX(EventDate) FROM CacheEventDates WHERE EventSource='DataViews';
18
INSERT INTO `tempCacheEventDates` SELECT 'Functions', MAX(EventDate) FROM CacheEventDates WHERE EventSource='Functions';
19
INSERT INTO `tempCacheEventDates` SELECT 'Groups', MAX(EventDate) FROM CacheEventDates WHERE EventSource='Groups';
20
INSERT INTO `tempCacheEventDates` SELECT 'Huds', MAX(EventDate) FROM CacheEventDates WHERE EventSource='Huds';
21
INSERT INTO `tempCacheEventDates` SELECT 'Links', MAX(EventDate) FROM CacheEventDates WHERE EventSource='Links';
22
INSERT INTO `tempCacheEventDates` SELECT 'Locations', MAX(EventDate) FROM CacheEventDates WHERE EventSource='Locations';
23
INSERT INTO `tempCacheEventDates` SELECT 'Permissions', MAX(EventDate) FROM CacheEventDates WHERE EventSource='Permissions';
24
INSERT INTO `tempCacheEventDates` SELECT 'Properties', MAX(EventDate) FROM CacheEventDates WHERE EventSource='Properties';
25
INSERT INTO `tempCacheEventDates` SELECT 'Redirectors', MAX(EventDate) FROM CacheEventDates WHERE EventSource='Redirectors';
26
INSERT INTO `tempCacheEventDates` SELECT 'Regions', MAX(EventDate) FROM CacheEventDates WHERE EventSource='Regions';
27
INSERT INTO `tempCacheEventDates` SELECT 'RemoteCommands', MAX(EventDate) FROM CacheEventDates WHERE EventSource='RemoteCommands';
28
INSERT INTO `tempCacheEventDates` SELECT 'ReportFolders', MAX(EventDate) FROM CacheEventDates WHERE EventSource='ReportFolders';
29
INSERT INTO `tempCacheEventDates` SELECT 'Reports', MAX(EventDate) FROM CacheEventDates WHERE EventSource='Reports';
30
INSERT INTO `tempCacheEventDates` SELECT 'RoleDefinitions', MAX(EventDate) FROM CacheEventDates WHERE EventSource='RoleDefinitions';
31
INSERT INTO `tempCacheEventDates` SELECT 'Schedules', MAX(EventDate) FROM CacheEventDates WHERE EventSource='Schedules';
32
INSERT INTO `tempCacheEventDates` SELECT 'ScriptFolders', MAX(EventDate) FROM CacheEventDates WHERE EventSource='ScriptFolders';
33
INSERT INTO `tempCacheEventDates` SELECT 'Scripts', MAX(EventDate) FROM CacheEventDates WHERE EventSource='Scripts';
34
INSERT INTO `tempCacheEventDates` SELECT 'SensorChecks', MAX(EventDate) FROM CacheEventDates WHERE EventSource='SensorChecks';
35
INSERT INTO `tempCacheEventDates` SELECT 'Templates', MAX(EventDate) FROM CacheEventDates WHERE EventSource='Templates';
36
INSERT INTO `tempCacheEventDates` SELECT 'TicketCategory', MAX(EventDate) FROM CacheEventDates WHERE EventSource='TicketCategory';
37
INSERT INTO `tempCacheEventDates` SELECT 'TicketData', MAX(EventDate) FROM CacheEventDates WHERE EventSource='TicketData';
38
INSERT INTO `tempCacheEventDates` SELECT 'TimeCategory', MAX(EventDate) FROM CacheEventDates WHERE EventSource='TimeCategory';
39
INSERT INTO `tempCacheEventDates` SELECT 'UserFolders', MAX(EventDate) FROM CacheEventDates WHERE EventSource='UserFolders';
40
INSERT INTO `tempCacheEventDates` SELECT 'Users', MAX(EventDate) FROM CacheEventDates WHERE EventSource='Users';
41
INSERT INTO `tempCacheEventDates` SELECT 'VirusScanners', MAX(EventDate) FROM CacheEventDates WHERE EventSource='VirusScanners';
42
TRUNCATE `CacheEventDates`;
43
INSERT IGNORE INTO `CacheEventDates` (`EventSource`,`EventDate`) SELECT `EventSource`,`EventDate` FROM `tempCacheEventDates`;
44
DROP TEMPORARY TABLE IF EXISTS `tempCacheEventDates`;
45
CALL PopulateCacheEventDates();
46
END