Re: IT Home Page Add Applications and Sub-Categories

[Jason Miller]

You create an Active Link Guide and then put your AL that actually opens
the form in that guide.  You do not need an AL that calls the AL guide like
you would if you wanted the guide to be triggered by a button.  It is the
guide that shows on the.

Here is an example that shows "Request Console" (the Application List
Label) in the Application List on the Home Page.


This AL guide is in the 'Sharp Request Management' deployable app so it is
automatically placed under that heading.  It is duplicated below because I
also have the entry point enabled on the form itself.  I removed permission
from the guide so only my team sees the duplicate entry point (its dev and
I was messing around).


If you want an entry point from one app to open a form from another app
(i.e. to change which heading it shows under) you can create an AL guide in
the app where you want the entry point to show and have it open the form
from the other app.

HTH,
Jason
​
​
​


On Thu, Sep 4, 2014 at 1:56 PM, Kathy Morris  wrote:

> Yes I am following along in the 8.1 guide, however I am not seeing how you
> create the link the console.
> In order to create an active link to trigger the form to open, I would need
> to have the link on the console.
> I am not seeing how to generate the link in the documentation.  I could be
> overlooking a step in the guide.
> I do see how to open a form by setting an entry point on the form.
>
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa A DLA CTR
> INFORMATION
> OPERATIONS
> Sent: Thursday, September 04, 2014 4:16 PM
> To: arslist@ARSLIST.ORG
> Subject: Re: IT Home Page Add Applications and Sub-Categories
>
> I'm not on 8.0 but I would search for "Entry Point" in the documentation.
> I
> think it's the same.  It's an Active Link Guide that you make an entry
> point.
>
> It should be all in there.
>
> Lisa
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:arslist@ARSLIST.ORG] On Behalf Of Kathy Morris
> Sent: Thursday, September 04, 2014 3:16 PM
> To: arslist@ARSLIST.ORG
> Subject: IT Home Page Add Applications and Sub-Categories
>
> **
>
> Hi All,
>
>
>
> We are on AR System/ITSM 8.0
> How do I add an application to the IT Home Page.
>
> Not sure how to add it on the panel.
>
> I usually use the defaults Incident Management, AR System Administration,
> Change Management, Atrium Core, etc  however we need to add new
> categories and sub-categories.
>
>
>
> Thanks
>
> _ARSlist: "Where the Answers Are" and have been for 20 years_
>
>
> 
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the
> Answers
> Are, and have been for 20 years"
>
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> "Where the Answers Are, and have been for 20 years"
>

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: Why should you ENGAGE?

[Joe D'Souza]

What happened in Orlando stays in Orlando???

 

Oh no that's Vegas..

 

My bad..

 

:-)

 

Joe

 

  _  

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Mueller, Doug
Sent: Thursday, September 04, 2014 2:48 PM
To: arslist@ARSLIST.ORG
Subject: Re: Why should you ENGAGE?

 

Howard,

 

You are not supposed to bring things like that up!

 

For those of you wondering about the reference, the previous visit of RUG to
Orlando and to in fact the same

hotel was in July 2001.  This was the final RUG event under the banner
Remedy Corporation and it was post

the announcement (but pre the completion) of the purchase of Remedy by
Peregrine.

 

This is NOT THE SAME!  There is no evil empire who is lying and cheating and
stealing hanging over our heads.

 

I hope you all choose to come and continue the revitalization of the User
Group under BMC with a strong

Remedy presence and contribution to make sure that we can continue with a
bigger and more useful

event for everyone.

 

And Howard, you are definitely going to get a 5 minute timeout standing in
the corner for bringing up such

unpleasantness and bad memories from the "dark period".

 

 

On the other side, I do hope that this event continues to expand on the
capturing of the good things that were

part of those user group meetings that the WWRUG team was caretaking for the
past few years.  The only way

for that to work is to get customers like yourselves come to see new things
and learn about the products

you are using and to ask those hard questions in the hallways and breakouts.
We all hope to see you there.

 

Doug

 

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Richter, Howard (CEI - Atlanta)
Sent: Thursday, September 04, 2014 9:55 AM
To: arslist@ARSLIST.ORG
Subject: Re: Why should you ENGAGE?

 

** 

Hey Doug,

 

Maybe we need some sort of exorcism, so we are not reminded of the last time
a "Remedy" event was held in Orlando.

 

Hbr

 

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Doug Blair
Sent: Thursday, September 04, 2014 12:51 PM
To: arslist@ARSLIST.ORG
Subject: Re: [arslist] Why should you ENGAGE?

 

** 

On Sep 3, 2014, at 1:39 PM, Mueller, Doug  wrote:

 

Let me know if you have any questions/suggestions and I will make sure they
are responded to.

 

I hope to see you all in Orlando - I will probably be the one in some
ridiculous costume or hat or some other

such apparel who just may be carrying around a tray of appetizers or
desserts for your dining pleasure.

 

Doug Mueller

 

While I cannot speak for Mr. Mueller's intended behavior at BMC Engage 2014,


I can vouch for his excellent dessert service at WWRUG11 :-)

 

 

 

Click here
  to report this email as spam.

_ARSlist: "Where the Answers Are" and have been for 20 years_ 



** 

 

Doug Mueller, The Cupcake Man..

 

(I know, I know. You were just counting the minutes until someone posted
this..)

 

Doug

 

--

Doug Blair

d...@blairing.com

+1 224-558-5462

_ARSlist: "Where the Answers Are" and have been for 20 years_ 

_ARSlist: "Where the Answers Are" and have been for 20 years_ 

_ARSlist: "Where the Answers Are" and have been for 20 years_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: *Ancient* bug with Set Field from a SQL transaction still present...

