Re: Retrieve data from SQL Menus

2013-11-27 Thread Sweety
Menu has below qualification (('CategorizationSchemaKeyword' = $23009$) OR ($23009$ = " ")) AND (('Asset Class' = $300483500$) OR ($300483500$ = $NULL$)) AND ('Status' = "Enabled") ___ UNSUBSCRIBE or access ARSl

Re: Retrieve data from SQL Menus

2013-11-27 Thread Sweety Khanna
Dim fieldValueList As New FieldValueList() fieldValueList.Item(23009) = "" fieldValueList.Item(300483500) = "" fieldValueList.Item(7) = "Enabled" Dim menuItems menuItems = Access.server.ExpandMenu("PCT:PDC:P1_CIType-Q", fieldValueList)

Re: Retrieve data from Search Menus

2013-11-27 Thread Misi Mladoniczky
Hi, It is exactly the same. Except for context sensitive stuff, which might be harder to do. You can spot it in the same way through DevStudio by seeing a $536870913$ text somewhere in the search thing. The id can be different. And if you have that, you must find and set this value withing the AR

Re: Retrieve data from SQL Menus

2013-11-27 Thread Misi Mladoniczky
Hi, You got what you need. The name of the API-call. Then you can read about what it does. I am just pointing you to a procedure where you can determine the API-calls needed by yourself instead of needing our help. If you are running MidTier, the ARGetCharMenu might have been done earlier when th

8.1 SP2 == JAVA question

2013-11-27 Thread John Baker
Patrick It's not so much java at fault but the ARAPI native libraries that are still - for a reason that completely escapes me - floating around the ARAPI. I thought it was supposed to be pure Java about 5 years ago, and it mostly is. John ___

Re: Retrieve data from Search Menus

2013-11-27 Thread Sweety
I want to retrieve the details from Search Menu not SQL Menu, my bad. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"

Re: Retrieve data from SQL Menus

2013-11-27 Thread Sweety Khanna
Hi Misi, I did not get much information in log, the only thing which I got in the low file is the below line +EXPQRY ARExpandQueryMenu from Remedy User (protocol 14) at IP address On Wed, Nov 27, 2013 at 4:05 AM, Misi Mladoniczky wrote: > Hi, > > I the C-API, it would be a combination o

Re: Target date Calc

2013-11-27 Thread Brian Goralczyk
David, I am happy that it is working, but I would caution you against doing math on the field value. It put a lot of extra work on the database. You are much better doing the math against the variable and look for fields that fall within that range. Particularly if you have an index on that fie

Re: area plugin authorization issue

2013-11-27 Thread Mueller, Doug
Sergio, What you are attempting is actually the most common use of AREA - using the AREA plugin for authentication but having the Authorization from the User form. All of the extra fields - groups, notification methods, email address - of the AREA return are optional. If they are not supplied,

Re: Target date Calc

2013-11-27 Thread David Boylan
Thanks Brian. I ended up using this - ((($\DATE$ + 86400) - ( '105261') >= ((60 * 60) * 1)) OR ('105261' = $\NULL$ )) AND 'Status' < "Resolved" This worked. ___ UNSUBSCRIBE or access ARSlist Archives at w

Re: Table field qualification length restrictions

2013-11-27 Thread Brian Goralczyk
Doug, Thank you sir. That is the answer I was looking for. I am just knocking out possible issues. I will look further. I wasn't 100% sure it was an issue with Remedy anyways. This helps confirm my suspicions and that is what I was looking for. Thank you. On Wed, Nov 27, 2013 at 11:30 AM,

Re: Table field qualification length restrictions

2013-11-27 Thread Mueller, Doug
Brian, There is no explicit limit to the size of an External qualification from the AR System side. Now, there could be limits of specific clauses from the DB or maybe there is something else going on. WIthout the error you are getting and determining where it is from, it is really difficult

Re: 8.1 SP2 == JAVA question

2013-11-27 Thread patrick zandi
ldd -d is the command.. There is some problem with it.. On Wed, Nov 27, 2013 at 11:32 AM, LJ LongWing wrote: > ** > Patrick, > To the best of my knowledge...there is no 8.1 SP2...just 8.1 Patch > 2the difference between a patch and a service pack is that a patch > requires you to install t

Re: Table field qualification length restrictions

2013-11-27 Thread Grooms, Frederick W
While I don't know of a limit off hand there may be one depending on your database (some databases do have a limit to the size of the where clause) Having the actual error (and what db you are on) would allow someone to give you a definitive answer Fred From: Action Request System discussion l

Re: Table field qualification length restrictions

2013-11-27 Thread Kemes, Lisa A DLA CTR INFORMATION OPERATIONS
Sorry, I should have asked my question differently. I meant to say, did you TEST the same qualification in a simple advanced search to see if it works that way. I was just curious... -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On B

