Microsoft SQL server play

[area0]

Hi guys,

Just wondering what's the best way to run an SQL UPDATE on a remote Microsoft SQL database; the idea is that, once a machine runs through the win_updates module, a field in the SQL database called 'last patched' is updated to the current day/time.

Am i looking at the command module with DSN/username/password in the playbook?

Thanks guys