How to correlate which Deployment Area ID corresponds to which Deployment Area name on Spotfire Server in case of multiple deployment areas.

How to correlate which Deployment Area ID corresponds to which Deployment Area name on Spotfire Server in case of multiple deployment areas.

How to correlate which Deployment Area ID corresponds to which Deployment Area name on Spotfire Server in case of multiple deployment areas created on Spotfire server. - Run the following SQL query on the Spotfire Database to find the AREA ID of the deployment area.

    SELECT AREA_ID
    FROM DEP_AREAS_DEF
    WHERE DEP_AREA_NAME='<Replace me with actual Area Name>'
    Replace <> with the Area Name on which new packages were deployed. e.g Production, Test, etc.

- Go to the Spotfire Server machine and browse the following folder/directory.

              For Spotfire server 7.0 and lower versions:

              <Server Installation folder>\tomcat\temp\deploy\

              For Spotfire server 7.5 and higher versions:
               
             <Server Installation folder>\tomcat\temp\TIBCO\TSS\deploy

In this directory there will be multiple folders having name with deployment area ID's.

- Now you can correlate your deployment area name with actual AREA ID returned in above SQL query.