Contens
|
SCCM Reporter (Freeware)
- 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.
- 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 Version 0.9.0.8 (C#, .NET 4)
sccmrepo.exe Any CPU
sccmrepo.chm Help File
SCCM_ERROR_CODES.txt
|