Re: Stoopid Parenthesis
** 'sokay, Lisa, those two statements are logically equivalent. ~james -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa Sent: Friday, May 30, 2008 8:36 AM To: arslist@ARSLIST.ORG Subject: Stoopid Parenthesis ** I forget how to force extra Parenthesis when I need them in the Qualification area on a table field... I would like it to look like this: ( 'Survey Type' = $Survey Type$) AND (( 'Create Date' = $Result From Date$) AND ( 'Create Date' $Result To Date$)) But when I save the form, Remedy changes it to: ( 'Survey Type' = $Survey Type$) AND ( 'Create Date' = $Result From Date$) AND ( 'Create Date' $Result To Date$) ARS 7.0.1 Patch 007 (admin) Server 7.0.1 Patch 003 Windows 2003 Lisa Kemes AR System Developer Tyco Electronics 717-810-2408 tel 717-810-2124 fax [EMAIL PROTECTED] __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Mid-tier and internal network
** Is having another web server to service off-campus requests out of the question? That seems like the best idea, so far as DMZs and making *really* sure that your internal services remain that way go. fwiw, ~james -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin Sent: Thursday, May 29, 2008 9:19 AM To: arslist@ARSLIST.ORG Subject: Mid-tier and internal network Dear List, We have a Mid-Tier system on a web server that is accessible only to our university’s internal network. That is, someone from within the University can access the Mid-Tier, but someone outside can’t unless they have a VPN. Unfortunately, we also have numerous regular web pages that we DO want outsiders to be able to access. Has anyone had any experience setting up a web server so that Mid-Tier is only available internally, but regular web pages are available to the world? (Mid-Tier 7.1 patch 2, IIS 6 web server, Windows 2003 machine, Tomcat servlet server)
Re: Populating Table field with sql query result
Hi Ravi; I've not had a reason to do this yet, so I can't offer specifics (happily, there's been lots of good and related information over the last couple of days--and much more earlier, I'm sure). You'll need a view or vendor form set up so that ARS can see the table from the other database--after that, you can probably run queries against the view/vendor form in a similar way. View forms generally require a link specified in ar.cfg with the connection string of the remote DB, and vendor forms require an ARDBC plug-in to use. If you can't get direct access to the remote DB, maybe you can get the other DBA to ship you the data in batches to import (eeew)? Sorry I couldn't be more help, but if you give these grand ARS listers more detail like remote DB type, the access you're likely to have to it, ARS specs...well, all that, I bet they've more clues :) ~james -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ravi Sent: Thursday, May 22, 2008 8:43 PM To: arslist@ARSLIST.ORG Subject: Re: Populating Table field with sql query result James: I have been trying to do something similar. One question. If the table on which I want to run the sql query is on a different database, what do I have to do within Remedy so it can connect to a table in that database. Thanks Ravi Russell, James C wrote: ** Hello Victor; I don't know that this is what you're looking for, but I run a series of sql queries in a single escalation to populate a 'current state' kinda form--I'm using one query per field; might not be the most effective way in the world, but it works. This has MS SQL date conversions in--oracle is different and a bit more cryptic (IMO--I've got those around somewhere if you need 'em): Here's a Set Fields example that works just fine: Read Value for Field From: SQL SQL Command: SELECT COUNT(1) FROM Your_Form_Name WHERE (Create_Date = DATEDIFF(s, '19700101', DATEADD(mm,-30,getdate( AND (rb_TicketType = 5) If No Requests Match: Set fields to NULL If Multiple Records Match: Use first matching Fields: Name: cntTiks Value: $1$ ...there's no reason in the world that you couldn't make a set fields with an sql statement like: SELECT thing1, thing2, thing3, ... ,thingN FROM Your_Form WHERE Field_name = 'char_value' OR Field_Name2 84600 (or whatever--could do joins and unions against multiple forms if necessary) ..and then the Names/values in the 'Fields' section of the set fields is like: Name: Field1 Value: $1$ Name: Field2 Value: $2$ Name: Field3 Value: $3$ : : Name: FieldN Value: $N$ When you're choosing a value for the field, the drop-down list will give you an option to choose a value x from the 'SQL Result Column,' where x is a number between 1 and N (the number of fields you're pulling in your select statement). Erm. For whatever it's worth. HTH ~james -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Victor Sent: Sunday, May 18, 2008 12:47 PM To: arslist@ARSLIST.ORG Subject: Populating Table field with sql query result Hello Listers, It is possible to populate a table field with the result from an sql query? Any idea how this could be done? Victor ___ 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 ___ 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
Re: Populating Table field with sql query result
** Hello Victor; I don't know that this is what you're looking for, but I run a series of sql queries in a single escalation to populate a 'current state' kinda form--I'm using one query per field; might not be the most effective way in the world, but it works. This has MS SQL date conversions in--oracle is different and a bit more cryptic (IMO--I've got those around somewhere if you need 'em): Here's a Set Fields example that works just fine: Read Value for Field From: SQL SQL Command: SELECT COUNT(1) FROM Your_Form_Name WHERE (Create_Date = DATEDIFF(s, '19700101', DATEADD(mm,-30,getdate( AND (rb_TicketType = 5) If No Requests Match: Set fields to NULL If Multiple Records Match: Use first matching Fields: Name: cntTiks Value: $1$ ...there's no reason in the world that you couldn't make a set fields with an sql statement like: SELECT thing1, thing2, thing3, ... ,thingN FROM Your_Form WHERE Field_name = 'char_value' OR Field_Name2 84600 (or whatever--could do joins and unions against multiple forms if necessary) ..and then the Names/values in the 'Fields' section of the set fields is like: Name: Field1 Value: $1$ Name: Field2 Value: $2$ Name: Field3 Value: $3$ : : Name: FieldN Value: $N$ When you're choosing a value for the field, the drop-down list will give you an option to choose a value x from the 'SQL Result Column,' where x is a number between 1 and N (the number of fields you're pulling in your select statement). Erm. For whatever it's worth. HTH ~james -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Victor Sent: Sunday, May 18, 2008 12:47 PM To: arslist@ARSLIST.ORG Subject: Populating Table field with sql query result Hello Listers, It is possible to populate a table field with the result from an sql query? Any idea how this could be done? Victor ___ 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
Performance Encryption, the Requester Console, and ARERR 8939
** Hello List! This one is a stumper, so far--perhaps some of you grand folks have a clue (all the ones we've found have added up NULL). ARS7.1 ITSM 7.0.03 SQL 2005 Win 2003 We installed the 'performance encryption' package, and the plugin server--as far as the requester console is concerned (specifically RQC:ServiceRequestWizard)--returns an error, and never processes the request: --- The AR System Plug-In server is not responding. Cannot connect to the system at this time. Contact your AR System Administrator for assistance (ARERR 8939) --- The plugin server is running, AREA and ARDBC LDAP connections work fine (and shows up in the arplugin log); that part isn't bothered by encryption. If we make the encryption optional, then the client connection from user.exe will negotiate encrypted (if the client has been patched for encryption), and the requestor thread (which was NOT able to negotiate encryption for some reason) is not being challenged and is allowed to continue. It appears that something isn't able to negotiate a connection, but it's not clear what's failing, or why--nothing at all crashes, we just get the refused connection, and a lot of nothing useful in either the arsql, arerror, or arplugin logs. It didn't happen with the 56bit encryption that comes with ARS, either, but that's not strong enough for the data we carry and the policies set by our ISO, so... Any clues welcome! Thanks, ~james [] James Russell 512.475.9262 | [] Remedy Development Team 512.475.9400 | [] The University of Texas, ITS | [] [EMAIL PROTECTED] | ~~ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are smime.p7s Description: S/MIME cryptographic signature
Re: Performance Encryption, the Requester Console, and ARERR 8939
** Defect filed for this one: SW00290777 Just wanted to post an FYI, in case anyone was puzzling over it. Thanks! ~james [] James Russell 512.475.9262 | [] Remedy Development Team 512.475.9400 | [] The University of Texas, ITS | [] [EMAIL PROTECTED] | ~~ -Original Message- From: Russell, James C Sent: Tuesday, March 18, 2008 11:59 AM To: 'arslist@arslist.org' Subject: Performance Encryption, the Requester Console, and ARERR 8939 ** Hello List! This one is a stumper, so far--perhaps some of you grand folks have a clue (all the ones we've found have added up NULL). ARS7.1 ITSM 7.0.03 SQL 2005 Win 2003 We installed the 'performance encryption' package, and the plugin server--as far as the requester console is concerned (specifically RQC:ServiceRequestWizard)--returns an error, and never processes the request: --- The AR System Plug-In server is not responding. Cannot connect to the system at this time. Contact your AR System Administrator for assistance (ARERR 8939) --- The plugin server is running, AREA and ARDBC LDAP connections work fine (and shows up in the arplugin log); that part isn't bothered by encryption. If we make the encryption optional, then the client connection from user.exe will negotiate encrypted (if the client has been patched for encryption), and the requestor thread (which was NOT able to negotiate encryption for some reason) is not being challenged and is allowed to continue. It appears that something isn't able to negotiate a connection, but it's not clear what's failing, or why--nothing at all crashes, we just get the refused connection, and a lot of nothing useful in either the arsql, arerror, or arplugin logs. It didn't happen with the 56bit encryption that comes with ARS, either, but that's not strong enough for the data we carry and the policies set by our ISO, so... Any clues welcome! Thanks, ~james [] James Russell 512.475.9262 | [] Remedy Development Team 512.475.9400 | [] The University of Texas, ITS | [] [EMAIL PROTECTED] | ~~ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are smime.p7s Description: S/MIME cryptographic signature
Help zeroing permission/support group data in ARS7.1/ITSM 7.0.02?
Howdy listers! A blown migration between ARS 7.1, ITSM 7.0.02 (Unix/Oracle to Win2003/SQL) servers has caused some interesting company/support group/people permissions errors, and we'd like to zero everything and start over (Re-migrating with Migrator hasn't worked out correctly, and we need to change support company structure, anyway). The problem...there are more background foundation forms for this purpose than any number of sticks may be shaken at, so far as I can tell. Not to mention those concerning assignment, notification, aliases...the list goes on. Have any of you grand folks run across this before? If I had a clean database image to roll back to, that'd be ideal...but we don't have one that contains all the installed applications without some corrupt data in (last time *that* will happen!). We tried zeroing it by poring over forms and deleting what we'd added, but miss a form here or there, and it corrupts subsequent data entry. Just now, we're running across assignment problems--I did find a load of bad/left over data in CTM:People Permission Groups, and am fixing that. Several other forms have already been 'fixed,' like CTM:SYS-Access Permission Grps, and some have good data already, like CTM:Support Group Associations (yet assignment still fails). A small bit of past experience with this already suggests that the problem with assignments and access restrictions aren't going to be fixed with this data update, either..and time is a-tickin'. Any ideas, suggestions, or advice is most welcome--if there are any other details I can supply that would help, I'll be more than happy to. Thank you! ~james [] James C Russell 512.475.9262 | [] Remedy Development Team 512.475.9400 | [] The University of Texas, ITS | [] [EMAIL PROTECTED] | ~~ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are smime.p7s Description: S/MIME cryptographic signature
Re: Help zeroing permission/support group data in ARS7.1/ITSM 7.0.02?
Thanks much! My co-developer found it, and is going through the docs now. We've got enough customizations in place that I'd rather not reinstall ITSM unless necessary...but we've got to upgrade to patch 6 anyway, for the tool to work, so might have to regardless. Definitely will if that tool won't overwrite. Ah, well. Best option found so far, by far; 'fixing' the background data hasn't seemed to go anywhere. Thanks for the undocumented tip, too--definitely worth keeping in mind. Cheers! ~james [] James C Russell 512.475.9262 | [] Remedy Development Team 512.475.9400 | [] The University of Texas, ITS | [] [EMAIL PROTECTED] | ~~ -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of strauss Sent: Wednesday, November 14, 2007 3:14 PM To: arslist@ARSLIST.ORG Subject: Re: Help zeroing permission/support group data in ARS7.1/ITSM 7.0.02? If it is bad enough, maybe you should load up the new data management application (ITSM Patch 9003) and export your data to match the spreadsheets, clean it up in the spreadsheets, then load a new installation of ITSM with it? We are planning to build our production 7 server that way, and will first test it by exporting data from our prototype server and loading it onto a test server to see if it works as advertised. It's brand new, so there will probably be some glitches (like the default client install is useless on a Vista workstation due to directory lock-down and Excel 2007 security), but if you have to start over on foundation data, that is what this tool is supposed to be for. The advantage would be that after you clean the data and load it into a fresh install of ITSM, you should be free of the records that are in error or obsolete that you can't easily remove in the current application. We are abandoning a lot of prototype Company and related data that we decided not to use by doing it this way, without (we hope) having to re-create everything manually. We were going to use the EffectTech solution, but it does not handle Support Staff/groups/permissions (which is most of the work); the new tool from BMC claims to import that data as well. BTW, watch out if you have forms that were part of deployable applications and got lost somehow (I lost some Change Management join forms when uninstalling Approval Server 7.0.01 to install 7.1). They are basically IMPOSSIBLE to replace via either import or Migrator from a system that still has them installed correctly. I am now told that you should NEVER uninstall Approval Server once Change Management has been installed (no, it's not documented anywhere, but they did file a defect for that). If you have any problems with the basic laydown of foundation and application forms, you will need to reinstall - which makes the ability to reload the foundation and support staff data from files extremely valuable. I would rather rebuild from scratch than go live on a system that was covered with band-aids... Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Russell, James C Sent: Wednesday, November 14, 2007 11:37 AM To: arslist@ARSLIST.ORG Subject: Help zeroing permission/support group data in ARS7.1/ITSM 7.0.02? Howdy listers! A blown migration between ARS 7.1, ITSM 7.0.02 (Unix/Oracle to Win2003/SQL) servers has caused some interesting company/support group/people permissions errors, and we'd like to zero everything and start over (Re-migrating with Migrator hasn't worked out correctly, and we need to change support company structure, anyway). The problem...there are more background foundation forms for this purpose than any number of sticks may be shaken at, so far as I can tell. Not to mention those concerning assignment, notification, aliases...the list goes on. Have any of you grand folks run across this before? If I had a clean database image to roll back to, that'd be ideal...but we don't have one that contains all the installed applications without some corrupt data in (last time *that* will happen!). We tried zeroing it by poring over forms and deleting what we'd added, but miss a form here or there, and it corrupts subsequent data entry. Just now, we're running across assignment problems--I did find a load of bad/left over data in CTM:People Permission Groups, and am fixing that. Several other forms have already been 'fixed,' like CTM:SYS-Access Permission Grps, and some have good data already, like CTM:Support Group Associations (yet assignment still fails). A small bit of past experience with this already suggests that the problem
Re: ITSM 7.0 bug.
Oh, great...hope there are more of those out there :/ Have a good evening, man--tomorrow is launch, tweaking, and downright finishing that thing... *wave* ~james __ [] James C. Russell 512.475.9262 | [] SA, ITS User Services 512.475.9400 | [] [EMAIL PROTECTED] | ~~ -Original Message- From: Payne, George Sent: Tuesday, July 31, 2007 4:45 PM To: arslist@ARSLIST.ORG Cc: Rubarth-Lay, James W; Russell, James C Subject: ITSM 7.0 bug. Hey Gang, We're using ITSM 7.0 on ARS 7.0.01 with an Oracle 10g database. Trying to create a new Support Group, I guess I got a little too aggressive with the Description; I typed 141 characters and it threw the error below when I tried to save it. The field properties show it to be a 255 character field on the Support Group form, but the underlying field that the Description is being pushed to by workflow is apparently only 128 characters on the CTM:SYS-Access Permission Grps form. When I trimmed the Description to 128 characters, it saved just fine. --- ARERR [552] Failure during SQL operation to the database : ORA-12899: value too large for column ARADMIN.T567.C10 (actual: 141, maximum: 128) ARERR [306] Value does not fall within the limits specified for the field : (Maximum length- 128) : CTM:SYS-Access Permission Grps : Description --- I didn't see this on the ARSWiki, so I guess I'll turn in a request to support. Gp George Payne Assistant Director, User Services Information Technology Services University of Texas at Austin 512.232.7513 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are smime.p7s Description: S/MIME cryptographic signature
