fortinet.fortimanager.fmgr_system_sql_customskipidx module – List of aditional SQL skip index fields.

Note

This module is part of the fortinet.fortimanager collection (version 2.2.0).

You might already have this collection installed if you are using the ansible package. It is not included in ansible-core. To check whether it is installed, run ansible-galaxy collection list.

To install it, use: ansible-galaxy collection install fortinet.fortimanager.

To use it in a playbook, specify: fortinet.fortimanager.fmgr_system_sql_customskipidx.

New in fortinet.fortimanager 2.1.0

Synopsis

  • This module is able to configure a FortiManager device.

  • Examples include all parameters and values which need to be adjusted to data sources before usage.

Parameters

Parameter

Comments

access_token

string

The token to access FortiManager without using username and password.

bypass_validation

boolean

Only set to True when module schema diffs with FortiManager API structure, module continues to execute without validating parameters.

Choices:

  • false ← (default)

  • true

enable_log

boolean

Enable/Disable logging for task.

Choices:

  • false ← (default)

  • true

forticloud_access_token

string

Authenticate Ansible client with forticloud API access token.

proposed_method

string

The overridden method for the underlying Json RPC request.

Choices:

  • "update"

  • "set"

  • "add"

rc_failed

list / elements=integer

The rc codes list with which the conditions to fail will be overriden.

rc_succeeded

list / elements=integer

The rc codes list with which the conditions to succeed will be overriden.

state

string / required

The directive to create, update or delete an object.

Choices:

  • "present"

  • "absent"

system_sql_customskipidx

dictionary

the top level parameters set

device-type

string

Device type.

FortiGate - Set device type to FortiGate.

FortiManager - Set device type to FortiManager

FortiClient - Set device type to FortiClient.

FortiMail - Set device type to FortiMail.

FortiWeb - Set device type to FortiWeb.

FortiSandbox - Set device type to FortiSandbox

FortiProxy - Set device type to FortiProxy

Choices:

  • "FortiGate"

  • "FortiManager"

  • "FortiClient"

  • "FortiMail"

  • "FortiWeb"

  • "FortiSandbox"

  • "FortiProxy"

id

integer

Add or Edit log index fields.

index-field

string

Field to be added to skip index.

log-type

string

Log type.

app-ctrl

attack

content

dlp

emailfilter

event

generic

history

traffic

virus

voip

webfilter

netscan

fct-event

fct-traffic

fct-netscan

waf

gtp

dns

ssh

ssl

file-filter

asset

Choices:

  • "app-ctrl"

  • "attack"

  • "content"

  • "dlp"

  • "emailfilter"

  • "event"

  • "generic"

  • "history"

  • "traffic"

  • "virus"

  • "voip"

  • "webfilter"

  • "netscan"

  • "fct-event"

  • "fct-traffic"

  • "fct-netscan"

  • "waf"

  • "gtp"

  • "dns"

  • "ssh"

  • "ssl"

  • "file-filter"

  • "asset"

  • "protocol"

  • "siem"

  • "ztna"

workspace_locking_adom

string

The adom to lock for FortiManager running in workspace mode, the value can be global and others including root.

workspace_locking_timeout

integer

The maximum time in seconds to wait for other user to release the workspace lock.

Default: 300

Notes

Note

  • Running in workspace locking mode is supported in this FortiManager module, the top level parameters workspace_locking_adom and workspace_locking_timeout help do the work.

  • To create or update an object, use state present directive.

  • To delete an object, use state absent directive.

  • Normally, running one module can fail when a non-zero rc is returned. you can also override the conditions to fail or succeed with parameters rc_failed and rc_succeeded

Examples

- hosts: fortimanager-inventory
  collections:
    - fortinet.fortimanager
  connection: httpapi
  vars:
     ansible_httpapi_use_ssl: True
     ansible_httpapi_validate_certs: False
     ansible_httpapi_port: 443
  tasks:
   - name: List of aditional SQL skip index fields.
     fmgr_system_sql_customskipidx:
        bypass_validation: False
        workspace_locking_adom: <value in [global, custom adom including root]>
        workspace_locking_timeout: 300
        rc_succeeded: [0, -2, -3, ...]
        rc_failed: [-2, -3, ...]
        state: <value in [present, absent]>
        system_sql_customskipidx:
           device-type: <value in [FortiGate, FortiManager, FortiClient, ...]>
           id: <value of integer>
           index-field: <value of string>
           log-type: <value in [app-ctrl, attack, content, ...]>

Return Values

Common return values are documented here, the following are the fields unique to this module:

Key

Description

meta

dictionary

The result of the request.

Returned: always

request_url

string

The full url requested.

Returned: always

Sample: "/sys/login/user"

response_code

integer

The status of api request.

Returned: always

Sample: 0

response_data

list / elements=string

The api response.

Returned: always

response_message

string

The descriptive message of the api response.

Returned: always

Sample: "OK."

system_information

dictionary

The information of the target system.

Returned: always

rc

integer

The status the request.

Returned: always

Sample: 0

version_check_warning

list / elements=string

Warning if the parameters used in the playbook are not supported by the current FortiManager version.

Returned: complex

Authors

  • Xinwei Du (@dux-fortinet)

  • Xing Li (@lix-fortinet)

  • Jie Xue (@JieX19)

  • Link Zheng (@chillancezen)

  • Frank Shen (@fshen01)

  • Hongbin Lu (@fgtdev-hblu)