Re: Remedy 7.6.04 Web Services Password encryption
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-readable password, it is always up to you. Take your word password, put it through a MD5, SHA - or whatever else you like - generator and set it in Remedy and in the other system as 5f4dcc3b5aa765d61d8327deb882cf99. This way, at least you can pretend it is not clear text. Except for what was already mentioned (HTTPS) don't forget about firewalling to permit access only from specific hosts. Hope it helps. Best regards, Mihai -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of John Baker Sent: Tuesday, November 26, 2013 11:08 PM To: arslist@ARSLIST.ORG Subject: Remedy 7.6.04 Web Services Password encryption Expanding on LJ's response, you may wish to consider SSL client certificates, so users of the service can not connect unless they have a client certificate. Whilst there's probably no way to get the username from within the (very limited) AR System web service implementation, you can at least sleep soundly knowing you know who's connecting to it. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years The information contained in this e-mail message is privileged and confidential and is for the exclusive use of the addressee. The person who receives this message and who is not the addressee, one of his employees or an agent entitled to hand it over to the addressee, is informed that he may not use, disclose or reproduce the contents thereof, and is kindly asked to notify the sender and delete the e-mail immediately. ___ 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
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 the sqlcommand. If it has a $536870913$ or similar field id in it, it must be replaced with a string or integer. I suggest that you browse through the C-API-documentation to get an idea of what kind of calls there is. You can also turn on API-logging to see which API-calls are executed for a certain kind of operation. This can be done with Client-side-logs while enabling logging for Server-API in the AR System User Preferences form. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Hi List, How can I retrive the data from SQL Menus through .Net API programming ? Any sample code would be great. Regards, Sweety ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: How can I save changes
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: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Andrey Blednykh Sent: Wednesday, November 27, 2013 12:05 PM To: arslist@ARSLIST.ORG Subject: How can I save changes ** Hello, friends, I have started to work with BMC Remedy recently and now I have quite simple question. How can I save/deliver form which was changed in Developer to the production server? Maybe you will give me advice where I can read about it exactly? We use ARSystem Server 7604 sp4 / Tomcat 6 on Windows 2008 R2 Server. Thanks in advance! _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Runmacro fails
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 servername -U username -P password -o /App1/report.csv -f
HPD:Help Desk -t csv -q ('UAN GO Number' != $NULL$ OR 'VAS exists flag' !=
$NULL$) AND 'Status*' 4
Accessing server - servername...
Processing form - HPD:Help Desk ...
Unknown field reference - position 47 (...ists flag' != $^) AND
'Status*'...) [ARERR 2297]
Server - servername access complete with total matches of 0 record(s).
Thanks,
Govind M
+91 8123458366
Atheeb Remedy Team
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky
Sent: Tuesday, November 26, 2013 9:18 PM
To: arslist@ARSLIST.ORG
Subject: Re: Runmacro fails
Hi,
Copy/paste seems to be a bad idea, as there are some special control characters
in the file.
I suggest you use ftp or scp instead, and see if that helps.
Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13):
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.
Hi listers,
I was trying to execute the below command in Putty.
./runmacro -d path of macrofile -x servername -U username -P
password -e reportsavedname
It gives the below statement and exist. As a prequisite, I have
updated the path of macrofile and runmacro binary in LD_LIBRARY_PATH.
Also added
LoadSchemaFromCache: F in conf. But no result.
Action Request System Unix Runmacro Version 7.1.00 Copyright (c) BMC
Software, Inc. 1991-2007. All rights reserved.
Executing macro - UANVASReport. Please wait...
Segmentation Fault (core dumped)
But I still have a doubt on the format of *.arq file which was
recorded in windows client and copy pasted into unix directory with
permissions. I just changed the to file: path adjusting to Unix format.
Is there something I am missing to do.? Appreciate any suggestion.
Solaris 10, ARS 7.1 Patch 8
Thanks,
Govind
Please do not print this email unless it is absolutely necessary.
The information contained in this electronic message and any
attachments to this message are intended for the exclusive use of the
addressee(s) and may contain proprietary, confidential or privileged
information. If you are not the intended recipient, you should not
disseminate, distribute or copy this e-mail. Please notify the sender
immediately and destroy all copies of this message and any attachments.
WARNING: Computer viruses can be transmitted via email. The recipient
should check this email and any attachments for the presence of
viruses. The company accepts no liability for any damage caused by any
virus transmitted by this email.
www.wipro.com
__
_ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers
Are, and have been for 20 years
The information contained in this electronic message and any attachments to
this message are intended for the exclusive use of the addressee(s) and may
contain proprietary, confidential or privileged information. If you are not the
intended recipient, you should not disseminate, distribute or copy this e-mail.
Please notify the sender immediately and destroy all copies of this message and
any attachments.
WARNING: Computer viruses can be transmitted via email. The recipient should
check this email and any attachments for the presence of viruses. The company
accepts no liability for any damage caused by any virus transmitted by this
email.
www.wipro.com
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years
Re: Add Status Reason for use on Asset UI
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(in this case AST:BaseElement ) (Note : We have to Convert respective form to custom from base because we are getting error no delete flag is enabled on regular form ) 4. Again add the that field from AST:Attribute in that join 5.then check the field values are reflected on join form or not Then When you create records status reason value will save on form . :) Regards, ITSM Support (Bhagyashri Jogdand) Vyom Labs Pvt. Ltd. BSM Solutions Services || ITIL Consulting Training Email: [hidden email] http://ars-action-request-system.1093659.n2.nabble.com/user/SendEmail.jtp?t ype=nodenode=7583733i=0 || Web Site: www.vyomlabs.com Follow Vyom Labs http://twitter.com/#!/vyomlabs http://twitter.com/#%21/vyomlabs || http://www.linkedin.com/company/vyom-labs From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Smerz, Christian Sent: Wednesday, November 27, 2013 2:36 AM To: arslist@ARSLIST.ORG Subject: Re: Add Status Reason for use on Asset UI ** This would now be a field on the AST:Attributes form. Part of the architecture change for AM/CMDB is to move asset lifecycle fields to this form and out of the CMDB. We modified the field (through overlay) directly. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Hennigan, Sandra Sent: Tuesday, November 26, 2013 3:01 PM To: arslist@ARSLIST.ORG Subject: Add Status Reason for use on Asset UI ** Windows 2008 r2 Oracle 11g ARS 8.1 ITSM 8.1 I need to add new Status Reason attributes for use on Asset UI records. The directions I have found pertain to Incident, Change or Work Order. The directions have you add a attribute to the Status Reason_Hidden field on the form then add a record to the SYS:Status Reason Menu Items form. I have not found directions for adding new Status Reason for Asset UIs and could not find a corresponding Status Reason_Hidden field on the BMC Base Element form. I added a record for the new Status Reason on the SYS:Status Reason Menu Items form. The new Status Reason can be selected on any Asset UI but when the record is saved, the selected Status Reason does not save. Assistance appreciated. Thank you, Sandra Hennigan Remedy Developer _ARSlist: Where the Answers Are and have been for 20 years_ _ This message (including any attachments) is confidential and intended for a specific individual and purpose. If you are not the intended recipient, please notify the sender immediately and delete this message. _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: How can I save changes
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 then connect to prod server through Dev Studio and import the def file. I hope this helps. With best regards, Santosh Kumar From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Andrey Blednykh Sent: Wednesday, November 27, 2013 12:05 PM To: arslist@ARSLIST.ORG Subject: How can I save changes ** Hello, friends, I have started to work with BMC Remedy recently and now I have quite simple question. How can I save/deliver form which was changed in Developer to the production server? Maybe you will give me advice where I can read about it exactly? We use ARSystem Server 7604 sp4 / Tomcat 6 on Windows 2008 R2 Server. Thanks in advance! _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: How can I save changes
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 through Dev Studio and import the def file. I hope this helps. With best regards, Santosh Kumar From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Andrey Blednykh Sent: Wednesday, November 27, 2013 12:05 PM To: arslist@ARSLIST.ORG Subject: How can I save changes ** Hello, friends, I have started to work with BMC Remedy recently and now I have quite simple question. How can I save/deliver form which was changed in Developer to the production server? Maybe you will give me advice where I can read about it exactly? We use ARSystem Server 7604 sp4 / Tomcat 6 on Windows 2008 R2 Server. Thanks in advance! _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Runmacro fails
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 about earlier.
Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13):
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.
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 servername -U username -P password -o /App1/report.csv -f
HPD:Help Desk -t csv -q ('UAN GO Number' != $NULL$ OR 'VAS exists flag'
!= $NULL$) AND 'Status*' 4
Accessing server - servername...
Processing form - HPD:Help Desk ...
Unknown field reference - position 47 (...ists flag' != $^) AND
'Status*'...) [ARERR 2297]
Server - servername access complete with total matches of 0 record(s).
Thanks,
Govind M
+91 8123458366
Atheeb Remedy Team
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky
Sent: Tuesday, November 26, 2013 9:18 PM
To: arslist@ARSLIST.ORG
Subject: Re: Runmacro fails
Hi,
Copy/paste seems to be a bad idea, as there are some special control
characters in the file.
I suggest you use ftp or scp instead, and see if that helps.
Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13):
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.
Hi listers,
I was trying to execute the below command in Putty.
./runmacro -d path of macrofile -x servername -U username -P
password -e reportsavedname
It gives the below statement and exist. As a prequisite, I have
updated the path of macrofile and runmacro binary in LD_LIBRARY_PATH.
Also added
LoadSchemaFromCache: F in conf. But no result.
Action Request System Unix Runmacro Version 7.1.00 Copyright (c) BMC
Software, Inc. 1991-2007. All rights reserved.
Executing macro - UANVASReport. Please wait...
Segmentation Fault (core dumped)
But I still have a doubt on the format of *.arq file which was
recorded in windows client and copy pasted into unix directory with
permissions. I just changed the to file: path adjusting to Unix format.
Is there something I am missing to do.? Appreciate any suggestion.
Solaris 10, ARS 7.1 Patch 8
Thanks,
Govind
Please do not print this email unless it is absolutely necessary.
The information contained in this electronic message and any
attachments to this message are intended for the exclusive use of the
addressee(s) and may contain proprietary, confidential or privileged
information. If you are not the intended recipient, you should not
disseminate, distribute or copy this e-mail. Please notify the sender
immediately and destroy all copies of this message and any attachments.
WARNING: Computer viruses can be transmitted via email. The recipient
should check this email and any attachments for the presence of
viruses. The company accepts no liability for any damage caused by any
virus transmitted by this email.
www.wipro.com
__
_ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers
Are, and have been for 20 years
The information contained in this electronic message and any attachments to
this message are intended for the exclusive use of the addressee(s) and may
contain proprietary, confidential or privileged information. If you are not
the intended recipient, you should not disseminate, distribute or copy this
e-mail. Please notify the sender immediately and destroy all copies of this
message and any attachments.
WARNING: Computer viruses can be transmitted via email. The recipient should
check this email and any attachments for the presence of viruses. The company
accepts no liability for any damage caused by any virus transmitted by this
email.
www.wipro.com
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years
Re: OT: ServiceNow
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 product that result from the upgrade. Remedy's UI can be cumbersome but I don't see SNOW as being superior in that regard, just that they have less fields on their forms. However, if my organization was interested in having our data hosted on the internet in a cloud environment (not the case at the moment) I would look into SNOW. It sounds like ROD comes with a lot of bureaucracy. SNOW is an unknown to me in that regard but we already know how BMC's support can be. I'm still skeptical of several things about both products but I also think competition in the marketplace is a good thing as long as I can stay current on the technologies. Thanks, Shawn Pierson Remedy Developer | Energy Transfer From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of laurent matheo Sent: Tuesday, November 26, 2013 12:41 PM To: arslist@ARSLIST.ORG Subject: Re: OT: ServiceNow ** I was working on a proposal for my company, migration from 7.6.04 to 8.x. We showed the whole « migration in multiple steps and data migration » process. Customer told us (I quote, well... quote translated from French): « SNOW presale tech engineer told us that on their solution an upgrade was clicking on a button with less than one minute downtime on production »... What do you want to reply to this? :D Those guys are over agressive, I mean, we can make stuff sound better than real life during presale, but come on... There is a difference between « truth enhancement » and this :) And I surely don't wanna go this road, lying to get a deal... Imagine I get on the project later, total waste and utter failure. De : Pierson, Shawn shawn.pier...@energytransfer.commailto:shawn.pier...@energytransfer.com Répondre à : arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Date : mardi 26 novembre 2013 22:34 À : arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Objet : Re: OT: ServiceNow ** My company has also recently taken a look at Service Now. I can also confirm hearing some deliberately false information being provided, but that's likely typical for any sales presentation. That being said, I do have a cautiously positive view of their product. The techie part of my personality would like to make the switch just to learn something completely new and exciting, but in terms of doing what's best for my organization I don't think it's fully matured enough yet to replace Remedy, plus not all companies are willing to have their private data out on the cloud yet. I've also come to the opinion that us Remedy folks are maybe more opposed to some of the people involved with ServiceNow and their marketing techniques than the anything else. Either way, I plan to keep my eye on them and if my management told me tomorrow that they signed me up for classes and that we'd be migrating to that product, I would treat it as an opportunity not treat it as the end of the world. Thanks, Shawn Pierson Remedy Developer | Energy Transfer From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of arslist Sent: Tuesday, November 26, 2013 2:26 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: OT: ServiceNow ** That is I was looking at SNOW in terms of knowing what's good and what is bad. No product is the best at everything. I am certainly more open minded about the products than most folks I met at the SNOW conference were. To them [SNOW conference attendees, the ServiceNow employees and others] BMC Remedy is the enemy and it can do no right. There were many expressing blatantly false views, I kept my opinions mostly to myself. Well, I did have to correct former BMC employees who were saying Fred Luddy had something to do with creating Remedy. A view I heard enough times to consider it to be deliberate. Yes, the marketing is a direct steal from what Remedy Corp. said in the 1990s, and there is a tiny bit of truth to some of what they say. Mostly though, if the developer studio were sped up to the speed of the old Admin tool, It could easily be shown you can create robust custom apps faster and easier with Remedy than with ServiceNow. Real apps that is, with a real data model. They however, can show creating new fields and apps in minutes due to the simplicity of the system, the data model, what gets displayed and the simplistic development tool that does not show that all real development is done by working on java scripts. That being said, if you want quick and simple display of quick and simple data in a quick and simple data model, it arguably can. Then again, so can dozens of other light weight applications. RemedyForce would certainly seem the
Business Object Universe and 7.6.04 SP2 Overlay
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 incorrect. A quick look at the data confirms that Business Objects Universe is ignoring the BMC Overlays. Is this correct? Do we really need to manually update Business Object Universe? Have I lost out on something here? A few new Status Reasons has been created on HPD:Help Desk. The new reasons are completely ignored by BO Universe. Is this correct? I would expect that there were some code or layer in between that fixed this? A quick check of the SQL code generated by Business Objects: SELECT DISTINCT FIELD_ENUM_VALUES.enumId, field_enum_values.value AS STATUS_REASON FROM field_enum_values WHERE field_enum_values.schemaId = (SELECT SCHEMAID FROM arschema WHERE name = 'HPD:Help Desk') AND field_enum_values.fieldId = 100150 If changed to access the overlay - the related report is correct? SELECT DISTINCT FIELD_ENUM_VALUES.enumId, field_enum_values.value AS STATUS_REASON FROM field_enum_values WHERE field_enum_values.schemaId = (SELECT SCHEMAID FROM arschema WHERE name = 'HPD:Help Desk__o') AND field_enum_values.fieldId = 100150 I would expect this to be fixed or handled by BMC Software. Or am I dreaming? ARS 7.604SP2 SQL 2008 Windows. Thanks, Terje ~ Terje Moglestue Mogle Partners Limited ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: How can I save changes
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 blednyk...@mail.ru wrote: ** 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 through Dev Studio and import the def file. I hope this helps. With best regards, Santosh Kumar *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Andrey Blednykh *Sent:* Wednesday, November 27, 2013 12:05 PM *To:* arslist@ARSLIST.ORG *Subject:* How can I save changes ** Hello, friends, I have started to work with BMC Remedy recently and now I have quite simple question. How can I save/deliver form which was changed in Developer to the production server? Maybe you will give me advice where I can read about it exactly? We use ARSystem Server 7604 sp4 / Tomcat 6 on Windows 2008 R2 Server. Thanks in advance! _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
How to Parse a variable character string
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 carriage return after the name and before Title. Can anyone give me the Set Fields actions that would do this? Thanks. Carol ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Opinions on COBIT
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) theo.fon...@gmail.com wrote: Hi Rick! You are right about the comparison between ITIL and COBIT, but COBIT, like ITIL, is a framework, not a solution to the problem. Back when the dinosaurs were still roaming the earth, I once did COBIT 4.1 foundation and found that it had some merit, and a couple of good things to go and implement, but, like ITIL, it's bloated with some superfluous academic surrealism that you have to filter out for yourself to make it work in real life. The foundation exam, like the ITIL foundation exam, is dumbed down to test your thought processes, grammar and comprehension of the English language with questions referring to the subject, rather than your knowledge and recollection of the subject matter itself, making it fall-out-of-a-tree easy to pass the foundation exam. That said, I would still recommend doing both ITIL and COBIT as both have some good pointers in the right direction. I remember walking out of the COBIT exam, thinking that it would be a great idea to publish a book that combines the best of ITIL and COBIT whilst aligning them, but got busy at work and never got round to it. The good news is that there are folks at ISACA who also had the same idea: http://www.isaca.org/KNOWLEDGE-CENTER/RESEARCH/RESEARCHDELIVERABLES/Pages/CO BIT-Mapping-Mapping-of-ITIL-V3-With-COBIT-4-11.aspx http://www.isaca.org/Knowledge-Center/Research/ResearchDeliverables/Pages/Al igning-COBIT-4-1-ITIL-V3-and-ISO-IEC-27002-for-BusinessBenefit.aspx In short: -COBIT is about defining and managing IT processes in general. -ITIL is about managing the IT support shop specifically. -They overlap in some areas and you have to align them yourself. -Do COBIT to compliment your SOX compliance. Best Regards, Theo -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Westbrock Sent: 27 November 2013 00:08 To: arslist@ARSLIST.ORG Subject: Opinions on COBIT Hi all- Lately I have seen several references to COBIT and being unfamiliar with it I did some quick research. My take is that in some ways it complements ITIL and in other ways competes with ITIL at some level. I am very interested to hear what the fine folks on the list have to say about COBIT, especially anyone who is currently following the COBIT framework (or has in the past). If you prefer to contact me off-list with your thoughts I'm fine with that although I have a feeling that everyone could benefit from the responses. Thanks in advance, Rick ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Business Object Universe and 7.6.04 SP2 Overlay
** I'm pretty sure you are going to have to modify the universe to see this new table. That's one of the reasonswhy the Analytics install/configure guide mentions to create a linked universe. Terry on Nov 27, 2013, Terje Moglestue te...@mogle.com wrote: ** 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 incorrect. A quick look at the data confirms that Business Objects Universe is ignoring the BMC Overlays. Is this correct? Do we really need to manually update Business Object Universe? Have I lost out on something here? A few new Status Reasons has been created on HPD:Help Desk. The new reasons are completely ignored by BO Universe. Is this correct? I would expect that there were some code or layer in between that fixed this? A quick check of the SQL code generated by Business Objects: SELECTDISTINCTFIELD_ENUM_VALUES.enumId,field_enum_values.valueASSTATUS_REASON FROMfield_enum_values WHEREfield_enum_values.schemaId= (SELECTSCHEMAID FROMarschema WHEREname='HPD:Help Desk') ANDfield_enum_values.fieldId=100150 If changed to access the overlay the related report is correct? SELECTDISTINCTFIELD_ENUM_VALUES.enumId,field_enum_values.valueASSTATUS_REASON FROMfield_enum_values WHEREfield_enum_values.schemaId= (SELECTSCHEMAID FROMarschema WHEREname='HPD:Help Desk__o') ANDfield_enum_values.fieldId=100150 I would expect this to be fixed or handled by BMC Software. Or am I dreaming? ARS 7.604SP2 SQL 2008 Windows. Thanks, Terje ~ Terje Moglestue Mogle Partners Limited _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_
Re: How to Parse a variable character string
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 how it works out. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. 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 carriage return after the name and before Title. Can anyone give me the Set Fields actions that would do this? Thanks. Carol ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: How to Parse a variable character string
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 replace the text Title: with the control character. Step 4) Find the position of the control character. Step 5) Use positions found in step 2 and 4, then use RIGHT and LEFT and parse out the Managers Name. If you also want to the Location and the Tile stripped out I would have made a guide and made a loop and worked my way down from the top. Regards, Terje -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Carol Carnevali Sent: Wednesday, November 27, 2013 2:02 PM To: arslist@ARSLIST.ORG Subject: How to Parse a variable character string 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 carriage return after the name and before Title. Can anyone give me the Set Fields actions that would do this? Thanks. Carol ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Target date Calc
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) * 1))
OR ('105261' = $\NULL$ ) ) AND 'Status' Resolved
'105261' being the Target date.
Of course this only shows those of a Target date before the Server timestamp.
Suggestions on how to show those (up to 23 hours) after the DATE default of
12:00 AM?
ARS 8.1
ITSM 8.1
Thanks,
Dave
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years
Re: Target date Calc
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 devide it by 86400 into an
int field (dropping the fractional answer) then multiply it by 86400 to get
today at midnight. Then back to the qualification above.
HTH,
Brian Goralczyk
On Wed, Nov 27, 2013 at 8:26 AM, David Boylan david_boy...@brown.eduwrote:
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) *
1)) OR ('105261' = $\NULL$ ) ) AND 'Status' Resolved
'105261' being the Target date.
Of course this only shows those of a Target date before the Server
timestamp. Suggestions on how to show those (up to 23 hours) after the DATE
default of 12:00 AM?
ARS 8.1
ITSM 8.1
Thanks,
Dave
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years
Table field qualification length restrictions
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 ( I know that is a lot ) it seems to give an obscure error. I don't have the error in front of me so I can't include it, which I know might help someone figure out the issue for me, but my real question is, does anyone know of a length limitation on the table field's qualification and does external impact that at all? Any advice or guidance on this would help. It is mostly for us to decide if we have to rewrite that process now (urgently) or later (not the issue). Thanks all, Brian Goralczyk ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: How to Parse a variable character string-RESOLVED
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$, $# Our Calls$ + 9, $# Our Emails$) Works like a charm! Thanks again for your input and other solutions. Carol ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: How to Parse a variable character string-RESOLVED
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:) Setting '# Our Calls' with: STRSTR($Details$, Manager: ) 2nd Set Fields: Setting the desired field with: SUBSTR($Details$, $# Our Calls$ + 9, $# Our Emails$) Works like a charm! Thanks again for your input and other solutions. Carol ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Table field qualification length restrictions
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, 2013 10:37 AM To: arslist@ARSLIST.ORG Subject: Table field qualification length restrictions ** 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 ( I know that is a lot ) it seems to give an obscure error. I don't have the error in front of me so I can't include it, which I know might help someone figure out the issue for me, but my real question is, does anyone know of a length limitation on the table field's qualification and does external impact that at all? Any advice or guidance on this would help. It is mostly for us to decide if we have to rewrite that process now (urgently) or later (not the issue). Thanks all, Brian Goralczyk _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: OT: ServiceNow
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 customers don't have to resort to complaints to senior product management to get problems fixed, etc.? Would you rather have a car that isn't as great and may not have all the bells and whistles of another but where the dealership is able to fix it quickly or one where the dealership is unresponsive, mechanics take weeks to fix it and limited parts manuals are available? When's the last time your salesperson or tech support person called you just to see how things were going or there's anything they can do for you? Just giving you some things to think about -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Sweety Khanna Sent: Tuesday, November 26, 2013 7:42 PM To: arslist@ARSLIST.ORG Subject: Re: OT: ServiceNow Just a reduction in installation time is not enough to say that iSNow is better than remedy. Did you see the user interface of SNow ? It sucks... Its not at all user friendly. BMC Remedy is much better than SNow in all areas. I assume that BMC is working very hard to make it more powerful. It wont let its best product to go in vain. I love remedy. On 11/26/13, Joe Newmark jwnewm...@yahoo.com wrote: We have implemented SNOW in both hosted and on premise instances and we like it. The average deployment time has dropped significantly from that of installing Remedy. We are currently deploying both SNOW and Remedy on Demand for two customers. I will take SNOW over RoD anytime... I am fighting BMC on many fronts. The latest was getting them to understand that the AR server needed to get out past the proxy server to deliver a web service. They had set it up that way in development, but not in QA or production. It took three critical tickets and four days to get this worked out. Couple that with the hoops you need to jump through to get a simple customization like a notification filter done makes and I am fed up. When I first heard about ServiceNow, I was not impressed, after all I was a Remedy guy. However by the time the Berlin version came out I was impressed by how easy it was to deploy even on premise. The average installation time is under 20 minutes. That is installing both the database and the application. To me ServiceNow is what Remedy 8 should have been. Both products have their place, but BMC needs to step up their game to keep their market share. Sent from my iPad On Nov 26, 2013, at 4:34 PM, Pierson, Shawn shawn.pier...@energytransfer.com wrote: ** My company has also recently taken a look at Service Now. I can also confirm hearing some deliberately false information being provided, but that's likely typical for any sales presentation. That being said, I do have a cautiously positive view of their product. The techie part of my personality would like to make the switch just to learn something completely new and exciting, but in terms of doing what's best for my organization I don't think it's fully matured enough yet to replace Remedy, plus not all companies are willing to have their private data out on the cloud yet. I've also come to the opinion that us Remedy folks are maybe more opposed to some of the people involved with ServiceNow and their marketing techniques than the anything else. Either way, I plan to keep my eye on them and if my management told me tomorrow that they signed me up for classes and that we'd be migrating to that product, I would treat it as an opportunity not treat it as the end of the world. Thanks, Shawn Pierson Remedy Developer | Energy Transfer From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of arslist Sent: Tuesday, November 26, 2013 2:26 PM To: arslist@ARSLIST.ORG Subject: Re: OT: ServiceNow ** That is I was looking at SNOW in terms of knowing what's good and what is bad. No product is the best at everything. I am certainly more open minded about the products than most folks I met at the SNOW conference were. To them [SNOW conference attendees, the ServiceNow employees and others] BMC Remedy is the enemy and it can do no right. There were many expressing blatantly false views, I kept my opinions mostly to myself. Well, I did have to correct former BMC employees who were saying Fred Luddy had something to do with creating Remedy. A view I heard enough times to consider it to be deliberate. Yes, the marketing is a direct steal from what Remedy Corp. said in the 1990s, and there is a tiny bit of truth to some of what they say. Mostly though, if the developer studio were sped up to the speed of the old Admin tool, It could easily be shown you can create robust custom apps
8.1 SP2 == JAVA question
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 will run on 1.7.0_45, and 1.6.0_43, and 1.5.0_51 Almost seems like we are going backward... 1.6.0_ 43 is paid support now 1.5.0_ 51 is paid support now --- so you have to have Extended support to get the 8.1 system working to Oracle. Is this a Gimmick? Seems very odd that the latest will not run with the 1.7 1.8 is almost released and is in RC4 I think... --- ERRORS__ more arjavaplugin-stderr-2013-11-26.log log4j:ERROR No output stream or file set for the appender named [null]. java.lang.UnsatisfiedLinkError: /u01/app/bin/libarapsignal81_build001.so: ld.so.1: java: fatal: libjsig.so: open failed: No such file or directory at java.lang.ClassLoader$NativeLibrary.load(Native Method) at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1928) at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1854) at java.lang.Runtime.loadLibrary0(Runtime.java:845) at java.lang.System.loadLibrary(System.java:1084) at com.bmc.arsys.common.NativeLibraryLoader.load(Unknown Source) at com.bmc.arsys.common.JNISignalHandler.loadLibrary(Unknown Source) at com.bmc.arsys.approval.main.ApprovalMainThread.initializeHandler(Unknown Source) at com.bmc.arsys.approval.main.ApprovalMainThread.initialize(Unknown Source) at com.bmc.arsys.approval.main.ApprovalMainThread.run(Unknown Source) at java.lang.Thread.run(Thread.java:722) Exception in thread Main java.lang.UnsatisfiedLinkError: com.bmc.arsys.common.JNISignalHandler.initialize(I[[Ljava/lang/String;Z)I at com.bmc.arsys.common.JNISignalHandler.initialize(Native Method) at com.bmc.arsys.approval.main.ApprovalMainThread.initializeHandler(Unknown Source) at com.bmc.arsys.approval.main.ApprovalMainThread.initialize(Unknown Source) at com.bmc.arsys.approval.main.ApprovalMainThread.run(Unknown Source) at java.lang.Thread.run(Thread.java:722) log4j:ERROR No output stream or file set for the appender named [null]. -- Patrick Zandi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: 8.1 SP2 == JAVA question
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 includes everything from previous patchesI know it's a bit quibbly, but I want to avoid confusion :) SoI'm not sure what's happening with it...I had an 8.1 Patch 2 ITSM server that was running on the latest Java patches without issue. But, typically when a Java throws the 'UnsatisfiedLinkError', it's referring to some native library, in this case /u01/app/bin/libarapsignal81_build001.so that it can't find. Is that file in place? I'm not extremely familiar with linked library problems on linux/unix, but I know there are commands you can use to determine if files are in the LD_LIBRARY_PATH or not and such. On Wed, Nov 27, 2013 at 9:19 AM, patrick zandi remedy...@gmail.com 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 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 will run on 1.7.0_45, and 1.6.0_43, and 1.5.0_51 Almost seems like we are going backward... 1.6.0_ 43 is paid support now 1.5.0_ 51 is paid support now --- so you have to have Extended support to get the 8.1 system working to Oracle. Is this a Gimmick? Seems very odd that the latest will not run with the 1.7 1.8 is almost released and is in RC4 I think... --- ERRORS__ more arjavaplugin-stderr-2013-11-26.log log4j:ERROR No output stream or file set for the appender named [null]. java.lang.UnsatisfiedLinkError: /u01/app/bin/libarapsignal81_build001.so: ld.so.1: java: fatal: libjsig.so: open failed: No such file or directory at java.lang.ClassLoader$NativeLibrary.load(Native Method) at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1928) at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1854) at java.lang.Runtime.loadLibrary0(Runtime.java:845) at java.lang.System.loadLibrary(System.java:1084) at com.bmc.arsys.common.NativeLibraryLoader.load(Unknown Source) at com.bmc.arsys.common.JNISignalHandler.loadLibrary(Unknown Source) at com.bmc.arsys.approval.main.ApprovalMainThread.initializeHandler(Unknown Source) at com.bmc.arsys.approval.main.ApprovalMainThread.initialize(Unknown Source) at com.bmc.arsys.approval.main.ApprovalMainThread.run(Unknown Source) at java.lang.Thread.run(Thread.java:722) Exception in thread Main java.lang.UnsatisfiedLinkError: com.bmc.arsys.common.JNISignalHandler.initialize(I[[Ljava/lang/String;Z)I at com.bmc.arsys.common.JNISignalHandler.initialize(Native Method) at com.bmc.arsys.approval.main.ApprovalMainThread.initializeHandler(Unknown Source) at com.bmc.arsys.approval.main.ApprovalMainThread.initialize(Unknown Source) at com.bmc.arsys.approval.main.ApprovalMainThread.run(Unknown Source) at java.lang.Thread.run(Thread.java:722) log4j:ERROR No output stream or file set for the appender named [null]. -- Patrick Zandi _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: 8.1 SP2 == JAVA question
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 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 will run on 1.7.0_45, and 1.6.0_43, and 1.5.0_51 Almost seems like we are going backward... 1.6.0_ 43 is paid support now 1.5.0_ 51 is paid support now --- so you have to have Extended support to get the 8.1 system working to Oracle. Is this a Gimmick? Seems very odd that the latest will not run with the 1.7 1.8 is almost released and is in RC4 I think... --- ERRORS__ more arjavaplugin-stderr-2013-11-26.log log4j:ERROR No output stream or file set for the appender named [null]. java.lang.UnsatisfiedLinkError: /u01/app/bin/libarapsignal81_build001.so: ld.so.1: java: fatal: libjsig.so: open failed: No such file or directory at java.lang.ClassLoader$NativeLibrary.load(Native Method) at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1928) at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1854) at java.lang.Runtime.loadLibrary0(Runtime.java:845) at java.lang.System.loadLibrary(System.java:1084) at com.bmc.arsys.common.NativeLibraryLoader.load(Unknown Source) at com.bmc.arsys.common.JNISignalHandler.loadLibrary(Unknown Source) at com.bmc.arsys.approval.main.ApprovalMainThread.initializeHandler(Unknown Source) at com.bmc.arsys.approval.main.ApprovalMainThread.initialize(Unknown Source) at com.bmc.arsys.approval.main.ApprovalMainThread.run(Unknown Source) at java.lang.Thread.run(Thread.java:722) Exception in thread Main java.lang.UnsatisfiedLinkError: com.bmc.arsys.common.JNISignalHandler.initialize(I[[Ljava/lang/String;Z)I at com.bmc.arsys.common.JNISignalHandler.initialize(Native Method) at com.bmc.arsys.approval.main.ApprovalMainThread.initializeHandler(Unknown Source) at com.bmc.arsys.approval.main.ApprovalMainThread.initialize(Unknown Source) at com.bmc.arsys.approval.main.ApprovalMainThread.run(Unknown Source) at java.lang.Thread.run(Thread.java:722) log4j:ERROR No output stream or file set for the appender named [null]. -- Patrick Zandi _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Table field qualification length restrictions
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 telling me the field is too long error. It is more obscure. This request is more to see if anyone else has ran into a length issue and might know what it is. But thank you for the suggestion. Brian Goralczyk On Wed, Nov 27, 2013 at 10:12 AM, Kemes, Lisa A DLA CTR INFORMATION OPERATIONS lisa.kemes@dla.mil wrote: 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, 2013 10:37 AM To: arslist@ARSLIST.ORG Subject: Table field qualification length restrictions ** 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 ( I know that is a lot ) it seems to give an obscure error. I don't have the error in front of me so I can't include it, which I know might help someone figure out the issue for me, but my real question is, does anyone know of a length limitation on the table field's qualification and does external impact that at all? Any advice or guidance on this would help. It is mostly for us to decide if we have to rewrite that process now (urgently) or later (not the issue). Thanks all, Brian Goralczyk _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Table field qualification length restrictions
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 Behalf Of Brian Goralczyk Sent: Wednesday, November 27, 2013 12:05 PM To: arslist@ARSLIST.ORG Subject: Re: Table field qualification length restrictions ** 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 telling me the field is too long error. It is more obscure. This request is more to see if anyone else has ran into a length issue and might know what it is. But thank you for the suggestion. Brian Goralczyk On Wed, Nov 27, 2013 at 10:12 AM, Kemes, Lisa A DLA CTR INFORMATION OPERATIONS lisa.kemes@dla.mil wrote: 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, 2013 10:37 AM To: arslist@ARSLIST.ORG Subject: Table field qualification length restrictions ** 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 ( I know that is a lot ) it seems to give an obscure error. I don't have the error in front of me so I can't include it, which I know might help someone figure out the issue for me, but my real question is, does anyone know of a length limitation on the table field's qualification and does external impact that at all? Any advice or guidance on this would help. It is mostly for us to decide if we have to rewrite that process now (urgently) or later (not the issue). Thanks all, Brian Goralczyk _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Table field qualification length restrictions
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 list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Brian Goralczyk Sent: Wednesday, November 27, 2013 11:05 AM To: arslist@ARSLIST.ORG Subject: Re: Table field qualification length restrictions ** 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 telling me the field is too long error. It is more obscure. This request is more to see if anyone else has ran into a length issue and might know what it is. But thank you for the suggestion. Brian Goralczyk -Original Message- On Wed, Nov 27, 2013 at 10:12 AM, Kemes, Lisa A DLA CTR INFORMATION OPERATIONS wrote: 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.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of Brian Goralczyk Sent: Wednesday, November 27, 2013 10:37 AM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Table field qualification length restrictions ** 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 ( I know that is a lot ) it seems to give an obscure error. I don't have the error in front of me so I can't include it, which I know might help someone figure out the issue for me, but my real question is, does anyone know of a length limitation on the table field's qualification and does external impact that at all? Any advice or guidance on this would help. It is mostly for us to decide if we have to rewrite that process now (urgently) or later (not the issue). Thanks all, Brian Goralczyk ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: 8.1 SP2 == JAVA question
ldd -d is the command.. There is some problem with it.. On Wed, Nov 27, 2013 at 11:32 AM, LJ LongWing lj.longw...@gmail.com 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 the base, then patch 1, then patch 2but when the first service pack comes out, it will be a stand alone install that includes everything from previous patchesI know it's a bit quibbly, but I want to avoid confusion :) SoI'm not sure what's happening with it...I had an 8.1 Patch 2 ITSM server that was running on the latest Java patches without issue. But, typically when a Java throws the 'UnsatisfiedLinkError', it's referring to some native library, in this case /u01/app/bin/libarapsignal81_build001.so that it can't find. Is that file in place? I'm not extremely familiar with linked library problems on linux/unix, but I know there are commands you can use to determine if files are in the LD_LIBRARY_PATH or not and such. On Wed, Nov 27, 2013 at 9:19 AM, patrick zandi remedy...@gmail.comwrote: ** 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 will run on 1.7.0_45, and 1.6.0_43, and 1.5.0_51 Almost seems like we are going backward... 1.6.0_ 43 is paid support now 1.5.0_ 51 is paid support now --- so you have to have Extended support to get the 8.1 system working to Oracle. Is this a Gimmick? Seems very odd that the latest will not run with the 1.7 1.8 is almost released and is in RC4 I think... --- ERRORS__ more arjavaplugin-stderr-2013-11-26.log log4j:ERROR No output stream or file set for the appender named [null]. java.lang.UnsatisfiedLinkError: /u01/app/bin/libarapsignal81_build001.so: ld.so.1: java: fatal: libjsig.so: open failed: No such file or directory at java.lang.ClassLoader$NativeLibrary.load(Native Method) at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1928) at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1854) at java.lang.Runtime.loadLibrary0(Runtime.java:845) at java.lang.System.loadLibrary(System.java:1084) at com.bmc.arsys.common.NativeLibraryLoader.load(Unknown Source) at com.bmc.arsys.common.JNISignalHandler.loadLibrary(Unknown Source) at com.bmc.arsys.approval.main.ApprovalMainThread.initializeHandler(Unknown Source) at com.bmc.arsys.approval.main.ApprovalMainThread.initialize(Unknown Source) at com.bmc.arsys.approval.main.ApprovalMainThread.run(Unknown Source) at java.lang.Thread.run(Thread.java:722) Exception in thread Main java.lang.UnsatisfiedLinkError: com.bmc.arsys.common.JNISignalHandler.initialize(I[[Ljava/lang/String;Z)I at com.bmc.arsys.common.JNISignalHandler.initialize(Native Method) at com.bmc.arsys.approval.main.ApprovalMainThread.initializeHandler(Unknown Source) at com.bmc.arsys.approval.main.ApprovalMainThread.initialize(Unknown Source) at com.bmc.arsys.approval.main.ApprovalMainThread.run(Unknown Source) at java.lang.Thread.run(Thread.java:722) log4j:ERROR No output stream or file set for the appender named [null]. -- Patrick Zandi _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ -- Patrick Zandi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Table field qualification length restrictions
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 to help debug, but as far as AR System having some limit defined - there is NOT one (now, there is always the chance that there is an accidental limit - i.e. bug - but I don't know of anything in this area and have not heard from any customers about a limit). If you could get the actual error message, it would help tremendously. Doug From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Brian Goralczyk Sent: Wednesday, November 27, 2013 7:37 AM To: arslist@ARSLIST.ORG Subject: Table field qualification length restrictions ** 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 ( I know that is a lot ) it seems to give an obscure error. I don't have the error in front of me so I can't include it, which I know might help someone figure out the issue for me, but my real question is, does anyone know of a length limitation on the table field's qualification and does external impact that at all? Any advice or guidance on this would help. It is mostly for us to decide if we have to rewrite that process now (urgently) or later (not the issue). Thanks all, Brian Goralczyk _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Table field qualification length restrictions
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, Mueller, Doug doug_muel...@bmc.comwrote: ** 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 to help debug, but as far as AR System having some limit defined – there is NOT one (now, there is always the chance that there is an accidental limit – i.e. bug – but I don't know of anything in this area and have not heard from any customers about a limit). If you could get the actual error message, it would help tremendously. Doug *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Brian Goralczyk *Sent:* Wednesday, November 27, 2013 7:37 AM *To:* arslist@ARSLIST.ORG *Subject:* Table field qualification length restrictions ** 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 ( I know that is a lot ) it seems to give an obscure error. I don't have the error in front of me so I can't include it, which I know might help someone figure out the issue for me, but my real question is, does anyone know of a length limitation on the table field's qualification and does external impact that at all? Any advice or guidance on this would help. It is mostly for us to decide if we have to rewrite that process now (urgently) or later (not the issue). Thanks all, Brian Goralczyk _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Target date Calc
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 www.arslist.org
Where the Answers Are, and have been for 20 years
Re: area plugin authorization issue
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, the system should take the yes/no about authentication to tell if the user is valid and then look up the other data from the User form. Take a look at the documentation page https://docs.bmc.com/docs/display/ars81/AREA+API+data+structure It talks about the return structure of the AREA call and the fact that if values returned are NULL, it will cross reference the user form for the information. You can supply some values and not others or no values for anything and have everything other than authentication be from the user form. Note that you need to have the cross reference blank password setting configured to cause AREA to look at the user form after authentication. I hope this is helpful, Doug Mueller From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Sergio Feito Sent: Monday, November 25, 2013 8:54 AM To: arslist@ARSLIST.ORG Subject: area plugin authorization issue ** Hi. I'm trying to develop an area plugin in java in an ARS 8.1. The authentication works fine but not the authorization (licenses and groups). The user log into the system and exists in the User form but doesn't take licenses or group list from the User form. I want to make the users are assigned the license type, app licenses, group list etc... specified in the User form instead setting this parameters as a constant in the plugin. Is there any way to do this?? Best regards Sergio Feito. _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Target date Calc
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 field.
If you do, doing math against it invalidates the index.
It might help to verbalize your qualification.
I want records where today plus a day minus field value is greater than
or equal to 3600 or the field value is null and status is less than
resolved.
I would recommend instead,
I want records where status is less than resolved and field value is
between midnight today and midnight tomorrow or value is null.
I think you will find a substantial performance gain with the revision.
HTH,
Brian Goralczyk
On Wed, Nov 27, 2013 at 12:07 PM, David Boylan david_boy...@brown.eduwrote:
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 www.arslist.org
Where the Answers Are, and have been for 20 years
___
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
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 m...@rrr.se wrote: 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 the sqlcommand. If it has a $536870913$ or similar field id in it, it must be replaced with a string or integer. I suggest that you browse through the C-API-documentation to get an idea of what kind of calls there is. You can also turn on API-logging to see which API-calls are executed for a certain kind of operation. This can be done with Client-side-logs while enabling logging for Server-API in the AR System User Preferences form. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Hi List, How can I retrive the data from SQL Menus through .Net API programming ? Any sample code would be great. Regards, Sweety ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Retrieve data from Search Menus
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
8.1 SP2 == JAVA question
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 ___ 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
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 the mid-tier server cached information about how the menu was constructed. If you run ARUser, you will this might also have been cached into ARF/ARV files before hand... If things exists in the C-API it has an equivalent in the Java-API and any other wrapper on top of these two core API:s. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. 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 m...@rrr.se wrote: 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 the sqlcommand. If it has a $536870913$ or similar field id in it, it must be replaced with a string or integer. I suggest that you browse through the C-API-documentation to get an idea of what kind of calls there is. You can also turn on API-logging to see which API-calls are executed for a certain kind of operation. This can be done with Client-side-logs while enabling logging for Server-API in the AR System User Preferences form. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Hi List, How can I retrive the data from SQL Menus through .Net API programming ? Any sample code would be great. Regards, Sweety ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Retrieve data from Search Menus
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 ARQualfierStruct. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. 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 ___ 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
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) Dim menuItem For Each menuItem In menuItems MsgBox(menuItem.ToString) Next I tried this but I am getting error (313) data types are not appropriate for relational operation On Wed, Nov 27, 2013 at 3:59 PM, Misi Mladoniczky m...@rrr.se wrote: 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 the mid-tier server cached information about how the menu was constructed. If you run ARUser, you will this might also have been cached into ARF/ARV files before hand... If things exists in the C-API it has an equivalent in the Java-API and any other wrapper on top of these two core API:s. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. 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 m...@rrr.se wrote: 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 the sqlcommand. If it has a $536870913$ or similar field id in it, it must be replaced with a string or integer. I suggest that you browse through the C-API-documentation to get an idea of what kind of calls there is. You can also turn on API-logging to see which API-calls are executed for a certain kind of operation. This can be done with Client-side-logs while enabling logging for Server-API in the AR System User Preferences form. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Hi List, How can I retrive the data from SQL Menus through .Net API programming ? Any sample code would be great. Regards, Sweety ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ 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
Menu has below qualification
(('CategorizationSchemaKeyword' = $23009$) OR ($23009$ = )) AND
(('Asset Class' = $300483500$) OR ($300483500$ = $NULL$)) AND ('Status' =
Enabled)
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years
