Re: SRM association

[remedyarlist]

Yes but that is a very long procedure to find all relations. Looks like I need 
to build a custom join form. 

Sent on my BlackBerry® from Vodafone

-Original Message-
From: ravi rai 
Sender:   "Action Request System discussion list(ARSList)" 

Date: Sat, 28 Apr 2012 21:17:53 
To: 
Reply-To: arslist@ARSLIST.ORG
Subject: Re: SRM association


You can check SRID field in all asocciated module 
CHG_Infrastructure_Change
HPD_Help_Desk  etc...

 



Date: Fri, 27 Apr 2012 23:31:15 +
From: remedyarl...@gmail.com
Subject: Re: SRM association
To: arslist@ARSLIST.ORG

** Thanks rebecca for the reply, but what if a single SR have multiple IM and 
CRQ associated with it. What data will AppRequestID hold then.



Sent on my BlackBerry® from Vodafone


From: "Boyd, Rebecca"  
Sender: "Action Request System discussion list(ARSList)"  
Date: Fri, 27 Apr 2012 17:03:12 -0400
To: 
ReplyTo: arslist@ARSLIST.ORG 
Subject: Re: SRM association

** 
Try SRM:Request. You may want to add the AppRequestID (CRQ or INC #) to fields 
in view.


On Fri, Apr 27, 2012 at 6:54 AM,  wrote:

SRM: 7.6.04

Do we have a form where we can find all IM & CM tickets associated with SRM. I 
have a issue where even after IM ticket is resolved SRM tickets are still in 
planning status. I need to find all SRM tickets for which associated tickets 
are resolved.

I am not sure if this is a bug in the system but that would be my second task.

Thanks in adv.
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"


-- 
Rebecca BoydApplication AdministratorWake Forest University

_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"


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

Re: SRM association

[remedyarlist]

Thanks rebecca for the reply, but what if a single SR have multiple IM and CRQ 
associated with it. What data will AppRequestID hold then.
 

 
Sent on my BlackBerry® from Vodafone

-Original Message-
From: "Boyd, Rebecca" 
Sender:   "Action Request System discussion list(ARSList)" 

Date: Fri, 27 Apr 2012 17:03:12 
To: 
Reply-To: arslist@ARSLIST.ORG
Subject: Re: SRM association

Try SRM:Request. You may want to add the AppRequestID (CRQ or INC #) to
fields in view.

On Fri, Apr 27, 2012 at 6:54 AM,  wrote:

> SRM: 7.6.04
>
> Do we have a form where we can find all IM & CM tickets associated with
> SRM. I have a issue where even after IM ticket is resolved SRM tickets are
> still in planning status. I need to find all SRM tickets for which
> associated tickets are resolved.
>
> I am not sure if this is a bug in the system but that would be my second
> task.
>
> Thanks in adv.
> 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"
>



-- 
Rebecca Boyd
Application Administrator
Wake Forest University

___
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"

SRM association

[remedyarlist]

SRM: 7.6.04

Do we have a form where we can find all IM & CM tickets associated with SRM. I 
have a issue where even after IM ticket is resolved SRM tickets are still in 
planning status. I need to find all SRM tickets for which associated tickets 
are resolved. 

I am not sure if this is a bug in the system but that would be my second task. 

Thanks in adv.
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

[remedyarlist]

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: "Where the Answers Are"_ 
>>  Private and confidential as detailed 
>> here.
>> 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"


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug1

Count of records

[remedyarlist]

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: Run process to open FORM on second server

[remedyarlist]

Agreed. Thx.

Sent on my BlackBerry® from Vodafone

-Original Message-
From: LJ LongWing 
Sender:   "Action Request System discussion list(ARSList)" 

Date: Tue, 17 Jan 2012 15:58:45 
To: 
Reply-To: arslist@ARSLIST.ORG
Subject: Re: Run process to open FORM on second server

Does it really need to be masked?  You could even set the user to not have a
password..the user in question is a read restricted user.generic by
nature.and it doesn't really matter if someone gets the password, because
they can't do anything with it J

 

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of remedyarl...@gmail.com
Sent: Tuesday, January 17, 2012 3:40 PM
To: arslist@ARSLIST.ORG
Subject: Re: Run process to open FORM on second server

 

** ** 

Thank you so much, it worked for me. Only issue is pwd is visible in the
url. Need to mask it. 

Thanks again.


Regards,
Kumar

Sent on my BlackBerryR from Vodafone

  _  

From: LJ LongWing  

Sender: "Action Request System discussion list(ARSList)"
 

Date: Tue, 17 Jan 2012 14:53:29 -0700

To: 

ReplyTo: arslist@ARSLIST.ORG 

Subject: Re: Run process to open FORM on second server

 

Taken directly from the DevStudio Help on the subject

 

http://midTierServer/arsys/servlet/ViewFormServlet?form=formName

&server=serverName&username=userName&pwd=password

 

then.if you want to open it for a specific record, I believe you would use
&eid=12345 for the request ID (field 1) of the record you want it to open

 

 

 

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of remedyarl...@gmail.com
Sent: Tuesday, January 17, 2012 2:31 PM
To: arslist@ARSLIST.ORG
Subject: Re: Run process to open FORM on second server

 

** ** 

Hi LJ,

Following your solution, I need to call web link for I'm form with
authentication in active link. Could you please share the syntax.

Regards,

Sent on my BlackBerryR from Vodafone

  _  

From: LJ LongWing  

Sender: "Action Request System discussion list(ARSList)"
 

Date: Tue, 17 Jan 2012 13:42:46 -0700

To: 

ReplyTo: arslist@ARSLIST.ORG 

Subject: Re: Run process to open FORM on second server

 

Kumar,

Being you are using ITSM via Mid-Tier (right?).you could use a static URL to
the Reporting server that provides a hard coded user/password.  This user
would need a read restricted license to be able to do this.but it should
work.

 

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of remedy arlist
Sent: Tuesday, January 17, 2012 1:24 PM
To: arslist@ARSLIST.ORG
Subject: Run process to open FORM on second server

 

** 

Hi ARSlist users,


BackGround: Have a Prod app and Rpt server. SQL level replication is enabled
to replicate data b/w the 2 in real time. ARADMIN access is disabled on RPT
to avoid users updating records. 

Issue: Users are performing free text searches on Notes field, Resolution
and summary field of Incident Form leading to timeout errors. 

Proposed solution: Plan is to provide a button on Prod Incident form. By
pressing this button, Active Link will fire and open incident FORM on
Reporting, where users can perform adv searches. This will work only if user
have same access in both Prod and RPT.

Road Block: Since data is getting replcated from Prod to Rpt, so users
permissions also get replicated from Prod to RPT. Now each access is
connected to server license so the permission replicated to Reporting is
connected to Prod server and reporting server license. As a result even
though user have admin access in Prod, it will work as Read only account on
Reporting. (ARADMIN is locked on RPT and needs a CRQ to remove this lock for
even account that needs to be udpated on Rpt). If there is a RUN Process
command that can be used in AL so we can pass a authentication, then i can
hard code a generic account (which has all needed ITSM access) and that
should do the trick.

Any help is appreciated. Alternate solutions are also welcome. 

Regards,
Kumar

_attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ 

_attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend
WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ 

_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"


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

Re: Run process to open FORM on second server

[remedyarlist]

Thank you so much, it worked for me. Only issue is pwd is visible in the url. 
Need to mask it. 

Thanks again.


Regards,
Kumar
Sent on my BlackBerry® from Vodafone

-Original Message-
From: LJ LongWing 
Sender:   "Action Request System discussion list(ARSList)" 

Date: Tue, 17 Jan 2012 14:53:29 
To: 
Reply-To: arslist@ARSLIST.ORG
Subject: Re: Run process to open FORM on second server

Taken directly from the DevStudio Help on the subject

 

http://midTierServer/arsys/servlet/ViewFormServlet?form=formName

&server=serverName&username=userName&pwd=password

 

then.if you want to open it for a specific record, I believe you would use
&eid=12345 for the request ID (field 1) of the record you want it to open

 

 

 

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of remedyarl...@gmail.com
Sent: Tuesday, January 17, 2012 2:31 PM
To: arslist@ARSLIST.ORG
Subject: Re: Run process to open FORM on second server

 

** ** 

Hi LJ,

Following your solution, I need to call web link for I'm form with
authentication in active link. Could you please share the syntax.

Regards,

Sent on my BlackBerryR from Vodafone

  _  

From: LJ LongWing  

Sender: "Action Request System discussion list(ARSList)"
 

Date: Tue, 17 Jan 2012 13:42:46 -0700

To: 

ReplyTo: arslist@ARSLIST.ORG 

Subject: Re: Run process to open FORM on second server

 

Kumar,

Being you are using ITSM via Mid-Tier (right?).you could use a static URL to
the Reporting server that provides a hard coded user/password.  This user
would need a read restricted license to be able to do this.but it should
work.

 

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of remedy arlist
Sent: Tuesday, January 17, 2012 1:24 PM
To: arslist@ARSLIST.ORG
Subject: Run process to open FORM on second server

 

** 

Hi ARSlist users,


BackGround: Have a Prod app and Rpt server. SQL level replication is enabled
to replicate data b/w the 2 in real time. ARADMIN access is disabled on RPT
to avoid users updating records. 

Issue: Users are performing free text searches on Notes field, Resolution
and summary field of Incident Form leading to timeout errors. 

Proposed solution: Plan is to provide a button on Prod Incident form. By
pressing this button, Active Link will fire and open incident FORM on
Reporting, where users can perform adv searches. This will work only if user
have same access in both Prod and RPT.

Road Block: Since data is getting replcated from Prod to Rpt, so users
permissions also get replicated from Prod to RPT. Now each access is
connected to server license so the permission replicated to Reporting is
connected to Prod server and reporting server license. As a result even
though user have admin access in Prod, it will work as Read only account on
Reporting. (ARADMIN is locked on RPT and needs a CRQ to remove this lock for
even account that needs to be udpated on Rpt). If there is a RUN Process
command that can be used in AL so we can pass a authentication, then i can
hard code a generic account (which has all needed ITSM access) and that
should do the trick.

Any help is appreciated. Alternate solutions are also welcome. 

Regards,
Kumar

_attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ 

_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"


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

Re: Run process to open FORM on second server

[remedyarlist]

Hi LJ,

Following your solution, I need to call web link for I'm form with 
authentication in active link. Could you please share the syntax.

Regards,
Sent on my BlackBerry® from Vodafone

-Original Message-
From: LJ LongWing 
Sender:   "Action Request System discussion list(ARSList)" 

Date: Tue, 17 Jan 2012 13:42:46 
To: 
Reply-To: arslist@ARSLIST.ORG
Subject: Re: Run process to open FORM on second server

Kumar,

Being you are using ITSM via Mid-Tier (right?).you could use a static URL to
the Reporting server that provides a hard coded user/password.  This user
would need a read restricted license to be able to do this.but it should
work.

 

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of remedy arlist
Sent: Tuesday, January 17, 2012 1:24 PM
To: arslist@ARSLIST.ORG
Subject: Run process to open FORM on second server

 

** 

Hi ARSlist users,


BackGround: Have a Prod app and Rpt server. SQL level replication is enabled
to replicate data b/w the 2 in real time. ARADMIN access is disabled on RPT
to avoid users updating records. 

Issue: Users are performing free text searches on Notes field, Resolution
and summary field of Incident Form leading to timeout errors. 

Proposed solution: Plan is to provide a button on Prod Incident form. By
pressing this button, Active Link will fire and open incident FORM on
Reporting, where users can perform adv searches. This will work only if user
have same access in both Prod and RPT.

Road Block: Since data is getting replcated from Prod to Rpt, so users
permissions also get replicated from Prod to RPT. Now each access is
connected to server license so the permission replicated to Reporting is
connected to Prod server and reporting server license. As a result even
though user have admin access in Prod, it will work as Read only account on
Reporting. (ARADMIN is locked on RPT and needs a CRQ to remove this lock for
even account that needs to be udpated on Rpt). If there is a RUN Process
command that can be used in AL so we can pass a authentication, then i can
hard code a generic account (which has all needed ITSM access) and that
should do the trick.

Any help is appreciated. Alternate solutions are also welcome. 

Regards,
Kumar

_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"


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"