Skip to content

SQL version detection and reporting in SCCM ?

Featured Replies

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

 

  • Author

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?

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.

 

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.