REMEDY 8.1: I NEED GET HOUR AND MINUTE SEPARATELY

2015-03-18 Thread Pamela Morales
Hi everyone,

I need use in an escalation the hour and the minute from $TIME$ or $TIMESTAMP$ 
to compare with a numeric field which has the hour and otherone has the minute 
to execute an action.

I need asap to resolve a customer's case 

Thanks

Pamela

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"


Re: REMEDY 8.1: I NEED GET HOUR AND MINUTE SEPARATELY

2015-03-18 Thread Pamela Morales
Hi,

Originally,  I had a form with three time fields. I need to save those on the 
form becasuse with an escalation I compare those fields to $TIME$, and if this 
qualification is true, the escalation push fields on 
CHG:ChangeInterface_Create. The only part that is not working is the 
comparision between the time fields and $TIME$ because I need to execute only 
once per time, and it is executed more than once because it is taking seconds.

Now, I'm trying to do the same form with three numeric fields for 3 hours and 
three numeric fields for 3 minutes. I need to save those on the form becasuse 
with an escalation I compare those hours and minute, and execute the action. I 
guess it could work and compare once.

So??What should I do??

Regards

Pamela

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"


Re: REMEDY 8.1: I NEED GET HOUR AND MINUTE SEPARATELY

2015-03-18 Thread Pamela Morales
Yes, Now I do like that.

Hour1:  3  Minute1: 15
Hour2:  15  Minute1: 30
Hour3:  18  Minute1: 59


Before, I had

Hora1: 03:15:00
Hour2: 15:30:00
Hour3: 18:59:00

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"


Re: REMEDY 8.1: I NEED GET HOUR AND MINUTE SEPARATELY

2015-03-18 Thread Pamela Morales
Yes, they are setted manually and I need compare to time stamp

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"


Re: REMEDY 8.1: I NEED GET HOUR AND MINUTE SEPARATELY

2015-03-18 Thread Pamela Morales
Let me try...

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"


Re: REMEDY 8.1: I NEED GET HOUR AND MINUTE SEPARATELY

2015-03-19 Thread Pamela Morales
Hi Levi,

I had try your suggestion. But It is taking every minute whole registers on the 
form even if the hour and minute doesn't meet the condition.

Here is my run if on the escalation which create the ticket.

('FechaInicioEjecucion' <= $DATE$) AND (('Dia1' = $WEEKDAY$) OR ('Dia2' = 
$WEEKDAY$) OR ('Dia3' = $WEEKDAY$) OR ('Dia4' = $WEEKDAY$) OR ('Dia5' = 
$WEEKDAY$) OR ('Dia6' = $WEEKDAY$) OR ('Dia7' = $WEEKDAY$)) AND 
('EstadoTareaDiaria' = "Activado") AND ('HoraAct' >= 'Hora') AND ('HoraAct2' < 
'Hora2') AND ('Min' >= 'Minuto') AND ('Min2' < 'Minuto2')

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"


Re: REMEDY 8.1: I NEED GET HOUR AND MINUTE SEPARATELY

2015-03-19 Thread Pamela Morales
Hi Levi,

I had try your suggestion. But It is taking every minute all registers on the 
form even if the hour and minute doesn't meet the condition.

Here is my run if  qualification on the escalation which create the ticket.

('FechaInicioEjecucion' <= $DATE$) AND (('Dia1' = $WEEKDAY$) OR ('Dia2' = 
$WEEKDAY$) OR ('Dia3' = $WEEKDAY$) OR ('Dia4' = $WEEKDAY$) OR ('Dia5' = 
$WEEKDAY$) OR ('Dia6' = $WEEKDAY$) OR ('Dia7' = $WEEKDAY$)) AND 
('EstadoTareaDiaria' = "Activado") AND ('HoraAct' >= 'Hora') AND ('HoraAct2' < 
'Hora2') AND ('Min' >= 'Minuto') AND ('Min2' < 'Minuto2')

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"


How can I create ticktes for Change on status "closed"

2015-03-31 Thread Pamela Morales
**
Hi everybody,

I need create tickets for changes on status "closed". We need use the Data Import.

I'm doing that but I'm getting this error on arerror log  

Mar 30 16:38:24 2015  390603 :  : You must provide the Actual Start Date and Actual End Date when completing or closing a change. (ARERR 1440220)

I sent those fields on the .csv file but I don't know why is it??

How can I solve this??

Regards

Pamela
_ARSlist: "Where the Answers Are" and have been for 20 years_


Re: How can I create ticktes for Change on status "closed"

2015-04-02 Thread Pamela Morales
Hi, Thanks for your answer.

I was trying to do like you told, but I'm adding four date field on 
CHG:ChangeInterface_Create:

EarliestDate, CompletedDate, ClosedDate and SubmitDate,

