Description
-----------------
How to Quickly Generate a Report of Folder Paths With Their Respective Master Cluster or Replica Clusters Assignments via a SQL*PLUS Query.

The SQL*PLUS scripts below are provided to assist admins in quickly reviewing their folder/cluster assigments. PTC Technical Support will not assist in any script modifications and/or formatting of the output. Please refer to any SQL reference manual should you require additional formatting.

To generate a listing of folder paths and their assigned master clusters, copy
the following script can be cut into a text file called 'master_cluster.sql'.
Once created it can be run on the dataserver from a command line as system:

  sqlplus system/manager  @master_cluster.sql

The results will be spooled to a text file called "master_cluster.txt". 

-----cut & paste below-----------------

set lines 120
set pages 100 
col "Folder Path" for a75
col "Master Cluster" for a40

spool master_cluster.txt

select folpath "Folder Path", c1.fsname "Master Cluster"
from pdm.pdm_folder f, pdm.pdm_filespace c1
where f.fsid=c1.fsid
order by 1
/
exit

----cut and paste above-----------------

Similarly another script can be used to generate a report of folders and their
assigned replica cluster(s). Cut and paste the syntax below into a file called
'replica_cluster.sql' and run it as system from the command line like:

  sqlplus system/manager  @replica_cluster.sql

-----cut & paste below-----------------

set lines 120
set pages 100 
col "Folder Path" for a75
col "Replica Cluster" for a40

spool replica_cluster.txt

select folpath "Folder Path", c1.fsname "Replica Cluster"
from pdm.pdm_folder f, pdm.pdm_fsreplica r, pdm.pdm_filespace c1
where f.folid=r.folid and c1.fsid=r.fsid 
order by 1,2
/
exit

----cut and paste above-----------------

Alternate Technique
-----------------
N/A

Resolution
-----------------
N/A