Having your reports prompt for a collection

Once again….. just more great stuff I found. Building a report in SCCM can be simple – but that doesn’t mean it’s easy. Here’s a great Blog Post about how to get your reports to prompt for a collection to run against.




Report Builder 3.0 Unable to connect to Dataset

So, I had an issues with Report Builder not wanting to connect to the Database due to a certificate chain error in the prelogon handshake. I found this great post on TechNet Forums about the issue and it fixed it for me. There are detailed instructions on how to import the SCCM Database server’s certificate into your trusted root.


Start>run>mmc>file>add/remove snapins>certificate>Computer Account>Local Computer>Certificates>Personal>Certificates>Issued to: Name of server

 Look at each cert.  On the 3<sup style=”color:#1f497d;”>rd</sup> tab (Certification Path) it should say “ConfigMgr SQL Server Identification Certificate”.  Export that cert.

Then on the machine running report builder, import the certificate to the local computer trusted root.

SCCM Query Builder results limited to 2000

SCCM Query Builder results limited to 2000

While building Queries in SCCM Query Builder, you will sooner or later run into an issue where it will only return 2000 items. This is a legacy setting that goes back to SMS 2.0 where the server/PC would literally run out of memory to return more than that. Head over to Peter Daalmans’s Blog for the complete answer, but here’s a snippet in case his blog goes down….

For 32bits ConfigMgr 2012 Consoles on 64bits go to the following registry key:

  • HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\ConfigMgr10\AdminUI\QueryProcessors

Otherwise go to the following registry key:

  • HKEY_LOCAL_MACHINE\SOFTWARE \Microsoft\ConfigMgr10\AdminUI\QueryProcessors

Add a DWORD value for ValueLimit and set it to a, for you appropriate value. (eg. decimal value 10000)

After adding and changing the value and restarting the ConfigMgr Console you are able to see all values.