Re: Windows Vista Question

2007-03-14 Thread Heider, Stephen
it but hey if you like graphics (Dont get me started on Remedy) John Mosco W01/GS-11 IT Coordinator Customer Support Manager PNG JFHQ J6 'We the people' From: Action Request System discussion list(ARSList) on behalf of Heider, Stephen Sent: Wed 3/14/2007 7

Re: DST Test Results on March 11th 8:00 AM

2007-03-12 Thread Heider, Stephen
Another, or additional, method would be to run a Direct SQL command each time users login (loads the main form) UPDATE AR_System_User_Preference SET Time_Zone = NULL WHERE Submitter = '$USER$' This would take effect the next time the user logged in. I actually do this with a stored procedure

OT: TS Census ScanWkstn.exe Error

2007-03-12 Thread Heider, Stephen
We use TS Census (now Zen Asset Management) for tracking computers and software. Within Remedy users can select a computer and then click a button to force a rescan of the computer. Starting this morning (or just noticed) the ScanWkstn.exe console program is crashing. The only thing that has

Re: DST Test Results on March 11th 8:00 AM

2007-03-12 Thread Heider, Stephen
suggested would work for those users as well as those that use a preference server. -- 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 3/12/07, Heider, Stephen

Re: MS SQL - Oracle ... Distributed Transaction failed ?

2007-03-12 Thread Heider, Stephen
Robert, Are you able to insert records in Query Analyzer while logged in as user ARAdmin? Try placing your INSERT commands in a Stored Procedure and test it in Query Analyzer. Then run the stored proc from workflow to see if it works. Here are a few posts that might be useful: ROLLBACK

Re: AR E-mail Engine 6.3 and HTML emails bug - workaround

2007-03-12 Thread Heider, Stephen
..this behavior is also present in Outlook 2007. In the new Outlook, Word 2007 is used for all email - it can't be turned off. Even if you don't have Word 2007 a special version of Word 2007 is installed with Outlook 2007 for viewing emails. For additional details see the thread OT: Remedy HTML

Re: AR E-mail Engine 6.3 and HTML emails bug - workaround

2007-03-12 Thread Heider, Stephen
*I think this posting was eaten by the List email engine. I posted one message before and one message after I sent this one and both have been received, except this one. From: Heider, Stephen Sent: Monday, March 12, 2007 1:33 PM To: arslist@ARSLIST.ORG Subject

Re: Send survey at close

2007-03-12 Thread Heider, Stephen
Rich, The way I do it here is to include a URL in the HTML email which the requester receives when their ticket is marked Resolved. When clicked, the employee is logged into remedyweb and workflow selects the tab that lists their tickets, selects the ticket that was just resolved, then opens the

Re: RESOLVE: DST Test Results on March 11th 8:00 AM

2007-03-12 Thread Heider, Stephen
Of Heider, Stephen Sent: Monday, March 12, 2007 9:21 AM To: arslist@ARSLIST.ORG Subject: Re: DST Test Results on March 11th 8:00 AM Another, or additional, method would be to run a Direct SQL command each time users login (loads the main form) UPDATE AR_System_User_Preference SET Time_Zone = NULL

SQL Server 2005 CLR and ARS API

2007-03-08 Thread Heider, Stephen
List, I am attempting to create a stored procedure written in .Net that uses the ARS .Net API. Everything works as expected except when adding the ARS API part. I am not sure if this is even possible because it seems that you can only have one .dll file inside a SQL Assembly, and the

Re: ARSList awards meeting refreshments

2007-03-01 Thread Heider, Stephen
Yes, but Twinkies have a 32 year shelf life :) -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of strauss Sent: Thursday, March 01, 2007 1:42 AM To: arslist@ARSLIST.ORG Subject: OT: ARSList awards meeting refreshments All

Re: LOGOFF event capture

2007-02-28 Thread Heider, Stephen
One option would be to add an active-link on the main control form that pushes a new record to a logon/logoff form when the user opens the form, and also when they close the form (exit the application). Stephen -Original Message- From: Action Request System discussion list(ARSList)

Re: Server Logins with Multiple ARS Instances - Possible Bug

