I got some more information from them. They are using the ARDBC and a restricted read account to access the SQL server. No webservice for the iDashboards COTS tool. The webservices a used to report specific data from the form. I tried Axton's suggestion and had them run Select Login name from User where Login Name = "Testuser" and could not connect.
I'll have to keep an eye on this to see if they add excessive load to the system or if we start seeing table locks. I will then resort to aggregating their queries into a form and letting them pull data from there so they are not constantly pinging the ticket form. Thanks, BTW, has anyone ever used iDashboards with ARS? It looks interesting. --- 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 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Axton Sent: Thursday, June 30, 2011 3:23 PM To: arslist@ARSLIST.ORG Subject: EXTERNAL: Re: Select statement to check for connectivity from external source ** I'm a bit confused; remedy permissions don't apply to db queries. With that said, the User form should have a record for the current user and the dynamic group access to the User record should allow the user to read their own record. Axton On Thu, Jun 30, 2011 at 1:02 PM, Grooms, Frederick W <frederick.w.gro...@xo.com<mailto:frederick.w.gro...@xo.com>> wrote: Are they using the API or going directly to the database? If they access the DB directly then there is no permissions issue (as it bypasses Remedy's permissions). Oh ... I see you state web Service. You could give them a specific web service that doesn't use any parameters to bring back a single record for a system available check. Personally I think aggregating their data would at least allow you to control the query and load Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>] On Behalf Of Reiser, John J Sent: Thursday, June 30, 2011 12:48 PM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Select statement to check for connectivity from external source 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<http://www.arslist.org> attend wwrug11 www.wwrug.com<http://www.wwrug.com> ARSList: "Where the Answers Are" _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
