maintenance_work_planned_publics

Creates, updates, deletes, gets or lists a maintenance_work_planned_publics resource.

Overview

Name	maintenance_work_planned_publics
Type	Resource
Id	ovh.connectivity.maintenance_work_planned_publics

Fields

The following fields are returned by SELECT queries:

list

Work Planned operation structure

Name	Datatype	Description
id	integer	Work Planned operation id
date_begin	string	Begin date, the work planned operation starts at this time (wire: dateBegin)
date_end	string	End date, the work planned operation finishes at the time (wire: dateEnd)
departments	array	List of impacted department codes
description	string	Description of the work planned operation
duration	string (duration)	Duration of the work planned operation
fallback	boolean	Fallback planned for the operation
fallback_date_begin	string (date-time)	Fallback operation starts at this time (wire: fallbackDateBegin)
fallback_date_end	string (date-time)	Fallback operation ends at this time (wire: fallbackDateEnd)
impact	string	Impact of the work planned operation
intervention_type	string	Intervention type (BACKBONE_MAINTENANCE, CARD_SWAP_WITH_IMPACT, CLUSTER_AN_ROUTER_MIGRATION, CORRECTIVE_MAINTENANCE, DSLAM_LINK_UPGRADE_WITHOUT_CARD_SWAP, DSLAM_UPGRADE_WITH_IMPACT, FIBER_CABLE_LINK_SWAP, FIBER_CONNECTION_WITH_IMPACT, FIBER_MAINTENANCE, FIBER_THIRD_PARTY_WORK_WITH_IMPACT, IP_BACKBONE_LINK_MIGRATION_WITH_IMPACT, IP_BACKBONE_SWITCH_UPGRADE_WITH_IMPACT, IP_MAINTENANCE, LEVEL2_DSLAM_MIGRATION, LINK_MIGRATION_WITH_DSL_IMPACT, LL_THIRD_PARTY_MAINTENANCE_WITH_IMPACT, LOOP_AN_ROUTER_MIGRATION, LOOP_AN_ROUTER_UPGRADE, MAINTENANCE, OPTIC_FIBER_WORK_WITH_OUTAGE_DURING_NON_WORKING_HOURS, PLANNED_CORRECTIVE_MAINTENANCE, SENSITIVE_LOOP_LINK_UPGRADE, TRANSMISSION_CORRECTIVE_MAINTENANCE, TRANSMISSION_CUSTOMER_TRANSFERT_MIGRATION_WITH_IMPACT, TRANSMISSION_FIBRE_MAINTENANCE, TRANSMISSION_LINK_COMMISSIONING_PRODUCTION_DECOMMISSIONING_WORK_WITH_IMPACT, TRANSMISSION_LINK_TRANSFERT_MIGRATION_WITH_IMPACT, TRANSMISSION_MAINTENANCE, TRANSMISSION_MOVING_WITH_IMPACT, TRANSMISSION_SWITCH_UPGRADE_WITH_IMPACT, WITH_IMPACT) (wire: interventionType)
nras	array	List of impacted NRA/NRO
operator	string	Operator (AXIONE, BOUYGUES, KOSC, ORANGE, OVH, SFR)
technology	string	Technology impacted by the work planned operation
zone	string	Zone of the work planned operation

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
list	select		begin_date, end_date	Returns the planned work operations of network operators, with their dates, duration, impact, impacted NRA/NRO and departments. Filter on the begin and end dates.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
api_host	string	The OVHcloud API host. Selected by OVH_ENDPOINT (ovh-eu, ovh-ca or ovh-us; default ovh-eu). (default: api.eu.ovhcloud.com, x-stackQL-envVarSelector: {"envVar":"OVH_ENDPOINT","default":"ovh-eu","values":{"ovh-eu":"api.eu.ovhcloud.com","ovh-ca":"api.ca.ovhcloud.com","ovh-us":"api.us.ovhcloud.com"}})
begin_date	string (date-time)	List only work planned started after this date (wire: beginDate)
end_date	string (date-time)	List only work planned ending prior to this date (wire: endDate)

SELECT examples

list

Returns the planned work operations of network operators, with their dates, duration, impact, impacted NRA/NRO and departments. Filter on the begin and end dates.

SELECT
id,
date_begin,
date_end,
departments,
description,
duration,
fallback,
fallback_date_begin,
fallback_date_end,
impact,
intervention_type,
nras,
operator,
technology,
zone
FROM ovh.connectivity.maintenance_work_planned_publics
WHERE begin_date = '{{ begin_date }}'
AND end_date = '{{ end_date }}'
;