2007-02-27 Thread Heider, Stephen
To: arslist@ARSLIST.ORG Subject: Re: Server Logins with Multiple ARS Instances - Possible Bug Make sure that no ARTCPPORT env var is set! Ben - --- Original Message --- - From: Heider, Stephen [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Mon, 26 Feb 2007 15:34:27 I

Re: Server Logins with Multiple ARS Instances - Possible Bug

2007-02-27 Thread Heider, Stephen
box...you will get remedydev From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen Sent: Monday, February 26, 2007 1:34 PM To: arslist@ARSLIST.ORG Subject: Server Logins with Multiple ARS Instances - Possible Bug

Re: DSTC Bug ARS 6.0.3 Patch 20 and User/Group Form Changes

2007-02-27 Thread Heider, Stephen
. Jenni Wacholz 480-445-2517 Remedy Administrator Coventry Health Care From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen Sent: Tuesday, February 27, 2007 8:29 AM To: arslist@ARSLIST.ORG Subject: Re

OT: Virtual PC 2007 Available

2007-02-26 Thread Heider, Stephen
For those who like to run test ARS installations in a virtual environment, version 2007 was just released (still free). It now works with Vista 32- and 64-bit. I am using it with Vista 64-bit and it runs fine and seems to be faster than VPC 2004.

Server Logins with Multiple ARS Instances - Possible Bug

2007-02-26 Thread Heider, Stephen
I noticed something that doesn't seem right with logging into different instances of ARS on the same server. The server name that is visible in the User Tool (6.3 and 7.0) and from the .Net API (v7.x) lists the wrong server in certain circumstances. Environment: Windows Server 2003 with ARS

Re: Server Logins with Multiple ARS Instances - Possible Bug

2007-02-26 Thread Heider, Stephen
Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen Sent: Monday, February 26, 2007 3:34 PM To: arslist@ARSLIST.ORG Subject: Server Logins with Multiple ARS Instances - Possible Bug ** I noticed something that doesn't seem right with logging into different

Re: ARS 7.x - ARSSOInfo.dll

2007-02-16 Thread Heider, Stephen
is embedded each user will need to have a custom compiled version of arssoinfo.dll on their computer. Has anyone found a good use for arssoinfo.dll? Stephen From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Heider

Re: Get Rid of the Splash Screen on User Tool - Resolved

2007-02-16 Thread Heider, Stephen
); What strikes me is how *fast* the User tool fires up when you come at it via OLE. It just pops! Tim [EMAIL PROTECTED] v: 937-878-9045 f: 937-878-9055 m: 937-369-7012 http://www.widowfield.com - Original Message From: Heider, Stephen [EMAIL

ARDBC.LDAP Not Available as Vendor Form - ARS 7.0.1 Patch 1

2007-02-15 Thread Heider, Stephen
After completely uninstalling ARS 7.0.0, and subsequently removing ARS folders from a test server (Windows Server 2003), I installed ARS 7.0.1 Patch 1 including Mid-Tier 7.0.1 Patch 1 and the installation went without error. During the server installation I selected AREA LDAP, ARDBC LDAP, and Web

Re: ARDBC.LDAP Not Available as Vendor Form - ARS 7.0.1 Patch 1

2007-02-15 Thread Heider, Stephen
go to create a vendor form you have to type in the Available Vendor Name (ARSYS.ARDBC.LDAP). Fred From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen Sent: Thursday, February 15, 2007 8:55 AM To: arslist

Re: ARDBC.LDAP Not Available as Vendor Form - ARS 7.0.1 Patch 1 - RESOLVED (partially)

2007-02-15 Thread Heider, Stephen
Pospisil Technology Support Systems ▪T▪ ▪ ▪Mobile UK▪ -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen Sent: 15 February 2007 15:17 To: arslist@arslist.org Subject: Re: ARDBC.LDAP Not Available as Vendor Form

Re: ARDBC.LDAP Not Available as Vendor Form - ARS 7.0.1 Patch 1

2007-02-15 Thread Heider, Stephen
to see what is really going on. -- 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 2/15/07, Heider, Stephen [EMAIL PROTECTED] wrote: It's not accepting any

