COOPWARE © Coopware 2022

Contens

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 All Applications

SCCM Reporter Collection and Members

SCCM Reporter Network Details

SCCM Reporter Edit Query

SCCM Reporter My Deployment Status

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