Create GP tools for the rest of the ArcSDE administration tasks

JackHorton

The new GP tools for ArcSDE administration are great!
Now let's finish the job, and create GP tools for the rest of the ArcSDE administration tasks.  Currently there are some tasks for which the SDE command line is still required, and some tasks for which there is a GUI but no GP tool.
Here are some examples:

• Return connected users as a python list
• Return locks as a python list
• Return the host and process for locks and users
• Return privileges as a Python list
• Return users as a python list
• Return roles as a Python list
• Return DBtune keywords and parameters as a python list
• Rerurn server configuration parameters as a python list

Make corresponding ModelBuilder iterators for all the proposed lists
Provide GP tools to alter all the values in these python lists

Provide gp tools for all application server setup and administration tasks
Review all the ArcSDE command line commands and ensure that there are GP tools for all relevant commands

MelissaJarman

This is continually being worked on by members of development and support services. I did find one of the things on your list in arcpy for 10.2. We urge users to bring things to support with business cases and information about commands that are not available or not scriptable outside of the commandline.

Return connected users as a python list - ListUsers (arcpy) http://resources.arcgis.com/en/help/main/10.2/index.html#//018v00000030000000
There is also a DisconnectUser (arcpy), but I am not currently aware of a way to script a list of the locks, etc. This type of information is being handled or listed under the following NIM:
NIM095119 - SDEMON:Create geoprocessing tools or arcpy functions for operations performed when using the 'sdemon' command.

 

Do This, Not That! – Alternatives to using SDE command line tools

- See more at: http://blogs.esri.com/esri/supportcenter/2013/10/04/do-this-not-that-alternatives-to-using-sde-command-line-tools/#sthash.LbGIERch.dpuf

Do this not that - alternatives to using the SDE commandline BLOG

Do This, Not That! – Alternatives to using SDE command line tools

- See more at: http://blogs.esri.com/esri/supportcenter/2013/10/04/do-this-not-that-alternatives-to-using-sde-command-line-tools/#sthash.LbGIERch.dpuf

Do This, Not That! – Alternatives to using SDE command line tools

- See more at: http://blogs.esri.com/esri/supportcenter/2013/10/04/do-this-not-that-alternatives-to-using-sde-command-line-tools/#sthash.LbGIERch.dpuf

http://blogs.esri.com/esri/supportcenter/2013/10/04/do-this-not-that-alternatives-to-using-sde-command-line-tools/