How to check SSRS version by querying database?

Mughees, Muhammad 0 Reputation points
2024-04-22T18:08:28.3033333+00:00

Hello,

Is there a way to query SSRS version currently installed using TSQL? In sql server 2019 there is a table 'ProductInfoHistory' and it looks like it keeps the history but I have noticed that it is not consistent and I do not see it updated when I apply the latest ssrs update/patch. However, the log file reflects the latest patch info.

Is 'ProductInfoHistory' table officially supported by Microsoft? I could not find any documentation about this table.

Thanks

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,827 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Greg Low 1,495 Reputation points Microsoft Regional Director
    2024-04-23T00:40:41.6366667+00:00

    I wish this was easier but it's not.

    As you noted, the database and its contents don't reflect the version of the SSRS service directly. In addition, over the years, they often don't even increase the database compatibility level when you move between versions, including if you apply an in-place upgrade.

    You need to find out what version the service is, rather than the database. You can query that by looking at the value returned when you open the report server URL like: //servername/reportserver

    Note the example for mine:

    User's image


  2. ZoeHui-MSFT 33,626 Reputation points
    2024-04-23T03:01:46.7133333+00:00

    Hi @Mughees, Muhammad,

    The best way is checking report server configure manager to get the directly result.

    User's image Also, i have not found the docs about ProductInfoHistory table. Not sure if we upgrade the SSRS will the table value changed or not.

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.