none
SCCM 2012 SP1 Reproting - Reports URL shows unwanted folders.

    General discussion

  • Hi All,

    I have installed SCCM 2012 SP1 & configured reporting in windows SQL server 2012 but the reports url shows many unwanted folders & I am not able to generate reports from the SCCM server.

    Please help.

    Monday, June 10, 2013 6:57 AM

All replies

  • Looks like someone has published/deployed a lot of reports and folders. You have to delete the folders and figure out who is publishing the reports.

    Kent Agerlund | My blogs: blog.coretech.dk/kea and SCUG.dk/ | Twitter: @Agerlund | Linkedin: Kent Agerlund | Mastering ConfigMgr 2012 The Fundamentals

    Monday, June 10, 2013 7:09 AM
    Moderator
  • i am managing the reports & the sccm server, it was there after installing the reporting Role in sccm.

    Thanks,

    Pranay.


    Monday, June 10, 2013 7:31 AM
  • I've never seen that. Is there anything useful in srsrp.log?

    Torsten Meringer | http://www.mssccmfaq.de

    Monday, June 10, 2013 7:50 AM
    Moderator
  • Hi Torsten,

    I dont have this log on my sccm server.

    Monday, June 10, 2013 8:14 AM
  • It's located on the reporting services point.

    Torsten Meringer | http://www.mssccmfaq.de

    Monday, June 10, 2013 8:41 AM
    Moderator
  • SRSRP.log shows this :-

    Monday, June 10, 2013 11:33 AM
  • So are the SQL reporting services running? Can you open http://your-srs-server/Reports and /Reportserver? What SP and CU level (SRS) is it?

    Torsten Meringer | http://www.mssccmfaq.de

    Monday, June 10, 2013 11:58 AM
    Moderator
  • So are the SQL reporting services running?

    ya, i started the reporting services & now the log files are not showing these errors.

    Can you open http://your-srs-server/Reports and /Reportserver?

    ya, i can open these URL. i have deleted all the other folders which were in http://your-srs-server/Reports except CM_NCI folder.

    but reports are still not present in this folder.

    What SP and CU level (SRS) is it?

    I have installed SQL 2012 SP1.

    Monday, June 10, 2013 12:16 PM
  • Hi,

    There was a thread several months ago with the same issue. I adjusted a script I wrote to remove duplicate reports to remove all of the .OLD folders. If you'd like, I'll post it again.

    Monday, June 10, 2013 1:21 PM
  • Hi Mike,

    If you don't mind posting the script to remove duplicate reports, it would be very handy to have.  After I installed SP1, many reports were duplicated in my environment with an "_" prefix in the repot name.

    Monday, June 10, 2013 2:21 PM
  • Hi Tim,

    Here's the script to delete the duplicate reports. The reports were prefixed by TWO underscores in my environment, so you'll need to adjust this slightly to have it look for a single underscore. I've added some comments into the code on what changes to make.

    #######################################################################################################################
    # SCCM2012SP1-RemoveDuplicateSSRSReports.ps1
    # This script will connect to SSRS on a specified server and delete all reports that begin with a double underscore
    # Used for SSRS cleanup after SCCM 2012 SP1 installation
    # Script must be run from an account that has access to modify the SSRS instance
    # 2/15/2013 - Mike Laughlin
    #
    # Resources used in writing this script:
    # Starting point: http://stackoverflow.com/questions/9178685/change-datasource-of-ssrs-report-with-powershell
    # API Documentation: http://msdn.microsoft.com/en-us/library/ms165967%28v=sql.90%29.aspx
    #######################################################################################################################
    
    # Define variables
    	$SiteCode = ""
    	$serverName = ""
    
    # Set the value of $noConfirm to $True only if you don't want to manually confirm report deletion. Use with caution.
    	$noConfirm = $False
    
    # Safeguard	
    	If ( $SiteCode -eq "" -or $serverName -eq "" ) { Write-Host "Enter the required information for the SiteCode and serverName variables before running this script." -ForegroundColor Red -BackgroundColor Black ; Exit }
    
    # Connect to SSRS
    	$ssrs = New-WebServiceProxy -uri http://$serverName/ReportServer/ReportService2005.asmx?WSDL -UseDefaultCredential
    
    # Get a listing of all reports in SSRS
    	$reportFolder = "/ConfigMgr_" + $SiteCode
    	$reports = $ssrs.ListChildren($reportFolder, $True)
    	
    # Find all reports starting with double underscores
    # If the reports are prefixed by a single underscore, comment out the next line and uncomment line 35.
    	$reportsToDelete = $reports | Where { $_.Name.Substring(0,2) -eq "__" } 
    
    # Find all reports starting with single underscores
    #	$reportsToDelete = $reports | Where { $_.Name.Substring(0,1) -eq "_" } 	
    	
    # Quit if no reports are found
    	If ( $reportsToDelete.Count -eq 0 ) { Write-Host "No reports found. Quitting." ; Exit }
    	
    # Show a listing of the reports that will be deleted
    	Write-Host "The following reports will be deleted from SSRS on" $serverName":`n"
    	$reportsToDelete.Name
    	Write-Host "`nTotal number of reports to delete:" $reportsToDelete.Count "`n"
    	
    # Get confirmation before deleting if $noConfirm has not been changed
    	If ( $noConfirm -eq $False ) 
    	{ 
    		$userConfirmation = Read-Host "Delete these reports from" $serverName"? Enter Y or N"
    		If ( $userConfirmation.ToUpper() -ne "Y" ) { Write-Host "Quitting, reports have not been deleted." ; Exit }
    	}
    	
    # Delete the reports
    	$deletedReportCount = 0
    	
    	Write-Host "Beginning to delete reports now. Please wait."
    	ForEach ( $report in $reportsToDelete ) { $ssrs.DeleteItem($report.Path) ; $deletedReportCount++ } 
    	Write-Host "Reports have been deleted. Total number of deleted reports:" $deletedReportCount

    Standard disclaimer: While this script worked just fine for me in my environment, I make no guarantees that it will work anywhere else. I've attempted to make this script as user friendly and generic as possible, but it may require slight tweaking to work properly.

    Pranay,

    Please let me know if you'd like to me to post the script that will handle the .OLD folder deletion.


    Monday, June 10, 2013 2:36 PM
  • Hi Mike,

    Thanks for sharing the script.

    But my problem is that i have deleted all the folder's from the report URL manually except the CM_NCI folder.

    but still the reports are not getting generated.

    when deleting the report folder do i need to take care about other things ??

    Thanks,

    Pranay.

    Tuesday, June 11, 2013 4:31 AM
  • Hi Pranay,

    I didn't actually run into these issues myself, all I did was adjust the script I posted above to remove the .OLD.* report folders. Sorry, I don't really have much else to add.

    Tuesday, June 11, 2013 4:22 PM
  • hi all thanks for your reply,

    I uninstalled the Reporting service point from my sql server(present under Server & site system roles in SCCM) & then remove each & every folder from the Report URL.

    Then installed it again, finally it worked for me.I am able to generate the reports now.

    But, don't have idea about how & why those folders were generated.

    it would be great if some one can explain the cause.

    Thanks,

    Pranay.

    Wednesday, June 12, 2013 6:41 AM
  • Hi all,

    We are getting this problem in most of our installation, the sql version which we were using are sql server 2012, sql server 2008 r2 sp2 with SCCM 2012 SP1.

    the folders are created in a sequence from 0-9.

    e.g. ConfigMngr_SiteName.OLD(0-9),(1.0-1.9)....(9.0-9.9)

    I have deleted the folder & reinstalled the Reporting role in SCCM 2012 SP1 & SQL 2008 R2 SP1 site but it didn't worked & I tried the same steps earlier in SQL 2012 & it worked fine.

    Now, i have few questions :-

    1.How these folders are getting generated.

    2.Is there a sure shot Work around for this problem.

    Thanks,

    Pranay.

    Tuesday, June 25, 2013 8:50 AM
  • I had this same issue after the SP1 upgrade back in February.  I have folders up to _661.  The last one created was February 13th 2013.  My reports were missing from the console, so I had to copy them from one of the OLD_0 or 1 folder back to the ConfigMgr_SITE folder (from Reporting site), and I do not recall if i re-installed the reporting components or not.  Things are fine now, but I was not about to manually try to delete those folders, and since they all appeared to be empty (not containing any reports) I did not worry about them.  Hope this helps some one in the future.
    Thursday, September 19, 2013 4:44 PM
  • Please let us know if you get additional OLD report folders in the future.


    Thanks,

    Mark

    mark.mears@cireson.com

    Check out our System Center App Store: http://www.cireson.com/app-store

    Thursday, September 19, 2013 5:01 PM
  • I had this same issue after the SP1 upgrade back in February.  I have folders up to _661.  The last one created was February 13th 2013.  My reports were missing from the console, so I had to copy them from one of the OLD_0 or 1 folder back to the ConfigMgr_SITE folder (from Reporting site), and I do not recall if i re-installed the reporting components or not.  Things are fine now, but I was not about to manually try to delete those folders, and since they all appeared to be empty (not containing any reports) I did not worry about them.  Hope this helps some one in the future.

    I'll post the script I mentioned above that will remove the .OLD.* folders for you:

    ######################################################################################################################################
    # SCCM2012SP1-RemoveDuplicateSSRSFolders.ps1
    # This script will connect to SSRS on a specified server and delete all folders that end with .OLD.*
    # Used for SSRS cleanup after SCCM 2012 SP1 installation
    # Script must be run from an account that has access to modify the SSRS instance
    # 3/22/2013 - Mike Laughlin
    #
    # Resources used in writing this script:
    # Starting point: http://stackoverflow.com/questions/9178685/change-datasource-of-ssrs-report-with-powershell
    # API Documentation: http://msdn.microsoft.com/en-us/library/ms165967%28v=sql.90%29.aspx
    # Previous script: http://social.technet.microsoft.com/Forums/en-US/configmanagergeneral/thread/dc9aa3b4-cea9-4a07-87ca-2795a2dbc04e
    ######################################################################################################################################
    
    # Define variables
    	$SiteCode = ""
    	$serverName = ""
    
    # Set the value of $noConfirm to $True only if you don't want to manually confirm folder deletion. Use with caution.
    	$noConfirm = $False
    
    # Safeguard	
    	If ( $SiteCode -eq "" -or $serverName -eq "" ) { Write-Host "Enter the required information for the SiteCode and serverName variables before running this script." -ForegroundColor Red -BackgroundColor Black ; Exit }
    
    # Connect to SSRS
    	$ssrs = New-WebServiceProxy -uri http://$serverName/ReportServer/ReportService2005.asmx?WSDL -UseDefaultCredential
    
    # Get a listing of all folders in SSRS
    	$reportFolders = $ssrs.ListChildren("/", $True)
    	
    # Find all folders containing .OLD.*
    	$foldersToDelete = $reportFolders | Where { $_.Name -like "ConfigMgr_" + $SiteCode + ".OLD.*"}
    	
    # Quit if no folders are found
    	If ( $foldersToDelete.Count -eq 0 ) { Write-Host "No folders with .OLD.* found. Quitting." ; Exit }
    	
    # Show a listing of the folders that will be deleted
    	Write-Host "The following folders will be deleted from SSRS on" $serverName":`n"
    	$foldersToDelete.Name
    	Write-Host "`nTotal number of folders to delete:" $foldersToDelete.Count "`n"
    	
    # Get confirmation before deleting if $noConfirm has not been changed
    	If ( $noConfirm -eq $False ) 
    	{ 
    		$userConfirmation = Read-Host "Delete these folders from" $serverName"? Enter Y or N"
    		If ( $userConfirmation.ToUpper() -ne "Y" ) { Write-Host "Quitting, folders have not been deleted." ; Exit }
    	}
    	
    # Delete the folders
    	$deletedFolderCount = 0
    	
    	Write-Host "Beginning to delete folders now. Please wait."
    	ForEach ( $folder in $foldersToDelete ) { $ssrs.DeleteItem($folder.Path) ; $deletedFolderCount++ } 
    	Write-Host "Folders have been deleted. Total number of deleted folders:" $deletedFolderCount

    Again, standard disclaimer: While this script worked just fine for me in my environment, I make no guarantees that it will work anywhere else. I've attempted to make this script as user friendly and generic as possible, but it may require slight tweaking to work properly.


    Don't retire TechNet! - (Maybe there's still a chance for hope, over 11,925+ strong and growing)

    Friday, September 20, 2013 12:38 AM