idea Create GP tools for the rest of the ArcSDE administration tasks in Data Management Ideas https://community.esri.com/t5/data-management-ideas/create-gp-tools-for-the-rest-of-the-arcsde/idi-p/932092 <P>The new GP tools for ArcSDE administration are great!<BR />Now let's finish the job, and create GP tools for the rest of the ArcSDE administration tasks.&nbsp; 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.<BR />Here are some examples:</P><UL><LI>Return connected users as a python list</LI><LI>Return locks as a python list</LI><LI>Return the host and process for locks and users</LI><LI>Return privileges as a Python list</LI><LI>Return users as a python list</LI><LI>Return roles as a Python list</LI><LI>Return DBtune keywords and parameters as a python list</LI><LI>Rerurn server configuration parameters as a python list</LI></UL><P>Make corresponding ModelBuilder iterators for all the proposed lists<BR />Provide GP tools to alter all the values in these python lists<BR /><BR />Provide gp tools for all application server setup and administration tasks<BR />Review all the ArcSDE command line commands and ensure that there&nbsp;are GP tools for all relevant commands</P><!-- content transformation source ID: 087E00000004KM6 --> Wed, 24 Aug 2022 22:12:19 GMT JackHorton 2022-08-24T22:12:19Z Create GP tools for the rest of the ArcSDE administration tasks https://community.esri.com/t5/data-management-ideas/create-gp-tools-for-the-rest-of-the-arcsde/idi-p/932092 <P>The new GP tools for ArcSDE administration are great!<BR />Now let's finish the job, and create GP tools for the rest of the ArcSDE administration tasks.&nbsp; 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.<BR />Here are some examples:</P><UL><LI>Return connected users as a python list</LI><LI>Return locks as a python list</LI><LI>Return the host and process for locks and users</LI><LI>Return privileges as a Python list</LI><LI>Return users as a python list</LI><LI>Return roles as a Python list</LI><LI>Return DBtune keywords and parameters as a python list</LI><LI>Rerurn server configuration parameters as a python list</LI></UL><P>Make corresponding ModelBuilder iterators for all the proposed lists<BR />Provide GP tools to alter all the values in these python lists<BR /><BR />Provide gp tools for all application server setup and administration tasks<BR />Review all the ArcSDE command line commands and ensure that there&nbsp;are GP tools for all relevant commands</P><!-- content transformation source ID: 087E00000004KM6 --> Wed, 24 Aug 2022 22:12:19 GMT https://community.esri.com/t5/data-management-ideas/create-gp-tools-for-the-rest-of-the-arcsde/idi-p/932092 JackHorton 2022-08-24T22:12:19Z Re: Create GP tools for the rest of the ArcSDE administration tasks https://community.esri.com/t5/data-management-ideas/create-gp-tools-for-the-rest-of-the-arcsde/idc-p/932093#M784 <HTML><HEAD></HEAD><BODY>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.<BR /><BR />Return connected users as a python list - ListUsers (arcpy) <A href="http://resources.arcgis.com/en/help/main/10.2/index.html#//018v00000030000000" target="_blank">http://resources.arcgis.com/en/help/main/10.2/index.html#//018v00000030000000</A><BR />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:<BR /><SPAN style="color: black;"><SPAN style="font-size: 12.0pt;">NIM095119 - SDEMON:Create geoprocessing tools or arcpy functions for operations performed when using the 'sdemon' command.</SPAN></SPAN><BR /><BR />&nbsp; <DIV><DIV><DIV><DIV class="post-4782 post type-post status-publish format-standard hentry category-arcgis-for-desktop category-arcsde category-geodata-2 tag-arccatalog tag-arcsde-command-line tag-create-enterprise-geodatabase tag-enable-enterprise-geodatabase tag-geodatabase tag-geoprocessing tag-sde"><H1 class="entry-title">Do This, Not That! – Alternatives to using SDE command line tools</H1></DIV></DIV></DIV> - See more at: <A href="http://blogs.esri.com/esri/supportcenter/2013/10/04/do-this-not-that-alternatives-to-using-sde-command-line-tools/#sthash.LbGIERch.dpuf" target="_blank">http://blogs.esri.com/esri/supportcenter/2013/10/04/do-this-not-that-alternatives-to-using-sde-command-line-tools/#sthash.LbGIERch.dpuf</A></DIV> Do this not that - alternatives to using the SDE commandline BLOG <DIV><DIV><DIV><DIV class="post-4782 post type-post status-publish format-standard hentry category-arcgis-for-desktop category-arcsde category-geodata-2 tag-arccatalog tag-arcsde-command-line tag-create-enterprise-geodatabase tag-enable-enterprise-geodatabase tag-geodatabase tag-geoprocessing tag-sde"><H1 class="entry-title">Do This, Not That! – Alternatives to using SDE command line tools</H1></DIV></DIV></DIV> - See more at: <A href="http://blogs.esri.com/esri/supportcenter/2013/10/04/do-this-not-that-alternatives-to-using-sde-command-line-tools/#sthash.LbGIERch.dpuf" target="_blank">http://blogs.esri.com/esri/supportcenter/2013/10/04/do-this-not-that-alternatives-to-using-sde-command-line-tools/#sthash.LbGIERch.dpuf</A></DIV> <DIV><DIV><DIV><DIV class="post-4782 post type-post status-publish format-standard hentry category-arcgis-for-desktop category-arcsde category-geodata-2 tag-arccatalog tag-arcsde-command-line tag-create-enterprise-geodatabase tag-enable-enterprise-geodatabase tag-geodatabase tag-geoprocessing tag-sde"><H1 class="entry-title">Do This, Not That! – Alternatives to using SDE command line tools</H1></DIV></DIV></DIV> - See more at: <A href="http://blogs.esri.com/esri/supportcenter/2013/10/04/do-this-not-that-alternatives-to-using-sde-command-line-tools/#sthash.LbGIERch.dpuf" target="_blank">http://blogs.esri.com/esri/supportcenter/2013/10/04/do-this-not-that-alternatives-to-using-sde-command-line-tools/#sthash.LbGIERch.dpuf</A></DIV> <A href="http://blogs.esri.com/esri/supportcenter/2013/10/04/do-this-not-that-alternatives-to-using-sde-command-line-tools/" target="_blank">http://blogs.esri.com/esri/supportcenter/2013/10/04/do-this-not-that-alternatives-to-using-sde-command-line-tools/</A> <!-- content transformation source ID: 00aE0000004M0sE --> </BODY></HTML> Wed, 20 Nov 2013 13:17:46 GMT https://community.esri.com/t5/data-management-ideas/create-gp-tools-for-the-rest-of-the-arcsde/idc-p/932093#M784 MelissaJarman 2013-11-20T13:17:46Z Re: Create GP tools for the rest of the ArcSDE administration tasks - Status changed to: Implemented https://community.esri.com/t5/data-management-ideas/create-gp-tools-for-the-rest-of-the-arcsde/idc-p/1602128#M2493 <P>Tools to replace commonly used ArcSDE commands have been created and have been available for several releases.</P> Thu, 03 Apr 2025 00:03:27 GMT https://community.esri.com/t5/data-management-ideas/create-gp-tools-for-the-rest-of-the-arcsde/idc-p/1602128#M2493 ShannonShields 2025-04-03T00:03:27Z