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
Sent: Thursday, April 26, 2012 2:43 PM
Newsgroups: public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
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 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
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: remedyarl...@gmail.com
Sent: Thursday, April 26, 2012 5:57 AM Newsgroups:
public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
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 BlackBerry® from Vodafone
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"