[Joe D'Souza]

It does make sense - it just feels (if you are not already aware that is the
way it works) that there is something wrong somewhere. I felt that about 5
years ago when I saw that on 7.1 and was wondering why it was showing me
multiple choices  when I had selected just one column to return. It took me
a few to figure it must have been looking at the number of commas to
generate that menu.

 

I do not remember ever having a problem with the SQL set field functionality
not working correctly otherwise. I preferred to use it over creating a view
form to set fields from as it less involved timewise.

 

Once however if I recall correctly, I did run out of characters as the
column that saves the SQL statement did not accommodate my SQL statement.
I'm pretty sure it was limited to the number of characters that could be
used in the SQL statement.

 

Joe

 

  _  

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Mueller, Doug
Sent: Thursday, September 04, 2014 2:38 PM
To: arslist@ARSLIST.ORG
Subject: Re: *Ancient* bug with Set Field from a SQL transaction still
present...

 

Everyone,

 

Charlie is right about the functionality.

 

There is actually no way to determine the exact number of rows returned.
What if the SQL is a stored

procedure or uses an * or whatever it does.  The only thing the menu at the
end is to try and help you by

giving a menu of field references like we do with non-direct SQL cases and
we give you some aids.

 

That is all the menu is.

 

You can enter ANY value you want.  If that is a column returned, we will use
that value.  If not, it will be a

NULL value.  Either way, the operation will be performed with the
appropriate substitution.

 

 

So, this is not a bug, but just the way things work.  The only alternative
would be to give you no menu help

and require that you type the substitution in correctly.  That way there
would never be a mismatch of the

number of items and the substitution parameters.  But, we feel that giving
you the most likely set of

choices and at least you can see the right syntax so you could drop and then
just change the number was

more useful than just abandoning you to your own devices.

 

I hope this explains things.

 

Doug Mueller

 

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Charlie Lotridge
Sent: Thursday, September 04, 2014 11:20 AM
To: arslist@ARSLIST.ORG
Subject: Re: *Ancient* bug with Set Field from a SQL transaction still
present...

 

** 

FYI this "comma counting" only affects what appears in the list of "field"
choices.  There's nothing stopping you from hand typing, say, $10$ or $100$
into a Set Fields value, even if the drop-down shows only (say) 5 choices.
Of course, your SQL had then better have at least that many columns of data
for this to make sense.

 

An example reason for this is a "SELECT * FROM..." sql statement.  Without a
very complex analysis of the DB's data dictionary, or somehow trying out the
SQL, there's no way for the Dev Studio to know how many columns might be
returned.  So, the value expression parser needs to allow you to include
whatever $$ values you wish to include.

 

For fun I just tried including a $200$ in a value.  Worked fine.  And,
without any SQL, the list of field choices seems to default to showing $1$
through $10$.

 

-c

 

On Thu, Sep 4, 2014 at 10:43 AM, Joe D'Souza  wrote:

** 

I saw it in 7.1 when I did a nested SQL statement that had many commas and
had noticed that it was number of commas + 1 that the Admin Tool back then
estimated the $ variables. Same as now. So that logic fails when you use
functions that require more than one parameters separated by a comma.

 

I did hear that was the case pre-7.1 too..

 

It must be tricky when you are returning more than 1 column yeah?
Fortunately for me both back then as well as now I needed only a single
column returned by the SQL so the only value I had any interest in was $1$.

 

Joe

 

  _  

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W
Sent: Thursday, September 04, 2014 8:49 AM
To: arslist@ARSLIST.ORG
Subject: Re: *Ancient* bug with Set Field from a SQL transaction still
present...

 

I'm not sure if it would be the API or just the code that is used in
Developer Studio (Possibly the same code that was used in the Admin tool).

 

When you do an SQL set fields DS does not actually run it to determine the
number of columns in the output so it just makes the best guess it can on
how many there will be.  I have seen this same scenario since at least
version 5 with the Admin Tool.

 

Fred

 

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Joe D'Souza
Sent: Thursday, September 04, 2014 6:10 AM
To: arslist@ARSLIST.ORG
Subject: *Ancient* bug with Set Field from a SQL transaction still
present...

 

** 

I had found this bu

Reported Date in Incident

[Brittain, Mark]

HI All,

I find that in most cases the Reported Date is somewhat redundant and thought I 
could make it useful. On our monitoring system, the alert is either released by 
the engineer to create an Incident via the Incident Interface Create web 
service or it auto releases after 10 minutes after the alert becomes critical. 
I need the Critical Date/Time for reports and hate to add new fields if I don't 
need to do so . So I was thinking I could populate the Critical Date/Time into 
the Reported Date field. In testing the date time I sent got overwritten with 
the submit date timing.  I did the test from my desktop so maybe there were 
active links that would not come into play if submitted via a web service.

Is this doable and I'm missing something simple, or is this just a bad idea?

ITSM 7.6.04

Mark

Mark Brittain
Sr. OSD Systems Engineer
ITILv3 Foundation, Continual Service Improvement
NaviSite, Inc. - A Time Warner Cable Company
mbritt...@navisite.com
Office: 315.634.9337
Mobile: 315.882.5360
[cid:image001.gif@01CFC86B.0B401A40]



This E-mail and any of its attachments may contain Time Warner Cable 
proprietary information, which is privileged, confidential, or subject to 
copyright belonging to Time Warner Cable. This E-mail is intended solely for 
the use of the individual or entity to which it is addressed. If you are not 
the intended recipient of this E-mail, you are hereby notified that any 
dissemination, distribution, copying, or action taken in relation to the 
contents of and attachments to this E-mail is strictly prohibited and may be 
unlawful. If you have received this E-mail in error, please notify the sender 
immediately and permanently delete the original and any copy of this E-mail and 
any printout.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: IT Home Page Add Applications and Sub-Categories

[Kathy Morris]

Yes I am following along in the 8.1 guide, however I am not seeing how you
create the link the console. 
In order to create an active link to trigger the form to open, I would need
to have the link on the console.
I am not seeing how to generate the link in the documentation.  I could be
overlooking a step in the guide.
I do see how to open a form by setting an entry point on the form.


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa A DLA CTR INFORMATION
OPERATIONS
Sent: Thursday, September 04, 2014 4:16 PM
To: arslist@ARSLIST.ORG
Subject: Re: IT Home Page Add Applications and Sub-Categories

I'm not on 8.0 but I would search for "Entry Point" in the documentation.  I
think it's the same.  It's an Active Link Guide that you make an entry
point.

It should be all in there.

Lisa

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Kathy Morris
Sent: Thursday, September 04, 2014 3:16 PM
To: arslist@ARSLIST.ORG
Subject: IT Home Page Add Applications and Sub-Categories

** 

Hi All,

 

We are on AR System/ITSM 8.0
How do I add an application to the IT Home Page.   

Not sure how to add it on the panel.  

I usually use the defaults Incident Management, AR System Administration,
Change Management, Atrium Core, etc  however we need to add new
categories and sub-categories.

 

Thanks

_ARSlist: "Where the Answers Are" and have been for 20 years_


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers
Are, and have been for 20 years"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: IT Home Page Add Applications and Sub-Categories

[Kemes, Lisa A DLA CTR INFORMATION OPERATIONS]

I'm not on 8.0 but I would search for "Entry Point" in the
documentation.  I think it's the same.  It's an Active Link Guide that
you make an entry point.

It should be all in there.

Lisa

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Kathy Morris
Sent: Thursday, September 04, 2014 3:16 PM
To: arslist@ARSLIST.ORG
Subject: IT Home Page Add Applications and Sub-Categories

** 

Hi All,

 

We are on AR System/ITSM 8.0
How do I add an application to the IT Home Page.   

Not sure how to add it on the panel.  

I usually use the defaults Incident Management, AR System
Administration, Change Management, Atrium Core, etc  however we need
to add new categories and sub-categories.

 

Thanks

_ARSlist: "Where the Answers Are" and have been for 20 years_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

IT Home Page Add Applications and Sub-Categories

[Kathy Morris]

Hi All,

 

We are on AR System/ITSM 8.0
How do I add an application to the IT Home Page.   

Not sure how to add it on the panel.  

I usually use the defaults Incident Management, AR System Administration,
Change Management, Atrium Core, etc..  however we need to add new categories
and sub-categories.

 

Thanks


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: Why should you ENGAGE?

[Mueller, Doug]

Howard,

You are not supposed to bring things like that up!

For those of you wondering about the reference, the previous visit of RUG to 
Orlando and to in fact the same
hotel was in July 2001.  This was the final RUG event under the banner Remedy 
Corporation and it was post
the announcement (but pre the completion) of the purchase of Remedy by 
Peregrine.

This is NOT THE SAME!  There is no evil empire who is lying and cheating and 
stealing hanging over our heads.

I hope you all choose to come and continue the revitalization of the User Group 
under BMC with a strong
Remedy presence and contribution to make sure that we can continue with a 
bigger and more useful
event for everyone.

And Howard, you are definitely going to get a 5 minute timeout standing in the 
corner for bringing up such
unpleasantness and bad memories from the "dark period".


On the other side, I do hope that this event continues to expand on the 
capturing of the good things that were
part of those user group meetings that the WWRUG team was caretaking for the 
past few years.  The only way
for that to work is to get customers like yourselves come to see new things and 
learn about the products
you are using and to ask those hard questions in the hallways and breakouts.  
We all hope to see you there.

Doug

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Richter, Howard (CEI - Atlanta)
Sent: Thursday, September 04, 2014 9:55 AM
To: arslist@ARSLIST.ORG
Subject: Re: Why should you ENGAGE?

**
Hey Doug,

Maybe we need some sort of exorcism, so we are not reminded of the last time a 
"Remedy" event was held in Orlando.

Hbr

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Doug Blair
Sent: Thursday, September 04, 2014 12:51 PM
To: arslist@ARSLIST.ORG
Subject: Re: [arslist] Why should you ENGAGE?

**
On Sep 3, 2014, at 1:39 PM, Mueller, Doug 
mailto:doug_muel...@bmc.com>> wrote:

Let me know if you have any questions/suggestions and I will make sure they are 
responded to.

I hope to see you all in Orlando - I will probably be the one in some 
ridiculous costume or hat or some other
such apparel who just may be carrying around a tray of appetizers or desserts 
for your dining pleasure.

Doug Mueller

While I cannot speak for Mr. Mueller's intended behavior at BMC Engage 2014,
I can vouch for his excellent dessert service at WWRUG11 :-)




