How to find the physical location of SDMS files associated with a specific object in Statistica Enterprise ?

How to find the physical location of SDMS files associated with a specific object in Statistica Enterprise ?

1. Select the Statistica Enterprise object for which you would like to find the corresponding SDMS Versioning documents and take a note of the ID at the right bottom of Statistica Enterprise Manager. For instance, in the example below, we are looking at a data configuration with ID=83



2. Login to the database that stores the SDMS tables corresponding to your Statistica enterprise.This can be determined with the help of the article : https://support.tibco.com/s/article/How-to-determine-SDMS-Meta-database
3. We will have to map this to some terminology depending on the type of Statistica Enterprise objects listed below:

• Data Configurations - profile
• Analysis Configurations/Workspaces - monitor
• Binary documents -bin_doc
• Reports - monitor_ext_data

4. Run the SQL :
     SELECT * from SDMDOCUMENTS where BASENAME='[term from step 3]_[ID from step 1]'



5. Copy the DOC_GUID from the query result and execute the query :
  Select * from SDMDOCREVISIONS where DOC_GUID='[GUID that was result of step 4]'



6. Navigate to the path specified in PathName of the the meta database and look up the path in the physical SDMS Server .For help on how to locate the SDMS Server, refer to : https://support.tibco.com/s/article/How-to-locate-the-SDMS-Server-that-SDMS-Client-Enterprise-manager-is-pointing-to

NOTE: TIBCO does not recommend making any manual changes to the files/folders . Please raise a case at support.tibco.com if you have an administrative need to move these files (such as C:\ is getting full on SDMS Server and how to move the files to a different drive )

https://support.tibco.com/s/article/How-to-determine-SDMS-Meta-database
https://support.tibco.com/s/article/How-to-migrate-SDMS-from-one-server-to-another
https://support.tibco.com/s/article/How-to-locate-the-SDMS-Server-that-SDMS-Client-Enterprise-manager-is-pointing-to