0

I am part of a team that is working on moving over our existing SCCM system from 2007 to 2012. The reports have been migrated over, but most of the queries do not work due to inconsistencies in the table and column names.

As a result, I need to modify the migrated reports to reflect the table and column names in SCCM 2012. There are over 1000 reports, so I would like to script this process.

Is there a way to modify an SCCM report programmatically, via WMI, instead of through the SCCM console?

Phil Gabardo
  • 142
  • 11

1 Answers1

0

Here's a powershell script that can find/replace text in multiple files:

PowerShell Script to Find and Replace for all Files with a Specific Extension

Perhaps you could copy all the rdl files from their location on the existing MSSRS server (for me it's X:\SMS_SRSRP\Reports) to a temporary location, modify them with a variation of the script above (doing multiple find/replace loops for each DB item that needs to be changed), and then copy the modified files to your new MSSRS server.

Community
  • 1
  • 1
Mike Frazer
  • 1
  • 2
  • You should add the code here in case the linked page changes. The link should be also given, but just for reference purposes. – ZygD May 07 '15 at 19:09