ARS 7.x - ARSSOInfo.dll

2007-02-15 Thread Heider, Stephen
According to http://www.bmc.com/userworld/vancouver/assets/sessions/ARSI-104_Cool_Sol utions_for_LDAP.pdf and http://documents.bmc.com/supportu/documents/57/12/65712/65712.pdf, ARSSOInfo.dll can be used to auto-login to the Windows User Tool using AREA. Has anyone got this to work? Do you

New Utility: Retrieve Workstation Info within Windows User Tool

2007-02-14 Thread Heider, Stephen
List, I created a utility that some may find useful. Thanks to Matt for letting me host it on his site. http://www.mattreinfeldt.com/site/component/option,com_docman/task,cat_v iew/gid,41/Itemid,28/ http://www.mattreinfeldt.com/site/component/option,com_docman/task,cat_ view/gid,41/Itemid,28/

Re: Server fails to Restart w/NT Authority user

2007-02-14 Thread Heider, Stephen
Scott, I experienced a similar situation about 2 years ago. I am not 100% sure if this is the issue, but... what is the login name used for the Remedy NT service and SQL Server NT service? I changed it here to a network account that has Admin access on the server and also has access to query

Re: Next-ID-Block-Size - Skipping Numbers

2007-02-09 Thread Heider, Stephen
Wow. I am curious as to how this is a benefit. Does anyone know why BMC designed it this way [that each time you restart the server it skips Request ID numbers]? There must be some benefit, I just can't see it. Stephen From: Action Request System

Re: Next-ID-Block-Size - Skipping Numbers

2007-02-09 Thread Heider, Stephen
] On Behalf Of Heider, Stephen Sent: Friday, February 09, 2007 5:40 AM To: arslist@ARSLIST.ORG Subject: Re: Next-ID-Block-Size - Skipping Numbers ** Wow. I am curious as to how this is a benefit. Does anyone know why BMC designed it this way [that each time you restart the server it skips

Re: Tally NetCensus Integration

2007-02-07 Thread Heider, Stephen
Greg, I have integrated Tally TSCensus (now from Novell named Zen Asset Management). Is Tally NetCensus a different version of TSCensus? Stephen From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Greg

Re: use of ' in sql calls

2007-02-07 Thread Heider, Stephen
Ivan, Apostrophes are something that will need to planned for anytime you make calls to a SQL database directly. But, it's quick to do. In a Set Fields, replace the single ' with two '' using the Remedy REPLACE() function. Store the result in a tmp field. Then use the tmp field in your SQL

Re: use of ' in sql calls

2007-02-07 Thread Heider, Stephen
PROTECTED] On Behalf Of Heider, Stephen Sent: Wednesday, February 07, 2007 10:32 AM To: arslist@ARSLIST.ORG Subject: Re: use of ' in sql calls Ivan, Apostrophes are something that will need to planned for anytime you make calls to a SQL database directly. But, it's quick to do. In a Set Fields

Re: Tally NetCensus Integration

2007-02-07 Thread Heider, Stephen
, They are actually using version 7 on ZenWorks and are thinking of upgrading to 7.5. Had any success with this? Greg Donalson Remedy Approved Consultant Entaq, Inc. w# - 281-893-1800 c# - 832-689-2344 www.entaq.com From: Heider, Stephen Sent: Wed 2/7/2007 9:47 AM

Re: Uninstall of 7.0.x client w/ Crystal may cause corruption of MSFT apps

2007-02-05 Thread Heider, Stephen
David, Thank you for notifying us. My main computer has both Office 2003 and Visual Studio (2003 and 2005). On a related note, is there a way to get notified automatically when a bug Id is created? If it wasn't for you sending this note my computer, and hence my productivity, could have

Re: Maybe OT: RPC Service Going Up/Down - RESOLVED

2007-01-31 Thread Heider, Stephen
purged from the network and instantly made the Remedy server's settings invalid. Stephen -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen Sent: Wednesday, January 31, 2007 7:44 AM To: arslist@ARSLIST.ORG

Re: REPLACE function not replacing...

