How to run single powershell command on ansible?

Question

Here is the powershell command on my playbook:

- name: "Execute Powershell from Ansible"
  ignore_errors: yes
  ansible.windows.win_shell: (Get-Acl -Path "C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Binn") | Format-list

Here is error from ansible:

{
"ansible_loop_var": "item",
"_ansible_no_log": false,
"item": "(Get-Acl -Path \"C:\\Program Files\\Microsoft SQL Server\\MSSQL13.MSSQLSERVER\\MSSQL\\Binn\") | Format-list",
"changed": false,
"msg": "Get-AnsibleParam: Missing required argument: _raw_params",
"_ansible_item_label": "(Get-Acl -Path \"C:\\Program Files\\Microsoft SQL Server\\MSSQL13.MSSQLSERVER\\MSSQL\\Binn\") | Format-list" 
}

Kevin C · Accepted Answer · 2020-10-14 17:10:54Z

2

The error is

Missing required argument: _raw_params

Escape the quotes the other way, like this:

- name: Execute Powershell from Ansible
  ansible.windows.win_shell: |
    Get-Acl -Path "C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Binn" | Format-list

And also, do not use ignore_errors: yes as the first module to use.

edited Oct 14, 2020 at 17:10

answered Oct 14, 2020 at 11:48

Kevin C

5,9069 gold badges39 silver badges79 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

ifu1 · Accepted Answer · 2020-10-14 16:00:37Z

1

Solved! Here is the yaml:

- name: Execute Powershell from Ansible
  win_shell: |
    Get-Acl -Path "C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Binn" | Format-list
    Get-Acl -Path "C:\Program Files\Microsoft SQL Server\130\COM" | Format-list
    Get-Acl -Path "C:\Program Files\Microsoft SQL Server\130\Shared" | Format-list
    Get-Acl -Path "C:\Program Files\Microsoft SQL Server\130\Shared\ErrorDumps" | Format-list

answered Oct 14, 2020 at 16:00

ifu1

252 silver badges6 bronze badges

Collectives™ on Stack Overflow

How to run single powershell command on ansible?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related