Re: A question on Remedy 6.3
Hi, check the rowlevel-accces on SHR:People, should be given by AssigneeGroup (fieldid 112). Kind regards Rainer From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of John Atherly Sent: Thursday, April 26, 2012 9:50 PM To: arslist@ARSLIST.ORG Subject: Re: A question on Remedy 6.3 ** The permission on QA and Prod matched. But while closing the window on the SHR:People form production I click save by mistake even though I made no changes to the form or permission. How it is working!I forgot about the trick of just opening and saving it. Thanks everyone _ John Atherly | APC by Schneider Electric | Information, Process Organization (IPO) | Remedy Administrator / Developer Phone: +305-266-5005 ext. 237 | Email: john.athe...@apcc.commailto:%20john.athe...@apcc.com | Site: www.apc.com/http://www.apc.com/ | Address: 703 Waterford Way, Suit 850, Miami, FL 33126 USA *** Please consider the environment before printing this e-mail LJ LongWing lj.longw...@gmail.commailto:lj.longw...@gmail.com Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG 04/26/2012 03:22 PM Please respond to arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG To arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG cc Subject Re: A question on Remedy 6.3 ** John, Check the permissions they have to the request ID on Prod…I would bet that they don’t have access to everyone elses record…so you likely have assignee in there…but not public, or something similar. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of John Atherly Sent: Thursday, April 26, 2012 12:54 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: A question on Remedy 6.3 ** First off yes I still have a small group of users that are still on 6.3 I have been asked to look at an issue were users are not getting the list menu after they type in a name on a form I have a form call let say Phone Numbers and on this form is a character field in which they can type in a partial name and then an active link fire to set it to all Caps. Then the same active link takes the value in caps and does a look up to the SHR:People form to find LIKE matching Full Name and returns the needed information. I have three environment Dev QA and Production. If I try it, it works on all three servers but if a standard user tries it, it only works on Dev and QA. In the log file I can see it changing to caps and doing the look up but if no match is found it set the field to NULL. If the standard user just types in any letter found in their Full Name it will only return their record. So I think it is working it's just that they can not see others SHR:People records. They have view access to the form and read access to Full Name. I have removed all the workflow and replaced it with a new copy from QA Both server have submitter lock on Is there any other server setting that I can not think of since I think this is a permission issue on the server level. Working in 6.3 Admin I really did miss the function of Dev Studio. _ John Atherly | APC by Schneider Electric | Information, Process Organization (IPO) | Remedy Administrator / Developer Phone: +305-266-5005 ext. 237 | Email: john.athe...@apcc.commailto:%20john.athe...@apcc.com | Site: www.apc.com/http://www.apc.com/ | Address: 703 Waterford Way, Suit 850, Miami, FL 33126 USA *** Please consider the environment before printing this e-mail _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ __ This email has been scanned by the Symantec Email Security.cloud service. __ _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Force Logout after inactivity?
Joe, IE tabs: Microsoft have changed the way in which IE handles sessions in various versions of Window, so you can't rely on a session remaining when a tab is closed (I think that's true for Windows 7). The logout problem was previously discussed on ARSlist and I recall pointing out that the best solution would be that when a browser detects a session has been killed in the Java webserver, they are prompted for login credentials (if not using SSO Plugin) and allowed to continue work. I'd expect some kind of dialog to appear informing them the session has timed out and asking them if they want to continue where they left off or quit the application. John ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Can't access MidTier http://servername/arsys/shared/login.jsp?/arsys/
Dear ARS-List, In our environment we can't access our AR System Server by http-Access. We get the following error: http Status 500. Today we really didn't do any Update or system changes. Two weeks ago we had problems with our plugin-server. To fix this issue we reinstalled java on our server. I tried to update to latest java (1.7) and tomcat version (7.0.27) but this didn't solve the problem. Do you have any ideas how I can solve this problem? If you need further information please contact me. Regards Christoph Wagner HTTP Status 500 - type Exception report message description The server encountered an internal error () that prevented it from fulfilling this request. exception org.apache.jasper.JasperException: Unable to compile class for JSP: An error occurred at line: 64 in the jsp file: /shared/login_common.jsp The method StripOffScriptTag(String) is undefined for the type Validator 61:String iframeurl = null; 62:String requrl = (String)session.getAttribute(HttpSessionKeys.TARGET_URL); 63:if (requrl == null) 64:requrl = Validator.StripOffScriptTag(request.getQueryString()); 65:if (requrl != null (requrl.length()0) requrl.charAt(0) == '/') { 66:int appidx = requrl.indexOf(/apps/); 67:if (appidx != -1) { Stacktrace: org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHa ndler.java:93) org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.ja va:330) org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:43 5) org.apache.jasper.compiler.Compiler.compile(Compiler.java:298) org.apache.jasper.compiler.Compiler.compile(Compiler.java:277) org.apache.jasper.compiler.Compiler.compile(Compiler.java:265) org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.ja va:564) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.ja va:302) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265) javax.servlet.http.HttpServlet.service(HttpServlet.java:729) note The full stack trace of the root cause is available in the Apache Tomcat/5.5.27 logs. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Dev Studio Layout WinXP vs Win7
Refer to Microsoft KB to fix font size. http://answers.microsoft.com/en-us/windows/forum/windows_7-windows_programs/ms-sans-serif-font-is-bigger/835d20d3-b93d-408b-9245-84bfda341946 OR BMC communities https://communities.bmc.com/communities/message/240392#240392 Thanks, Ashish ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
AW: Can't access MidTier http://servername/arsys/shared/login.jsp?/arsys/
Dear listers, I also tried to upgrade AR Server and MidTier from 7.1 P8 to 7.1 P 11. But this also didn't help. Regrads Christoph Von: Wagner, Christoph Gesendet: Freitag, 27. April 2012 09:58 An: arslist@ARSLIST.ORG Betreff: Can't access MidTier http://servername/arsys/shared/login.jsp?/arsys/ Dear ARS-List, In our environment we can't access our AR System Server by http-Access. We get the following error: http Status 500. Today we really didn't do any Update or system changes. Two weeks ago we had problems with our plugin-server. To fix this issue we reinstalled java on our server. I tried to update to latest java (1.7) and tomcat version (7.0.27) but this didn't solve the problem. Do you have any ideas how I can solve this problem? If you need further information please contact me. Regards Christoph Wagner HTTP Status 500 - type Exception report message description The server encountered an internal error () that prevented it from fulfilling this request. exception org.apache.jasper.JasperException: Unable to compile class for JSP: An error occurred at line: 64 in the jsp file: /shared/login_common.jsp The method StripOffScriptTag(String) is undefined for the type Validator 61:String iframeurl = null; 62:String requrl = (String)session.getAttribute(HttpSessionKeys.TARGET_URL); 63:if (requrl == null) 64:requrl = Validator.StripOffScriptTag(request.getQueryString()); 65:if (requrl != null (requrl.length()0) requrl.charAt(0) == '/') { 66:int appidx = requrl.indexOf(/apps/); 67:if (appidx != -1) { Stacktrace: org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHa ndler.java:93) org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.ja va:330) org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:43 5) org.apache.jasper.compiler.Compiler.compile(Compiler.java:298) org.apache.jasper.compiler.Compiler.compile(Compiler.java:277) org.apache.jasper.compiler.Compiler.compile(Compiler.java:265) org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.ja va:564) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.ja va:302) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265) javax.servlet.http.HttpServlet.service(HttpServlet.java:729) note The full stack trace of the root cause is available in the Apache Tomcat/5.5.27 logs. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Count of records
Thank you all for your ideas... Looks like I have to build a new form with a drop down field with arschema as menu value. On selection of each form, on demand query runs and real time count is provided. Sent on my BlackBerry® from Vodafone -Original Message- From: Jose Huerta jose.hue...@sm2baleares.es Sender: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG Date: Thu, 26 Apr 2012 22:20:56 To: arslist@ARSLIST.ORG Reply-To: arslist@ARSLIST.ORG Subject: Re: Count of records I know you can't customize nor access the DB. I see no solution to your case. But I can provide you some solutions, customizing or accessing the database. All of this is for Oracle. 1.- Run an SQL sentence: SELECT A.SCHEMAID, A.NAME, A.NEXTID, T.NUM_ROWS FROM ARSCHEMA A JOIN user_tables T ON ( ('T' ||TRIM(TO_CHAR(A.SCHEMAID))) = T.TABLE_NAME) Provides you the next ID and number of requests at each regular form. 2.- Create a view using the previous SQL and map it to a View Form. 3.- Create a view form mapping the user_tables table. Then create a join view between this form and the AR System metadata:arschema form, with the join qualification like the provided one. Regards, Jose Huerta http://theremedyforit.com/ On Thu, Apr 26, 2012 at 21:09, Jason Miller jason.mil...@gmail.com wrote: ** That is great! On Thu, Apr 26, 2012 at 11:52 AM, Pierson, Shawn shawn.pier...@sug.comwrote: ** In order to help developers like myself get better at filtering data, my son is named Robert’); DROP TABLE Students;-- Pierson. ** ** http://xkcd.com/327/ ** ** Thanks, ** ** *Shawn Pierson * Remedy Developer | Energy Transfer ** ** *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Jason Miller *Sent:* Thursday, April 26, 2012 1:44 PM *To:* arslist@ARSLIST.ORG *Subject:* OT: Count of records ** ** ** A good reason to not run your application as root/admin... I had a system once were I didn't have admin access on the app server but the AR System ran as root. I built a form where I could enter an OS command in a text field and Remedy would issue the command to the OS in a Run Process. Worked great for things like sending a chown command on log files that I couldn't view because they were created by root. ** ** The same could hold true if your ARSystem db user is a sysadmin. Be careful that the SELECT COUNT(*) doesn't turn into DROP DATABASE ARSystem. :-) ** ** Jason On Thu, Apr 26, 2012 at 7:07 AM, Joe Martin D'Souza jdso...@shyle.net wrote: You do not require the ARAdmin password to run a direct SQL on your application.. Customize your app wherein, you run a direct SQL in a set field operation to set a field with $1$ of the SQL statement == select count(*) from view name Do not use the terminating ; character on your direct SQL as the AR System engine takes care of that.. Use that statement in a set field action and set a temp field to return your count to.. This will not limit your count by what your get list limits on your server or your clients are.. Joe -Original Message- From: remedyarl...@gmail.com Sent: Thursday, April 26, 2012 5:57 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Count of records Quick question.. Do we have a form in remedy 7.6.X where we can check the count of rows in each table. I know we have a form to check schema ID's but will this also give count of rows. My Getlist query on server is restricted to 2K records only so I have to run 1=1 query on each target form in web mode to get the count. Unfortunately user too do not give the count. Also I don't have read access to DB and client is not ready to share ARAdmin pwd (for security). And as usual no customization allowed. Any help would be appreciated. Sent on my BlackBerry® from Vodafone ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ** ** _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ Private and confidential as detailed herehttp://www.sug.com/disclaimers/default.htm#Mail. If you cannot access hyperlink, please e-mail sender. _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
SRM association
SRM: 7.6.04 Do we have a form where we can find all IM CM tickets associated with SRM. I have a issue where even after IM ticket is resolved SRM tickets are still in planning status. I need to find all SRM tickets for which associated tickets are resolved. I am not sure if this is a bug in the system but that would be my second task. Thanks in adv. Sent on my BlackBerry® from Vodafone ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Can we use the Requester Console (not SRM) if we installed ITSM using the 7604SP2 Stack Installer?
**Can we use the Requester Console (not SRM) if we installed ITSM using the 7604SP2 Stack Installer? Question about the 7604SP2 Stack Installer and the Requester (no SRM) Console. We’ve installed the full ITSM suite using the above stack installer and had a question about configuring and using the Requester Console. In reading the 7604 BMC Integration Guide and the 7604 BMC SRM Admin guide, there are notes stating that the configuration forms (via the Application Admin console) for the Requester Console have been replaced by SRM. I’m able to find the Definition form for the Requester Console but wanted to know if the other configuration forms are/aren’t included as part of the 7604SP2 stack installer. Our users would like to use the Requester Console as we currently do not have plans to roll-out and use SRM. Any guidance/suggestions on the Requester Console configuration form names would be most appreciated and whether we can use the Requester Console after using the ITSM stack installer (which installed SRM). Thanks in advance for your time and help. ~Antonio ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Can't access MidTier http://servername/arsys/shared/login.jsp?/arsys/
Hello, Try some of these: 1. Stop Tomcat, delete the work directory (yes, I did mean delete). Start Tomcat. 2. If you've upgraded, check you really did copy all the files over as the issue looks like a mismatched JSP and jar. 3. Install SSO Plugin so users don't have to use a login page :) John ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Can we use the Requester Console (not SRM) if we installed ITSM using the 7604SP2 Stack Installer?
I am not much of a fan of the Stack installer: I mean it kinda works, but there are issues.. I would recommend installing from scratch.. even on a laptop/virtual you get better performance than a stack installer. IMHO .. you could always reinstall the SRM piece.. On Fri, Apr 27, 2012 at 9:27 AM, Antonio M antonio.rem...@gmail.com wrote: **Can we use the Requester Console (not SRM) if we installed ITSM using the 7604SP2 Stack Installer? Question about the 7604SP2 Stack Installer and the Requester (no SRM) Console. We’ve installed the full ITSM suite using the above stack installer and had a question about configuring and using the Requester Console. In reading the 7604 BMC Integration Guide and the 7604 BMC SRM Admin guide, there are notes stating that the configuration forms (via the Application Admin console) for the Requester Console have been replaced by SRM. I’m able to find the Definition form for the Requester Console but wanted to know if the other configuration forms are/aren’t included as part of the 7604SP2 stack installer. Our users would like to use the Requester Console as we currently do not have plans to roll-out and use SRM. Any guidance/suggestions on the Requester Console configuration form names would be most appreciated and whether we can use the Requester Console after using the ITSM stack installer (which installed SRM). Thanks in advance for your time and help. ~Antonio ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are -- Patrick Zandi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Count of records
You might just want to download ARUtilities application (google it). It’s free for a time (until trial expires) and provides a means to do sql against the server as you would by building a form/logic as you indicated. It does other things too. Note: I’m not affiliated with the product. It just seems you need a solution that doesn’t require effort or introducing code on the system itself, that will open the proverbial can of worms. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of remedyarl...@gmail.com Sent: Friday, April 27, 2012 5:39 AM To: arslist@ARSLIST.ORG Subject: Re: Count of records ** Thank you all for your ideas... Looks like I have to build a new form with a drop down field with arschema as menu value. On selection of each form, on demand query runs and real time count is provided. Sent on my BlackBerry® from Vodafone From: Jose Huerta jose.hue...@sm2baleares.esmailto:jose.hue...@sm2baleares.es Sender: Action Request System discussion list(ARSList) arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Date: Thu, 26 Apr 2012 22:20:56 +0200 To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG ReplyTo: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: Count of records ** I know you can't customize nor access the DB. I see no solution to your case. But I can provide you some solutions, customizing or accessing the database. All of this is for Oracle. 1.- Run an SQL sentence: SELECT A.SCHEMAID, A.NAMEhttp://A.NAME, A.NEXTID, T.NUM_ROWS FROM ARSCHEMA A JOIN user_tables T ON ( ('T' ||TRIM(TO_CHAR(A.SCHEMAID))) = T.TABLE_NAME) Provides you the next ID and number of requests at each regular form. 2.- Create a view using the previous SQL and map it to a View Form. 3.- Create a view form mapping the user_tables table. Then create a join view between this form and the AR System metadata:arschema form, with the join qualification like the provided one. Regards, Jose Huerta http://theremedyforit.com/ On Thu, Apr 26, 2012 at 21:09, Jason Miller jason.mil...@gmail.commailto:jason.mil...@gmail.com wrote: ** That is great! On Thu, Apr 26, 2012 at 11:52 AM, Pierson, Shawn shawn.pier...@sug.commailto:shawn.pier...@sug.com wrote: ** In order to help developers like myself get better at filtering data, my son is named Robert’); DROP TABLE Students;-- Pierson. http://xkcd.com/327/ Thanks, Shawn Pierson Remedy Developer | Energy Transfer From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of Jason Miller Sent: Thursday, April 26, 2012 1:44 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: OT: Count of records ** A good reason to not run your application as root/admin... I had a system once were I didn't have admin access on the app server but the AR System ran as root. I built a form where I could enter an OS command in a text field and Remedy would issue the command to the OS in a Run Process. Worked great for things like sending a chown command on log files that I couldn't view because they were created by root. The same could hold true if your ARSystem db user is a sysadmin. Be careful that the SELECT COUNT(*) doesn't turn into DROP DATABASE ARSystem. :-) Jason On Thu, Apr 26, 2012 at 7:07 AM, Joe Martin D'Souza jdso...@shyle.netmailto:jdso...@shyle.net wrote: You do not require the ARAdmin password to run a direct SQL on your application.. Customize your app wherein, you run a direct SQL in a set field operation to set a field with $1$ of the SQL statement == select count(*) from view name Do not use the terminating ; character on your direct SQL as the AR System engine takes care of that.. Use that statement in a set field action and set a temp field to return your count to.. This will not limit your count by what your get list limits on your server or your clients are.. Joe -Original Message- From: remedyarl...@gmail.commailto:remedyarl...@gmail.com Sent: Thursday, April 26, 2012 5:57 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Count of records Quick question.. Do we have a form in remedy 7.6.X where we can check the count of rows in each table. I know we have a form to check schema ID's but will this also give count of rows. My Getlist query on server is restricted to 2K records only so I have to run 1=1 query on each target form in web mode to get the count. Unfortunately user too do not give the count. Also I don't have read access to DB and client is not ready to share ARAdmin pwd (for security). And as usual no customization allowed. Any help would be appreciated. Sent on my BlackBerry® from Vodafone ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.orghttp://www.arslist.org attend wwrug12 www.wwrug12.comhttp://www.wwrug12.com
AW: Can't access MidTier http://servername/arsys/shared/login.jsp?/arsys/
Hey John, thank you very much for your help. 1. I already tried this, too. But without any results. 2. I tried an update. But I got the same error message. After that I fell back to the previous versions again. (tomcat and java) 3. What exactly is the SSO plugin? With which user-id all users are logged in, if they don't use a login page? Thank you very much for your help! Regards Christoph -Ursprüngliche Nachricht- Von: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] Im Auftrag von John Baker Gesendet: Freitag, 27. April 2012 15:38 An: arslist@ARSLIST.ORG Betreff: Can't access MidTier http://servername/arsys/shared/login.jsp?/arsys/ Hello, Try some of these: 1. Stop Tomcat, delete the work directory (yes, I did mean delete). Start Tomcat. 2. If you've upgraded, check you really did copy all the files over as the issue looks like a mismatched JSP and jar. 3. Install SSO Plugin so users don't have to use a login page :) John ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Can we use the Requester Console (not SRM) if we installed ITSM using the 7604SP2 Stack Installer?
I am trying to install with the stack installer as I write this. I don't like that it makes you install using 64 bit JRE, unlike the regular AR system installer that gives you a choice in case you want to use MAPI for emails. I am thinking of just doing the AR system installer 7.6.04 SP3 and then manually installing Atrium Core, ITSM, SLM, and SRM. My concern is that if I do this manually, AR system will be at SP3, while Atrium and ITSM will be at SP2. Has anyone had an issue doing it this way? Jesus Ortega Senior II, Implementation Engineer LyondellBasell Industries Office: 713 309-4914 Cell:281 546-0735 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of patrick zandi Sent: Friday, April 27, 2012 8:43 AM To: arslist@ARSLIST.ORG Subject: Re: Can we use the Requester Console (not SRM) if we installed ITSM using the 7604SP2 Stack Installer? ** I am not much of a fan of the Stack installer: I mean it kinda works, but there are issues.. I would recommend installing from scratch.. even on a laptop/virtual you get better performance than a stack installer. IMHO .. you could always reinstall the SRM piece.. On Fri, Apr 27, 2012 at 9:27 AM, Antonio M antonio.rem...@gmail.commailto:antonio.rem...@gmail.com wrote: **Can we use the Requester Console (not SRM) if we installed ITSM using the 7604SP2 Stack Installer? Question about the 7604SP2 Stack Installer and the Requester (no SRM) Console. We've installed the full ITSM suite using the above stack installer and had a question about configuring and using the Requester Console. In reading the 7604 BMC Integration Guide and the 7604 BMC SRM Admin guide, there are notes stating that the configuration forms (via the Application Admin console) for the Requester Console have been replaced by SRM. I'm able to find the Definition form for the Requester Console but wanted to know if the other configuration forms are/aren't included as part of the 7604SP2 stack installer. Our users would like to use the Requester Console as we currently do not have plans to roll-out and use SRM. Any guidance/suggestions on the Requester Console configuration form names would be most appreciated and whether we can use the Requester Console after using the ITSM stack installer (which installed SRM). Thanks in advance for your time and help. ~Antonio ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.orghttp://www.arslist.org attend wwrug12 www.wwrug12.comhttp://www.wwrug12.com ARSList: Where the Answers Are -- Patrick Zandi _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ Information contained in this email is subject to the disclaimer found by clicking on the following link: http://www.lyondellbasell.com/Footer/Disclaimer/ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Can we use the Requester Console (not SRM) if we installed ITSM using the 7604SP2 Stack Installer?
The Stack installer should be used for specific reasons such as POC that will adhere to the specifications of the stack installer. If you are using multiple servers and want to control what is installed and where it is installed use the individual installers. -Original Message- From: Ortega, Jesus A jesus.ort...@lyondellbasell.com To: arslist arslist@ARSLIST.ORG Sent: Fri, Apr 27, 2012 9:56 am Subject: Re: Can we use the Requester Console (not SRM) if we installed ITSM using the 7604SP2 Stack Installer? ** I am trying to install with the stack installer as I write this. I don’t like that it makes you install using 64 bit JRE, unlike the regular AR system installer that gives you a choice in case you want to use MAPI for emails. I am thinking of just doing the AR system installer 7.6.04 SP3 and then manually installing Atrium Core, ITSM, SLM, and SRM. My concern is that if I do this manually, AR system will be at SP3, while Atrium and ITSM will be at SP2. Has anyone had an issue doing it this way? Jesus Ortega Senior II, Implementation Engineer LyondellBasell Industries Office: 713 309-4914 Cell:281 546-0735 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of patrick zandi Sent: Friday, April 27, 2012 8:43 AM To: arslist@ARSLIST.ORG Subject: Re: Can we use the Requester Console (not SRM) if we installed ITSM using the 7604SP2 Stack Installer? ** I am not much of a fan of the Stack installer: I mean it kinda works, but there are issues.. I would recommend installing from scratch.. even on a laptop/virtual you get better performance than a stack installer. IMHO .. you could always reinstall the SRM piece.. On Fri, Apr 27, 2012 at 9:27 AM, Antonio M antonio.rem...@gmail.com wrote: **Can we use the Requester Console (not SRM) if we installed ITSM using the 7604SP2 Stack Installer? Question about the 7604SP2 Stack Installer and the Requester (no SRM) Console. We’ve installed the full ITSM suite using the above stack installer and had a question about configuring and using the Requester Console. In reading the 7604 BMC Integration Guide and the 7604 BMC SRM Admin guide, there are notes stating that the configuration forms (via the Application Admin console) for the Requester Console have been replaced by SRM. I’m able to find the Definition form for the Requester Console but wanted to know if the other configuration forms are/aren’t included as part of the 7604SP2 stack installer. Our users would like to use the Requester Console as we currently do not have plans to roll-out and use SRM. Any guidance/suggestions on the Requester Console configuration form names would be most appreciated and whether we can use the Requester Console after using the ITSM stack installer (which installed SRM). Thanks in advance for your time and help. ~Antonio ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are -- Patrick Zandi _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ Information contained in this email is subject to the disclaimer found by clicking on the following link: http://www.lyondellbasell.com/Footer/Disclaimer/ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Count of records
You don't even have to sql against the server ... you just right click on a form and Count and it tells you the number of records. You cannot get this done any easier and even if you buy ARUtilities it is a great investment for that feature and others. Note: I'm not affiliated with the product have just been using it for many years! On Fri, Apr 27, 2012 at 8:53 AM, Eric Roys er...@seamlessti.com wrote: ** You might just want to download ARUtilities application (google it). It’s free for a time (until trial expires) and provides a means to do sql against the server as you would by building a form/logic as you indicated. It does other things too. ** ** Note: I’m not affiliated with the product. It just seems you need a solution that doesn’t require effort or introducing code on the system itself, that will open the proverbial can of worms. ** ** *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *remedyarl...@gmail.com *Sent:* Friday, April 27, 2012 5:39 AM *To:* arslist@ARSLIST.ORG *Subject:* Re: Count of records ** ** ** Thank you all for your ideas... Looks like I have to build a new form with a drop down field with arschema as menu value. On selection of each form, on demand query runs and real time count is provided. Sent on my BlackBerry® from Vodafone -- *From: *Jose Huerta jose.hue...@sm2baleares.es *Sender: *Action Request System discussion list(ARSList) arslist@ARSLIST.ORG *Date: *Thu, 26 Apr 2012 22:20:56 +0200 *To: *arslist@ARSLIST.ORG *ReplyTo: *arslist@ARSLIST.ORG *Subject: *Re: Count of records ** ** ** I know you can't customize nor access the DB. I see no solution to your case. ** ** But I can provide you some solutions, customizing or accessing the database. ** ** All of this is for Oracle. ** ** 1.- Run an SQL sentence: ** ** SELECT A.SCHEMAID, A.NAME, A.NEXTID, T.NUM_ROWS FROM ARSCHEMA A JOIN user_tables T ON ( ('T' ||TRIM(TO_CHAR(A.SCHEMAID))) = T.TABLE_NAME) ** ** Provides you the next ID and number of requests at each regular form. ** ** 2.- Create a view using the previous SQL and map it to a View Form. ** ** 3.- Create a view form mapping the user_tables table. Then create a join view between this form and the AR System metadata:arschema form, with the join qualification like the provided one. ** ** Regards, ** ** Jose Huerta http://theremedyforit.com/ ** ** On Thu, Apr 26, 2012 at 21:09, Jason Miller jason.mil...@gmail.com wrote: ** That is great! ** ** On Thu, Apr 26, 2012 at 11:52 AM, Pierson, Shawn shawn.pier...@sug.com wrote: ** In order to help developers like myself get better at filtering data, my son is named Robert’); DROP TABLE Students;-- Pierson. http://xkcd.com/327/ Thanks, *Shawn Pierson * Remedy Developer | Energy Transfer *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Jason Miller *Sent:* Thursday, April 26, 2012 1:44 PM *To:* arslist@ARSLIST.ORG *Subject:* OT: Count of records ** A good reason to not run your application as root/admin... I had a system once were I didn't have admin access on the app server but the AR System ran as root. I built a form where I could enter an OS command in a text field and Remedy would issue the command to the OS in a Run Process. Worked great for things like sending a chown command on log files that I couldn't view because they were created by root. The same could hold true if your ARSystem db user is a sysadmin. Be careful that the SELECT COUNT(*) doesn't turn into DROP DATABASE ARSystem. :-) Jason On Thu, Apr 26, 2012 at 7:07 AM, Joe Martin D'Souza jdso...@shyle.net wrote: You do not require the ARAdmin password to run a direct SQL on your application.. Customize your app wherein, you run a direct SQL in a set field operation to set a field with $1$ of the SQL statement == select count(*) from view name Do not use the terminating ; character on your direct SQL as the AR System engine takes care of that.. Use that statement in a set field action and set a temp field to return your count to.. This will not limit your count by what your get list limits on your server or your clients are.. Joe -Original Message- From: remedyarl...@gmail.com Sent: Thursday, April 26, 2012 5:57 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Count of records Quick question.. Do we have a form in remedy 7.6.X where we can check the count of rows in each table. I know we have a form to check schema ID's but will this also give count of rows. My Getlist query on server is
Re: Rack and Enclosure modeling in CMDB 2.1
Thanks, Peter! You make a good point about the blade enclosure, I will see if that should be added as a tracked computer system as well. Infrastructure is looking to replace the Nlyte product, which is one reason I'm considering hosting this data in the CMDB. One advantage I believe is that I can use the sandbox functionality to automatically offer the planning requirement they want (to be able to model major restructuring without affecting the production data). Another is that I can use Atrium Integrator to update this data (from realtime monitors and static update files). The disadvantage is creating and maintaining this data in the CMDB instead of federating out to another system (which is why I am still considering this idea, if anyone has a good freeware rack tracking system that they've integrated with). Note that there is both a requirement for easy updating of information (moving things from rack to rack on a weekly, sometimes daily basis) and for mass updates (patching all OS of a specific type, or moving one rack's contents to another). Here's what I've worked out so far, two extra classes and two extra relationships: (Equipment parent) class PQ_Enclosure (type set by CTI: Rack, PatchPanel, Blade Enclosure, etc) (Equipment parent) class PQ_Slot that will be related to PQ_Enclosure (component) and to slotted CIs. Relationship PQ_SlottedLocation: Cardinality Many:1 , Regular data storage, Source PQ_SLOT, Destination BMC_BaseElement. Relationship PQ_AvailableSlot: Cardinality 1:Many, Regular data storage, Source PQ_Enclosure, Destination PQ_SLOT. So the basic model is PQ_Enclosure --PQ_AvailableSlot-- PQ_Slot --PQ_SlottedLocation-- (Slotted CI) The idea is to have a flexible structure that can be used to represent any physical object that holds a set of other objects, from a rack to a blade enclosure to a SAN. Since an enclosure can contain another enclosure, I can use the same class to for the rack, the blade enclosure in the rack, etc. One enclosure can have many slots, and one device can connect to many slots, but each slot may only be connected to one enclosure and one CI, so the system should inherently prevent double-slotting a CI. This should also allow impact analysis to be done through a rack to determine effect of changes and allow for transparent change management of restructuring. Regarding room location, I am planning on using the BMC_PhysicalLocation class to denote the rack's location by room and grid coordinates. Since each asset will be related to a rack that will have this location set, this should allow me to consolidate the location information of all of the assets in a rack in one location object, reducing duplication of data. Also the location of an object would be updated automatically when it is moved from one enclosure to another, reducing maintenance. What I am not sure about yet is how this will actually look to the user or how much work it will be to set up and maintain it. For example: 1. Can you see a relationship one or two levels away on the CI relationship table? For example, if I have a rack that has a BMC_PhysicalLocation object related (room 345, grid 1,8), a blade enclosure related to the rack and a blade related to that enclosure, from the blade's relationship table, I'm assuming I won't see the location object related, right? If I won't, is there an easily available mechanism to trace up the tree to find and display it on the CI form? 2. I'm thinking that I can add a table onto the PQ_Enclosure form that will allow for searches of related PQ_Slots, with a filter to let the user choose between All, Open, and Filled slots. Any problems with this? 3. What will the easiest way be to find a particular combination of slots? What I imagine is a button that brings up a dialog that lets the user choose location, enclosure/slot type, and number of slots needed. For example, say there is a three AU enclosure that needs to be mounted. If there is an easier mechanism built in, please let me know, but here are my thoughts otherwise: a. I could reduce the scope of the search with a running tally of open slots on the enclosure themselves; start with a list of only the enclosures that have enough slots, then search to find consecutive. b. A smart search could start with the number of consecutive slots needed, (ex: 3), table walk related slots in order, add to a counter for each open slot found, reset the counter for used slot found, and stop when counter equals slots needed. 4. Another useful piece will be having a visual representation, Nlyte style; i.e., the enclosure objects and relationships would be exported to this solution and a visual image of the rack and the objects in it would be generated. I have been told there are some freeware (visio?) solutions that will let you plot relationships in controlled fashion like this. Does anyone have any
Message images
Hi All, Sort of an odd question that seems to fit on a rainy Friday. You know that symbols for the AR System User note, warning and error messages. Has anyone have those images? I am creating a Yes/No dialog box and trying to make it look like a system message. If anyone has the images that I could slap onto a flat button, that would be great. Thanks Mark Mark Brittain Remedy Developer ITILv3 Foundation NaviSite - A Time Warner Cable Company mbritt...@navisite.com Office: 315-453-2912 x5335 Mobile: 315-317-2897 This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: SRM and Puppet
Reading from the TMS Admin 7600.pdf document it says: You should define all the content you need to create an automatic task on the Automatic tab of the Task Template form. There is no Automatic Tab on the Task Template form. We have 7.6.04 SP2. Is it somewhere else now? Thanks! Lisa From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Pierson, Shawn Sent: Wednesday, April 25, 2012 2:06 PM To: arslist@ARSLIST.ORG Subject: Re: SRM and Puppet ** I believe the document you want to look at is BMC Remedy IT Service Management Configuration Guide. In it look for the section on the Command Automation Interface. I haven't worked with Puppet so I am not sure how you call things with it, but that document should help you get a better understanding of what steps would be needed. Thanks, Shawn Pierson Remedy Developer | Energy Transfer From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa Sent: Wednesday, April 25, 2012 12:53 PM To: arslist@ARSLIST.ORG Subject: Re: SRM and Puppet ** Thanks Shawn, Is there a document specifically about Task Management. I can't find anything about the Launch Command feature of this... Thanks! Lisa From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Pierson, Shawn Sent: Wednesday, April 25, 2012 1:52 PM To: arslist@ARSLIST.ORG Subject: Re: SRM and Puppet ** If you look into Task Management, there are automated tasks that you can build that should help you with some of that. You would still have to do some level of customization of ITSM (especially if you want to pass data entered via SRM to the Task itself) but it should be doable. Thanks, Shawn Pierson Remedy Developer | Energy Transfer From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa Sent: Wednesday, April 25, 2012 12:50 PM To: arslist@ARSLIST.ORG Subject: Re: SRM and Puppet ** Let me give some more details: We are a completely custom shop right now (ARS 7.6.04 SP2) We have a goal of researching the possibility of automating functions of our Operations and Server teams (ie. creating VM's, etc) So we installed the ITSM Stack on a test server and have been playing with SRM, CM, and Work Orders, etc. (not really focusing on Automation yet) and we have not done anything with CMDB yet. The boss wants a simulation of what automation would look like for a presentation. He'd like to use Puppet (which I think is very much like Blade Logic). Luckily, there are others that are working on the Puppet part (so I don't need to worry about that end of it). All I need to do is launch something to start a process in Puppet. One of the tests that was suggested was using one of the PUPPET capabilities to use the 'message of the day' module that would target Unix servers. They want the SRM process to drop the message to Puppet for it to pick up and execute. My MAIN question (which I meant to ask before) is: Can dropping the message to Puppet be done with simply SRM and a CM, or is there more to it than that? Would CMDB and Orchestrator have to be involved? I'm not sure that SRM and CM is all that needs to be involved with this. Thanks! Lisa From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa Sent: Wednesday, April 25, 2012 12:09 PM To: arslist@ARSLIST.ORG Subject: SRM and Puppet ** Has anyone used SRM to launch automation tasks using Puppet? (http://puppetlabs.com/) Lisa Kemes AR System Developer TEIS - USA +1 717 810 2408 tel +1 717 602 9460 mobile lisa.ke...@te.commailto:lisa.ke...@te.com 100 Amp Drive Harrisburg, PA 17112 [http://www.te.com/images/socialmedia/smallTElogo.gif]http://www.te.com/ www.te.comhttp://www.te.com/ [http://www.te.com/images/socialmedia/twitter.png]http://twitter.com/teconnectivity[http://www.te.com/images/socialmedia/facebook.png]http://www.facebook.com/teconnectivity[http://www.te.com/images/socialmedia/flickr.png]http://www.flickr.com/photos/teconnectivity/[http://www.te.com/images/socialmedia/linkedin.png]http://www.linkedin.com/groups?gid=1591657[http://www.te.com/images/socialmedia/youtube.png]http://www.youtube.com/teconnectivity _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ Private and confidential as detailed herehttp://www.sug.com/disclaimers/default.htm#Mail. If you cannot access hyperlink, please e-mail sender. _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ Private and confidential as detailed herehttp://www.sug.com/disclaimers/default.htm#Mail. If you cannot access hyperlink, please e-mail sender. _attend WWRUG12 www.wwrug.com ARSlist:
Re: SRM and Puppet
I think I found the answer: The Automatic tab on the Task Template form appears only if the task template that you are defining is for an Automatic task. Thanks! Lisa From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa Sent: Friday, April 27, 2012 12:27 PM To: arslist@ARSLIST.ORG Subject: Re: SRM and Puppet ** Reading from the TMS Admin 7600.pdf document it says: You should define all the content you need to create an automatic task on the Automatic tab of the Task Template form. There is no Automatic Tab on the Task Template form. We have 7.6.04 SP2. Is it somewhere else now? Thanks! Lisa From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Pierson, Shawn Sent: Wednesday, April 25, 2012 2:06 PM To: arslist@ARSLIST.ORG Subject: Re: SRM and Puppet ** I believe the document you want to look at is BMC Remedy IT Service Management Configuration Guide. In it look for the section on the Command Automation Interface. I haven't worked with Puppet so I am not sure how you call things with it, but that document should help you get a better understanding of what steps would be needed. Thanks, Shawn Pierson Remedy Developer | Energy Transfer From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa Sent: Wednesday, April 25, 2012 12:53 PM To: arslist@ARSLIST.ORG Subject: Re: SRM and Puppet ** Thanks Shawn, Is there a document specifically about Task Management. I can't find anything about the Launch Command feature of this... Thanks! Lisa From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Pierson, Shawn Sent: Wednesday, April 25, 2012 1:52 PM To: arslist@ARSLIST.ORG Subject: Re: SRM and Puppet ** If you look into Task Management, there are automated tasks that you can build that should help you with some of that. You would still have to do some level of customization of ITSM (especially if you want to pass data entered via SRM to the Task itself) but it should be doable. Thanks, Shawn Pierson Remedy Developer | Energy Transfer From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa Sent: Wednesday, April 25, 2012 12:50 PM To: arslist@ARSLIST.ORG Subject: Re: SRM and Puppet ** Let me give some more details: We are a completely custom shop right now (ARS 7.6.04 SP2) We have a goal of researching the possibility of automating functions of our Operations and Server teams (ie. creating VM's, etc) So we installed the ITSM Stack on a test server and have been playing with SRM, CM, and Work Orders, etc. (not really focusing on Automation yet) and we have not done anything with CMDB yet. The boss wants a simulation of what automation would look like for a presentation. He'd like to use Puppet (which I think is very much like Blade Logic). Luckily, there are others that are working on the Puppet part (so I don't need to worry about that end of it). All I need to do is launch something to start a process in Puppet. One of the tests that was suggested was using one of the PUPPET capabilities to use the 'message of the day' module that would target Unix servers. They want the SRM process to drop the message to Puppet for it to pick up and execute. My MAIN question (which I meant to ask before) is: Can dropping the message to Puppet be done with simply SRM and a CM, or is there more to it than that? Would CMDB and Orchestrator have to be involved? I'm not sure that SRM and CM is all that needs to be involved with this. Thanks! Lisa From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa Sent: Wednesday, April 25, 2012 12:09 PM To: arslist@ARSLIST.ORG Subject: SRM and Puppet ** Has anyone used SRM to launch automation tasks using Puppet? (http://puppetlabs.com/) Lisa Kemes AR System Developer TEIS - USA +1 717 810 2408 tel +1 717 602 9460 mobile lisa.ke...@te.commailto:lisa.ke...@te.com 100 Amp Drive Harrisburg, PA 17112 [http://www.te.com/images/socialmedia/smallTElogo.gif]http://www.te.com/ www.te.comhttp://www.te.com/ [http://www.te.com/images/socialmedia/twitter.png]http://twitter.com/teconnectivity[http://www.te.com/images/socialmedia/facebook.png]http://www.facebook.com/teconnectivity[http://www.te.com/images/socialmedia/flickr.png]http://www.flickr.com/photos/teconnectivity/[http://www.te.com/images/socialmedia/linkedin.png]http://www.linkedin.com/groups?gid=1591657[http://www.te.com/images/socialmedia/youtube.png]http://www.youtube.com/teconnectivity _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ Private and confidential as detailed
Re: Def-export of Packing Lists missing objects...
Hi, I would be very surprised if the getContainer-call gives you the wrong result. When I edit/open my packing-list in Dev Studio I always get the correct count. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * 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. Well...I'm referring specifically to the getContainer call (I use Java) off of the ARServerUser object, and then do a print of that object structure. I'm asking because we are on 7.6.4 SP1, upgrading to SP3 shortly in production. We use packing lists extensively to determine the code that needs to be moved to prod from Dev...but we don't use the Dev studio to export our code, we use a custom app I have written that walks the contents of the packing list and exports each object to its own def file and I've never experienced the situation that you are discussing, but mainly because I don't ask my ARServerUser object to export the entire PL, but instead, a separate export for each object within it...so I'm looking to see if you can identify within the PL Object on the server if each object is 'defined properly'basically...see if you can figure out what's causing the objects that aren't showing up in your def to not show up. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: Wednesday, April 25, 2012 2:29 PM To: arslist@ARSLIST.ORG Subject: Re: Def-export of Packing Lists missing objects... Hi, Do you mean using ARExport() or ARGetContainer()? Why would that differ? The def-file is pretty much an ARExport()-call... Best Regards - Misi, RRR AB, http://rrr.se If you connect to your server via your favorite api language, and output the contents of the containerare all of the references to your workflow there appropriately? -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: Wednesday, April 25, 2012 10:22 AM To: arslist@ARSLIST.ORG Subject: Re: Def-export of Packing Lists missing objects... Hi, I have only looked at the PL in the DEF-file. The filters had not change between my exports, the only thing I did was to remove and readd on object. Best Regards - Misi, RRR AB, http://rrr.se You have obviously looked at the PL through the API to be able to find the differences. Have you compared the filters in question having the problem with those that aren't and see if you see ANY difference? -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: Wednesday, April 25, 2012 9:43 AM To: arslist@ARSLIST.ORG Subject: Re: Def-export of Packing Lists missing objects... Hi, Exporting as XML changed nothing. I added the objects by right-clicking on the packing list and choosing edit. After that I press the Add... button. I removed, saved, closed, reopened and readded a problematic object. This resulted in 65 exported objects instead of the 63 I had before the change... The ONLY difference if I look at the exported container-definition (packing-list-definition), is that one of the references changed position in the list. Everything els is the same. Very strange! Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * 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'm keenly interested in this problem. Do you have this problem if you export the objects in XML Def instead of regular Def? How were these objects added to the PL...if you remove one of the 'missing' ones, save, then re-add it, is it still missing? -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: Wednesday, April 25, 2012 1:55 AM To: arslist@ARSLIST.ORG Subject: Re: Def-export of Packing Lists missing objects... Hi Guillaume, I tried your suggestion, and both when I set 'Add Items With Related Property' to Content and Directly Related Objects, I still get the same result... 20 missing filters and 1 missing filter-guide in the DEF, with a total of 83 objects in the packing-list: $ perl rrrVerPackList.pl RRR-VENDOR-EMAIL-v6.def Missing objects in PACKING LIST ### NOT IN PACK 3/RRR-VENDOR-EMAIL Missing objects in DEF FILE ### NOT IN DEF
Re: Message images
Hi mark if you select image property in DS and then click on Image Reference you might find the image there. I have not checked whether the image you want is there but worth checking. thanks Shafqat Ayaz From: Brittain, Mark mbritt...@navisite.com To: arslist@ARSLIST.ORG Sent: Friday, April 27, 2012 5:23 PM Subject: Message images ** Hi All, Sort of an odd question that seems to fit on a rainy Friday. You know that symbols for the AR System User note, warning and error messages. Has anyone have those images? I am creating a Yes/No dialog box and trying to make it look like a system message. If anyone has the images that I could slap onto a flat button, that would be great. Thanks Mark Mark Brittain Remedy Developer ITILv3 Foundation NaviSite – A Time Warner Cable Company mbritt...@navisite.com Office: 315-453-2912 x5335 Mobile: 315-317-2897 This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: RE-POST DUE TO FORMAT ERRORS: ARSFAQ! ARSFAQ! - Stackoverflow(ish) clone for Remedy QA - BETA
LOL - Yes weee, NO we didn't! You know what's messed up about that question? It's spam. You know what's messed up about it being spam? I put a lot of effort into writing scripts to flag and capture that stuff. You know what's messed...ahhh you get it. The question has been deleted, of course. Date: Thu, 26 Apr 2012 15:01:35 -0600 From: lj.longw...@gmail.com Subject: Re: RE-POST DUE TO FORMAT ERRORS: ARSFAQ! ARSFAQ! - Stackoverflow(ish) clone for Remedy QA - BETA To: arslist@ARSLIST.ORG ** Michael,We have reached critical mass 2012/4/20 Nau, Michael m@ing-diba.de ** I’ve got my browser set to auto-refresh and am waiting for question no.2 to be posted. I think this will be the critical mass. Hey, it’s Friday ;-) Good luck with the site! RegardsMichael From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Michael Latham Sent: Monday, April 16, 2012 3:18 AM To: arslist@ARSLIST.ORG Subject: Re: RE-POST DUE TO FORMAT ERRORS: ARSFAQ! ARSFAQ! - Stackoverflow(ish) clone for Remedy QA - BETA ** POLITICAL ANSWER: The idea is to present exclusivity and a sense of community in regards to the Remedy folks that is not an appendage of yet another conglomeration of tech sites. MY ANSWER: I just wanted to provide something I thought was cool to other cool people like myself. You know those individuals who would like to feel more interaction and gain more credit for their knowledge with Remedy and all associated technologies. I also felt like it was an easier interface to collaborate on when it comes to Q A but at the same time providing a forum atmosphere without the forum look. TLDR Version: I just wanted to do something exclusive but familiar to those who share my passion of Remedy...or not. Date: Fri, 13 Apr 2012 09:53:37 -0400 From: jon.sla...@amway.com Subject: Re: RE-POST DUE TO FORMAT ERRORS: ARSFAQ! ARSFAQ! - Stackoverflow(ish) clone for Remedy QA - BETA To: arslist@ARSLIST.ORG I was going to say Why not just create a stack exchange site proposal? AFAIK they're free, you just have to prove you have enough users to make it worthwile ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ING-DiBa AG, Frankfurt am Main. Registernummer HRB 7727, Handelsregister Amtsgericht Frankfurt am Main. Vorstand: Roland Boekhout (Vorsitzender), Herbert Willius (stellv. Vorsitzender), Bas Brouwers, Bernd Geilen, Katharina Herrmann, Martin Krebs. Aufsichtsrat: Ben Tellings (Vorsitzender) Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist nicht gestattet. This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: RE-POST DUE TO FORMAT ERRORS: ARSFAQ! ARSFAQ! - Stackoverflow(ish) clone for Remedy QA - BETA
There was a question? From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Michael Latham Sent: Friday, April 27, 2012 12:29 PM To: arslist@ARSLIST.ORG Subject: Re: RE-POST DUE TO FORMAT ERRORS: ARSFAQ! ARSFAQ! - Stackoverflow(ish) clone for Remedy QA - BETA ** LOL - Yes weee, NO we didn't! You know what's messed up about that question? It's spam. You know what's messed up about it being spam? I put a lot of effort into writing scripts to flag and capture that stuff. You know what's messed...ahhh you get it. The question has been deleted, of course. Date: Thu, 26 Apr 2012 15:01:35 -0600 From: lj.longw...@gmail.commailto:lj.longw...@gmail.com Subject: Re: RE-POST DUE TO FORMAT ERRORS: ARSFAQ! ARSFAQ! - Stackoverflow(ish) clone for Remedy QA - BETA To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG ** Michael, We have reached critical mass 2012/4/20 Nau, Michael m@ing-diba.demailto:m@ing-diba.de ** I've got my browser set to auto-refresh and am waiting for question no.2 to be posted. I think this will be the critical mass. Hey, it's Friday ;-) Good luck with the site! Regards Michael From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of Michael Latham Sent: Monday, April 16, 2012 3:18 AM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: RE-POST DUE TO FORMAT ERRORS: ARSFAQ! ARSFAQ! - Stackoverflow(ish) clone for Remedy QA - BETA ** POLITICAL ANSWER: The idea is to present exclusivity and a sense of community in regards to the Remedy folks that is not an appendage of yet another conglomeration of tech sites. MY ANSWER: I just wanted to provide something I thought was cool to other cool people like myself. You know those individuals who would like to feel more interaction and gain more credit for their knowledge with Remedy and all associated technologies. I also felt like it was an easier interface to collaborate on when it comes to Q A but at the same time providing a forum atmosphere without the forum look. TLDR Version: I just wanted to do something exclusive but familiar to those who share my passion of Remedy...or not. Date: Fri, 13 Apr 2012 09:53:37 -0400 From: jon.sla...@amway.commailto:jon.sla...@amway.com Subject: Re: RE-POST DUE TO FORMAT ERRORS: ARSFAQ! ARSFAQ! - Stackoverflow(ish) clone for Remedy QA - BETA To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG I was going to say Why not just create a stack exchange site proposal? AFAIK they're free, you just have to prove you have enough users to make it worthwile ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.orghttp://www.arslist.org attend wwrug12 www.wwrug12.comhttp://www.wwrug12.com ARSList: Where the Answers Are _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ ING-DiBa AG, Frankfurt am Main. Registernummer HRB 7727, Handelsregister Amtsgericht Frankfurt am Main. Vorstand: Roland Boekhout (Vorsitzender), Herbert Willius (stellv. Vorsitzender), Bas Brouwers, Bernd Geilen, Katharina Herrmann, Martin Krebs. Aufsichtsrat: Ben Tellings (Vorsitzender) Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist nicht gestattet. This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.orghttp://www.arslist.org attend wwrug12 www.wwrug12.comhttp://www.wwrug12.com ARSList: Where the Answers Are _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: RE-POST DUE TO FORMAT ERRORS: ARSFAQ! ARSFAQ! - Stackoverflow(ish) clone for Remedy QA - BETA
You cant back down from critical mass its not possible thats whats CRITICAL about it there is NO GOING BACK .oh well now we must wait for an ACTUAL second question to see if it truly is critical mass J From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Michael Latham Sent: Friday, April 27, 2012 11:29 AM To: arslist@ARSLIST.ORG Subject: Re: RE-POST DUE TO FORMAT ERRORS: ARSFAQ! ARSFAQ! - Stackoverflow(ish) clone for Remedy QA - BETA ** LOL - Yes weee, NO we didn't! You know what's messed up about that question? It's spam. You know what's messed up about it being spam? I put a lot of effort into writing scripts to flag and capture that stuff. You know what's messed...ahhh you get it. The question has been deleted, of course. _ Date: Thu, 26 Apr 2012 15:01:35 -0600 From: lj.longw...@gmail.com Subject: Re: RE-POST DUE TO FORMAT ERRORS: ARSFAQ! ARSFAQ! - Stackoverflow(ish) clone for Remedy QA - BETA To: arslist@ARSLIST.ORG ** Michael, We have reached critical mass 2012/4/20 Nau, Michael m@ing-diba.de ** Ive got my browser set to auto-refresh and am waiting for question no.2 to be posted. I think this will be the critical mass. Hey, its Friday ;-) Good luck with the site! Regards Michael From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Michael Latham Sent: Monday, April 16, 2012 3:18 AM To: arslist@ARSLIST.ORG Subject: Re: RE-POST DUE TO FORMAT ERRORS: ARSFAQ! ARSFAQ! - Stackoverflow(ish) clone for Remedy QA - BETA ** POLITICAL ANSWER: The idea is to present exclusivity and a sense of community in regards to the Remedy folks that is not an appendage of yet another conglomeration of tech sites. MY ANSWER: I just wanted to provide something I thought was cool to other cool people like myself. You know those individuals who would like to feel more interaction and gain more credit for their knowledge with Remedy and all associated technologies. I also felt like it was an easier interface to collaborate on when it comes to Q A but at the same time providing a forum atmosphere without the forum look. TLDR Version: I just wanted to do something exclusive but familiar to those who share my passion of Remedy...or not. Date: Fri, 13 Apr 2012 09:53:37 -0400 From: jon.sla...@amway.com Subject: Re: RE-POST DUE TO FORMAT ERRORS: ARSFAQ! ARSFAQ! - Stackoverflow(ish) clone for Remedy QA - BETA To: arslist@ARSLIST.ORG I was going to say Why not just create a stack exchange site proposal? AFAIK they're free, you just have to prove you have enough users to make it worthwile ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ING-DiBa AG, Frankfurt am Main. Registernummer HRB 7727, Handelsregister Amtsgericht Frankfurt am Main. Vorstand: Roland Boekhout (Vorsitzender), Herbert Willius (stellv. Vorsitzender), Bas Brouwers, Bernd Geilen, Katharina Herrmann, Martin Krebs. Aufsichtsrat: Ben Tellings (Vorsitzender) Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist nicht gestattet. This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: SRM association
Try SRM:Request. You may want to add the AppRequestID (CRQ or INC #) to fields in view. On Fri, Apr 27, 2012 at 6:54 AM, remedyarl...@gmail.com wrote: SRM: 7.6.04 Do we have a form where we can find all IM CM tickets associated with SRM. I have a issue where even after IM ticket is resolved SRM tickets are still in planning status. I need to find all SRM tickets for which associated tickets are resolved. I am not sure if this is a bug in the system but that would be my second task. Thanks in adv. Sent on my BlackBerry® from Vodafone ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are -- Rebecca Boyd Application Administrator Wake Forest University ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Issue with Grouping on a Table field
There is a Character Field with a menu that sets the EXTERNAL query and refreshes the table field. I am having trouble seeing how that would prevent a grouping from showing up. I think I will set the table qualification to 1=1 and add the Refresh button back so I can refresh manually to rule out any odd timing issues like you describe. Jason On Fri, Apr 27, 2012 at 3:07 PM, Joe Martin D'Souza jdso...@shyle.netwrote: ** Weird... Would you be having any workflow may be getting triggered on Refresh table fire workflow or whatever that option is on the table field display property? I would check along that direction and see if there is anything ‘workflow’ wise that is preventing the display of that last entry.. Joe *From:* Jason Miller jason.mil...@gmail.com *Sent:* Friday, April 27, 2012 5:25 PM *Newsgroups:* public.remedy.arsystem.general *To:* arslist@ARSLIST.ORG *Subject:* Issue with Grouping on a Table field ** Hello everybody, Has anybody seen this issue where the last record in a Table field does not show when the Table is set to Group on a field? In the screen print below you can see there are 4 groupings. The first three grouping show the lines/records in that group. The last grouping (#4) does not show the record in that group. Any ideas? ARS 7.6.04 SP2 on Window with MS SQL [image: Inline image 1] Thanks, Jason _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Issue with Grouping on a Table field
Nope, no difference. On Fri, Apr 27, 2012 at 3:41 PM, Jason Miller jason.mil...@gmail.comwrote: There is a Character Field with a menu that sets the EXTERNAL query and refreshes the table field. I am having trouble seeing how that would prevent a grouping from showing up. I think I will set the table qualification to 1=1 and add the Refresh button back so I can refresh manually to rule out any odd timing issues like you describe. Jason On Fri, Apr 27, 2012 at 3:07 PM, Joe Martin D'Souza jdso...@shyle.netwrote: ** Weird... Would you be having any workflow may be getting triggered on Refresh table fire workflow or whatever that option is on the table field display property? I would check along that direction and see if there is anything ‘workflow’ wise that is preventing the display of that last entry.. Joe *From:* Jason Miller jason.mil...@gmail.com *Sent:* Friday, April 27, 2012 5:25 PM *Newsgroups:* public.remedy.arsystem.general *To:* arslist@ARSLIST.ORG *Subject:* Issue with Grouping on a Table field ** Hello everybody, Has anybody seen this issue where the last record in a Table field does not show when the Table is set to Group on a field? In the screen print below you can see there are 4 groupings. The first three grouping show the lines/records in that group. The last grouping (#4) does not show the record in that group. Any ideas? ARS 7.6.04 SP2 on Window with MS SQL [image: Inline image 1] Thanks, Jason _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: SRM association
Thanks rebecca for the reply, but what if a single SR have multiple IM and CRQ associated with it. What data will AppRequestID hold then. Sent on my BlackBerry® from Vodafone -Original Message- From: Boyd, Rebecca boy...@wfu.edu Sender: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG Date: Fri, 27 Apr 2012 17:03:12 To: arslist@ARSLIST.ORG Reply-To: arslist@ARSLIST.ORG Subject: Re: SRM association Try SRM:Request. You may want to add the AppRequestID (CRQ or INC #) to fields in view. On Fri, Apr 27, 2012 at 6:54 AM, remedyarl...@gmail.com wrote: SRM: 7.6.04 Do we have a form where we can find all IM CM tickets associated with SRM. I have a issue where even after IM ticket is resolved SRM tickets are still in planning status. I need to find all SRM tickets for which associated tickets are resolved. I am not sure if this is a bug in the system but that would be my second task. Thanks in adv. Sent on my BlackBerry® from Vodafone ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are -- Rebecca Boyd Application Administrator Wake Forest University ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Issue with Grouping on a Table field
Another thing I seem to vaguely recall at the back of my mind of there being trouble with the 112 field when it came to ‘something’ – not sure what that something was.. And I do not recall if that was fixed. Care to check in that direction? Specifically if the user performing that refresh, does not have access by way of field 112 on that request, but somehow the table field calculates that there is a record, but does not display it? It’s a far cry, but when troubleshooting sometimes I’ve seen the most vague possibility sometimes is your answer if that is the only vague possibility you can think of.. I guess I’m asking you to eliminate that vague, almost improbable possibility.. Joe From: Jason Miller Sent: Friday, April 27, 2012 6:41 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Issue with Grouping on a Table field ** There is a Character Field with a menu that sets the EXTERNAL query and refreshes the table field. I am having trouble seeing how that would prevent a grouping from showing up. I think I will set the table qualification to 1=1 and add the Refresh button back so I can refresh manually to rule out any odd timing issues like you describe. Jason On Fri, Apr 27, 2012 at 3:07 PM, Joe Martin D'Souza jdso...@shyle.net wrote: ** Weird... Would you be having any workflow may be getting triggered on Refresh table fire workflow or whatever that option is on the table field display property? I would check along that direction and see if there is anything ‘workflow’ wise that is preventing the display of that last entry.. Joe From: Jason Miller Sent: Friday, April 27, 2012 5:25 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Issue with Grouping on a Table field ** Hello everybody, Has anybody seen this issue where the last record in a Table field does not show when the Table is set to Group on a field? In the screen print below you can see there are 4 groupings. The first three grouping show the lines/records in that group. The last grouping (#4) does not show the record in that group. Any ideas? ARS 7.6.04 SP2 on Window with MS SQL Thanks, Jason ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are