Re: Table field qualification length restrictions

2013-11-27 Thread Brian Goralczyk
Lisa, I could certainly complete the process another way. But since this is an a current issue I am not looking to redesign it unless I have to. That is why I am asking about a limitation in the field length of the qualification rather than how to redesign it. And the error isn't a Remedy telli

Re: 8.1 SP2 == JAVA question

2013-11-27 Thread patchsk
Not same OS and java version. We are on Linux 6.x, ARS8.1p002, Oracle 11g and is working fine with jdk1.7.0_25. On Wednesday, November 27, 2013 8:19:04 AM UTC-8, patrick zandi wrote: > > ** > Hey'a all > ENV:Solaris 10, Oracle 11.2.0.3 > > If I run the arsystem on the JAVA 1.5.0_51 and JAVA

Re: 8.1 SP2 == JAVA question

2013-11-27 Thread LJ LongWing
Patrick, To the best of my knowledge...there is no 8.1 SP2...just 8.1 Patch 2the difference between a patch and a service pack is that a patch requires you to install the base, then patch 1, then patch 2but when the first service pack comes out, it will be a stand alone install that include

8.1 SP2 == JAVA question

2013-11-27 Thread patrick zandi
Hey'a all ENV:Solaris 10, Oracle 11.2.0.3 If I run the arsystem on the JAVA 1.5.0_51 and JAVA 1.6.0_43 version all works great If I attempt to use the JAVA 1.7.0_45 -- it fails horribly.. with the Errors below : contacted BMC they said it is not compatible with 1.7 .. YET:: my ars 7.1 P11

Re: OT: ServiceNow

2013-11-27 Thread richard....@bwc.state.oh.us
ARLIST is a great resource to have, but think about why it's needed. Could a competing product be so well designed and easy to use/customize/modify and so reliable that a similar comparable resource isn't needed? Could the SNOW folks be so attentive and interested in their customers that the custom

Re: Table field qualification length restrictions

2013-11-27 Thread Kemes, Lisa A DLA CTR INFORMATION OPERATIONS
Can you do this same qualification in a simple search or do you get the same error. Maybe show us the qualification as well. Lisa -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Brian Goralczyk Sent: Wednesday, November 27

Re: How to Parse a variable character string-RESOLVED

2013-11-27 Thread Misi Mladoniczky
Hi, Good. Note that my suggestion only used a single action. Best Regards - Misi, RRR AB, http://rrr.se > Thanks Misi and Terje! We actually figured it out using just 2 Set Fields > actions as follows: > > 1st Set Fields: > Setting '# Our Emails' with: STRSTR($Details$, " > Title:") >

Re: How to Parse a variable character string-RESOLVED