and I was trying to map on the filter CHG:ICI:CreateChange_100`! each one with 
the fields on CHG:InfrastructureChange, but the SubmitDate I'm not allowed to 
map, because it is not listed on the mappig view.

I guess those fields are the required. 

May you help me with some idea??

Thanks

Best Regards,

Pamela

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"


VIP* Field on HPD-INC-AssigneeAssignment SYS:NotificationMessages

2015-04-14 Thread Pamela Morales
Hi Everybody,

I need send the field VIP* from CTM:People on HPD-INC-AssigneeAssignment which 
is a SYS:NotificationMessages for the assignee to know if the requester is a 
VIP user or not.

Thanks for yours asap answers.

Best Regards,

Pamela Morales

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"


Remedy 7.6.04, Second ARServer added to servergroup without rank number

2015-04-16 Thread Pamela Morales
Hello,

I'm configuring a server group wiht two arservers, I'm following the guide, I 
did step by step, but when I added the second server group the rank number is 
empty and this should be 2.

I tried Server- Connection- Name: FQDN but it doesn't work

I hope your help to solve this issue.

Thanks

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"


Re: Remedy 7.6.04, Second ARServer added to servergroup without rank number

2015-04-16 Thread Pamela Morales
Hi, Thanks for your answer.

I would like know if this kind of workaround to set the operation rank to the 
second server could cause any issue later??


Thansk for your feedback

Pamela

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"


Re: Remedy 7.6.04, Second ARServer added to servergroup without rank number

2015-04-17 Thread Pamela Morales
Thanks I got it!!

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"


How populate a table in a form with data from other form

2015-05-27 Thread Pamela Morales
Hi everyone,


I need help!!

I'm adding a tab on CHG:Infrastructure Change on which should display a table 
with data from AP:Question-Comment-Info. 

The search criteria is AppRequest=$Infrastructure Change ID$, this should 
display a list of the registers that met the qualification.

But it is not displaying nothing...

Please your help

Best Regards

Pamela

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"


Re: How populate a table in a form with data from other form

2015-05-28 Thread Pamela Morales
Hi, how can I refresh the object automatically when the form is opened??

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"


Re: How populate a table in a form with data from other form

2015-05-28 Thread Pamela Morales
I would like to refresh the table automatically on the tab when the form is 
opened.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"


Re: How populate a table in a form with data from other form

2015-05-28 Thread Pamela Morales
And I need to take the data on the  rows and columns of the table and post on a 
character field.

How can I do that action??

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"


Incident Requester Info on a Change before save the change

2015-06-03 Thread Pamela Morales
Hi everyone,

I need bring the incident requester name and lastname to the change form when I 
click on create a infrastructure change on Incident Form.

How can I access those field from Infrastructure Change before save the 
change???

Thanks for your answers

Pamela

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"


Count CRQ related an INC in status=<"Completed"

2015-06-18 Thread Pamela Morales
Hi,

I need know how can I get in a field the result of 

SELECT COUNT (*) FROM CHG_Association_ID02Join WHERE (Request_ID01 =$Incident 
Number$  AND RequestID02_Status>=10)

What I need is that no one could resolve or close or cancel and incident if it 
has one or more related changes in status less than completed, closed or 
canceled.


I was trying to do this by a filter with a Direct SQL command with this query, 
but I don't know how to take the number of the result of the query.

If you have any other solution please, let me know.

Best Regards,

Pamela

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"


Re: Count CRQ related an INC in status=<"Completed"

2015-06-19 Thread Pamela Morales
Hi Bruce,

I tried what you recommend, but I got an error: Invalid column name 
'INC2014000903'. (SQL Server 207) (ARERR 552). I'm trying to do this SQL 
Sentence:


SELECT COUNT (*) FROM dbo.CHG_Association_ID02Join WHERE (Request_ID01 
="$Incident Number$"  AND RequestID02_Status>=10)

I will be grateful  with your help

Thanks

Pamela

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"


URGENT: Company without service because of ARERR 337, but it has the license applied.

2015-06-29 Thread Pamela Morales
Hi everybody,

We need help urgently, the users of Remedy 7.6.04 cannot access even do any  
task on Remedy, because they get ARERR 337 about licenses. but we review and 
the ARSERVER is with the correct license.

Please help 

Pamela

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"


Re: URGENT: Company without service because of ARERR 337, but it has the license applied.

2015-06-29 Thread Pamela Morales
Hi,

We solved, it was a change in the MAC Address of the Virtual Machine 'cause by 
an infrastructure incident.

Thx a lot..

Pamela

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"


Intergration BMC Remedy - MS Dynamics

2015-07-08 Thread Pamela Morales
Hi everybody,

 A customer needs to integrate BMC Remedy 8.1 with MS Dynamics and MS Dynamic's 
technical staff recommend to make this integration via Odata(REST).

Are there a simple way to integrate?? In another hand, how do we make the 
integration by Odata(REST) Protocol?? Are there any tutorial or information for 
this activity??

I'll grateful so much your help.

Best Regards,

Pamela 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"