SCCM - Change the maximum number of rows displayed in the reports

If you ever wonder how to change the maximum number of returned rows in SCCM reports I will explain it now.

The default number is 10000 rows. I have tested up to 300K rows and it was fine.

First create a DWORD named Rowcount in HKLM\SOFTWARE\Wow6432\Microsoft\SMS\Reporting for 64-bit and HKLM\SOFTWARE\Microsoft\SMS\Reporting for 32-bit in your server hosting the Reporting Point.

To change to the maximum possible number of rows set the DWORD to the hexadecimal value of ffffffff (8 f's). Now test it.

If that didn't work then you have to change the AspBufferingLimit in IIS. If you have IIS 6 go to C:\Windows\System32\inetsrv and edit the file MetaBase.xml

Now search for AspBufferingLimit and change it's value according to your requirements.

4194304 is the default and can handle 10000 rows, so to change it to 100K rows just add one 0 to the end. e.g. 41943040

If you are using IIS 7 then you have to make the changes directly in the console. Open IIS and double click the ASP icon. Now expand Limit Properties and change the Response Buffering Limit to your requirements.