Re: how to remove duplicate entries

[Heider, Stephen]

serouche,

If you know SQL you could write a stored procedure that would identify
the duplicates and then update a separate field on the form (ie. Set an
Optional Checkbox field to 0).  Followed by a filter that would delete
each of the records which have a value in this checkbox field. 

If you need users to be able to run this at anytime trigger it from an
Active Link.

HTH

Stephen
Remedy Skilled Professional

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Misi Mladoniczky
Sent: Monday, January 21, 2008 6:28 AM
To: arslist@ARSLIST.ORG
Subject: Re: how to remove duplicate entries

Hi,

You could create a table-field that sorts its content on the field(s)
you
want to remove duplicates from. Also include the request-id in one
column.

Table Field with Columns:
- TblColValue
- TblColReqID

Create a display-only-temp-fields:
- TempPrevValue

Then you create Active Links for a table-loop-guide:
AL 1:
  Run If: $TblColValue$ = $TempPrevValue$
  Action Run Process: @@:Application-Delete-Entry "Form" "$TblColReqID$"
AL 2:
  Run If:
  Action Set Fields: TempPrevValue = $TblColValue$

Create the Guide and add the above Active Links:

Create an Active Link that calls the guide with Table Loop activated.

Best Regards - Misi, RRR AB, http://www.rrr.se

Products from RRR Scandinavia:
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy
logs.
* RRR|Translator - Manage and automate your language translations.
Find these products, and many free tools and utilities, at
http://rrr.se.

> dear all,
>
> I would like to clean-up duplicate entries in a character field.
> I must use AL on the web.
> How can I do this?
> Through filters I would do something like "RUN PROCESS echo "MYFIELD"
|
> sort | uniq" and that will do but through AL on the web I don't see.
> Please help.
> Thank you.
>
> serouche
> /"because there is always a remedy to help you"/
>
>

___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
>
> --
> This message was scanned by ESVA and is believed to be clean.
>


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Find EXCEL.EXE full path

[Heider, Stephen]

Here is the way I do it - it's been in production for about 3 years now.
I test for the usual places the various versions of Excel reside.

