In Analytics, show ArcGIS server services, the usage of databases tablenames
in analytics (reports?) show all the databases, schema names and tables that are used in portal, a arcgis server and the html5 viewers
the database names, schema owners and table names
example
databasename = geo001
tables:
geo_owner.subground
geo_owner.parcels
ect.
For the database administator its good to know which databases and tables are used by arcgis server and viewers
We used generic database role names for portal and arcgis server and htm5 viewer to grant the select permissies on tables
example:
If you see a select grant on a table but you dont know if that select grant is still nessecary for a arcgis server service, i would like to see in analytics if that table is still in use by a arcgis server service (and viewers)
And if a grant select had been revoked on a table that is in use, analytics should give in its alarm the database and schema owner/table name it cant reach anymore (the arcgis service will fail and give a alert)
the table use information can be found in manifest of the service -> http://arcgisserver:6080/arcgis/admin/services/folder/MapServer/iteminfo/manifest/manifest.xml
the <OnPremiseConnectionString> -> DB_CONNECTION_PROPERTIES= dbname -> USER=xyz
and for the tables:
<OnPremisePath> -> <OnServerName>DB-TABLE</OnServerName>
the database names, schema owners and table names
example
databasename = geo001
tables:
geo_owner.subground
geo_owner.parcels
ect.
For the database administator its good to know which databases and tables are used by arcgis server and viewers
We used generic database role names for portal and arcgis server and htm5 viewer to grant the select permissies on tables
example:
If you see a select grant on a table but you dont know if that select grant is still nessecary for a arcgis server service, i would like to see in analytics if that table is still in use by a arcgis server service (and viewers)
And if a grant select had been revoked on a table that is in use, analytics should give in its alarm the database and schema owner/table name it cant reach anymore (the arcgis service will fail and give a alert)
the table use information can be found in manifest of the service -> http://arcgisserver:6080/arcgis/admin/services/folder/MapServer/iteminfo/manifest/manifest.xml
the <OnPremiseConnectionString> -> DB_CONNECTION_PROPERTIES= dbname -> USER=xyz
and for the tables:
<OnPremisePath> -> <OnServerName>DB-TABLE</OnServerName>
2
Please sign in to leave a comment.
Comments
0 comments