COOPWARE © Coopware 2024

Contens

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.
    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"

SCCM Reporter All Collections

SCCM Reporter Add Collection

SCCM Reporter Network Details

SCCM Reporter Edit Query

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