V.Urgent: How Incident/Change License works, how can we manage releasing

2008-10-27 Thread Manish SINGLA
Hello List, We are growing with our customer base from Remedy utilization in side ST, with which our incident and Change support people are growing. Now we need to estimate the utilization of Helpdesk and Change management Floating license utilization, so that we could plan what to buy more.

Re: V.Urgent: How Incident/Change License works, how can we manage releasing

2008-10-27 Thread Robert . 2 . Kern
Hello Manish, have no hands on experience on ITSM, but the user.log file should be a good starting point. Depending on your version, you can turn it on at the admin or user client, at the server-log settings. We do some license monitoring/opimization based on that log file, down to the user.

Re: V.Urgent: How Incident/Change License works, how can we manage releasing

2008-10-27 Thread Manish SINGLA
Hello Cheerio, Robert, Thanks for the quick response. I have extracted aruser.log but couldn't find segregated license for Helpdesk(Incident management) and Change Management. Aruser.log give only one consolidated picture of aruser licenses in use. Please advice some thing else can be

Re: RANT: Support Finally Got under my skin

2008-10-27 Thread Carey Matthew Black
I would verify that the ar server config file (ar.conf) has a line in it that specifies the group that you expect for this feature: ( Debug-GroupId ). I would then go to the Group form and find any records with that 'Group ID' value. ( There should be only one. ) And as an added sanity... take

Re: UNSUBSCRIBE

2008-10-27 Thread Darrell Reading
I dub thee UNSUBSCRIBEd. Darrell Reading Systems Engineer Phone 479.204.5739 [EMAIL PROTECTED] Wal-Mart Stores, Inc. 805 Moberly Lane, MS-0560-68 Bentonville, AR 72716 Save Money. Live Better From: Action Request System discussion list(ARSList)

Re: Using Military Time

2008-10-27 Thread Rod Harris
Let us know how you get on. Good luck with it, Rod -Original Message- From: Action Request System discussion list(ARSList) on behalf of Paul Blasquez Sent: Sat 10/25/2008 4:15 AM To: arslist@ARSLIST.ORG Subject: Re: Using Military Time Rod, Thank you for this info, I will go back

Re: Form dropped but still in schema table

2008-10-27 Thread Garrison, Sean (Norcross)
You will have to go deep into ar to fix this one: My guess is that the AP:Detail-Signature had been modified somehow. It used to contain a field that has since been removed. To explore this run the following queries: SELECT NUMFIELDS FROM ARSCHEMA WHERE NAME LIKE 'AP:Detail-Signature' SELECT

Adding days to a Date field in a qualification doesn't work

2008-10-27 Thread Mark Milke
Hi Listers, I have a date field on my form and I want to check, if the date entered isn't later than 6 months from now. I have an Active Link with the following qualification: 'my_date_field' $DATE$ + 182 This doesn't work. 'my_date_field' $DATE$ works just fine. As soon as I try to add any

Re: Adding days to a Date field in a qualification doesn't work

2008-10-27 Thread LJ Longwing
have you tried 'my_date_field' ($DATE$ + 182) so that it will add 182 to the date before doing the compare? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mark Milke Sent: Monday, October 27, 2008 8:27 AM To:

Re: Adding days to a Date field in a qualification doesn't work

2008-10-27 Thread Mark Milke
'my_date_field' ($DATE$ + 182) so that it will add 182 to the date before doing the compare? Yes, that's exactly what I did. Mark ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:

Re: Adding days to a Date field in a qualification doesn't work

2008-10-27 Thread Grooms, Frederick W
I usually have to put the Date fields inside quotes when doing calculations 'my_date_field' ($DATE$ + 182) Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mark Milke Sent: Monday, October 27, 2008 10:08 AM To:

Re: Adding days to a Date field in a qualification doesn't work

2008-10-27 Thread Tanner, Doug
Try 'my_date_field' ($DATE$ + 15724800) Humor me Doug -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mark Milke Sent: Monday, October 27, 2008 11:08 AM To: arslist@ARSLIST.ORG Subject: Re: Adding days to a Date field in a

Re: Adding days to a Date field in a qualification doesn't work

2008-10-27 Thread Opela, Gary L CTR USAF AFMC 72 CS/SCBAH
Yeah, I think that doug is on to something here. The $DATE$ keyword is referring to seconds, I believe, and thus you need to add six months worth of seconds. Note, that $DATE$ calculates to midnight that day, so if you need to calculate six months from now, then you will likely need to use

