Uggg. Just move to SSRS and be done with these obsolete, and busted settings. ;)
From: [email protected] [mailto:[email protected]] On Behalf Of Daniel Ratliff Sent: Thursday, July 25, 2013 9:05 AM To: [email protected] Subject: [mssms] RE: SCCM Report to return more than 10K rows Yes, that setting is also referenced in the link I posted. They are just using a script to do it. I think there is a SQL chance you have to make too, but I cannot remember off hand. Daniel Ratliff Technology Consultant | Client Innovation Technologies Humana 123 E. Main St. | Louisville, KY, 40202 T 502.476.9976 [email protected]<mailto:[email protected]> From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Mukherjee, Surajit Sent: Thursday, July 25, 2013 10:59 AM To: [email protected]<mailto:[email protected]> Subject: [mssms] RE: SCCM Report to return more than 10K rows Hi Daniel, Do you mean to say I should do the below from http://support.microsoft.com/kb/925764 . To increase the buffering limit, follow these steps: 1. Click Start, click Run, type cmd, and then click OK. 2. Type the following command, and then press ENTER: cd /d %systemdrive%\inetpub\adminscripts 3. Type the following command, and then press ENTER: cscript.exe adsutil.vbs SET w3svc/aspbufferinglimit LimitSize Note LimitSize represents the buffering limit size in bytes. For example, the number 67108864 sets the buffering limit size to 64 MB. Best Regards, Surajit From: [email protected]<mailto:[email protected]> [mailto:[email protected]]<mailto:[mailto:[email protected]]> On Behalf Of Daniel Ratliff Sent: Thursday, July 25, 2013 5:12 PM To: [email protected]<mailto:[email protected]> Subject: [mssms] RE: SCCM Report to return more than 10K rows You have to configure an IIS setting and the reg setting as well to allow it to return more than 10000 rows. http://social.technet.microsoft.com/Forums/systemcenter/en-US/a4d116e6-82d8-43de-9e8a-84a395343912/reporting-limit-10000-records<https://urldefense.proofpoint.com/v1/url?u=http://social.technet.microsoft.com/Forums/systemcenter/en-US/a4d116e6-82d8-43de-9e8a-84a395343912/reporting-limit-10000-records&k=%2FbkpAUdJWZuiTILCq%2FFnQg%3D%3D%0A&r=29CGw0FLmvm9zusO71hppmbSyI7WC4xlwL9K0rW1DgI%3D%0A&m=gKtKlJalDE3kbl14FzlCjosFCHIEU51IoP32Wnz3k%2Bo%3D%0A&s=c0c54fd79d1e3ea4322940cbc357944af93de8a21060746108a03bdd8fd93101> Daniel Ratliff From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Mukherjee, Surajit Sent: Thursday, July 25, 2013 7:08 AM To: [email protected]<mailto:[email protected]> Subject: [mssms] SCCM Report to return more than 10K rows Hi, Any help on this. I tried from MS http://technet.microsoft.com/en-us/library/bb680885.aspx<https://urldefense.proofpoint.com/v1/url?u=http://technet.microsoft.com/en-us/library/bb680885.aspx&k=%2FbkpAUdJWZuiTILCq%2FFnQg%3D%3D%0A&r=29CGw0FLmvm9zusO71hppmbSyI7WC4xlwL9K0rW1DgI%3D%0A&m=gKtKlJalDE3kbl14FzlCjosFCHIEU51IoP32Wnz3k%2Bo%3D%0A&s=83246e1fddffe9488a186f8e99b50ab3da8a497fc77663e44424d4a4ef2fe284> but did not work for me. Best Regards, Surajit _____________ The information contained in this message is proprietary and/or confidential. If you are not the intended recipient, please: (i) delete the message and all copies; (ii) do not disclose, distribute or use the message in any manner; and (iii) notify the sender immediately. In addition, please be aware that any message addressed to our domain is subject to archiving and review by persons other than the intended recipient. Thank you. The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information. _____________ The information contained in this message is proprietary and/or confidential. If you are not the intended recipient, please: (i) delete the message and all copies; (ii) do not disclose, distribute or use the message in any manner; and (iii) notify the sender immediately. In addition, please be aware that any message addressed to our domain is subject to archiving and review by persons other than the intended recipient. Thank you. The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information.
