VhdZdZdZy)a --- module: sp_whoisactive short_description: Install/update C(sp_whoisactive) by Adam Mechanic description: - A wrapper for C(Install-DbaWhoIsActive) to fetch the latest version of the script, or install from a local cached version. version_added: 0.1.0 options: 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 type: str required: false database: description: - Name of the target database. type: str required: true force: description: - If this switch is enabled, then C(sp_WhoisActive) will be downloaded from the internet even if previously cached. type: bool default: false author: "John McCall (@lowlydba)" requirements: - L(dbatools,https://www.powershellgallery.com/packages/dbatools/) PowerShell module extends_documentation_fragment: - lowlydba.sqlserver.sql_credentials - lowlydba.sqlserver.attributes.check_mode - lowlydba.sqlserver.attributes.platform_all z - name: Install/Update sp_whoisactive lowlydba.sqlserver.sp_whoisactive: sql_instance: sql-01.myco.io database: lowlydb z data: description: Output from the C(Install-DbaWhoIsActive) function. returned: success, but not in check_mode. type: dict N) DOCUMENTATIONEXAMPLESRETURNu/home/dcms/DCMS/lib/python3.12/site-packages/ansible_collections/lowlydba/sqlserver/plugins/modules/sp_whoisactive.pyrs  D  r