Jump to content

Search the Community

Showing results for tags 'maintenance window'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • MSPGeek
    • The Geek Cast
    • Code of Conduct
  • ConnectWise Automate / Labtech
    • ConnectWise Automate / LabTech
    • ConnectWise Automate / LabTech - Development

Categories

  • ConnectWise Automate
    • Scripts
    • Plugins
    • SQL Snippets
    • Role Definitions
    • Automate PowerShell Code
    • Reports
    • Internal Monitors
    • Remote Monitors
  • ConnectWise Manage
    • API Interacting Code

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


About Me


Location


Agent Count


INTERESTS


OCCUPATION


ICQ


WEBSITE


WLM


YAHOO


AOL


FACEBOOK


GOOGLEPLUS


SKYPE


TWITTER


YOUTUBE

Found 2 results

  1. The maintenancemode table has been replaced with a view which emulates the data the maintenancemode table used to contain by building it from the new maintenancemodequeue table. However CW screwed up the SQL because instead of using a stock MySQL function they tried to calculate some time / datetime values themselves. With long-lasting maintenance modes this can overflow the maximum value for a time datatype which causes the SQL to throw warnings and produce incorrect output. Here's a fix - submitted to CW as Ticket#13557433 on 2020-070-02 You'll likely need to replace this after every upgrade / patch until CW get around to fixing the code in their releases. I wouldn't hold your breath - last time it took two years for them to replace their broken SQL with the fix I gave them. Note - I have not confirmed that the output of this table matches what would have existed in the old maintenancemode table under all conditions. Instead I have focused on just fixing the calculations CW used. To use either directly run / import the direct-import file below, or open the view in your SQL editor and paste the view-content file into the view and click save. maintenancemode-fixed-2020-07-02-direct-import.sql maintenancemode-fixed-2020-07-02-view-content.sql
  2. So we need to set a custom maintenance window for one of the locations for one of our clients. We need a window from 5pm to 12am every first and third Sunday. I have never written a script for Automate before so I am not even sure where to start. Has anyone done anything like this before? Is this even possible? Thanks!
×
×
  • Create New...