Re: IncidentInterface_Create

Hi Ron. I don’t know how to get your email address from this list. thanks *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Peters, Ron *Sent:* Friday, June 22, 2012 11:25 AM *To:* arslist@ARSLIST.ORG *Subject:* Re: IncidentInterface_Create

Re: Friday Humor - REOPEN

Ha ha! I like those!!! :) -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Barber, Sue Sent: Friday, June 22, 2012 2:50 PM To: arslist@ARSLIST.ORG Subject: Re: Friday Humor - REOPEN I can't stand by and not reply!

Re: XML expertise required...

Hi Joe I tried it in XML Notepad, and there are 3 or 4 places where a Space is Missing between a double quote and an attribute. Lines 18, 30, and 31 had problems – in the code sample you gave. XML Notepad tells you where the error is, and you have to open a text editor to actually fix it on

question on format of Remedy dates in SQL Server

Hi all – I’m wondering how I convert my date fields so that I can understand them in sql server: Example: SELECT last_modified_date , convert(varchar(40), last_modified_date, 100) FROM HPD_Help_Desk WHERE Incident_Number = 'INC00031823'; I expected the above ‘Convert’ to fix the

Re: question on format of Remedy dates in SQL Server

Okay I finally found it… I used DATEADD (ss, name of Remedy date field, ‘19700101’) in the sql. SELECT last_modified_date ,dateadd(ss, last_modified_date, '19700101') FROM HPD_Help_Desk WHERE …. How it looks: J *From:* Nancy Tietz [mailto:nti...@umich.edu] *Sent:* Friday, June 08

Re: question on format of Remedy dates in SQL Server

By doing it in a function, I don't need to remember the syntax every time :) -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Nancy Tietz Sent: Friday, June 08, 2012 8:59 AM To: arslist@ARSLIST.ORG Subject: Re: question on format

Re: Remedy SRM Incident Tibco - failed to move to 'Incident Closure'

Is Tibco updating the ‘Last Modified By’ and ‘Last Modified Date’ fields? Also, look for “GO TO 1000” actions in workflow… I’ve had trouble with those before… J *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Jose Huerta *Sent:*

Re: I am unable to search against the Request ID of a 3 form join.

the Answers Are_ -- *Nancy Tietz* Application Systems Analyst Programmer AIS - FIN / ITSM Information Technology Services University of Michigan x30515 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend

ARUtilities question on DEF files

Hi I've just gotten my ARUtilities license for 7.6. I'm wondering what is the difference between the DEF file produced from ARUtilities and the DEF file produced from Developer Studio? They look slightly different and are a slightly different file size. Was I supposed to order version 7.5 of

question on Pulling in external data via a SQL

Hello all! I am trying to design a solution where a filter pulls in rows from an Oracle view on another server, and the next filter loads them to a staging table/form, then some filters convert some of the data values, then a filter loads them to the regular ITSM form. The number of rows at one

Re: question on Pulling in external data via a SQL

) [mailto:arslist@ARSLIST.ORG] On Behalf Of Nancy Tietz Sent: Thursday, May 31, 2012 3:24 PM To: arslist@ARSLIST.ORG Subject: question on Pulling in external data via a SQL Hello all! I am trying to design a solution where a filter pulls in rows from an Oracle view on another server, and the next filter loads

Re: question on Pulling in external data via a SQL

) [mailto:arslist@ARSLIST.ORG] On Behalf Of Nancy Tietz Sent: Thursday, May 31, 2012 3:24 PM To: arslist@ARSLIST.ORG Subject: question on Pulling in external data via a SQL Hello all! I am trying to design a solution where a filter pulls in rows from an Oracle view on another server, and the next filter

Re: BMC Remedy Action Request System Wikipedia page is set to be deleted

At the bottom of the Wiki you can rate the page… giving a rating is proving that somebody is looking at it at least. *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Easter, David *Sent:* Thursday, May 31, 2012 4:34 PM *To:* arslist@ARSLIST.ORG

Re: Using ITSM Support Groups with AR System Roles

Hi - This is my take on it. With ITSM, the AR User form and AR Group form are not generally needed. They don't have enough information. The People form on ITSM (Administrator Console Application Administration Console People-View) is the one that has people associated with the Support Group

Re: ITSM 7.6.04 - Generic Categorization

ARUtilities is not expensive at all! I have used their SQL and it is very helpful. Or, depending on which database (Oracle, DB2, MS Sql Server...) the product is on, perhaps you could use your Db tool. For example for Oracle, use the SQL Developer. There is also a quick way to update fields via

Where is procedure for inactivating a Remedy User?

Happy Friday to all! I’m trying to understand how to “correctly” inactivate a user in ITSM 7.6.03 – who was a Support Person and has a lot of Knowledge articles etc. assigned to them. I can’t find documentation on that. Anyone have the procedure? or know where it is? or if there is one

Re: Where is procedure for inactivating a Remedy User?

to that user, have been either reassigned or closed and reopened by another user as is appropriate, which includes the KB’s... Joe *From:* Nancy Tietz nti...@umich.edu *Sent:* Friday, May 18, 2012 9:56 AM *Newsgroups:* public.remedy.arsystem.general *To:* arslist@ARSLIST.ORG *Subject

Re: question on Incident Console Window Open vs. Search Incident Window Open

