database table names visible in ananlytics?

K L

16 décembre 2017 19:44

Hello,

 

Does analytics shows the all the database tables that are used in portal, a arcgis server and the html5 viewers?

 

the database names, schema owners and table names

 

example

 

databasename = geo001 (oracle db)

 

geo_owner.subground

 

geo_owner.parcels

 

ect.

 

For the database administator its good to know witch database and tables are used bij arcgis server and viewers

 

ect.

 

We used generic database role names for portal and arcgis server and htm5 viewer to grant the select permissies on tables

 

analytics should give us insight on what is actually being used

 

 

0

• 

  K L

  16 décembre 2017 20:01

  example:

   

  if a grant select had to been revoked om a table, analytics should show if that can be done safely because it is not configured to be used anymore

   

  if you see a grant select on a table but you dont know if that grant is still nessecary for the viewers, i would like to see in analytics if that table is still been configured in arcgis services and viewers to be used or not

   

  And if a grant select had been revoked on a table, analytics should give in its alarm the database and schema owner/table name it cant reach anymore (the service will fail and alarm also)

  0
• 

  K L

  29 décembre 2017 10:35

  the table use information can be found in manifest of the service -> http://gisserver: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>

   

   

  0
• 

  Aaron Oxley

  16 avril 2018 18:39

  Hi, k l,

   

  It is not currently possible to monitor usage of databases by ArcGIS Server, but you can monitor Data Links usage by Essentials Sites, and Data File Usage for Portals. 

   

  If you'd like to see Analytics include functionality to monitor ArcGIS Server services' usage of databases, I suggest adding it to the Ideas section (https://support.geocortex.com/GSCIdeas?c=09a6000000008RxAAI&filter=1&categ=all&sub-nav=ideas&main-nav=optimizer&page=1) so other users can vote for, or comment on, this suggestion.

   

  Thanks,

  Aaron Oxley

  0

Vous devez vous connecter pour laisser un commentaire.