Re: Reporting question

2015-03-18 Thread Arner, Todd
Have you looked at using the My Reports menu on the mid-tier? Basically you would create your advanced query with parameters on the form you want to report against, run the query, select all from the search results, click the Report button, select the report that you already created, run the

How to find SQL query while querying a vendor form

2015-03-18 Thread MalviyaSaurabh
i All, An active link is defined on a display-only form, its set field action is querying a vendor form using the EXTERNAL operator. From the extract of the below plugin log I can see its failing when tryin to query ORB:asset_display form. I am getting an error like shown below: /Database

Re: How to find SQL query while querying a vendor form

2015-03-18 Thread LJ LongWing
Saurabh, If it was there, I would expect it to be between these two lines /* Wed /Mar 18 2015 07:28:08.4525 */+GLEWFARDBCGetListEntryWithFields – vendor CROOM.ARDBC.POSTGRE table ORB:asset_display /* Wed Mar 18 2015 07:28:08.8188 */-GLEWF FAIL/ but it's not there...you can try changing the

Re: How to find SQL query while querying a vendor form

2015-03-18 Thread Walters, Mark
As LJ points out, if the AR server was issuing the SQL it would be inside the API call. However, this is a vendor form backed by an ARDBC plugin, and it is this that is doing the actual data fetching. You’ll need to see what debug options are available for the plugin or, failing that, at the

How to configure TLS 1.1 or 1.2 transport protocol on outgoing web-service calls from ARSystem

2015-03-18 Thread Terry Bootsma
Hello ARSListers: This is a very specific technical question, so if anyone can help or has had experience configuring this, I would definitely appreciate any response. We are using Remedy 8.1.01 on Linux with the following java version: java version 1.7.0_09-icedtea OpenJDK Runtime

Re: Requirements Doc

2015-03-18 Thread Tami Palacky
thank you! On Tuesday, March 17, 2015 at 4:44:03 PM UTC-4, Lucero, Michelle wrote: ** Hi, Tami, et al:: The sample zoo requirements doc also exists in the 8.1.00 online documentation. Search for this *EXACT* text inside these quotation marks, “An example BMC Remedy AR System

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

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

2015-03-18 Thread Lippincott, Levi (OMA-GIS)
So are those values set manually and that is what you need to compare the current time stamp to or do you want to set those to workflow too? Levi Lippincott / Remedy Administrator +1 402 561 7014 office +1 402 321 5421 mobile levi.lippinc...@interpublic.com Interpublic Group  6825 Pine Street,

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 Lippincott, Levi (OMA-GIS)
So if it was me I would do the following. Existing Field Examples hour1 hour2 hour3 minute1 minute2 minute3 Next the number of extra fields I would create would change based on my need and how complex my comparison qualification will need to be. Assuming you need to compare all 6 fields I

Re: Incident template with tasks - no tasks?

2015-03-18 Thread Jason Miller
I have seen a small handful of the Ideas implemented. Not nearly what the Community and customer expect. Jason On Thu, Mar 12, 2015 at 5:49 AM, Martinez, Marcelo A marc...@cpchem.com wrote: ** Thank you guys… I suppose it just made sense in my head to have this. I haven’t used PD very

Re: Looking for a document

2015-03-18 Thread Thad Esser
Is this what you are looking for? (its for Oracle) https://docs.bmc.com/docs/display/public/ars81/Preparing+your+Oracle+database+before+you+install+the+AR+System+server#PreparingyourOracledatabasebeforeyouinstalltheARSystemserver-Settingupapreviouslycreatedtablespace Here's the link with links

Re: Digitally signed email or attached PDF

2015-03-18 Thread Jason Miller
I haven't done it but two things come to mind. 1) if there are command line utilities for your platform (Win/*nix) that can check the signatures then it must be doable with a combination of workflow and scripts. 2) I am figuring there are probably Java libraries that can check the signatures so

Looking for a document

2015-03-18 Thread Gordon Frank
I know there is a document which has all of the SQL code which is used when ARSYSTEM is built. Does anyone know the document which has this? I can't remember which one it is. Thanks Gordon Frank ___ UNSUBSCRIBE or

Archive-Delete possiblities for SLM forms

2015-03-18 Thread Madhu V
Hi List, Can anyone suggest me the Archive-Delete possiblities for below SLM forms?. SLM:AuditLog SLM:Measurement SLM:MilestoneLogging We found many Entries in the above forms , since the Database size is growing we want to go for Archive-Delete option. Please let me if you foresee any

Re: Incident template with tasks - no tasks?

2015-03-18 Thread Jason Miller
How much more time do you want me to spend on this? :) I think I have spend enough time on it today. a few second pass You know me too well. Here is a quick look at a few other product families. ProductDelivered Requested Percent Delivered Server Automation

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

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

2015-03-18 Thread Lippincott, Levi (OMA-GIS)
When you say three numeric fields for 3 hours and three numeric fields for 3 minutes do you mean you have 6 fields total used to store values like the following? Hour 1: 3 Hour 2: 6 Hour 3: 9 Minute 1: 15 Minute 2: 30 Minute 3: 45 Levi Lippincott /

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

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

2015-03-18 Thread Lippincott, Levi (OMA-GIS)
Pamela, My solution is probably way dumber than some of the responses you are going to get. :) Not knowing anything else about your environment I would set a temp hour and minute field using these functions HOUR($TIMESTAMP$) MINUTE($TIMESTAMP$) and then I would have another escalation whose

Re: Incident template with tasks - no tasks?

2015-03-18 Thread LJ LongWing
Jason, What if you compare the other product sets?there are a few out there touting that they listen to ideas and implement them...like Remedy Force, or Footprints? On Wed, Mar 18, 2015 at 3:17 PM, Jason Miller jason.mil...@gmail.com wrote: ** Ok, so I did some investigating and a little

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: Incident template with tasks - no tasks?

2015-03-18 Thread Jason Miller
Ok, so I did some investigating and a little number crunching. Below is the breakout of Ideas Delivered / Requested per Idea grouping. Idea Grouping Delivered Requested Percent Delivered AR System

SRM Product Orderinig Feature

2015-03-18 Thread Veronica Soriano
Has anyone implemented the SRM Product Ordering Feature. I prototyped this feature and it looks promising for one of my customer's requirements. Just want to see if there are any issues I should be aware of. Thank you.