Click 
here
 to report this email as spam.
_ARSlist: "Where the Answers Are" and have been for 20 years_
[cid:image001.jpg@01CFC836.189179D0]
**

Doug Mueller, The Cupcake Man

(I know, I know. You were just counting the minutes until someone posted 
this)

Doug

--
Doug Blair
d...@blairing.com
+1 224-558-5462
_ARSlist: "Where the Answers Are" and have been for 20 years_
_ARSlist: "Where the Answers Are" and have been for 20 years_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Intermittent authentication service not responding error- 8922/9388

[Harry]

Hi Experts,

While there NOT even single change to remedy server was applied, in terms 
of configuration to the ar.conf, armonitor.cfg, threads etc…or workflow 
level, but after a scheduled restart of all the remedy servers (is a weekly 
activity) we started facing authentication service not responding error- 
8922, intermittently 

Interestingly, our QA environment also started behaving with this same 
ARERRR 8922 and that too intermittently.

We have multiple LDAP servers in AREA-LDAP configuration.

--ARERR 8922 is using User tool and ARERR 9388 is using mid-tier/browser.

*AR server version*  7.6.04 SP3  with Red hat Linux EL5.x. Its Server group 
environment.

 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: *Ancient* bug with Set Field from a SQL transaction still present...

[Mueller, Doug]

Everyone,

Charlie is right about the functionality.

There is actually no way to determine the exact number of rows returned.  What 
if the SQL is a stored
procedure or uses an * or whatever it does.  The only thing the menu at the end 
is to try and help you by
giving a menu of field references like we do with non-direct SQL cases and we 
give you some aids.

That is all the menu is.

You can enter ANY value you want.  If that is a column returned, we will use 
that value.  If not, it will be a
NULL value.  Either way, the operation will be performed with the appropriate 
substitution.


So, this is not a bug, but just the way things work.  The only alternative 
would be to give you no menu help
and require that you type the substitution in correctly.  That way there would 
never be a mismatch of the
number of items and the substitution parameters.  But, we feel that giving you 
the most likely set of
choices and at least you can see the right syntax so you could drop and then 
just change the number was
more useful than just abandoning you to your own devices.

I hope this explains things.

Doug Mueller

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Charlie Lotridge
Sent: Thursday, September 04, 2014 11:20 AM
To: arslist@ARSLIST.ORG
Subject: Re: *Ancient* bug with Set Field from a SQL transaction still 
present...

**
FYI this "comma counting" only affects what appears in the list of "field" 
choices.  There's nothing stopping you from hand typing, say, $10$ or $100$ 
into a Set Fields value, even if the drop-down shows only (say) 5 choices.  Of 
course, your SQL had then better have at least that many columns of data for 
this to make sense.

