topic Re: arcpy query version information in Python Questions

arcpy query version information

RyanKozoriz — Fri, 27 Jan 2012 18:00:01 GMT

Is it possible, using arcpy, to query version information from SDE? I would like to report information such as Version Name, Owner, Creation Date, Modified Date, Description, and Permissions.
Thanks,
Ryan

Re: arcpy query version information

RussellBrennan — Mon, 30 Jan 2012 16:39:02 GMT

Is it possible, using arcpy, to query version information from SDE? I would like to report information such as Version Name, Owner, Creation Date, Modified Date, Description, and Permissions.
Thanks,
Ryan

Currently this is not possible @ version 10.0 of ArcGIS. With 10.1 we will have an arcpy.da.ListVersions function that will return version objects with all of these properties.

Re: arcpy query version information

RyanKozoriz — Mon, 30 Jan 2012 17:03:59 GMT

Thanks for a quick response. Looking forward to 10.1!

Re: arcpy query version information

JeffBarrette — Tue, 31 Jan 2012 13:10:06 GMT

With arcpy.mapping you can get the following SDE properties using the serviceProperties property on the Layer object.

Keys for an ArcSDE dictionary

ServiceType �??The property displaying the type of service. This will only be SDE for ArcSDE layer types.
Server �??The name or IP address of the computer where the ArcSDE geodatabase is located.
Service �??The name or port number of the process running on the ArcSDE server.
Database �??The name of the enterprise RDBMS database. This is not required when using Oracle.
UserName �??A user account. This will be blank if using operating system authentication.
AuthenticationMode �??Geodatabase or operating system authentication.
Version �??The version of the geodatabase to which you are connecting.

There is a code sample that uses this property.

http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/Layer/00s300000008000000/

Jeff