Spotlight versions 11.x and below:
1. Go to default installation of Spotlight Diagnostic Server: C:\Program Files\Quest Software\Diagnostic Server\Agent\bin folder
2. Copy SpotlightDiagnosticServer.ini file to another path outside of here like you Desktop. Important not to rename or make a backup in the same folder.
3. Open file with Notepad.
4. Change this line and increase it's value, i.e. 30000:
"-Dcom.quest.adk.rowLimit=10000"
5. Save file and close
6. Restart Diagnostic Server services
Spotlight version 12.0 and above:
1. Go to default installation of Spotlight Diagnostic Server: C:\Program Files\Quest Software\Diagnostic Server\Agent\conf folder
2. Copy DiagnosticServer.Properties file to another path outside of here like you Desktop. Important not to rename or make a backup in the same folder.
3. Open file with Notepad.
4. Change this line and increase it's value, i.e. 30000:
"-Dcom.quest.adk.rowLimit=10000"
5. Save file and close
6. Restart Diagnostic Server services