An example reason for this is a "SELECT * FROM..." sql statement.  Without a 
very complex analysis of the DB's data dictionary, or somehow trying out the 
SQL, there's no way for the Dev Studio to know how many columns might be 
returned.  So, the value expression parser needs to allow you to include 
whatever $$ values you wish to include.

For fun I just tried including a $200$ in a value.  Worked fine.  And, without 
any SQL, the list of field choices seems to default to showing $1$ through $10$.

-c

On Thu, Sep 4, 2014 at 10:43 AM, Joe D'Souza 
mailto:jdso...@shyle.net>> wrote:
**
I saw it in 7.1 when I did a nested SQL statement that had many commas and had 
noticed that it was number of commas + 1 that the Admin Tool back then 
estimated the $ variables. Same as now. So that logic fails when you use 
functions that require more than one parameters separated by a comma.

I did hear that was the case pre-7.1 too..

It must be tricky when you are returning more than 1 column yeah? Fortunately 
for me both back then as well as now I needed only a single column returned by 
the SQL so the only value I had any interest in was $1$.

Joe


From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, 
Frederick W
Sent: Thursday, September 04, 2014 8:49 AM
To: arslist@ARSLIST.ORG
Subject: Re: *Ancient* bug with Set Field from a SQL transaction still 
present...

I’m not sure if it would be the API or just the code that is used in Developer 
Studio (Possibly the same code that was used in the Admin tool).

When you do an SQL set fields DS does not actually run it to determine the 
number of columns in the output so it just makes the best guess it can on how 
many there will be.  I have seen this same scenario since at least version 5 
with the Admin Tool.

Fred

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Joe 
D'Souza
Sent: Thursday, September 04, 2014 6:10 AM
To: arslist@ARSLIST.ORG
Subject: *Ancient* bug with Set Field from a SQL transaction still present...

**
I had found this bug a really long time ago on version 7.1.

It still exists.

I was trying Set Fields through SQL to capitalize the first letter of a word 
after the 6th character so this should have returned only $1$ as a possible 
choice of results.

select substr('$FieldName$', 1, 6) || initcap(substr('$FieldName$', 7)) from 
dual

However, I get $1$, $2$, $3$ and $4$ to choose from. It appears like the 
ARSystem API looks at every comma between select and from and thinks that there 
are that many column values to return, which would explain the 4 dollar columns 
in the result list to choose from.

Fortunately using $1$ (which should have been the only choice to choose from) 
gets me the right results.

Has anybody else reported this to BMC Support? I had reported this years ago 
but it appears like it has not yet got fixed. Fortunately, back then too, I 
needed just the first column so I did not have any real problem.

I have not tested to see if I need more than one column, if the $ variables 
would return the right r

Re: *Ancient* bug with Set Field from a SQL transaction still present...

[Charlie Lotridge]

FYI this "comma counting" only affects what appears in the list of "field"
choices.  There's nothing stopping you from hand typing, say, $10$ or $100$
into a Set Fields value, even if the drop-down shows only (say) 5 choices.
 Of course, your SQL had then better have at least that many columns of
data for this to make sense.

An example reason for this is a "SELECT * FROM..." sql statement.  Without
a very complex analysis of the DB's data dictionary, or somehow trying out
the SQL, there's no way for the Dev Studio to know how many columns might
be returned.  So, the value expression parser needs to allow you to
include *whatever
*$$ values you wish to include.

For fun I just tried including a $200$ in a value.  Worked fine.  And,
without any SQL, the list of field choices seems to default to showing $1$
through $10$.

-c


On Thu, Sep 4, 2014 at 10:43 AM, Joe D'Souza  wrote:

> **
>
> I saw it in 7.1 when I did a nested SQL statement that had many commas and
> had noticed that it was number of commas + 1 that the Admin Tool back then
> estimated the $ variables. Same as now. So that logic fails when you use
> functions that require more than one parameters separated by a comma.
>
>
>
> I did hear that was the case pre-7.1 too..
>
>
>
> It must be tricky when you are returning more than 1 column yeah?
> Fortunately for me both back then as well as now I needed only a single
> column returned by the SQL so the only value I had any interest in was $1$.
>
>
>
> Joe
>
>
>  --
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> arslist@ARSLIST.ORG] *On Behalf Of *Grooms, Frederick W
> *Sent:* Thursday, September 04, 2014 8:49 AM
> *To:* arslist@ARSLIST.ORG
> *Subject:* Re: *Ancient* bug with Set Field from a SQL transaction still
> present...
>
>
>
> I’m not sure if it would be the API or just the code that is used in
> Developer Studio (Possibly the same code that was used in the Admin tool).
>
>
>
> When you do an SQL set fields DS does not actually run it to determine the
> number of columns in the output so it just makes the best guess it can on
> how many there will be.  I have seen this same scenario since at least
> version 5 with the Admin Tool.
>
>
>
> Fred
>
>
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> arslist@ARSLIST.ORG] *On Behalf Of *Joe D'Souza
> *Sent:* Thursday, September 04, 2014 6:10 AM
> *To:* arslist@ARSLIST.ORG
> *Subject:* *Ancient* bug with Set Field from a SQL transaction still
> present...
>
>
>
> **
>
> I had found this bug a really long time ago on version 7.1.
>
>
>
> It still exists.
>
>
>
> I was trying Set Fields through SQL to capitalize the first letter of a
> word after the 6th character so this should have returned only $1$ as a
> possible choice of results.
>
>
>
> select substr('$FieldName$', 1, 6) || initcap(substr('$FieldName$', 7))
> from dual
>
>
>
> However, I get $1$, $2$, $3$ and $4$ to choose from. It appears like the
> ARSystem API looks at every comma between select and from and thinks that
> there are that many column values to return, which would explain the 4
> dollar columns in the result list to choose from.
>
>
>
> Fortunately using $1$ (which should have been the only choice to choose
> from) gets me the right results.
>
>
>
> Has anybody else reported this to BMC Support? I had reported this years
> ago but it appears like it has not yet got fixed. Fortunately, back then
> too, I needed just the first column so I did not have any real problem.
>
>
>
> I have not tested to see if I need more than one column, if the $
> variables would return the right results. Also I have not tested what $2$,
> $3$ and $4$ holds. Probably nulls. Or may return an error at run time if
> you select them.
>
>
>
> Cheers
>
>
>
> Joe
>  _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist:
> "Where the Answers Are" and have been for 20 years_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: *Ancient* bug with Set Field from a SQL transaction still present...