Hi Joe – This is that same request from before, - sigh. I’m attempting to notify the user via a popup that this particular incident that they have wandered into, is already currently open by someone else. However – I am saving the $USER$ value in an Active Link on Window Open, and YES it Does

Re: question on Incident Console Window Open vs. Search Incident Window Open

in it apparently. J *From:* Nancy Tietz [mailto:nti...@umich.edu] *Sent:* Wednesday, May 16, 2012 11:33 AM *To:* arslist@arslist.org *Subject:* RE: question on Incident Console Window Open vs. Search Incident Window Open Hi Joe – This is that same request from before, - sigh. I’m attempting to notify

Re: question on Incident Console Window Open vs. Search Incident Window Open

, irrespective to what may already be existing in the database – it will not be saved to the form unless you press save or perform a ‘Perform-Action-Apply’ so it could easily mislead you like it did now when you use this operations carelessly to manipulate field values Joe *From:* Nancy Tietz

Re: Direct SQL in Active Link problems

. If the server is a UNIX server, ftp those files (binary ftp) to your local client, and import the form (def file) followed by the import of the data (arx file).. The form is called AR System Error Message Form.. Cheers Joe -Original Message- From: Nancy Tietz Sent: Thursday, May 10, 2012

I think I Need to call a Filter From an Active Link

Hi all - I believe I need to be able to trigger a Filter from an Active Link. Why do I want to do that - you ask? Because, only Active Links can detect that the user has opened or closed a window. And, because only Filters can look at what the Server form data is, and act on that. Any ideas?

Re: Direct SQL in Active Link problems

Hi Axton – Oh that’s right – somebody said to use ‘$SERVERTIMESTAMP$’… *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Axton *Sent:* Thursday, May 10, 2012 11:50 AM *To:* arslist@ARSLIST.ORG *Subject:* Re: Direct SQL in Active Link problems

Re: Direct SQL in Active Link problems

: Nancy Tietz Sent: Thursday, May 10, 2012 12:00 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Direct SQL in Active Link problems ** Hi Axton - Oh that's right - somebody said to use '$SERVERTIMESTAMP$'. -Original Message- From: Action Request System

Re: Direct SQL in Active Link problems

The error message was:Error in parsing the Run Process or Direct SQL command (ARERR 9102) thanks -Original Message- From: Nancy Tietz [mailto:nti...@umich.edu] Sent: Thursday, May 10, 2012 1:45 PM To: arslist@arslist.org Subject: RE: Direct SQL in Active Link problems Okay - I'll try

Re: Direct SQL in Active Link problems

an article that talks about many of these concepts here: http://theremedyforit.com/2012/01/scheduling-actions-in-bmc-remedy-action-request-system/ HTH, Jason On Thu, May 10, 2012 at 9:00 AM, Nancy Tietz nti...@umich.edu wrote: ** Hi Axton – Oh that’s right – somebody said to use ‘$SERVERTIMESTAMP

Re: Direct SQL in Active Link problems

UPDATE command in the Direct SQL: (which worked fine in ARUtilities SQL) update HPD_Help_Desk SET UM_Opened_By = '$USER$', UM_Opened_Date = UM_Opened_Date_Integer WHERE Incident_Number = '$Incident Number$'; I didn’t get any date. L Thanks! *From:* Nancy Tietz [mailto:nti

Re: Direct SQL in Active Link problems

HPD_Help_Desk SET UM_Opened_By = '$USER$', UM_Opened_Date = $zMyDisplayOnlyInteger$ WHERE Incident_Number = '$Incident Number$'; *From:* Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] *On Behalf Of *Nancy Tietz *Sent:* Thursday, May 10, 2012 3:28 PM *To:* arslist

Re: to commit or not to commit... that is the question

of concept. Jason On Mon, May 7, 2012 at 12:29 PM, Nancy Tietz nti...@umich.edu wrote: ** Wow – I just found out I can use the ‘SQL’ thing in ARUtilities to actually SEE my Data!!! I’m so excited!!! Okay I’ll try to hold myself back on the ‘!’s and smileys… The C95019 field

Re: Direct SQL question - in Log file ARACTSQL(xxx,0,-1,-2,1000000161)

Yes that is just what I did! SQL log files in the AR System Admin Server Administration. And I found that for some reason my system’s date format was different than the one that Jason gave. And also for some reason, I don’t have to specify the + or minus of GMT difference either like Jason

Re: to commit or not to commit... that is the question

Wow – I just found out I can use the ‘SQL’ thing in ARUtilities to actually SEE my Data!!! I’m so excited!!! Okay I’ll try to hold myself back on the ‘!’s and smileys… The C95019 field is a new field that I added to hold the ‘opened’ date-time for the incident. It is a ‘date/time’ type

Re: How to Delete a row in Active Link

Hi - thank you for responding. Actually I am trying NOT to update the original form HPD:Help Desk. That is why I created a 2nd form and a Join form - which joins HPD:Help Desk and the 2nd form. I like the idea of using a Direct SQL though... because then I could have my new field on HPD:Help

Re: How to Delete a row in Active Link

form.. Joe -Original Message- From: Nancy Tietz Sent: Wednesday, May 02, 2012 11:16 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: How to Delete a row in Active Link Hi - thank you for responding. Actually I am trying NOT to update the original form