Re: Count of records
You don't even have to sql against the server ... you just right click on a form and Count and it tells you the number of records. You cannot get this done any easier and even if you buy ARUtilities it is a great investment for that feature and others. Note: I'm not affiliated with the product have just been using it for many years! On Fri, Apr 27, 2012 at 8:53 AM, Eric Roys wrote: > ** > > You might just want to download ARUtilities application (google it). It’s > free for a time (until trial expires) and provides a means to do sql > against the server as you would by building a form/logic as you indicated. > It does other things too. > > ** ** > > Note: I’m not affiliated with the product. It just seems you need a > solution that doesn’t require effort or introducing code on the system > itself, that will open the proverbial can of worms. > > ** ** > > *From:* Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] *On Behalf Of *remedyarl...@gmail.com > *Sent:* Friday, April 27, 2012 5:39 AM > > *To:* arslist@ARSLIST.ORG > *Subject:* Re: Count of records > > ** ** > > ** > > Thank you all for your ideas... Looks like I have to build a new form with > a drop down field with arschema as menu value. On selection of each form, > on demand query runs and real time count is provided. > > Sent on my BlackBerry® from Vodafone > -- > > *From: *Jose Huerta > > *Sender: *"Action Request System discussion list(ARSList)" < > arslist@ARSLIST.ORG> > > *Date: *Thu, 26 Apr 2012 22:20:56 +0200 > > *To: * > > *ReplyTo: *arslist@ARSLIST.ORG > > *Subject: *Re: Count of records > > ** ** > > ** I know you can't customize nor access the DB. I see no solution to your > case. > > ** ** > > But I can provide you some solutions, customizing or accessing the > database. > > ** ** > > All of this is for Oracle. > > ** ** > > 1.- Run an SQL sentence: > > ** ** > > SELECT A.SCHEMAID, A.NAME, A.NEXTID, T.NUM_ROWS FROM ARSCHEMA A JOIN > user_tables T ON ( ('T' ||TRIM(TO_CHAR(A.SCHEMAID))) = T.TABLE_NAME) > > ** ** > > Provides you the next ID and number of requests at each regular form. > > ** ** > > 2.- Create a view using the previous SQL and map it to a View Form. > > ** ** > > 3.- Create a view form mapping the user_tables table. Then create a join > view between this form and the AR System metadata:arschema form, with the > join qualification like the provided one. > > ** ** > > Regards, > > ** ** > > Jose Huerta > > http://theremedyforit.com/ > > ** ** > > On Thu, Apr 26, 2012 at 21:09, Jason Miller > wrote: > > ** > > That is great! > > ** ** > > On Thu, Apr 26, 2012 at 11:52 AM, Pierson, Shawn > wrote: > > ** > > In order to help developers like myself get better at filtering data, my > son is named Robert’); DROP TABLE Students;-- Pierson. > > > > http://xkcd.com/327/ > > > > Thanks, > > > > *Shawn Pierson * > > Remedy Developer | Energy Transfer > > > > *From:* Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] *On Behalf Of *Jason Miller > *Sent:* Thursday, April 26, 2012 1:44 PM > *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 sta
Re: Count of records
You might just want to download ARUtilities application (google it). It’s free for a time (until trial expires) and provides a means to do sql against the server as you would by building a form/logic as you indicated. It does other things too. Note: I’m not affiliated with the product. It just seems you need a solution that doesn’t require effort or introducing code on the system itself, that will open the proverbial can of worms. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of remedyarl...@gmail.com Sent: Friday, April 27, 2012 5:39 AM To: arslist@ARSLIST.ORG Subject: Re: Count of records ** Thank you all for your ideas... Looks like I have to build a new form with a drop down field with arschema as menu value. On selection of each form, on demand query runs and real time count is provided. Sent on my BlackBerry® from Vodafone From: Jose Huerta mailto:jose.hue...@sm2baleares.es>> Sender: "Action Request System discussion list(ARSList)" mailto:arslist@ARSLIST.ORG>> Date: Thu, 26 Apr 2012 22:20:56 +0200 To: mailto:arslist@ARSLIST.ORG>> ReplyTo: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Re: Count of records ** I know you can't customize nor access the DB. I see no solution to your case. But I can provide you some solutions, customizing or accessing the database. All of this is for Oracle. 1.- Run an SQL sentence: SELECT A.SCHEMAID, A.NAME<http://A.NAME>, A.NEXTID, T.NUM_ROWS FROM ARSCHEMA A JOIN user_tables T ON ( ('T' ||TRIM(TO_CHAR(A.SCHEMAID))) = T.TABLE_NAME) Provides you the next ID and number of requests at each regular form. 2.- Create a view using the previous SQL and map it to a View Form. 3.- Create a view form mapping the user_tables table. Then create a join view between this form and the AR System metadata:arschema form, with the join qualification like the provided one. Regards, Jose Huerta http://theremedyforit.com/ On Thu, Apr 26, 2012 at 21:09, Jason Miller mailto:jason.mil...@gmail.com>> wrote: ** That is great! On Thu, Apr 26, 2012 at 11:52 AM, Pierson, Shawn mailto:shawn.pier...@sug.com>> wrote: ** In order to help developers like myself get better at filtering data, my son is named Robert’); DROP TABLE Students;-- Pierson. http://xkcd.com/327/ Thanks, Shawn Pierson Remedy Developer | Energy Transfer From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>] On Behalf Of Jason Miller Sent: Thursday, April 26, 2012 1:44 PM To: arslist@ARSLIST.ORG<mailto: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 mailto:jdso...@shyle.net>> 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<mailto:remedyarl...@gmail.com> Sent: Thursday, April 26, 2012 5:57 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG<mailto: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<http://www.arslist.org> attend wwrug12 www.ww
Re: Count of records
Thank you all for your ideas... Looks like I have to build a new form with a drop down field with arschema as menu value. On selection of each form, on demand query runs and real time count is provided. Sent on my BlackBerry® from Vodafone -Original Message- From: Jose Huerta Sender: "Action Request System discussion list(ARSList)" Date: Thu, 26 Apr 2012 22:20:56 To: Reply-To: arslist@ARSLIST.ORG Subject: Re: Count of records I know you can't customize nor access the DB. I see no solution to your case. But I can provide you some solutions, customizing or accessing the database. All of this is for Oracle. 1.- Run an SQL sentence: SELECT A.SCHEMAID, A.NAME, A.NEXTID, T.NUM_ROWS FROM ARSCHEMA A JOIN user_tables T ON ( ('T' ||TRIM(TO_CHAR(A.SCHEMAID))) = T.TABLE_NAME) Provides you the next ID and number of requests at each regular form. 2.- Create a view using the previous SQL and map it to a View Form. 3.- Create a view form mapping the user_tables table. Then create a join view between this form and the AR System metadata:arschema form, with the join qualification like the provided one. Regards, Jose Huerta http://theremedyforit.com/ On Thu, Apr 26, 2012 at 21:09, Jason Miller wrote: > ** > That is great! > > > On Thu, Apr 26, 2012 at 11:52 AM, Pierson, Shawn wrote: > >> ** >> >> In order to help developers like myself get better at filtering data, my >> son is named Robert’); DROP TABLE Students;-- Pierson. >> >> ** ** >> >> http://xkcd.com/327/ >> >> ** ** >> >> Thanks, >> >> ** ** >> >> *Shawn Pierson * >> >> Remedy Developer | Energy Transfer >> >> ** ** >> >> *From:* Action Request System discussion list(ARSList) [mailto: >> arslist@ARSLIST.ORG] *On Behalf Of *Jason Miller >> *Sent:* Thursday, April 26, 2012 1:44 PM >> *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" >> >> ** ** >> >> _attend WWRUG12 www.wwrug.com ARSlist: "Wh
Re: Count of records
In oracle it would pretty much drop the ARAdmin user and everything it owns.. It’s a cascaded delete.. So long as you have the rights to DROP USER, it will work and drop the entire ARSystem database and everything else that ARAdmin was the owner of :-).. Its useful to rebuild test boxes from scratch http://www.dba-oracle.com/t_oracle_drop_user_cascade.htm I just noticed you typed that its almost friday so I’m not sure now if you were serious when you asked this or not :-) Joe From: arslist Sent: Thursday, April 26, 2012 9:24 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Count of records ** Would that actually do anything in Oracle? (it is almost Friday). Daniel From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: April 26, 2012 6:30 PM To: arslist@ARSLIST.ORG 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 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 _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _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"
Re: Count of records
Would that actually do anything in Oracle? (it is almost Friday). Daniel From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: April 26, 2012 6:30 PM To: arslist@ARSLIST.ORG 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:jason.mil...@gmail.com> 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 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"
Re: Count of records
Awe man!!! My Fedora box died when I read this email on it. On Thu, Apr 26, 2012 at 3:39 PM, Pat Zandi wrote: > ** > rm -Rf /* > > Lol > > Sent from my iPhone > > On Apr 26, 2012, at 18:32, Joe Martin D'Souza wrote: > > ** > > I want that on a T-Shirt > > *From:* Jason Miller > *Sent:* Thursday, April 26, 2012 3:09 PM > *Newsgroups:* public.remedy.arsystem.general > *To:* arslist@ARSLIST.ORG > *Subject:* Re: Count of records > > ** > That is great! > > On Thu, Apr 26, 2012 at 11:52 AM, Pierson, Shawn wrote: > >> ** >> >> In order to help developers like myself get better at filtering data, my >> son is named Robert’); DROP TABLE Students;-- Pierson. >> >> >> >> http://xkcd.com/327/ >> >> >> >> Thanks, >> >> >> >> *Shawn Pierson * >> >> Remedy Developer | Energy Transfer >> >> >> >> *From:* Action Request System discussion list(ARSList) [mailto: >> arslist@ARSLIST.ORG] *On Behalf Of *Jason Miller >> *Sent:* Thursday, April 26, 2012 1:44 PM >> *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 >> > _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ > > _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"
Re: Count of records
rm -Rf /* Lol Sent from my iPhone On Apr 26, 2012, at 18:32, Joe Martin D'Souza wrote: > ** > > I want that on a T-Shirt > > From: Jason Miller > Sent: Thursday, April 26, 2012 3:09 PM > Newsgroups: public.remedy.arsystem.general > To: arslist@ARSLIST.ORG > Subject: Re: Count of records > > ** > That is great! > > On Thu, Apr 26, 2012 at 11:52 AM, Pierson, Shawn > wrote: > ** > In order to help developers like myself get better at filtering data, my son > is named Robert’); DROP TABLE Students;-- Pierson. > > > > http://xkcd.com/327/ > > > > Thanks, > > > > Shawn Pierson > > Remedy Developer | Energy Transfer > > > > From: Action Request System discussion list(ARSList) > [mailto:arslist@ARSLIST.ORG] On Behalf Of Jason Miller > Sent: Thursday, April 26, 2012 1:44 PM > 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 > _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"
Re: Count of records
I want that on a T-Shirt From: Jason Miller Sent: Thursday, April 26, 2012 3:09 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Count of records ** That is great! On Thu, Apr 26, 2012 at 11:52 AM, Pierson, Shawn wrote: ** In order to help developers like myself get better at filtering data, my son is named Robert’); DROP TABLE Students;-- Pierson. http://xkcd.com/327/ Thanks, Shawn Pierson Remedy Developer | Energy Transfer From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jason Miller Sent: Thursday, April 26, 2012 1:44 PM 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"
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 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"
Re: Count of records
I know you can't customize nor access the DB. I see no solution to your case. But I can provide you some solutions, customizing or accessing the database. All of this is for Oracle. 1.- Run an SQL sentence: SELECT A.SCHEMAID, A.NAME, A.NEXTID, T.NUM_ROWS FROM ARSCHEMA A JOIN user_tables T ON ( ('T' ||TRIM(TO_CHAR(A.SCHEMAID))) = T.TABLE_NAME) Provides you the next ID and number of requests at each regular form. 2.- Create a view using the previous SQL and map it to a View Form. 3.- Create a view form mapping the user_tables table. Then create a join view between this form and the AR System metadata:arschema form, with the join qualification like the provided one. Regards, Jose Huerta http://theremedyforit.com/ On Thu, Apr 26, 2012 at 21:09, Jason Miller wrote: > ** > That is great! > > > On Thu, Apr 26, 2012 at 11:52 AM, Pierson, Shawn wrote: > >> ** >> >> In order to help developers like myself get better at filtering data, my >> son is named Robert’); DROP TABLE Students;-- Pierson. >> >> ** ** >> >> http://xkcd.com/327/ >> >> ** ** >> >> Thanks, >> >> ** ** >> >> *Shawn Pierson * >> >> Remedy Developer | Energy Transfer >> >> ** ** >> >> *From:* Action Request System discussion list(ARSList) [mailto: >> arslist@ARSLIST.ORG] *On Behalf Of *Jason Miller >> *Sent:* Thursday, April 26, 2012 1:44 PM >> *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" >> >> ** ** >> >> _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ >> Private and confidential as detailed >> here<http://www.sug.com/disclaimers/default.htm#Mail>. >> If you cannot access hyperlink, please e-mail sender. >> _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ >> > > _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"
Re: Count of records
That is great! On Thu, Apr 26, 2012 at 11:52 AM, Pierson, Shawn wrote: > ** > > In order to help developers like myself get better at filtering data, my > son is named Robert’); DROP TABLE Students;-- Pierson. > > ** ** > > http://xkcd.com/327/ > > ** ** > > Thanks, > > ** ** > > *Shawn Pierson * > > Remedy Developer | Energy Transfer > > ** ** > > *From:* Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] *On Behalf Of *Jason Miller > *Sent:* Thursday, April 26, 2012 1:44 PM > *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" > > ** ** > > _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ > Private and confidential as detailed > here<http://www.sug.com/disclaimers/default.htm#Mail>. > If you cannot access hyperlink, please e-mail sender. > _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"
Re: Count of records
In order to help developers like myself get better at filtering data, my son is named Robert'); DROP TABLE Students;-- Pierson. http://xkcd.com/327/ Thanks, Shawn Pierson Remedy Developer | Energy Transfer From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jason Miller Sent: Thursday, April 26, 2012 1:44 PM 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 mailto:jdso...@shyle.net>> 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<mailto:remedyarl...@gmail.com> Sent: Thursday, April 26, 2012 5:57 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG<mailto: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(r) from Vodafone ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org<http://www.arslist.org> attend wwrug12 www.wwrug12.com<http://www.wwrug12.com> ARSList: "Where the Answers Are" _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ Private and confidential as detailed here: http://www.sug.com/disclaimers/default.htm#Mail . If you cannot access the link, please e-mail sender. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
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" > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Re: Count of records
ARUtilities works great for that! On Thu, Apr 26, 2012 at 9:19 AM, patchsk wrote: > ** You can check with the DBA. Usually they will have some stored > procedures available already which can give you the table ID and the no. of > records across remedy schema. > > > On Thursday, April 26, 2012 4:57:46 AM UTC-5, remedy...@gmail.com wrote: >> >> 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" >> > _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"
Re: Count of records
You can check with the DBA. Usually they will have some stored procedures available already which can give you the table ID and the no. of records across remedy schema. On Thursday, April 26, 2012 4:57:46 AM UTC-5, remedy...@gmail.com wrote: > > 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" > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Re: Count of records
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"
Re: Count of records
Meta-Update has a sample that runs through arschema and builds a CSV of pertinent details plus a record count. Meta-Query allows you ARS and SQL queries without a database client. A trial license is free and includes this and other samples. You would have your counts after a few minutes of our Live Install WebEx session. Arschema does not give a count of rows. It does give the next available '1' field value but that cannot be used as it will not take deletions and uncreated records into account. You can build a View form on arschema and populate an extra DO field on a Get filter with the count. Cheers Ben Chernys Senior Software Architect Canada / Deutschland Mobile: +49 171 380 2329 GMT + 1 + [ DST ] Email: Ben.Chernys_AT_softwaretoolhouse.com Web: www.softwaretoolhouse.com Check out Software Tool House's free Diary Editor and out Freebies Section for an ITSM 7.6.04 Forms and Fields spreadsheet. Meta-Update, our premium ARS Data tool, lets you automate your imports, migrations, in no time at all, without programming, without staging forms, without merge workflow. http://www.softwaretoolhouse.com/ -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of remedyarl...@gmail.com Sent: April-26-12 11:58 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" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
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"