2007-01-26 Thread Heider, Stephen
Certain versions of ARS insert a space just before the new-line character. Try using LTRIM in your REPLACE command. REPLACE($FieldwLineBreak$, LTRIM( |), ) Stephen From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf

Re: Turn off Workflow during the delete process

2007-01-25 Thread Heider, Stephen
One approach is to have your Application-Delete-Entry filter (triggered by Status=Delete, for example) set to run at execution level 0. The second command in the filter would be a Go To 1000. This would ensure that no other filter workflow runs. This assumes that no other filters run at 0 or

Re: Issues since patch #19 or #20

2007-01-24 Thread Heider, Stephen
...getting ready to install patch 20 for ARS Server v6.3 (SQL Server, W2K3) on a dev server. Because the Installer also modifies forms I prefer copying the new files instead when installing patches. I submitted a RFE last year so that we have the option of _only_ installing patched files and

Re: Trace a user to an IP address?

2007-01-22 Thread Heider, Stephen
Jim, I capture the IP address and store it with other computer and user data in a logging form when users log in. You could add a filter that emails you anytime a specific username is used to login. Stephen -Original Message- From: Action Request System discussion list(ARSList)

Re: Opening a new browser window

2007-01-22 Thread Heider, Stephen
the link to open in a new browser window. Thanks again all, Eric Cleereman -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Heider, Stephen Sent: Thursday, January 18, 2007 7:42 AM To: arslist@ARSLIST.ORG Subject: Re: Opening a new

Re: Opening a new browser window

2007-01-18 Thread Heider, Stephen
The way I do it here is to run IE's .exe with the URL in a Run Process. C:\Program Files\Internet Explorer\IEXPLORE.EXE http:\\google.com This opens the URL in a new window. Stephen From: Action Request System discussion list(ARSList) on behalf of Michiel

Re: OT User World 2007

2007-01-17 Thread Heider, Stephen
Orlando: 80's, plus Disney World. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ben Chernys Sent: Wednesday, January 17, 2007 11:15 AM To: arslist@ARSLIST.ORG Subject: Re: OT User World 2007 Here's how you tell the

Re: Sending HTML email surveys to requesters and getting their input back

2007-01-11 Thread Heider, Stephen
Eug, We do something similar here, but it should also work for email surveys: Remedy sends an html form template. When received by employees, they open it (Outlook), enter some information and make a selection from a radio button. Then they enter their password in a password field and click

OT: ARS List Email is a Goldmine - How to Index

2007-01-11 Thread Heider, Stephen
List, I search my local ARS List emails regularly. However, it's somewhat slow searching the email body within Outlook. For Jan 2005 to Jan 2007 the .pst file is 700MB. I am getting close to simply writing something that extracts the Outlook emails and imports them into a database (either

Re: ARS List Email is a Goldmine - How to Index

2007-01-11 Thread Heider, Stephen
] On Behalf Of Heider, Stephen Sent: Thursday, January 11, 2007 5:13 AM To: arslist@ARSLIST.ORG Subject: OT: ARS List Email is a Goldmine - How to Index List, I search my local ARS List emails regularly. However, it's somewhat slow searching the email body within Outlook. For Jan 2005 to Jan 2007

Re: CLI Create Entry Program

2007-01-08 Thread Heider, Stephen
I wrote two command line apps to create and delete entries. If anyone is interested please contact me off list. If you're interested in the code (VB.Net 2003, ARS .Net API 7.0.2523.16350) I think it could make it to the List (3,288 bytes zipped). Stephen

Re: CLI Create Entry Program

2007-01-08 Thread Heider, Stephen
Matt has allowed me to post these on his site - Thanks Matt! http://www.mattreinfeldt.com/site/component/option,com_docman/task,cat_v iew/gid,41/Itemid,28/ Stephen -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Heider

Re: ROLLBACK - Distributed Transaction issues.

2007-01-05 Thread Heider, Stephen
John, Have you tried calling a stored proc the remedy server from workflow? The sp would then perform the remote insert. Stephen -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Reiser, John J Sent: Friday, January 05, 2007

Re: ROLLBACK - Distributed Transaction issues.