2013-11-27 Thread Carol Carnevali
Thanks Misi and Terje! We actually figured it out using just 2 Set Fields actions as follows: 1st Set Fields: Setting '# Our Emails' with: STRSTR($Details$, " Title:") Setting '# Our Calls' with: STRSTR($Details$, "Manager: ") 2nd Set Fields: Setting the desired field with: SUBSTR($Details$, $#

Table field qualification length restrictions

2013-11-27 Thread Brian Goralczyk
I have an issue that I am tracking down and I think a possible point of issue is the table field qualification. We are using a text field that is a compilation of data. We are then doing a "contains" qualification check against that field. When we hit a field length of just under 2000 characters

Re: Target date Calc

2013-11-27 Thread Brian Goralczyk
I would say a simple solution to this would be to add a hidden display only date/time field set to only date (which would always tell you midnight) then display where $Target Date$ >= $tempdate/time$ and $Target Date$ <= $tempdate/time$ + 86400 Another option would be to take a timestamp and dev

Target date Calc

2013-11-27 Thread David Boylan
I'm creating a new Sys Predefined Query that will appear on the Incident Console. The spec is that, the powers that be, want to see every incident that has a Target Date of today, even if it is after the server timestamp. I've come up with this - ((($\TIMESTAMP$ - '105261') >= ((60 * 60) *

Re: How to Parse a variable character string

2013-11-27 Thread Terje Moglestue
Carol, I assume all text is hold by one field. This can be done several way. There are no correct answer. Step 1) Use REPLACE and replace the text "Manager:" with a control character. # is a good control character. Step 2) Find the position of the control character. Step 3) Use REPLACE and re

Re: How to Parse a variable character string

2013-11-27 Thread Misi Mladoniczky
Hi, You need start and end position to get the name. Something like SUBSTRC($f$, STRSTR($f$, "Manager: ") + LENGTHC("Manager: "), STRSTR($f$, "Manager: ") - 1) The -1 at the end might need to be changed to 2, depending on if your system uses CR+LF or just LF for "carriage return". Let us knw ho

Re: Business Object Universe and 7.6.04 SP2 Overlay

2013-11-27 Thread tboot...@objectpath.com
** I'm pretty sure you are going to have to modify the universe to see this new table.  That's one of the reasons why the Analytics install/configure guide mentions to create a linked universe.   Terry   on Nov 27, 2013, Terje Moglestue wrote: ** Folks,   It might be my lack of understanding or k

Re: Opinions on COBIT

2013-11-27 Thread Rick Westbrock
Thanks Theo, I will check out those links. I am not on a path to take the exams, I just need to get some info on COBIT besides just the party line. Thanks, Rick On Nov 26, 2013 10:59 PM, "Theo Fondse (Gmail)" wrote: > Hi Rick! > > You are right about the comparison between ITIL and COBIT, but CO

How to Parse a variable character string

2013-11-27 Thread Carol Carnevali
Hello, I am trying to use Functions to parse out the manager's name from a character field that will always have the same format (see below) but, of course, the manager's name will be different in each case. Locations: 2 JSQ Manager: Dowling, John Title: Contingent Worker Note that there is a

Re: How can I save changes

2013-11-27 Thread Karthik
Cache flush is needed only if you make form level changes, menus and active links. It's nit needed for filters and escalations. - Karthik On Nov 27, 2013 5:41 PM, "Andrey Blednykh" wrote: > ** > > As I understand, I should also Flush Cache on Mid Tier server. > > Thank you very mush, Santosh. >

Business Object Universe and 7.6.04 SP2 Overlay

2013-11-27 Thread Terje Moglestue
Folks, It might be my lack of understanding or knowledge on the use of Business Object and their Universe. Our Business Object team just told me that they are having some data issues related to some of their reports. More correctly some of the users are reporting that the data reported in incor

Re: OT: ServiceNow

2013-11-27 Thread Pierson, Shawn
The thing to remember is that at the end of the day, once the installation is done you actually have to use the thing. The effort required for the upgrade is really none of the users' business other than scheduling the downtime with them. They care about the features and usability of the produ

Re: Runmacro fails

2013-11-27 Thread Misi Mladoniczky
Hi, "...$NULL$..." will be expanded by the shell to "...$...", which explains that problem. Try "...\$NULL\$..." instead. Then you can set environment ARAPILOGGING=1 and check the resulting arapicmd* and arapires* files to see how far the tool gets when you try to run the Macro you were talking

Re: How can I save changes

2013-11-27 Thread Andrey Blednykh
As I understand, I should also Flush Cache on Mid Tier server. Thank you very mush, Santosh. >** >Hi Andrey, >  >If you are making changes on a form through Developer Studio using dev server >then once changes are done, export the form into def file from Dev Studio then >connect to prod server

Re: How can I save changes

2013-11-27 Thread Andrey Blednykh
Santosh, thank you for the answer, I did it and restarted servers but I don't see any changes... What should I do else?  >** >Hi Andrey, >  >If you are making changes on a form through Developer Studio using dev server >then once changes are done, export the form into def file from Dev Studio t

Re: Add Status Reason for use on Asset UI

2013-11-27 Thread Vyom Labs Support
Hi, If you want to add status reason then you have to follow below steps: 1. Add a record to the SYS:Status Reason Menu Items form 2.Add status reasons in field called "Status Reason"(100150) on AST:Attribute 3.Open the respective join form delete the "Status Reason" field from form(

Re: Runmacro fails

2013-11-27 Thread Govind M
Misi, I have used ftp as well as scp. But still no results. Also, the below format throws the error as Unknown reference fields when the parser intercepts the $ symbol. runmacro -x -U -P -o "/App1/report.csv" -f "HPD:Help Desk" -t csv -q " ('UAN GO Number' != $NULL$ OR 'VAS exists flag' !=

Re: How can I save changes

2013-11-27 Thread Kumar, Santosh
Hi Andrey, If you are making changes on a form through Developer Studio using dev server then once changes are done, export the form into def file from Dev Studio then connect to prod server through Dev Studio and import the def file. I hope this helps. With best regards, Santosh Kumar From:

Re: Retrieve data from SQL Menus

2013-11-27 Thread Misi Mladoniczky
Hi, I the C-API, it would be a combination of doing first a ARGetCharMenu() followed by a ARExpandCharMenu(). It becomes complex if it is a context sensitive menu, where you need to insert a values into the structs. It should be straight forward for SQL menus, as it only contains a "string" with

Re: Remedy 7.6.04 Web Services Password encryption

2013-11-27 Thread Cosma Mihai
HTTP will always be open to man-in-the-middle attacks, so if you send your password hashed, the same password could still be sent by a third party impersonating as your user. This is why HTTPS must be used. You can use a dedicated user to call your webservices, and if you want to use a non-read