Count of all instances of software registered with Add or Remove Programs failsIf I try it from the Primary server (Windows 2008 SP1 x64 running SCCM 2007 SP1 wR2), I get<br/><br/> <p>http internal server error 500.  I have tried adding rowcount under the Reporting key in the registry and set the dword value to 200000.  I did not reboot the server.<br/><br/>I also tried looking for the aspbufferlimit but that doesn't exist in the metabase.xml on Server 2008.  Other reports work fine.  Any ideas?</p>© 2009 Microsoft Corporation. All rights reserved.Tue, 07 Jul 2009 00:31:56 Z7650ce1d-d073-4c2c-94cd-d971add900f6http://social.technet.microsoft.com/Forums/en-US/configmgradminconsole/thread/7650ce1d-d073-4c2c-94cd-d971add900f6#7650ce1d-d073-4c2c-94cd-d971add900f6http://social.technet.microsoft.com/Forums/en-US/configmgradminconsole/thread/7650ce1d-d073-4c2c-94cd-d971add900f6#7650ce1d-d073-4c2c-94cd-d971add900f6gatorcbhttp://social.technet.microsoft.com/Profile/en-US/?user=gatorcbCount of all instances of software registered with Add or Remove Programs failsIf I try it from the Primary server (Windows 2008 SP1 x64 running SCCM 2007 SP1 wR2), I get<br/><br/> <p>http internal server error 500.  I have tried adding rowcount under the Reporting key in the registry and set the dword value to 200000.  I did not reboot the server.<br/><br/>I also tried looking for the aspbufferlimit but that doesn't exist in the metabase.xml on Server 2008.  Other reports work fine.  Any ideas?</p>Wed, 01 Jul 2009 16:29:10 Z2009-07-01T16:29:10Zhttp://social.technet.microsoft.com/Forums/en-US/configmgradminconsole/thread/7650ce1d-d073-4c2c-94cd-d971add900f6#06bb2224-2f9e-4a96-9147-5d63460b23d4http://social.technet.microsoft.com/Forums/en-US/configmgradminconsole/thread/7650ce1d-d073-4c2c-94cd-d971add900f6#06bb2224-2f9e-4a96-9147-5d63460b23d4Kent Agerlundhttp://social.technet.microsoft.com/Profile/en-US/?user=Kent%20AgerlundCount of all instances of software registered with Add or Remove Programs failsHi,<br/><br/>What if you change RowCount to 0xffffffff (hex)?<hr class="sig">Kent Agerlund | http://agerlund.spaces.live.com/blog/Wed, 01 Jul 2009 16:36:27 Z2009-07-01T16:36:27Zhttp://social.technet.microsoft.com/Forums/en-US/configmgradminconsole/thread/7650ce1d-d073-4c2c-94cd-d971add900f6#45ad9053-4f02-470b-9617-25bb2c718234http://social.technet.microsoft.com/Forums/en-US/configmgradminconsole/thread/7650ce1d-d073-4c2c-94cd-d971add900f6#45ad9053-4f02-470b-9617-25bb2c718234gatorcbhttp://social.technet.microsoft.com/Profile/en-US/?user=gatorcbCount of all instances of software registered with Add or Remove Programs failssame thing...is a reboot important after changing the value?...I have the dword right under Reporting not under Reporting\Sitecode.  Is that right?  I picked 32-bit dword tooWed, 01 Jul 2009 16:57:47 Z2009-07-01T16:58:56Zhttp://social.technet.microsoft.com/Forums/en-US/configmgradminconsole/thread/7650ce1d-d073-4c2c-94cd-d971add900f6#e40a9848-0424-48bd-a5ab-abba2d96d7c9http://social.technet.microsoft.com/Forums/en-US/configmgradminconsole/thread/7650ce1d-d073-4c2c-94cd-d971add900f6#e40a9848-0424-48bd-a5ab-abba2d96d7c9Tom Watsonhttp://social.technet.microsoft.com/Profile/en-US/?user=Tom%20WatsonCount of all instances of software registered with Add or Remove Programs failsYou may want to rethink what you will really do with a report that has over 10000 rows in the first place.  I've had requests for massive reports in the past, and when the people asking receive the data, they usually want is broken down in some manner.<br/> <br/> One option would be to take the report code and simply paste it into SQL Management Studio, and run it from there.  Replace any variables with the actual values you want to query against.  You can then export the data from there.<br/> <br/> A similar conversation regarding SMS 2003 reporting limits can be found at http://www.myitforum.com/forums/m_72860/tm.htm<br/> <br/> A different approach would be to look at the Asset Management: Software 6A - Search for Installed Software report.<br/> <br/> Regards,<br/> Tom WatsonThu, 02 Jul 2009 13:20:04 Z2009-07-02T13:20:04Zhttp://social.technet.microsoft.com/Forums/en-US/configmgradminconsole/thread/7650ce1d-d073-4c2c-94cd-d971add900f6#f2469c4e-8c96-426c-877d-a87e52d6af64http://social.technet.microsoft.com/Forums/en-US/configmgradminconsole/thread/7650ce1d-d073-4c2c-94cd-d971add900f6#f2469c4e-8c96-426c-877d-a87e52d6af64gatorcbhttp://social.technet.microsoft.com/Profile/en-US/?user=gatorcbCount of all instances of software registered with Add or Remove Programs failsIt looks like running Report Software 6A works.  It starts to error somewhere between 4225 rows and 4250<br/><br/>ThanksThu, 02 Jul 2009 14:11:26 Z2009-07-02T14:11:26Zhttp://social.technet.microsoft.com/Forums/en-US/configmgradminconsole/thread/7650ce1d-d073-4c2c-94cd-d971add900f6#0dfa5d23-98ce-4386-b283-ae2323e8f686http://social.technet.microsoft.com/Forums/en-US/configmgradminconsole/thread/7650ce1d-d073-4c2c-94cd-d971add900f6#0dfa5d23-98ce-4386-b283-ae2323e8f686Wallyhttp://social.technet.microsoft.com/Profile/en-US/?user=WallyCount of all instances of software registered with Add or Remove Programs failsSo do you have what you want now? If so, then can you mark the question as answered?<hr class="sig">Wally MeadMon, 06 Jul 2009 17:52:30 Z2009-07-06T17:52:30Z