2007-01-05 Thread Heider, Stephen
brilliance. - paraphrased by me -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen Sent: Friday, January 05, 2007 10:23 AM To: arslist@ARSLIST.ORG Subject: Re: ROLLBACK - Distributed Transaction issues. John

Re: Remedy and Altiris Intetgration

2007-01-04 Thread Heider, Stephen
John, Our company will soon be switching from Zen Asset Management (formally known as TS Census) to Altiris. Do you by chance have any tips or info you could pass along? Thanks. ARS 6.3 Windows Server 2003 SQL Server 2000 Stephen From: Action Request System

Re: Remedy and Altiris Intetgration

2007-01-04 Thread Heider, Stephen
the connectors if you're at all competent in DB stuff and Remedy (which you probably are). Once you see the data model, it makes sense, and isn't that hard to map to whatever Remedy tables you want. Rick On 1/4/07, Heider, Stephen [EMAIL PROTECTED] wrote: John, Our company

Re: Remedy and Altiris Intetgration

2007-01-04 Thread Heider, Stephen
To: arslist@ARSLIST.ORG Subject: Re: Remedy and Altiris Intetgration ** And I don't think you'll find one that way, either. The only way I got to see it was by looking at the actual database tables. Rick On 1/4/07, Heider, Stephen [EMAIL PROTECTED] wrote: Rick, I have

Re: Remedy and Altiris Intetgration

2007-01-04 Thread Heider, Stephen
and could probably help with a few tips. Heather, want to chime in here? Rick On 1/4/07, Heider, Stephen [EMAIL PROTECTED] wrote: I having been examining the tables and views this afternoon, just in case. I just found this on Altiris' support site http

Re: ActiveDirectory - Converting long int values ?

2006-12-22 Thread Heider, Stephen
Robert, If I understand your question correctly, it seems you are very close... I retrieve the AD long int value and store it in a Remedy Decimal field. In the next Set Fields action divide by 1000 and store in the same Decimal field. In the next Set Fields action set the Remedy

Re: ActiveDirectory - Converting long int values ?

2006-12-22 Thread Heider, Stephen
System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen Sent: Friday, December 22, 2006 4:19 PM To: arslist@ARSLIST.ORG Subject: Re: ActiveDirectory - Converting long int values ? Robert, If I understand your question correctly, it seems you are very close... I

Re: ActiveDirectory - Converting long int values ?

2006-12-22 Thread Heider, Stephen
: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG ] On Behalf Of Heider, Stephen Sent: Friday, December 22, 2006 4:40 PM To: arslist@ARSLIST.ORG Subject: Re: ActiveDirectory - Converting long int values ? Robert, Here is the Active Link log

OT: Partition Manager

2006-12-21 Thread Heider, Stephen
Our Remedy server's C: drive needs to be repartitioned to have more disk space. We are going to purchase and use this software this weekend. The manufacturer is having a 40% off sale on all their products until the end of the month. I have previously used the software for another company to

Re: Tree Table Fields

2006-12-21 Thread Heider, Stephen
Rob, This might be the same bug that I found. From my support vendor email dated Dec 4: As we reported the problem with BMC, they detected this issue as a defect. The defect ID given by them is SW00255419. We are following up with them for any workaround, we will reply back as soon as we get

Re: What are?

2006-12-19 Thread Heider, Stephen
I concur. I frequently use Ctrl+Shift+F within Acrobat Reader and point to the folder that contains all the ARS documentation pdfs. This searches every pdf for the keywords or phrase you are looking for. Stephen -Original Message- From: Action Request System discussion

Re: Voting option when sending mails

2006-12-19 Thread Heider, Stephen
Sashi, Yes, it can be done. I use that here with html email forms. When the user clicks a button it submits their entry to a web app, which in turn updates Remedy. One thing to watch out for is the default button. If a user views the email then presses Enter one of the buttons will be

Re: Voting option when sending mails

