I'm trying to use a combination of the SQL Server 2008 Reporting Services ReportServer database and the report server web service to determine the GUID for a particular report. What I want is to see a list of the previous names of a report that has been renamed or moved on the report server. I know a report's history snapshots stays with it when you rename it because the report has a unique GUID that doesn't change when you rename it. However, I can't seem to find a place in the database where previous names of a report are associated with the report's GUID. I can't find any instance of an old report name in the database, so I don't know if this is even stored. When I look at all the values of Catalog.Path and Catalog.Name in the database, the old values are not included from before the report rename. Is it possible, given a value like MyAwesomeReport, to associate that with a GUID like 7af3fe6d-b4ea-4cd8-8430-280392cba428, so that I can determine that this report has actually been renamed to MySuperAwesomeReport?
reporting services - determining report GUID from old report name
1.1k Views Asked by Sarah Vessels At
1
There are 1 best solutions below
Related Questions in SQL-SERVER-2008
- How to create separate rows for each unique value in source data
- How to Multiply all values within a column with SQL like SUM()
- Concatenated string in column alias
- Column value divided by row count in SQL Server
- MSSQL Bulk Insert CSV - Multiple columns include commas
- String to DATETIME with TimeZone
- Compare each records of same table in sql server and return duplicates
- 2008R2 SQL Code for case when using the SUM?
- Separate string into columns
- Pass parameters to sql agent job step (Transact-SQL Script)
- using Case get values from different table in sql server
- How to use Replace an unknown length of characters in SQL Server?
- Join Multiple table without using joins
- call an sql function by name returned by select
- How to create a check (Table A.Id and Table B.Id and TypeId = 1)?
Related Questions in REPORTING-SERVICES
- Pass multiple account variables to single parameter
- Update SSRS security for reports
- SSRS Report Expression, for 2 fields in one column
- How to assign dataset values in RDLC report header?
- SSRS Multi-Value Parameter Not Filtering
- Toggle groups based on a parameter
- How to build rptproj using C#
- Don't produce report if there is no data - PDF
- SSRS ListRenderingExtension Unauthorised Exception
- SSRS Color Expression Lesser than X
- Format Numbers in Multiple columns of SSRS Report
- Create Sum of calculated columns in Microsoft Reporting Services like Fibonacci series
- SSRS parameter Datatypes
- creating many reports from a single template - what is this called?
- SSRS Add Parent Group to Entire Tablix
Related Questions in REPORT
- Update SSRS security for reports
- parameter passing while generating report in ASP.NET
- Don't produce report if there is no data - PDF
- mysql -how can we store Testng results to database
- How can I hide a standard report from the print button pull down menu list on Odoo 8?
- SSRS 2012 - Hide Duplicate Rows
- INST-07407: Unable to detect machine platform or JVM bits while installing oracle forms and reports
- Writing doc output to pdf
- SQL Datename within a function
- Write a docx and password protect it
- Export Moodle report in csv file
- Using SQL Can I get incremental changes in data from query results? Loops?
- Conditional Formatting via VBA MS Access Report not working
- Insert a plot inside a paragraph
- STM32 USB HID reports
Related Questions in SSRS-2008
- How to build rptproj using C#
- Format Numbers in Multiple columns of SSRS Report
- creating many reports from a single template - what is this called?
- Find Mondays between 2 dates
- Show a message to the user instead of blank report
- SSRS Tablix - Total with Top N
- How to repeat Left Most rows for a group in SSRS report
- If else Condition in PostgreSql
- How can I eliminate #error in SSRS expression when subtracting by field that may or may not be null?
- How to implement multiselect with new columns in SSRS
- Tablix in Tablix - Header not repeating
- Why rsAccessDenied error on SSRS when using Chrome but not in IE
- If A Not Equal to B in SSRS
- Make whole SSRS report repeat by groups
- Colour Formatting Based on Conditions
Related Questions in REPORTSERVER
- how to use formula in Pentaho Mondrian schema XML
- SSRS2008 Subreport not found
- reporting services - determining report GUID from old report name
- How to behave with GUID column in a self-reference table
- SetDataSourceCredentials for ReportViewer works only for first page of report
- Implementing single sign on with gluu on reportserver
- Stopping ReportServer execution logs Deletion
- Expression to calculate % in a report
- ReportServer database - Users have access to which reports?
- SQL ReportServer 2005 on Win Server 2008 & IIS7 gets "unable to load client print control"
- Where to install ReportServer
- What's the best way to style the default virtual directory listing in SSRS?
- Unable to upload report to report server
- Error when running database script Report Server Configuration Manager
- Running Database Script Error SQL Server/ Report Server
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
I think the easiest way for you to be able to determine a history for these is to build your own ETL script which would look up the current name of the reports, stored by GUID, and hold this in another structure. Having looked through the ReportServer database, I don't believe the name attribute of a report is held historically. I would based my implementation for this off the Sample Code for Reporting Utilization Stat's which is available in the examples on codeplex. I'll see if I can find the link to that example, its how I learned the most about how the ReportServer database is used and structured.