Pages

Monday 4 February 2013

Unable to display all rows in SCCM reports

Just recently I found a few of our larger reports weren't displaying/returning all rows properly so a call went into MS with the following resolution:



Issue:-

Unable to view complete Reports. Row count limited to 2035

Cause:-

                1> ASP buffer Limit was set to false

2> Buffer limit was using default settings.

Resolution:-

                1> Enable the Buffer Limit to true.

2>. On all computers on which a reporting point is enabled, run Regedt32 or

 Regedit.

3. Navigate to the following registry key:

               \HKEY_LOCAL_MACHINE\Software\Microsoft\SMS\Reporting

               or on a 64 bit Operating System:

\HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\SMS\Reporting

4. In the Reporting key, create a DWORD value named Rowcount, edit this value, and enter ffffffff for this new entry.

5. All rows should now be returned by any report query run from this reporting point.

 Open command prompt to C:\Inetpub\AdminScripts and run the following command:

 Cscript adsutil.vbs set w3svc/aspbufferinglimit "209715200"

6. Restart the IIS and SMS_Reporting services.

No comments:

Post a Comment

Let me know if this helped.

I'd really appreciate any comments (well, only nice ones) so please feel free to let me know what you think of the blog and also ask for further help...