Active Link 1 (check for Excel 2003)
Run If Qual: nothing
Set Fields 
zTmpField1 = "C:\Program Files\Microsoft
Office\OFFICE11\Excel.exe"
Set Fields
zTmpField2 = $PROCESS$ cmd.exe /c "if exist """$zTmpField1$"""
(echo Yes) else (echo No)"

Active Link 2 (not found, check for Excel XP)
Run If Qual: NOT 'zTmpField2' LIKE "Y%" OR 'zTmpField2' = $NULL$
Set Fields 
zTmpField1 = "C:\Program Files\Microsoft
Office\OFFICE10\Excel.exe"
Set Fields
zTmpField2 = $PROCESS$ cmd.exe /c "if exist """$zTmpField1$"""
(echo Yes) else (echo No)"
Else Action (means it found it in Active Link 1)
Set Fields
Global - Excel Path = $zTmpField1$

...and so on until you find a match. Right now I only check for Excel
2003, Excel XP, Excel 2000.  This reminds me, I need to add a check for
Excel 2007 since several users are beginning to use that version.


There is another option available to you - WksInfo from
http://arswiki.org/projects/dotnetutil.  Click on the Downloads link
located in the upper-right part of the screen.   

This free open source utility gathers a number of details from the
user's computer (from Windows User Tool, not Mid-Tier) and makes them
available to your workflow.  The Excel path is included (although it
needs to be updated to check for Excel 2007).

The utility is written in VB.Net 2005 and the ARS .Net API.

Stephen
Remedy Skilled Professional


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of CONDREA, Daniel
Sent: Thursday, January 24, 2008 7:49 AM
To: arslist@ARSLIST.ORG
Subject: Find EXCEL.EXE full path

Hi All,

Can anyone share 'How to get EXCEL.EXE full path from user tool?'

Usually EXCEL.EXE path is

C:\Program Files\Microsoft Office\OFFICE11

Thank you very much,
Daniel Condrea


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

ServletExec Max Concurrent Requests Exceeded

[Heider, Stephen]

All users receiving this error from mid tier server:

 


ServletExec Max Concurrent Requests Exceeded


When not registered, ServletExec supports a maximum of 3 concurrent
requests.

 

 

Nothing has changed on that server for a long time, except flushing the
cache periodically.  I rebooted the mid-tier server and everything
appears fine now.  Any idea as to how this may have occurred?

 

ARS server

ARS 6.3 p22

SQL Server 2000

Windows Server 2003

 

Mid Tier server

Mid Tier 6.3 p22

Windows Server 2003

IIS 6

New Atlanta ServletExec  5.0 (from the ARS 6.3 mid-tier installation
program)

 

Thanks.

 

Stephen 

Remedy Skilled Professional



 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Parenthesis

[Heider, Stephen]

Lisa,

Tip:

When I need to edit a qualification where ARS automatically (and not
wanted) adds a bunch of parenthesis, I copy/paste the entire
qualification into notepad and quickly perform a search & replace for )
and then for ( to remove all parenthesis.  Then I add back the few
parentheses that actually mean something and then copy/paste back into
the ARS object. 

If I know I will be working and testing the qualification for a while I
leave notepad open (with the qualification text). This way I can do all
my editing in notepad and not have to deal with ARS continually adding
its own parenthesis.

HTH  


Stephen
Remedy Skilled Professional

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa
Sent: Tuesday, February 05, 2008 1:54 PM
To: arslist@ARSLIST.ORG
Subject: Re: Parenthesis

This worked,

Thanks everyone!!

Lisa 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Axton
Sent: Tuesday, February 05, 2008 1:48 PM
To: arslist@ARSLIST.ORG
Subject: Re: Parenthesis

( 'Status' = "ACTIVE") AND ('tmp_SurveyDate' = $NULL$) AND ((( 'Q1' !=
$NULL$ ) AND ( 'Response 1' =  $NULL$ )) OR (( 'Q2' !=  $NULL$ ) AND (
'Response 2' =  $NULL$ )))

On Feb 5, 2008 1:43 PM, Kemes, Lisa <[EMAIL PROTECTED]>
wrote:
> **
>
>
> I'm having a heck of a time trying to get this Run If statement to
work:
>
> (( 'Status' = "ACTIVE") AND ('tmp_SurveyDate' = $NULL$) AND ( 'Q1' != 
> $NULL$ ) AND ( 'Response 1' =  $NULL$ )) OR (( 'Q2' !=  $NULL$ ) AND (

> 'Response 2' =  $NULL$ ))
>
> I want this filter to run if: (Q1 is not null and Response 1 is Null) 
> OR (Q2 is not Null or Response 2 is Null) but only if the Status is 
> Active and the tmp_SurveyDate is Null
>
> No matter where I put my parenthesis, Remedy keeps putting them where 
> it wants to and it's running my filter even though the tmp_SurveyDate 
> field NOT Null.
>
> Any ideas?
>
> Lisa Kemes
> AR System Developer
> Tyco Electronics
> 717-810-2408 tel
> 717-810-2124 fax
> [EMAIL PROTECTED] __Platinum Sponsor: www.rmsportal.com
> ARSlist: "Where the Answers Are" html___


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum
Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Newbie: form with links to frequently accessed forms

[Heider, Stephen]

Ravi,

Here is another approach, something I implemented here.  I have about 80 forms 
that I frequently need to open and search.  Using the Find option in the Object 
List (Ctrl+O, Find, , click Find) is not convenient to me.

I use a Table Field on a display-only/control panel form that points to a 
Regular form containing the names of forms I wish to open.  I use an active 
link that opens the form when I double-click a row in the Table field.

Regular form fields:
'Display Name' A friendly name for the form.
'Form Name' ARS form name, or URL.
'VUI Name' ARS VUI name.
'URL' Checkbox if the entry is a URL.   

The Table Field shows the 'Display Name' and 'Form Name' columns. The URL field 
is included but hidden. 

On double-click the active link opens the form, or if the 'URL' checkbox is 
checked then it opens the URL.

For opening ARS forms (not URLs) the Open Window command uses $SERVER$ for the 
Server Name field, $col Form Name$ for the Form Name field, and $col VUI Name$ 
for the Form View field.  The Window Type is set to Search and the Target 
Location is set to New.

For opening URLs, I use this Run Process command: 

rundll32 url.dll,FileProtocolHandler $col Form Name$

I only need this for Windows User Tool.  You could use the Run Process command 
"PERFORM-ACTION-OPEN-URL new" to open URLs in mid-tier.

Creating this only took about 30 minutes and I use it every single day for my 
administration.  Anytime I find myself opening a form that is not in this list 
of forms I just add a record to the Regular form field (described above) and 
from them on all I need to do is double-click in the Table field and it's 
opened for me.

To enhance this you could add a checkbox to open the form in New mode instead 
of Search mode.  I seldom need to open in New mode so when I need to, I first 
open in Search modem then select Edit > Copy to New.

Stephen
Remedy Skilled Professional






-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Ravi
Sent: Friday, February 08, 2008 7:40 AM
To: arslist@ARSLIST.ORG
Subject: Re: Newbie: form with links to frequently accessed forms

This is all I am looking for. Thank you. One more question about the 
active link. Can the active link take the name of the button as an 
argument. What I am saying is the following: if I have 5 buttons opening 
5 different forms, can I just have one active link taking the name of 
the button as an argument or do I have to create 5 active links?

Thanks
Ravi
MUNJAL, Jaya, IDC wrote:
> **
>
> Ravi
>
>  
>
> § Create a Display Only Form
>
> § Create 5 buttons (name them according to the form they open)
>
> § Create 5 Active Link with Open Window Action. In the open 
> Window specify which Form you want to open
>
>  
>
> For more details on the Open Window action of active link refer to 
> Basic User Guide.
>
>  
>
> Hope this helps.
>
>  
>
> Thanks
>
>  
>
>  
>
> Jaya Munjal
>
> IEA Remedy Team
>
> RBS India Development Centre (P) Ltd
>
>  
>
> T  +91 124 6724163
>
> M +91 9811405409
>
> [EMAIL PROTECTED]
>
> Unitech Business Park, Block F, Sector 41, South City 1,
>
> Gurgaon, Harayana India 122001
>
> P Please don't print this e-mail unless you really need to.
>
> www.rbs.com
>
>  
>
> Visit our Sharepoint site here
>
> Raise a fault with one of our systems here
>
>  
>
>  
>
>  
>
>  
>
> -Original Message-
> From: Action Request System discussion list(ARSList) 
> [mailto:[EMAIL PROTECTED] On Behalf Of Ravi
> Sent: 08 February 2008 08:52
> To: arslist@ARSLIST.ORG
> Subject: Newbie: form with links to frequently accessed forms
>
>  
>
> Hi: I typically access about 5 forms as a user from the remedy client.
>
> Can somebody point me to the right doc which explains how I can create a
>
> simple form with links to these forms in search or new mode? I have
>
> searched many docs and can't seem to find it.
>
>  
>
> TIA
>
> Ravi
>
>  
>
> ___
>
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>
> Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
>
> ***
> The Royal Bank of Scotland plc. Registered in Scotland No 90312. Registered 
> Office: 36 St Andrew Square, Edinburgh EH2 2YB. 
> Authorised and regulated by the Financial Services Authority 
>  
> This e-mail message is confidential and for use by the 
> addressee only. If the message is received by anyone other 
> than the addressee, please return the message to the sender 
> by replying to it and then delete the message from your 
> computer. Internet e-mails are not necessarily secure. The 
> Royal Bank of Scotland plc does not accept responsibility for 
> changes made to this message after it was sent. 
>
> Whilst all reasonable care has been taken to avoid the 
> t

Re: Escalations ARS 7.x

[Heider, Stephen]

On my wish list (for years), I want to be able to right-click any
escalation and select Run Now. Maybe in a later version of ARS.

 

You could create a separate regular form to hold your "escalations"
which has filters attached to it.  An escalation would then check this
small form every 1 minute to see if anything needs to be done. If so,
then the escalation would push a value to the Status field, which would
run the filters and update the schedule for the next run.

 

With your escalations in a separate form you could then test any
escalation by manually updating the Status field.

 

HTH

 

Stephen

Remedy Skilled Professional

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza
Sent: Friday, February 15, 2008 5:41 PM
To: arslist@ARSLIST.ORG
Subject: Re: Escalations ARS 7.x

 

If that's the case I do agree that sucks especially if you have the need
to run that one time escalation over lets say 500 K records.. It would
be harder to design one in a minutes interval. The workaround would be
to create a flag that the escalation would set after its run on a
record..

 

Joe

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of Russ Grant
Sent: Friday, February 15, 2008 5:10 PM
To: arslist@ARSLIST.ORG
Subject: Escalations ARS 7.x

** Apparently there is a change to the way Escalations execute
in ARS 7.x. In previous versions of ARS, going back MANY years, when you
created an escalation which runs on an interval - it would execute upon
saving it and then on the interval. In version 7.1 the escalation will
not execute immediately but will wait until the interval time to
execute. While I can appreciate that people might want to wait until the
interval time has expired before running the escalation I wish that
Remedy would have made it an option, I want it to run immediately so I
can test the results. I realize I can set a short interval, test the
results, then reset the interval but in many cases I only want to run
the escalation once to clean up data, in which case I would set the
interval to 99 days (just in case I get side tracked , I still have 99
days to turn off the escalation).

Russ

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: ARinside

[Heider, Stephen]

Have you tried here?

 

http://www.mattreinfeldt.com/site/component/option,com_docman/task,cat_v
iew/gid,35/Itemid,28/

 

Stephen

Remedy Skilled Professional

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Gayford, Matthew C.
Sent: Wednesday, February 20, 2008 12:34 PM
To: arslist@ARSLIST.ORG
Subject: Re: ARinside

 

The site used to be system.devdor.net but that link no longer works, it
just takes you to a domain parking page.

 

I've got the installer for 2.07.2 if that helps.

 

-Matt

Matthew C. Gayford
Technology Research & Development
Information Technology Systems Division
University of North Carolina Wilmington 
(910) 962-7177

 

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Toby White
Sent: Wednesday, February 20, 2008 12:10 PM
To: arslist@ARSLIST.ORG
Subject: ARinside

 

** What is the latest version of ARinside?
Where can I find it?

Thanks,
Toby.
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___ 

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Check within workflow for users licence type / state

[Heider, Stephen]

Albert,

If I understand your question, couldn't you do a regular Set Fields from
the User form with a Set Field If set to:

'Login Name' = $USER$ AND ('License Type' = "Fixed" OR 'License Type' =
"Floating")

Set the value of the Login Name field from the User form to a zTmp field
on your form.  The next filter or active link would check to see if the
zTmp field was $NULL $ or not.  If not, then the user has a license to
write.

Stephen
Remedy Skilled Professional


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Albert Bihler
Sent: Thursday, February 21, 2008 11:14 AM
To: arslist@ARSLIST.ORG
Subject: Check within workflow for users licence type / state

Hi list,

is there a way to check using workflow whether the user that
is running the workflow has currently a read, read (floting) or
write (floating) license?

Whenever a user leaves our main form we write some field
values to a user preferences form (on window close). This
works fine as long as the user has got a proper license. However
if the user only has a read token it fails with ARERR [8932]
"You do not have write license"

Possible solutions that are coming to my mind are:
- Do a direct sql instead of a push-field action. This is not nice
  because we are talking of about 50 fields and I think this could
  violate the license agreement.
- Push values to a new form and create always a new record there
  Then let an escalation push the values to the users properties
  form. Not nice because a lot of workflow and there is a time delay
  because of the escalation.
- check for the users license and only save the fields when he has
  a write token. Not nice either.

Any suggestions?

ARS 7.0.1
Solaris 10
Oracle 10gR2

Kind regards,
Albert


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: OT - Possible Friday Humor from BMC's Knowledgebase

[Heider, Stephen]

Does anyone know if ARS contains any Easter eggs?

 

Stephen

Remedy Skilled Professional

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Lammey, Peter A.
Sent: Friday, February 22, 2008 10:12 AM
To: arslist@ARSLIST.ORG
Subject: OT - Possible Friday Humor from BMC's Knowledgebase

 

I was out on BMC's Knowledge website looking up knowledge regarding
table fields and their retrieving values from the a Table field column
that is linked to a Selection field (or drop down field).

After the list of knowledge articles was returned I opened up one titled
"Can I query for the values in the column within a Table Field?".

This is knowledge article KM-3274.  When you read this article
the author wrote the Solution in a very funny manner.  It seems like
this person must have read too many Dr. Seuss books or something.

Take a look out on BMC's website at this Knowledge article where the
solution reads: 

"Query on Columns within a Table field". You can not do it in a box with
a fox, nor in a house with a mouse, or with a punk on a skunk. You can
not do it here or there you can not do it anywhere, you can not Query on
a Table you can not do it, you just arent able :)

Thanks 
Peter Lammey 
ESPN MIT Technical Services & Applications Management 
860-766-4761 

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Refresh Table - Maintain Sort

[Heider, Stephen]

ARS 6.3 p23 (server and user tool)

 

I have noticed an undesirable behavior with refreshing tables when using
the Run Process PERFORM-ACTION-TABLE-REFRESH command.  I hope there is a
work-around.  Here is the issue:

 

A user clicks on a table field column in order to sort by that column.
The user then clicks a Refresh button.

 

When workflow uses the Change Field - Refresh Table Field command the
table field remains sorted by the column the user had selected. 

 

When workflow uses the Run Process - PERFORM-ACTION-TABLE-REFRESH
command the sort order is reset to the default.  Which means the user
has to click the column again to sort by that column.  Is there any way
to stop ARS from resetting the default sort order for the table field?

 

BTW, I use the PERFORM-ACTION-TABLE-REFRESH command so that users can
determine how many rows to return.  For example, on one of my screens I
have a radio button that reads  "Show up to: o 100   o 250   o 500   o
750   o 1000" with 100 as the default.  For most searches 100 is enough,
yet users have the option to show more as needed.  The full Run Process
command is PERFORM-ACTION-TABLE-REFRESH 536870938 1 $zTmpInt1$.

 

TIA

 

Stephen 
Remedy Skilled Professional

 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Refresh Table - Maintain Sort

[Heider, Stephen]

Tony,

 

My understanding is that PERFORM-ACTION-TABLE-REFRESH is the only
command which allows you to specify the number of rows to return [from a
field].

 

With PERFORM-ACTION-ACTIVE-LINK, can you specify the number of rows to
return?  

 

Stephen

Remedy Skilled Professional

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Tony Worthington
Sent: Thursday, March 06, 2008 9:43 AM
To: arslist@ARSLIST.ORG
Subject: Re: Refresh Table - Maintain Sort

 

** 
Not a solution to the actual problem .. but a workaround might be to
push the refresh button in an a/l with "perform-action-active-link 1
" 


-- 
Tony Worthington
Sr. Technical Analyst
Kohl's Department Stores
[EMAIL PROTECTED]
262-703-5911 



"Heider, Stephen" <[EMAIL PROTECTED]> 
Sent by: "Action Request System discussion list(ARSList)"
 

03/06/2008 08:28 AM 

Please respond to
arslist@ARSLIST.ORG

To

arslist@ARSLIST.ORG 

cc

 

Subject

Refresh Table - Maintain Sort

 

 

 




** 
ARS 6.3 p23 (server and user tool) 
  
I have noticed an undesirable behavior with refreshing tables when using
the Run Process PERFORM-ACTION-TABLE-REFRESH command.  I hope there is a
work-around.  Here is the issue: 
  
A user clicks on a table field column in order to sort by that column.
The user then clicks a Refresh button. 
  
When workflow uses the Change Field - Refresh Table Field command the
table field remains sorted by the column the user had selected. 
  
When workflow uses the Run Process - PERFORM-ACTION-TABLE-REFRESH
command the sort order is reset to the default.  Which means the user
has to click the column again to sort by that column.  Is there any way
to stop ARS from resetting the default sort order for the table field? 
  
BTW, I use the PERFORM-ACTION-TABLE-REFRESH command so that users can
determine how many rows to return.  For example, on one of my screens I
have a radio button that reads  "Show up to: o 100   o 250   o 500   o
750   o 1000" with 100 as the default.  For most searches 100 is enough,
yet users have the option to show more as needed.  The full Run Process
command is PERFORM-ACTION-TABLE-REFRESH 536870938 1 $zTmpInt1$. 
  
TIA 
  
Stephen 
Remedy Skilled Professional 
  

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___ 

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Refresh Table - Maintain Sort

[Heider, Stephen]

Kalyan,

 

The default sort, as defined in the table properties, is fine. It's when
the user sorts it differently by clicking a column that I want to retain
after a table refresh.  

 

The Change Field works but does not allow you to specify the number of
rows to return.  The PERFORM-ACTION-TABLE-REFRESH does allow you to
specify the number of rows to return but resets the sort order to what
is defined in the table properties.  The goal is to prevent ARS from
resetting the sort during a table refresh with the
PERFORM-ACTION-TABLE-REFRESH command.

 

Stephen

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kalyan Krishna Nethy
Sent: Thursday, March 06, 2008 11:03 AM
To: arslist@ARSLIST.ORG
Subject: Re: Refresh Table - Maintain Sort

 

** 

Hi Stephen,

 

I think you can mention the the fields to sort with in the table
properties. I hope that will work.

 

Regards,

Kalyan.

On Thu, Mar 6, 2008 at 9:22 PM, Heider, Stephen <[EMAIL PROTECTED]>
wrote:

** 

Tony,

 

My understanding is that PERFORM-ACTION-TABLE-REFRESH is the only
command which allows you to specify the number of rows to return [from a
field].

 

With PERFORM-ACTION-ACTIVE-LINK, can you specify the number of rows to
return?  

 

Stephen

Remedy Skilled Professional

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Tony Worthington
Sent: Thursday, March 06, 2008 9:43 AM
To: arslist@ARSLIST.ORG
Subject: Re: Refresh Table - Maintain Sort

 

** 
Not a solution to the actual problem .. but a workaround might be to
push the refresh button in an a/l with "perform-action-active-link 1
" 


-- 
Tony Worthington
Sr. Technical Analyst
Kohl's Department Stores
[EMAIL PROTECTED]
262-703-5911 

"Heider, Stephen" <[EMAIL PROTECTED]> 
Sent by: "Action Request System discussion list(ARSList)"
 

03/06/2008 08:28 AM 

Please respond to
arslist@ARSLIST.ORG

To

arslist@ARSLIST.ORG 

cc

 

Subject

Refresh Table - Maintain Sort

 

 

 




** 
ARS 6.3 p23 (server and user tool) 
  
I have noticed an undesirable behavior with refreshing tables when using
the Run Process PERFORM-ACTION-TABLE-REFRESH command.  I hope there is a
work-around.  Here is the issue: 
  
A user clicks on a table field column in order to sort by that column.
The user then clicks a Refresh button. 
  
When workflow uses the Change Field - Refresh Table Field command the
table field remains sorted by the column the user had selected. 
  
When workflow uses the Run Process - PERFORM-ACTION-TABLE-REFRESH
command the sort order is reset to the default.  Which means the user
has to click the column again to sort by that column.  Is there any way
to stop ARS from resetting the default sort order for the table field? 
  
BTW, I use the PERFORM-ACTION-TABLE-REFRESH command so that users can
determine how many rows to return.  For example, on one of my screens I
have a radio button that reads  "Show up to: o 100   o 250   o 500   o
750   o 1000" with 100 as the default.  For most searches 100 is enough,
yet users have the option to show more as needed.  The full Run Process
command is PERFORM-ACTION-TABLE-REFRESH 536870938 1 $zTmpInt1$. 
  
TIA 
  
Stephen 
Remedy Skilled Professional 
  

__Platinum Sponsor: www.rmsportal.com <http://www.rmsportal.com/>
ARSlist: "Where the Answers Are" html___ 

__Platinum Sponsor: www.rmsportal.com <http://www.rmsportal.com/>
ARSlist: "Where the Answers Are" html___

__Platinum Sponsor: www.rmsportal.com <http://www.rmsportal.com/>
ARSlist: "Where the Answers Are" html___ 


__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___ 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Output of field contents to file via a filter action

[Heider, Stephen]

Mike,

 

Here is one option (there are probably many).

 

Since you are on Windows create a small .Net console app with the .Net
ARS API that retrieves the email contents by querying the form, then
creates a text file of the contents of the email, then attaches the file
to an Attachment Field in Remedy.

 

Your filters would first determine the length of the email, and then
only call the console app when it is greater than a certain number.
When you call the console app you would pass in the $1$ value so it
knows which record to work with.

 

 

Afterwards, if you wanted to take this concept further you could design
the console app to work with any form, and field, and any attachment
field.  You could then use this with other forms.

 

Stephen

Remedy Skilled Professional

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Mike Balogh
Sent: Thursday, March 06, 2008 3:28 PM
To: arslist@ARSLIST.ORG
Subject: Output of field contents to file via a filter action

 

Hi everyone -

 

I'm attempting to output the contents of a large character field to a
file via a filter action.  I must use a filter because this process will
be used for processing emails coming in to our server.  Above a certain
size I want to output the email body to a file and then attach that file
to a Helpdesk ticket.  I've tried using the following via as a Run
Process command:

 

%ComSpec% /C Echo $FieldValue$ >> c:\file.txt

 

This works great until the field has a carriage return in the value.
Once a carriage return is introduced into the field, the process fails
completely and the file is not created at all.  Unfortunately, virtually
every time we use this process, the field value is going to have
potentially thousands of carriage returns in it.  I've tried various
combinations with the /A and /S switches as well as putting
double-quotes around the $FieldValue$.  Anyone have any other
suggestions or a completely different way I could try to do this?

 

Windows Server 2003 Enterprise

MS SQL 2005

ARS 7.0.01 p2

 

Thanks in advance!

~Mike

 

---

Michael J Balogh

Wingspan Systems Inc.

[EMAIL PROTECTED]  

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: LDAP arplugin failure problem

[Heider, Stephen]

Maria,

 

Another option to get around the LDAP query limitation is to create a
single SQL View comprised of multiple SELECTs that are UNIONed together.
You can then query this view and retrieve all LDAP entries.

 

See the email from January 9 entitled "Re: LDAP Question".  There is a
script attached that can be used to create the SQL View.

 

Stephen

Remedy Skilled Professional

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Thomas Bean
Sent: Thursday, March 06, 2008 7:20 PM
To: arslist@ARSLIST.ORG
Subject: Re: LDAP arplugin failure problem

 

Hi Maria,

I would guess that your LDAP server has an entry count limit on the
number of records that can be returned by a search.  This is fairly
common -- usually LDAP servers are set to an entry count limit of 1 or 2
thousand records.  If the LDAP admin is unwilling or unable to alter
this setting, you might try breaking it up into multiple escalations
that search for the users in manageable chunks (e.g., all users with
user names starting with "A", then "B", then "C", etc.).  Each letter of
the alphabet would have to return fewer entries than the LDAP entry
count limit, of course.  That would a whopping 26 escalations instead of
one, but it might work, depending upon how many users you have in LDAP.

 

If you can go another route, I have found that it is much easier to set
up this kind of import using a view form to an external database rather
than an vendor form using the ARDBC LDAP plugin.

 

--Thomas

 

- Original Message - 

From: Maria C Delagarza
  

Newsgroups: gmane.comp.crm.arsystem.general

To: arslist@ARSLIST.ORG 

Sent: Thursday, March 06, 2008 1:07 PM

Subject: LDAP arplugin failure problem

 

** 

Hi Listers,

 

I am appealing to people smarter than myself.  I currently am
having an issue with an LDAP import.  Here is the scenario:

 

We are connected to the LDAP and can run queries on the Vendor
Form that return the record we want to see.  However, when we run the
same query through a filter escalation the arplugin fails and does not
give an error messageit fails around 50K records or so.  Any
thoughts?

 

We are running ARS 7.1 Patch 006

MS SQL 2005

Windows Server 2003

 

Any help is much appreciated, we are trying to get to a pilot on
Monday and this problem is preventing our CTM:People population.

 

 

Thanks.

 

MCD

Maria C Delagarza

AR System Specialist

Eluri Designs

eluridesign.com

[EMAIL PROTECTED]

 

 

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the
Answers Are" html___ 

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Output of field contents to file via a filter action

[Heider, Stephen]

Fred,

 

That's cool.  I did not know that about that part of the Notify command.
For reference, in ARS 6.3, the BasicGuide-630.pdf describes it on page
524.

 

In my testing this morning I am not sure if I can use it here.  I see
three challenges to overcome:

 

1.  The first 8 lines and the last 3 need to be removed from the
file. This is extra text inserted by the Notify command.

a.  The application or process that ultimately receives the
file will need to remove these extra lines.

 

2.  Each time the Notify command is run it appends to the existing
file.

a.  After each run the file needs to be deleted or renamed.

 

3.  The filename is not unique.  For example, "notify4.arn".  This
prevents multiple simultaneous users from running this command.  Even
though you can have up to 80 different file names (notify4.arn through
notify83.arn) there is no guarantee that two users will not run the
process that creates these files at the same time.

a.  An indirect work-around is to create a queue for these
command whereby only one command is run at one time.

 

Since this a new command for me, are there any work-arounds for these
items?  Items 2 and 3 could have been dealt with if ARS allowed for
custom (unique) filenames.

 

 

Stephen

Remedy Skilled Professional

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W
Sent: Thursday, March 06, 2008 9:28 PM
To: arslist@ARSLIST.ORG
Subject: Re: Output of field contents to file via a filter action

 

An easier way to do it would be to use the Notify action.  Change the
Mechanism field to Other and put a number (4 and above) in the Other
Code.  This will create a file on your server.  The Other mechanism is
documented in the Workflow Objects manual (pg 76 for 7.0.x)

 

Fred  

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen
Sent: Thursday, March 06, 2008 2:52 PM
To: arslist@ARSLIST.ORG
Subject: Re: Output of field contents to file via a filter action

Mike,

 

Here is one option (there are probably many).

 

Since you are on Windows create a small .Net console app with the .Net
ARS API that retrieves the email contents by querying the form, then
creates a text file of the contents of the email, then attaches the file
to an Attachment Field in Remedy.

 

Your filters would first determine the length of the email, and then
only call the console app when it is greater than a certain number.
When you call the console app you would pass in the $1$ value so it
knows which record to work with.

 

 

Afterwards, if you wanted to take this concept further you could design
the console app to work with any form, and field, and any attachment
field.  You could then use this with other forms.

 

Stephen

Remedy Skilled Professional

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Mike Balogh
Sent: Thursday, March 06, 2008 3:28 PM
To: arslist@ARSLIST.ORG
Subject: Output of field contents to file via a filter action

 

Hi everyone -

 

I'm attempting to output the contents of a large character field to a
file via a filter action.  I must use a filter because this process will
be used for processing emails coming in to our server.  Above a certain
size I want to output the email body to a file and then attach that file
to a Helpdesk ticket.  I've tried using the following via as a Run
Process command:

 

%ComSpec% /C Echo $FieldValue$ >> c:\file.txt

 

This works great until the field has a carriage return in the value.
Once a carriage return is introduced into the field, the process fails
completely and the file is not created at all.  Unfortunately, virtually
every time we use this process, the field value is going to have
potentially thousands of carriage returns in it.  I've tried various
combinations with the /A and /S switches as well as putting
double-quotes around the $FieldValue$.  Anyone have any other
suggestions or a completely different way I could try to do this?

 

Windows Server 2003 Enterprise

MS SQL 2005

ARS 7.0.01 p2

 

Thanks in advance!

~Mike

 

---

Michael J Balogh

Wingspan Systems Inc.

[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> 

 

 

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Output of field contents to file via a filter action

[Heider, Stephen]

Carey,

Precisely. Thanks for the confirmation.

I don't think I can make use of this command for the purpose of creating
a file from the contents of an ARS field.

Stephen
Remedy Skilled Professional

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black
Sent: Friday, March 07, 2008 8:42 AM
To: arslist@ARSLIST.ORG
Subject: Re: Output of field contents to file via a filter action

Stephen,

I am certain that the design intent was that there would be a process
that parses the file and does the right thing with what it finds in
the file. So #2 and #3 are totally by design. Also the process was
envisioned as a standing "server" process and not something that is
invoked over and over again. But I guess you could do that too. You
just have to manage the "high water mark" for the entries that you
have already processed between invocations.

If you need to pass data to the process that is monitoring the file
then the value needs to be a field that is written to the entry in the
file. The process parses the entry and does what it needs to do from
there.


If my vague memory is correct, I would be careful about
altering/renaming/moving the file while the ARS server is running. You
may find that multiple users are writing to the file and that there
are some "bad times" to alter the file. Also the ARS server may be
confused by the files length changing or disappearing out from
underneath it too. ( I seem to remember issues like that from when I
played with this many years ago. But my memory might be poor about the
details from that long ago. Do some testing at least.)

The thing that I do not like about the approach is that it builds in a
queue. (and thus a likely delay in the process) If what you need is
"in line processing" then look toward the Filter Plugin. If the queue
effect it desired and/or helpful then the Notify-Other model may work
well for you too.

HTH.

-- 
Carey Matthew Black
Remedy Skilled Professional (RSP)
ARS = Action Request System(Remedy)

Love, then teach
Solution = People + Process + Tools
Fast, Accurate, Cheap Pick two.


On Fri, Mar 7, 2008 at 7:53 AM, Heider, Stephen <[EMAIL PROTECTED]>
wrote:
> **
>
>
>
> Fred,
>
>
>
> That's cool.  I did not know that about that part of the Notify
command.
> For reference, in ARS 6.3, the BasicGuide-630.pdf describes it on page
524.
>
>
>
> In my testing this morning I am not sure if I can use it here.  I see
three
> challenges to overcome:
>
>
>
> The first 8 lines and the last 3 need to be removed from the file.
This is
> extra text inserted by the Notify command.
>
> The application or process that ultimately receives the file will need
to
> remove these extra lines.
>
>
>
> Each time the Notify command is run it appends to the existing file.
>
> After each run the file needs to be deleted or renamed.
>
>
>
> The filename is not unique.  For example, "notify4.arn".  This
prevents
> multiple simultaneous users from running this command.  Even though
you can
> have up to 80 different file names (notify4.arn through notify83.arn)
there
> is no guarantee that two users will not run the process that creates
these
> files at the same time.
>
> An indirect work-around is to create a queue for these command whereby
only
> one command is run at one time.
>
>
>
> Since this a new command for me, are there any work-arounds for these
items?
> Items 2 and 3 could have been dealt with if ARS allowed for custom
(unique)
> filenames.
>
>
> Stephen
> Remedy Skilled Professional


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: White Space

[Heider, Stephen]

If I could add to this...   Add another REPLACE() that surrounds the one
below that changes ";;" into ";".  This is just in case there already
are some semi-colons in the list of email addresses.

 

Stephen

Remedy Skilled Professional

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Ron Tavares
Sent: Monday, March 10, 2008 3:48 PM
To: arslist@ARSLIST.ORG
Subject: Re: White Space

 

** 

Just before the Notify action to send the e-mail, do a 'Set Field'
action:

REPLACE ($$, " ", ";"). 

I blieve this will do the trick.
 

On 3/10/08, Brittain, Mark <[EMAIL PROTECTED]> wrote: 

** 

HI All, 

I am having a challenge with white space in emails. If a use selects
multiple email addresses from a menu, there is a white space. Of course
this barfs when the email goes out.

Is there a way to replace the white space on submit with a semi-colon. 

Thanks 
Mark 

Mark Brittain 
ESM Remedy Developer 
NaviSite Inc. 
315-453-2912 x5418  (office) 
315-317-2897 (cell) 


This e-mail is the property of NaviSite, Inc. It is intended only for
the person or entity to which it is addressed and may contain
information that is privileged, confidential, or otherwise protected
from disclosure. Distribution or copying of this e-mail, or the
information contained herein, to anyone other than the intended
recipient is prohibited.
 

__Platinum Sponsor: www.rmsportal.com 
ARSlist: "Where the Answers Are" html___


__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___ 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Phone number formatting...

[Heider, Stephen]

Joe,

 

Here is a SQL Server function that can be used to format your phone
numbers.  It works with US 7 and 10 digit phone numbers and 10 digit
phone numbers with extensions.   I like using a function because you can
call it with one line of code in ARS workflow, or from a SQL-based
database (ARS or non-ARS), and also from a SQL prompt.  HTH

 

CREATE FUNCTION dbo.udf_FormatPhoneNumber

(

   @Phone VARCHAR(100)

)

RETURNS VARCHAR(30)

AS

BEGIN

   IF ISNULL(@Phone ,'') = ''

  RETURN NULL

 

   DECLARE   @tmpPhone VARCHAR(30),

 @ReturnValue VARCHAR(30),

 @Pos INT,

 @Character VARCHAR(1),

 @Ext VARCHAR(10)

 

   -- Remove any existing formatting.

   SET @tmpPhone = REPLACE(REPLACE(REPLACE(REPLACE(ISNULL(@Phone,
''), '(', '') , ')', ''), '-', ''), ' ', '')

   

   set @ReturnValue = ''

   SET @Pos = 1

 

   -- Build string of only numbers.

   WHILE @Pos <= LEN(@tmpPhone)

   BEGIN

  SET @Character = SUBSTRING(@tmpPhone, @Pos, 1)

  IF @Character BETWEEN '0' AND '9' 

 SET @ReturnValue = @ReturnValue + @Character

 

  SET @Pos = @Pos + 1

   END

 

   IF @ReturnValue = ''

  RETURN NULL

 

   IF LEN(@ReturnValue) > 10

  SET @Ext = ' x' + SUBSTRING(@ReturnValue, 11, 10)

   ELSE

  SET @Ext = ''

 

   IF LEN(@ReturnValue) >= 10

  SET @ReturnValue = RTRIM('(' + LEFT(@ReturnValue, 3) + ')
' + 

  SUBSTRING(@ReturnValue, 4, 3) + '-' + 

  SUBSTRING(@ReturnValue, 7, 4) + ' ' +

  @Ext)

   ELSE

  SET @ReturnValue = RTRIM(LEFT(@ReturnValue, 3) + '-' + 

  SUBSTRING(@ReturnValue, 4, 4) +

  @Ext)

  

   RETURN @ReturnValue

END

 

Stephen

Remedy Skilled Professional

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza
Sent: Wednesday, March 12, 2008 10:20 PM
To: arslist@ARSLIST.ORG
Subject: Phone number formatting...



Joe D'Souza

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

FW: Moving records to the top based on a condition

[Heider, Stephen]

Rashmi,

 

Here is one way it can be done, however it might not be useful due to
performance.  I present this to spark ideas...

 

Overview: Using SQL, create a SQL View that includes a calculated
column. This column would contain the sort order based on whatever
criteria you require.  Then create an ARS View form on top of this SQL
View.  Your table field would reference this calculated column to sort
the records on screen. 

 

Here is the SQL View:

 

CREATE VIEW dbo.uvw_MySQLViewForARS

AS

SELECT Summary, Last_Modified_Date, Priority, State, dbo.udf_SortOrder
AS SortOrder

FROM dbo.SHR_ConsolidatedList

 

Here is the function:

 

CREATE FUNCTION dbo.udf_SortOrder

(

   @Last_Modified_Date INT,

   @Priority INT,

   @State INT

)

RETURNS VARCHAR(20)

BEGIN

   DECLARE @SortOrder VARCHAR(20)

   SET @SortOrder = CONVERT(VARCHAR,@Last_Modified_Date) + '|' +
CONVERT(VARCHAR,@Priority) + '|' + CONVERT(VARCHAR,@State)

 

   IF @State = 0 AND @Priority = 1 AND (SELECT * FROM
dbo.uvw_CurrentRemedyTime) > (@Last_Modified_Date + (45 * 60))

  RETURN '0|' + @SortOrder

 

   RETURN '1|' + @SortOrder

END

 

Add whatever other parameters to the function you may need for sorting.
For criteria that matches your condition prefix a number.  In this
example there is only one condition, so I am using only a 0 and a 1 to
provide the proper sorting. If you had 5 conditions then you would use
numbers 0-5 (or 1-6, or 100 - 105, etc.).

 

Here is the SQL View that the function needs to get the current
date/time in Remedy time.  *With SQL Server you can't use a
non-deterministic value (such as GETDATE()) directly, so you have to use
a View to return the value.

 

CREATE VIEW [dbo].[uvw_CurrentRemedyTime]

AS

  SELECT DATEDIFF(s, '01/01/1970', GETDATE()) CurrentRemedyTime

 

HTH

 

Stephen

Remedy Skilled Professional

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Rashmi Amruth
Sent: Monday, March 24, 2008 1:09 AM
To: arslist@ARSLIST.ORG
Subject: Re: Moving records to the top based on a condition

 

** 

Hi Joe,

 

The table records are being retrieved from a view form. But this view
form already has sort criteria set for existing records. Now, I need to
sort only a subset of these records for the criteria which I have
defined.

 

Thanks,

Rashmi




___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Moving records to the top based on a condition

[Heider, Stephen]

...use this Select instead

 

SELECT Summary, Last_Modified_Date, Priority, State,
dbo.udf_SortOrder(Last_Modified_Date, Priority, State) AS SortOrder

 

As someone once wrote:   If cups_of_coffee < 2 Then refill

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen
Sent: Monday, March 24, 2008 9:13 AM
To: arslist@ARSLIST.ORG
Subject: FW: Moving records to the top based on a condition

 

Rashmi,

 

Here is one way it can be done, however it might not be useful due to
performance.  I present this to spark ideas...

 

Overview: Using SQL, create a SQL View that includes a calculated
column. This column would contain the sort order based on whatever
criteria you require.  Then create an ARS View form on top of this SQL
View.  Your table field would reference this calculated column to sort
the records on screen. 

 

Here is the SQL View:

 

CREATE VIEW dbo.uvw_MySQLViewForARS

AS

SELECT Summary, Last_Modified_Date, Priority, State, dbo.udf_SortOrder
AS SortOrder

FROM dbo.SHR_ConsolidatedList

 

Here is the function:

 

CREATE FUNCTION dbo.udf_SortOrder

(

   @Last_Modified_Date INT,

   @Priority INT,

   @State INT

)

RETURNS VARCHAR(20)

BEGIN

   DECLARE @SortOrder VARCHAR(20)

   SET @SortOrder = CONVERT(VARCHAR,@Last_Modified_Date) + '|' +
CONVERT(VARCHAR,@Priority) + '|' + CONVERT(VARCHAR,@State)

 

   IF @State = 0 AND @Priority = 1 AND (SELECT * FROM
dbo.uvw_CurrentRemedyTime) > (@Last_Modified_Date + (45 * 60))

  RETURN '0|' + @SortOrder

 

   RETURN '1|' + @SortOrder

END

 

Add whatever other parameters to the function you may need for sorting.
For criteria that matches your condition prefix a number.  In this
example there is only one condition, so I am using only a 0 and a 1 to
provide the proper sorting. If you had 5 conditions then you would use
numbers 0-5 (or 1-6, or 100 - 105, etc.).

 

Here is the SQL View that the function needs to get the current
date/time in Remedy time.  *With SQL Server you can't use a
non-deterministic value (such as GETDATE()) directly, so you have to use
a View to return the value.

 

CREATE VIEW [dbo].[uvw_CurrentRemedyTime]

AS

  SELECT DATEDIFF(s, '01/01/1970', GETDATE()) CurrentRemedyTime

 

HTH

 

Stephen

Remedy Skilled Professional

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Rashmi Amruth
Sent: Monday, March 24, 2008 1:09 AM
To: arslist@ARSLIST.ORG
Subject: Re: Moving records to the top based on a condition

 

** 

Hi Joe,

 

The table records are being retrieved from a view form. But this view
form already has sort criteria set for existing records. Now, I need to
sort only a subset of these records for the criteria which I have
defined.

 

Thanks,

Rashmi

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Change Database Entry Mode - Optional to Display Only

[Heider, Stephen]

One way is to copy the field Id to your buffer. Delete the field and
save the form. Then immediately create a new display-only field with the
same name and Paste the field Id. Then save the form. 

That should work...just make sure that no-one is using that form when
you make the change.

If the field is a drop-down menu or radio button and you don't want to
re-enter each individual value, copy the field itself and paste it into
a new temporary form.  This should also preserve the field Id.  Delete
the field from the original form, save, then Paste the field into the
original form, change the field type to display-only and save.

Stephen
Remedy Skilled Professional

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of T. Dee
Sent: Monday, March 24, 2008 11:22 AM
To: arslist@ARSLIST.ORG
Subject: OT: Change Database Entry Mode - Optional to Display Only

Are there any utilities that would allow me to change a database field
from Optional to Display Only?

ARS 7.0.01 (patch 002)

Thanks!


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Form Aliases (UNCLASSIFIED)

[Heider, Stephen]

Gordon,

There is a message entitled "Delete Records of Alert Events" from Jan 10
with a SQL script attached that lists all the ARS forms with their
corresponding DB table names.  Is this what you are looking for?

Stephen
Remedy Skilled Professional

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of FRANK, GORDON CTR DISA JSSC
Sent: Tuesday, March 25, 2008 8:05 AM
To: arslist@ARSLIST.ORG
Subject: Form Aliases (UNCLASSIFIED)

Classification:  UNCLASSIFIED 
Caveats: NONE

Does anyone know what DB table the form "aliases and labels" are held
in?

I had thought it was arschema, but they don't appear to be there.

Gordon M. Frank
Remedy Skilled Professional
ITIL V3 Certified
DISA\Verizon FNS
Office phone: 703-614-6130
Office email: [EMAIL PROTECTED]
Classification:  UNCLASSIFIED 
Caveats: NONE


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: ARS6.3 + SQL Question (UNCLASSIFIED)

[Heider, Stephen]

Charlie,

Use an OPENQUERY in a local SQL View that points to the remote server.

CREATE VIEW dbo.uvw_MyRemoteView
AS
SELECT * FROM OPENQUERY(SERVERNAME, 'SELECT FirstName, LastName FROM
SERVERNAME.phonebook.dbo.vw_tbl_ARS')


Then in your workflow: 

SELECT FirstName, LastName FROM uvw_MyRemoteView WHERE LastName LIKE
'%$Submitter$%'


Stephen
Remedy Skilled Professional

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Bennett, Charlie CTR MDA/DOCC
Sent: Thursday, March 27, 2008 8:52 AM
To: arslist@ARSLIST.ORG
Subject: ARS6.3 + SQL Question (UNCLASSIFIED)

Classification:  UNCLASSIFIED 
Caveats: NONE

Hi All!

I'm having a small problem getting my Remedy 6.3 app to talk to a remote
MSSQL Server 2K SP3 database running on a Win2k3, SP2 machine.  My AR
server
is running on a Win2k SP4 machine, with the AR System database running
on a
MSSQL Server 2K SP4 database on the same machine.

I've created an active link to grab some user information stored in the
remote server upon Return/Table or Level Dbl-Clk in a Set Field (SQL)
action
- it's supposed to go out, query based on the name entered into a
submitter
field and find possible matches and populate related user info fields,
or
display a select list if multiple matches come back.  Here's a chopped
down
and simplified version of the query I'm working with (I've simplified it
as
much as possible, but to no avail):

SELECT FirstName, LastName FROM SERVERNAME.phonebook.dbo.vw_tbl_ARS TARS
WHERE TARS.LastName LIKE '%$Submitter$%'

I've verified that I've got DTC running on both machines.  I've set the
remote server up as a linked server, with it set to impersonate with a
specific security context.  I've verified this is working because I can
see
the views/tables under the linked server in EntpMgr.  I am able to run
the
above query from my active link in QryAlzr just fine.  However, when I
go in
through the user tool and enter a name into the submitter field and fire
the
active link, I get this error:


"ARERR [552] Failure during SQL operation to the database : The ROLLBACK
TRANSACTION request has no corresponding BEGIN TRANSACTION. (SQL Server
3903)
The preceding message occurred during the execution of active link
+NTFAR:050-Set Submitter Info - TEST -- action 1. (ARNOTE 1101)"


I'm at the end of my rope here.  Hopefully someone has seen this before
and
knows what's up.  Perhaps I'm overlooking something embarassingly silly
here?  - I hope so!

Thanks in advance!!


Charlie Bennett
Remedy Developer
Missile Defense Integration & Operations Center
Schriever AFB
Colorado Springs, CO
(719) 721-7470 

Classification:  UNCLASSIFIED 
Caveats: NONE



___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

FW: How to know when a table is full ??

[Heider, Stephen]

Tadeu,

 

If you are using a version of SQL Server you could use the attached
script to create a SQL View, then create an ARS View form for the SQL
View.  Here is how my screen looks:

 

 

 

HTH

 

Stephen

Remedy Skilled Professional

 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Tadeu Augusto Dutra Pinto
Sent: Monday, April 07, 2008 10:34 AM
To: arslist@ARSLIST.ORG
Subject: RES: How to know when a table is full ??

 

Hi John,

 

Thanks for your reply...

 

But I would like to create this in a AR Sytem Form... (like Alert
Events, AR System Email Messages)

 

Could I create new Fields in these kind of forms without any worry about
modify AR System Forms???

 

 

Att,

 

Tadeu Augusto Dutra Pinto


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
<>CREATE VIEW dbo.udv_ARS_FormRowCounts
AS

SELECT  a.schemaId, b.Name FormName, CONVERT(VARCHAR,a.TableName) TableName, 
a.TotalRows, CHECKSUM(a.TableName) RequestID 
FROM(SELECT so.Name TableName, MAX(si.rows) TotalRows,
CASE ISNUMERIC(SUBSTRING(so.Name, 2, 99)) 
WHEN 1 THEN SUBSTRING(so.Name, 2, 99) 
ELSE 
CASE ISNUMERIC(SUBSTRING(so.Name, 3, 
1)) 
WHEN 0 THEN SUBSTRING(so.Name, 2, 1) 
ELSE 
CASE 
ISNUMERIC(SUBSTRING(so.Name, 4, 1)) 
WHEN 0 THEN SUBSTRING(so.Name, 
2, 2) 
ELSE 
CASE 
ISNUMERIC(SUBSTRING(so.Name, 5, 1)) 
WHEN 0 THEN 
SUBSTRING(so.Name, 2, 3) 
ELSE 
CASE 
ISNUMERIC(SUBSTRING(so.Name, 6, 1)) 
WHEN 0 THEN 
SUBSTRING(so.Name, 2, 4) 
ELSE 
CASE 
ISNUMERIC(SUBSTRING(so.Name, 7, 1)) 
WHEN 0 
THEN SUBSTRING(so.Name, 2, 5) 
ELSE 

CASE ISNUMERIC(SUBSTRING(so.Name, 8, 1)) 

WHEN 0 THEN SUBSTRING(so.Name, 2, 6) 

END
END
END
END
END
END
END schemaId
FROMsysobjects so
JOINsysindexes si
ON  si.id = OBJECT_ID(so.name)
WHERE   so.xtype = 'U'
AND LEFT(so.Name,1) IN ('T','B','H')
AND ISNUMERIC(SUBSTRING(so.Name,2,1)) = 1
GROUP BY so.Name) a
JOINarSchema b
ON  a.schemaId = b.schemaId

Re: How to know when a table is full ??

[Heider, Stephen]

Tadeu,

 

 This is the column in the view named RequestID.  It is a unique value
generated from the CHECKSUM() function.  It doesn't matter too much how
you get this number as long as it's different for each record.  In this
case I just used a built-in SQL command.

 

In the Remedy Administrator tool:

 

1.   Select File > New Server Object

2.   Select View Form and click OK

3.   Enter in the name of the SQL View in the first field:
ARSystem.dbo.udv_ARS_FormRowCounts and click Load

4.   Click Add All to move all the column names you see in the left
pane over to the right pane

5.   In the drop-down menu select the RequestID column

6.   Click create, then save the form.

 

Login to the Remedy User Tool to see and browse the new form. If you
were already logged in then re-login to the User Tool.

 

With most View forms (and this one in particular) take care not to add,
delete, or change any data or records. One way is to add a Filter to the
new ARS View form that Executes On Submit, Modify, Delete, Merge. It has
one Message commend of type Error.  

 

Note: As you already know if you are using ARS in Demo mode then there
is a maximum of 2000 records per form.  If you have more than 2000 ARS
tables then you will receive an error message when you try to browse
this ARS View form.  If so, then just view the SQL View outside of ARS
(ie. SQL Query Analyzer). 

 

Stephen

Remedy Skilled Professional

 

 

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza
Sent: Friday, April 18, 2008 2:05 PM
To: arslist@ARSLIST.ORG
Subject: Re: How to know when a table is full ??

 

** 

Create a view form, but that view must have at least one eligible field
that would meet the following criteria..

1) The field must be Non-NULL

2) It must be anywhere between 5 to 15 characters

3) Data in this field must be unique

 

Joe

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of tricky maybe
Sent: Friday, April 18, 2008 1:53 PM
To: arslist@ARSLIST.ORG
Subject: Re: How to know when a table is full ??

** 

Once I run the script it created that view on the SQL side now
how do you create an ARS view form from this?  Or how can I make that
show up on the Remedy side like the admin tool or user tool?

 

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen
Sent: Friday, April 18, 2008 10:39 AM
To: arslist@ARSLIST.ORG
Subject: FW: How to know when a table is full ??

 

** 

Tadeu,

 

If you are using a version of SQL Server you could use the
attached script to create a SQL View, then create an ARS View form for
the SQL View.  Here is how my screen looks:

 



 

HTH

 

Stephen

Remedy Skilled Professional

 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Tadeu Augusto Dutra Pinto
Sent: Monday, April 07, 2008 10:34 AM
To: arslist@ARSLIST.ORG
Subject: RES: How to know when a table is full ??

 

Hi John,

 

Thanks for your reply...

 

But I would like to create this in a AR Sytem Form... (like
Alert Events, AR System Email Messages)

 

Could I create new Fields in these kind of forms without any
worry about modify AR System Forms???

 

 

Att,

 

Tadeu Augusto Dutra Pinto

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___ 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: .NET Fast-Export BMC-Remedy Export Utility

[Heider, Stephen]

Did anyone receive the full attachment?  I did not.  

 

If it is greater than 5MB our email system will remove it.

 

Stephen

 

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Brian Goralczyk
Sent: Sunday, April 20, 2008 10:12 PM
To: arslist@ARSLIST.ORG
Subject: Re: .NET Fast-Export BMC-Remedy Export Utility

 

** Upon review, I have the same attachment.  

On Sun, Apr 20, 2008 at 7:45 PM, Axton <[EMAIL PROTECTED]> wrote:

I see the attachment in the email, but it is 1k and has the following
contents:

This attachment was removed.

Are you able to open the attachment?

Axton Grams

On Sun, Apr 20, 2008 at 4:40 PM, Brian Goralczyk <[EMAIL PROTECTED]>
wrote:
> ** I got the attachment.  I am using gmail.

>
>
>
> On Sun, Apr 20, 2008 at 9:32 AM, Axton <[EMAIL PROTECTED]> wrote:
> >
> >
> >
> > fyi, gmail, or someone in the middle, removed the attachment.
> >
> > Axton Grams
> >
> >
> >
> >
> > On Sun, Apr 20, 2008 at 3:21 AM, Ali Musa <[EMAIL PROTECTED]> wrote:
> > > **
> > >
> > >
> > >
> > > Hi all:
> > >
> > > Please find attached the latest version of .NET fast-Export
utility,
> since I
> > > was not able to upload it on BMC community-site.
> > >
> > > Fast Export .NET is a migration utility tools that copy a data of
a
> schema
> > > from server to server for an identical schema (schema-to-schema)
or as a
> > > normal export utility (schema-to-file) send output to  (.arx) file
that
> can
> > > be imported by Remedy Import.  Able to migrate data generated in
AR3-7
> and
> > > was developed using features of both API 4.5.2 and API 5.1.2
libraries.
> and
> > > latest version of C# a .NET programming language for Window and
WEB.
> > >
> > > Please not that in the documentation page there is no html all I c
> hanged to
> > > .exe fro security, the only html page is README.htm that instruct
you
> how to
> > > use the page.
> > >
> > > I would like to thank you all in anticipation and the arslist
management
> for
> > > overing me this chance to present my product and I look forward to
> hearing
> > > your feed-back and comments.
> > >
> > > Ali.
> > >
> > >   - Disclaimer: The
information
> in
> > > this email and in any files transmitted with it, is intended only
for
> the
> > > addressee and may contain confidential and/or privileged material.
> Access to
> > > this email by anyone else is unauthorized. If you receive this in
error,
> > > please contact the sender immediately and delete the material from
any
> > > computer. If you are not the intended recipient, any disclosure,
> copying,
> > > distribution or any action taken or omitted to be taken in
reliance on
> it,
> > > is strictly prohibited. Statement and opinions expressed in this
e-mail
> are
> > > those of the sender, and do not necessarily reflect those of STC.
> __Platinum
> > > Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___
> >
> >
>

___
> > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> >
> >
> >
> >
> > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
> >
>
>
>  __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers
Are"
> html___


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"


__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___ 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: History of AR System

[Heider, Stephen]

Hey Tim,  same here.   Remember that I took over for you in '99. :)

Stephen
Remedy Skilled Professional

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Timothy Powell
Sent: Monday, July 06, 2009 8:51 AM
To: arslist@ARSLIST.ORG
Subject: Re: History of AR System

**
I got tossed in to it in June 1997 at GTE in Tampa, FL. We were on V3.0.
I was handed a manual and told to go forth and build applications. I didn't 
step foot in any Remedy class until Sept 1998 when I took the Admin class.
Tim

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org]
Sent: Monday, June 29, 2009 3:18 PM
To: arslist@ARSLIST.ORG
Subject: Re: History of AR System

**
Back in 97, I sat down with the Remedy manual, read it cover to cover and was a 
Remedy administrator.  There were only two apps (I think); Helpdesk and Asset.  
Today, I looking at all the manuals if you have the whole ITSM suite, I no 
longer think that's possible.  I'm curious, how many folks started Remedy by 
just reading the docs, or did most people go out and get formal training.

Ben Cantatore
Remedy Manager
(914) 457-6209

Emerging Health IT
3 Odell Plaza
Yonkers, New York 10701


>>> robert.w.r...@gmail.com 06/29/09 10:56 AM >>>
** I began working with the point release of 2.1 late in 1994 or early 1995 
when I was at Winstar, a gone-broke telecommunications company. I wrote the 
help-desk app for the network ops center, as well as configuration forms, 
certification forms, lots of stuff. Back then it was a good front-end for a 
database. We worked with voice communications, so the FCC required a lot of 
auditing, all of which had to be written.

I got into Remedy as a C programmer who didn't have a project at the moment. I 
was horrified to find no Else statements built into the system. I can't 
remember when that came along, but it was quite an advance in programming. We 
worked with HP-UX and an early version of Oracle. Installation of just about 
anything was a bear, but once all the ducks were lined up it went well.

Ever since then I've worked with the ARS. Now it's quite sophisticated in 
comparison with the old days.

On Sun, Jun 28, 2009 at 4:39 PM, Daniel Bloom 
mailto:danielbl...@rogers.com>> wrote:
>From a bit of googling .


Remedy Corp.
The Company was incorporated on November 20, 1990 in Delaware
Headquarters Mountain View, California, USA
Key people Larry Garlick, Founder & CEO
Dave Mahler, VP Marketing
Doug Mueller, Chief Architect
Version 1.0 ?
Version 1.1 Approx. Nov 1992 still looking for confirmation
Version 2.0 was May 19, 1995
Version 4.0 was Jan 27, 1999


-Original Message-
From: Action Request System discussion list(ARSList)
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Remedy vs. HelpStar

[Heider, Stephen]

Our company is looking to see if there is another help desk product
besides Remedy to use for ticketing.  The primary reason for looking at
another product is cost savings, as we will need to add a number of
users/licenses to our existing Remedy system.

Next week I begin my evaluation of HelpStar.  I know the strength and
extendibility of Remedy, and do not think a small product like HelpStar
can compete.  However, I still need to compare it objectively.

Has anyone used and developed in HelpStar?  Has anyone previously
performed a side-by-side comparison with Remedy, and would be willing to
compare notes?

Any information would be helpful.

Thanks.
 
Stephen

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

Re: Stored Procedure in Remedy 6.03

[Heider, Stephen]

Eric,
 
The error is likely due to DTC not completely configured on both the
local and remote servers.  There are a number of previous posts
regarding this issue.
 
Another possibility is that ARS 6.3 is not supported with SQL Server
2005.
 
Stephen



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Dunn, Eric
Sent: Friday, June 01, 2007 2:12 PM
To: arslist@ARSLIST.ORG
Subject: SQL Stored Procedure Part II


** 
I forgot to add the error:
ARERR [552] Failure during SQL operation to the database : The ROLLBACK
TRANSACTION request has no corresponding BEGIN TRANSACTION. (SQL Server
3903)



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Dunn, Eric
Sent: Friday, June 01, 2007 2:10 PM
To: arslist@ARSLIST.ORG
Subject: Stored Procedure in Remedy 6.03


** 
I have an issue where I can not run a SQL Server Stored Procedure from
inside the client - but runs fine from Query Analyzer.  The Database is
SQL server 2005 with the Remedy server being 6.03 patch 16. 
 
Anyone seen this?
 
Eric W. Dunn
Programmer Analyst III - Remedy/Collaboration
McLeod USA, Inc. - Network Engineering
8665 New Trails Dr.
The Woodlands, TX 77381
(281)465-1265
(281)465-1951 fax
 




NOTICE: This electronic mail transmission may contain confidential
information and is intended only for the person(s) named. Any use,
copying or disclosure by any other person is strictly prohibited. If you
have received this transmission in error, please notify the sender via
e-mail.




__20060125___This posting was submitted with HTML in
it___

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

Re: API Logging

[Heider, Stephen]

*Subject line changed

Roseta,

What type of logging are you trying to perform?  Are the results of the
logging stored in a regular Remedy form?

What type and version of the ARS API are you using? (ie. C, Java, .Net)

Are the several applications web- or Windows-based?  Are they all Remedy
applications?

What version of ARS and Mid Tier are you using?

Which form is being automatically closed after 1 minute?  

Stephen

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of roseta
Sent: Sunday, June 03, 2007 1:30 AM
To: arslist@ARSLIST.ORG
Subject: Re: Get Rid of the Splash Screen on User Tool

Hello,

I have simillar question to you . I want to have one logging page for
several application and I used the  code. but the problem is that after
one minute the form is closed and session is closed.

Is there any timeout for this API? why this happens?
Can you give me a hint on this?


Thanks in advance.

--
View this message in context:
http://www.nabble.com/Get-Rid-of-the-Splash-Screen-on-User-Tool-tf219261
7.html#a10933868
Sent from the ARS (Action Request System) mailing list archive at
Nabble.com.


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

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

OT: LDAP Query in SQL Server 2000 UDF

[Heider, Stephen]

List,

I have a Vendor form (ARS 6.3) connected to Active Directory (Windows
2003), and it works fine.  The 'Vendor Information' setting for the form
is "ldap://ServerName/DC=pbsj,DC=com??sub?(objectclass=user)".  I can
query this Vendor form for a specific user just like any other Remedy
form, and it's quick.

I want to be able to query a specific user in Active Directory from
within a SQL Server 2000 function.  

In SQL, this function below does work for a user named, literally,
'LoginName'.  Unfortunately, with the OPENQUERY system function the
SELECT statement must be a literal string without variables (ie. can't
use variable @LoginName to substitute for 'LoginName').  

SELECT * FROM OPENQUERY(ADSI, 'SELECT msExchHomeServerName FROM
''LDAP://ServerName'' WHERE objectClass=''User'' AND
objectCategory=''Person'' AND sAMAccountName=''LoginName''') 

I don't think I can query the Vendor form from within SQL Server because
it is not a SQL View (like other forms).  For example:  SELECT * FROM
MyRemedyVendorForm WHERE sAMAccountName = 'LoginName'

Does anyone know of a way to query Active Directory by a single user
name within SQL Server? 

Thanks.

*I can pull back All users (4000+) from AD and then search through the
results, however this is too resource intensive.  Another option is to
create a .Net console app and then run it. I want avoid this option if
possible, at least until our production server uses SQL Server 2005
because I can then create a SQL function using .Net which will run very
fast.
 
Stephen

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

Re: Menu Question

[Heider, Stephen]

Brian,
 
You could use a SQL menu, such as this example with the User form:
SELECT Login_Name FROM User_x

UNION

SELECT Full_Name FROM User_x

 
Stephen 
 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Brian Gillock
Sent: Tuesday, June 05, 2007 9:32 AM
To: arslist@ARSLIST.ORG
Subject: Menu Question


** 

ARS Comrades,

I may be overlooking the obvious here, but...  I have a form that stores
patient information.  In that I have primary and secondary physicians.
I realize now that storing those in the same form wasn't exactly the
best way to go about it, but it's getting late in the game and I'm
hoping not to have to make a change.  Is there a way to pull both
physicians into a menu?  I want to be able to select between the two
physicians in another form.

 

 

Thanks!

Brian

__20060125___This posting was submitted with HTML in
it___

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

Re: Making an attachment field read-only

[Heider, Stephen]

Dwayne,

One approach is to keep the attachments in a separate form (one form
could be used for the entire application).  Then on the form(s) where
you want to allows users to add and view add a table field that points
to the attachments form.  This is how we handle it here.

If you want to go this route, each record in the attachment form would
contain one attachment field with unlimited size.  The link back to a
ticket would be: FormName=Schema And RecordEntryID=RequestID.  You could
also add: Server=Server.

The file size limit, ability to change or delete, permissions, etc.
would be up to you, all controlled by your workflow.  

HTH

Stephen

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin
Sent: Tuesday, June 05, 2007 7:56 AM
To: arslist@ARSLIST.ORG
Subject: Making an attachment field read-only

Greetings everyone,

We want to create a "Diary" attachment field, which means that once
you've attached a document you can't delete or change it.

I don't see the attachment fields in the field list for the active link
"Change Field" action. Is there any way you can dynamically make an
attachment field read-only?

(ARS 7.01 patch 2, Linux server, Oracle 10 db)

Dwayne Martin
Computing Support
James Madison University


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

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

Re: Sync Search Database getting Wiped out daily

[Heider, Stephen]

Regarding "...can not be done if your Server is NOT a windows box", is
the synch option available in any of the ARS API's?  I searched through
the help file for the 7.0 and 7.1 .Net API's but didn't see it
mentioned.

Stephen

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black
Sent: Monday, April 09, 2007 1:34 PM
To: arslist@ARSLIST.ORG
Subject: Re: Sync Search Database getting Wiped out daily

Jaspal,

Well... in order for "Sync Search database gets wiped out daily" to be
true then more had to be going on. The object_search_admin record would
not remove all of the related "Sync Search database" data.
(Unless the absence of the orbject_search_admin record some how short
cuts the admin tool from even trying to find any data in the Sync Search
DB forms. I guess that could be the case.)


I also find it a shame that this same functionality (Escalation to
rebuild the Sync DB) can not be done if your Server is NOT a windows
box. [ AKA: All of this stuff should be server side and preferably one
of the *Special* run process type actions. ]

Thanks for telling us know about someone is automating this process.

By the way: Do you know why they are deleting that record at all? ( I
doubt it is really a necessary step.)

--
Carey Matthew Black
Remedy Skilled Professional (RSP)
ARS = Action Request System(Remedy)

Love, then teach
Solution = People + Process + Tools
Fast, Accurate, Cheap Pick two.



On 4/9/07, Rawat, Jaspal <[EMAIL PROTECTED]> wrote:
> **
>
> Actually there was an escalation, that I didn't knew abt, which was 
> running nightly.
> It was a two step run process so that we could have the latest Synced 
> Search DB.
>
> 1. Application-Query-Delete-Entry "object_search_admin" 1=1 2. CMD /C 
> ARAdmin.exe -x $SERVER$ -u Webservice -p pipeline -portnum 2112 -s
>
> The second run process was not running because the PATH variable was 
> not having the Remedy binaries path included.
>
>
> Jaspal S Rawat


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

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

Re: Sync Search Database getting Wiped out daily

[Heider, Stephen]

 
Fred,

Thanks for the tip on truncating.  The entire process now only takes 35
minutes (400 forms, 7000 active-links, 1700 filters).  

I had hoped the synch process was available from the API...  I just
created a stored procedure (SQL Server) that performs all the steps for
"Synch Search Database", and have it scheduled to run nightly.  This
approach works when ARS is installed on a Windows server with the
Administrator Tool.  Here is the Direct SQL command:

EXEC usp_SynchSearchTables '$SERVER$', 'Demo', 'secret', 'C:\Program
Files\AR System\Admin\aradmin.exe'


CREATE PROCEDURE dbo.usp_SynchSearchTables
(
@Server VARCHAR(255),
@User VARCHAR(255),
@Password VARCHAR(255),
@ARAdmin VARCHAR(255)
)
-- Synchronizes the Remedy Object Search tables.
AS

SET NOCOUNT ON

DECLARE @SchemaId VARCHAR(10),
@SQL NVARCHAR(100),
@Command VARCHAR(1000)

SELECT @SchemaId = CONVERT(VARCHAR,SchemaId) FROM ARSchema WHERE [Name]
= 'object_search_admin'
SET @SQL = N'TRUNCATE TABLE H' + @SchemaId
EXEC sp_executesql @SQL
SET @SQL = N'TRUNCATE TABLE B' + @SchemaId
EXEC sp_executesql @SQL
SET @SQL = N'TRUNCATE TABLE T' + @SchemaId
EXEC sp_executesql @SQL

SELECT @SchemaId = CONVERT(VARCHAR,SchemaId) FROM ARSchema WHERE [Name]
= 'object_search_details'
SET @SQL = N'TRUNCATE TABLE H' + @SchemaId
EXEC sp_executesql @SQL
SET @SQL = N'TRUNCATE TABLE B' + @SchemaId
EXEC sp_executesql @SQL
SET @SQL = N'TRUNCATE TABLE T' + @SchemaId
EXEC sp_executesql @SQL

SELECT @SchemaId = CONVERT(VARCHAR,SchemaId) FROM ARSchema WHERE [Name]
= 'object_search_ref'
SET @SQL = N'TRUNCATE TABLE H' + @SchemaId
EXEC sp_executesql @SQL
SET @SQL = N'TRUNCATE TABLE B' + @SchemaId
EXEC sp_executesql @SQL
SET @SQL = N'TRUNCATE TABLE T' + @SchemaId
EXEC sp_executesql @SQL

IF CHARINDEX(' ', @ARAdmin) > 0 AND LEFT(@ARAdmin,1) <> '"'
SET @ARAdmin = '""' + @ARAdmin + '""'

SET @Command = @ARAdmin + ' -x ' + @Server + ' -u ' + @User + ' -p ' +
@Password + ' -s'

EXEC master..xp_cmdshell @Command
GO


Stephen 



-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W
Sent: Thursday, June 07, 2007 11:26 AM
To: arslist@ARSLIST.ORG
Subject: Re: Sync Search Database getting Wiped out daily

No, the building of the Sync data is an Admin Tool function not an API
function.  Also in order to do this on a Windows server the Admin tool
would have to be installed on the server as well.

Theoretically if your server can connect to a Windows machine where the
Admin tool is installed, it could start up the process remotely.


Side Note...  In order to speed up the Sync Process I have done the
following:   
Add 2 new Display Only Integer fields to the "object_search_admin" form
($Details Schema ID$, $Ref Schema ID$).

Add a filter "object_search_admin-TruncateOld`!" to the form
"object_search_admin"   
Filter Run If:  'TR.Run/Not Run' = 1   
Action 1:  Set Fields   
 From SQL:  SELECT SCHEMAID FROM ARSCHEMA WHERE
NAME='object_search_details'   
 Set $Details Schema ID$ = $1$   
Action 2:  Set Fields   
 From SQL:   SELECT SCHEMAID FROM ARSCHEMA WHERE
NAME='object_search_ref'   
 Set $Ref Schema ID$ = $1$   
Action 3: Direct SQL   
 Command: TRUNCATE TABLE T$Details SchemaID$   
Action 4: Direct SQL   
 Command: TRUNCATE TABLE H$Details SchemaID$   
Action 5: Direct SQL   
 Command: TRUNCATE TABLE B$Details SchemaID$   
Action 6: Direct SQL   
 Command: TRUNCATE TABLE T$Ref Schema ID$   
Action 7: Direct SQL   
 Command: TRUNCATE TABLE H$Ref Schema ID$   
Action 8: Direct SQL   
 Command: TRUNCATE TABLE B$Ref Schema ID$   


Watching the SQL logs as a Sync was started I saw that the Server had to
query the Details form and delete each record as well as do the same to
the Ref form.  Truncating both forms with the filter cut the sync time
on my server from approx 2 hours to just 35 minutes.  Since the Admin
tool uses the Remedy API to set the Run flag on the admin form this
filter fires normally. 

Fred

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen
Sent: Thursday, June 07, 2007 9:52 AM
To: arslist@ARSLIST.ORG
Subject: Re: Sync Search Database getting Wiped out daily

Regarding "...can not be done if your Server is NOT a windows box", is
the synch option available in any of the ARS API's?  I searched through
the help file for the 7.0 and 7.1 .Net API's but didn't see it
mentioned.

Stephen

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Carey Ma

Re: Hardware specs

[Heider, Stephen]

Since you mentioned defragging... 
 
I  just wanted to pass along a tip regarding defragging disks (at least
in Windows).   I schedule all the Remedy servers and my desktop computer
to defrag each night.  It's free, keeps the drives defragged, and
doesn't interfere with normal operations. 
 
I have a batch file that contains commands such as these:
 
defrag c: > c:\defragrpt.txt
defrag e: >> c:\defragrpt.txt
 
In Windows Scheduled Tasks I added a job that runs every night (outside
of backup times) and creates a small report of before and after
fragmentation percentages.  
 
Stephen 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza
Sent: Thursday, June 07, 2007 1:24 PM
To: arslist@ARSLIST.ORG
Subject: Re: Hardware specs


** 
For the use you intend, 250 GB would be more or less good enough
considering you might be storing application install files, possibly
taking DB backups on your local disk while installing and later when you
make certain AR System or its applications configuration changes. I
would budget about 50 GB for all those backups and about the same for
all the files that you would be downloading to install various products
plus patches..
 
Allocate at least 4 GB for your ARS Database and about the same size of
a tempdb / temp space..
 
Defrag your drive after all your installs for a good measure..
 
About your processor I don't really have that much of hardware expertise
but 2 processors of 3 GHz sounds pretty good.
 
Joe

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of John Hanson
Sent: Thursday, June 07, 2007 12:30 PM
To: arslist@ARSLIST.ORG
Subject: Re: Hardware specs


** 
That was about what I thought.  My first idea was for 2 GB RAM,
but it sounds like 4GB would probably be better overall.  For disk
space, would 250GB be about right?  What about the processor(s) - a
couple of 3.0 GHz?
 
Thanks,
John

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza
Sent: Thursday, June 07, 2007 9:22 AM
To: arslist@ARSLIST.ORG
Subject: Re: Hardware specs


** 
Even 2 GB RAM for ITSM 7 seems a little less than what
it should be.. Especially if you are using it for development and
testing.. if it were being used to demo the application by sales 2 GB
would have been just about right..
 
Joe

-Original Message-
From: Action Request System discussion
list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Durrant, Michael
M. - ITSD
Sent: Thursday, June 07, 2007 12:10 PM
To: arslist@ARSLIST.ORG
Subject: Re: Hardware specs


** 
If you're doing all that stuff on one machine, I
would recommend a laptop with AT LEAST 2GB of RAM, if not more.  ARS
Server + RDBMS consume prodigious amounts of memory.
 
Michael Durrant
[EMAIL PROTECTED]
Share what you know.  Learn what you don't.

 

 



From: Action Request System discussion
list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of John Hanson
Sent: Thursday, June 07, 2007 10:03 AM
To: arslist@ARSLIST.ORG
Subject: Hardware specs


** 

Hello list, 
I've been asked for hardware specs for a
standalone laptop to use as a sandbox for Remedy future development.  I
went through some old list emails but couldn't find quite what I needed.
It would be used for testing out version 7 and would have ARS, ITSM,
CMDB, mid-tier, and database all on the one machine.  Any assistance is
appreciated.

Thanks! 

John Hanson
Remedy Administrator/Developer
The Standard
1100 SW Sixth Avenue
Portland, OR 97204
Telephone (971) 321-7153
[EMAIL PROTECTED] 


__20060125___This posting
was submitted with HTML in it___ The information contained in this email
may be privileged, confidential or otherwise protected from disclosure.
All persons are advised that they may fac

Re: Table Properties - Results Color Tab

[Heider, Stephen]

Lisa,
 
One way to accomplish this is to add a Selection field to your form that
would include all of the different colors you plan to use for all of
your conditions.  Filters would then set this new Selection field.  Your
Table field would look at this field to determine which color to use for
each row.
 
Setting a Selection field from Filters provides the ability to create
complex conditions for each color.  In your example below, one of the
Filter conditions would be: myRealNumberField < 4.
 
HTH
 
Stephen



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa
Sent: Thursday, June 07, 2007 3:54 PM
To: arslist@ARSLIST.ORG
Subject: Table Properties - Results Color Tab


** 
Are Selection Fields the only fields that you can use to set colors for
rows in a table?
 
What if I would like to make all rows with an real number field < 4 red?
 
Lisa
__20060125___This posting was submitted with HTML in
it___

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

Re: ARS 7.01 P3 - any news ?

[Heider, Stephen]

...One thing that has worked most of the time for me when the Installer
does not accept the Remedy login username/password is to clear out the
password for the Demo user and uncheck Cross Ref Blank Password.  I then
use the Demo username when prompted by the Installer.
 
After the Installer completes I reset the Demo password and re-check the
Cross Ref Blank Password setting.
 
HTH
 
Stephen



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of patrick zandi
Sent: Friday, June 08, 2007 10:31 AM
To: arslist@ARSLIST.ORG
Subject: Re: ARS 7.01 P3 - any news ?


** 
Just thought I would share what I saw last night on this patch.
Server: Installer would not work properly - Got the connection to the
db, saw tables, asked to overwrite or upgrade, selected upgrade, It went
to the next question userid and password (I think that was next) then it
would not upgrade-- it could not connect ? 
Server: Installed all files for a server upgrade, vice installer, --
installed files, rebooted server. it came up running server, and
services, yet you cannot connect (rpc) error's (like server is not up).
stopped restarted, no diff.. looked at arerror log.. nothing.. wierd -
Stopped (restored to ars 7.01 P2) it is all working agian.. (Wheeewww..
) Breath---
Mid-tier: Installed and have it working now.. seems to work ok.. 
Issues so far: if you hit refreash or use a script to refresh it ask's
you to login.
(have not tested sso with it yet) or (floating licenses).
 
Just keeping you all informed..  Who know's  maybe P4 with be better--
But they have not even started on that yet .. rats.. guess it can be a
while.. another 4 months ?

 
On 5/31/07, patrick zandi <[EMAIL PROTECTED]> wrote: 


Anyone playing in this sandbox out there, care to comment ?
ARS 7.01 P3 - Limited Release


-- 
Patrick Zandi 




-- 
Patrick Zandi __20060125___This posting was
submitted with HTML in it___ 

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

Re: Hoover Text

[Heider, Stephen]

In Mid Tier?  Yes
 
Search the List for "tooltips", or click here
http://www.nabble.com/forum/Search.jtp?forum=716&local=y&query=tooltips
 
Stephen



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Bowen, Marc
Sent: Friday, June 08, 2007 2:05 PM
To: arslist@ARSLIST.ORG
Subject: Hoover Text


** 

Does anyone know if it is possible within ARS to show text when the
mouse "hoovers" over a field?

ARS 7.01

Solaris 5.10

Oracle 10

Thanks in advance

 

Marc Bowen
Remedy Skilled Professional
[EMAIL PROTECTED] 

 



***


The information in this email is confidential and may be legally
privileged.
It is intended solely for the addressee. Access to this email by anyone
else is
unauthorized. If you are not the intended recipient, any disclosure,
copying,
distribution or any action taken or omitted to be taken in reliance on
it, is
prohibited and may be unlawful. When addressed to our clients any
opinions or
advice contained in this email are subject to the terms and conditions
expressed in the governing KPMG client engagement letter.


***






__20060125___This posting was submitted with HTML in
it___

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

Re: Pushing Values to TCO:Cost form

[Heider, Stephen]

You can also create a new record by leaving the Push Fields If blank
(instead of adding 1=2).  Just set the If No Requests Match to "Create a
New Request" and If Any Requests Match = "Take No Action"
 
Stephen



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Antonio Maradiaga
Sent: Monday, June 11, 2007 9:53 AM
To: arslist@ARSLIST.ORG
Subject: Re: Pushing Values to TCO:Cost form


** 
Rick,
 
My qualification used was $TCO_CostEID$ != $NULL$
 
Just updated my qualifcation to 1=2 and its working.  THanks for your
help sir,
 
~Antonio

 
On 6/11/07, Rick Ponzo <[EMAIL PROTECTED]> wrote: 

Hi Antonio,

What is the qualification you are using to to create the new
record?
One sure way to create the record is to Push Field If 1=2. 

Rick Ponzo
IntegrITS Corporation


Antonio Maradiaga wrote:
> **
> All,
>
> Trying to push values to the TCO:Costs form to create a new
record
> from a staging form I've created.  I'm passing all the
required 
> fields, but my filter keeps modifying the same record instead
of
> creating a new entry in the TCO:Costs form.  I'm currently
using:
>
> ARS v6.3 on Win 2K3 server
> ITSM v5.6
> SQL Server 
>
> Has anyone worked with the TCO:Costs form and can anyone tell
me why
> my "Create new request" option on my push fields action is not
> creating new records?
>
> Thanks.
>
> ~Antonio
> __20060125___This posting was submitted
with HTML
> in it___

--
Rick Ponzo
IntegrITS Corporation
[EMAIL PROTECTED] 



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



__20060125___This posting was submitted with HTML in
it___ 

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

Re: Introducing 'Feeds' plug-in to AR System MidTier...

[Heider, Stephen]

I was able to login just now and download it.

Stephen 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza
Sent: Monday, June 11, 2007 2:32 PM
To: arslist@ARSLIST.ORG
Subject: Re: Introducing 'Feeds' plug-in to AR System MidTier...

Is there a problem logging to the Community Downloads page?? I tried to
log in and got an error "Error Detected" with no error details..

Joe

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of Dogiparthi, Maruthi
Sent: Monday, June 11, 2007 2:10 PM
To: arslist@ARSLIST.ORG
Subject: Introducing 'Feeds' plug-in to AR System MidTier...


Hi,

'Feed' is a recent technique to syndicate information from multiple
sources easily. Recent versions of popular browsers (Internet Explorer
7.0, Firefox
2.0) and rich desktop applications (FeedDemon etc) support 'feeds' very
well. Popular websites (CNN.com, msnbc.com etc) allow users to subscribe
to feeds and get their content easily. In intranet environments, many
users'd be interested in getting updates from different systems thru
feeds along with news etc.

RSS is one of the popular formats behind this technique. AR System
application developers can feed-enable their data using this mid-tier
plug-in that communicates with AR System server and transforms data to
RSS feed format.


This plug-in is tested with 7.0.1 Patch 2 (MidTier and AR Server) but
should work with 7.0.1 version onwards.

* To reach the download location, do the following:

  - Go to http://www.bmc.com/arsystem/dev_community/
  - Click on Community Downloads
  - You should see 'Feeds Plug-in' listed under "New to Community
Downloads". Select it.
  - Click on View Download button
  - In the resulting page, go to Attachment tab

* Download Feeds.zip and 'Feeds and ARSystem.doc' and open it for the
installation instructions

More details:
* Attached document has more info on security aspects and general
introduction to feeds etc
* This plug-in is a sample data visualization plug-in and not officially
supported by BMC

Feel free to send me an email if you have questions/comments or defects
to report or enhancement requests.


Thanks
Maruthi (maruthi_dogiparthi -add @bmc.com to this name) No virus found
in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.472 / Virus Database: 269.8.13/843 - Release Date:
6/10/2007
1:39 PM


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

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

Re: Panacea Workflow Studio

[Heider, Stephen]

I concur.  I have been using Workflow Studio for almost 2 years. 

One of the most remarkable aspects of the company/developers is the time
to fix a bug. In the few times I have reported a bug, they jump right on
it and found the issue (usually only 1-2 days), then fix it and post the
new version within 24 hours!  Amazing.

We all know that Bugs Happen, but the important thing to me is fixing it
asap.

Stephen

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Rocky Rockwell
Sent: Tuesday, June 12, 2007 3:38 PM
To: arslist@ARSLIST.ORG
Subject: 

I agree, panacea workflow studios has worked out great for us. for
migration for forms, workflow and data. plus all of the extra stuff it
does.

*Rocky*

Rocky Rockwell
eMA Team - Remedy Developer
[EMAIL PROTECTED] 
Ph#1: 214-567-8874
Ph#2: 325-884-1263



Anderson, Douglas W. wrote:
> **
>
> Hi Dave,
>
> I find the Panacea software to be very useful for a wide variety of 
> functions, you can check it out at www.pws-europe.com
>
> Their support has always been excellent as well.
>
> I have no financial interest in the company, though my employer is a 
> customer.
>
> Welcome back to the wondrous/curious world of ARS!
>
> Peace,
> Doug Anderson
>
> Opinions expressed are necessarily mine, not necessarily those of the 
> Mayo Foundation.
>
> Original message:
> Date:Tue, 12 Jun 2007 00:20:51 -0500
> From:Dave Headley <[EMAIL PROTECTED]>
> Subject: Workflow Explorer
>
> Hi All,It's been a while since I was on the ARSList - jobs change and 
> focusses shift.  My latest move has brought me back into the Remedy 
> world and I'm looking at how other people explore their home grown and

> Remedy's packaged application code.  The master AR Suite used to 
> provide a good set of documentation but I was wondering if anyone can 
> tell me of new code explorer software that is out at the moment. I'm 
> using version 7 and want to be able to search through the workflow to 
> browse for dependencies between workflow objects so that anything I 
> add doesn't conflict with other workflow.  Incident Management is a 
> whole lot more complicated than Help Desk used to be and I'm finding 
> it difficult to follow all of the links around the application so am 
> looking to see if there are any helper applications. Thanks in advance
Dave Headley.
>
> __20060125___This posting was submitted with HTML 
> in it___


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

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

Re: Panacea Workflow Studio

[Heider, Stephen]

You're right. I wish it would cache to speed up the processing.  

I also wish the Compare Servers feature would provide the option to Not see any 
objects which are identical.  When I am comparing two servers I am only 
interested in seeing the differences (ie. 8000 objects are identical and 20 are 
not). 

Maybe in the next version...

Stephen

-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Jarl Grøneng
Sent: Tuesday, June 12, 2007 3:45 PM
To: arslist@ARSLIST.ORG
Subject: 

The drawback with panacea is that it does not cache information You need to 
load everything each time you access a form.

--
Jarl

On 6/12/07, Rocky Rockwell <[EMAIL PROTECTED]> wrote:
> I agree, panacea workflow studios has worked out great for us. for 
> migration for forms, workflow and data. plus all of the extra stuff it does.
>
> *Rocky*
>
> Rocky Rockwell
> eMA Team - Remedy Developer
> [EMAIL PROTECTED] 
> Ph#1: 214-567-8874
> Ph#2: 325-884-1263
>
>
>
> Anderson, Douglas W. wrote:
> > **
> >
> > Hi Dave,
> >
> > I find the Panacea software to be very useful for a wide variety of 
> > functions, you can check it out at www.pws-europe.com
> >
> > Their support has always been excellent as well.
> >
> > I have no financial interest in the company, though my employer is a 
> > customer.
> >
> > Welcome back to the wondrous/curious world of ARS!
> >
> > Peace,
> > Doug Anderson
> >
> > Opinions expressed are necessarily mine, not necessarily those of 
> > the Mayo Foundation.
> >
> > Original message:
> > Date:Tue, 12 Jun 2007 00:20:51 -0500
> > From:Dave Headley <[EMAIL PROTECTED]>
> > Subject: Workflow Explorer
> >
> > Hi All,It's been a while since I was on the ARSList - jobs change 
> > and focusses shift.  My latest move has brought me back into the 
> > Remedy world and I'm looking at how other people explore their home 
> > grown and Remedy's packaged application code.  The master AR Suite 
> > used to provide a good set of documentation but I was wondering if 
> > anyone can tell me of new code explorer software that is out at the 
> > moment. I'm using version 7 and want to be able to search through 
> > the workflow to browse for dependencies between workflow objects so 
> > that anything I add doesn't conflict with other workflow.  Incident 
> > Management is a whole lot more complicated than Help Desk used to be 
> > and I'm finding it difficult to follow all of the links around the 
> > application so am looking to see if there are any helper applications. 
> > Thanks in advance Dave Headley.
> >
> > __20060125___This posting was submitted with 
> > HTML in it___
>
> __
> _ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org 
> ARSlist:"Where the Answers Are"
>

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

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

ARAdmin.exe Synch Search Database

[Heider, Stephen]

When running Tools > Synch Search Database within the Administrator Tool
it runs and there are no errors displayed.  When I run Synch Search
Database from the command line using "ARAdmin.exe -x Remedy -u Demo -p
secret -s" it runs and then at the very end displays the following text:

--
Starting Sync.
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
Sync Done.
--

These errors are probably generated within the Administrator Tool but
are just not displayed.  

What would cause these errors?  

ARS 6.3 (p16 & p21)
 
Stephen

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

Re: ARAdmin.exe Synch Search Database

[Heider, Stephen]

I even tried deleting the forms, then letting ARS recreate them by
running the Synch within the Administrator Tool.  

When running from the command line, I first TRUNCATE TABLE for the
tables behind the object_search_* SQL Views.

I wonder if another form has invalid fields and the Synch process
doesn't know how to handle them and is coughing up an error???

Stephen

 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W
Sent: Wednesday, June 13, 2007 9:29 AM
To: arslist@ARSLIST.ORG
Subject: Re: ARAdmin.exe Synch Search Database

It sounds like your object_search_ref or object_search_details form may
be messed up

Fred

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen
Sent: Wednesday, June 13, 2007 6:46 AM
To: arslist@ARSLIST.ORG
Subject: ARAdmin.exe Synch Search Database

When running Tools > Synch Search Database within the Administrator Tool
it runs and there are no errors displayed.  When I run Synch Search
Database from the command line using "ARAdmin.exe -x Remedy -u Demo -p
secret -s" it runs and then at the very end displays the following text:

--
Starting Sync.
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line Sync Done.
--

These errors are probably generated within the Administrator Tool but
are just not displayed.  

What would cause these errors?  

ARS 6.3 (p16 & p21)
 
Stephen


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

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

OT: Get Out-of-Office Message From Exchange

[Heider, Stephen]

Exchange Server experts,

I created a .Net console app that returns 1 or 0 if a user has set their
Out of Office setting in Outlook (Exchange 2003). No special permission
needed for this.

I want to be able to display a user's Out of Office message in Remedy.
The OoO text is stored in each user's InBox as a hidden email.  In order
to read email in someone else's InBox you need permission.  

The network account that runs the Remedy NT service (Win 2003) and/or
SQL Server 2000 would need to be granted this permission.  However, for
obvious reasons the account should not be granted Exchange Administrator
permission (which allows for reading someone else's InBox).

Here's the question: 

Is it even possible to grant permission to an account so that it *only*
can read users' Out of Office messages?

 
Stephen

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

Re: Linux Rules TOP 500 Supercomputers - Not a single Window$ supercomputer

[Heider, Stephen]

Do you think they make a notebook version of those supercomputer?  ITSM
7 requires a lot of resources.  :)
 
Stephen



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Guillaume Rheault
Sent: Friday, June 15, 2007 12:24 PM
To: arslist@ARSLIST.ORG
Subject: OT: Linux Rules TOP 500 Supercomputers - Not a single Window$
supercomputer


** 
All,
 
This is not directly related to the Remedy world, but since sometimes
listers ask what questions about Windows vs. Linux/UNIX, I thought this
post is then appropriate.
 
Linux and UNIX are the undisputed champions in the supercomputer world.
There is not a single Windows supercomputer that made it in top 500
supercomputers list
 
The top 500 supercomputers by OS family:
 
http://www.top500.org/stats/28/osfam/
 
The top 500 supercomputers by OS:
 
http://www.top500.org/stats/28/os/
 
This definitely must be a big embarrassment for Microsoft, that not a
single Window$ box made it to the top 500!
 
Guillaume
 
 
__20060125___This posting was submitted with HTML in
it___

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

OT: Crystal Reports XI Developer Upgrade

[Heider, Stephen]

Just wanted to pass this along for those that use CR for creating
reports for ARS... This seems like a fairly good deal.  I have an old v9
version that I plan to upgrade.

"Upgrade from previous versions of Crystal Reports to the Developer
Edition..." for $99 or purchase new for just $395.
 
http://www.businessobjects.com/devres/1087


Stephen 

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

Re: Disappearing tasks from Changes in ITSP 4.0

[Heider, Stephen]

Michel,
 
If the Tasks are getting deleted then create a Filter that executes on
Delete.  The filter can either stop the deletion, or if deletions are
allowed then it Pushes a record to another form that tracks when and by
whom the Task was deleted. 
 
Stephen



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Giguere, Michel
Sent: Friday, June 15, 2007 1:48 PM
To: arslist@ARSLIST.ORG
Subject: Disappearing tasks from Changes in ITSP 4.0


** 

I was wondering if anyone else has had this problem.

 

We are using Remedy 6.03 patch 20 and ITSP 4.0.

 

Some CHG:Infrastructure Change Task sometimes disappear and were not
able to recreate the problem.

 

Thanks!

 

-Michel- 

 

P.S.: We have had the same kind of problem with disappearing
CHG:Infrastructure Change Worklogs and BMC has found the bug. The fix is
to modify filter
'CFW:405M-AutoGenerateWorklog-SetStatusCREATE-woATTACHPASE' to update
'CHG:Worklog' = "Yes" instead of 'CFG:Worklog' = "Yes".

 

 

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza
Sent: June 15, 2007 1:27 PM
To: arslist@ARSLIST.ORG
Subject: Re: How to find which fields have a unique index.

 

Your error says its Field ID 179 that is violating this index..

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of Ray M
Sent: Friday, June 15, 2007 1:16 PM
To: arslist@ARSLIST.ORG
Subject: How to find which fields have a unique index.

** 

I get the following  error when I try to submit a new request
via AR Perl.

 

[ERROR] The value(s) for this entry violate a unique index that
has been defined for this form (HPD:IncidentInterface_Create
entry:0002282 fields: 179 ) (ARERR #382) 

 

How do I find which fields in form have a unique index

TIA

Ray

__20060125___This posting was submitted with
HTML in it___ 

__20060125___This posting was submitted with HTML in
it___ __20060125___This posting was submitted with
HTML in it___

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

Re: Is the Support Site Knowledge Base Down?

[Heider, Stephen]

As an alternative to searching online, there is the ARS_KBImport utility
available on http://arswiki.org/projects/dotnetutil/downloads that
provides for offline searching.
 
Stephen
 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Warren Baltimore
Sent: Monday, June 18, 2007 11:41 AM
To: arslist@ARSLIST.ORG
Subject: Re: Is the Support Site Knowledge Base Down?


** 
This is such a loaded question
 
:-p
 
It seems to be back up now

 
On 6/18/07, Pierson, Shawn <[EMAIL PROTECTED]> wrote: 

Joe,

It's not working for me either and the rest of the support site
is ok.

-Original Message- 
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Joe Bucci
Sent: Monday, June 18, 2007 9:10 AM
To: arslist@ARSLIST.ORG
Subject: Is the Support Site Knowledge Base Down?


Has anyone been able to use the KB this morning?

Thanks, Joe

Joe Bucci
cell 703-608-4467


_ 
Need a break? Find your escape route with Live Search Maps.

http://maps.live.com/default.aspx?ss=Restaurants~Hotels~Amusement%20Park


&cp=33.832922~-117.915659&style=r&lvl=13&tilt=-90&dir=0&alt=-1000&scene=
1118863&encType=1&FORM=MGAC01




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

The information in this e-mail, and any files transmitted with
it, is intended for the exclusive use of the recipient(s) to which it is
addressed and may contain confidential, proprietary or privileged
information.  If you are not an intended recipient, you have received
this transmission in error and any use, review, dissemination,
distribution, printing or copying of this information is strictly
prohibited.  If you have received this e-mail in error, please notify
the sender immediately of the erroneous transmission by reply e-mail,
immediately delete this e-mail and all electronic copies of it from your
system and destroy any hard copies of it that you may have made. Thank
you. 



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





-- 
Warren R. Baltimore II
Remedy Developer
UW Medicine IT Services
School of Medicine
University of Washington
Box 358220
1325 Fourth Ave, Suite 2000
Seattle, WA 98101

The opinions expressed in this e-mail are in no way those of the
University of Washington, or the State of Washington.  They are my own.
__20060125___This posting was submitted with HTML in
it___ 

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

Re: Get Out-of-Office Message From Exchange

[Heider, Stephen]

(like they always do) to set
their Remedy notifications to "None"...

Last time I tried this, it was not "open" and required mailbox access
rights :( of course we were on a different version of exchange at that
time as well.
** THANKS **

Thanks-n-advance;
HDT Platform Incident / Problem Manager & Architect Robert Molenda IT OS
PA
Tel: +1 408 503 2701
Fax: +1 408 503 2912
Mobile: +1 408 472 8097
[EMAIL PROTECTED]
Quality begins with your actions.


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen
Sent: Friday, June 15, 2007 7:58 AM
To: arslist@ARSLIST.ORG
Subject: OT: Get Out-of-Office Message From Exchange

Exchange Server experts,

I created a .Net console app that returns 1 or 0 if a user has set their
Out of Office setting in Outlook (Exchange 2003). No special permission
needed for this.

I want to be able to display a user's Out of Office message in Remedy.
The OoO text is stored in each user's InBox as a hidden email.  In order
to read email in someone else's InBox you need permission.  

The network account that runs the Remedy NT service (Win 2003) and/or
SQL Server 2000 would need to be granted this permission.  However, for
obvious reasons the account should not be granted Exchange Administrator
permission (which allows for reading someone else's InBox).

Here's the question: 

Is it even possible to grant permission to an account so that it *only*
can read users' Out of Office messages?

 
Stephen


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


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


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

Re: how to capture ip address of remedy client user?

[Heider, Stephen]

Andrew,
 
You may be able to get the client's IP address through log files but I
have not tried it.  If you capture the IP address from the client when
they first login (ie. Home Page) and store it in a Global field, then
anytime you need to inform the server of their IP address you would pass
it to the form (which the Filter could pick up).
 
I have used ipconfig.exe before, but like Fred mentioned, you would need
to parse it (I ended up creating a SQL function to parse and return the
IP address.)
 
Another option [for the Remedy User Tool] is the WksInfo utility
available on http://arswiki.org/projects/dotnetutil/downloads.  It
returns the IP address and other info.  For mid tier clients the IP
address can be captured in javascript and jsp and stored in a Global
field.
 
HTH
 
Stephen



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Andrew Hicox
Sent: Thursday, June 21, 2007 2:17 PM
To: arslist@ARSLIST.ORG
Subject: Re: how to capture ip address of remedy client user?


** 


Yeah all I'm after is "just the facts" ... :-)

 
I'm looking for something that can run in a filter on the server and
capture the ip address of the connection to the server that modified the
ticket. 
 
Not concerned with the configuration on the client ... they can have 20
ips for all I care ;-)


thx everyone,


 -A

-Original Message-
From: Carey Matthew Black <[EMAIL PROTECTED]>
To: arslist@ARSLIST.ORG
Date: Thu, 21 Jun 2007 14:01:13 -0400
Subject: Re: how to capture ip address of remedy client user?


Also keep in mind that as VMWare and other such "virtual NIC"s
(like
VPN's) exist more and more it is likely that the client PC will
have
multiple IP's. So you may need to collect a set of values
instead of
"one" value.

I know that makes the task more difficult, but it is really
"truth"
that your after right?

-- 
Carey Matthew Black
Remedy Skilled Professional (RSP)
ARS = Action Request System(Remedy)

Love, then teach
Solution = People + Process + Tools
Fast, Accurate, Cheap Pick two.

On 6/21/07, Grooms, Frederick W <[EMAIL PROTECTED]>
wrote:
> **
>
> From the User Tool you can do a Set Fields Action to get the
host name:
>$zHostName$ (or whatever you name the field) = $PROCESS$
%COMSPEC% /c
> echo %COMPUTERNAME%
>
> For the IP you can do:
>
>$zLocalIP$ (or whatever you name the field) = $PROCESS$
%COMSPEC% /c
> ipconfig
> You will have to parse out the IP from the result
>
> Fred
>
>  
>  From: Action Request System discussion list(ARSList)
> [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Hicox
> Sent: Thursday, June 21, 2007 11:10 AM
> To: arslist@ARSLIST.ORG
> Subject: how to capture ip address of remedy client user?
>
>
>
>
> Hello everyone:
>
>
> In addition to the usual 'last modified by' field, I also
would like to
> capture the ip address or hostname of the user who last
modified a record.
> Anyone know a way to do that? Seems like there would be a
keyword like
> $HOSTNAME$ or $IP$ would do it but I don't see anything like
that in the
> docs. We're running ARS 7.0
>
> thanks,
>
>
>
> -Andrew
>
>
>
>
>
>
>
>   __20060125___This posting was
> submitted with HTML in it___



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


__20060125___This posting was submitted with HTML in
it___ 

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

Table Field Columns Not Visible

[Heider, Stephen]

List,

I hope you can help. This issue is on the production server.

On the main (home) display-only form a table field that is used to
display tickets is not displaying all columns.  They all appear on the
development server but not on the production server.   

I have exported/imported the .def file for the form from dev to prod
several times but the columns still do not appear.  If it wasn't the
main/home form I would delete it then reimport the .def.

On one of the columns I removed the permissions, then added permissions,
then saved the form.  That column now no longer appears in the table
field. It seems like something is corrupt.

I even tried adding every permission and also issuing a Change Field
action to force the column Visible (it is not marked as Hidden in the
.def).

Help!

Production:
ARS 6.3 p16
Windows 2003
SQL 2000

Development:
ARS 6.3 p21
Windows 2003
SQL 2000
 
Stephen

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

Re: Table Field Columns Not Visible

[Heider, Stephen]

I cleared the "AR System/Home" folder and re-logged in but the columns
do not appear.  Afterwards I opened the ar.ini and there was not a
ColumnWidth section.


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of David Sanders
Sent: Monday, June 25, 2007 10:39 AM
To: arslist@ARSLIST.ORG
Subject: Re: Table Field Columns Not Visible

Hi Stephen

You could also check your AR.INI file in your home directory and look at
the entries in the section [ColumnWidth].  In fact, you could delete
that whole section.

HTH

David Sanders
Remedy Solution Architect
Enterprise Service Suite @ Work
==
ARS List Award Winner 2005
Best 3rd party Remedy Application
 
See the ESS Concepts Guide
 
tel +44 1494 468980
mobile +44 7710 377761
email [EMAIL PROTECTED]
 
web http://www.westoverconsulting.co.uk
 
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen
Sent: Monday, June 25, 2007 3:24 PM
To: arslist@ARSLIST.ORG
Subject: Table Field Columns Not Visible

List,

I hope you can help. This issue is on the production server.

On the main (home) display-only form a table field that is used to
display tickets is not displaying all columns.  They all appear on the
development server but not on the production server.   

I have exported/imported the .def file for the form from dev to prod
several times but the columns still do not appear.  If it wasn't the
main/home form I would delete it then reimport the .def.

On one of the columns I removed the permissions, then added permissions,
then saved the form.  That column now no longer appears in the table
field. It seems like something is corrupt.

I even tried adding every permission and also issuing a Change Field
action to force the column Visible (it is not marked as Hidden in the
.def).

Help!

Production:
ARS 6.3 p16
Windows 2003
SQL 2000

Development:
ARS 6.3 p21
Windows 2003
SQL 2000
 
Stephen



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


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

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

Re: Table Field Columns Not Visible

[Heider, Stephen]

One of the missing/invisible columns is a Selection field, one is a
datetime field, and one is a character field with a length of 30.


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96
CS/SCCE
Sent: Monday, June 25, 2007 10:36 AM
To: arslist@ARSLIST.ORG
Subject: Re: Table Field Columns Not Visible

Stephen:

The field the column is pulling from...what's the character limit of
that field?

Norm

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen
Sent: Monday, June 25, 2007 9:24 AM
To: arslist@ARSLIST.ORG
Subject: Table Field Columns Not Visible

List,

I hope you can help. This issue is on the production server.

On the main (home) display-only form a table field that is used to
display tickets is not displaying all columns.  They all appear on the
development server but not on the production server.   

I have exported/imported the .def file for the form from dev to prod
several times but the columns still do not appear.  If it wasn't the
main/home form I would delete it then reimport the .def.

On one of the columns I removed the permissions, then added permissions,
then saved the form.  That column now no longer appears in the table
field. It seems like something is corrupt.

I even tried adding every permission and also issuing a Change Field
action to force the column Visible (it is not marked as Hidden in the
.def).

Help!

Production:
ARS 6.3 p16
Windows 2003
SQL 2000

Development:
ARS 6.3 p21
Windows 2003
SQL 2000
 
Stephen


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


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

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

Re: Table Field Columns Not Visible

[Heider, Stephen]

Getting closer...  The User Tool is 7.0.01 p2.  

When I right-click on the table field and select Reset  all columns
appear.  When I logout and log back in those columns are not visible.

When I login on another computer with User Tool 6.03.00 p16 all of the
columns appear.

How can I get the columns to remain visible in User Tool v7 without
having to right-click and select Reset each time the form is opened?

Stephen


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Mike Wallick
Sent: Monday, June 25, 2007 10:42 AM
To: arslist@ARSLIST.ORG
Subject: Re: Table Field Columns Not Visible

I've also seen this when using the v7 user tool. Since that version
allows users to specify table field preferences (like showing/hiding
table columns), I've noticed that when I add columns to a table field
and then open that form in a v7 user tool, I have to "add" the column by
right-clicking on the table, choosing preferences, add column, etc.
However, since you're using WF to show/hide these columns, that's
probably not the issue.

Again, if you're using a v7 user tool, you could try resetting the table
(right click on the table, choose preferences, reset. That will reset
any client-side table field preferences.

Just a thought.

Mike

On 6/25/07, Opela, Gary L Contr OC-ALC/ITMA
<[EMAIL PROTECTED]> wrote:
> Interesting.
>
> You said that you did check permissions on each of the columns, right?
> Did you check to make sure that the entries in the Group form were in 
> production too?
>
> I've noticed before that whenever importing, it will sometimes import 
> the permission on the field even if I've not yet created the group
yet.
>
> Also, bear in mind, that if you copy/paste a table from one form to 
> another (for instance from dev to prod) that the field IDs on the 
> columns in the table are not retained. They will be assigned new 
> column ids, so if you rely on WF to make the columns visible, this 
> might be an issue as well.
>
> The things I would check:
>
> Permissions on each column
> Groups in the group form for the permissions If I'm relying on WF to 
> make columns visible, make sure there is no issue with field IDs on 
> the columns Delete all cached views (arv and arf) for that form Check 
> on the table properties tab to make sure that the column widths didn't

> some how get messed up
>
> I'm wondering if its not an issue with groups, since it works on dev 
> but not production. I've had this exact issue before with some fields 
> on dev showing up, but then they didn't show up on prod.
>
> HTH
>
> -Original Message-
> From: Action Request System discussion list(ARSList) 
> [mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen
> Sent: Monday, June 25, 2007 9:24 AM
> To: arslist@ARSLIST.ORG
> Subject: Table Field Columns Not Visible
>
> List,
>
> I hope you can help. This issue is on the production server.
>
> On the main (home) display-only form a table field that is used to 
> display tickets is not displaying all columns.  They all appear on the

> development server but not on the production server.
>
> I have exported/imported the .def file for the form from dev to prod 
> several times but the columns still do not appear.  If it wasn't the 
> main/home form I would delete it then reimport the .def.
>
> On one of the columns I removed the permissions, then added 
> permissions, then saved the form.  That column now no longer appears 
> in the table field. It seems like something is corrupt.
>
> I even tried adding every permission and also issuing a Change Field 
> action to force the column Visible (it is not marked as Hidden in the 
> .def).
>
> Help!
>
> Production:
> ARS 6.3 p16
> Windows 2003
> SQL 2000
>
> Development:
> ARS 6.3 p21
> Windows 2003
> SQL 2000
>
> Stephen
>
> __
> __
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org 
> ARSlist:"Where the Answers Are"
>
> __
> _ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org 
> ARSlist:"Where the Answers Are"
>


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

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

Re: Table Field Columns Not Visible - RESOLVED

[Heider, Stephen]

After Resetting the table field preferences I selected the Save option.

Thank you to all for responding!  I was beginning to get a little
nervous for a moment :)

It's weird that only columns that were added or changed recently were
affected. Columns that haven't changed in a while were visible.  Is this
a bug in the v7 User Tool?

Stephen
 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen
Sent: Monday, June 25, 2007 10:56 AM
To: arslist@ARSLIST.ORG
Subject: Re: Table Field Columns Not Visible

Getting closer...  The User Tool is 7.0.01 p2.  

When I right-click on the table field and select Reset  all columns
appear.  When I logout and log back in those columns are not visible.

When I login on another computer with User Tool 6.03.00 p16 all of the
columns appear.

How can I get the columns to remain visible in User Tool v7 without
having to right-click and select Reset each time the form is opened?

Stephen


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Mike Wallick
Sent: Monday, June 25, 2007 10:42 AM
To: arslist@ARSLIST.ORG
Subject: Re: Table Field Columns Not Visible

I've also seen this when using the v7 user tool. Since that version
allows users to specify table field preferences (like showing/hiding
table columns), I've noticed that when I add columns to a table field
and then open that form in a v7 user tool, I have to "add" the column by
right-clicking on the table, choosing preferences, add column, etc.
However, since you're using WF to show/hide these columns, that's
probably not the issue.

Again, if you're using a v7 user tool, you could try resetting the table
(right click on the table, choose preferences, reset. That will reset
any client-side table field preferences.

Just a thought.

Mike

On 6/25/07, Opela, Gary L Contr OC-ALC/ITMA
<[EMAIL PROTECTED]> wrote:
> Interesting.
>
> You said that you did check permissions on each of the columns, right?
> Did you check to make sure that the entries in the Group form were in 
> production too?
>
> I've noticed before that whenever importing, it will sometimes import 
> the permission on the field even if I've not yet created the group
yet.
>
> Also, bear in mind, that if you copy/paste a table from one form to 
> another (for instance from dev to prod) that the field IDs on the 
> columns in the table are not retained. They will be assigned new 
> column ids, so if you rely on WF to make the columns visible, this 
> might be an issue as well.
>
> The things I would check:
>
> Permissions on each column
> Groups in the group form for the permissions If I'm relying on WF to 
> make columns visible, make sure there is no issue with field IDs on 
> the columns Delete all cached views (arv and arf) for that form Check 
> on the table properties tab to make sure that the column widths didn't

> some how get messed up
>
> I'm wondering if its not an issue with groups, since it works on dev 
> but not production. I've had this exact issue before with some fields 
> on dev showing up, but then they didn't show up on prod.
>
> HTH
>
> -Original Message-
> From: Action Request System discussion list(ARSList) 
> [mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen
> Sent: Monday, June 25, 2007 9:24 AM
> To: arslist@ARSLIST.ORG
> Subject: Table Field Columns Not Visible
>
> List,
>
> I hope you can help. This issue is on the production server.
>
> On the main (home) display-only form a table field that is used to 
> display tickets is not displaying all columns.  They all appear on the

> development server but not on the production server.
>
> I have exported/imported the .def file for the form from dev to prod 
> several times but the columns still do not appear.  If it wasn't the 
> main/home form I would delete it then reimport the .def.
>
> On one of the columns I removed the permissions, then added 
> permissions, then saved the form.  That column now no longer appears 
> in the table field. It seems like something is corrupt.
>
> I even tried adding every permission and also issuing a Change Field 
> action to force the column Visible (it is not marked as Hidden in the 
> .def).
>
> Help!
>
> Production:
> ARS 6.3 p16
> Windows 2003
> SQL 2000
>
> Development:
> ARS 6.3 p21
> Windows 2003
> SQL 2000
>
> Stephen
>
> __
> __
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org 
> ARSlist:"Where the Answers Are"
>
> _

Re: Installing ARS 5.1.2 on SQL 2005

[Heider, Stephen]

Bruce,
 
You probably already know that SQL 2005 is not supported on 5.1.2 ARS...
however here is something to try.
 
Install SQL 2000 on the same computer, then try to install ARS 5.1.2 to
your SQL 2005 instance. If that fails then install it to your SQL 2000
instance.  After you have installed all the ARS software make a SQL
database backup of the ARSystem db.  Restore the db to SQL 2005. Then
update the ar.cfg file to point to the 2005 server.   This may trick ARS
into running on SQL 2005.
 
HTH
 
Stephen



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Bruce Scott
Sent: Tuesday, June 26, 2007 6:39 PM
To: arslist@ARSLIST.ORG
Subject: Installing ARS 5.1.2 on SQL 2005


** 
I am trying to move my existing ARS system from Oracle 9i to SQL Server
2005 prior to upgrading the version of ARS.  However, I can't get the
ARS 5.1.2 installer to recognize the SQL 2005 Client dlls. Newer
versions of ARS will install correctly, but I would like to take a
smaller jump in changes if possible.  Has anyone else experienced this?
The error message I'm seeing is this:
 
Cannot load database connection DLL.  The database software might not be
installed.  Click OK to return to the Select Database screen.
 
With an earlier install using the Oracle 9i client this error was
attributed to having a semi-colon in place of the colon of the path
statement.  The path statement has been modified to include the
following variants:
 
C:\Program Files\Microsoft SQL
Server\90\Tools\Binn\VSShell\Common7\IDE\;C:\Progra~1\Micros~4\90\Tools\
Binn\VSShell\Common7\IDE\;"C:\Program Files\Microsoft SQL
Server\90\Tools\Binn\VSShell\Common7\IDE\"
 

Any suggestions would be greatly appreciated.

 

Bruce Scott

Application Developer - Remedy

SSG, PetSMART, Inc.

Office:  623.587.2340

eMail:  [EMAIL PROTECTED]

 


The information contained in this electronic mail message, including
attachments, if any, is PetSmart confidential information.  It is
intended only for the use of the person(s) named above.  If the reader
of this message is not the intended recipient, or has received this
message in error, you are hereby notified that any review,
dissemination, distribution or copying of this communication is strictly
prohibited.  If you are not the intended recipient or have received this
message in error, please notify the sender via e-mail and promptly
delete the original message.


__20060125___This posting was submitted with HTML in
it___

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

Re: Real-World Value of SMS & CMDB

[Heider, Stephen]

Interesting site.
   



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of John Sundberg
Sent: Thursday, June 28, 2007 8:00 AM
To: arslist@ARSLIST.ORG
Subject: Re: Real-World Value of SMS & CMDB


** 
Kaiser,

An interesting source of info/opinion about CMDB.
http://www.itskeptic.org/taxonomy/term/6

I also recommend for general ITSM/ITIL:
http://www.itskeptic.org/

I like the itskeptic - as (whoever it is) the person has a very real
world approach to the ITSM world. (And also calls out some companies
bluffs/marketing).

Email me offlist for comments. 

Thanks,

-John



On 6/27/07, Kaiser Norm E CIV USAF 96 CS/SCCE <[EMAIL PROTECTED]
> wrote: 

Matt and everyone else:

So for those of you who have a populated CMDB in a large
enterprise--are 
you truly gleaning anything OF VALUE from it that you couldn't
glean
from the native auto-discovery DB itself?

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto: [EMAIL PROTECTED] On Behalf Of Carey Matthew Black
Sent: Wednesday, June 27, 2007 2:29 PM
To: arslist@ARSLIST.ORG
Subject: Re: Real-World Value of SMS & CMDB 

Norm,

Part of the value of having monitoring (and discovery tools) is
that
you can bash "changes" in the availability and configuration
against
planed changes. (And you can discover unplanned, and
uncontrolled 
changes.) Some of the most expensive problems are planned
changes.
However some of the more serious failures are normally
unplanned.


Automated process can run 100% of the time. Humans pounding on
the
keyboard generally are not as 100% available, or 100% consistent
about
how they do things. ("Microsoft" != "microsoft" in most
programming
languages.)

Everything I have read and learned about a CMDB is that if your
not 
discovering some (or most) of your data then you might as well
not
even start down that road. Even if the discovery process leads
to some
false negatives, it is a start to understanding your actually
environment and processes. And that is the point of the
Configuration 
Management DB.

--
Carey Matthew Black
Remedy Skilled Professional (RSP)
ARS = Action Request System(Remedy)

Love, then teach
Solution = People + Process + Tools
Fast, Accurate, Cheap Pick two. 




On 6/27/07, Kaiser Norm E CIV USAF 96 CS/SCCE <
[EMAIL PROTECTED]>
wrote:
> **
>
>
>
> Well...what the auto-discovery tool can/can't do isn't really
my 
concern here.
>
>
>
> Say I have a server on the network.  My discovery tool
discovers it.
It
> accordingly creates a record in its database.
>
>
>
> A few days go by.  Someone shuts down the server for 
> maintenance...coincidentally during the next discovery poll.
The
discovery
> tool now sees the server as "missing" from the network.
>
>
>
> Now consider an enterprise that consists of over 40,000 such
machines 
> (servers, workstations, laptops, etc.) and imagine the
problem.
>
>
>
>  
>
>
> From: Action Request System discussion list(ARSList)
> [mailto: __20060125___This posting was
submitted with HTML in it___


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"
<<143714472v3_150x150_Front.jpg>>

Re: BMC Remedy Incident Management 7.0.02 installation query

[Heider, Stephen]

Rosemary,
 
This is something that has worked at times in the past for me...it's not
specific to Incident Management but ARS installations in general.  When
I notice the installation hangs on the 'Restarting server' message I
open up the Windows Services dialog and manually start (or restart) the
ARS service.  The installation program may continue.
 
HTH
 
Stephen



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Rosemary OConnor
Sent: Sunday, July 01, 2007 8:00 PM
To: arslist@ARSLIST.ORG
Subject: BMC Remedy Incident Management 7.0.02 installation query


** 
Hi all,
 
I'm hoping someone can shed some light on the installation process.
 
I'm attempting to install BMC Remedy Incident Management 7.0.02 onto a
Windows 2003 Server R2 SP2 Standard Edition (VMWare unfortunately),
2.2Ghz processor and 2.0Gb RAM. It's been going a few hours so far. I
know the server specs leave a lot to be desired but it's all I've been
able to squeeze from our systems team, even after pointing out all the
recommendations in the installation manuals.
 
The installation seems to go fine until it gets to the point where it
says "Restarting BMC Remedy Action Request System Server. Please wait.",
also the CPU has been running at 100% since it got to this screen.
 
Does anyone know how long it could do this for before finalising the
installation? It's the first of the ITSM applications to go onto the
server.
 
Kind regards
Rosemary

Send instant messages to your online friends
http://au.messenger.yahoo.com __20060125___This
posting was submitted with HTML in it___

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

Re: E-mail Submit from BlackBerry Device

[Heider, Stephen]

Chris,

Yes, I have.  One way is to use an HTML Form message with a Submit
button that posts the user's response to a non-gui web application.
This web app receives the posted response and using the ARS API, sends
the response to Remedy.

Another way is to create a gui web application which the user runs from
the BlackBerry Browser.  The web app would receive the users response
and send it to Remedy via the ARS API.  

There are other ways, I'm sure, but both of these approaches have been
in production here for a couple years.

Note, on the BB most or all of the Javascript settings must be enabled
in the BlackBerry Browser. Most are disabled by default.


Stephen


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Christopher Blue
Sent: Monday, July 02, 2007 10:42 AM
To: arslist@ARSLIST.ORG
Subject: E-mail Submit from BlackBerry Device

Has anyone implemented a submit action from a BlackBerry device?

I just need for a BlackBerry user to answer a yes/no type message and
have it submit a form I can fire the workload from.

I tried setting up a HTML message per the manual but it doesn't work. 
The incoming record shows "Parsed and Executed" but no record is created
and the error logs are clean. Incoming mail is working; plain text
message process normally but really won't work for this type of input.
Is there some step I'm missing or has anyone been able to implement
this?

Thanks!

ENV:

ARS 6.03p21 on WIN2K
MS Exchange 2K
MS Outlook profile running MAPI profile for email engine user Oracle
9.2.0.6 Mid Tier 6.03p21 on Apache

Chris Blue
CHEP
Orlando FL


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

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

FW: Field names in a list

[Heider, Stephen]

I am looking for documentation on the .Def format...to be able to decode
it similar to what Misi has in this utility.

I searched the list and the pdfs (v7.x).  Is this info posted somewhere?


Stephen
 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Misi Mladoniczky
Sent: Monday, July 02, 2007 4:51 AM
To: arslist@ARSLIST.ORG
Subject: Re: Field names in a list

Rob,

I have now updated our rrrDefFieldList-tool to include field labels.

This tool runs on def-files and produce a list of all the fields in the
file. It does not connect to the server or the network.

The result is a semicolon separated text file that you can open in
Excel.

The listed information includes information about Form, Id, Name, Label,
Type, Option, Length, Enum-values, Default, Pattern and Menu of each
field.

https://www.rrr.se/cgi/tools/main#rrrDefFieldList

Best Regards - Misi, RRR AB, http://www.rrr.se

> As we all know each field in a form has at least three names, one the 
> user sees (user-facing), the name we see in the admin tool and the 
> name stored in the database.
>
> I have a manager who wants a csv file listing all the fields on a form

> showing the user-facing name alongside the admin-tool name. The reason

> is that users see the admin-tool name (or the database name) while 
> putting together reports. We have for instance, relabeled field 'Tag 
> Number' so that users see 'PIMS Number', but it remains 'Tag Number' 
> in the admin tool and Tag_Number in the database.
>
> The admin-tool and database names are easy to come by, but how can I 
> extract the user-facing names? Will arinside do it? I can't install 
> anything needing admin rights without a song-and-dance routine with 
> computer security--that takes weeks. If arinside or some other tool 
> will do the trick, I can possibly speed up that process.
>
> I've been through the database this morning looking in a MS SQL 
> installation on my laptop, and I do not see a table under ARSystem 
> that holds the info I need. For instance, Field has the name and a lot

> of other info, but column fieldName is the admin-tool name.
>
> Any help would be appreciated. Is the answer obvious? Am I missing 
> something, as usual?
>
> Thanks.
>
> --
> Bob Rowe, Remedy Action Request System Development and Administration
>  [EMAIL PROTECTED] "The golden rule is to test 
> everything in the light of reason and experience, no matter from where

> it comes."
> Mohandas K. Gandhi
>
> __
> _ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org 
> ARSlist:"Where the Answers Are"
>


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

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

Re: FW: Field names in a list

[Heider, Stephen]

Would anyone out there have notes they would be willing to share?  I
would like to create a Class (in .net) that could be used to decode
these values so that it could be added to any ARS API .Net project.

Stephen

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Misi Mladoniczky
Sent: Monday, July 02, 2007 2:21 PM
To: arslist@ARSLIST.ORG
Subject: Re: FW: Field names in a list

No, not really!

You can slowly figure things out by simultaneously looking at the
def-file and the ar.h-file in the API.

The XML-definitions are easier. Unfortunately, they tend to become huge.

Best Regards - Misi, RRR AB, http://www.rrr.se

Products from RRR Scandinavia:
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy
logs.
* RRR|Translator - Manage and automate your language translations.
Find these products, and many free tools and utilities, at
http://rrr.se.

> I am looking for documentation on the .Def format...to be able to 
> decode it similar to what Misi has in this utility.
>
> I searched the list and the pdfs (v7.x).  Is this info posted
somewhere?
>
>
> Stephen
>
>
> -Original Message-
> From: Action Request System discussion list(ARSList) 
> [mailto:[EMAIL PROTECTED] On Behalf Of Misi Mladoniczky
> Sent: Monday, July 02, 2007 4:51 AM
> To: arslist@ARSLIST.ORG
> Subject: Re: Field names in a list
>
> Rob,
>
> I have now updated our rrrDefFieldList-tool to include field labels.
>
> This tool runs on def-files and produce a list of all the fields in 
> the file. It does not connect to the server or the network.
>
> The result is a semicolon separated text file that you can open in 
> Excel.
>
> The listed information includes information about Form, Id, Name, 
> Label, Type, Option, Length, Enum-values, Default, Pattern and Menu of

> each field.
>
> https://www.rrr.se/cgi/tools/main#rrrDefFieldList
>
> Best Regards - Misi, RRR AB, http://www.rrr.se
>
>> As we all know each field in a form has at least three names, one the

>> user sees (user-facing), the name we see in the admin tool and the 
>> name stored in the database.
>>
>> I have a manager who wants a csv file listing all the fields on a 
>> form
>
>> showing the user-facing name alongside the admin-tool name. The 
>> reason
>
>> is that users see the admin-tool name (or the database name) while 
>> putting together reports. We have for instance, relabeled field 'Tag 
>> Number' so that users see 'PIMS Number', but it remains 'Tag Number'
>> in the admin tool and Tag_Number in the database.
>>
>> The admin-tool and database names are easy to come by, but how can I 
>> extract the user-facing names? Will arinside do it? I can't install 
>> anything needing admin rights without a song-and-dance routine with 
>> computer security--that takes weeks. If arinside or some other tool 
>> will do the trick, I can possibly speed up that process.
>>
>> I've been through the database this morning looking in a MS SQL 
>> installation on my laptop, and I do not see a table under ARSystem 
>> that holds the info I need. For instance, Field has the name and a 
>> lot
>
>> of other info, but column fieldName is the admin-tool name.
>>
>> Any help would be appreciated. Is the answer obvious? Am I missing 
>> something, as usual?
>>
>> Thanks.
>>
>> --
>> Bob Rowe, Remedy Action Request System Development and Administration
>>  [EMAIL PROTECTED] "The golden rule is to test 
>> everything in the light of reason and experience, no matter from 
>> where
>
>> it comes."
>> Mohandas K. Gandhi
>>
>> _
>> _ _ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org

>> ARSlist:"Where the Answers Are"
>>
>
> __
> __
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org 
> ARSlist:"Where the Answers Are"
>
> __
> _ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org 
> ARSlist:"Where the Answers Are"
>


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

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

Re: FW: Field names in a list

[Heider, Stephen]

I want to be able to use a .def file as input. 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black
Sent: Monday, July 02, 2007 3:34 PM
To: arslist@ARSLIST.ORG
Subject: Re: FW: Field names in a list

Stephen,

Uh... why not use the API to get the values?

The def file format ( def or xml ) is not guaranteed in any way shape or
form. BMC could choose to encrypt the objects at the ARS server before
shipping the object back to the client API. Or they could just radically
change the file format in v7.1 or 8 or 9 without notice, or need to
"allow you to open a bug report against it." ( If they drop
functionality from the API you had better bet that you and others will
be screaming about the loss of functionality. )

--
Carey Matthew Black
Remedy Skilled Professional (RSP)
ARS = Action Request System(Remedy)

Love, then teach
Solution = People + Process + Tools
Fast, Accurate, Cheap Pick two.


On 7/2/07, Heider, Stephen <[EMAIL PROTECTED]> wrote:
> Would anyone out there have notes they would be willing to share?  I 
> would like to create a Class (in .net) that could be used to decode 
> these values so that it could be added to any ARS API .Net project.
>
> Stephen


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

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

Re: Email limitation ARS 6.3

[Heider, Stephen]

The body of html-template outbound email is limited to around 32,000
characters.  
 
I have a scheduled process that runs and sends me potentially lengthy
emails. I had to add a check for email length while it's generating, and
send the email when it gets above 30,000 characters. The process
continues sending me emails up to 30,000 characters until the entire
process is completely finished.
 
Stephen



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Shellman, David
Sent: Monday, July 02, 2007 5:48 PM
To: arslist@ARSLIST.ORG
Subject: Re: Email limitation ARS 6.3



Nicholas,

Not sure about ITSM but notify filters in the AR System server have a
bug that trims To and Cc to 256 characters.

Dave
--
[EMAIL PROTECTED] (Wireless)

- Original Message -
From: Action Request System discussion list(ARSList)

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

Re: Current connected users

[Heider, Stephen]

...or the API.
 
Stephen



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Shellman, David
Sent: Wednesday, July 04, 2007 10:13 AM
To: arslist@ARSLIST.ORG
Subject: Re: Current connected users


** 
Well there's always the user log also.
 
Dave



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of George Treisbach
Sent: Wednesday, July 04, 2007 8:47 AM
To: arslist@ARSLIST.ORG
Subject: Re: Current connected users


** 

 
"Can anybody suggest a way to get a list of connected uses to an
Action
Request System version 6.3?

Best regards,
Daniel"
 

If you want a list you can print, create a form and create an entry with
user and date/time information.  Use an active link to push information
whenever user opens a default form or opens 'any' form on the system.
Another active link MAY be able to update the entry with log-out
information when the client/mid-tier user is closed.
 
You could also create a display form with table to list the active
users.
 
G Treisbach
Harrisburg, Pa. USA
 
 
__20060125___This posting was submitted with HTML in
it___ __20060125___This posting was submitted with
HTML in it___

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

Re: Allow external code execution from Outlook

[Heider, Stephen]

Atul,

We have Outlook 2003 SP2 (with all patches), and use a similar process.
One of my emails is an HTML form sent by Remedy to managers to
approve/deny requests for access to applications or servers.  They
select their choice and click the Submit button. 

The html form posts their selection to an ASP.Net application, which in
turn, updates the Remedy ticket. The only thing I see different is that
you call a JSP file and I call an ASPX file. I am not a Java developer
(yet), but it seems that it shouldn't matter to Outlook.

I know in Outlook 2007 Microsoft disabled the ability to post data from
a submit button in an html form email...directly within Outlook.  You
can, however select the option to view the email in your browser, which
allows you to post the form data from a submit button.

Something to check: In Internet Explorer, Tools > Internet Options >
Security > Local Intranet click the Sites button.  Are all boxes
checked?  Click the Advanced button. Is the server with the JSP file
listed?

Are you trying to Submit the response from the email Preview pane? It
has been my experience that html forms that post do not work in the
Preview pane, and I have to open the email first.

Are you using IE 6 or IE 7?  Are the results the same in both versions?

Stephen


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Atul Vohra
Sent: Saturday, July 07, 2007 9:16 AM
To: arslist@ARSLIST.ORG
Subject: Allow external code execution from Outlook

Hi All,

In our remedy implementation, we were sending a "resolution email" to
the requester when their ticket was resolved. This email is an HTML form
with a submit button that executes a JSP code on our server and updates
the help desk status. The requester basically accept or reject the
solution from the email without getting back to the Help Desk ticket.

Now there is a new outlook patch (SR2 for Outlook 2003) where they can
not execute the code i.e. nothing happens when they click the "submit".
I read up about this Outlook patch and it stops external code execution.


But could not find a way to allow code execution from trusted sites (?)

I know this is not a remedy question but am hoping someone on this list
may have a clue.

Regards
Atul


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

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

Re: ARERR 623 AREA LDAP problem

[Heider, Stephen]

This might not be the same issue but just in case...  Was Windows Server
2003 SP2 installed recently?

Over the weekend SP2 of Windows Server 2003 was installed here.
Afterwards this caused errors such as "The operation could not be
performed because the OLE DB provider 'SQLOLEDB' was unable to begin a
distributed transaction" and "The ROLLBACK TRANSACTION request has no
corresponding BEGIN TRANSACTION".

SP2 changed the security settings of DTC which broke the SQL Linked
Servers.  Reconfiguring DTC fixed the issue. 

Stephen
 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Brad Terhune
Sent: Monday, July 09, 2007 10:24 AM
To: arslist@ARSLIST.ORG
Subject: ARERR 623 AREA LDAP problem

Good morning list!
Pardon my ignorance but I cannot figure this one out.  All of the users
that I have authenticating off our Active Directory cannot log in this
morning (all of a sudden, was working Friday).

Exchange and domain computer logins work fine on AD so it does not seem
to be directly tied to AD.

I have restarted the box and commented out the external authentication
line in the ar.cfg file and restarted the services.  Didn't work.  I
cannot find an error log that i can use but I don't know where to start
to look.

I am running ARS 6.3, Helpdesk 5.6 on a Windows Server 2003 box.
Oracle back end.  The Windows firewall is off.

Thanks,
Brad


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

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

Re: SQL 2000 SP2 & SP4 and Remedy (U)

[Heider, Stephen]

I have experienced no issues with SP4 since it was released.

Stephen 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Hennigan, Sandra H CTR OSD-CIO
Sent: Monday, July 09, 2007 3:50 PM
To: arslist@ARSLIST.ORG
Subject: SQL 2000 SP2 & SP4 and Remedy (U)

UNCLASSIFIED

I have been told that our Remedy database needs Microsoft's SQL SP2 and
SP4. 
Our environment:

Windows server 2003
ARS 6.3 patch 21
Help Desk 5.5
SLA 5

SQL 2000 SP1

Remedy Client 6.3 patch 20

I searched the BMC site to no avail - has anyone applied either of these
two patches?  Neither SP is new.  Any cares/concerns that I need to be
aware of before applying?  

Any assistance would be appreciated. Thanks.

Sandra Hennigan

Enterprise Remedy Administrator
Office # 703-602-2525 x251
CACI - Ever Vigilant

Apparently, there is nothing that cannot happen today.  Mark Twain


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

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

Re: ARSSOINFO - Windows client login

[Heider, Stephen]

Brandi,

What helped me with troubleshooting this is to remove the splash screen
that appears when the User Tool is starting.

Here is the subject of the thread from Feb 16, 2007:  
"Get Rid of the Splash Screen on User Tool - Resolved" 

HTH

Stephen

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Brandi Barbour
Sent: Wednesday, July 11, 2007 4:05 PM
To: arslist@ARSLIST.ORG
Subject: ARSSOINFO - Windows client login

I generated an arssoinfo.dll using Visual Studio 2005 C++ (MFC DLL).  I
copied the code that was included in the white paper and generate the
mentioned dll.  I specified a valid remedy user name.  Our Remedy Server
is not cross referencing blank password.  Area LDAP is not configured.
Our server is running with port mapper.  Everything compiles fine.  I
placed the dll in the same location as the user and alert programs.
When I launch either program I get the login dialog.  The white paper
claims that the dialog will appear if any errors are encountered when
either program attempts to load the DLL and call the 2 methods.   

1)  Is there any logging going on when I run either program to see
what's going on?  
2) What tool should I use to compile the dll?
3) Do you have compiled dll with source that you can send us that you
know works?  (We can modify it for our environment and recompile.)
4) Please provide any other information as you can regarding the
creation and usage of the arssoinfo.dll

Any help is appreciated..  
Thanks,
Brandi


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

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

Re: Submitter Mode - Locked ...Brute force? - Resolved!

[Heider, Stephen]

Isn't the Submitter field a required system field?  An error would
result if this field was blank.
 
Stephen



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Chintan Shah
Sent: Thursday, July 12, 2007 11:55 AM
To: arslist@ARSLIST.ORG
Subject: Re: Submitter Mode - Locked ...Brute force? - Resolved!


** 
Hello everyone,
Just an FYI.
'TR.Submitter' != $NULL$ would not work if you want to track the
following scenario:-
1. 'Submitter' field has a value in it and user  erased the value in it
and saved it. In that case 'TR.Submitter' would be NULL even though a
change occured on that field.
I would suggest to use , 'Submitter'!='DB.Submitter'. This would track
all records.

Thanks
Chintan.
Leigh Gruber <[EMAIL PROTECTED]> wrote:

** 
John,
 
THANK YOU so much.  With all the great ideas presented, this one
will require only a minimum of my time and is just the sort of solution
I was hoping to find.  As a side bar, I will make a second filter to
ensure that every form is at least touched during that week.  
 
To EVERYONE who helped contributed to this thread, THANKS for
all your help,
 
Leigh
 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of John Sundberg
Sent: Wednesday, July 11, 2007 10:59 PM
To: arslist@ARSLIST.ORG
Subject: Re: Submitter Mode - Locked ...Brute force?
 
** (off the top of my head - so some details are missing - but
you should get the point)

A technique to find if you can take advantage of submitter mode
locked:

Create a new table called "SubmitterChangeTracker" 
create a filter if 'TR.Submitter' != $NULL$ -- push a record to
SubmitterChangeTracker with schemaname, recordnumber, etc

Put that filter on Modify -- for all your schemas

Then let it run for a week -- if you find records in
SubmitterChangeTracker -- you will be able to track it down. 

etc...

-John


On 7/11/07, Leigh Gruber <[EMAIL PROTECTED]> wrote:
** 
Good Morning Listers,
 
We have an existing system operating with the Submitter Mode set
to Changeable.   This system has around 750 forms with a mix of Remedy
and home grown applications.  We need to change submitter mode to Locked
so we can host another custom application which must run in Submitter
Mode Locked.
 
I have 3 questions!
 
1. Is there any way, other than ones that require "brute force",
to determine if the original system has workflow that modifies the
submitter field?  I have set the development box to Submitter Mode
locked and tried some very limited record modification, but I don't have
any testing resources available.
 
Here's what I've tried so far on our dev system (Remedy 6.3; MS
SQL Server):

*   Analyzed Advanced search results on the
object_search_details form.  The selection criteria was ('Item Details'
LIKE "%Submitter%") AND NOT('Item Details' LIKE "%1 = 0%").  I haven't
seen a problem in resulting (100 or so) records. 
*   I've also checked the Submitter field #2 for other names
it may have.

 
2. Are there any "gotchas" I should know about that might cause
us problems if/when I change the production system?
 
3. Is it safe to assume that our Remedy/BMC applications will
NOT have workflow that writes to the Submitter form?
 
I would appreciate any words of wisdom you might have for me.
 
Many thanks,
Leigh Gruber
 
 
 
 
The information contained in this message may be privileged
and/or confidential. If you are not the intended recipient, or
responsible for delivering this message to the intended recipient, any
review, forwarding, dissemination, distribution or copying of this
communication or any attachment(s) is strictly prohibited. If you have
received this message in error, please so notify the sender immediately,
and delete it and all attachments from your computer and network. 
 
__20060125___This posting was submitted with
HTML in it___ 



-- 
John David Sundberg
235 East 6th Street, Suite 400B
St. Paul, MN 55101
(651) 556-0930-work
(651) 247-6766-cell
(651) 695-8577-fax
[EMAIL PROTECTED]
__20060125___This posting was submitted with HTML in
it___ 
__20060125___This posting was submitted with
HTML in it___ 




Yahoo! oneSearch: Finally, mobile search that gives answers

FW: Oracle SQL SELECT statement to find field LABEL - Now for SQL Server

[Heider, Stephen]

List,

Based mostly on the info below I created a SQL View that returns field
labels which is formatted for SQL Server 2000/2005.

The script inside the attached txt file creates one view
(uvw_ARSFieldLabels) and two supporting functions
(udf_DecodeFieldDataType, udf_DecodeFieldLabel)

To query, 
SELECT * FROM uvw_ARSFieldLabels WHERE SchemaName = 'HPD:HelpDesk'

HTH

Stephen

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Lin, Jason
Sent: Wednesday, December 20, 2006 6:49 PM
To: arslist@ARSLIST.ORG
Subject: Re: Oracle SQL SELECT statement to find field LABEL

Someone on the list posted the following query a while back and I found
it really useful. Can't remember the lister's name (kudo). You might
have to tweak it a little bit for your own use... Make sure to replace
the schemaid in the query

select vuiname, fieldName,
SUBSTR(SUBSTR(SUBSTR(propshort,INSTR(propshort, '\20\4\')+6),
INSTR(SUBSTR(propshort,INSTR(propshort, '\20\4\')+6),'\')+1),0,
SUBSTR(SUBSTR(propshort,INSTR(propshort, '\20\4\')+6),0,
INSTR(SUBSTR(propshort,INSTR(propshort, '\20\4\')+6),'\')-1))
"FIELDLABEL", a.fieldid,
decode(datatype,2,'Integer',3,'RealNum',4,'Char',
5,'Diary',6,'RadioBtn',7,'Date/Time',10,'Decimal',
11,'Attachment',12,'Currency',13,'Date',14,'Time',31,'Trim',33,'Table',3
4,'Column',35,'Page',
36,'Page Holder',37,'AttachPool',42,'View',43,'Flashboards')
from field a, field_dispprop b, vui c
where a.schemaId = 255 and a.schemaid = b.schemaid and b.schemaid =
c.schemaid and a.fieldid=b.fieldid and c.vuiid = b.vuiid and datatype !=
32 and proplong is null UNION select vuiname, fieldName,
SUBSTR(SUBSTR(SUBSTR(dbms_lob.substr(proplong,4000,1),
INSTR(dbms_lob.substr(proplong,4000,1),
'\20\4\')+6),INSTR(SUBSTR(dbms_lob.substr(proplong,4000,1),
INSTR(dbms_lob.substr(proplong,4000,1), '\20\4\')+6),'\')+1),0,
SUBSTR(SUBSTR(dbms_lob.substr(proplong,4000,1),
INSTR(dbms_lob.substr(proplong,4000,1), '\20\4\')+6),0,
INSTR(SUBSTR(dbms_lob.substr(proplong,4000,1),
INSTR(dbms_lob.substr(proplong,4000,1), '\20\4\')+6),'\')-1))
"FIELDLABEL", a.fieldid,
decode(datatype,2,'Integer',3,'RealNum',4,'Char', 5,'Diary',
6,'RadioBtn',7,'Date/Time',10,'Decimal',11,'Attachment',12,'Currency',13
,'Date',14,'Time',
31,'Trim',33,'Table',34,'Column',35,'Page',36,'Page
Holder',37,'AttachPool',42,'View',
43,'Flashboards') from field a, field_dispprop b, vui c where a.schemaId
= 255 and a.schemaid = b.schemaid and b.schemaid = c.schemaid and
a.fieldid=b.fieldid and c.vuiid = b.vuiid and datatype != 32 and
propshort is null UNION select vuiname,
fieldName,SUBSTR(SUBSTR(SUBSTR(propshort,INSTR(propshort, '\110\4\')+7),
INSTR(SUBSTR(propshort,INSTR(propshort, '\110\4\')+7),'\')+1),0,
SUBSTR(SUBSTR(propshort,INSTR(propshort, '\110\4\')+7),0,
INSTR(SUBSTR(propshort,INSTR(propshort, '\110\4\')+7),'\')-1)) "Field
Label", a.fieldid, 'Button' from field a, field_dispprop b, vui c where
a.schemaId = 255 and a.schemaid = b.schemaid and b.schemaid = c.schemaid
and a.fieldid=b.fieldid and c.vuiid = b.vuiid and datatype=32 and
proplong is null UNION select vuiname, fieldName,
SUBSTR(SUBSTR(SUBSTR(dbms_lob.substr(proplong,4000,1),
INSTR(dbms_lob.substr(proplong,4000,1), '\110\4\')+7),
INSTR(SUBSTR(dbms_lob.substr(proplong,4000,1),
INSTR(dbms_lob.substr(proplong,4000,1), '\110\4\')+7),'\')+1),0,
SUBSTR(SUBSTR(dbms_lob.substr(proplong,4000,1),
INSTR(dbms_lob.substr(proplong,4000,1), '\110\4\')+7),0,
INSTR(SUBSTR(dbms_lob.substr(proplong,4000,1),
INSTR(dbms_lob.substr(proplong,4000,1), '\110\4\')+7),'\')-1)) "Field
Label", a.fieldid, 'Button' from field a, field_dispprop b, vui c where
a.schemaId = 255 and a.schemaid = b.schemaid and b.schemaid = c.schemaid
and a.fieldid=b.fieldid and c.vuiid = b.vuiid and datatype=32 and
propshort is null order by 1

Hope it help.

Jason Lin
Programmer Analyst
UCSF - OAAIS - Remedy
1855 Folsom Street
San Francisco, CA 94143


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kirk
Sent: Wednesday, December 20, 2006 5:35 AM
To: arslist@ARSLIST.ORG
Subject: Oracle SQL SELECT statement to find field LABEL

Hello ARLIST,

I'm customizing the AR Message Catalog schema to allow select users to
update the Help details for schema fields.

I'm at the stage where I've added a SQL statement to present the user
with the english db field name and a char field to update the help text.

However since sometimes the db field name is not the same as the field
LABEL that the user would normally see I need to find that in the db
tables.

I've looked through the AR DatabaseRefGuide doc but can't determine the
proper table/column where this info is stored.

Does anyone know what the SELECT statement would be or what db table
this would reside in?

Thx in advance,
Kirk


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where
the Ans

Re: Convert to Remedy DATE field with SQL - SOLVED

[Heider, Stephen]

Got it...

UPDATE  Form_Name
SET Date_Field = (Create_Date / 86400) + 2440588

86400 = seconds in a day
2440588 = days from Jan 1, 4713 BC to Jan 1, 1970
(http://www.onlineconversion.com/julian_date.htm)

Stephen

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen
Sent: Friday, July 13, 2007 8:35 AM
To: arslist@ARSLIST.ORG
Subject: Convert to Remedy DATE field with SQL

List,

I added a Remedy DATE field (not DATE/TIME) to an existing form that has
many records.  I need to backfill the existing entries with the Date
portion of an existing Date/Time field.

What SQL command will populate a Remedy Date field with the date portion
of a Remedy Date/Time field?  

I looked at threads "Diary Field, Convert Seconds to Date" (May 1, 2007)
and "Question regarding "Date" field NOT the "Date-Time" field" (April
19, 2007).  I realize that the Remedy Date field represents the number
of days since Jan 1, 4713 BC.

I know I can accomplish this with a filter but it would take a long time
to run, and would update the Modified Date field on each record. With
SQL it would take only a few seconds to run.

Thanks.

SQL Server 2000
ARS 6.3

Stephen 


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

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

Convert to Remedy DATE field with SQL

[Heider, Stephen]

List,

I added a Remedy DATE field (not DATE/TIME) to an existing form that has
many records.  I need to backfill the existing entries with the Date
portion of an existing Date/Time field.

What SQL command will populate a Remedy Date field with the date portion
of a Remedy Date/Time field?  

I looked at threads "Diary Field, Convert Seconds to Date" (May 1, 2007)
and "Question regarding "Date" field NOT the "Date-Time" field" (April
19, 2007).  I realize that the Remedy Date field represents the number
of days since Jan 1, 4713 BC.

I know I can accomplish this with a filter but it would take a long time
to run, and would update the Modified Date field on each record. With
SQL it would take only a few seconds to run.

Thanks.

SQL Server 2000
ARS 6.3

Stephen 

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

OT: Validate XML in SQL Server 2000

[Heider, Stephen]

This is a SQL Server 2000 question yet will be used directly with
Remedy.

What I want to do is pass an XML document into a stored procedure.
Before I use the XML I need to validate it. The built-in module
sp_xml_preparedocument is supposed to perform this validation.  However,
if for any reason the document is not considered well formed the stored
procedure aborts with no way of trapping the error.

In SQL Server 2000 extended procedures can be created using C++ but I do
not yet program in this language.  With SQL Server 2005 this is not an
issue because I can write a .Net stored procedure and use TRY/CATCH.

The only way I can see to accomplish this is to write a .Net .exe file
and shell out.  For performance reasons I would rather not have to run
an executable from within a stored procedure.
 
Does anyone have a solution for validating an XML document within a SQL
2000 stored procedure?
 
Thanks.

Stephen 

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

Re: Can do a push field action on selection fields

[Heider, Stephen]

Are the fields on the form which receives the data Regular or Display
Only?

Stephen
 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Gretchen Beck
Sent: Wednesday, July 18, 2007 1:50 PM
To: arslist@ARSLIST.ORG
Subject: Can do a push field action on selection fields

Hi,

I'm hoping this is an easy problem (or else a known bug), but I'm
stumped. 
I've got a dialog box with a date field and three selection fields that
is supposed to push information to a form with identical date and
selection fields via an active link. The new form is created correctly,
and character fields are pushed, but nothing appears in the date or
selections fields. 
When I turn on active link logging, the log shows the actions were
successful, but when I open the form, the fields are empty.

I've been able to repeat these results with a separate dialog box and a
second form with just a single selection field...

This is on Arserver 6.03 and Aruser 6.0.

So, am I crazy, is there a workaround (besides just pushing to character
fields), or is this a bug?

Thanks!

Gretchen Beck
Carnegie Mellon


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

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

IsGroupMember, Not $USER $

[Heider, Stephen]

List,

This seems like an easy one, but I am drawing a blank this morning.

What built-in workflow command do you use to determine if another user
(not the currently logged in $USER $) is a member of a group?

For example, in workflow I want to see if UserA is a member of GroupB.
UserA is not the one that is logged in.

ARS 6.3, 7.0.1 
 
Stephen 

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

ARFilter, VB.Net - Return Multiple Values

[Heider, Stephen]

I decided to take a look at the ARFilter plugin.  I have some ideas
where this could be useful.

I created a script that returns a single value fine, but will not send
an array of values.  From the ARFilter readme.txt:

---
4) To return a value from script, set "result" to any value.  This can
be a
single value of a datatype (string, integer, etc.) or an array of
values.  In the case of a single value, $1$ in the plug-in return values
will contain
the returned value.  In the case of an array, $1$, $2$, $3$, etc. will
contain as many values as exist in the array. 
---

This very basic script returns the value of a single element:

dim test(1) as string
test(0) = "option A"
test(1) = "option B"
result = test(1)

When I change the last line to:  result = test   
I would expect that the array of values would be passed back to Remedy,
but all output parameters values are blank.

I then changed the script to this:

dim x as string = "1,2"
dim y As Array = Split(x, ",")
result = y

This produces the error: "Function without an 'As' clause; return type
of Object assumed. (ARERR "5000)"

I have found no examples of VB.Net code that return multiple values from
a Set Fields FilterAPI Filter.  Has anyone been able to get this to
work? 

ARS 6.3, VB.Net 2005
 
Stephen

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

Re: Service hanging

[Heider, Stephen]

Colby,

I have seen similar occurrences before.  I recall rebooting the server
corrected the situation. 

HTH

Stephen 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Zebel, Colby
Sent: Friday, July 20, 2007 6:07 AM
To: arslist@ARSLIST.ORG
Subject: Service hanging

Hi,

I'm seeing an issue where the Remedy service simply sits and hangs at a
'starting' status.  Nothing is logged in the Remedy, NT, or DB logs.  If
I point this app server at my dev database the service will start and if
I point the dev app server at this database the dev service does the
same thing.  Leading me to believe it's an issue with the database.  I
can connect from the app server to the database via odbcping and
enterprise manager and I have confirmed the correct ownership of objects
in the db.  This was working fine until an attempt was made to restart
the service early this morning.  Nothing has changed on the database
since the last restart.  Any ideas? I'm a little desperate...

Environment:
Win2k server (OS and remote DB)
ARS 7.0.1 patch 1
SQL Server 2000

Thanks!
Colby

Colby Zebel, Remedy Developer/Administrator Technisource (formerly
IntelliMark) Office - 717.790.0404 x5288 Mobile - 717.919.4738
[EMAIL PROTECTED] http://www.technisource.com


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

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

Attachments Drag-n-Drop Multiple Files

[Heider, Stephen]

List,

With our Remedy system users add attachments (Windows User Tool only)
via a single dialog I created. Screenshot attached.  The files are
stored in a separate form that only has attachments.  This has been
working fine for over a year.

A new requirement is to provide the ability to also drag-n-drop an
attachment onto the form as an option instead of using the File Add
window.  So, I display the Attachment Pool as a 10 pixel by 10 pixel
square that is positioned on top of the Add button.

Users can drag a file onto the tiny square and drop it when the plus
sign appears.  *Because there is no event that fires when an attachment
is dropped onto an attachment pool, the user still has to click the Add
button.

This works great. Now the requirement is to drag-n-drop multiple files
at one time.  So, I added several more Attachment Fields to the
attachment pool (5 total).  I can drag up to 5 files onto the form at
one time, followed by clicking the Add button.  Here is where it gets
interesting...

Sometimes it works fine - all the files are successfully dropped onto
the attachment pool.  However, about half the time the User Tool prompts
the user if they want to overwrite an existing file.

What is happening is this, if I drag 3 files onto the attachment pool I
get prompted to overwrite the 1st file with the 2nd file. Then I get
prompted to overwrite the 2nd file with the 3rd file.  The end result is
that only the last file ends up in the attachment pool.  

I have not found any pattern to this.  I am setting the Attachment
Fields to $NULL $ after each processing so I know it's not that. It even
sometimes occurs when I first open the attachments screen.

Why does this occur? Since my code is not changing between the times I
run it, I think it must be something with Remedy.
 
How are others using drag-n-drop with an attachments screen?

Thanks.
 
Stephen

ARS 6.3

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"
PK¤Bô6÷e˜xñc)untitled.JPGíWPSK—î›6„”MˆeS 
IÃê‚ ˆ([EMAIL PROTECTED]@AY‰

¢¨¼€,
a1d¹sQÐúGkfÞ_3So¦èÔ©tßþúëþÎ=}º/Ü¿3lìmAÀù
¸
PölÀÞ^H$À ¤FDlîDÝ1<„þZG!f¡ÀLäß|+Õ׾ɗM[Bv,v¢¸iî2YlHðk`
ŒµæëÏ×0Ö×Õ',5^îH£:R(ŽÛ"xXU]SûèyC㋗MͯZÚþä¶w|èìêîä

Œ~Ꮝë‚š,¿Ô¥€èBIH %¤ÆuA¨Ýã 
Ì<#IÅT©Ma¿iï“ÆZ1s¯Ü—Ñ6qý¬äþLvnIÛüqi_•ýׄÅýKʾû¡«LGCÈËC+8,Ê[Ÿ¡¸ |…EHµ
{”ÓÁÏòûTÿ¦¯õn|}~¯Ak=AjÉïKÌ\uíÞøœ:éö˜¹8E‹
3[f¥Ü靦œãâ¨rÑPp#«z~Ó
ÿ廄ñ¸m„~¼<}¸¾7ÃdÚ|–w‰ì¼8{uûz·¢ÿVbO½‘Côæ÷À`ôY!Õ+/;èo“"¹(ZÀÁgF'jFND,
:ï"Ã.e‡é‚®ga`é-[ºÕëaœµ¼ÑiNöǚ)ðèN(áþ)M…¤ 
ò¥Wnk‰/ëåúJÏòaÀYƒ²ÄuÇvl¦$Þsßõ(%´r—­zºÚ§sumph}Ω’²e}!· ëû±CÄÝÛÜbQïD»æzäÏuóNŬ
üŠO¥×²;Ӗ„}b†³s˗ÙæV°¥Ã×KÚxg8ª†±[Ö1ד¤  
¤¥¥i,¨¥­!÷ãÐ0{»Úæ[Ìãgì ¬½å¼0è?m;áýÆîÒ¬  ¯ýÄSO§žþßxzÍ—«ƒËiáó¼ßà 
Œž®Ä\ù$h>ó•«5O5¥ò¢†‰÷ÈYлe¿S¶R“GzOJæ}\¥PñvÑîõm½Ù)’4ê1³7ù 
„Û•þî¶ÍòÂA–XàšÔ_¶TJŸ°:ÖضML#„2ž5³)õvÝï²HÙ|TRÀ,íŸGE&5¨>¬%TUf‰ÊI[ÒªƒV=³ó²¢†DQQÑ¡†W4&¡Ä{ôδìіÆ?[Z›B„ÒÊʹâPü²ËüÍw4zµð=µ®âÁ¤Ž ï“­>å!/¼ºq
?…ŸÂÿà×`®Ï;¨å%¼9<ùn§ÁMHrßôz"ä2ÃÑ%õŸþ$%Ž´GòÑEψ“+Ùuš‰‡Uªî?Q­Ó_ûsŠHŸ¥usaH¥fˆGu‡£8‘ÓÇÒ¾r4û±zB>ïgø
  Ûi«öSԗâ]5
9¨y×-M5ٛ×ÌX\ñÀû§å»¢¡]’X%·ú¤F¼VoœW²ðèÇh’vµÜ䪣—‘„.hòf)ׯ—àïÝa9ÐëÊ7DT*#·†}¶&Ӕb&`ÏFÐ0°ÈG®`//[EMAIL
 PROTECTED]/X$½­ýî”IÇ7MvGþ½97aµÖÉ0Qç:l¤Þ毐±Ú(ݘTe”©žÝ6œ÷IŸòƒ3‰¡ÑH±Ö   
™­™ËÀàÍ®å~o‘æ1M)[EMAIL 
PROTECTED])Ð~Ž‡<©4½JŒ=çxSurÔ֘õö%c…u²ûU¼Yü˜ëüÅ8•%ôÛØÀØw¡;–ô/Ðàs5DŸñ6ù^ú÷¯òÅ¥ÉÞ¿·Éÿ˔Çò,oz—0V–Ù(ñ.ɔ/÷èôt¢ï+åšzš [EMAIL PROTECTED]
ÕlŽÀvp,@„…< ¯f³}
HRÁ‡÷âHæ—äí¼/4K,ä‘à¨ږð…Ä@ç°ýÓ²œÓ6T7ä"
HBžö€ú»ÎÏc›‘]ڙ¡qI,¤C
&ÏÈ3
xuÉ¢éٕÝ)Rˆï6Çh¿Š5Vq(€ŒDǘ¤Ð+¦ËŸ%OMø7P©†žÆ_VolI·Êÿy
IYŠ1ÿ/
`€‹¤ÎýÙ'a8Ï8…
|pEŸ,Rõ̋Åó#–9®ì8²ñùž™xؤ6ƒ%¯à+÷)}£³SÌöÏçàQ‡“üïy¬M€æîÁÅ7¾áW*ëÅøìÑÎyöz°pÈ#¿8\P·íŽŸò´$ôF7ŸÌëÈÕw
w8×ç¬aªFûèÀyÚ'̳uG
g¡;ꝢûF‡ÎíF6«NØ$~‚…ÖÓ92¤¥0˜c¢#üÌây.qÁl­€Õeó*œŸÐ«. R¯M 
NsÖL"jÿSZ{¯²M´"ì΍±™££gOx›yœQ3¿l¦Ù¾s;ïd9¸(Ô+—&–¤F/6—{}÷î–s!]n| ®
nñt.Gm¡
²cU#´û†³o»í½Y­6í¬SÐÑS¾Œ‰ä6G1ÀY{e³8«(¹µÔ¤·E7|í”Å}ËEÁtäÄê|;~˜úÇsï±.zʹ.”Á÷‡ÉßkgòbµxÞbZûø
8Y
 öÄO§ÀSàÿ~ðD£°½”ŸÖžÎ•Ðð¼BÁWÓV’ƒçø—0Yeí»ÁF*
‹([EMAIL 
PROTECTED]'ZìMµŸÜÒWM!&«%_Q"ûށ¶Ø¨Qéu5AƒÜ[\ûU¹„ö‚:ó‘ËÛsJ¥qïã“ä‹
W?s™
Ö!~
ÛiD*÷P,Nílñt>qþ Zc·WíK¡äJ)L1cŒ~XØÝÙYÞ_ÕQæîKô¾cc([EMAIL PROTECTED]|[EMAIL 
PROTECTED]||võÖ»ZÅÙ¹ü‘Üuëû.[Æ·ÄÎbžRÿ|ª)¬Ëä   
1VŸ÷³­J¦:º”¼%y‚ã¡ÃØõ¼ÂGWwt$ËZ"zÝö†D~‚t±Pà·þsÓªôô–¤Ðäæž;íŒ?
„%=qMùåÃOa0oõS`§öû‚¶Ý«#lG…ҁ9ÓæbŸV’lËt]'u\)bXõH«´gaȪ3e¸K4¾|9ÔCOëòxÈTžjÓÖ£7'Èo•°x¼±¤
 
lti¬q»F»‹„à;œqö˼1×W0¨¾*ræ-–Jìk|F­-—1m=xdØÚéŽ;5œ†nÎȌ¯Ë,T\sõÞ§ããK>Q®’–NF™.˜ÄÊF*Š5Î]ª^š#“^¸¥^n†yÎD´¸

õ<æ¶}ô‰õ-›ÝÍnÂ}µ=œ­´ÀóÛ*Ï5çvÌ´c퀢ÙP·“q.¤»Wx—.®!ìä¶&3¡ßVµvX9¸`Ì`8g–J
¿4·»
e´·^Ì²áú—Þ
Ê9RÔßµÕUœ—ï±é6*ÅÈ?1óü­cjd a3æÆÖÔö:’1Øý±ÆvjÿÁáV>ðùY¦[N3%PQ‚$’ÂÉõSaÐd-<àLVé–è6}sëšq‰ÔÙ>cKFÅÅõ
˟pt:[EMAIL 
PROTECTED]'9¹3ð¨û+ÅøÚÄÙ4ô‘;Ռ†”sý2—x\ßY[«ÊË>u֜ö‰܊Dëý

Re: BUW 2007 Track Sessions Announced

[Heider, Stephen]

Can you imagine using an IDE like Visual Studio for Remedy development?  That 
would be very nice - Remedy.NET.
 



From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Pierson, Shawn
Sent: Friday, July 20, 2007 9:59 AM
To: arslist@ARSLIST.ORG
Subject: Re: BUW 2007 Track Sessions Announced


** 
I would add that a big problem with this is that ITSM 7 is extremely buggy, 
harder to use than previous versions, and extremely expensive.  AR System 
development is what kept Remedy alive, and by de-emphasizing the strong point 
of Remedy, I see AR System and ITSM usage declining in the future.  I have 
heard from a lot of people that their management is looking forward to the ITSM 
release from Microsoft because they think it will be more integrated with other 
systems.  While I think the Microsoft product is not going to be that good in 
the first release, it will improve, and if BMC does not improve the quality of 
ITSM and go back to selling AR System itself as a major product, Microsoft will 
put them out of the IT service management business.
 
Shawn

-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL 
PROTECTED] On Behalf Of Rick Cook
Sent: Thursday, July 19, 2007 7:18 PM
To: arslist@ARSLIST.ORG
Subject: Re: BUW 2007 Track Sessions Announced


** 
I think that Susan has a point, and to make a more specific 
observation, the de-emphasis of the AR System as a development platform, making 
BMC's defacto focus on it just being a willing and able container for the 
ITSM/CMDB, has led to less custom work going on these days.  This in turn leads 
to fewer people able to talk about innovative things they're doing, because 
it's increasingly out of the mainstream that it once would have been in the 
middle of.  Not to say that there isn't custom work, it's just that privacy 
concerns are probably keeping most govt. apps private, and most private 
entities are going ITIL/ITSM these days, because that's all that BMC sells to 
them. 
 
Not necessarily blaming BMC for that, just saying that this is a 
foreseeable byproduct of their product direction, exacerbated by the fact that 
many of us are neck deep in trying to figure out what the  BMC was thinking 
in some of the feature decisions with ITSM. 
 
Maybe THAT would be a good breakout - Gap analysis between ITSM 7.0.2 
delivered functionality and what customers are actually wanting it to do, both 
raising awareness for prospective customers and giving some ideas for bridging 
those gaps for both future and present deployers of the apps. 
 
Rick
 
On 7/19/07, Susan Palmer <[EMAIL PROTECTED]> wrote: 

** 
David,
 
Maybe there is an unspoken message that bmc should be listening 
too.  There generally is no lack of submissions by non-host presenters.  Since 
the advent of the various version 7 products there has been an aura around 
Remedy that is disconcerting to some degree.  Last year we gathered over a 100 
topics of interest.  This year few if any topics were suggested here.  That in 
itself is very unusual.  
 
Thoughts to mull over 

 
Susan

 


 
On 7/19/07, Easter, David <[EMAIL PROTECTED] > wrote: 

** 

> I, too, was disappointed with the dearth of non-BMC 
presenters.  
 
We too were disappointed in the number of customer 
submissions.  If anyone missed the submission deadline but has a desire to 
present, please feel free to send me a direct E-mail with your topic and 
synopsis.  We still have some ability to move things around to accommodate 
customer presentations.  It doesn't necessarily have to be a development 
training session - we'd love to have customers present their honest (but 
hopefully positive) experience with BMC products too! 
 
Thanks,
 

-David J. Easter
Sr. Product Manager, Service Management Business Unit
BMC Software, Inc.
 
The opinions, statements, and/or suggested courses of 
action expressed in this E-mail do not necessarily reflect those of BMC 
Software, Inc.  My voluntary participation in this forum is not intended to 
convey a role as a spokesperson, liaison or public relations representative for 
BMC Software, Inc. 




From: Action Req

Re: Question about EntryFieldValueList

[Heider, Stephen]

Should [ String formName = "HPD:Help Desk"; ] be [ String formName =
"HPD:HelpDesk"; ] instead?   No space between Help and Desk.

Stephen

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of bswrchrd
Sent: Sunday, July 22, 2007 11:57 PM
To: arslist@ARSLIST.ORG
Subject: Question about EntryFieldValueList

I am newbie and trying to display the values in the fields associated
with a entryfieldvaluelist using the following C# code:

using System;
using System.Collections.Generic;
using System.Text;
using BMC.ARSystem;
using BMC.ARSystem.Utilities.Common;

namespace BMC.ARSystem
{
public class Search
{
static void Main(string[] args)
{
if (args.Length == 0)
{
Console.WriteLine("No arguments submitted");
Console.ReadLine();
return;
}

String serverName = string.Empty;
String userName = string.Empty;
String password = string.Empty;
String formName = "HPD:Help Desk";

try
{
serverName = args[0].ToString();// first arg-the
key
userName = args[1].ToString();   // second arg-the
value
password = args[2].ToString();   // third arg-the
value
}
catch
{
Console.ReadLine();
return;
}

{
ARSystem.Server ARServer = new ARSystem.Server();
ARServer.Login(serverName, userName, password, "");

String qual = "1=1";

BMC.ARSystem.EntryListFieldList elfl = new
BMC.ARSystem.EntryListFieldList();
elfl.AddField(0);

BMC.ARSystem.EntryFieldValueList efvl = new
BMC.ARSystem.EntryFieldValueList();
efvl = ARServer.GetListEntryWithFields(formName, qual,
elfl, Convert.ToUInt32(0), Convert.ToUInt32(99));

int i = efvl.Count - 1;
int j;
for (j = 0; j < i; i += 1)
{
string entryID = efvl.Item(i).EntryID;
Console.WriteLine(entryID);

}
}
}
}
}

I keep receiving an error :

Error   1   'BMC.ARSystem.EntryFieldValueList' does not contain a
definition for 'Item'   C:\VS2005\Projects\RemedySearch\RemedySearch
\Program.cs 59  47  RemedySearch

What's weird is that I built a Powershell script that will retrieve the
data, everything is fine, but I would like to be able to compile the
code. I know I'm missing something but I can't figure out what is it. If
anybody can see it TIA.


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

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

Re: Remedy and Programming Languages

[Heider, Stephen]

Andy,

Because ARS is a database-centric platform, I think learning SQL
programming (any flavor) is beneficial.  Knowing how to access the raw
data and integrate it with other database applications is good to know.

The second is an ARS API language. Java and C are directly supported, so
if you just starting out with programming I would choose one of these.
For me, I prefer VB.Net because I have a number of years experience
developing in VB.Net, VB, and VBA.  

Stephen
 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Mayfield, Andy L.
Sent: Monday, July 23, 2007 12:13 PM
To: arslist@ARSLIST.ORG
Subject: Remedy and Programming Languages

I would like some opinions from all my great friends here on the
ARSlist. 

If you had to choose one programming language to learn (for use
with Remedy) which one would you choose?

Thanks in advance. 

Andy L. Mayfield
Sr. System Operation Specialist
Alabama Power Company
Office: 8-226-1805
Cell: 288-9140
SoLinc: 19140

 <> 


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

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

Re: Attachments Drag-n-Drop Multiple Files - SOLVED

[Heider, Stephen]

It worked when I shrank the attachment pool from 10x10 to 7x7.

Stephen 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen
Sent: Friday, July 20, 2007 8:54 AM
To: arslist@ARSLIST.ORG
Subject: Attachments Drag-n-Drop Multiple Files

List,

With our Remedy system users add attachments (Windows User Tool only)
via a single dialog I created. Screenshot attached.  The files are
stored in a separate form that only has attachments.  This has been
working fine for over a year.

A new requirement is to provide the ability to also drag-n-drop an
attachment onto the form as an option instead of using the File Add
window.  So, I display the Attachment Pool as a 10 pixel by 10 pixel
square that is positioned on top of the Add button.

Users can drag a file onto the tiny square and drop it when the plus
sign appears.  *Because there is no event that fires when an attachment
is dropped onto an attachment pool, the user still has to click the Add
button.

This works great. Now the requirement is to drag-n-drop multiple files
at one time.  So, I added several more Attachment Fields to the
attachment pool (5 total).  I can drag up to 5 files onto the form at
one time, followed by clicking the Add button.  Here is where it gets
interesting...

Sometimes it works fine - all the files are successfully dropped onto
the attachment pool.  However, about half the time the User Tool prompts
the user if they want to overwrite an existing file.

What is happening is this, if I drag 3 files onto the attachment pool I
get prompted to overwrite the 1st file with the 2nd file. Then I get
prompted to overwrite the 2nd file with the 3rd file.  The end result is
that only the last file ends up in the attachment pool.  

I have not found any pattern to this.  I am setting the Attachment
Fields to $NULL $ after each processing so I know it's not that. It even
sometimes occurs when I first open the attachments screen.

Why does this occur? Since my code is not changing between the times I
run it, I think it must be something with Remedy.
 
How are others using drag-n-drop with an attachments screen?

Thanks.
 
Stephen

ARS 6.3


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

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

Re: Say what about that knowledge base?

[Heider, Stephen]

Dave,
 
Here is the email that may answer your question.




From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Stephen
Sent: Wednesday, May 16, 2007 10:24 AM
To: arslist@ARSLIST.ORG
Subject: New Open Source .Net App Available - ARS_KBImport


** 

I just released a new .Net console application on ARSWiki that provides
the ability to automatically import kb web pages into a Remedy form.
Once in Remedy, you can perform searches using regular ARS search
options (equal, not equal, like, and, or, not, less than, greater than,
etc.).

 

Periodically people on the List have asked about the application I wrote
a year and a half ago.  Although the original version worked I wanted to
completely rewrite it before releasing to improve the performance and
make the code more readable. 

 

As Remedy developers, much of our development time is spent automating
tasks and improving efficiency.  When you view a kb you could copy/paste
the information into a Remedy form and attach the web page [that is
automatically copied to your internet temp folder] in an attachment
field.  This app automates the process.  It imports the kb web page and
parses it into individual fields, from which you can search.

 

The initial reason for creating this was because for a period of 4-6
months the supportweb KB search engine would lock up after performing
one or two searches.  I would have to close all browser windows and
start over to perform another search.  Additionally, I wanted the
ability to specify more detailed searches than what was available
online.

 

The readme.txt has all the details to install, but basically you import
one form and copy a few files to a new folder.  The .Net 2.0 runtime and
the current ARS .Net API need to be installed prior to running or
developing.  Tested with ARS 6.3 and 7.0.

 

I would like to thank Jason Miller, Nii Addy, and Brent Goodman for
their testing.  Their feedback and suggestions helped in making this a
more useful tool.

 

Please post any comments or suggestions on the new ARSWiki mailing lists

 

Main Projects Page

http://arswiki.org/projects/dotnetutil

 

Downloads

http://arswiki.org/projects/dotnetutil/downloads

 
Stephen



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Shellman, David
Sent: Thursday, July 26, 2007 8:45 AM
To: arslist@ARSLIST.ORG
Subject: Re: Say what about that knowledge base?



No need to feel silly.  I tried to use Fire Fox for many months before I
worked with the Customer Cares folks (Support can't help).

Hopefully Stephen can give us an explanation of how his tool can
retrieve data from the BMC/Remedy knowledgebase.


Dave
--
[EMAIL PROTECTED] (Wireless)

- Original Message -
From: Action Request System discussion list(ARSList)

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

Re: Open Excel doc from a Command Line process

[Heider, Stephen]

Henry,
 
It must be "ARS Wiki" day :)
 
I created a utility that obtains the Excel path (and other values) for
the installed version and store it in a Global Field.  Then, when I need
to run Excel I use the value inside this field.  The name of the utility
is WksInfo. http://arswiki.org/projects/dotnetutil  
 
 
Another approach would be to use a series of Set Fields $PROCESS $
commands to test the existence of the application file.  For example:
 
$PROCESS$ cmd.exe /c "if exist """$zTmpField1$""" (echo Yes) else (echo
No)"
 
Set zTmpField1 to "C:\Program Files\Microsoft
Office\OFFICE11\Excel.exe". If it doesn't exist then try it with
"C:\Program Files\Microsoft Office\OFFICE10\Excel.exe", and so on until
you find.
 
Stephen



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Douglas, Henry
Sent: Thursday, July 26, 2007 11:12 AM
To: arslist@ARSLIST.ORG
Subject: Open Excel doc from a Command Line process


** 

Hello ARSList

I am rewriting several "hard coded" functions on the system I have
inherited. The latest is a Run Process command to open Excel a user
maintained spreadsheet. The current working Command Line in the Run
Process action is: C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE
\\servername\drive\folder\filename.xls

I need to rewrite this to function for multiple versions of excel not
just from the OFFICE11 install directory. I have tried many interactions
with no success even some that work from Start Run in windows but not
from the User tool. TIA

 

Thanks

Henry

 

STATEMENT OF CONFIDENTIALITY: The information contained in this message
or any attachments to this message are intended only for the person(s)
or entity to which it is addressed and may contain confidential and/or
privileged material as well as being protected from disclosure. Any
review, retransmission, dissemination or other use of, or taking of any
action in reliance upon, this information by persons or entities other
than the intended recipient is strictly prohibited. If you received this
in error, please contact the sender immediately and delete the material
from any computer. __20060125___This posting was
submitted with HTML in it___

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

Re: Say what about that knowledge base?

[Heider, Stephen]

Louise,

This was the primary reason I created the ARS_KBImport utility. Perhaps
this may be a solution for you.  

HTH
 
http://arswiki.org/projects/dotnetutil
Click on the Downloads link to download the utility.

Stephen


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of E. Louise van Hine
Sent: Thursday, July 26, 2007 6:36 AM
To: arslist@ARSLIST.ORG
Subject: Say what about that knowledge base?

I haven't been able to get a search to run on the BMC Knowledge base,
even when I select a product.  I have just put in a support request for
it, but perhaps someone else has a tip or trick for running a search,
because keyword searching with that top panel does not seem to function
without a huge JSP error. 

Could it have something to do with running Mozilla Firefox 2.0?


--
Regards,

Louise van Hine
KTSL Limited
[EMAIL PROTECTED]


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

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

Re: ARServer.exe crashing

[Heider, Stephen]

Rogerio,

It may be due to SQL Server 2005 not being supported with v5.1.2. 

Stephen

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Rogerio
Sent: Monday, July 30, 2007 10:09 AM
To: arslist@ARSLIST.ORG
Subject: ARServer.exe crashing

Hi everyone,

Need some help. We are receiving this error randomly during the day:

"AR System Server Executable (SQL Server) encountered a problem and
needed to close"

Then I see this in event viewer:

" Faulting application arserver.exe, version 5.1.2.0, faulting module
ntdll.dll, version 5.2.3790.3959, fault address 0x0001bd02."

Anyone have seen this before or have any idea about?

Enviroment:

ARS 5.1.2 - Windows 2003 SP2 - SQL Server 2005

Thanks,


Rogerio Bronzoni Aguiar
CMagnani


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

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

Re: ARServer.exe crashing

[Heider, Stephen]

Rogerio,

I understand. I wish I had a better answer for you.  Has Windows or SQL
been updated recently (ie. security patches, service packs)?

Stephen


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Rogerio
Sent: Monday, July 30, 2007 10:19 AM
To: arslist@ARSLIST.ORG
Subject: RES: ARServer.exe crashing

Stephen,

The fact that is not supported doesn't mean that doesn't work. We have
used this configuration since a long time and the error appeared
recently.

Thanks,


Rogerio Bronzoni Aguiar
[EMAIL PROTECTED]
(11)2168-3705
 

-Mensagem original-
De: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Em nome de Heider, Stephen Enviada em:
segunda-feira, 30 de julho de 2007 11:10
Para: arslist@ARSLIST.ORG
Assunto: Re: ARServer.exe crashing

Rogerio,

It may be due to SQL Server 2005 not being supported with v5.1.2. 

Stephen

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Rogerio
Sent: Monday, July 30, 2007 10:09 AM
To: arslist@ARSLIST.ORG
Subject: ARServer.exe crashing

Hi everyone,

Need some help. We are receiving this error randomly during the day:

"AR System Server Executable (SQL Server) encountered a problem and
needed to close"

Then I see this in event viewer:

" Faulting application arserver.exe, version 5.1.2.0, faulting module
ntdll.dll, version 5.2.3790.3959, fault address 0x0001bd02."

Anyone have seen this before or have any idea about?

Enviroment:

ARS 5.1.2 - Windows 2003 SP2 - SQL Server 2005

Thanks,


Rogerio Bronzoni Aguiar
CMagnani


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



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


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

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

Re: ARServer.exe crashing

[Heider, Stephen]

Rogerio,

After googling this
http://www.google.com/search?q=0x0001bd02+ntdll.dll&btnG=Search (not
many matches)

I found one solution that might help 
http://www.svnforum.org/2017/viewtopic.php?p=9633&sid=a8dd34e057a8dd4f1c
8f7131a76a1bf0

"In the C:\WINDOWS\ServicePackFiles\i386 to change ntdll.dll for
ntdll.old"

Stephen

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen
Sent: Monday, July 30, 2007 10:20 AM
To: arslist@ARSLIST.ORG
Subject: Re: ARServer.exe crashing

Rogerio,

I understand. I wish I had a better answer for you.  Has Windows or SQL
been updated recently (ie. security patches, service packs)?

Stephen


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Rogerio
Sent: Monday, July 30, 2007 10:19 AM
To: arslist@ARSLIST.ORG
Subject: RES: ARServer.exe crashing

Stephen,

The fact that is not supported doesn't mean that doesn't work. We have
used this configuration since a long time and the error appeared
recently.

Thanks,


Rogerio Bronzoni Aguiar
[EMAIL PROTECTED]
(11)2168-3705
 

-Mensagem original-
De: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Em nome de Heider, Stephen Enviada em:
segunda-feira, 30 de julho de 2007 11:10
Para: arslist@ARSLIST.ORG
Assunto: Re: ARServer.exe crashing

Rogerio,

It may be due to SQL Server 2005 not being supported with v5.1.2. 

Stephen

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Rogerio
Sent: Monday, July 30, 2007 10:09 AM
To: arslist@ARSLIST.ORG
Subject: ARServer.exe crashing

Hi everyone,

Need some help. We are receiving this error randomly during the day:

"AR System Server Executable (SQL Server) encountered a problem and
needed to close"

Then I see this in event viewer:

" Faulting application arserver.exe, version 5.1.2.0, faulting module
ntdll.dll, version 5.2.3790.3959, fault address 0x0001bd02."

Anyone have seen this before or have any idea about?

Enviroment:

ARS 5.1.2 - Windows 2003 SP2 - SQL Server 2005

Thanks,


Rogerio Bronzoni Aguiar
CMagnani


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



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


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


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

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

Re: Associating .ARTASK Files to VBS

[Heider, Stephen]

Norm,
 
You should be able to change the associated program for file extensions
here: My Computer > Tools > Options > File Types > file extension.
 
How are you handling the User Tool authentication?  The Windows user
name is easy enough to capture, but how do you handle feeding the User
Tool the password?  Or how are you bypassing the password?
 
 
Stephen




From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96
CS/SCCE
Sent: Monday, July 30, 2007 11:40 AM
To: arslist@ARSLIST.ORG
Subject: Associating .ARTASK Files to VBS


** 

Hello everyone:

 

I have a creative problem and I'd sincerely appreciate any/all
suggestions or ideas.  I don't even know if what I'm trying to do is
possible, but I'm open to all ideas.

 

I've written a neat little application that, when executed, launches the
Remedy User client and logs the user on automatically.  What I really
like about it is that it also works with .artask attachments.  That is,
Remedy shoots the user a message: "You have a ticket assigned to you.
Click the attachment below to view it." The user double clicks the
attachment, and my executable first checks to see if Remedy is running.
If it is not, it launches Remedy as the user logged on to the OS, and
then it launches ARTask, which in turn, displays the ticket.

 

It's a very simple (poor man's) SSO.  It works great.

 

Here's the problem.  The application I wrote is, well, an application.
That is, it's an .EXE.  In my environment, putting new .EXE files on
workstations is a no-no, but putting scripts (such as VBS) is perfectly
fine.  So I completely re-wrote the application as a VB script.  It
works fine...except for the .ARTASK association.  Evidently in Windows
XP, one cannot associate a file to be run by a VB script the way one
would, say, associate a .DOC file be opened with Word.

 

So now I'm stuck.  I need some way to change the file association of
.ARTASK to ARtask.exe to .ARTASK to custom VBS.  Any ideas?

 

Norm

__20060125___This posting was submitted with HTML in
it___

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

EIE 7.0.1 p5 Install

[Heider, Stephen]

List,

I am trying to install EIE 7.0.1 patch 5 and the installation program
can not authenticate any Remedy user.  I also tried removing the
password for Demo.

I disabled all external authentication (it was using LDAP) and restarted
the services.

No other ARS applications are installed, other than those that come with
the base ARS Server package.

Any ideas?

Stephen 

Windows Server 2003
ARS 7.0.1 p3, using Port Mapper
SQL Server 2005 

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

Re: EIE 7.0.1 p5 Install - SOLVED

[Heider, Stephen]

Right. I disabled external auth before removing the Demo password.
 
The cause: Min API Level.  It was set to version 7 in the Admin Tool.  I
cleared it and restarted the services, then it worked.
 
 
I wish BMC would address this issue of installers and the API level.
EIE 7 is a version 7 application and should use the version 7 API.  If
they must use old API's to install new applications then at least
display an accurate error message.  
 
BMC makes all the software involved: ARS, API, EIE.  Their installation
programs should test to see if the login error is due to Min API Level
and report it to the installer.  
 
At the very least they could compile a [very] tiny v7 API console
application that uses the v7 API to report back to the installer the Min
API Level.
 
Stephen



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Roger Justice
Sent: Wednesday, August 01, 2007 4:35 PM
To: arslist@ARSLIST.ORG
Subject: Re: EIE 7.0.1 p5 Install


** When you removed the Demo password the system will try to authenicate
with the AD you must have a Demo password.


-Original Message-
From: Heider, Stephen <[EMAIL PROTECTED]>
To: arslist@ARSLIST.ORG
Sent: Wed, 1 Aug 2007 3:40 pm
Subject: EIE 7.0.1 p5 Install


List,

I am trying to install EIE 7.0.1 patch 5 and the installation program
can not authenticate any Remedy user.  I also tried removing the
password for Demo.

I disabled all external authentication (it was using LDAP) and restarted
the services.

No other ARS applications are installed, other than those that come with
the base ARS Server package.

Any ideas?

Stephen 

Windows Server 2003
ARS 7.0.1 p3, using Port Mapper
SQL Server 2005 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
<http://www.arslist.org/>  ARSlist:"Where the 
Answers Are"



AOL now offers free email to everyone. Find out more about what's free
from AOL at AOL.com <http://www.aol.com?ncid=AOLAOF0002000437> .

__20060125___This posting was submitted with HTML in
it___ 

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

OT: Attachement Updation - File Contents Changed

[Heider, Stephen]

Hugo,
 
Your post got me thinking: How can you determine if the file contents
have changed?  I have wanted to create something like this for a
while... so I just wrote this SQL Server 2000 function that returns the
checksum of an attachment field (actually any field of Image data type.
The current and new values could be compared to see if it changed.  You
can also use this to find duplicates in the attachment fields in your
system.
 
CREATE FUNCTION dbo.udf_GetImageChecksum
(
 @ImageField IMAGE 
)
RETURNS INT
AS
BEGIN
 DECLARE @Len BIGINT,
   @Pos BIGINT,
   @CheckSum VARCHAR(8000)
 
 SET @Len = DATALENGTH(@ImageField)
 SET @Pos = 1
 SET @CheckSum = ''
 
 WHILE @Pos < @Len
 BEGIN
  
  SET @CheckSum = @CheckSum + CONVERT(VARCHAR,
BINARY_CHECKSUM(SUBSTRING(@ImageField, @Pos, 8000)))
 
  IF LEN(@CheckSum) > 7900
   SET @CheckSum = CONVERT(VARCHAR, CHECKSUM(@CheckSum))
 
  SET @Pos = @Pos + 8000
 END
 
 RETURN CHECKSUM(@CheckSum)
END
 
In a Set Fields SQL command:
 
SELECT dbo.udf_GetImageChecksum(c536880912)
FROM b611c536880912
WHERE entryId = 'ATTACH16929'
 
 
HTH someone.
 
Stephen



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Hugo Visser
Sent: Thursday, August 02, 2007 5:15 AM
To: arslist@ARSLIST.ORG
Subject: Re: Attachement Updation


** You cannot compare the file contents, but using TR you should be able
to detect that a file was attached again (if the DB value wasn't
$NULL$). The "value" contains the file size in bytes, the compressed
size in the DB and the full filename on the client. 

Also note that user cannot change the attachment from the attachment
field without re-attaching it. Just changing the attachment
(open->edit->save) doesn't update the DB, it only updates the local
temporary copy of the file. 

Hugo


On 8/2/07, Meenakshinathan <[EMAIL PROTECTED]> wrote: 

Hi Robert,

Thanks for the information.

Anyhow this solution is not working. Remedy stores the
attachments in
the following way ,(i am
sure. but
it might bytes),. 

I am not user this TR and DB can apply for attachement fields.

can any one give me a alternative solution on this? Looking for
your
inputs.

Thanks,
Meenakshinathan


On Jul 28, 2:36 am, Robert Halstead < [EMAIL PROTECTED]>
wrote:
> I'm not entirely sure on this, but couldn't you do a filter on
modify
> with a run-if condition as: 'TR.Attachment' != '
DB.Attachment' ??  I'm
> not entirely sure how remedy stores the attachments.  It might
> work
>
> Anyone else ??
>
> On 7/27/07, Meenakshinathan < [EMAIL PROTECTED]
 > wrote:
>
> > Hi Listers,
>
> > In my application, at first stage users can attach 3-4
files. when the
> > request assinged to next stage, that next stage user can
edit or 
> > modify the attachment and can upload it again. In this stage
my client
> > has an requirement like, first stage user to be notified
whenever any
> > attachement is updated. If anybody came throrough this , can
you 
> > please let me know how do i implement this?
>
> > Thanks,
> > Meenakshinathan
>
> >

___-
> > UNSUBSCRIBE or access ARSlist Archives
atwww.arslist.orgARSlist:"Where the Answers Are"
>
> --
> "A fool acts, regardless; knowing well that he is wrong. The
ignoramus
> acts on only what he knows, but all that he knows. 
> The ignoramus may be saved, but the fool knows that he is
doomed."
>
> Robert Halstead
>
>

___-
> UNSUBSCRIBE or access ARSlist Archives
atwww.arslist.orgARSlist:"Where the Answers Are"



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



__20060125___This posting was submitted with HTML in
it___

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

Re: OT: Attachement Updation - File Contents Changed

[Heider, Stephen]

I agree.  I would like to see this built in to ARS - obtaining the
checksum is very simple in a compiled language such as C or .Net.  This
info should also be available on a display only form/field (eg. before
it gets pushed back to the server).
 
Along with checksums, the file size should be obtainable on a display
only form/field.  As it is now a file has to be pushed back to the
server in a form to get the file size.  In active links I would like to
know if a file is too large [for the user, based on permissions] prior
to pushing it back to the server.
 
Stephen



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Hugo Visser
Sent: Friday, August 03, 2007 4:31 AM
To: arslist@ARSLIST.ORG
Subject: Re: OT: Attachement Updation - File Contents Changed


** Stephen,

That's very clever, thanks for sharing :) Maybe BMC should put some kind
of PERFORM-ACTION-FOOBAR to do this in a DB independent way.

Hugo


On 8/2/07, Heider, Stephen <[EMAIL PROTECTED]> wrote: 

** 
Hugo,
 
Your post got me thinking: How can you determine if the file
contents have changed?  I have wanted to create something like this for
a while... so I just wrote this SQL Server 2000 function that returns
the checksum of an attachment field (actually any field of Image data
type.  The current and new values could be compared to see if it
changed.  You can also use this to find duplicates in the attachment
fields in your system.
 
CREATE FUNCTION dbo.udf_GetImageChecksum
(
 @ImageField IMAGE 
)
RETURNS INT
AS
BEGIN
 DECLARE @Len BIGINT,
   @Pos BIGINT,
   @CheckSum VARCHAR(8000)
 
 SET @Len = DATALENGTH(@ImageField)
 SET @Pos = 1
 SET @CheckSum = ''
 
 WHILE @Pos < @Len
 BEGIN
  
  SET @CheckSum = @CheckSum + CONVERT(VARCHAR,
BINARY_CHECKSUM(SUBSTRING(@ImageField, @Pos, 8000)))
 
  IF LEN(@CheckSum) > 7900
   SET @CheckSum = CONVERT(VARCHAR, CHECKSUM(@CheckSum))
 
  SET @Pos = @Pos + 8000
 END
 
 RETURN CHECKSUM(@CheckSum)
END
 
In a Set Fields SQL command:
 
SELECT dbo.udf_GetImageChecksum(c536880912)
FROM b611c536880912
WHERE entryId = 'ATTACH16929'
 
 
HTH someone.
 
Stephen



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Hugo Visser
Sent: Thursday, August 02, 2007 5:15 AM
To: arslist@ARSLIST.ORG
Subject: Re: Attachement Updation


** You cannot compare the file contents, but using TR you should
be able to detect that a file was attached again (if the DB value wasn't
$NULL$). The "value" contains the file size in bytes, the compressed
size in the DB and the full filename on the client. 

Also note that user cannot change the attachment from the
attachment field without re-attaching it. Just changing the attachment
(open->edit->save) doesn't update the DB, it only updates the local
temporary copy of the file. 

Hugo


On 8/2/07, Meenakshinathan <[EMAIL PROTECTED] > wrote: 

Hi Robert,

Thanks for the information.

Anyhow this solution is not working. Remedy stores the
attachments in
the following way ,(i
am sure. but
it might bytes),. 

I am not user this TR and DB can apply for attachement
fields.

can any one give me a alternative solution on this?
Looking for your
inputs.

Thanks,
Meenakshinathan


On Jul 28, 2:36 am, Robert Halstead <
[EMAIL PROTECTED]> wrote:
> I'm not entirely sure on this, but couldn't you do a
filter on modify
> with a run-if condition as: 'TR.Attachment' != '
DB.Attachment' ??  I'm
> not entirely sure how remedy stores the attachments.
It might
> work
>
> Anyone else ??
>
> On 7/27/07, Meenakshinathan < [EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]> > wrote:
>
> > Hi Listers,
>
> > In my application, at first stage users can attach
3-4 files. when the
> > request assinged to next stage, that next stage user
can edit or 
  

Re: Attachement Updation - File Contents Changed

[Heider, Stephen]

Shawn,
 
There is a free utility available on ARS Wiki that will assist in
setting up and populating an Attachments form like you describe -
ARS_CreateAttachmentsForm.  http://arswiki.org/projects/dotnetutil
 
Stephen



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Shawn Stonequist
Sent: Friday, August 03, 2007 8:19 AM
To: arslist@ARSLIST.ORG
Subject: Re: Attachement Updation - File Contents Changed


** 
 Just a thought, but instead of attaching the files directly to the
request you are on, what if it was a child form, with a Submit-Only,
single field, attachment pool?
 
This way, to upload a new attachment, a new child record has to be
created, and you know who & when did it. This would also keep historical
records, you could compare the file at each and every stage/change that
took place, or if you don't need this, you could simply delete the
previous records. 
 
I've not worked through this completely, so I'm not sure what
complications might arise (though, immediately I can think of the fact
users will have to open the child record before they can get to the
attachment) .
 
HTH
Shawn Stonequist
EMNS, Inc.



On 8/2/07, Meenakshinathan <[EMAIL PROTECTED]> wrote: 

Hi Robert,

Thanks for the information.

Anyhow this solution is not working. Remedy stores the
attachments in
the following way ,(i am
sure. but
it might bytes),. 

I am not user this TR and DB can apply for attachement fields.

can any one give me a alternative solution on this? Looking for
your
inputs.

Thanks,
Meenakshinathan


On Jul 28, 2:36 am, Robert Halstead < [EMAIL PROTECTED]>
wrote:
> I'm not entirely sure on this, but couldn't you do a filter on
modify
> with a run-if condition as: 'TR.Attachment' != '
DB.Attachment' ??  I'm
> not entirely sure how remedy stores the attachments.  It might
> work
>
> Anyone else ??
>
> On 7/27/07, Meenakshinathan < [EMAIL PROTECTED]
 > wrote:
>
> > Hi Listers,
>
> > In my application, at first stage users can attach 3-4
files. when the
> > request assinged to next stage, that next stage user can
edit or 
> > modify the attachment and can upload it again. In this stage
my client
> > has an requirement like, first stage user to be notified
whenever any
> > attachement is updated. If anybody came throrough this , can
you 
> > please let me know how do i implement this?
>
> > Thanks,
> > Meenakshinathan
>
> >

___-
> > UNSUBSCRIBE or access ARSlist Archives
atwww.arslist.orgARSlist:"Where the Answers Are"
>
> --
> "A fool acts, regardless; knowing well that he is wrong. The
ignoramus
> acts on only what he knows, but all that he knows. 
> The ignoramus may be saved, but the fool knows that he is
doomed."
>
> Robert Halstead
>
>

___-
> UNSUBSCRIBE or access ARSlist Archives
atwww.arslist.orgARSlist:"Where the Answers Are"



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



__20060125___This posting was submitted with HTML in
it___ __20060125___This posting was submitted with
HTML in it___ __20060125___This posting was
submitted with HTML in it___ 

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

Re: Multiple values from tiered menus

[Heider, Stephen]

Michael,

 

The way I do it here is to have the menu return the Entry Id of the menu
option.  Then with the Entry Id I query the source form to retrieve the
Tier 1, 2, 3 options.  I display those options in a separate read-only
field. To the user, it looks like this:  Category / Type / Item.

 

Stephen

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Durrant, Michael M. - ITSD
Sent: Tuesday, August 07, 2007 3:38 PM
To: arslist@ARSLIST.ORG
Subject: Multiple values from tiered menus

 

I think I may have asked this already but I can't find the thread...

 

Running ARS 7...

 

Is is possible to get multiple values from a tiered menu selection?
Example:

 

User selects value from Tier 3 of a menu.  I want to know which Tier 1
and Tier 2 values they chose to get there.

 

 

The information contained in this email may be privileged, confidential
or otherwise protected from disclosure.  All persons are advised that
they may face penalties under state and federal law for sharing this
information with unauthorized individuals.  If you received this email
in error, please reply to the sender that you have received this
information in error.  Also, please delete this email after replying to
the sender. 

__20060125___This posting was submitted with HTML in
it___

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

FW: Attachement Updation

[Heider, Stephen]

How about converting everything to 3D, which then requires the red/blue
glasses :)

 

 

 

 

 

http://heuristicresearch.com/media/convertto3d.html

 

 

Stephen

 

 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa
Sent: Tuesday, August 07, 2007 4:21 PM
To: arslist@ARSLIST.ORG
Subject: Re: Attachement Updation

 

"FYI:  As long as it is displayed on the screen a person can capture it

to send it to the printer using Alt-PrintScreen."

 

Fred, this is very true as well. They could also paste the capture

screen into a Word Document.  I might bring this up if they continue to

make this an issue.  

 

Thanks!

 

Lisa 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"
<>

Re: Attachement Updation

[Heider, Stephen]

Kathy,

 

Here is one approach but it will take a little time to implement...
create a separate form to store all of the attachments.  

 

On the tickets use either a table field to display the attachments
linked to the ticket or a dialog.  I use a dialog here.  Users click a
button and a popup is displayed. From this popup users [based on
permissions] can add, view, save to disk or delete attachments.  

 

The 'delete' option does not really delete the attachment record but
marks it as disabled.  There is a checkbox on the screen to show
'deleted' attachments. 

 

Each attachment on this dialog displays the user and the timestamp of
when they added it and/or deleted it. This approach preserves the
attachments and tracks who did what when.  

 

Stephen

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kathy Morris
Sent: Tuesday, August 07, 2007 9:48 PM
To: arslist@ARSLIST.ORG
Subject: Re: Attachement Updation

 

This has been a SOX requirement for us.  When a Change has been approved
based upon certain conditions, we do not want someone modifying the
attachments later.







Get a sneak peek of the all-new AOL.com

.

__20060125___This posting was submitted with HTML in
it___

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

Re: ARServer.exe crashing

[Heider, Stephen]

Hey Rogerio,

Did you find a solution for this?


Stephen


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Rogerio
Sent: Monday, July 30, 2007 10:39 AM
To: arslist@ARSLIST.ORG
Subject: RES: ARServer.exe crashing

I'll take a look on that.

Thanks,


Rogerio Bronzoni Aguiar
CMagnani


-Mensagem original-
De: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Em nome de Heider, Stephen
Enviada em: segunda-feira, 30 de julho de 2007 11:26
Para: arslist@ARSLIST.ORG
Assunto: Re: ARServer.exe crashing

Rogerio,

After googling this
http://www.google.com/search?q=0x0001bd02+ntdll.dll&btnG=Search (not
many matches)

I found one solution that might help 
http://www.svnforum.org/2017/viewtopic.php?p=9633&sid=a8dd34e057a8dd4f1c
8f7131a76a1bf0

"In the C:\WINDOWS\ServicePackFiles\i386 to change ntdll.dll for
ntdll.old"

Stephen

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen
Sent: Monday, July 30, 2007 10:20 AM
To: arslist@ARSLIST.ORG
Subject: Re: ARServer.exe crashing

Rogerio,

I understand. I wish I had a better answer for you.  Has Windows or SQL
been updated recently (ie. security patches, service packs)?

Stephen


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Rogerio
Sent: Monday, July 30, 2007 10:19 AM
To: arslist@ARSLIST.ORG
Subject: RES: ARServer.exe crashing

Stephen,

The fact that is not supported doesn't mean that doesn't work. We have
used this configuration since a long time and the error appeared
recently.

Thanks,


Rogerio Bronzoni Aguiar
CMagnani

-Mensagem original-
De: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Em nome de Heider, Stephen Enviada em:
segunda-feira, 30 de julho de 2007 11:10
Para: arslist@ARSLIST.ORG
Assunto: Re: ARServer.exe crashing

Rogerio,

It may be due to SQL Server 2005 not being supported with v5.1.2. 

Stephen

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Rogerio
Sent: Monday, July 30, 2007 10:09 AM
To: arslist@ARSLIST.ORG
Subject: ARServer.exe crashing

Hi everyone,

Need some help. We are receiving this error randomly during the day:

"AR System Server Executable (SQL Server) encountered a problem and
needed to close"

Then I see this in event viewer:

" Faulting application arserver.exe, version 5.1.2.0, faulting module
ntdll.dll, version 5.2.3790.3959, fault address 0x0001bd02."

Anyone have seen this before or have any idea about?

Enviroment:

ARS 5.1.2 - Windows 2003 SP2 - SQL Server 2005

Thanks,


Rogerio Bronzoni Aguiar
CMagnani


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



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


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


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



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


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

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