SCCM Reporter (Freeware)

1. SCCM Reporter is a Reporting Tool for SCCM SQL Databases.
   It resolves the hierarchical structure of Collections and included Collections
   stored in a relational SCCM SQL Database.
   Make sure you have read access to your instance of the SCCM SQL Database!
   (e.g. with integrated Windows Security)
   It includes Queries for Applications and Deploymenttypes where Properties are stored in XML Format.
2. Before you start choose a Connect String to the SCCM SQL Database:
   You have 3 Options:
   • ADO: Server=tcp:sccm.org.net; Database=CMDB; Integrated Security=true
   • OLE: Provider=sqloledb; Server=sccm.org.net; Database=CMDB; Integrated Security=SSPI
   • ODBC: Use in Toolbar to define an ODBC User DSN:
     - Enter a name for the DSN, a description and the name of your SQL Server.
     - Use Windows Authentication and set the Standard DB to SCCM Content DB.
     - Specify the Connect String: DSN= in the SQL Reporter Settings.
     An ODBC USER DSN with SQL Driver can also be importet in the Registry:
     REGEDIT4
// Your SCCM Server USE THIS USER DSN in SCCM Reporter
[HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\sccm.org.net]
"Driver"="C:\\Windows\\system32\\SQLSRV32.dll"
"Description"="sccm.org.net" // Your SCCM Server
"Database"="CMDB" // Your SCCM SQL DATABASE
"Trusted_Connection"="Yes"
   
   
3. Download and register SCCM_Views.reg to explorer a set of SCCM Views described in
   https://learn.microsoft.com/en-us/previous-versions/system-center/system-center-2012-R2/dn581978(v=technet.10)

SCCM Reporter Version 0.9.0.9 (C#, .NET 4)
sccmrepo.exe Any CPU
sccmrepo.chm Help File
SCCM_ERROR_CODES.txt
SCCM_Views.reg