Cannot export all of the rows from the Deadlocks table from the SQL Server agent (4228520)

The SQL PI deadlock dashboard in the SQL Server agent displays the number of Deadlocks has 2829 deadlock but can only export 679 of those deadlocks.

Please follow the steps below to apply a change to the function.

1. Navigate to Configuration | Definitions in the Foglight Management Console
2. Select the All Definitions item
3. Search for system:dbwc_mssql_realtime_sql20activity_deadlocks.14
4. Select the function named Process Deadlock Data
5. Click the Edit button to edit the Process Deadlock Data function
6. Add the following line below the line "import java.sql.Timestamp". The number is the count of the deadlocks. This can be modified to the value that you want.
7. Click the Save button for the function.

* Please note that the FMS userid must have the "Cartridge Developer" role to make a change to the function.