Re: Menu on same field
Can you do a sql menu with distinct Take Care Dale Jones 919-523-6034 Take Care Dale Jones 919-523-6034 > On Oct 4, 2017, at 4:39 PM, Brittain, Mark wrote: > > ** > Hi All > > This is one of those case where I did something years ago and can’t remember > how I did it. Hoping someone can assist. > > Have 10 records and the First Name field contains Joe, Joe, Bob, Joe, Mike, > Joe, Bob, Mike, Joe and Bill. > > On the same field I want have a menu that searches on the First Name field > and displays Bill, Bob, Joe, Mike. > > If I create a new record I could use the existing names or type in a new one. > If the new record was for Mary, after submit, the menu would contain Bill, > Bob, Joe, Mary, Mike > > I just know this is simple enough to do, but it was about 10 years last time > I did it. Any suggestions would be greatly appreciated. > > ARS 9.1 > > Thanks > Mark > > Mark Brittain | Senior Systems Engineer | 315.634.9337 > 125 Elwood Davis Road | Syracuse NY 13212 > > > _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: Engage: Guess Who
Do not recognize Doug Mueller without his windbreaker jacket. Take Care Dale Jones 919-523-6034 > On Oct 15, 2014, at 4:35 PM, "Tanner, Doug" > wrote: > > ** > Guess who? > Doug Tanner > This email is subject to certain disclaimers, which may be reviewed via the > following link. http://compass-usa.com/Pages/Disclaimer.aspx. _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: Strange search results
When you use the menus hidden fields are set by active links used for validation. Ie the instance id of the Asset cti is set in a hidden field This value does not match your record for some reason. (Usually a delete and recreate of the cti in question) To clean up - manually type in CTI and search. You can manually reselect cti and save each record or perform a modify all and set cti by using the menu. Take Care Dale Jones 919-523-6034 > On Oct 15, 2014, at 2:08 PM, "Morrison, David A." > wrote: > > ** > Good day list, > > Having a strange search problem. Using ARS 7.1 with SQL. Have a basic Asset > form with equipment CTI. When user does a search selecting from the pull > down menu, the results only show part of the assets. If you manually type > the CTI in the fields, it shows all of the assets for that CTI. Any ideas? > Thanks in advance. > > David Morrison > East Tennessee State University > _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"
Business Time Segment Code (Active Links, Filters, Escalations and Form) get modified every night
Has anyone ever seen the Business Time Segment Code (Active Links, Filters, Escalations and Form) get modified every night by "Remedy Application Service"? Looks like someone is installing it at 3AM every morning. I am looking into this for a customer on 7.5.00 Patch 008 Hotfix 20140205. Take Care Dale Jones DCS Raleigh, NC 919-523-6034 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Asset Blackout Dates with Change "Schedule Assist"
ITSM 8.1 I am being asking about Blackout Date and how they work with Change Management "Schedule Assist". Not finding it very useful and documentation/community notes are limited (I am just starting to scratch the surface) Am I missing a lot on this feature and should I dig deeper. I can get the "Find Next Avail Time" for basic Blackout windows to work for complete days. This function is part of CHG and leverages the foundation Time Segment feature. Does anyone have any working useful use cases or test cases that I can recreate. Do not want to dig deeper if nothing is really there? Is anyone productively using ITSM Change "Schedule Assist" button and the "Find Next Avail Time" button? Thanks Dale Jones DCS Raleigh, NC 919-523-6034 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: ADV: Cherwell Webinar
I have been working with Remedy since 1994 and over the past 2 year have been offered countless Remedyforce contracts, that I turned down. The recruiters did not know that Remedy and Remedyforce were different. This past February I decided to take the SalesForce.com developer certification and the RemedyForce certification program. Currently have 2 Remedy projects going along with one RemedyForce engagement RemedyForce has similar methodology but completely different coding logic. The good thing is it reminds me of the Remedy 4.0 days (good old days) (Powerful but has some things where you just have to code around the SaleForce.com As Design features) Dale Jones DCS Raleigh, NC 919-523-6034 From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] on behalf of LJ LongWing [lj.longw...@gmail.com] Sent: Monday, August 04, 2014 4:20 PM To: arslist@ARSLIST.ORG Subject: Re: ADV: Cherwell Webinar ** yeaI understand why BMC named it 'Remedyforce', to capitalize on the 'name' of Remedy, but I've had countless people say 'So, you know Remedy, how do I do this in Remedyforce'it's tough explaining to them that Remedyforce, despite it's name is NOT Remedy On Mon, Aug 4, 2014 at 2:17 PM, Tauf Chowdhury mailto:taufc...@gmail.com>> wrote: ** Good point LJ. It's built on a different platform so Sent from my iPhone On Aug 4, 2014, at 4:12 PM, LJ LongWing mailto:lj.longw...@gmail.com>> wrote: ** But...RemedyForce IS another productit's not another company...but it is 100% a different product... On Mon, Aug 4, 2014 at 2:07 PM, Grassi, Christopher mailto:cgra...@columnit.com>> wrote: ** I’ve been using Remedy since Version 5 - if you are unhappy with Remedy for any reason, I would look at Remedyforce before going to another product. Feel free to reach out if you want to know more. -Chris Grassi cgras...@gmail.com<mailto:cgras...@gmail.com> On 4 Aug 2014, at 14:44, Kevin Shaffer mailto:kshaf...@partneritsm.com>> wrote: ** I have been hesitant to bring up the topic of Cherwell on the ARSList, but there seems to have been some interest and discussion about Cherwell last week. First of all, I have been a Remedy consultant since the late 90’s, version 3.x. I have experienced all the highs and lows that everyone describes on this list. I would love to see BMC succeed and Remedy continue to lead. The reality is I have witnessed many of my colleagues drift over to SNOW and others get out of the business completely, as we watched the competitors catch up and some even surpass in some areas as others have pointed out. The majority of our business is still BMC, but a growing portion of it is now Cherwell. Most of us are all facing similar challenges and questions from management. Why does the licensing model have to be so confusing?, Why do upgrades have to be so painful?, Why can’t I call support and get an onshore resource?, Why does on-premise or on-demand feel like a lifetime commitment?, etc. Whether or not you feel that any of the aforementioned questions are true about BMC Remedy, these questions are still being asked by management. Partner IT is hosting a one hour webinar on August 14, 2014 at 1 PM EST to discuss how Cherwell can address many of the “Why” questions we all face. The intended audience is not just Remedy users but rather companies that are evaluating options. Please contact me OFFLINE if you are interested in attending and I will send you a more formal invitation. We will have very techy people presenting to address anything that comes up. Kevin Shaffer, Senior Partner Partner IT, Inc. Office Phone: (888) 380-8899 Cell Phone: (316) 208-5341 Fax: (708) 887-1704 Email: kshaf...@partneritsm.com<mailto:kshaf...@partneritsm.com> Website: http://www.partneritsm.com Follow Us: http://www.twitter.com/partneritsm YouTube: http://www.youtube.com/partneritsm _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_ _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: Mid Tier 8.1.01 Timeouts
Describe your environment (Load balancers?? or SSO??) I recently had a 8.1.01 customer with Java SSO (Single Sign On) where we had to increase the Java SSO time deviation. We were getting the following error in the Plugin Logs Too much deviation between the token timestamp and the system time. Once we increased the Deviation parameter the timeout issues stopped. Take Care Dale Jones DCS Raleigh, NC 919-523-6034 From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] on behalf of Hennigan, Sandra [sandra.henni...@usdoj.gov] Sent: Tuesday, March 11, 2014 4:33 PM To: arslist@ARSLIST.ORG Subject: Re: Mid Tier 8.1.01 Timeouts ** Does security have an application timeout? Thank you, Sandra Hennigan Remedy Developer From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Lippincott, Levi (OMA-GIS) Sent: Tuesday, March 11, 2014 4:26 PM To: arslist@ARSLIST.ORG Subject: Mid Tier 8.1.01 Timeouts ** Has anyone ran into the issue where their users are timing out after an extremely low amount of time from the Mid Tier? This is even happening to some of our Fixed license users. They are getting session invalid errors after sometimes as little as 10 minutes. [Description: Description: cid:411C7191-C84A-4BC4-84A6-03A2A02A75D5] Connect with us:interpublic.com<http://www.interpublic.com/> Twitter<https://twitter.com/#%21/interpublicipg> Facebook<https://www.facebook.com/InterpublicGroup> Levi Lippincott / Remedy Administrator +1 402 561 7014 office +1 402 321 5421 mobile levi.lippinc...@interpublic.com<mailto:levi.lippinc...@interpublic.com> Lync Communcator Interpublic Group 6825 Pine Street, Omaha, NE 68106 "Talent is a Gift; But Character is a Choice." -Matt Grotewold- This message contains information which may be confidential and privileged. Unless you are the intended recipient (or authorized to receive this message for the intended recipient), you may not use, copy, disseminate or disclose to anyone the message or any information contained in the message. If you have received the message in error, please advise the sender by reply e-mail, and delete the message. Thank you very much. _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 to delete all changes 5k as its testing
There is some tasks that need cleaning. Here are a couple options: Temporarily Disable the Task Filter that checks for Assignee TMS:TAS:RequireAssignee Or Fix the Tasks with the missing Assignee. Find the One or Mod All Tasks that have NULL Assignee Or Open Task via the Object List and Delete first. https://Server:8443/arsys/forms/Server/AR System Mid Tier Object List or directly https://Server:8443/arsys/forms/Server/TMS:Task Dale Jones DCS Raleigh, NC 919-523-6034 From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] on behalf of Hany Abd Elfattah [hany...@gmail.com] Sent: Thursday, February 13, 2014 9:46 AM To: arslist@ARSLIST.ORG Subject: Re: how to delete all changes 5k as its testing ** What do you mean by using the mid tier to delete 5k test change with its tasks and approvals, i tried to delete them from the application but i faced error please select the task assignee group first On Thursday, February 13, 2014, Dale Jones mailto:d...@dcshq.com>> wrote: ** 5k - Just use the Mid Tier 5K is not a lot to clean up A lot safer. Dale Jones DCS Raleigh, NC 919-523-6034 From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] on behalf of Hany Abd Elfattah [hany...@gmail.com] Sent: Thursday, February 13, 2014 9:27 AM To: arslist@ARSLIST.ORG Subject: how to delete all changes 5k as its testing ** Hi all, We are moving new environment 7.6 to production and need to delete all test cases of changes and it's related tasks and the approval if possible They are around 5k test change, is there a way to delete them from DB or any other easy and safe way Thx, Hany -- BR, Hany _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ -- BR, Hany _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 to delete all changes 5k as its testing
5k - Just use the Mid Tier 5K is not a lot to clean up A lot safer. Dale Jones DCS Raleigh, NC 919-523-6034 From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] on behalf of Hany Abd Elfattah [hany...@gmail.com] Sent: Thursday, February 13, 2014 9:27 AM To: arslist@ARSLIST.ORG Subject: how to delete all changes 5k as its testing ** Hi all, We are moving new environment 7.6 to production and need to delete all test cases of changes and it's related tasks and the approval if possible They are around 5k test change, is there a way to delete them from DB or any other easy and safe way Thx, Hany -- BR, Hany _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: User not getting window open in Create more (ARUser 7.6.03)
Look in the "AR System User Preference" form Search for the Users Record Clear it or make it the same as a working user. Dale Jones DCS Raleigh, NC 919-523-6034 From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] on behalf of Reiser, John J [john.j.rei...@lmco.com] Sent: Wednesday, February 12, 2014 5:18 PM To: arslist@ARSLIST.ORG Subject: User not getting window open in Create more (ARUser 7.6.03) ** ARS Server 7.6.04 SP5 ARUser 7.6.03 I have three Helpdesk operators taking customer tickets on our home built helpdesk. They run aruser on their windows 7 PC and then there is a third party utility connected to the phone system that accesses the aruser.exe process and forces open the appropriate form based on the Helpdesk number that was called. This 3rd party utility is a blackbox to me and since I can’t prove that it is the culprit I can’t force them to call in the vendor for troubleshooting. The scenario goes like this: A customer calls on Line 1 the utility opens Form 1 in aruser.exe . Line 2 opens form 2 and so on. All forms are supposed to open in Create (green screen) mode. After the request is submitted I close the form with an AL to prevent window bloat because the 3rd party can’t reuse an open window. So for one of the operators the process opens in create mode the first time the aruser.exe is run. All subsequent interaction with the 3rd party utility opens the correct form but in Search mode. It’s not machine specific. It happens on any machine that the Operator use. And when I had the Operator use a dummy account with the same permissions the system worked first time and every time after that. So we have confined the issue to the Operators account. I saved the account to another name and created a new user record with the original name from the Active Directory. She still gets the bad functionality, works the first time but not subsequent times. Active Link logs on the operator’s account only shows what happens after the utility runs. Would the arreload command reset the User-cache and maybe clear her problem. Thank you, --- John J. Reiser Remedy Developer/Administrator Senior Software Development Analyst Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me _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: Migration of Foundation and Historical Data ITSM 7.6 to ITSM 8 - Using Spoon
BMC has been good at not deleting any fields from version to version. They have been adding lots of fields. I would stick to ARX files. As long as you add your custom fields with the same field number Automap will match them up. Closed records should not be edited and that only leaves Open records to clean up. There may be some cleanup of records that historical reports may need for consistency. Dale Jones DCS Raleigh, NC 919-523-6034 From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] on behalf of BradRemedy [bradrem...@gmail.com] Sent: Wednesday, January 15, 2014 12:10 AM To: arslist@ARSLIST.ORG Subject: Re: Migration of Foundation and Historical Data ITSM 7.6 to ITSM 8 - Using Spoon ** Hi With all the various modules, I would say we have < 1 million combined records with around 200 new records being created via SRM on a daily basis (so around 6000 new calls a month). Not a massive system to other installations however it is used extensively in our organization. I was thinking of using ARX files, however wasn't sure on the database structure between the versions and if it would present other problems. On Wed, Jan 15, 2014 at 7:00 AM, Dale Jones mailto:d...@dcshq.com>> wrote: ** Brad, You have multiple options to move data, I would first like to ask a couple questions. Transactional Data - Number of INC, CHG, SRM, PBM, Task. Just ballpark 100K or > million. Volume per month 50K, 100K or >million Number of open tickets INC, CHG, SRM, PBM, Task I have leveraged ARX exports and imports for most of my customers transactional data migrations to 8.1 (1 initial move then multiple Delta moves up to Go Live weekend. Added a handful of cleanup filters and an escalation or two to trigger cleanup. The main cleanup is on open records that need to modified and will trip validation filter errors. Also have added an exclusion to some existing validation filters (ie 'Submit Date' > "01/01/14") (Go Live date 01/01/14 example) Dale Jones DCS Raleigh, NC 919-523-6034 From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>] on behalf of BradRemedy [bradrem...@gmail.com<mailto:bradrem...@gmail.com>] Sent: Tuesday, January 14, 2014 11:22 PM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Migration of Foundation and Historical Data ITSM 7.6 to ITSM 8 - Using Spoon ** Hi All Hope everyone is well. We are busy with our upgrade to ITSM 8 and have setup a completely new environment which will host the Version 8 applications. We are currently running Remedy 7.6 P003 with ITSM 7.6 and SRM 7.6. The new environment has been setup and configured and is working perfectly and we now come to the task of migrating the data from ITSM 7.6 to the new ITSM 8 environment. For now, we are focusing on the foundation data as that is the most important part and I was wondering how everyone who has done this upgrade has managed to move their data over. I was looking at using the spreadsheets, however it is alot of admin work and with any data updates or changes on our currently live 7.6 environment, we would need to make sure that we apply those updates to the version 8 environment. Ideally, we would like a automated solution / scripted solution that we can run which would update the data and keep the new environment in sync. It was suggested by another developer that we look at possibly using the Atrium Integration Spoon application to do this data migration and that we create a transformation job which we can re-run etc. Has anyone done this before? If not, would you please share how your company / project was able to migrate their data? Any assistance would be greatly appreciated. Thanks Brad _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"
Re: Migration of Foundation and Historical Data ITSM 7.6 to ITSM 8 - Using Spoon
Brad, You have multiple options to move data, I would first like to ask a couple questions. Transactional Data - Number of INC, CHG, SRM, PBM, Task. Just ballpark 100K or > million. Volume per month 50K, 100K or >million Number of open tickets INC, CHG, SRM, PBM, Task I have leveraged ARX exports and imports for most of my customers transactional data migrations to 8.1 (1 initial move then multiple Delta moves up to Go Live weekend. Added a handful of cleanup filters and an escalation or two to trigger cleanup. The main cleanup is on open records that need to modified and will trip validation filter errors. Also have added an exclusion to some existing validation filters (ie 'Submit Date' > "01/01/14") (Go Live date 01/01/14 example) Dale Jones DCS Raleigh, NC 919-523-6034 From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] on behalf of BradRemedy [bradrem...@gmail.com] Sent: Tuesday, January 14, 2014 11:22 PM To: arslist@ARSLIST.ORG Subject: Migration of Foundation and Historical Data ITSM 7.6 to ITSM 8 - Using Spoon ** Hi All Hope everyone is well. We are busy with our upgrade to ITSM 8 and have setup a completely new environment which will host the Version 8 applications. We are currently running Remedy 7.6 P003 with ITSM 7.6 and SRM 7.6. The new environment has been setup and configured and is working perfectly and we now come to the task of migrating the data from ITSM 7.6 to the new ITSM 8 environment. For now, we are focusing on the foundation data as that is the most important part and I was wondering how everyone who has done this upgrade has managed to move their data over. I was looking at using the spreadsheets, however it is alot of admin work and with any data updates or changes on our currently live 7.6 environment, we would need to make sure that we apply those updates to the version 8 environment. Ideally, we would like a automated solution / scripted solution that we can run which would update the data and keep the new environment in sync. It was suggested by another developer that we look at possibly using the Atrium Integration Spoon application to do this data migration and that we create a transformation job which we can re-run etc. Has anyone done this before? If not, would you please share how your company / project was able to migrate their data? Any assistance would be greatly appreciated. Thanks Brad _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: Adding fields to incident form causes scroll issues
Tim, If memory serves me correct, there are multiple Panels there on top of each other. Kind of a pain. You have to move the top panel to get to the panel under it. Leverage the Outline + and - in Dev Studio. Work flow hides and unhides these panels. Dale Jones DCS Raleigh, NC 919-523-6034 From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] on behalf of Timothy Powell [timothy.pow...@pbs-consulting.com] Sent: Monday, December 09, 2013 11:44 AM To: arslist@ARSLIST.ORG Subject: Re: Adding fields to incident form causes scroll issues ** BUT…… This did lead me down another branch of the path you started me on, where I think I have found the problem. It’s not the size of the HPD:Help Desk form that’s causing the issue. I think it’s the size of the panel and related view field on the SHR:Landing Console. Playing with that now, but so far my experiments show me that’s where the issue lies. Thanks! From: Timothy Powell [mailto:timothy.pow...@pbs-consulting.com] Sent: Monday, December 09, 2013 10:32 AM To: 'arslist@ARSLIST.ORG' Subject: RE: Adding fields to incident form causes scroll issues I did check that. The form is sized ok. When I view it in "Show Actual View Size" mode, the 3 fields that get covered are visible and the buttons (z2PH_FormControlHolder) are below the fields. But thanks for the thought. Tim From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Brian Goralczyk Sent: Monday, December 09, 2013 10:15 AM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Re: Adding fields to incident form causes scroll issues ** Is it possible that you need to change the size of the form? Have you tried verifying that it is big enough at least? With the form open in DS hit ctrl+alt+m or go to the Layout menu and choose "Show Actual View Size" and make sure that size is properly sized. I figure it can't hurt to check. HTH, Brian Goralczyk On Mon, Dec 9, 2013 at 8:27 AM, Timothy Powell mailto:timothy.pow...@pbs-consulting.com>> wrote: I'm still stuck. It's probably a "has it got gas in it" problem, but I can't see it. Any help is appreciated. Thanks, Tim -Original Message- From: Timothy Powell [mailto:timothy.pow...@pbs-consulting.com<mailto:timothy.pow...@pbs-consulting.com>] Sent: Friday, December 06, 2013 11:17 AM To: 'arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>' Subject: Adding fields to incident form causes scroll issues I searched this year's posting for this issue and not finding anything, I am posting my issue. Environment: ARS 7.6.04 SP4 ITSM 7.6.04 SP2 Mid-Tier 7.6.04 SP4 Description: I have a requirement to modify HPD:Help Desk to: Add a row to the Template and Summary fields (from 1 row to 2 rows of display). Add 3 fields to the Incident details area as well. Steps taken: I opened Dev Studio and one-by-one, enlarged (in height) the various panel holders and panels in the following order. z2PLH_ConsoleFlashBoards z2PL_Console z2PLH_Details z2PL_Main Body After each one, I flushed the cache, and tested the view. The maximized mid-tier screen looked good and the reduced sized screen allowed for proper scrolling that let me see all the fields in the view properly and the z2PH_FormControlHolder which contains all the buttons, floated properly to stay below all the visible fields as I tested various sized reduced screens. Next: I enlarged the z2PH_IncidentInformation panel and I added the rows to Template and Summary and added the 3 fields to that panel. I moved the z2PL_Assignment and z2PH_AdditionalIncidentInformation panels down to accommodate the new size of the z2PH_IncidentInformation panel. The relocated panels were within the resized panel holders and panels described in Steps taken. Saved form Flushed MT cache. Open in browser. Maximized window looks fine. BUT NOW if I reduce the screen down the scroll bars appears but it stops "adjusting" and blocks the last 3 fields in the z2PH_AdditionalIncidentInformation panel. This also occurs in search mode when there is a results list. So it appears that something is not allowing the z2PH_FormControlHolder to move below point x OR something is prohibiting on of the panels from expanding past that point. Anybody have a clue as to what I need to look for here? Thanks. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org<http://www.arslist.org> "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"
Re: Update Demo user password: Arcache utility
This adds an Admin (TEMPADMIN) with no password. If you needed a password because of Authentication of Blank pwd setting, just add pwd in the -p "newpassword" arcache -Ua -eTEMP999 -lw 1 -n "TEMPADMIN" -p"" -s servername -g "1;" Log in with new User Admin and change the Demo password via the User Form. Dale Jones DCS Raleigh, NC 919-523-6034 From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] on behalf of pankaj [pankaj.salpe...@vyomlabs.com] Sent: Wednesday, November 20, 2013 11:43 AM To: arslist@ARSLIST.ORG Subject: Update Demo user password: Arcache utility ** Hello, Need to update the Demo user password using arcache utility. Can you please let me know the command. Regards, Pankaj. _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: MAX attachemnt size
Andres, I usually set the max Attachment size to the same as the customers email system limit. I have seen it anywhere from 10 to 40Meg. Create a process for anything bigger then the limit. In Work Log Attach a link to the file on a FTP server or in SharePoint. Take Care Dale Jones DCS Raleigh, NC 919-523-6034 From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] on behalf of andres tamayo [cycom...@gmail.com] Sent: Monday, September 16, 2013 11:49 AM To: arslist@ARSLIST.ORG Subject: MAX attachemnt size ** Hi all. i have a question about maximum recommended attachment size for remedy I'm always work with a maximum recommendation of 5MB which i configure i the AR server configuration options. for some reasons there are needs to work with big size files sometimes up to 30Mb, so i have my limit set to 0 looking through the midtier log i'm seeing many errors related to the attachservlet and i'm thinking it is because the file size. apparently this is causing performance issues to clients trying to work through web. i already change permgen size to 512m and have my heap size set to 2048. any other recommendation about this subject thanks _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: Permissions Question/Problem
Also the message You do not have write access to this record. : > 7 Means that 'Status' (C7) field does not have modify permission of "Submitter" or your ID was not set to the Submitter field on Create (Default on Submitter should be $USER$ or you add $USER$ in the original create. Dale Jones DCS Raleigh, NC 919-523-6034 From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] on behalf of Longwing, Lj [llongw...@usgs.gov] Sent: Tuesday, September 10, 2013 2:13 PM To: arslist@ARSLIST.ORG Subject: Re: Permissions Question/Problem ** Russ, As Frederick says, the fields need to have Submitter Change permissions. The setting of 'Allow any user to submit' is extremely confusing, but it shouldn't be. That setting simply means that you don't need to be a member of a group with 'change' permission to be able to submit the record...you don't even need a write license to be able to write to the field on submit...but it has NOTHING to do with ability to MODIFY the record once submitted. That requires that you be in Submitter Mode Locked (which you are), that the user in question's name must be the value in field id 2, and the Submitter permission must be assigned with Change permissions. And as Misi said, it should work the same way in both clients...so you may be dealing with either a server or client side cache issue. On Tue, Sep 10, 2013 at 12:10 PM, Grooms, Frederick W mailto:frederick.w.gro...@xo.com>> wrote: ** Do the fields on the “Cart” form have Submitter Write permissions? Fred From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>] On Behalf Of rdg em Sent: Tuesday, September 10, 2013 1:04 PM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Permissions Question/Problem ** ARS 8.1/OS=Windows Server/Custom App I have a form which is used to create user request, "Allow Any User To Submit" = Yes, since users will typically not have a license (Submitter Mode = Locked). The application has a read only form(control panel) which is used to create the user request. The user request are created from a list in a table field and move to "Cart" which is just an adjacent table field. Multiple request can be moved to the cart. This is my problem, once the user has added the needed request, I have workflow (AL guide/loop) which goes through the table, changing the status of the request so they can be approved. When I execute the ALs I get an error: You do not have write license (ARERR 8932) You do not have write access to this record. : 7 (ARERR 331) Although if I log into ARS using thick client with the same user(no license) I'm able to modify the record, executing status change with no problems/errors. I'm now confused why my workflow (Active Links) error out but doing the changes manually apart from workflow does not error. This seems very easy and straight forward - I've created many apps in the past that do similar functions. Any suggestions for correcting this problem would be very much appreciated. This is the first app I've built since a recent upgrade from 7.4 to 8.1, there are many small changes that have caused me to relearn a few things. I'm hoping this is another case of something new but maybe I'm just missing something obvious. Thank you, Russ _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: HostID for ITSM preconfigured stack install?
Chad, The Remedy License Host ID has always been the NIC (MAC) address of the machine the ARServer is installed on. All Platforms. If your NIC card needs to be changed or your VM is build with a different NIC, then the ARS server will need a new license key. Take Care Dale Jones DCS Raleigh, NC 919-523-6034 From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] on behalf of Chad Wilhelm [chad.wilh...@caretech.com] Sent: Tuesday, September 10, 2013 9:57 AM To: arslist@ARSLIST.ORG Subject: Re: HostID for ITSM preconfigured stack install? ** Is this true in a Windows VM environment? Thank You, Chad Wilhelm CareTech Solutions Office: (248) 823-0177 [Description: cid:image001.gif@01CDCBC5.16E98150]<http://www.caretech.com/> Helping extraordinary people do extraordinary things Best in KLAS Partial IT Outsourcing 2012 Extensive IT Outsourcing 2008, 2009, 2010 and 2011 Best in KLAS Awards: Software & Services www.KLASresearch.com<http://www.klasresearch.com/> [Description: Description: KLAS_2013] From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Andrew Hicox Sent: Tuesday, September 10, 2013 9:44 AM To: arslist@ARSLIST.ORG Subject: Re: HostID for ITSM preconfigured stack install? ** HAHH! I can't believe I never noticed this before. Sure enough, it IS is the MAC addy of the primary network card on Linux. Thanks a ton, everyone! -Andy On Sep 10, 2013, at 8:40 AM, Dale Jones mailto:d...@dcshq.com>> wrote: ** Carl, Lynix ifconfig | grep HWaddr [root@Server503 logs]# ifconfig | grep HWaddr eth0 Link encap:Ethernet HWaddr 00:50:56:8E:6D:1A Remove : or -'s Host ID will 0050568e6d1a Take Care Dale Jones DCS Raleigh, NC 919-523-6034 From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>] on behalf of Longwing, Lj [llongw...@usgs.gov<mailto:llongw...@usgs.gov>] Sent: Tuesday, September 10, 2013 9:35 AM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Re: HostID for ITSM preconfigured stack install? ** Carl, I know that's true in Windows...but I seem to remember it being different in some os's...particularly Solaris...but I'm unsure about Linux On Tue, Sep 10, 2013 at 7:30 AM, Carl Wilson mailto:carlbwil...@gmail.com>> wrote: ** Hi, The Host ID is the MAC Address of the main network card in the target system (minus any "-" separators). Kind Regards, Carl Wilson http://www.missingpiecessoftware.com/ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>] On Behalf Of Andrew Hicox Sent: 10 September 2013 14:28 To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: HostID for ITSM preconfigured stack install? ** Everyone, I apologize in advance, this may be a dumb question that's answered in the install docs, but dang if I can find it this morning. The long and short of it: I want to set up a quick ITSM install and poke around / evaluate / get an idea what I'm in for. I've downloaded BMCRemedyITSMSuitePreconfiguredStack8.1.00.Linux.tar.gz, which just appears to be an ARServer/Midtier plus all the ITSM bits. Cool. So I set up a DB, set up a VM make sure it's got all the Linux bits that it needs and plenty of disk space, fire up the installer, and it asks for a license key. Presumably because there is so much data in the ITSM install, it violates the "no more than 10k records" condition of a demo-licensed arserver. Cool, cool. I can go get an eval license off the BMC site. But I need the Host-ID. The only place I know to get the Host-ID is off the arserver license dialog. Which I don't have. Because I don't have an arserver yet! And while I could go on … install the arserver, get the hostID, go get my eval license, then come back and install the rest of ITSM, it seems like it'd be awful nice to be able to use this all-in-one installer and get it over with all in one go. Does anyone know a way to get the host-id off a system before you put up an arserver? thanks, -Andy _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_ _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" <><>
Re: HostID for ITSM preconfigured stack install?
Carl, Lynix ifconfig | grep HWaddr [root@Server503 logs]# ifconfig | grep HWaddr eth0 Link encap:Ethernet HWaddr 00:50:56:8E:6D:1A Remove : or -'s Host ID will 0050568e6d1a Take Care Dale Jones DCS Raleigh, NC 919-523-6034 From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] on behalf of Longwing, Lj [llongw...@usgs.gov] Sent: Tuesday, September 10, 2013 9:35 AM To: arslist@ARSLIST.ORG Subject: Re: HostID for ITSM preconfigured stack install? ** Carl, I know that's true in Windows...but I seem to remember it being different in some os's...particularly Solaris...but I'm unsure about Linux On Tue, Sep 10, 2013 at 7:30 AM, Carl Wilson mailto:carlbwil...@gmail.com>> wrote: ** Hi, The Host ID is the MAC Address of the main network card in the target system (minus any "-" separators). Kind Regards, Carl Wilson http://www.missingpiecessoftware.com/ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>] On Behalf Of Andrew Hicox Sent: 10 September 2013 14:28 To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: HostID for ITSM preconfigured stack install? ** Everyone, I apologize in advance, this may be a dumb question that's answered in the install docs, but dang if I can find it this morning. The long and short of it: I want to set up a quick ITSM install and poke around / evaluate / get an idea what I'm in for. I've downloaded BMCRemedyITSMSuitePreconfiguredStack8.1.00.Linux.tar.gz, which just appears to be an ARServer/Midtier plus all the ITSM bits. Cool. So I set up a DB, set up a VM make sure it's got all the Linux bits that it needs and plenty of disk space, fire up the installer, and it asks for a license key. Presumably because there is so much data in the ITSM install, it violates the "no more than 10k records" condition of a demo-licensed arserver. Cool, cool. I can go get an eval license off the BMC site. But I need the Host-ID. The only place I know to get the Host-ID is off the arserver license dialog. Which I don't have. Because I don't have an arserver yet! And while I could go on … install the arserver, get the hostID, go get my eval license, then come back and install the rest of ITSM, it seems like it'd be awful nice to be able to use this all-in-one installer and get it over with all in one go. Does anyone know a way to get the host-id off a system before you put up an arserver? thanks, -Andy _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"
Re: Looking for Remedy job
I will call you next week. May have something in Atlanta or Nashville will not know until September about Nashville. Sent from my iPhone On Aug 23, 2013, at 6:07 PM, "Gentry, Elmer" mailto:elmer.gen...@hp.com>> wrote: ** Looking for remedy position see resume attached Thanks, Elmo Gentry Remedy Developer HP Enterprise Services Dept of Homeland Security 919.424.5635 _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: The role Jetty plays
High Level - Jetty and Tomcat are comparable applications. (Jetty and Tomcat are often cast as direct competitors.) I have never seen ARS Install Jetty or even attached to Jetty. Most likely related to someone else doing installs or testing on your server. I would recommend ARS to use Tomcat and have Jetty uninstalled. Check directory and see when Jetty was installed, most likely not same date as ARS. Take Care Dale Jones DCS Raleigh, NC 919-523-6034 From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] on behalf of Differ, Alfred W CTR PHD NSWC, 210 [alfred.differ@navy.mil] Sent: Wednesday, July 10, 2013 2:47 PM To: arslist@ARSLIST.ORG Subject: The role Jetty plays Hi all, I'm learning to install the 8.1 ITSM product line on a windows 2008 R2 environment for development uses. I typically get the IIS webserver and Tomcat (7) running independently and then do the Remedy installation steps. I had some issues with the preconfigured suite installer that I won't bother going into in detail, and decided to install the ARS platform and do things the old fashioned way while I learned. What has happened is I have the 8.1 ARS platform installed and it starts ok, but my security guys are reporting security risks against what I've done and I'm trying to learn from it. They are seeing an old version of Jetty that has a known hash collision vulnerability and advising I update it. Since I never saw anything mentioning Jetty during the install, my first task to find out which installer did what. So my questions are as follows: On the application tier, what role does Jetty play if any? What tools make use of this feature? (I might be able to skip installing some parts for now while I learn.) It is possible this has nothing to do with the Remedy installation since my sys admins also do things on the server without 'fully' understanding the implications. I might be barking up the wrong tree. If anyone has any ideas on what the security finding might suggest, though, I'd appreciate it. (CVE-2011-4461) -al ___ 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: Question concerning Attachment Pool field
David, Did you create an overlay for view, each Attachment field , Attachment Pool, the destination Page and Tab? May want to try in Base Mode. May want to try in a Dev Studio version with the same version as Server. (Rule of thumb is newer versions of Dev Studio will try to introduce features that Older Version of ARS server will not be aware of and not know how to handle.) Take Care Dale Jones DCS Raleigh, NC 919-523-6034 From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] on behalf of Shellman, David [dave.shell...@te.com] Sent: Wednesday, May 15, 2013 12:39 PM To: arslist@ARSLIST.ORG Subject: Re: Question concerning Attachment Pool field ** Tried that. You get a message that the form types do not match. Dave On May 15, 2013, at 12:24 PM, "Julie Sellers" mailto:julsell...@yahoo.com>> wrote: ** Dave, When you export a form it creates two items for import, the base form and the overlay (indicated by the form name with a '.o' extension). Could you not export the data, export the form, and then only import the base form (basically deleting the overlay)? Just a thought... From: "Shellman, David" mailto:dave.shell...@te.com>> To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Sent: Wednesday, May 15, 2013 10:57 AM Subject: Re: Question concerning Attachment Pool field ** Mark, If someone could verify it’s a version issue or if it’s an issue that also exists with 7.6.04 that would be great. We went through several discussions with Jason Miller before we upgraded. He was assured by Dev Studio developers that using a newer version is backward compatible. We needed to upgrade to 8.1 to get us out of a corner that we had been painted into with 7.6.04 Dev Studio. 7.6.04 had several shortcomings once an “unmodified” form had an overlay added. Since the forms were home grown from previous versions of the AR System we decided to go to convert them to “custom” forms. 7.6.04 Dev Studio does not have the ability to delete an Overlay which needs to be done before converting. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Brittain, Mark Sent: Wednesday, May 15, 2013 10:19 AM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Re: Question concerning Attachment Pool field ** Hi Dave, The general rule has always been to use the same version of the admin/developer tool as the server version. So there might be something with the 8.1 developer that is not compatible. Mark From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Shellman, David Sent: Wednesday, May 15, 2013 9:51 AM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Question concerning Attachment Pool field ** I’m seeing something odd with Developer Studio. Not sure it’s me or something with Dev Studio. Using 8.1 Dev Studio against a 7.6.04 server (Windows app server running on Oracle). We have a form that has two Attachment Pool fields on the form. I’m attempting to move the fields to a Tab on a page field. Drag and Drop doesn’t seem to allow me to move the fields there. On a regular field, I can right mouse click and use the Move field option. However with an Attachment field, I don’t see that option. I can create a new Attachment pool field on the tab but I can’t seem to move an exist one. Am I missing something obvious? Dave Dave Shellman +1 717 810 3687 tel +1 717 810 2124 fax dave.shell...@te.com<mailto:dave.shell...@te.com> MS 161-043 PO Box 3608 Harrisburg, PA 17105-3608 <http://www.te.com/> <http://twitter.com/teconnectivity><http://www.facebook.com/teconnectivity><http://www.flickr.com/photos/teconnectivity/><http://www.linkedin.com/groups?gid=1591657><http://www.youtube.com/teconnectivity> _ARSlist: "Where the Answers Are" and have been for 20 years_ This E-mail and any of its attachments may contain Time Warner Cable proprietary information, which is privileged, confidential, or subject to copyright belonging to Time Warner Cable. This E-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this E-mail, you are hereby notified that any dissemination, distribution, copying, or action taken in relation to the contents of and attachments to this E-mail is strictly prohibited and may be unlawful. If you have received this E-mail in error, please notify the sender immediately and permanently delete the original and any copy of this E-mail and any printout. _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20
Re: Accounting for timezone differences in notification filters
Yolanda, There is a Time Zone field on the AR System User Preferences form (On Locale Tab). This field is not automatically set and you would need Users to Manually set it or a Process or Custom Code to set it. There is also a Time Zone form that has the Offset seconds to be used in any calculation. Once set, you could update any Date in any Field that would be used by the Notification. Need a Couple Filter Lookups and a Couple additional fields for the Calculations Take Care Dale Jones DCS Raleigh, NC 919-523-6034 From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] on behalf of Rick Westbrock [rwestbr...@qmxs.com] Sent: Monday, May 13, 2013 1:19 PM To: arslist@ARSLIST.ORG Subject: Re: Accounting for timezone differences in notification filters ** Yolanda- You could always modify the notification filter to append the server’s time zone directly after the time field. The users will still need to do the math in their head to get their local time but at least they see the server time zone (which doesn’t have to be named as such) directly in the notification instead of relying on training from you. -Rick ___ Rick Westbrock QMX Support Services From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Longwing, Lj Sent: Monday, May 13, 2013 9:18 AM To: arslist@ARSLIST.ORG Subject: Re: Accounting for timezone differences in notification filters ** Yolanda, I don't believe that Remedy 'stores' the tz difference for a user, so it has no real way to tell what timezone a message should be sent init's translated on the fly via regional settings on the computer when displayed in the browser. I have always just told them what timezone the server is in, and they have always just translated from there. On Mon, May 13, 2013 at 10:15 AM, Yolanda Collier mailto:yolanda.collier@navy.mil>> wrote: The server is in a PST and the majority of the users are on the EST. When notifications are sent out they contain the server time which will be incorrect for our customers outside of PST. For example: Customer East Coast is requesting a meeting at 3 pm. The notification will utilize the server time (which is PST) and show a 3 hour difference and the time will reflect 12 pm. Is there any setting or workflow that can be utilzed to ensure time zone difference is presented in the notification sent by the filter? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org<http://www.arslist.org> "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"
Re: Import without import tool?
Kerry, Another option is via SLQ and Bulk Insert (If someone there has DB skills, a job/script can be scheduled.) You will need a SQL Client on the machine that will run SQL. Recommend a DB user other then ARAdmin * Create Table (Holder Remedy table or DB Table and Create a Remedy View Form against it) * Need a 15 CHAR unique column (SQL can set one) * Use Bulk Insert to import the data * Verify the data * Once data is in a DB Table (Remedy Table or Remedy View Form against DB Table) you can run Remedy Code against it and Push/Pull/Manipulate... (Escalations, Filters) Examples BULK INSERT EmployeeDB.dbo.Employees FROM 'C:\Data\EmployeeData_c.dat' WITH ( DATAFILETYPE = 'char', FIELDTERMINATOR = ',', ROWTERMINATOR = '\r\n' ); OR BULK INSERT mdb_cleanse.dbo.[@repository employee list] FROM ‘C:\Users\djones\Documents\Run Queries\Employee_List.csv’ WITH ( FIELDTERMINATOR = ‘,’, ROWTERMINATOR = ‘\n’ ) Google Bulk Insert for many examples. Take Care Dale Jones DCS Raleigh, NC 919-523-6034 From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] on behalf of Raman Arora [arora.raman8...@gmail.com] Sent: Thursday, March 07, 2013 10:47 AM To: arslist@ARSLIST.ORG Subject: Re: Import without import tool? ** I remember I used to get that done using Command line interfacethere were certain parameters that I used. arimportcmd was the command...I'm sure if you search that, you'll get whet you want. Raman On Thu, Mar 7, 2013 at 8:52 PM, Grooms, Frederick W mailto:frederick.w.gro...@xo.com>> wrote: You should be able to script the rik program (which has to be there as it is used during the install) to do the dataimport Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>] On Behalf Of Kerry Murdock Sent: Thursday, March 07, 2013 8:29 AM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Re: Import without import tool? Arghhh - well it looks like I can't do that because the server doesn't have the import tool installed!!! K Kerry, I have typically written a process that they attach the csv to an attachment field and then I save it to the server and run the import there. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org<http://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: ITSM doesn't display
Mark, Make sure you did not duplicate a Group #. Make sure you did not give a Group # of 0 or 1 to any custom Groups. 0 = Public and 1= Admin Search Group Form and look at Group #s for dups Search Roles Form and look at #s and permissions for State - Production Look for Dups or 0 or 1. If you have db access: Also SQl query the a non admin user in the User Cache and User (T#) Table looking at Groups. To get T# Select schemaId, name form arschema order by name; User Cache is what is cached in to memory. Hope this gets you closer. Dale Jones DCS Raleigh, NC 919-523-6034 From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] on behalf of Brittain, Mark [mbritt...@navisite.com] Sent: Thursday, March 07, 2013 11:39 AM To: arslist@ARSLIST.ORG Subject: Re: ITSM doesn't display ** The only change we have made since it was installed is the Mid-tier 7.6.04 SP3 201301041509 Hotfix and this definitely not a mid-tier issue. This started after I added a support group. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mohammed Khalil (Technosys Limited) Sent: Thursday, March 07, 2013 11:33 AM To: arslist@ARSLIST.ORG Subject: Re: ITSM doesn't display ** Hi Mark, Have any security patches or BMC patches been applied to the server in question? Regards, Khalil M. Khalil Technosys Limited<http://www.linkedin.com/company/technosys-limited> Tel:+44(0)1923437677 Mob: +44(0)7916153032 kha...@technosysuk.com<mailto:kha...@technosysuk.com> www.technosysuk.com<http://www.technosysuk.com/> [cid:image001.gif@01CE1B28.67CCF450] From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Brittain, Mark Sent: 07 March 2013 16:21 To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Re: ITSM doesn't display ** Hi Dale, I checked the state of every application and they are all “Production”. I’m stumped. Mark From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Dale Jones Sent: Wednesday, March 06, 2013 10:48 PM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Re: ITSM doesn't display ** Mark, Sounds like you have somehow switched the Application from Production to Maintenance mode. (Sometimes playing with adding/removing forms from an Application cause dev studio to think for itself). Take a Look in Dev Studio Open Applications Select the Application that is giving you the issue. Select General Field 'State' change to Production or Test These read the permissions from Roles form (Prod or Test permissions) Maintenance locks everyone out except admins Take Care Dale Jones DCS Raleigh, NC 919-523-6034 From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] on behalf of Brittain, Mark [mbritt...@navisite.com] Sent: Wednesday, March 06, 2013 10:37 PM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Re: ITSM doesn't display ** All non-admin users. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of laurent matheo Sent: Wednesday, March 06, 2013 6:16 PM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Re: ITSM doesn't display ** Is this only for one user or all users? Check the record on "User" form for this people. On 06 Mar, 2013,at 09:19 PM, "Brittain, Mark" mailto:mbritt...@navisite.com>> wrote: HI All, This one really has been baffled and after two days with BMC support have not made any progress. Fortunately this is only on my development server. If I log on as a user to the IT Home Page everything is blank except the Applications panel on the left. If I select Incident Management Console nothing shows below the Incident Console title bar. If I select Search Incident, I get the Incident (Search) Title bar, the Search New Search, Searches, etc and below that I only get the blue BMC banner. If I press the Search button I get You have no access to field 1 (ARERR 333). Changes and Problems are the same way. The sample App works fine. If I logon as an AR System Administrator everything works fine. Same thing happens in the client so it is not a mid-tier issue. Has anyone seen this before? Any suggestions where to look for the cause? ARS 7.6.04 SP3 Mid-tier 7.6.04 SP3 201301041509 Hotfix Thanks Mark Mark Brittain Remedy Developer ITILv3 Foundation NaviSite – A Time Warner Cable Company mbritt...@navisite.com<mailto:mbritt...@navisite.com> Office: 315-453-2912 x5335 Mobile: 315-882.5360 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. Distributio
Re: ITSM doesn't display
Mark, Sounds like you have somehow switched the Application from Production to Maintenance mode. (Sometimes playing with adding/removing forms from an Application cause dev studio to think for itself). Take a Look in Dev Studio Open Applications Select the Application that is giving you the issue. Select General Field 'State' change to Production or Test These read the permissions from Roles form (Prod or Test permissions) Maintenance locks everyone out except admins Take Care Dale Jones DCS Raleigh, NC 919-523-6034 From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] on behalf of Brittain, Mark [mbritt...@navisite.com] Sent: Wednesday, March 06, 2013 10:37 PM To: arslist@ARSLIST.ORG Subject: Re: ITSM doesn't display ** All non-admin users. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of laurent matheo Sent: Wednesday, March 06, 2013 6:16 PM To: arslist@ARSLIST.ORG Subject: Re: ITSM doesn't display ** Is this only for one user or all users? Check the record on "User" form for this people. On 06 Mar, 2013,at 09:19 PM, "Brittain, Mark" mailto:mbritt...@navisite.com>> wrote: HI All, This one really has been baffled and after two days with BMC support have not made any progress. Fortunately this is only on my development server. If I log on as a user to the IT Home Page everything is blank except the Applications panel on the left. If I select Incident Management Console nothing shows below the Incident Console title bar. If I select Search Incident, I get the Incident (Search) Title bar, the Search New Search, Searches, etc and below that I only get the blue BMC banner. If I press the Search button I get You have no access to field 1 (ARERR 333). Changes and Problems are the same way. The sample App works fine. If I logon as an AR System Administrator everything works fine. Same thing happens in the client so it is not a mid-tier issue. Has anyone seen this before? Any suggestions where to look for the cause? ARS 7.6.04 SP3 Mid-tier 7.6.04 SP3 201301041509 Hotfix Thanks Mark Mark Brittain Remedy Developer ITILv3 Foundation NaviSite – A Time Warner Cable Company mbritt...@navisite.com<mailto:mbritt...@navisite.com> Office: 315-453-2912 x5335 Mobile: 315-882.5360 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. _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"
Re: Add status reason to "In Progress" status
Ron, The old Active Link values may still be in the Cache. Flush your cache (Mid Tier) and Local Browser cache. Active Links get stored in Mid Tier Cache and local Browser Cache. Take Care Dale Jones DCS Raleigh, NC 919-523-6034 From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] on behalf of Peters, Ron [rpet...@columbia.com] Sent: Thursday, January 03, 2013 11:46 AM To: arslist@ARSLIST.ORG Subject: Add status reason to "In Progress" status ** Hello all, I’ve added the reasons to this status in the status_reason_hidden field and entries to the sys:status reason menu items form. The reasons appear on the HPD:Help Desk screen but when I save an entry, the reason field is blanked out. I looked to see if I could find an active link that’s wiping out the value and I first thought it was HPD:INC:Status_100_ClearReason but even after disabling that object, the entry is still wiped out. I’m not sure where to look now. Any thoughts? Thanks again, Ron _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: 'field' != 'DB.field'
Try 'TR.field' != 'DB.field' AND 'TR.field' != $NULL$ Dale Jones DCS Raleigh, NC 919-523-6034 From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] on behalf of Raj [ravi6...@gmail.com] Sent: Monday, December 03, 2012 7:26 PM To: arslist@ARSLIST.ORG Subject: 'field' != 'DB.field' ** Hi, I have gone through various discussions on 'field' != 'DB.field' on the forum here but still little confused. Currently, we have a code 'field' != 'DB.field' and looks like it tracks all changes to the field. It is even tracking null value change as well. For Example, I am updating Audit log something like "value changed from A to B". But I do see entries of "value changed from to " Would this Run If qual in filter also tracks when a null is pushed to this field from API. My understanding is when a null is pushed, field has a transaction value of null but which is = to DB.field, then why is this filter firing? Did anyone encounter such a case? As I would like to stop logging "value changed from to " in the audit, as it is of no use. Pl advise. Thanks, Raj _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: Time question
Try $TIMESTAMP$ NOTE Business Time commands work only with Date/Time fields (not Date fields or Time fields). Dale Jones DCS Raleigh, NC 919-523-6034 From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] on behalf of Mayfield, Andy L. [almay...@southernco.com] Sent: Thursday, October 27, 2011 2:44 PM To: arslist@ARSLIST.ORG Subject: Re: Time question ** I tried that, but it doesn’t seem to like that either. Using Application-Bus-Time-Diff $TicketAssignedDate$ $DATE$ ["Normal Work Week"] It give an error at position 46. )-: From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Arner, Todd Sent: Thursday, October 27, 2011 1:39 PM To: arslist@ARSLIST.ORG Subject: Re: Time question ** Just a guess but I’d try removing the quotes from the field and keyword references Application-Bus-Time2-Diff $TicketAssignedDate$ $DATE$ ["Normal Work Week"] Todd Arner From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mayfield, Andy L. Sent: Thursday, October 27, 2011 1:25 PM To: arslist@ARSLIST.ORG Subject: Re: Time question ** Can someone help me out with the syntax for the Application-Bus-Time2-Diff command? After reading the “Configuring” manual on page 341 I thought I had it right, but it’s giving my an error at line position 49. Application-Bus-Time2-Diff "$TicketAssignedDate$" "$DATE$" ["Normal Work Week"] From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG]<mailto:[mailto:arslist@ARSLIST.ORG]> On Behalf Of White, Michael W (Mike) Sent: Thursday, October 27, 2011 11:39 AM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Re: Time question ** You can use built-in process Application-Bus-Time-Diff to return the number of seconds between two dates excluding weekends/holidays. Need records in Business Time Holidays and Business Time Workdays, two forms Remedy provides with ARS. Each handles multiple records – different kinds of work schedules, different kinds of holiday schedules (including no holidays if that’s what you’re after). Mike White EMail michael.wh...@verizon.com<mailto:michael.wh...@verizon.com> Office 813.978.2192 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG]<mailto:[mailto:arslist@ARSLIST.ORG]> On Behalf Of Mayfield, Andy L. Sent: Thursday, October 27, 2011 12:19 PM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Time question ** I’m trying to count the number of weekdays between two dates. Is there a way to easily do this? I’ve used DATEDIFF in the past, but it counts every day and not just the week days. Thanks, Andy L. Mayfield Alabama Power Company Protection & Control Technician Sr. Linc # 10*19140 Cell # 205-288-9140 Office # 205-226-1805 _attend WWRUG12 www.wwrug.com<http://www.wwrug.com> ARSlist: "Where the Answers Are"_ _attend WWRUG12 www.wwrug.com<http://www.wwrug.com> ARSlist: "Where the Answers Are"_ _attend WWRUG12 www.wwrug.com<http://www.wwrug.com> ARSlist: "Where the Answers Are"_ The information contained in this communication may be confidential, is intended only for the use of the recipient(s) named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication, or any of its contents, is strictly prohibited. If you have received this communication in error, please notify the sender immediately and destroy or delete the original message and any copy of it from your computer system. If you have any questions concerning this message, please contact the 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"
Re: Has anyone got Tasks working in ITSM 7.6 Patch 001 - Service Desk Module
Terry, The issues below have been fixed and addressed. Defect Summary - Task is opened in background when the selected Task is Double clicked on (Issue is found the Task or Child or Task Group tables.) SW00357475 fixes this issue. This Incident/Task integration code was fixed in 7.6.03. This code is in our code line moving forward. You can call support and request this hotfix (2 Active Links). The other reported issue is As Design: Tasks are created in a "Staged" status. When an Incident is moved to "In Progress" the Task is Activated. Shane's ARSList response is correct "This is part of the design to enforce the proper workflow so that tasks are not started before the system recognizes that work has begun on the Incident." I hope this helps. Take Care Dale Jones BMC Software, INC. Product Developer Raleigh, NC From: Action Request System discussion list(ARSList) [arsl...@arslist.org] on behalf of Terry Bootsma [tboot...@objectpath.com] Sent: Thursday, September 23, 2010 1:52 PM To: arslist@ARSLIST.ORG Subject: Re: Has anyone got Tasks working in ITSM 7.6 Patch 001 - Service Desk Module ** Thanks for your update Shane... Terry On Sep 23, 2010, Shane Buchholz wrote: We experienced both of these issues when we implemented as well. a) I don’t know if a bug has been reported on this particular issue, but the behavior is different depending on how you access the task. a. If you double click on the task it opens behind the dialogue window. b. If you select the task and click on View it will open correctly b) All tasks start off in the Staged status if the incident has not been put into at least the In Progress status. Once the incident is changed to In Progress or Pending then the task will move out of staged and into Pending or Assigned. I believe this is part of the design to enforce the proper workflow so that tasks are not started before the system recognizes that work has begun on the Incident. I hope that helps a little. Thanks, Shane Buchholz Systems Analyst II - Remedy Information Services Operations Samaritan Health Services From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Terry Bootsma Sent: Thursday, September 23, 2010 7:49 AM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Has anyone got Tasks working in ITSM 7.6 Patch 001 - Service Desk Module ** Hi everyone: Send<http://driver?nimlet=showcanvas> I am wondering if anyone else is having difficulty with the OOB Task implementation within Service Desk ITSM 7.6 Patch 001 (Windows). We are upgrading from 7.1 to 7.6 and one of the features that we use is the Task features associated with Incident Management. However, the 7.6 OOB implementation of tasks when it comes to Incidents is very buggy. Things like: (a) Modal dialog boxes bringing up task details "in behind" the modal dialog box, making it impossible to update the task without closing the dialog box. (b) All tasks (ad-hoc, task template, and task group template) coming up in the "Staged" status and not allowing you to move it out of this status. I'd be interested in hearing if anyone else is having this issue, and if so, what you did to get around this... Thanks.. Terry _attend WWRUG10 www.wwrug.com<http://www.wwrug.com> ARSlist: "Where the Answers Are"_ Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
Re: Just found - will bring to WWRUG
Phil, Since the WWRUG is in Vegas.. Can you beat a hand with Remedy software that comes on a Floppy? I raise you * a 2.1 User and Admin on floppy * and an 1.1.4 Flashboard User and Admin tool on Floppy. Maybe I can Doug to sign them. Take Care Dale Jones DCS Raleigh, NC 919-523-6034 From: Action Request System discussion list(ARSList) [arsl...@arslist.org] on behalf of Herb Partlow [h...@ibtcinc.com] Sent: Tuesday, September 14, 2010 7:50 PM To: arslist@ARSLIST.ORG Subject: Re: Just found - will bring to WWRUG ** I bet Mr phil b does or as least the Remedy Diva. But the real money would be on MR REMEDY.Doug M. :) Herb Partlow IB Technical Consulting O- 408.253.0344 F - 408.253.0344 C - 408.309.5316 "Sent from iPhone" On Sep 14, 2010, at 3:30 PM, John Sundberg mailto:john.sundb...@kineticdata.com>> wrote: ** <http://skitch.com/johnsundberg/dss4u/sbizhub10091417400.pdf-1-page>http://skitch.com/johnsundberg/dss4u/sbizhub10091417400.pdf-1-page Does anybody have an older version? -John -- John Sundberg Kinetic Data, Inc. "Building a Better Service Experience" Recipient of the WWRUG09 Innovator of the Year Award <mailto:john.sundb...@kineticdata.com>john.sundb...@kineticdata.com<mailto:john.sundb...@kineticdata.com> 651.556.0930 I www.kineticdata.com<http://www.kineticdata.com/> _attend WWRUG10 www.wwrug.com<http://www.wwrug.com> ARSlist: "Where the Answers Are"_ _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
Re: Integration of Midtier 7.1 with Crystal Report server XI
Salma,
I had the same issue. The Tomcat shutdown port need to be different values.
What you need to do is install CRXI with Tomcat and set Port to 8081, shut down
port 8006.
The Mid Tier does not give you the option to set the shut down port and it is
defaulted to 8005 (this causes the first install of Tomcat with CRXI to stop
working)
Take Care
Dale Jones
DCS
d...@dcshq.com
http://www.dcshq.com/
Remedy Consulting
Raleigh, NC
919-523-6034
From: Salma Begum
Sent: Thu 3/12/2009 2:24 AM
To: arslist@ARSLIST.ORG
Subject: Re: Integration of Midtier 7.1 with Crystal Report server XI
Hi Joe ,
Thanks for the reply. Yes i installed crystal report server XI on the same
machine where midtier and ARS is installed. Later i installed midtier as
well and gave crystal report path during midtier installtion . I did all
the configuration mentioned in Midtier PDF.
But its not working .. Crystal reports will stop working after midtier is
installed. Can i use 2 different versions of Tomcat on same server . Because
crystal report uses Tomcat 5.0.27 and it installs tomcat while installing
crystal report . I cant use this same tomcat server for midtier as it is not
able to detect . so i installed one more Tomcat server 5.5 and did midtier
installation. later after completion of midtier i did all configuration
mentioned in pdf and found that i m not able to Launch crystal report
('Central Management Console').
Please suggest , if i installed crystal report on same server will it work .
or should i installed midtier and crystal on two different server to avoid
web server conflicts.
Regards,
Salma
Joe DeSouza wrote:
>
> Did you install the Crystal Reports server and provide that information
> where required in the Mid-Tier configuration???
>
> Joe
>
>
>
>
>
> From: Salma Begum
> To: arslist@ARSLIST.ORG
> Sent: Thursday, March 12, 2009 1:47:17 AM
> Subject: Integration of Midtier 7.1 with Crystal Report server XI
>
> Hi Team,
>
>
> I m planning to integrate Midtier with Crystal report server XI for web
> reporting . Has anyone done this kind of integration,
>
>
> If yes, could someone guide me on how to proceed further.
>
>
> Regards,
>
> Salma
>
>
>
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
>
:-((
--
View this message in context:
http://n2.nabble.com/Integration-of--Midtier-7.1-with-Crystal-Report-server-XI-tp2465742p2465836.html
Sent from the ARS (Action Request System) mailing list archive at Nabble.com.
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
Re: Date/Time field in Table Qualification
Add an Active Link - If Dates are Null then set the dates to > "01/01/1970" May need a hidden date field to make this look pretty. Dale Jones DCS [EMAIL PROTECTED] http://www.dcshq.com/ Remedy Consulting Raleigh, NC 919-523-6034 From: Sergio Tomillero Sent: Fri 11/14/2008 6:36 AM To: arslist@ARSLIST.ORG Subject: Date/Time field in Table Qualification Hello people, I am trying to indicate a qualification in a table field, limiting the result at the value of two Date/Time fields. The problem is if I do not indicate any value in the date/time fields, the ARERR [313] error appears, with the next message: 'Data types are not appropiate for relational operations'. I have realized that Date/Time fields do not let to compare their value with NULL in Table fields Qualification, neither with "". Any idea? Thanks in advance, Sergio Tomillero -- View this message in context: http://www.nabble.com/Date-Time-field-in-Table-Qualification-tp20498771p20498771.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