2006-12-19 Thread Heider, Stephen
In the example I gave in my post from a few minutes ago, users must enter their password in a password field in the email form. The password and username are verified by the web app [that receives the user's post] prior to accepting it. Stephen From: Action

Re: Voting option when sending mails

2006-12-19 Thread Heider, Stephen
still dangerous because you are sending the password and username in clear text (I assume you are using an http get, providing the parameters in the url). Axton Grams On 12/19/06, Heider, Stephen [EMAIL PROTECTED] wrote: ** In the example I gave in my post from a few minutes

Ecora Connector for ARS

2006-12-19 Thread Heider, Stephen
Our company will soon evaluate Ecora Auditor Professional. The product will need to be integrated with the help desk (ARS 6.3). Has anyone worked with the Ecora Connector or the Ecora company? Stephen ___ UNSUBSCRIBE

Re: How do I create a checking out system

2006-12-15 Thread Heider, Stephen
Angie, Here is another approach that may be useful - it depends upon your environment. After reading your post this morning I started to consider different possibilities. There have been a lot of posts in the past regarding how to detect when someone else already has the same ticket open. As

Modify the Mid Tier Pop-Up Window

2006-12-15 Thread Heider, Stephen
ARS 6.3 Mid Tier 6.3 Windows Server 2003 IIS 6 ServletExec 5.0 Where are the settings located to customize the mid tier pop-up message box? This is the box that is displayed when a Message command is run in active links and filters. We would like to completely change it so that we can

Re: Can I call a filter inside an Escalation ???

2006-12-14 Thread Heider, Stephen
Tarun, In order to run a filter the form has to be updated. You could however, create a filter guide and filter that runs before any other filter. This new filter would call the new filter guide, which would call only those filters you want to run, then issue a GoTo 1000 to skip over the

Re: SSO - Again

2006-12-14 Thread Heider, Stephen
John, Regarding The SSO interface to the WUT was added later (7.0 I believe)., are there white papers, documentation, samples, etc. available for SSO in WUT? Stephen -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of John

Re: $PROCESS$ Issue

2006-12-13 Thread Heider, Stephen
One this to try is to add /c between cmd and copy. Another thing to try is placing the command in a batch/script file and calling it from from workflow. Stephen From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Scott

Re: OT: Remedy HTML Email and Outlook 2007 - Work-Around

2006-12-12 Thread Heider, Stephen
: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen Sent: Thursday, December 07, 2006 10:18 AM To: arslist@ARSLIST.ORG Subject: Re: OT: Remedy HTML Email and Outlook 2007 - Work-Around I found some more information. It's not good news. Outlook 2007

Re: Retrieving Date from SQL

2006-12-11 Thread Heider, Stephen
If I could add something to what Jim mentioned. In SQL Server functions (UDFs) can not return non-deterministic values directly. You can accomplish the goal of using or returning non-deterministic values (ie. GetDate(), GetUTCDate()) within a UDF by placing the non-deterministic values in a SQL

Re: ARUtilities Holiday Special

2006-12-08 Thread Heider, Stephen
Good deal! I just bought a copy for myself. Thanks. Stephen -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, December 08, 2006 7:48 AM To: arslist@ARSLIST.ORG Subject: OT: ARUtilities Holiday

Re: Fwd: Question: SQL

2006-12-07 Thread Heider, Stephen
Have you tried: Action 1 (if run from a filter): Set Fields zTmpField1 = UPPER($File1$) Action 1 (if run from an active link): Set Fields zTmpField1 = UPPER($File1$) WHERE RequestID = $RequestID$ Action 2: Set Fields SQL SELECT CHARINDEX('SOW', $zTmpField1$) and store to zTmpInt1 After it

Re: Fwd: Question: SQL

2006-12-07 Thread Heider, Stephen
PROTECTED] On Behalf Of Heider, Stephen Sent: Thursday, December 07, 2006 9:22 AM To: arslist@ARSLIST.ORG Subject: Re: Fwd: Question: SQL Have you tried: Action 1 (if run from a filter): Set Fields zTmpField1 = UPPER($File1$) Action 1 (if run from an active link): Set Fields zTmpField1 = UPPER

Re: OT: Remedy HTML Email and Outlook 2007 - Work-Around

2006-12-07 Thread Heider, Stephen
them to the zone.. unless you already trust its Certificate (ssl). Then it always shows. Hope that helps some.. On 12/7/06, Heider, Stephen [EMAIL PROTECTED] wrote: Slightly off topic, but this could soon affect recipients of Remedy html emails. Vista Ultimate