[Joe D'Souza]

I saw it in 7.1 when I did a nested SQL statement that had many commas and
had noticed that it was number of commas + 1 that the Admin Tool back then
estimated the $ variables. Same as now. So that logic fails when you use
functions that require more than one parameters separated by a comma.

 

I did hear that was the case pre-7.1 too..

 

It must be tricky when you are returning more than 1 column yeah?
Fortunately for me both back then as well as now I needed only a single
column returned by the SQL so the only value I had any interest in was $1$.

 

Joe

 

  _  

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W
Sent: Thursday, September 04, 2014 8:49 AM
To: arslist@ARSLIST.ORG
Subject: Re: *Ancient* bug with Set Field from a SQL transaction still
present...

 

I'm not sure if it would be the API or just the code that is used in
Developer Studio (Possibly the same code that was used in the Admin tool).

 

When you do an SQL set fields DS does not actually run it to determine the
number of columns in the output so it just makes the best guess it can on
how many there will be.  I have seen this same scenario since at least
version 5 with the Admin Tool.

 

Fred

 

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Joe D'Souza
Sent: Thursday, September 04, 2014 6:10 AM
To: arslist@ARSLIST.ORG
Subject: *Ancient* bug with Set Field from a SQL transaction still
present...

 

** 

I had found this bug a really long time ago on version 7.1.

 

It still exists.

 

I was trying Set Fields through SQL to capitalize the first letter of a word
after the 6th character so this should have returned only $1$ as a possible
choice of results.

 

select substr('$FieldName$', 1, 6) || initcap(substr('$FieldName$', 7)) from
dual

 

However, I get $1$, $2$, $3$ and $4$ to choose from. It appears like the
ARSystem API looks at every comma between select and from and thinks that
there are that many column values to return, which would explain the 4
dollar columns in the result list to choose from.

 

Fortunately using $1$ (which should have been the only choice to choose
from) gets me the right results.

 

Has anybody else reported this to BMC Support? I had reported this years ago
but it appears like it has not yet got fixed. Fortunately, back then too, I
needed just the first column so I did not have any real problem.

 

I have not tested to see if I need more than one column, if the $ variables
would return the right results. Also I have not tested what $2$, $3$ and $4$
holds. Probably nulls. Or may return an error at run time if you select
them.

 

Cheers

 

Joe

_ARSlist: "Where the Answers Are" and have been for 20 years_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: Responded Date Editable Mode.

[Carin Grobler]

Suresh,

You don't state what version of ITSM.

OOTB under Incident configuration Rules there is a configuration setting
 changeable Responded Date  Yes/No
Setting that  to No  will lock the field down for edit

These dates can be modified only by a user with the functional role of
support group manager or support group lead of the incident owner group, or
who has the Incident Master permission.

Through testing this was validated. The Reported Date and Responded Date on
Dates/System tab in Incident (Resolved or Closed) become R/W when user with
Incident Master permissions views/open them to modify. The same applies to
Resolution dates and other fields on Resolution tab.


On Thu, Sep 4, 2014 at 11:40 AM, LJ LongWing  wrote:

> **
> in 7.6.04 and forward, an Overlay would be the 'better' way to do it :)
>
>
> On Thu, Sep 4, 2014 at 10:34 AM, Hennigan, Sandra <
> sandra.henni...@usdoj.gov> wrote:
>
>> **
>>
>> There is workflow that sets the field to read-only even when the Rules
>> set the field to changeable.
>>
>>
>>
>> Check the HPD:INC:ReadOnlyFlds and HPD:INC:ReadOnlyField Active Links. I
>> did a file – save as and created custom ALs then disabled the out of the
>> box ALs.
>>
>>
>>
>> Thank you,
>>
>>
>>
>> Sandra Hennigan
>>
>> Remedy Developer
>>
>>
>>
>> *From:* Action Request System discussion list(ARSList) [mailto:
>> arslist@ARSLIST.ORG] *On Behalf Of *Suresh Loganathan
>> *Sent:* Thursday, September 4, 2014 12:15 PM
>> *To:* arslist@ARSLIST.ORG
>> *Subject:* Responded Date Editable Mode.
>>
>>
>>
>> **
>>
>> Hi All,
>>
>> Is it possible to make a Responded date field is editable mode.? I have
>> checked th information Incident Rules form and tried to edit responded date
>> field as no to yes. Tried to edit the date into that field. No luck.
>>
>> Any way to make it as read/write mode. Hope this field depends SLA.
>> Please share your input to fulfill this requirement only on configuration
>> side. kindly help.
>>
>> Regards,
>>
>> Suresh Loganathan.
>>
>> _ARSlist: "Where the Answers Are" and have been for 20 years_
>>  _ARSlist: "Where the Answers Are" and have been for 20 years_
>>
>
> _ARSlist: "Where the Answers Are" and have been for 20 years_
>

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: Why should you ENGAGE?

[Richter, Howard (CEI - Atlanta)]

Hey Doug,

Maybe we need some sort of exorcism, so we are not reminded of the last time a 
"Remedy" event was held in Orlando.

Hbr

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Doug Blair
Sent: Thursday, September 04, 2014 12:51 PM
To: arslist@ARSLIST.ORG
Subject: Re: [arslist] Why should you ENGAGE?

**
On Sep 3, 2014, at 1:39 PM, Mueller, Doug 
mailto:doug_muel...@bmc.com>> wrote:


Let me know if you have any questions/suggestions and I will make sure they are 
responded to.

I hope to see you all in Orlando - I will probably be the one in some 
ridiculous costume or hat or some other
such apparel who just may be carrying around a tray of appetizers or desserts 
for your dining pleasure.

Doug Mueller

While I cannot speak for Mr. Mueller's intended behavior at BMC Engage 2014,
I can vouch for his excellent dessert service at WWRUG11 :-)




Click 
here
 to report this email as spam.
_ARSlist: "Where the Answers Are" and have been for 20 years_
[cid:image001.jpg@01CFC83F.74782740]
**

Doug Mueller, The Cupcake Man

(I know, I know. You were just counting the minutes until someone posted 
this)

Doug

--
Doug Blair
d...@blairing.com
+1 224-558-5462
_ARSlist: "Where the Answers Are" and have been for 20 years_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: Why should you ENGAGE?

