Latest Contributions by JeffTimm

When portal came out I was very excited because for years had to deal with the Arcgis Server security where you could assign permissions to folders or services. Unfortunately this only applied to users.  If you were a publisher or admin all security went out the window. Here is my suggestion: Now that we have Federated Arcgis Servers that use Portal security I think the servers security model should actually mimic portal security instead of the following: “If a custom role is created with any administrative privileges, ArcGIS Server will grant members within that role full administrative access. This includes rights to publish any service type directly to ArcGIS Server and the ability to view and access all services. Consider the security risks before creating a custom role for any member that includes administrative privileges.” This limits the assignment of any Admin rights, even minor ones, in our environment where there is sensitive data.  Those added checkboxes in custom roles just sit there and taunt me. ... View more

I am looking for fellow GIS system architects who may be dabbling or even deploying a large highly available portal solution.  I currently am in testing with a Chef deployed 7 server environment.  I would share my challenges and solutions if you would. ESRI recommended that I ask in this forum for other large early adopters.  We currently have 2500 level 1 users and 50 level 2. ... View more

If I want to run a SQL query to create a view from another database on another server I create a linked server.  I then can query non spatial data and join into my geodatabase. The problem lies in that a standard query cannot bring CLR data type across the linked server connection.  In order to do that you need to use something along the lines of this.   Create view [cio].[vw_Dataset] as SELECT * FROM OPENQUERY([gpcsqlc1], 'SELECT  [OBJECTID] ,[District] ,[Name] ,[Headquarters] ,[Address] ,[City] ,[Zip] ,[Phone] ,[DateCreated] ,[Creator] ,[DateModified] ,[Editor] ,[GlobalID] ,[Shape] FROM [GIS_EDITS].[sde].[ADMINISTRATIVEDISTRICTS_evw]' )   Openquery apparently isn't supported in geodatabases.  This query works fine in SQL Management Studio but breaks when it is registered with the geodatabase. #query result ... View more