Re: Validate password through LDAP from a form.

2006-12-05 Thread Heider, Stephen
You could use or write a small command line app which is called from workflow that authenticates and returns either a 1 or 0. You may be able to create a user defined function (SQL Server 2005 + .Net) that authenticates a username+password and returns 1 or 0. HTH Stephen

Re: Database

2006-12-05 Thread Heider, Stephen
One benefit to using SQL Server 2005 is the ability to use .Net 2005 code for functions and stored procedures. Stephen From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Frank Caruso Sent: Tuesday, December 05, 2006

Re: MattReinfeldt.com Website Update

2006-12-04 Thread Heider, Stephen
Matt, I like the new look of the site. Thank you, and Vincent and Frank, for all the effort that went into making the site what it is today. I plan to download most items available on your site (lots of good stuff). I may have overlooked this, but is there a single zip file to download that

Re: Identify which filter created a notification

2006-12-01 Thread Heider, Stephen
Peter, I use codes that appear in the lower right corner of the html email in a small font. You could also make the codes (or names of filters) in hidden text. The text would be visible when you open the email in a text editor. For HPD:HelpDesk notifications, I use H01 - H##, for CHG:Change I

Re: How to create wait action?

2006-11-30 Thread Heider, Stephen
Anoop, If the wait needs to occur at the client (not the server) you can use a looping Active Link. Set a temp datetime field to $TIMESTAMP$ + 15 seconds. The Run If for the next AL would be $TIMESTAMP$ TmpDatetimeField. In this AL you would have one GoTo command that loops back on itself.

Re: Question: Attachments

2006-11-29 Thread Heider, Stephen
Tyrone, Use a Set Fields command that sets the attachment field to a temp char field. This will populate the temp char field with the name of the file. From here, you can test to see if certain text is inside the filename. Personal preference: If you are going to use this command multiple

Re: ARNOTE (10000)

2006-11-28 Thread Heider, Stephen
: ARS 5.1.2 Patch 1389, Mid-tier 6.3 Patch 13, Windows 2000. Thanks Radhika Direct : +44 20718 20262 Extn : 20262 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Heider, Stephen Sent: 27 November, 2006 9:45 PM To: arslist

Re: ARNOTE (10000)

