lowlydba / lowlydba.sqlserver / 2.3.2 / module / sp_whoisactive Install/update C(sp_whoisactive) by Adam Mechanic | "added in version" 0.1.0 of lowlydba.sqlserver" Authors: John McCall (@lowlydba)lowlydba.sqlserver.sp_whoisactive (2.3.2) — module
Install with ansible-galaxy collection install lowlydba.sqlserver:==2.3.2
collections: - name: lowlydba.sqlserver version: 2.3.2
A wrapper for C(Install-DbaWhoIsActive) to fetch the latest version of the script, or install from a local cached version.
- name: Install/Update sp_whoisactive lowlydba.sqlserver.sp_whoisactive: sql_instance: sql-01.myco.io database: lowlydb
force: default: false description: - If this switch is enabled, then C(sp_WhoisActive) will be downloaded from the internet even if previously cached. type: bool database: description: - Name of the target database. required: true type: str local_file: description: - Specifies the path to a local file to install sp_WhoisActive from. - This can be either the zip file as distributed by the website or the expanded SQL script. - If this option is not specified, the latest version will be downloaded and installed from https://github.com/amachanic/sp_whoisactive/releases required: false type: str sql_instance: description: - The SQL Server instance to modify. required: true type: str sql_password: description: - Password for SQL Authentication. required: false type: str sql_username: description: - Username for SQL Authentication. required: false type: str
data: description: Output from the C(Install-DbaWhoIsActive) function. returned: success, but not in check_mode. type: dict