[Doug Blair]

**
On Sep 3, 2014, at 1:39 PM, Mueller, Doug  wrote:Let me know if you have any questions/suggestions and I will make sure they are responded to. I hope to see you all in Orlando – I will probably be the one in some ridiculous costume or hat or some othersuch apparel who just may be carrying around a tray of appetizers or desserts for your dining pleasure. Doug MuellerWhile I cannot speak for Mr. Mueller’s intended behavior at BMC Engage 2014, I can vouch for his excellent dessert service at WWRUG11 :-)_ARSlist: "Where the Answers Are" and have been for 20 years_
**
Doug Mueller, The Cupcake Man….(I know, I know. You were just counting the minutes until someone posted this….)Doug--Doug Blaird...@blairing.com+1 224-558-5462_ARSlist: "Where the Answers Are" and have been for 20 years_

Re: Responded Date Editable Mode.

[LJ LongWing]

in 7.6.04 and forward, an Overlay would be the 'better' way to do it :)


On Thu, Sep 4, 2014 at 10:34 AM, Hennigan, Sandra  wrote:

> **
>
> There is workflow that sets the field to read-only even when the Rules set
> the field to changeable.
>
>
>
> Check the HPD:INC:ReadOnlyFlds and HPD:INC:ReadOnlyField Active Links. I
> did a file – save as and created custom ALs then disabled the out of the
> box ALs.
>
>
>
> Thank you,
>
>
>
> Sandra Hennigan
>
> Remedy Developer
>
>
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> arslist@ARSLIST.ORG] *On Behalf Of *Suresh Loganathan
> *Sent:* Thursday, September 4, 2014 12:15 PM
> *To:* arslist@ARSLIST.ORG
> *Subject:* Responded Date Editable Mode.
>
>
>
> **
>
> Hi All,
>
> Is it possible to make a Responded date field is editable mode.? I have
> checked th information Incident Rules form and tried to edit responded date
> field as no to yes. Tried to edit the date into that field. No luck.
>
> Any way to make it as read/write mode. Hope this field depends SLA. Please
> share your input to fulfill this requirement only on configuration side.
> kindly help.
>
> Regards,
>
> Suresh Loganathan.
>
> _ARSlist: "Where the Answers Are" and have been for 20 years_
>  _ARSlist: "Where the Answers Are" and have been for 20 years_
>

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: Responded Date Editable Mode.

[Hennigan, Sandra]

There is workflow that sets the field to read-only even when the Rules set the 
field to changeable.

Check the HPD:INC:ReadOnlyFlds and HPD:INC:ReadOnlyField Active Links. I did a 
file – save as and created custom ALs then disabled the out of the box ALs.

Thank you,

Sandra Hennigan
Remedy Developer

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Suresh Loganathan
Sent: Thursday, September 4, 2014 12:15 PM
To: arslist@ARSLIST.ORG
Subject: Responded Date Editable Mode.

**

Hi All,

Is it possible to make a Responded date field is editable mode.? I have checked 
th information Incident Rules form and tried to edit responded date field as no 
to yes. Tried to edit the date into that field. No luck.

Any way to make it as read/write mode. Hope this field depends SLA. Please 
share your input to fulfill this requirement only on configuration side. kindly 
help.

Regards,

Suresh Loganathan.
_ARSlist: "Where the Answers Are" and have been for 20 years_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Responded Date Editable Mode.

[Suresh Loganathan]

Hi All,

Is it possible to make a Responded date field is editable mode.? I have
checked th information Incident Rules form and tried to edit responded date
field as no to yes. Tried to edit the date into that field. No luck.

Any way to make it as read/write mode. Hope this field depends SLA. Please
share your input to fulfill this requirement only on configuration side.
kindly help.

Regards,

Suresh Loganathan.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

CMDB SP1 Upgrade...

[Suresh Loganathan]

Hi All,

We have current architecture like 2 ARS and 2 Mid Tier. 2 ARS pointing the
same database.

Recently, we have done CMDB SP1 upgrade in one node. Hope, DB also
upgraded. Another node is not upgraded for remedy testing reason.

My question, what are the issues will face if one node not upgraded to CMDB
SP1. kindly help to get this information.

Remedy Version: 8.1  Database: Oracle.

Regards,

Suresh Loganathan.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: Target date field is not populating on incident management console.

[Hennigan, Sandra]

Rajesh,

On the Incident Management Console, the "Target Date" refers to the Target Date 
field on the HPD:Help Desk (Incident) Best Practice view not to any Service 
Level Management field. (db name = Estimated Resolution Date). 

The Incident Target Date field is manually set unless you add workflow to add 
or require data in the field. Example: For our staff, the Target Date field is 
required when setting the Status to Pending.

Thank you,

Sandra Hennigan
Remedy Developer

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Rajesh Singh
Sent: Thursday, September 4, 2014 11:18 AM
To: arslist@ARSLIST.ORG
Subject: Target date field is not populating on incident management console.

Hi List,

Target date column are not getting populated on incident management console. 
It is happening for most of the incident, Even though the service target are 
attached to the incident target date are not populating on incident management 
console.  

I have tried the below mentioned steps found in BMC communities still no luck.

1. Application Administration Console -> Custom Configurations -> Service Level 
management -> Configure Application Settings -> Goal types.
 
2. Choose Incident Resolution/Incident Response from the table and check the 
box "Incident Estimated Resolution tracking"
 
3. Save
 
Rebuilt the SLM Rules by:
goto Data Sources -> choose HPD:HelpDesk ->click on "Modify filters/Create 
Filters"

I took the logs but still didn't find much information.
Please make me understand what is the use of target field on incident form.and 
how can i fix this issue?.

Thanks,
Rajesh. 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers 
Are, and have been for 20 years"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Target date field is not populating on incident management console.

[Rajesh Singh]

Hi List,

Target date column are not getting populated on incident management console. 
It is happening for most of the incident, Even though the service target are 
attached to the incident target date are not populating on incident management 
console.  

I have tried the below mentioned steps found in BMC communities still no luck.

1. Application Administration Console -> Custom Configurations -> Service Level 
management -> Configure Application Settings -> Goal types.
 
2. Choose Incident Resolution/Incident Response from the table and check the 
box "Incident Estimated Resolution tracking"
 
3. Save
 