Carriage Return

2008-10-27 Thread Trevino, Rick
Hello, Does anyone know how to use a carriage return included in a value. Example: Field name: Value :field + $field name$ + would like carriage return then $field Name$ + $field name$ Data Field Field Field Version7.0.1

Re: Carriage Return

2008-10-27 Thread Opela, Gary L CTR USAF AFMC 72 CS/SCBAH
You will need to expand the window by clicking on the elipses (...). Whenever the box is expanded, do your set fields or whatever: Value: $Field$ + + $Field$ + If you put in an opening double quote, then hit enter, it will return to the next line, and then add your closing double quote.

Re: Adding days to a Date field in a qualification doesn't work

2008-10-27 Thread LJ Longwing
Oh...I know why it's not workingbecause $DATE$ can be used for both Date and Date/Time fieldsand remedy probably does some dynamic stuff to the value when you are doing a compare with a date field...so what you may need to do is setfield ztmp_datefield = $DATE$ setfield ztmp_datefield =

Re: Carriage Return

2008-10-27 Thread LJ Longwing
You need to open up the edit box for the setfield, and where you want the enter put + , then press enter and put your end quote (or more text if you want)...and when you answer ok to the edit box you will see a vertical black box where your enter is. _ From: Action Request System

Re: Adding days to a Date field in a qualification doesn't work

2008-10-27 Thread Tanner, Doug
Yeah, It is at the database level a Date/Time field, the DISPLAY property is TIME :) Doug -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Opela, Gary L CTR USAF AFMC 72 CS/SCBAH Sent: Monday, October 27, 2008 11:21 AM To:

Re: Adding days to a Date field in a qualification doesn't work

2008-10-27 Thread Frank, Gordon M. (CMS/CTR)
An easy way to do this is to use the multipliers. You will also need to use $TIMESTAMP$ 'my_date_field' ($TIMESTAMP$ + (60*60*24*182)) $TIMESTAMP$ returns the number of seconds elapsed since midnight Coordinated Universal Time (UTC) of January 1, 1970. Guess what platform Remedy ARS was first

Re: Carriage Return

2008-10-27 Thread Trevino, Rick
Gary, thanks I will try that Rick -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Opela, Gary L CTR USAF AFMC 72 CS/SCBAH Sent: Monday, October 27, 2008 10:27 AM To: arslist@ARSLIST.ORG Subject: Re: Carriage Return You will

Re: Adding days to a Date field in a qualification doesn't work

2008-10-27 Thread Rockwell, Rocky
What I use is $DATE$ + (60*60*24*182) in stead of the big long can't remember integer. That way I can see what I am adding. Rocky Rocky Rockwell Remedy Application Designer Wk Phone: 214-567-8874 Cell: 214-663-7229 [EMAIL PROTECTED] -Original Message- From: Action Request System

Re: Adding days to a Date field in a qualification doesn't work

