Contents

DELETE FROM public.cmdb_scan_schedule;

-- SA (South Africa) Inserts
INSERT INTO cmdb_scan_schedule (business_unit, is_ar, start_day, start_hour, end_day, end_hour, engine_pool)
VALUES 
    ('PPB', FALSE, 'Sunday', 6, 'Monday', 6, 'Core scanner'),
    ('CIB', FALSE, 'Saturday', 6, 'Saturday', 20, 'Core Scanner'),
    ('CF', FALSE, 'Saturday', 6, 'Saturday', 20, 'Discovery scanners'),
    ('IAM', FALSE, 'Friday', 20, 'Saturday', 6, 'Deep dive'),
    ('BCB', FALSE, 'Saturday', 6, 'Saturday', 20, 'Deep dive'),
    ('TGF', FALSE, 'Sunday', 8, 'Sunday', 20, 'Deep dive');

-- AR (Africa Region) Inserts
INSERT INTO cmdb_scan_schedule (business_unit, is_ar, start_day, start_hour, end_day, end_hour, engine_pool)
VALUES 
    ('PPB', TRUE, 'Sunday', 2, 'Monday', 6, 'Core scanner pool'),
    ('CIB', TRUE, 'Saturday', 14, 'Sunday', 2, 'Core Scanner pool'),
    ('CF', TRUE, 'Friday', 20, 'Saturday', 2, 'Core Scanner pool'),
    ('IAM', TRUE, 'Saturday', 2, 'Saturday', 6, 'Core Scanner pool'),
    ('BCB', TRUE, 'Saturday', 6, 'Saturday', 10, 'Core Scanner pool'),
    ('TGF', TRUE, 'Saturday', 10, 'Saturday', 14, 'Core Scanner pool');


select * from cmdb_scan_schedule;

Version data entries

3 entries across 3 versions & 1 rubygems

Version	Path
avs-0.1.3	sql/critical_app_scan_schedule.sql
avs-0.1.2	sql/critical_app_scan_schedule.sql
avs-0.1.1	sql/critical_app_scan_schedule.sql