Rebuilt the SLM Rules by:
goto Data Sources -> choose HPD:HelpDesk ->click on "Modify filters/Create 
Filters"

I took the logs but still didn't find much information.
Please make me understand what is the use of target field on incident form.and 
how can i fix this issue?.

Thanks,
Rajesh.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: *Ancient* bug with Set Field from a SQL transaction still present...

[Charlie Lotridge]

Agreed.  The Dev Studio (and Admin tool before it) is not in the business
of parsing complex SQL, so they punt on the issue and just count commas
(and add one).  They trust that you, the developer who wrote the SQL, will
know how many valid results there actually are.

And now on to the subject of using the DB to perform this (kind of)
operation...it's very expensive!  I know that sometimes it's the only way
to get something done, but should be avoided wherever possible.  I sure
hope you're not doing this from active link logic, I cringe at the number
of times this would need to hit the wire (6).

-charlie


On Thu, Sep 4, 2014 at 5:49 AM, Grooms, Frederick W <
frederick.w.gro...@xo.com> wrote:

> **
>
> I’m not sure if it would be the API or just the code that is used in
> Developer Studio (Possibly the same code that was used in the Admin tool).
>
>
>
> When you do an SQL set fields DS does not actually run it to determine the
> number of columns in the output so it just makes the best guess it can on
> how many there will be.  I have seen this same scenario since at least
> version 5 with the Admin Tool.
>
>
>
> Fred
>
>
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> arslist@ARSLIST.ORG] *On Behalf Of *Joe D'Souza
> *Sent:* Thursday, September 04, 2014 6:10 AM
> *To:* arslist@ARSLIST.ORG
> *Subject:* *Ancient* bug with Set Field from a SQL transaction still
> present...
>
>
>
> **
>
> I had found this bug a really long time ago on version 7.1.
>
>
>
> It still exists.
>
>
>
> I was trying Set Fields through SQL to capitalize the first letter of a
> word after the 6th character so this should have returned only $1$ as a
> possible choice of results.
>
>
>
> select substr('$FieldName$', 1, 6) || initcap(substr('$FieldName$', 7))
> from dual
>
>
>
> However, I get $1$, $2$, $3$ and $4$ to choose from. It appears like the
> ARSystem API looks at every comma between select and from and thinks that
> there are that many column values to return, which would explain the 4
> dollar columns in the result list to choose from.
>
>
>
> Fortunately using $1$ (which should have been the only choice to choose
> from) gets me the right results.
>
>
>
> Has anybody else reported this to BMC Support? I had reported this years
> ago but it appears like it has not yet got fixed. Fortunately, back then
> too, I needed just the first column so I did not have any real problem.
>
>
>
> I have not tested to see if I need more than one column, if the $
> variables would return the right results. Also I have not tested what $2$,
> $3$ and $4$ holds. Probably nulls. Or may return an error at run time if
> you select them.
>
>
>
> Cheers
>
>
>
> Joe
>
>
>
>
>  _ARSlist: "Where the Answers Are" and have been for 20 years_
>

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: Importing Data from Remedy to SharePoint Caslendar

[John Sundberg]

The Kinetic Task engine can do this…

I can help you if you would like — email me directly.

Basically - Kinetic Task watches for tickets to be created in Remedy (or
any source) … then when a ticket is created (and it matches your criteria)
— it then runs a Kinetic Task tree. Task trees can talk to all kinds of
systems … SharePoint is just one example.

A bit more info about Task:
http://www.kineticdata.com/products/task/

A list of existing handlers:
http://community.kineticdata.com/20_Kinetic_Task/Task_Handlers

Specific SharePoint handlers (handlers are our term for integrations or
connectors)
http://community.kineticdata.com/20_Kinetic_Task/Task_Handlers/Microsoft_SharePoint


If you have userids for Remedy and for SharePoint — we should be able to
install Task and have this integration built in under 30 minutes.
(1 hour - if I also give you a tour of the whole thing)

-John



On Thu, Sep 4, 2014 at 7:19 AM, Arner, Todd  wrote:

> **
>
> I have a general question on importing data from a Remedy form into a
> SharePoint Calendar.  We have a custom built form in Remedy that we use to
> list the implementation schedule.  We are looking to export this date out
> of Remedy and into a SharePoint Calendar.  Has anyone done this?  Is there
> a product we can purchase to do this or is it something we need to build in
> house.  Any insight is greatly appreciated.  I’m not sure where to go with
> this one.
>
>
>
> Thanks,
>
> Todd Arner
>
> Great Lakes
>  --
> The information contained in this communication may be confidential, is
> intended only for the use of the recipient(s) named above, and may be
> protected under state or federal law. If the reader of this message is not
> the intended recipient, you are hereby notified that any dissemination,
> distribution, or copying of this communication, or any of its contents, is
> strictly prohibited. If you have received this communication in error,
> please forward the communication to no...@glhec.org immediately and
> destroy or delete the original message and any copy of it from your
> computer system. If you have any questions concerning this message, please
> contact the sender.
>  _ARSlist: "Where the Answers Are" and have been for 20 years_




-- 

*John Sundberg*
Kinetic Data, Inc.
"Your Business. Your Process."

651-556-0930 I john.sundb...@kineticdata.com
www.kineticdata.com I community.kineticdata.com

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: *Ancient* bug with Set Field from a SQL transaction still present...

[Grooms, Frederick W]

I'm not sure if it would be the API or just the code that is used in Developer 
Studio (Possibly the same code that was used in the Admin tool).

When you do an SQL set fields DS does not actually run it to determine the 
number of columns in the output so it just makes the best guess it can on how 
many there will be.  I have seen this same scenario since at least version 5 
with the Admin Tool.

Fred

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Joe D'Souza
Sent: Thursday, September 04, 2014 6:10 AM
To: arslist@ARSLIST.ORG
Subject: *Ancient* bug with Set Field from a SQL transaction still present...

**
I had found this bug a really long time ago on version 7.1.

It still exists.

I was trying Set Fields through SQL to capitalize the first letter of a word 
after the 6th character so this should have returned only $1$ as a possible 
choice of results.

select substr('$FieldName$', 1, 6) || initcap(substr('$FieldName$', 7)) from 
dual

However, I get $1$, $2$, $3$ and $4$ to choose from. It appears like the 
ARSystem API looks at every comma between select and from and thinks that there 
are that many column values to return, which would explain the 4 dollar columns 
in the result list to choose from.

