I am working on extracting the subscription parameters from the SSRS report server DB. I have parsed the XML out so that I get the parameter name and its value. See here. However, a lot of the values for these reports are stored as some sort of numeric value – almost like it’s an ID. The numeric value is of course useless to me and it wouldn’t be feasible to go through hundreds of reports on the webpage to find out what the parameter values really mean.

Here is an example: The value for parameter name Facility may be stored as 152540000001 but represented as ‘Site1″ on the actual webpage.

Has anyone ran into this before? I tried searching all of the tables and couldn’t find the id or string value in any. Would like to know how SSRS is mapping these numeric values to the string on the webpage so I can pull them.