find out the list of versioned feature classes or Dataset.

Question

Hi All,

I have a ArcSDE Geodatabase and have n number of dataset and layers, Its really huge.

I want to find out the list of versioned feature classes or Dataset.

Is there any way to query the SDE syetem tables and find?

Your help is really appreciated

Many Thanks

Cheers
Antony

FrédéricPRALLY · Answer

Hi antony,
Maybe you can used this add-in List versioned data,

Hope this help you,

Fred

VinceAngelo · Answer

The indent scheme is hyper-important in Python.  Please edit your solution so
it will work.  It would also be a good idea to post in a CODE block, so the text
is more legible (fixed-width font) -- use the "#" in the editor widgits.

- V

VanyaIvanov_0-1629106750132.png

AntonyPaul_M1 · Answer

Hi

I got python script to find out all the verioned feature classes inside the Geodatabase. It works for me so I thought of sharing it with you guys,import sys, string, os, arcgisscripting, logging

log_File = "c:\Documents and Settings\apaul\desktop\sde_dataset_versioning.log"

# Set up log file
logger = logging.getLogger('myapp')
hdlr = logging.FileHandler(log_File)
formatter = logging.Formatter('%(message)s')
hdlr.setFormatter(formatter)
logger.addHandler(hdlr)
logger.setLevel(logging.INFO)

gp = arcgisscripting.create(9.3)
gp.workspace = "C:\Documents and Settings\apaul\\desktop\sde_con.sde"

fds = gp.ListDatasets()

for fd in fds:
    gp.workspace = "C:\Documents and Settings\apaul\\desktop\sde_con.sde\%s" % fd
    fcs = gp.ListFeatureClasses()
    
    try:
        fc1 = fcs[0]
        desc = gp.Describe(fc1).IsVersioned
        print fd,desc
        logger.info('%s %s'%(fd,desc))
        
    except:
        pass

jakes_tbx.png