Fortunately using $1$ (which should have been the only choice to choose from) 
gets me the right results.

Has anybody else reported this to BMC Support? I had reported this years ago 
but it appears like it has not yet got fixed. Fortunately, back then too, I 
needed just the first column so I did not have any real problem.

I have not tested to see if I need more than one column, if the $ variables 
would return the right results. Also I have not tested what $2$, $3$ and $4$ 
holds. Probably nulls. Or may return an error at run time if you select them.


Cheers



Joe



___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Importing Data from Remedy to SharePoint Caslendar

[Arner, Todd]

I have a general question on importing data from a Remedy form into a 
SharePoint Calendar.  We have a custom built form in Remedy that we use to list 
the implementation schedule.  We are looking to export this date out of Remedy 
and into a SharePoint Calendar.  Has anyone done this?  Is there a product we 
can purchase to do this or is it something we need to build in house.  Any 
insight is greatly appreciated.  I'm not sure where to go with this one.

Thanks,
Todd Arner
Great Lakes

--
The information contained in this communication may be confidential, is 
intended only for the use of the recipient(s) named above, and may be protected 
under state or federal law. If the reader of this message is not the intended 
recipient, you are hereby notified that any dissemination, distribution, or 
copying of this communication, or any of its contents, is strictly prohibited. 
If you have received this communication in error, please forward the 
communication to no...@glhec.org immediately and destroy or delete the original 
message and any copy of it from your computer system. If you have any questions 
concerning this message, please contact the sender.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: process designer questions

[andres tamayo]

raj thanks for your quick answers! really helpful!


2014-09-03 20:05 GMT-05:00 Raj :

> **
>
> Answers inline.
>
>
>
> 1. how does the multitenant feature works? i mean the same process
> can exists for example for global and a particular company? if so how
> precedence works? i mean if mapping conditions are the same which process
> execute.
>
> The mapping is explicitly selected in the mapping form, so if you select
> Global Company – it will pick Global company process and if you selected
> your specific company, your specific company process will be selected for
> trigger. If you have selected both the companies, there is a sort order
> field based on which the choice is made.
>
>
>
>
>
> 2. when a process is attached to an incident can i still add ad hoc tasks?
>
> Not today, but an enhancement request can be made for this and possibly
> get addressed soon.
>
>
>
> 2. is there any documentation that states how the PD affects the
> global performance of the applications? i mean how can affect application
> performance be affected based in the fact that we can have complex process
> attached to an incident and there will be many process "executing" at same
> time?
>
> Where did you hear about that? PD is a combination of few filters and a
> filter plugin code. Filters would not affect the performance greatly.
> Filter plugin is configurable for number of threads and use of private
> queue and the same can be fine-tuned in case you find performance if
> needed, although I have not heard of explicit performance degradation due
> to PD. BTW – PD Processes execute in async manner in different threads and
> hence don’t give direct impact on parent requests.
>
>
>
> -Raj
>
>
>
> *From:* andres tamayo [via ARS (Action Request System)] 
> [mailto:ml-node+[hidden
> email] ]
> *Sent:* Thursday, September 04, 2014 01:16
> *To:* Hiremath, Raj
> *Subject:* process designer questions
>
>
>
> **
>
> Hi there
>
>
>
> i'm starting to work with PD associated to ITSM particularly incident
> module and i'm wondering if somebody can help me with some questions
> regarding this tool
>
>
>
> 1. how does the multitenant feature works? i mean the same process
> can exists for example for global and a particular company? if so how
> precedence works? i mean if mapping conditions are the same which process
> execute.
>
> The mapping is explicitly selected in the mapping form, so if you select
> Global Company – it will pick Global company process and if you selected
> your specific company, your specific company process will be selected for
> trigger. If you have selected both the companies, there is a sort order
> field based on which the choice is made.
>
>
>
>
>
> 2. when a process is attached to an incident can i still add ad hoc tasks?
>
> Not today, but an enhancement request can be made for this and possibly
> get addressed soon.
>
>
>
> 2. is there any documentation that states how the PD affects the
> global performance of the applications? i mean how can affect application
> performance be affected based in the fact that we can have complex process
> attached to an incident and there will be many process "executing" at same
> time?
>
> Where did you hear about that? PD is a combination of few filters and a
> filter plugin code. Filters would not affect the performance greatly.
> Filter plugin is configurable for number of threads and use of private
> queue and the same can be fine-tuned in case you find performance if
> needed, although I have not heard of explicit performance degradation due
> to PD. BTW – PD Processes execute in async manner in different threads and
> hence don’t give direct impact on parent requests.
>
>
>
>
>
> thanks
>
> _ARSlist: "Where the Answers Are" and have been for 20 years_
>  --
>
> *If you reply to this email, your message will be added to the discussion
> below:*
>
>
> http://ars-action-request-system.1.n7.nabble.com/process-designer-questions-tp118759.html
>
> To start a new topic under ARS (Action Request System), email [hidden
> email] 
> To unsubscribe from ARS (Action Request System), click here.
> NAML
> 
>   -rAJ
>
> --
> View this message in context: RE: process designer questions
> 
> Sent from the ARS (Action Request System) mailing list archive
>  at Nabble.com.
> _ARSlist: "W

*Ancient* bug with Set Field from a SQL transaction still present...

[Joe D'Souza]

I had found this bug a really long time ago on version 7.1.

 

It still exists.

 

I was trying Set Fields through SQL to capitalize the first letter of a word
after the 6th character so this should have returned only $1$ as a possible
choice of results.

 

select substr('$FieldName$', 1, 6) || initcap(substr('$FieldName$', 7)) from
dual

 

However, I get $1$, $2$, $3$ and $4$ to choose from. It appears like the
ARSystem API looks at every comma between select and from and thinks that
there are that many column values to return, which would explain the 4
dollar columns in the result list to choose from.

 

Fortunately using $1$ (which should have been the only choice to choose
from) gets me the right results.

 

Has anybody else reported this to BMC Support? I had reported this years ago
but it appears like it has not yet got fixed. Fortunately, back then too, I
needed just the first column so I did not have any real problem.

 

I have not tested to see if I need more than one column, if the $ variables
would return the right results. Also I have not tested what $2$, $3$ and $4$
holds. Probably nulls. Or may return an error at run time if you select
them.

 

Cheers

 

Joe


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"