Community
Select to view content in your preferred language

Create GP tools for the rest of the ArcSDE administration tasks

733
1
09-07-2012 10:44 AM
Status: Open
Labels (1)
JackHorton
by Esri Contributor
Esri Contributor

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

1 Comment
MelissaJarman
by Esri Contributor
‎11-20-2013 05:17 AM
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-comma...
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-comma...

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-comma...
http://blogs.esri.com/esri/supportcenter/2013/10/04/do-this-not-that-alternatives-to-using-sde-comma...