avHow to retrive the modification date of an ArcSDE elements?

[SaidAkif]

Hi all,

I work with an arcSDE database (SQL server Enterprise geodatabase) and I want to retrive using python code the modification date of each of its elements (tables, features classes, rasters, ...)

Thanks

[SaidAkif]

Hi Christian
I tried your code before and it worked well. Not I got kind of error. Here is what I did:
gdb = r'Database Connections\GKMI.sde'
owner = 'sde'  I let it as sde
table='GKMIGeodatabase.ATLR.CH_ATL_PipingPlover"  hre is the name of my table or feature class

I run the script. Unfortunatly, the dates was just boolean and = True

I don't know what I did wrong?
Could you please give me more explanation on the owner and table variable significations?

Thankd

[SaidAkif]

Hi

I tried this example:

sql =

"SELECT * FROM sys.tables"

sde_return = sde_conn.execute(sql)

after I retreive the first value of sde_return[

0] =

[u'SDE_GEOMETRY3320', 223997, None, 45, 0, u'U ', u'USER_TABLE', u'20/03/2014 10:32:12 AM', u'27/09/2015 8:55:24 AM', 0, 0, 0, 1, None, 2, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, u'TABLE', 0]

Do you know please how can i get the signification of each value (field names of sys.tables)

Thanks

[SaidAkif]

Thanks. This is really helpful