sdelayer -o describe_long : Gives information on a layer such as the current spatial index, the layerID, system units etc that cannot be found through ArcCatalog. Create a tool that returns all the information about a layer, so you don't have to go looking in the SDE user system tables.
ArcSDE 10.2
Layer Administration Utility
-----------------------------------------------------
Layer Description ....: <None>
Table Owner ..........: CUSTODIANS_AGENCY
Table Name ...........: OVG_VISTAS_REVAL
Spatial Column .......: SHAPE
Layer Id .............: 2237
SRID .................: 2
Auth SRID.............: 3857
Minimum Shape Id .....: 1
Offset ...............:
falsex: -20037700.000000
falsey: -30241100.000000
System Units .........: 10000.000000
Z Offset..............: 0.000000
Z Units ..............: 1.000000
Measure Offset .......: <None>
Measure Units ........: <None>
XY Cluster Tolerance .: 0.001
Spatial Index ........:
parameter: SPIDX_GRID,GRID0=4000,FULL
exist: Yes
array form: 4000,0,0
Layer Envelope .......:
minx: 16011558.40080, miny: -5349578.14150
maxx: 16528928.07960, maxy: -4751324.92700
Entities .............: nac+
Layer Type ...........: Extended SQL Type/ST_GEOMETRY
Creation Date ........: 08/11/16 10:45:08
I/O Mode .............: NORMAL
Autolocking ..........: Enabled
Precision.............: High
User Privileges ......: SELECT, UPDATE, INSERT, DELETE
Coordinate System ....: PROJCS["WGS_1984_Web_Mercator_Auxil
174532925199433]],PROJECTION["Mercator_Auxiliary_Sphere"],P
R["Auxiliary_Sphere_Type",0.0],UNIT["Meter",1.0]]
Layer Configuration ..: DEFAULTS
