Re: Convert Date in to timestamp in remedy

Have you tried doing it at application level? You could have a temporary character field to set the Date from the Date type field and then append the time part as 12:00:00 AM to the value in the character field separated by a space, and set it to the Date/Time field. Joe D'Souza -Original Mes

Re: View Field Problem?

Dan, I would be very surprised if the issue your having has anything to do with the version of Java on the client. It sounds like a pure browser display issue to me. Validate the HTML page that you are putting into the view field. (Either via setting the view field with a URL, or by pushing an HT

Convert Date in to timestamp in remedy

Hi, We are using ARS 6.3, MS SQL. I want to update a date field using direct sql - can some one help me with this. Is there a function to convert the date field in to timestamp or can I use the sql to update the date field directly. Thanks Atul

Re: How to use "ARS Scripting Plug-in for JAVA" ???

Look at the form "Java Scripting Test" and specifically the filters "Java Scripting:Get Script Code, Plugin, and Language" and "Java Scripting:Execute". Basically, the "Filter Script Library" form holds data records that are feed into the ARF (AR Filter) plugin via the Filter "Java Scripting:Execu

Re: !Resent! Application Dispatch errors - ARERR 4454

Hi George, Sounds like the same problem..I am facing but with 6.3. Could you please explain me how to check if there is something stuck in assingment/approval server? what is the arjoinfix? TIA. Anoop > Date: Fri, 28 Sep 2007 21:03:59 -0700> From: [EMAIL PROTECTED]> Subject: Re: > !Resent

detecting radio button selection in table

Folks, I have a problem/question dealing with radio buttons in a table. I have a customer (CIO) who wants a popup message to show as soon as a radio button option is selected in a table and has a certain value. Problem: Radio buttons when selected in a table do not activate Active Links. Q

Re: Alternatives to DSO for Data Transfer

Ok, I'm very interested in how to setup replication say, from T215 on oracle 10gR2 to a secondary database. Is it simply SQL that copies the data or are you using Transactional Replication? Thanks, -Geoff On 10/1/07, Nall, Roger <[EMAIL PROTECTED]> wrote: > > It has worked very well for us. Not

Re: ARServer fails to connect to new database server

Yes, the db owner is the appropriate account (the same name annotated in the logs where AR Server states that it cannot connect to the database as this individual). I'm curious as to whether or not the problem is the result of connecting to a new SQL 2005 server whereas our old method was connecti

Re: View Field Problem?

Why are you presenting the URL to the user at all? Does the user have to click the URL to initiate the chat session? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Wangler, Dan Sent: Monday, October 01, 2007 4:32 PM To: arslis

How to use "ARS Scripting Plug-in for JAVA" ???

Hi, How I can use these plug-in to create a Filter that executes a script ?? On "Form Name" field (at Basic tab) I'll select the "Filter Script Library" or another test form?? Because in my "If Action" tab, I have to put the fields that I'd like to use... like: ARSYS.ARF.JAVA for "Plug-In

Re: ARServer fails to connect to new database server

Did you check ownership of the ARSystem database? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Watson, Benjamin A. Sent: Monday, October 01, 2007 4:29 PM To: arslist@ARSLIST.ORG Subject: ARServer fails to connect to new data

View Field Problem?

Hello We are trying to implement a CHAT capability from our home grown help desk application. We have a simplifeid submit web form where the user keys in his id number and hits enter and we populate most of the rest of the form from LDAP. The customer then selects a product and a description

Re: Diary field sizing and the mid-tier

./arsys/resources/html/CharEditBoxPopup.html from 7.1 mid-tier; probably the same in all 7.x releases. Any time you have a browser windows without a url bar, you can use CTRL+D to bookmark the page (ie and firefox). The bookmark will tell you what you were looking at. Axton Grams On 10/1/07, G

ARServer fails to connect to new database server

List, Once upon a time ago... We had an ARSystem v 7.01 Server (with ITSM 6 apps) running against an MSSQL 2000 database server (all boxes are Windows 2003 Server Standard). This all worked just fine. We then upgraded our SQL to MSSQL 2005. Again, all works just fine. Now we need to mo

Urgent! I am hiring for a Talented Remedy (Magic) Administrator in Miami, FL

Hello List, Hope all is well, I am currently hiring for a Talented Remedy Administrator the Magic exposure is a plus. The individual on a day-to-day basis will be creating customizations and assisting in the install of Remedy Service Desk Express 9 for their Help Desk. Customizations include cre

Diary field sizing and the mid-tier

Hi, We're running ARS 6.0 with the Help Desk client, and mid-tier 7. One thing I consistently hear is that, when you click the diary icon on the worklog, if you are in the web client, the resulting display field is only two lines long (the text field where you can enter data is fine, it's the

Re: Clarification on DST ending

The patch corrects on which day DST occurs/ends. It does not alter the behavior of the actual time gain/loss on the day of the change. -David J. Easter Sr. Product Manager, Service Management Business Unit BMC Software, Inc. The opinions, statements, and/or suggested courses of action expresse

Re: Disappearing work log entries

Je ne sais pas! Michel Giguère CGI - Chorus [EMAIL PROTECTED] (514) 415-3000 (ext.4208) -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: October 1, 2007 3:55 PM To: arslist@ARSLIST.ORG Subject: Re: Disappearing wor

Re: Disappearing work log entries

select name from filter where filterid in ( select filterid from filter_push where fieldid in ( select fieldid from field where name = 'z1D Previous Operation')) and assignshort like '%HPD:WorkLog%' / select name from filter where filterid in ( select filterid from filter_set where fieldid in ( se

Re: CMDB2 - what class for network hardware?

Hello, We also use the BMC_Computer class. One important reason for that is that, if you're using the discovery tools, these CIs will be discovered and placed into the Computer Class initially. Having a custom class will be painful for you, since you'll have to work around it to move those CIs

Re: ITSM7 - Mass Change of Login / Access details

You might be able to do that from the user form. Howard On 10/1/07, Runar Helle <[EMAIL PROTECTED]> wrote: > > ** > > Hi, > > > > Is there an easy way to change attributes for several people at once? > > > > I have previously used Action à Modify all. However, in ITSM7 there seems > to be some k

Disappearing work log entries

Hello Listers, I recently got a call from our Help Desk that work info entries on incidents were disappearing. After looking at the HPD:WorkLog form, we noticed that some of the entries have had their status set to Delete. I turned on the escalation and filter logs but haven't seen anything com

Re: AR System & IP V6

Not so much a limitation, but AR System has not been fully tested or certified within an IPv6 environment. Testing and support for use within an IPv6 environment is tentatively planned for the mid-2008 release of AR System. -David J. Easter Sr. Product Manager, Service Management Business Unit B

Re: Alternatives to DSO for Data Transfer

It has worked very well for us. Not being a dba the biggest challenge I can remember is declaring a primary key for each Remedy table. While we all know that C1 is the primary key is not really declared at the db level. This has to be done manually. >From a Remedy stand point you need to remember

Re: Alternatives to DSO for Data Transfer

Roger, That's very interesting. I had been told by support in the past that Remedy would not work correctly with replication but that they would support it in a 7.x release. I'd be interested in how you've implemented it, how well it works for you, and what you've learned along the way. Thanks, C

Re: Escalation creating dup tickets

Joe, Is there a better email acct to send a piece of the escalation log. There is something very odd within it. C From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Monday, October 01, 2007 1:49 PM To:

Re: CMDB2 - what class for network hardware?

I believe in the CMDB 2.x best practices class they touch upon this item and recommend using the ComputerSystem class for tracking any networking HW with what Jarl has indicated below. We are in the process of using the mechanism recommended without creating our own classes, since this is an add

Re: Clarification on DST ending

** Thanks all. I believe we will just disable escalations for that hour on the night of the change, as we do use the ITSM 6.0 apps and I really don't want to customize all of them right now. I appreciate all the insight and suggestions. Thanks a lot everyone! -Original Messa

Re: "Can not Display Page" and "Caught Exception" errors in Internet Explorer

I am guessing not, but this is ITSM 7 OOB form/functionality, so not too sure. I can check. What if the answer is yes? What would I look for? Interestingly, when I took out the view name from the URL, the form showed up fine with the default view(when typed directly on the browser). The non-defau

ARSlist AWards: Voting extended to Friday October 5th 6p.m. EST, more votes or Cancelled

Since I didn't post the nominees for Products until a week late, I will extend all voting for the week. PLEASE NOTE: We need another 75 votes for a MVP, or there will be no Award this year. We need more votes for all categories or the Awards will be cancelled for this year. .. Daniel

RESOLVED - ITSM7 - Mass Change of Login / Access details

Kaiser and Joe, Thank you for your suggestions. My escalation seemed to drop that field completely (I had a second push on Nick name that worked). Direct SQL is not for me:-) My workaround was to change "Unrestricted access" to Read/Write and did a modify all. Thanks! Best regards, Runar -

Re: Escalation creating dup tickets

Is this a filter phasing issue? Usually, all set fields actions fire first, then all push fields actions to ensure data integrity. If one of the set fields actions fail, there are no records updated or created with the push fields action. With filters you can change this behavior by adding `! (back

Re: Clarification on DST ending

Joe, This might not help. Part of what I've seen in the past is that a duplicate pair of escalations are spawned. It might help to stop the second one from triggering but depending on timing they might fire at the same time. We usually have to cycle the app to get rid of the dups. Dave

Re: CMDB2 - what class for network hardware?

Yeah, I thought of that. I'm surprised there is such a glaring hole in the CDM... I think I'd rather create a new class structure to capture this information... Jack Covert Corporate IT Enterprise Systems Management Remedy Support Team Remedy Support Team Home Page http://collaborate.mckess

Re: Clarification on DST ending

Its a pretty rare exception so I'm not surprised its not handled. Its not applicable to a lot of countries anyway, but considering the ARS was primarily designed and used in the west, where use of DST is more common, maybe its time they do include such exceptions in their workflow where workflow ba

Re: Error message when running CR with AR UT 7.1

Thank you Dave. I have actually never used CR except through the user tool. I am going to see if I can download a copy. Thanks again, Brad On 10/1/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > ** > > Brad, > I have found in the past when a report return this error it is out of sync > with

Re: CMDB2 - what class for network hardware?

BMC.CORE:BMC_ComputerSystem: PrimaryCapability = "Router" BMC.CORE:BMC_ComputerSystem: PrimaryCapability = "Switch" -- Jarl On 10/1/07, Covert, Jack <[EMAIL PROTECTED]> wrote: > ** > > > > Hi guys. For those of you using CMDB 2, what classes are you using to store > your network hardware (switc

Re: Clarification on DST ending

It would be nice if we would have designed our escalation to run that way here at TycoElectronics but we haven't. I doubt that the OOB escalations execute that way either. Good suggestion though. Dave From: Action Request System discussion list(ARSList) [mail

Re: Clarification on DST ending

Yes I understand the reason why its happening. I was suggesting a workaround for it not to happen by time stamping the run time of the escalation and having an inclusion on the run if condition to make sure that the last time it has fired is greater than 1 or 2 hours as the case may be so it fires

Re: CMDB2 - what class for network hardware?

We're just planning to use Computer System for almost everything networking related. We will just use different categorizations to track it. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Covert, Jack

Re: Escalation creating dup tickets

GlacierChris, What are the chances that both your escalations evaluate to True, thus firing actions twice during the runtime of both the escalations resulting in 2 tickets? Joe D'Souza -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Be

Re: Clarification on DST ending

Joe, We've seen this behavior for years. It happens with escalations that are set to fire in the 2:00 AM to 3:00 AM time frame. I think it also happens with escalations that are just set to fire at intervals. Dave From: Action Request System discussion list(A

CMDB2 - what class for network hardware?

Hi guys. For those of you using CMDB 2, what classes are you using to store your network hardware (switches, routers, etc.). Jack Corporate IT Enterprise Systems Management Remedy Support Team Remedy Support Team Home Page http:

Re: ITSM7 - Mass Change of Login / Access details

Have you attempted direct SQL or is that not a viable option considering you may want filters to fire set to fire on modify? Joe D'Souza -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Runar Helle Sent: Monday, October 01, 2

Re: Clarification on DST ending

Joelie, A workaround could be having the escalation check for the last time it fired, and not fire if it has already fired an hour or 2 ago. This would mean you would have to customize your form for having the last time the escalation fired and setting that timestamp there and fixing the run if co

Re: Escalation creating dup tickets

Joe, There are no filters firing on this. Only 2 escalations, one for US and one for Row. Each escalation has 3 actions. 1. A push field taking data from the original form and pushing to Help Desk with a 1=2 qualification. 2. Takes the HD request ID and sets it back to the original form. 3.

Re: Notification Help

If you don't mind changing the timestamp on last modified date on your current form you can create a temp display only field on the main form and perform a save to that field that triggers a filter.. Joe D'Souza -Original Message- From: Action Request System discussion list(ARSList) [ma

Re: Clarification on DST ending

Joelie, I would say that it depends. A lot has to do with how the system clock is reset. In the past with systems where the system clock is reset immediately we often saw this happen. Some of our UNIX servers were set in a manner that the time change took effect over a period of time and we wou

Re: ITSM7 - Mass Change of Login / Access details

How about writing a one-time escalation? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Runar Helle Sent: Monday, October 01, 2007 12:13 PM To: arslist@ARSLIST.ORG Subject: ITSM7 - Mass Change of Login / Access details ** H

ITSM7 - Mass Change of Login / Access details

Hi, Is there an easy way to change attributes for several people at once? I have previously used Action --> Modify all. However, in ITSM7 there seems to be some kind of restriction on some fields so that you cannot use that feature. For example, Modify All does not work on Unrestricted Access a

Re: "Can not Display Page" and "Caught Exception" errors in Internet Explorer

Got any Javascript associated with the form and/or workflow? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rabi Tripathi Sent: Monday, October 01, 2007 11:59 AM To: arslist@ARSLIST.ORG Subject: "Can not Display Page" and "Cau

Re: Alternatives to DSO for Data Transfer

If you are using SQL Server you are not dependent on the Remedy version to institute transactional replication. We have been using this since ARS 4.5. Thanks, Roger A. Nall Manager, OSSNMS Remedy T-Mobile USA Desk: 813-348-2556 Cell: 973-652-6723 FAX: 813-348-2565 sf49fanv AIM IM RogerNall

Re: Clarification on DST ending

I thought this patch was to fix both sides of the time change. Howard On 10/1/07, Dudley, Joelie <[EMAIL PROTECTED]> wrote: > > I just want to make sure I understand this correctly. When DST ends the > first weekend in November the clocks get turned back one hour, in the > past this would cause

Re: Notification Help

Andy, Actually it was Sabrina that first suggested the push fields action. Because of the issue with email notification processes truncating the T0: and CC: addresses to 256 characters, we've changed a lot of our workflow to use push fields directly to the Email Messages form. If you need any he

Re: Notification Help

I was hoping to be able to do a Run Process call from an Active Link that would fire a Filter or Escalation to send a notification. While a very viable solution, I would prefer not to have to create another form just to send a notification. I am obviously not the most experienced Remedy Admin (pr

"Can not Display Page" and "Caught Exception" errors in Internet Explorer

Hi all, I have ITSM 7 and a few forms, especially when opened through buttons (like the "Create" braodcast button on Incident console) open with one or both of the following errors: "Can not Display Page" and "Caught Exception: Access is denied" It's happening with everybody. On Remedy User, thin

Re: Escalation creating dup tickets

GlacierChris, What is the workflow behind the creation of the ticket? I mean when the Escalation fires, is the Escalation directly creating that ticket? Or is a Filter set to fire on that Escalation create that ticket? What are the exactly actions on your Escalations as well as filters created t

Clarification on DST ending

I just want to make sure I understand this correctly. When DST ends the first weekend in November the clocks get turned back one hour, in the past this would cause escalation between 2-3 am to fire twice is this still the case? The patch back in the spring was only to change the timeframe of when

Escalation creating dup tickets

Hello all, Has anyone seen where a single escalation fires and creates matching tickets where the only difference is the Request ID? In the logs, it shows the escalation firing, doing a push to ITSM (Help Desk), does a return setfield back into the original form that a second setfield changes the

Re: ARS Helping Out The Little Guy

I'm currently involved in a project replacing an existing Magic-based system to a new Remedy System (ARSystem v7 ITESM v6). The data migration is NOT trivial. Of course, our customer doesn't have very good data in their Magic system to begin with (e.g. an e-mail address in a first name field, etc

Re: RESOLVED: How to perform redirection in Tomcat standalone.

SSL isn't too bad really. 1. Get familiar with Java keytool with regards to creating key-pairs, generating certificate requests, and installing certificates. At some point, you'll need to use keytool to generate a keypair to create your initial java keystore. IMPORTANT: make not of all passwords

Re: RESOLVED: How to perform redirection in Tomcat standalone.

What did you have to do to Tomcat to get it to run SSL? Christopher Strauss, Ph.D. Remedy Database Administrator University of North Texas Computing Center http://remedy.unt.edu/helpdesk/ > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTEC

Re: RESOLVED: How to perform redirection in Tomcat standalone.

Just went through the pain of doing this with SSL for a deployment. You can also add an additional content line for localhost redirection as well as the actual server name content line i.e. http://servername.com/arsys/home";> http://localhost/arsys/home";> In my case I changed the default ports

RESOLVED: How to perform redirection in Tomcat standalone.

When you install MT 7.1 and let it install Tomcat standalone, you have a: /webapps/ROOT folder. In that folder lies the default index.html page, which is the one that is shown when browsing to http://. BTW, the default index.html page for Tomcat bundled with MidTier is a page that simply states "

Crystal Report Server 11 and Mid-Tier Setup

Hi, Can somebody advice how can I setup mid-tier to run ITSM7 crystal reports? I have tried by referring Chap 10 "Configuring the mid-tier to Run reports on the web" from 7.0.1 Mid-Tier installation guide but failed to get result. I am still not sure where shall I install Crystal Report Viewer Com

Re: Splitting of a string

Hi, The CR in REPLACE may cause a problem, as it typically adds a SPACE after the CR. It looks right when you save the filter, but when you reopen it, the space is there. This may have been changed in newer releases of the ARSystem. One way to fix this would be to do something like this: Altern

Re: Error message when running CR with AR UT 7.1

Brad, I have found in the past when a report return this error it is out of sync with the database. The error should resolve if you open the report with CR and then verify the database. Usually the CR will want to remap a couple of fields and once it is complete your report should run. Additi

Re: Splitting of a string

Check out the REPLACE function. You may be able to replace the ";" with "" without having to parse out the string. To enter the CR, you will need to open the expand box for the text, so in the box, the replace command would look like: REPLACE($EMAIL_ADDRESS_STRING$, ";"," " note the last do

Re: Splitting of a string

Frans, If you only want to convert the string into a format that the email engine can use to send to multiple recipients, have you tried the REPLACE() function? Set Fields with something likeREPLACE($FieldName$, ";", "|") *For this email I used the pipe symbol (|) in place of a r

Re: Splitting of a string

Please try the below approach Assume that you have a field to capture the string. I call it as field "X" 1. Have a duplicate field A to keep your String for manipulation. 2. Have a field to keep your separator called field "B" (here it is ";") 3. Have another field called "C" (

Splitting of a string

Hi All I need to split the following string: vimals;appadmin;rianaj a filter must use the first logon id vimals and then appadmin and then rianaj etc. therefore it must split the string on ; I want to pass it to the E-Mail engine, which uses "Hard returns" to send a message to a lis