EPM - DataCollection - Get-DesynchronizedSqlReplicas
Overview
Return a list of all desynchronized SQL replicas.
Requirements
This script should be run on an SQL server.
Process
- Ensure Microsoft SQL is installed.
- Check the replication status for any unsynced replicas.
- Return all found unsynced items.
Payload Usage
Describe how the payload is executed and if it requires any parameters. If no parameters are needed, delete the parameter block below. State that this does not use a payload if it doesn’t.
Example:
Get-DesynchronizedSqlReplicas.ps1
This command returns a list of all SQL replication instances that are not synchronized or are synchronizing.
Output
System Object
./Get-DesynchronizedSqlReplicas-log.txt
Locations
| Payload | /repo/scripts/Get-DesynchronizedSqlReplicas.ps1 |
|---|---|
| Automate | |
| ConnectWise RMM | |
| Kaseya | |
| Datto RMM |