2008-10-27 Thread Thomas Bean
Yes, that should work. Although the $DATE$ keyword can be used for both Date and Date/Time fields, using an arithmetic operation against the keyword seems to force it to translate into a date/time value (# of seconds instead of # of days) at the database level. You can observe this by running

JOB: Column Technologies seeking Senior Mid Level Remedy Consultants based in Dallas or Houston

2008-10-27 Thread Melissa Wish
We are seeking Mid and Senior level Remedy Consultants based in Texas- preferably Houston or Dallas. *These are permanent positions with generous salary, bonus, benefits and vacation packages. Senior Level Candidates must have ITSM implementation experience. If you're interested please

Quick Question: RedHat with MS-SQL?

2008-10-27 Thread Herb Geozos
I think I already know the answer here based on the product compatibility chart (no), but I have a customer who is a fairly adamant RedHat shop, but at the same time their DB licensing is all MS-SQL. Is anybody out there running this combo, and/or is it supported? Many Thanks in Advance, Herb

Re: Quick Question: RedHat with MS-SQL?

2008-10-27 Thread Matt Worsdell
They put Microsoft SQL on Redhat, I don't think so! I think I already know the answer here based on the product compatibility chart (no), but I have a customer who is a fairly adamant RedHat shop, but at the same time their DB licensing is all MS-SQL. Is anybody out there running this combo,

Re: Quick Question: RedHat with MS-SQL?

2008-10-27 Thread LJ Longwing
Due to the fact that Remedy uses 'native libraries' to connect to the DB, and MS doesn't publish native libraries to connect to MS SQL, then Remedy doesn't support that combination. _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Herb Geozos

Re: Adding days to a Date field in a qualification doesn't work

2008-10-27 Thread Thomas Bean
Frank, This syntax will work if searching a Date/Time field, but it will not work with a Date (only) field. The value on the right side of the qualification (($TIMESTAMP$ + (60*60*24*182)) would generate an integer value well beyond the range of the Date field type. If you divided this value

Re: JOB: Column Technologies seeking Senior Mid Level Remedy Consultants based in Dallas or Houston

2008-10-27 Thread Drew Shuller
Melissa, are you getting any traction for these positions? Drew We are seeking Mid and Senior level Remedy Consultants based in Texas- preferably Houston or Dallas. *These are permanent positions with generous salary, bonus, benefits and vacation packages. Senior Level Candidates must

Re: V.Urgent: How Incident/Change License works, how can we manage releasing

2008-10-27 Thread Easter, David
What version of ITSM are you on? The answer differs depending on the version. For ITSM 6.0 or previous, application licenses were not formally tracked during operation. For ITSM 7.0 and above, applications licenses are processed and enforced by the server using the same logic as the AR

Active Link Function in an Escalation???

2008-10-27 Thread Pruitt, Christopher J
Hello Fellow Listers, Does anyone know a way to mimic the Active Link functions within an Escalation? I am trying to find a way to do the following to create log entries, on a UNIX server, that have a unique timestamp. These logs turn on and off every day. These logs are created via a SET FIELDS

Re: Active Link Function in an Escalation???

2008-10-27 Thread Joe DeSouza
Chris, Have you tried replacing the invalid characters to either null or an underscore or something? Joe - Original Message From: Pruitt, Christopher J [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, October 27, 2008 2:13:37 PM Subject: Active Link Function in an

Re: Adding days to a Date field in a qualification doesn't work

2008-10-27 Thread Joe DeSouza
Mark, Even if that did work, it wouldn't be always accurate, considering leap years or the 2 consecutive months that we have 30 days. Why not try string manupulation, by setting the current value contained in the date field, to a character field and then find the month position and extract

Re: Active Link Function in an Escalation???

2008-10-27 Thread Pruitt, Christopher J
Yes, but it still does not get us to the MMDD format we need. We can get DDMMYY at best so far. Christopher Pruitt EDS, an HP Company mailto: [EMAIL PROTECTED] We deliver on our commitments so you can deliver on yours. Confidentiality Notice: This message and any files transmitted with

Re: Active Link Function in an Escalation???

2008-10-27 Thread Grooms, Frederick W
What kind of error are you getting using TIMESTAMP? I have used the DAY, MONTH, and YEAR functions in set fields before with no problems (Except having to use LPAD as well). Escalation_ + LPAD(YEAR($TIMESTAMP$),4,2000) + LPAD(MONTH($TIMESTAMP$),2,00) + LPAD(DAY($TIMESTAMP$),2,00) + .log Fred

Re: Active Link Function in an Escalation???

2008-10-27 Thread Whaley, David G (Contractor)
If you are just trying to create a log file you can use the unix date command to achieve this. Going from memory here but you could use a run process action, and a command that looks like this, mv your_escalationfile.log `date +escalation_%Y%m%d.log` David

JOB: Senior Remedy Developer; Sydney/Australia; 6 Month Contract

2008-10-27 Thread Gareth Oliver
My friend is relisting the job I posted recently, this time as a contract position. Ideally the person would already has working rights in Australia, but the client will sponsor. Lynne's contact details are at the end. No consulting/recruitment organisations, this time please.

Re: Data - For Server Events

2008-10-27 Thread John
OK -- so I finally looked into ar.h (per Axton) to figure out what the form 'server events' is telling me. However -- I still don't quite know how to interpret the info provided. Has anybody actually used the Server Events with success? And - what did you do? Here is what I have in my

LOB Space Reclaim Issue

2008-10-27 Thread Do Duy
Hi, I just wanted to find out if anyone has had this problem and possibly how the issue was resolved. Details of the problem is below. Thank you in advance, Duy Do Broadcast Australia Database Version Database is on Oracle 10G 10.2.0.2.0 Standard Edition on Sun Solaris.

Mark Boyle is out of the office.

2008-10-27 Thread Mark Boyle
I will be out of the office starting 28/10/2008 and will not return until 29/10/2008. I will respond to your message when I return. - IMPORTANT NOTICE : The information in this email is confidential and may also be privileged. If you are not the intended recipient, any use or