Would that actually do anything in Oracle? (it is almost Friday).
Daniel From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Joe Martin D'Souza Sent: April 26, 2012 6:30 PM To: [email protected] Subject: OT: Count of records ** I like this command even better.. DROP USER aradmin CASCADE; This command should be only used by trained professionals.. Do not try this at home :-) Seriously!! Do not try this! Joe From: Jason Miller <mailto:[email protected]> Sent: Thursday, April 26, 2012 2:43 PM Newsgroups: public.remedy.arsystem.general To: [email protected] Subject: OT: Count of records ** A good reason to not run your application as root/admin... I had a system once were I didn't have admin access on the app server but the AR System ran as root. I built a form where I could enter an OS command in a text field and Remedy would issue the command to the OS in a Run Process. Worked great for things like sending a chown command on log files that I couldn't view because they were created by root. The same could hold true if your ARSystem db user is a sysadmin. Be careful that the SELECT COUNT(*) doesn't turn into DROP DATABASE ARSystem. :-) Jason On Thu, Apr 26, 2012 at 7:07 AM, Joe Martin D'Souza <[email protected]> wrote: You do not require the ARAdmin password to run a direct SQL on your application.. Customize your app wherein, you run a direct SQL in a set field operation to set a field with $1$ of the SQL statement ==> select count(*) from <view name> Do not use the terminating ; character on your direct SQL as the AR System engine takes care of that.. Use that statement in a set field action and set a temp field to return your count to.. This will not limit your count by what your get list limits on your server or your clients are.. Joe -----Original Message----- From: [email protected] Sent: Thursday, April 26, 2012 5:57 AM Newsgroups: public.remedy.arsystem.general To: [email protected] Subject: Count of records Quick question.. Do we have a form in remedy 7.6.X where we can check the count of rows in each table. I know we have a form to check schema ID's but will this also give count of rows. My Getlist query on server is restricted to 2K records only so I have to run 1=1 query on each target form in web mode to get the count. Unfortunately user too do not give the count. Also I don't have read access to DB and client is not ready to share ARAdmin pwd (for security). And as usual no customization allowed. Any help would be appreciated. Sent on my BlackBerryR from Vodafone _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
