SQL version detection and reporting in SCCM ?

[spgsitsupport]

There is this:

https://sccm-zone.com/sql-version-detection-and-report-sccm-2012-r2-12f299b5e63b

which is inaccurate in places.

Supplied .rdl is unusable (at least on RS 2012 R2) die to:

https://connect.microsoft.com/SQLServer/feedback/details/2050151/rdl-2016-schema-moved-taken-down

Kind of solution is here:

https://stackoverflow.com/questions/36272514/the-report-definition-has-an-invalid-target-namespace-rsinvalidreportdefinition

but still does not work:

The definition of this report is not valid or supported by this version of Reporting Services. The report definition may have been created with a later version of Reporting Services, or contain content that is not well-formed or not valid based on Reporting Services schemas. Details: The element 'Report' in namespace 'http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition' has invalid child element 'Body' in namespace 'http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition'. List of possible elements expected: 'Description, Author, AutoRefresh, InitialPageName, DataSources, DataSets, ReportParameters, Code, EmbeddedImages, Language, CodeModules, Classes, CustomProperties, Variables, DeferVariableEvaluation, ConsumeContainerWhitespace, DataTransform, DataSchema, DataElementName, DataElementStyle, ReportSections' in namespace 'http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition' as well as any element in namespace '##other'. (rsInvalidReportDefinition)

Anybody knows a solution that can be easily implemented?

Thanks

Seb

 

edit:

Also tried https://gallery.technet.microsoft.com/scriptcenter/SQL-Version-Report-in-SCCM-61d46820

Imports fine to SSRS, but on running I get error

An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for dataset 'DataSet1'. (rsErrorExecutingCommand)
For more information about this error navigate to the report server on the local server machine, or enable remote errors

 

[GarthMJ]

I can tell you that the MOF edit listed within your first will product wildly inaccurate results.

I can tell you that this blog post will help with showing you the true error within your SSRS RDL.

https://www.enhansoft.com/blog/turn-on-remote-error-reporting

 

[spgsitsupport]

Is there any better way then the "wrongly" edited mof from first link?

OK, with Remote Errors Enabled I have:

 

An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for dataset 'DataSet1'. (rsErrorExecutingCommand)
Invalid object name 'CM_VSM.dbo.v_GS_CUSTOM_SQL_2014_Property_2_00'.

Obviously something wrong with report?

[GarthMJ]

Just to be clear the MOF edit will give you no results when you don't have WMI provided installed for SQL, one of the SU removed it and it never gets put back. Or you will get duplicated results if you have two or more different version of SQL installed on the same computer.

Now as for others there is product that will give you this and a lot more. PM me if you want more details.

 

[GarthMJ]

BTW What the SSRS error is telling you, is that the there is no SQL view called that within the CM database.

[spgsitsupport]

I will just create/run report on Lansweeper

Job done, WAY easier!

Seb