2006-11-27 Thread Heider, Stephen
Radhika, As far as I know the message number can not be removed in the Windows User Tool, yet it can be removed in Mid Tier by modifying some configuration files (I did it a year ago and don't remember exactly where at this point). One alternative in the WUT is using your own pop-up display

Re: Login issue after domain change

2006-11-27 Thread Heider, Stephen
Pete, Is everyone using the same domain name? Add a Character field to the User form named Authentication String with a field of 118. Set the Default Value to your domain name. To initialize, update all User records [that use network authentication] by setting this new field to your domain

Re: Custom form logging help desk ticket

2006-11-16 Thread Heider, Stephen
Lisa, There is a free tool named BareTail (http://www.baremetalsoft.com/) that I use frequently. It allows you to view the active link log as it generates in real time. The tool is similar to AR Log Display but also works with server log files (actually, any text file). The thread OT: AR Log

Re: AR Email HTML Template

2006-11-14 Thread Heider, Stephen
Christopher, I use input boxes here in HTML templates with approvals. When someone requests access to an application, database, server, etc. from a web front-end a Remedy ticket is created and an approval email is sent to the next in line, usually the employee's supervisor. The supervisor types

OT: Sun Open Sources Java

2006-11-13 Thread Heider, Stephen
** http://www.techtree.com/India/News/Finally_Sun_Open_Sources_Java/551-77129-580.html Stephen __20060125___This posting was submitted with HTML in it___

Re: Very basic AD question...

2006-11-06 Thread Heider, Stephen
** Joe, This may or may not help you in this situation but just in case... Could you use a SQL View into AD and then create a Remedy form on top of the View? I have that setup here with the ADSI linked server. With SQL you could create elaborate coding that filters anything you want.

Email - Different FROM Address

2006-11-03 Thread Heider, Stephen
We have a new requirement that certain emails sent by Remedy need to have a different FROM address - the person who just modified the ticket. At first I planned on using multiple mailboxes, one for each person that has a record in the User form. But the ARS Email Engine evidently does not work

Re: Email - Different FROM Address

2006-11-03 Thread Heider, Stephen
: Friday, November 03, 2006 8:15 AM To: arslist@ARSLIST.ORG Subject: Re: Email - Different FROM Address Stephen, You can specify the from address in the notify action, on the messages tab. Heider, Stephen wrote: We have a new requirement that certain emails sent by Remedy need to have

Re: Email - Different FROM Address (U)

2006-11-03 Thread Heider, Stephen
Remedy Administrator Office # 703-602-2525 x251 CACI - Ever Vigilant(tm) Apparently, there is nothing that cannot happen today. Mark Twain -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen Sent: Friday, November 03

Re: Email - Different FROM Address - RESOLVED

2006-11-03 Thread Heider, Stephen
, 2006 9:06 AM To: arslist@ARSLIST.ORG Subject: Re: Email - Different FROM Address I don't think it does.. I have specified a from and reply-to address in several filters/escalations, all works as expected. Raido Heider, Stephen wrote: Raido, Yes, but I believe this has to map to an entry

Re: Aeroprise

2006-11-03 Thread Heider, Stephen
I concur. When I was evaluating Aeroprise products Pratik, Anoop and Martin were second to none. I have always been impressed with the professionalism of the people at this company. Stephen -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL

Re: How to reflect a new line in an HTML format?

2006-11-01 Thread Heider, Stephen
Remedy sometimes adds a space in front of the new line character in workflow. I use LTRIM to remove the leading space. REPLACE( $Short Description$ , LTRIM( |) , br ) *I used the pipe (|) symbol in this email instead of the actual new line character for readability. HTH Stephen

Remedy Support Site - Fixed? Endless Loop

2006-10-31 Thread Heider, Stephen
I just logged into the Remedy support site and proceeded to submit a new Issue. I received an error message You may not submit an Issue directly to BMC Support. Please contact your Support Channel (WIPRO LIMITED) to have them submit an Issue on your behalf (ARERR 356226). Ok, no problem, I will

Re: Client Application SSO (U)

2006-10-30 Thread Heider, Stephen
Dylan, The Remedy SSO interface requires additional configuration and programming on mid tier. From what I have read (here and elsewhere) and conversations I've had this is not trivial. Two mid tier-specific products I reviewed cost $15K - $20K for SSO, plus annual support. The SSO interface

Re: Newb needs API help...couple of questions

2006-10-30 Thread Heider, Stephen
Marc, Just a quick comment: Regarding You first real API call (ARGetListSchema), or a call to ARVerifyUser, will actually test out that the server/user/password is fine., in my login routine I attempt to generate a GUID immediately after login. If it works then I know the login was

Time Change - Processes Running Twice - Part Deux

2006-10-27 Thread Heider, Stephen
It's that time of year again where clocks get turned back an hour. The thread from Nov 2-7, 2005 entitled Time Change - Processes Running Twice includes info that may be useful to prepare for the time change this Sunday. OT: Except for extended evening daylight during the summer I wish this

Re: Client Application SSO (U)

2006-10-26 Thread Heider, Stephen
# 703-602-2525 x251 CACI - Ever Vigilant(tm) Apparently, there is nothing that cannot happen today. Mark Twain -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen Sent: Wednesday

Re: Client Application SSO (U)

2006-10-26 Thread Heider, Stephen
: arslist@ARSLIST.ORGSubject: Re: Client Application SSO (U) ** Stephen: How hard do you think this would be to extend into the UNIX world? James McKenzie L-3 GSI -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Heider

Re: Client Application SSO (U)

2006-10-26 Thread Heider, Stephen
, Heider, Stephen [EMAIL PROTECTED] wrote: For inquiring minds... here is the SSO solution I implemented here. Background: Over the last couple months I have been researching SSO solutions for Remedy, initially only for Mid Tier (6.3, 7.0). There are several good ones that will do the job

<    1   2   3   4   5   >