Hello Listers, MS 2003 Enterprise SP1 on VMware ARS 7.6.03 MS SQL Server 2005 on remote SAN
I have a department that is running select statements against the ARSystem to run iDashboards. They need a validation statement to confirm that the database is available. Currently they run SELECT COUNT(*) FROM ARS_FORM WHERE 1=1 because I have Unqualified searches disabled. I tried to point them to the group form with select group_name from Group where Group_ID = 0 so they can verify that "Public" is returned. The problem is that the Group form is only available to ARS Administrators. I know I can make a "Hello world!' form and store one record and give it public permissions but I know the group form will always be there. Group is a core form, Public is a core group. They also do a lot of Select statements with no WHERE clause against the form to pull ticket information that they process and display on a web site external to the ARSystem network through a web service. I am trying to keep the load on the ARSystem manageable. Does anyone have any suggestions? Should I add Public access to the group form but keep it hidden? Will an upgrade reset the permissions? Can I control the search qualification by altering the web service? Should I aggregate their data for them and serve it up from a separate form? This "Portal" will be getting hit by multiple people all day long. I don't want the excess traffic slowing down the whole system. Thanks you, --- John J. Reiser Remedy Developer/Administrator Senior Software Development Analyst Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
