SCCM Reporter (Freeware)

SCCM Reporter is a simple Reporting Tool for the SCCM Database (SQL).

Before you start choose a Connect String to the SCCM SQL Database:


1. 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"
   
   
2. SCCM Reporter Features:

   Status	Feature
   	Get a List of all SCCM Applications
   	Get a List of all SCCM Collections
   	Get a List of all SCCM Collections and Members
   	Get a List of all SCCM ContentSource
   	Get a List of all SCCM Deployments
   	Get a List of all SCCM DeploymentStatus
   	Get a List of all SCCM NetworkPrinters
   	Get a List of all SCCM Software Metering Results
   	Get a List of all SCCM Software Metering Rules
   	Get a List of all SCCM Systems
   	Get a List of all SCCM Systems with Malware Threats
   	Define customized Queries for several Clients in Collections
   	Get Error and Error Description for several Clients in Collections
   	...

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