MSSQL200 Question
Hi, got a Error Message try to login via SQL Analyzer into MSSQL2000 SP4: Login failed for user sa. Reason: not assiosiated with a trusted SQL Server Connection. What did I do wrong? Thx -- Feel free – 10 GB Mailbox, 100 FreeSMS/Monat ... Jetzt GMX TopMail testen: http://www.gmx.net/de/go/topmail ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Business Time with SLA's
I don't know much about SLA since we are just starting working with them. But I'm curious to why support would tell you to set your business hours to 5am to 2 pm when off set works with no issue that we have found. John Atherly American Power Conversion [EMAIL PROTECTED] 401-789-5735 Ext. 2120 1-800-788-2208 Ext. 2120 Jase Brandon [EMAIL PROTECTED] ITA.COM To Sent by: Action arslist@ARSLIST.ORG Request System cc discussion list(ARSList)Subject [EMAIL PROTECTED] Business Time with SLA's ORG 08/07/2006 04:11 PM Please respond to [EMAIL PROTECTED] RG ** Hi listers, I am trying to determine the best way to set up business time for an SLA. My server is on Pacific time and I want to make sure to include our virtual group in Central and Eastern time zones in a 8 to 5 SLA. I know the best way to do this is to have two business time tags with different offset hours, but we all agreed we could live with the hour difference for our intial testing. I called support and they said since my server is on Pacific, the best thing to do is change my business time tag schedule of 8am to 5pm To 5am to 2pm. I thought this was the main reason we had offset hours on a business time tag? Does anybody know of a better way to do this? Thanks in advance! ARS 6.3 patch 18 SQL Server 2000 Jase Brandon Remedy Administration/Development Customer Support Systems Group Desk - (615) - 320-4494 Cell - (334) - 318-5426 [EMAIL PROTECTED] DaVita Inc. __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Asset 6 customizations and CMDB
** Hi Jason, The class manager adds ur field to the BMC:BMC_ComputerSystem_ form. To show iton ur BMC:BMC_ComputerSystem and AST:ComputerSystem forms, you can right click these 2join forms and select the field you want to include. Once it shows up on the AST form, just position it wherever you want. Avoid using the cmdb2asset utility unless you are creating a new class altogether. Regards, Murtuza. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jason MillerSent: Thursday, August 03, 2006 12:56 AMTo: arslist@ARSLIST.ORGSubject: Asset 6 customizations and CMDB ** Hi all,I have CMDB 1.1 and ITSM 6 with Asset Management. I haven't had a chance to go to CMDB training yet so I am learning as I go. Since asset management sits on top of the CMDB are there any issues or gotchas modifying the AST forms directly? For instance I added a new attribute to the Computer System class (Char field) using the class manager (not bad, the only custom data field we needed from AM 4). Now I need the new field to show up on AST:ComputerSystem. Since it is an AM form can I just add it to the AST join form in the admin tool without any problems? Is there any metadata that goes along with the AM module or just CMDB? Is making changes to the AST forms and workflow just like modifying a join form and workflow in the good old days? Deleting the AST form and using the CMDB2Asset utility to recreate it just doesn't give me a warm and fuzzy feeling. As far as I have see so far the AM module is just added functionality to the CMDB but does not affect the CMDB itself (other then the data being stored in the CMDB). Thanks,Jason__20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: MSSQL200 Question
** The server might be configured for Windows Authentication Only.See http://support.microsoft.com/kb/889615/en-us--Michielbtw: nice mail address did you have anything to do with MasterARSuite? On 8/8/06, IT MAsters [EMAIL PROTECTED] wrote: Hi,got a Error Message try to login via SQL Analyzer into MSSQL2000 SP4:Login failed for user sa. Reason: not assiosiated with a trusted SQL Server Connection.What did I do wrong?Thx --Feel free – 10 GB Mailbox, 100 FreeSMS/Monat ...Jetzt GMX TopMail testen: http://www.gmx.net/de/go/topmail___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it___
Re: MSSQL200 Question
Title: RE: MSSQL200 Question ** Michiel: Definately the issue. Once I configured our test database for Windows and Database authentication, this error went away. But on the security side of things, I don't recommend using sa for anything. If you need that level of user, create one in the database with a hard to guess name and password. Disable the sa account if you can. James McKenzie From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Michiel Beijen Sent: Tuesday, August 08, 2006 6:47 AM To: arslist@ARSLIST.ORG Subject: Re: MSSQL200 Question ** The server might be configured for Windows Authentication Only. See http://support.microsoft.com/kb/889615/en-us -- Michiel btw: nice mail address did you have anything to do with MasterARSuite? On 8/8/06, IT MAsters [EMAIL PROTECTED] wrote: Hi, got a Error Message try to login via SQL Analyzer into MSSQL2000 SP4: Login failed for user sa. Reason: not assiosiated with a trusted SQL Server Connection. What did I do wrong? Thx -- Feel free - 10 GB Mailbox, 100 FreeSMS/Monat ... Jetzt GMX TopMail testen: http://www.gmx.net/de/go/topmail ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
JOB- REMEDY DEVELOPER
I have a Remedy development position located in San Diego that has recently opened. I have attached the job description below. If interested in discussing, please send resume to [EMAIL PROTECTED] or call me at 800-330-0309. Job Description: Summary of Job Duties: This position is accountable for development, administration, customization and integration of Remedy Action Request System solutions, with a strong focus on the out-of-the box I.T. Service Management (ITSM) suite (Help Desk, Change Management, and Asset Management). Responsibilities include gathering customer requirements, preparing design specifications documentation, application development, ongoing technical support and system maintenance. This position responds to user requests for data extraction, custom or ad-hoc database reporting or enhancements to system capabilities. And further provides end-user training, and system account administration and maintenance. Minimum Qualifications: The ideal candidate for this position will have a four-year technical degree or equivalent in work experience. Also, a minimum of two years of prior related work experience. The candidate will have an ability to provide positive customer service and advanced communication, problem solving and technical writing skills. Good customer presentation and project management skills are a must. Knowledge of databases, software design, and system administration is required. Previous experience in a technical support environment is required. Technical proficiency in relevant operating systems, applications and programming languages is required (Remedy Action Request System, Mid- Tier, and BMC Remedys ITSM Suite [Help Desk, Asset Management, Change Management]; Microsoft Windows Server; Unix; SQL Server; Oracle). Desired Qualifications: Remedy Approved Consultant (RAC) certification, Remedy Skilled Professional (RSP) certification or other advanced Remedy training classes. Technical proficiency in advanced technologies (Remedy Flashboards, Approval Engine, Service Level Agreements, Web Services and API programming; Unix; Java; C++) An active or recent secret security clearance, or the ability to obtain one. Required Skills: Minimum Qualifications: The ideal candidate for this position will have a four-year technical degree or equivalent in work experience. Also, a minimum of two years of prior related work experience. The candidate will have an ability to provide positive customer service and advanced communication, problem solving and technical writing skills. Good customer presentation and project management skills are a must. Knowledge of databases, software design, and system administration is required. Previous experience in a technical support environment is required. Technical proficiency in relevant operating systems, applications and programming languages is required (Remedy Action Request System, Mid- Tier, and BMC Remedys ITSM Suite [Help Desk, Asset Management, Change Management]; Microsoft Windows Server; Unix; SQL Server; Oracle). ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Windows 2000 and CMDB Performance Issues
Listers, I am creating a CMDB 1.1 Patch 3 with ITSM system. ARS 6.3 ITSM 6.0. We are seeing many serious performance issues and we have not even started any heavy testing. The CMDB times out when trying to do anything with it and we can not hardly even search for a Ticket when an Import is running. A friend mentioned it is because I am running Windows 2000 Server for the application server. Has anyone heard this? If so is there any documentation or specific things you can share about Windows 2000 and CMDB etc... Also has anyone else experienced performance issues like this with CMDB? ARS 6.3, ITSM 6.o, CMDB Patch 3, Application Server=Windows 2000, Database Oracle 10G on a very beefy AIX box. Regards, David Charters 317-331-8985 ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: RUG 2006 schedule is out!
** Well, I'm in. Joe Caropepe will be there, and, introducing the newest member of the SOMAS teamBruce Steinberg! (formerly of Fred Hutchinson). We'll all be there! Get the Beer Cold! On 8/7/06, Rick Cook [EMAIL PROTECTED] wrote: ** Daily schedules are now available, so that you can plan your day(s) there. Looks like some good sessions, but there's probably better info to be gleaned outside of them. I still have to find out if I'll be joining you. What's the count of those going so far? https://www.bmcuserworld.com/catalog/eventguide/publicSchedule.jsp Rick Cook•Remedy Approved Consultant • Denali Advanced Integration • (253) 278-4112 __20060125___This posting was submitted with HTML in it___ -- Warren R. Baltimore IIRemedy DeveloperUW Medicine IT Services School of MedicineUniversity of WashingtonBox 3582201325 Fourth Ave, Suite 2000Seattle, WA 98101The opinions expressed in this e-mail are in no way those of the University of Washington, or the State of Washington.They are my own. __20060125___This posting was submitted with HTML in it___
Re: Windows 2000 and CMDB Performance Issues
Title: RE: Windows 2000 and CMDB Performance Issues ** -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of dcharters Also has anyone else experienced performance issues like this with CMDB? ARS 6.3, ITSM 6.o, CMDB Patch 3, Application Server=Windows 2000, Database Oracle 10G on a very beefy AIX box. What is the connection between these two boxes? I've seen issues with clogged connections between them. Also, what is the version of the Oracle 9iR2 clients? James McKenzie __20060125___This posting was submitted with HTML in it___
Re: RUG 2006 schedule is out!
** Im in. Roger A. Nall OSSNMS Sr. Remedy Administrator/Developer T-Mobile USA Desk: 973-644-3963 Cell: 973-652-6723 FAX: 973-490-3296 sf49fanv AIM IM RogerNall Yahoo IM From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Warren Baltimore Sent: Tuesday, August 08, 2006 10:29 AM To: arslist@ARSLIST.ORG Subject: Re: RUG 2006 schedule is out! ** Well, I'm in. Joe Caropepe will be there, and, introducing the newest member of the SOMAS teamBruce Steinberg! (formerly of Fred Hutchinson). We'll all be there! Get the Beer Cold! On 8/7/06, Rick Cook [EMAIL PROTECTED] wrote: ** Daily schedules are now available, so that you can plan your day(s) there. Looks like some good sessions, but there's probably better info to be gleaned outside of them. I still have to find out if I'll be joining you. What's the count of those going so far? https://www.bmcuserworld.com/catalog/eventguide/publicSchedule.jsp Rick CookRemedy Approved Consultant Denali Advanced Integration (253) 278-4112 __20060125___This posting was submitted with HTML in it___ -- Warren R. Baltimore II Remedy Developer UW Medicine IT Services School of Medicine University of Washington Box 358220 1325 Fourth Ave, Suite 2000 Seattle, WA 98101 The opinions expressed in this e-mail are in no way those of the University of Washington, or the State of Washington.They are my own. __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: RUG 2006 schedule is out!
Shawn; You do not have to register, but they have 2 lines to get in and the registered people go first. So if you want your pick of seats or for busy ones if you want to make it in at all you should register. Bill Clary Remedy Developer, Technology Solutions FTS | Customer Support Center Pierson, Shawn [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] ri... I've never been to one before, do you have to register for the sessions of how does that work? I'm also looking at the pre-conference sessions, in particular the ITIL certification looks like a good idea. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook Sent: Monday, August 07, 2006 3:50 PM To: arslist@ARSLIST.ORG Subject: RUG 2006 schedule is out! ** Daily schedules are now available, so that you can plan your day(s) there. Looks like some good sessions, but there's probably better info to be gleaned outside of them. I still have to find out if I'll be joining you. What's the count of those going so far? https://www.bmcuserworld.com/catalog/eventguide/publicSchedule.jsp Rick Cook * Remedy Approved Consultant * Denali Advanced Integration * (253) 278-4112 __20060125___This posting was submitted with HTML in it___ The information in this e-mail, and any files transmitted with it, is intended for the exclusive use of the recipient(s) to which it is addressed and may contain confidential, proprietary or privileged information. If you are not an intended recipient, you have received this transmission in error and any use, review, dissemination, distribution, printing or copying of this information is strictly prohibited. If you have received this e-mail in error, please notify the sender immediately of the erroneous transmission by reply e-mail, immediately delete this e-mail and all electronic copies of it from your system and destroy any hard copies of it that you may have made. Thank you. ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org -- ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Dynamic Table Field Qualification help
Greetings All, I'm hoping someone can help with a table field qualification problem I've been trying to figure out. Form A has a table field that shows all entries from Form B where 'UserID' on Form A = 'UserID' on Form B. I need to have 3 drop-down menus on Form A that can be used to filter the table. The user should be able to choose a value in any one of these menus to further refine the table field qualification. These menu fields are copies of fields from Form B with an extra option added in the Attributes for Show All. So, if the menu field on Form B has values of 0, 1, and 2, the corresponding menu field on Form A will have values of 0, 1, 2, and 3 with the 3 being Show All. If I use the EXTERNAL feature so that the table qualification is dynamic, what happens if the user doesn't use the menus on Form A, or only chooses a value other than Show All on 1 or 2 of them? For example, I have the following qualification: 'UserID' = $UserID$ AND 'Field1' = EXTERNAL($menu1$) AND 'Field2' = EXTERNAL($menu2$) AND 'Field3' = EXTERNAL($menu3$) However, if the menu on Form A is Show All then I need the qualification to ignore the 'Field' = EXTERNAL($menu$) bit of the qualification so that it brings back all entries regardless of the value of 'Field'. Does this make sense? ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Windows 2000 and CMDB Performance Issues
Title: RE: Windows 2000 and CMDB Performance Issues ** While I am running Windows 2003 on both the application and database with MS SQL 2000 SP4 I did see some issues until I upgraded my network connections to 1GB. After that things were all good. Thanks, Andrew Baxter Manager, Information Technology w. (781) 902-6026 f. (781) 902-6002 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3 Sent: Tuesday, August 08, 2006 10:29 AM To: arslist@ARSLIST.ORG Subject: Re: Windows 2000 and CMDB Performance Issues -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of dcharters Also has anyone else experienced performance issues like this with CMDB? ARS 6.3, ITSM 6.o, CMDB Patch 3, Application Server=Windows 2000, Database Oracle 10G on a very beefy AIX box. What is the connection between these two boxes? I've seen issues with clogged connections between them. Also, what is the version of the Oracle 9iR2 clients? James McKenzie __20060125___This posting was submitted with HTML in it___ This e-mail is sent by Hudson Highland Group, Inc., or one of its subsidiaries, and may contain information that is privileged or confidential. If you are not the intended recipient, please delete the e-mail and any attachments and notify us immediately. __20060125___This posting was submitted with HTML in it___
Re: BMC User World Top Breakout Sessions
As a veteran of a few of these, I've learned that the speaker is as important as the topic. Find a topic that is of interest to you, and then ask around as to whether the speaker is known as a good one or not. Most are at least ok, but some are more engaging than others, and are known for different levels of detail. So, the speaker is important, the topic more so, but the level of detail is what's most important to me. Rick -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jon Chau Sent: Tuesday, August 08, 2006 7:51 AM To: arslist@ARSLIST.ORG Subject: BMC User World Top Breakout Sessions Greetings All, This will be my first BUG/RUG event and I was wondering what is on everyone's list of breakout sessions that are 'must attend' ? There are so many I want to go to, but I am limited with the schedule and number of sessions available per day. Jon Chau ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Recommeded network speeds...
** This is my setup.. Each of these instances reside on seperate boxes. 1.) 2 AR System Servers 2.) Oracle DB server 3.) 3 Web Servers with the mid tier application installed on all of them resolving the load balancer device name to connect to the AR Servers. 4.) Hardware load balancer betweenthe 2 AR System servers. 5.) We have acouple of web services published that would be used by other systems to querya table that has a couple of columns with lenghtof 1024 as of nowbut we might marginally increase it if needed. Information contained in these columns are a concatinated list of regions affected by an outage caused by a network element going down in the cable network. So since these regions could be pretty much undertermined depending on how big the outage is, its hard to say what the lenght of that concatinated list might be but more often then not they would be much less than 255 characters. It might be that one odd occassion when the outage is severe that numerous regions might be affected resulting in a data lenght of about 1024 - I'm hoping that would be a good maximum limit to have rather than keeping it unlimited. Keeping all these in mind, what would be the reccommended network speed I should ask the network guys to build this environment to cater to the above? Joe D'Souza Remedy Developer / Consultant, BearingPoint, Virginia. __20060125___This posting was submitted with HTML in it___
Re: Windows 2000 and CMDB Performance Issues
Title: RE: Windows 2000 and CMDB Performance Issues ** Dave: What version of the 9iR2 clients (5,6,7...) are you using? If you are confused at this point, there were fixes to the clients that may fix the problem you are experiencing right now. James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of dcharters Sent: Tuesday, August 08, 2006 9:06 AM To: arslist@ARSLIST.ORG Subject: Re: Windows 2000 and CMDB Performance Issues 9iR2 and the connection is a Gigabyte with 1 hop On Tue, 8 Aug 2006 07:28:40 -0700, McKenzie, James J C-E LCMC HQISEC/L3 wrote -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of dcharters Also has anyone else experienced performance issues like this with CMDB? ARS 6.3, ITSM 6.o, CMDB Patch 3, Application Server=Windows 2000, Database Oracle 10G on a very beefy AIX box. What is the connection between these two boxes? I've seen issues with clogged connections between them. Also, what is the version of the Oracle 9iR2 clients? James McKenzie __ _ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org -- Open WebMail Project (http://openwebmail.org) ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it___
Re: Dynamic Table Field Qualification help
Kevin,
It makes complete sense. But I think your going about it backwards too. :)
The EXTERNAL() operator could be used like your suggesting, but you
will face the issues that you have. Or your Table qualification has to
know about Select all and opt out that portion of the
qualification. Something like:
'UserID' = $UserID$ AND ('Field1' = EXTERNAL($menu1$) OR $menu1$ = 3)
AND ('Field2' = EXTERNAL($menu2$) OR $menu2$ = 3) AND ('Field3' =
EXTERNAL($menu3$) OR $menu3$ = 3)
However if you ever have to add a new value to one of those menus then
life gets messy because you have to update the table field as well.
In stead of that I would suggestion the following approach.
Add a hidden display only field that you set with the values from the
three fields on menu choice of any of the three fields. ('zTableQual')
So three active links on menu selection for the fields to call this
guide. The guide sets 'zTableQual' based on the values in the three
fields. So the guide logic would be something like the following:
Guide #1: Set zTableQual
'zTableQual' = $NULL$
if ( $menu1$ != $NULL$ AND $menu1$ 3)
'zTableQual' = ( 'Field1' = $menu1$ )
if ( $menu2$ != $NULL$ AND $menu2$ 3)
Call guide #2
'zTableQual' = 'zTableQual'+ ( 'Field2' = $menu1$ )
if ( $menu3$ != $NULL$ AND $menu3$ 3)
Call guide #2
'zTableQual' = 'zTableQual'+ ( 'Field3' = $menu1$ )
Guide #2:
if ( 'zTableQual' != $NULL$ )
'zTableQual' = 'zTableQual'+ ( AND )
Then the table qual would be:
'UserID' = $UserID$ AND EXTERNAL($zTableQual$)
If you logic changes for any of the three fields then just update
Guide1 to do the right thing with the 'zTableQual' string that you
build and your done.
If you even want to allow the user to specify ORs instead of ANDs
you could do that too. (and maybe even get fancy enough to let them
set parenthesees around which parts would be OR'ed and which parts
would be AND'ed. too. :) And the table qual stays the same!
Yea it looks like more work, but you also can choose to avoid OR
conditions which can help with RDBMs performance in the long run.
Just my two cents.
--
Carey Matthew Black
Remedy Skilled Professional (RSP)
ARS = Action Request System(Remedy)
Solution = People + Process + Tools
Fast, Accurate, Cheap Pick two.
Never ascribe to malice, that which can be explained by incompetence.
On 8/8/06, Kevin R. Carmack [EMAIL PROTECTED] wrote:
Greetings All,
I'm hoping someone can help with a table field qualification problem I've
been trying to figure out.
Form A has a table field that shows all entries from Form B where 'UserID'
on Form A = 'UserID' on Form B. I need to have 3 drop-down menus on Form
A that can be used to filter the table. The user should be able to
choose a value in any one of these menus to further refine the table field
qualification.
These menu fields are copies of fields from Form B with an extra option
added in the Attributes for Show All. So, if the menu field on Form B
has values of 0, 1, and 2, the corresponding menu field on Form A will
have values of 0, 1, 2, and 3 with the 3 being Show All.
If I use the EXTERNAL feature so that the table qualification is dynamic,
what happens if the user doesn't use the menus on Form A, or only chooses
a value other than Show All on 1 or 2 of them?
For example, I have the following qualification:
'UserID' = $UserID$ AND 'Field1' = EXTERNAL($menu1$) AND 'Field2' =
EXTERNAL($menu2$) AND 'Field3' = EXTERNAL($menu3$)
However, if the menu on Form A is Show All then I need the qualification
to ignore the 'Field' = EXTERNAL($menu$) bit of the qualification so that
it brings back all entries regardless of the value of 'Field'. Does this
make sense?
___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Enhancement idea: Field Label for fields
** Would have been nice to have field labels having the capacity to use a carriage return within the field name label.. This would mean you could still have a reasonably short label lenght for a field even ifthe label lenght waslong. I tried copying the return character in the hope to see if it works but apparently not... Cheers Joe D'Souza Remedy Developer / Consultant, BearingPoint, Virginia. __20060125___This posting was submitted with HTML in it___
Re: Enhancement idea: Field Label for fields
Joe, I would even be happen with on focus working for Text objects in a search window so that they could simulate what a field label does for the Advanced Search Bar(ASB). (So you could use a Text objects as the label for a field, and leave the field lable blank.) I would prefer a special field for all fields to let the admin specify what the ASB string should be so that we do not need to build active links per field, but I would take what I could get. :) [basic logic: if field's ASB value is null then do what it does now, if ( not null) then use that string/keyword/field reference? instead of what it does now keyword $ NULL $ would result in a no change on the ASB. ] -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. Never ascribe to malice, that which can be explained by incompetence. On 8/8/06, Joe DeSouza [EMAIL PROTECTED] wrote: ** Would have been nice to have field labels having the capacity to use a carriage return within the field name label.. This would mean you could still have a reasonably short label lenght for a field even if the label lenght was long. I tried copying the return character in the hope to see if it works but apparently not... Cheers Joe D'Souza Remedy Developer / Consultant, BearingPoint, Virginia. __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Recommeded network speeds...
** Hey James, All the components exist in a internal network - though they will be using this applicationover VPN from the outside world. So our aim is more to optimize the network speed internally between lets say the AR Server and the database, or the load balancer and the AR Servers, orbetween the Mid-tier and the load balancer and the AR Server and the database.. All these network pipelines basically. We are investing in new hardware so budgetsshouldn't be that much of a constraint.. Cheers Joe D'Souza Remedy Developer / Consultant, BearingPoint, Virginia. - Original Message From: "McKenzie, James J C-E LCMC HQISEC/L3" [EMAIL PROTECTED]To: arslist@ARSLIST.ORGSent: Tuesday, August 8, 2006 11:19:08 AMSubject: Re: Recommeded network speeds...** Joe: Internal or external? James Mckenzie From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe DeSouza Sent: Tuesday, August 08, 2006 8:10 AM To: arslist@ARSLIST.ORG Subject: Recommeded network speeds... ** This is my setup.. Each of these instances reside on seperate boxes. 1.) 2 AR System Servers 2.) Oracle DB server 3.) 3 Web Servers with the mid tier application installed on all of them resolving the load balancer device name to connect to the AR Servers. 4.) Hardware load balancer between the 2 AR System servers. 5.) We have a couple of web services published that would be used by other systems to query a table that has a couple of columns with lenght of 1024 as of now but we might marginally increase it if needed. Information contained in these columns are a concatinated list of regions affected by an outage caused by a network element going down in the cable network. So since these regions could be pretty much undertermined depending on how big the outage is, its hard to say what the lenght of that concatinated list might be but more often then not they would be much less than 255 characters. It might be that one odd occassion when the outage is severe that numerous regions might be affected resulting in a data lenght of about 1024 - I'm hoping that would be a good maximum limit to have rather than keeping it unlimited. Keeping all these in mind, what would be the reccommended network speed I should ask the network guys to build this environment to cater to the above? Joe D'Souza __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: Enhancement idea: Field Label for fields
** Done that before but thattakes the functionality of clicking on the text field to return the field name on the Advanced SearchBar.. So a workaround yes but it doesn't retain the original functionality... Cheers Joe D'Souza Remedy Developer / Consultant, BearingPoint, Virginia. - Original Message From: John Atherly [EMAIL PROTECTED]To: arslist@ARSLIST.ORGSent: Tuesday, August 8, 2006 11:34:53 AMSubject: Re: Enhancement idea: Field Label for fields Add a text field next to the field name.John AtherlyAmerican Power Conversion[EMAIL PROTECTED]401-789-5735 Ext. 21201-800-788-2208 Ext. 2120 Joe DeSouza [EMAIL PROTECTED] .COMTo Sent by: "Actionarslist@ARSLIST.ORG Request System cc discussion list(ARSList)"Subject [EMAIL PROTECTED] Enhancement idea: Field Label for ORGfields 08/08/2006 11:26 AM Please respond to [EMAIL PROTECTED] RG **Would have been nice to have field labels having the capacity to use acarriage return within the field name label.. This would mean you couldstill have a reasonably short label lenght for a field even if the labellenght was long.I tried copying the return character in the hope to see if it works butapparently not...CheersJoe D'SouzaRemedy Developer / Consultant,BearingPoint,Virginia.__20060125___This posting was submitted with HTML init__UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it___
Re: Recommeded network speeds...
Title: RE: Recommeded network speeds... ** Joe: Gig-E or higher then between the various components connected to a high-speed switch. Add a hardware firewall between the VPN and the Mid-Tier server to keep unwanted traffic out. James McKenzie From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe DeSouza Sent: Tuesday, August 08, 2006 9:33 AM To: arslist@ARSLIST.ORG Subject: Re: Recommeded network speeds... ** Hey James, All the components exist in a internal network - though they will be using this application over VPN from the outside world. So our aim is more to optimize the network speed internally between lets say the AR Server and the database, or the load balancer and the AR Servers, or between the Mid-tier and the load balancer and the AR Server and the database.. All these network pipelines basically. We are investing in new hardware so budgets shouldn't be that much of a constraint.. Cheers Joe D'Souza Remedy Developer / Consultant, BearingPoint, Virginia. - Original Message From: McKenzie, James J C-E LCMC HQISEC/L3 [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Tuesday, August 8, 2006 11:19:08 AM Subject: Re: Recommeded network speeds... ** Joe: Internal or external? James Mckenzie From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe DeSouza Sent: Tuesday, August 08, 2006 8:10 AM To: arslist@ARSLIST.ORG Subject: Recommeded network speeds... ** This is my setup.. Each of these instances reside on seperate boxes. 1.) 2 AR System Servers 2.) Oracle DB server 3.) 3 Web Servers with the mid tier application installed on all of them resolving the load balancer device name to connect to the AR Servers. 4.) Hardware load balancer between the 2 AR System servers. 5.) We have a couple of web services published that would be used by other systems to query a table that has a couple of columns with lenght of 1024 as of now but we might marginally increase it if needed. Information contained in these columns are a concatinated list of regions affected by an outage caused by a network element going down in the cable network. So since these regions could be pretty much undertermined depending on how big the outage is, its hard to say what the lenght of that concatinated list might be but more often then not they would be much less than 255 characters. It might be that one odd occassion when the outage is severe that numerous regions might be affected resulting in a data lenght of about 1024 - I'm hoping that would be a good maximum limit to have rather than keeping it unlimited. Keeping all these in mind, what would be the reccommended network speed I should ask the network guys to build this environment to cater to the above? Joe D'Souza __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: Enhancement idea: Field Label for fields
** Talking about enhancements,another one I wished they had was if they had the ability to 'lock' or'stick'an object to the form so that it wouldn't be moved accidently due to an accidental point click and drag operation that happens so often especially if you are working from a laptop that has a touchpad on.. I love touchpads onlaptops and hate to turn them off... So basically if they had anoption on the properties of a fieldwith a check box or drop list choice to Lock / Unlock. That would be areally handy one to have with thedefault on creation of the field tokeep it unlocked... Once you have the form designclose to final you start locking objects on the form so you wouldn't accidently movethem around.. Cheers Joe D'Souza Remedy Developer / Consultant, BearingPoint, Virginia. - Original Message From: Carey Matthew Black [EMAIL PROTECTED]To: arslist@ARSLIST.ORGSent: Tuesday, August 8, 2006 11:53:06 AMSubject: Re: Enhancement idea: Field Label for fields Joe,I would even be happen with "on focus" working for Text objects in asearch window so that they could "simulate" what a field label doesfor the Advanced Search Bar(ASB). (So you could use a Text objects asthe label for a field, and leave the field lable "blank".) I wouldprefer a special field for all fields to let the admin specify whatthe ASB string should be so that we do not need to build active linksper field, but I would take what I could get. :)[basic logic:if field's ASB value is null then do what it does now,if ( not null) then use that string/keyword/field reference? instead of what it does nowkeyword $ NULL $ would result in a "no change" on the ASB.]-- Carey Matthew BlackRemedy Skilled Professional (RSP)ARS = Action Request System(Remedy)Solution = People + Process + ToolsFast, Accurate, Cheap Pick two.Never ascribe to malice, that which can be explained by incompetence.On 8/8/06, Joe DeSouza [EMAIL PROTECTED] wrote: ** Would have been nice to have field labels having the capacity to use a carriage return within the field name label.. This would mean you could still have a reasonably short label lenght for a field even if the label lenght was long. I tried copying the return character in the hope to see if it works but apparently not... Cheers Joe D'Souza Remedy Developer / Consultant, BearingPoint, Virginia.__20060125___This posting was submitted with HTML in it__UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it___
Nested SELECT table qualification?
All I'm hoping for a simple answer for a simple question. How can you do a nested SELECT in a table field qualification? If there is no simple way what's the opinion regarding an enhancement request? Many Thanks! Pete Oracle AR7 For Example: SELECT C536870913,C536870914,C536870915 FROM T191 WHERE C536870913 != 'SID25' AND C536870914 IN (SELECT C536870914 FROM T191 WHERE C536870913 = 'SID25' AND C536870915 IN (SELECT C536870915 FROM T191 WHERE C536870913 = 'SID25')) ORDER BY C536870914;This electronic message contains information from CACI International Inc or subsidiary companies, which may be company sensitive, proprietary, privileged or otherwise protected from disclosure. The information is intended to be used solely by the recipient(s) named above. If you are not an intended recipient, be aware that any review, disclosure, copying, distribution or use of this transmission or its contents is prohibited. If you have received this transmission in error, please notify us immediately at [EMAIL PROTECTED] With the exception of messages sent by authorized CACI contracts or purchasing personnel, nothing in this message may be interpreted as a digital or electronic signature that can be used to: (a) authenticate either the submission or the acceptance of a proposal or offer to contract, or (b) modify an existing contract. ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Recommeded network speeds...
** Thanks James, I like the hardware firewall idea between the VPN and theMid-Tier server.. By the way since we were talking about the weather - its comparitively pleasant out here in Virginia today. Joe D'Souza Remedy Developer / Consultant, BearingPoint, Virginia. - Original Message From: "McKenzie, James J C-E LCMC HQISEC/L3" [EMAIL PROTECTED]To: arslist@ARSLIST.ORGSent: Tuesday, August 8, 2006 12:37:00 PMSubject: Re: Recommeded network speeds...** Joe: Gig-E or higher then between the various components connected to a high-speed switch. Add a hardware firewall between the VPN and the Mid-Tier server to keep unwanted traffic out. James McKenzie From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe DeSouza Sent: Tuesday, August 08, 2006 9:33 AM To: arslist@ARSLIST.ORG Subject: Re: Recommeded network speeds... ** Hey James, All the components exist in a internal network - though they will be using this application over VPN from the outside world. So our aim is more to optimize the network speed internally between lets say the AR Server and the database, or the load balancer and the AR Servers, or between the Mid-tier and the load balancer and the AR Server and the database.. All these network pipelines basically. We are investing in new hardware so budgets shouldn't be that much of a constraint.. Cheers Joe D'Souza Remedy Developer / Consultant, BearingPoint, Virginia. - Original Message From: "McKenzie, James J C-E LCMC HQISEC/L3" [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Tuesday, August 8, 2006 11:19:08 AM Subject: Re: Recommeded network speeds... ** Joe: Internal or external? James Mckenzie From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe DeSouza Sent: Tuesday, August 08, 2006 8:10 AM To: arslist@ARSLIST.ORG Subject: Recommeded network speeds... ** This is my setup.. Each of these instances reside on seperate boxes. 1.) 2 AR System Servers 2.) Oracle DB server 3.) 3 Web Servers with the mid tier application installed on all of them resolving the load balancer device name to connect to the AR Servers. 4.) Hardware load balancer between the 2 AR System servers. 5.) We have a couple of web services published that would be used by other systems to query a table that has a couple of columns with lenght of 1024 as of now but we might marginally increase it if needed. Information contained in these columns are a concatinated list of regions affected by an outage caused by a network element going down in the cable network. So since these regions could be pretty much undertermined depending on how big the outage is, its hard to say what the lenght of that concatinated list might be but more often then not they would be much less than 255 characters. It might be that one odd occassion when the outage is severe that numerous regions might be affected resulting in a data lenght of about 1024 - I'm hoping that would be a good maximum limit to have rather than keeping it unlimited. Keeping all these in mind, what would be the reccommended network speed I should ask the network guys to build this environment to cater to the above? Joe D'Souza __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: Nested SELECT table qualification?
** Have you considered using a Vew form with that SQL statement?On 8/8/06, Peter Joran [EMAIL PROTECTED] wrote: AllI'm hoping for a simple answer for a simple question. How can you do a nested SELECT in a table field qualification? If there is no simple way what's the opinion regarding an enhancement request? Many Thanks!PeteOracleAR7For Example:SELECT C536870913,C536870914,C536870915FROM T191WHERE C536870913 != 'SID25' ANDC536870914 IN(SELECT C536870914FROM T191 WHERE C536870913 = 'SID25'ANDC536870915 IN(SELECT C536870915FROM T191WHERE C536870913 = 'SID25'))ORDER BY C536870914;This electronic message contains information from CACI International Inc or subsidiary companies, which may be company sensitive, proprietary, privileged or otherwise protected from disclosure. The information is intended to be used solely by the recipient(s) named above. If you are not an intended recipient, be aware that any review, disclosure, copying, distribution or use of this transmission or its contents is prohibited. If you have received this transmission in error, please notify us immediately at [EMAIL PROTECTED]. With the exception of messages sent by authorized CACI contracts or purchasing personnel, nothing in this message may be interpreted as a digital or electronic signature that can be used to: (a) authenticate either the submission or the acceptance of a proposal or offer to contract, or (b) modify an existing contract.___UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org-- Frank CarusoSpecific Integration, Inc.Senior Remedy Engineer www.specificintegration.com703-376-1249 __20060125___This posting was submitted with HTML in it___
Re: Nested SELECT table qualification?
** Peter, Have you tried creating a view of the table in question at db levelusing the nested select? If not try it and then build aView table from the database view you create of that form, and then build a table field with no qualification on that table.. If however you need to use the EXTERNAL() keyword to dynamically change the nested select, then maybe a enhancement request might be in order... Cheers Joe D'Souza Remedy Developer / Consultant, BearingPoint, Virginia. - Original Message From: Peter Joran [EMAIL PROTECTED]To: arslist@ARSLIST.ORGSent: Tuesday, August 8, 2006 1:32:14 PMSubject: Nested SELECT table qualification? AllI'm hoping for a simple answer for a simple question. How can you do a nested SELECT in a table field qualification? If there is no simple way what's the opinion regarding an enhancement request?Many Thanks!PeteOracleAR7For Example:SELECT C536870913,C536870914,C536870915FROM T191WHERE C536870913 != 'SID25'ANDC536870914 IN(SELECT C536870914FROM T191 WHERE C536870913 = 'SID25'ANDC536870915 IN(SELECT C536870915FROM T191WHERE C536870913 = 'SID25'))ORDER BY C536870914;This electronic message contains information from CACI International Inc or subsidiary companies, which may be company sensitive, proprietary, privileged or otherwise protected from disclosure. The information is intended to be usedsolely by the recipient(s) named above. If you are not an intended recipient, be aware that any review, disclosure, copying, distribution or use of this transmission or its contents is prohibited. If you have received this transmission in error, pleasenotify us immediately at [EMAIL PROTECTED] With the exception of messages sent by authorized CACI contracts or purchasing personnel, nothing in this message may be interpreted as a digital or electronic signature that can be used to: (a) authenticateeither the submission or the acceptance of a proposal or offer to contract, or (b) modify an existing contract.___UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it___
Re: Enhancement idea: Field Label for fields
Joe, Or a similar idea I bumped into in IReports is that you lock all objects to prevent movement with the mouse. (But still allow movement via the field properties changes in X,Y values. :) I am not sure I would like to need to unlock several fields on a tab to be able to move them later. Rather I would be happy with a safety that tells the tool to ignore those kinds of mouse inputs for now. (But implemented at run time, and a transient value. Maybe the setting gets pushed into the admin prefs, maybe not.) -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. Never ascribe to malice, that which can be explained by incompetence. On 8/8/06, Joe DeSouza [EMAIL PROTECTED] wrote: ** Talking about enhancements, another one I wished they had was if they had the ability to 'lock' or 'stick' an object to the form so that it wouldn't be moved accidently due to an accidental point click and drag operation that happens so often especially if you are working from a laptop that has a touchpad on.. I love touchpads on laptops and hate to turn them off... So basically if they had an option on the properties of a field with a check box or drop list choice to Lock / Unlock. That would be a really handy one to have with the default on creation of the field to keep it unlocked... Once you have the form design close to final you start locking objects on the form so you wouldn't accidently move them around.. Cheers Joe D'Souza Remedy Developer / Consultant, BearingPoint, Virginia. - Original Message From: Carey Matthew Black [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Tuesday, August 8, 2006 11:53:06 AM Subject: Re: Enhancement idea: Field Label for fields Joe, I would even be happen with on focus working for Text objects in a search window so that they could simulate what a field label does for the Advanced Search Bar(ASB). (So you could use a Text objects as the label for a field, and leave the field lable blank.) I would prefer a special field for all fields to let the admin specify what the ASB string should be so that we do not need to build active links per field, but I would take what I could get. :) [basic logic: if field's ASB value is null then do what it does now, if ( not null) then use that string/keyword/field reference? instead of what it does now keyword $ NULL $ would result in a no change on the ASB. ] -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. Never ascribe to malice, that which can be explained by incompetence. On 8/8/06, Joe DeSouza [EMAIL PROTECTED] wrote: ** Would have been nice to have field labels having the capacity to use a carriage return within the field name label.. This would mean you could still have a reasonably short label lenght for a field even if the label lenght was long. I tried copying the return character in the hope to see if it works but apparently not... Cheers Joe D'Souza Remedy Developer / Consultant, BearingPoint, Virginia. __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: CMDB 2.0 C API - Another Problem
Byron, This commonly means that although the function declaration was found in the header file, the actual function in a library was not found during linking. Find the .dll or .so library file that contains the functions the cmdb.h file references, and either include it somewhere where the OS knows to load it or explicitly reference the directory it's in the LD_LIBRARY_PATH environment variable (If your using UNIX/LINUX). HTH, -Brian Luke -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dawe, Byron Sent: Tuesday, August 08, 2006 7:50 AM To: arslist@ARSLIST.ORG Subject: CMDB 2.0 C API - Another Problem Hi Listers; Thanks to Ben for his help with the last problem! Has anyone run into the situation where you include ar.h and cmdb.h , but when calling CMDBInitialization and/or CMDBTermination the compiler reports 'undefined reference' to the calls? Yet when I call only ARInitialization and/or ARTermination, these seem to work fine ! I am properly following the order of calling ARInitialization first then CMDBInitialization, but the second call gives compile errors although both header files are in the same place! I have checked the sample files and it seems I am doing it right, but still I get compile errors! Help and Thanks, Byron. === Byron Dawe Computing and Communications Memorial University of Newfoundland St. John's, NL A1C 5S7 Phone: (709) 757-3530 ext. 4054 === ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Nested SELECT table qualification?
** Create a database view that performs the nested select statement, then create a View form in ARS that reads from the view. You will probably need to include the C1 column in your SELECT, so that you have a valid field to use as the Request ID column in the View form. Use the View form as the source for your table field, and give it a blank qualification or something like "(1 = 1)". (The SELECT statement in the database view should filter the query results). HTH, Thomas - Original Message - From: Peter Joran Newsgroups: gmane.comp.crm.arsystem.general Sent: Tuesday, August 08, 2006 12:32 Subject: Nested SELECT table qualification? AllI'm hoping for a simple answer for a simple question. How can you do a nested SELECT in a table field qualification? If there is no simple way what's the opinion regarding an enhancement request?Many Thanks!PeteOracleAR7For Example:SELECT C536870913,C536870914,C536870915FROM T191WHERE C536870913 != 'SID25'AND C536870914 IN (SELECT C536870914 FROM T191 WHERE C536870913 = 'SID25'AND C536870915 IN (SELECT C536870915 FROM T191 WHERE C536870913 = 'SID25'))ORDER BY C536870914;This electronic message contains information from CACI International Inc or subsidiary companies, which may be company sensitive, proprietary, privileged or otherwise protected from disclosure. The information is intended to be usedsolely by the recipient(s) named above. If you are not an intended recipient, be aware that any review, disclosure, copying, distribution or use of this transmission or its contents is prohibited. If you have received this transmission in error, pleasenotify us immediately at [EMAIL PROTECTED]. With the exception of messages sent by authorized CACI contracts or purchasing personnel, nothing in this message may be interpreted as a digital or electronic signature that can be used to: (a) authenticateeither the submission or the acceptance of a proposal or offer to contract, or (b) modify an existing contract. __20060125___This posting was submitted with HTML in it___
Re: Recommeded network speeds...
Title: RE: Recommeded network speeds... ** Joe: Sunny, around 90 with a 50% chance of Thunderstorms here in Southern Arizona. And thanks. I've found folks who did not secure their VPNs and paid the price when a laptop or two were stolen. So, what does this have to do with ARS? Alot. Think security of your network, servers and system and plan accordingly. Since the ARS server is critical to most of us, we should think critically about security, all aspects. James McKenzie From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe DeSouza Sent: Tuesday, August 08, 2006 10:35 AM To: arslist@ARSLIST.ORG Subject: Re: Recommeded network speeds... ** Thanks James, I like the hardware firewall idea between the VPN and the Mid-Tier server.. By the way since we were talking about the weather - its comparitively pleasant out here in Virginia today. Joe D'Souza Remedy Developer / Consultant, BearingPoint, Virginia. - Original Message From: McKenzie, James J C-E LCMC HQISEC/L3 [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Tuesday, August 8, 2006 12:37:00 PM Subject: Re: Recommeded network speeds... ** Joe: Gig-E or higher then between the various components connected to a high-speed switch. Add a hardware firewall between the VPN and the Mid-Tier server to keep unwanted traffic out. James McKenzie From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe DeSouza Sent: Tuesday, August 08, 2006 9:33 AM To: arslist@ARSLIST.ORG Subject: Re: Recommeded network speeds... ** Hey James, All the components exist in a internal network - though they will be using this application over VPN from the outside world. So our aim is more to optimize the network speed internally between lets say the AR Server and the database, or the load balancer and the AR Servers, or between the Mid-tier and the load balancer and the AR Server and the database.. All these network pipelines basically. We are investing in new hardware so budgets shouldn't be that much of a constraint.. Cheers Joe D'Souza Remedy Developer / Consultant, BearingPoint, Virginia. - Original Message From: McKenzie, James J C-E LCMC HQISEC/L3 [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Tuesday, August 8, 2006 11:19:08 AM Subject: Re: Recommeded network speeds... ** Joe: Internal or external? James Mckenzie From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe DeSouza Sent: Tuesday, August 08, 2006 8:10 AM To: arslist@ARSLIST.ORG Subject: Recommeded network speeds... ** This is my setup.. Each of these instances reside on seperate boxes. 1.) 2 AR System Servers 2.) Oracle DB server 3.) 3 Web Servers with the mid tier application installed on all of them resolving the load balancer device name to connect to the AR Servers. 4.) Hardware load balancer between the 2 AR System servers. 5.) We have a couple of web services published that would be used by other systems to query a table that has a couple of columns with lenght of 1024 as of now but we might marginally increase it if needed. Information contained in these columns are a concatinated list of regions affected by an outage caused by a network element going down in the cable network. So since these regions could be pretty much undertermined depending on how big the outage is, its hard to say what the lenght of that concatinated list might be but more often then not they would be much less than 255 characters. It might be that one odd occassion when the outage is severe that numerous regions might be affected resulting in a data lenght of about 1024 - I'm hoping that would be a good maximum limit to have rather than keeping it unlimited. Keeping all these in mind, what would be the reccommended network speed I should ask the network guys to build this environment to cater to the above? Joe D'Souza __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: Enhancement idea: Field Label for fields
** Joe, It may not retain the functionality but you could build it. An On Focus AL could SET the Value of the Field Name of the Actual field into the Advanced Search Bar via the Query Bar field (ID 1005). Maybe use a look up form to hold all of your text fields and the corresponding data fields This is not tested so I don't know if it would on the WUT. It should work fine on the Midtier. John J. ReiserSoftware Development AnalystRemedy Administrator/DeveloperLockheed Martin - MS2The star that burns twice as bright burns half as long.Pay close attention and be illuminated by its brilliance. - paraphrased by me From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouzaSent: Tuesday, August 08, 2006 12:34 PMTo: arslist@ARSLIST.ORGSubject: Re: Enhancement idea: Field Label for fields ** Done that before but thattakes the functionality of clicking on the text field to return the field name on the Advanced SearchBar.. So a workaround yes but it doesn't retain the original functionality... Cheers Joe D'Souza Remedy Developer / Consultant, BearingPoint, Virginia. - Original Message From: John Atherly [EMAIL PROTECTED]To: arslist@ARSLIST.ORGSent: Tuesday, August 8, 2006 11:34:53 AMSubject: Re: Enhancement idea: Field Label for fields Add a text field next to the field name.John AtherlyAmerican Power Conversion[EMAIL PROTECTED]401-789-5735 Ext. 21201-800-788-2208 Ext. 2120 Joe DeSouza [EMAIL PROTECTED] .COMTo Sent by: "Actionarslist@ARSLIST.ORG Request System cc discussion list(ARSList)"Subject [EMAIL PROTECTED] Enhancement idea: Field Label for ORGfields 08/08/2006 11:26 AM Please respond to [EMAIL PROTECTED] RG **Would have been nice to have field labels having the capacity to use acarriage return within the field name label.. This would mean you couldstill have a reasonably short label lenght for a field even if the labellenght was long.I tried copying the return character in the hope to see if it works butapparently not...CheersJoe D'SouzaRemedy Developer / Consultant,BearingPoint,Virginia.__20060125___This posting was submitted with HTML init__UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org__20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: Enhancement idea: Field Label for fields
** Mathew, I wouldthink having the Adminto have the ability to choose his preferences whether or not he wants to use the Lock feature might be a great idea too.. Didn't think of that one :-) Joe D'Souza Remedy Developer / Consultant, BearingPoint, Virginia. - Original Message From: Carey Matthew Black [EMAIL PROTECTED]To: arslist@ARSLIST.ORGSent: Tuesday, August 8, 2006 1:41:30 PMSubject: Re: Enhancement idea: Field Label for fields Joe,Or a similar idea I bumped into in IReports is that you lock allobjects to prevent movement with the mouse. (But still allow movementvia the field properties changes in X,Y values. :)I am not sure I would like to need to unlock several fields on a tabto be able to move them later. Rather I would be happy with a "safety"that tells the tool to ignore those kinds of mouse inputs for now.(But implemented at run time, and a transient value. Maybe the settinggets pushed into the admin prefs, maybe not.)-- Carey Matthew BlackRemedy Skilled Professional (RSP)ARS = Action Request System(Remedy)Solution = People + Process + ToolsFast, Accurate, Cheap Pick two.Never ascribe to malice, that which can be explained by incompetence.On 8/8/06, Joe DeSouza [EMAIL PROTECTED] wrote: ** Talking about enhancements, another one I wished they had was if they had the ability to 'lock' or 'stick' an object to the form so that it wouldn't be moved accidently due to an accidental point click and drag operation that happens so often especially if you are working from a laptop that has a touchpad on.. I love touchpads on laptops and hate to turn them off... So basically if they had an option on the properties of a field with a check box or drop list choice to Lock / Unlock. That would be a really handy one to have with the default on creation of the field to keep it unlocked... Once you have the form design close to final you start locking objects on the form so you wouldn't accidently move them around.. Cheers Joe D'Souza Remedy Developer / Consultant, BearingPoint, Virginia. - Original Message From: Carey Matthew Black [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Tuesday, August 8, 2006 11:53:06 AM Subject: Re: Enhancement idea: Field Label for fields Joe, I would even be happen with "on focus" working for Text objects in a search window so that they could "simulate" what a field label does for the Advanced Search Bar(ASB). (So you could use a Text objects as the label for a field, and leave the field lable "blank".) I would prefer a special field for all fields to let the admin specify what the ASB string should be so that we do not need to build active links per field, but I would take what I could get. :) [basic logic: if field's ASB value is null thendo what it does now, if ( not null) thenuse that string/keyword/field reference? instead of what it does now keyword $ NULL $ would result in a "no change" on the ASB. ] -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. Never ascribe to malice, that which can be explained by incompetence. On 8/8/06, Joe DeSouza [EMAIL PROTECTED] wrote: **Would have been nice to have field labels having the capacity to use a carriage return within the field name label.. This would mean you could still have a reasonably short label lenght for a field even if the label lenght was long. I tried copying the return character in the hope to see if it works but apparently not... Cheers Joe D'Souza Remedy Developer / Consultant, BearingPoint, Virginia. __20060125___This posting was submitted with HTML in it___
Re: Nested SELECT table qualification?
My opinion on the enhancement request is that BMC will not venture anywhere near actually using a db for anything above simple select, insert, update, and delete statements. Union joins, table field grouping/aggregates (sum, avg, stddev, etc), sub-queries; keywords like 'in' and 'between'; are all beyond the capabilities of ARS. Axton Grams On 8/8/06, Thomas Bean [EMAIL PROTECTED] wrote: ** Create a database view that performs the nested select statement, then create a View form in ARS that reads from the view. You will probably need to include the C1 column in your SELECT, so that you have a valid field to use as the Request ID column in the View form. Use the View form as the source for your table field, and give it a blank qualification or something like (1 = 1). (The SELECT statement in the database view should filter the query results). HTH, Thomas - Original Message - From: Peter Joran Newsgroups: gmane.comp.crm.arsystem.general Sent: Tuesday, August 08, 2006 12:32 Subject: Nested SELECT table qualification? All I'm hoping for a simple answer for a simple question. How can you do a nested SELECT in a table field qualification? If there is no simple way what's the opinion regarding an enhancement request? Many Thanks! Pete Oracle AR7 For Example: SELECT C536870913,C536870914,C536870915 FROM T191 WHERE C536870913 != 'SID25' AND C536870914 IN (SELECT C536870914 FROM T191 WHERE C536870913 = 'SID25' AND C536870915 IN (SELECT C536870915 FROM T191 WHERE C536870913 = 'SID25')) ORDER BY C536870914;This electronic message contains information from CACI International Inc or subsidiary companies, which may be company sensitive, proprietary, privileged or otherwise protected from disclosure. The information is intended to be used solely by the recipient(s) named above. If you are not an intended recipient, be aware that any review, disclosure, copying, distribution or use of this transmission or its contents is prohibited. If you have received this transmission in error, please notify us immediately at [EMAIL PROTECTED] With the exception of messages sent by authorized CACI contracts or purchasing personnel, nothing in this message may be interpreted as a digital or electronic signature that can be used to: (a) authenticate either the submission or the acceptance of a proposal or offer to contract, or (b) modify an existing contract. __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: JOB- REMEDY DEVELOPER
Where in San Diego? Fluxman -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Shawn Recker Sent: 08/08/2006 9:55 AM To: arslist@ARSLIST.ORG Subject: JOB- REMEDY DEVELOPER I have a Remedy development position located in San Diego that has recently opened. I have attached the job description below. If interested in discussing, please send resume to [EMAIL PROTECTED] or call me at 800-330-0309. Job Description: Summary of Job Duties: This position is accountable for development, administration, customization and integration of Remedy Action Request System solutions, with a strong focus on the out-of-the box I.T. Service Management (ITSM) suite (Help Desk, Change Management, and Asset Management). Responsibilities include gathering customer requirements, preparing design specifications documentation, application development, ongoing technical support and system maintenance. This position responds to user requests for data extraction, custom or ad-hoc database reporting or enhancements to system capabilities. And further provides end-user training, and system account administration and maintenance. Minimum Qualifications: The ideal candidate for this position will have a four-year technical degree or equivalent in work experience. Also, a minimum of two years of prior related work experience. The candidate will have an ability to provide positive customer service and advanced communication, problem solving and technical writing skills. Good customer presentation and project management skills are a must. Knowledge of databases, software design, and system administration is required. Previous experience in a technical support environment is required. Technical proficiency in relevant operating systems, applications and programming languages is required (Remedy Action Request System, Mid- Tier, and BMC Remedy's ITSM Suite [Help Desk, Asset Management, Change Management]; Microsoft Windows Server; Unix; SQL Server; Oracle). Desired Qualifications: Remedy Approved Consultant (RAC) certification, Remedy Skilled Professional (RSP) certification or other advanced Remedy training classes. Technical proficiency in advanced technologies (Remedy Flashboards, Approval Engine, Service Level Agreements, Web Services and API programming; Unix; Java; C++) An active or recent secret security clearance, or the ability to obtain one. Required Skills: Minimum Qualifications: The ideal candidate for this position will have a four-year technical degree or equivalent in work experience. Also, a minimum of two years of prior related work experience. The candidate will have an ability to provide positive customer service and advanced communication, problem solving and technical writing skills. Good customer presentation and project management skills are a must. Knowledge of databases, software design, and system administration is required. Previous experience in a technical support environment is required. Technical proficiency in relevant operating systems, applications and programming languages is required (Remedy Action Request System, Mid- Tier, and BMC Remedy's ITSM Suite [Help Desk, Asset Management, Change Management]; Microsoft Windows Server; Unix; SQL Server; Oracle). ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: JOB- REMEDY DEVELOPER
** It's near downtown, zipcode 92110. Would that are be of interest for contract to direct work? Shawn Recker Regional Recruiting Manager Technisource 4800 North River Blvd. NE Cedar Rapids, IA 52411 Office 319.378.9220 | 1-800-330-0309 | Fax 319.378.9229 [EMAIL PROTECTED] | www.technisource.com Cox - Home [EMAIL PROTECTED] Cox - Home [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 08/08/2006 01:17 PM Please respond to arslist To: arslist@ARSLIST.ORG cc: Subject: Re: JOB- REMEDY DEVELOPER Where in San Diego? Fluxman -Original Message- From: Action Request System discussion list(ARSList) __20060125___This posting was submitted with HTML in it___
Re: Enhancement idea: Field Label for fields
** Might just work - I have tried other functionality on theUser / Web tool to show/ hide the query bar by using a field created with that field ID and it had worked as far as showing and hiding the query bar... I don't think I'm going to use that though for this as I do not really want to create unnecessary text fields on the form. Great idea though - should have thought of that myself having used that kind of an idea before.. Joe D'Souza Remedy Developer / Consultant, BearingPoint, Virginia. - Original Message From: "Reiser, John J" [EMAIL PROTECTED]To: arslist@ARSLIST.ORGSent: Tuesday, August 8, 2006 1:47:00 PMSubject: Re: Enhancement idea: Field Label for fields** Joe, It may not retain the functionality but you could build it. An On Focus AL could SET the Value of the Field Name of the Actual field into the Advanced Search Bar via the Query Bar field (ID 1005). Maybe use a look up form to hold all of your text fields and the corresponding data fields This is not tested so I don't know if it would on the WUT. It should work fine on the Midtier. John J. ReiserSoftware Development AnalystRemedy Administrator/DeveloperLockheed Martin - MS2The star that burns twice as bright burns half as long.Pay close attention and be illuminated by its brilliance. - paraphrased by me From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouzaSent: Tuesday, August 08, 2006 12:34 PMTo: arslist@ARSLIST.ORGSubject: Re: Enhancement idea: Field Label for fields ** Done that before but thattakes the functionality of clicking on the text field to return the field name on the Advanced SearchBar.. So a workaround yes but it doesn't retain the original functionality... Cheers Joe D'Souza Remedy Developer / Consultant, BearingPoint, Virginia. - Original Message From: John Atherly [EMAIL PROTECTED]To: arslist@ARSLIST.ORGSent: Tuesday, August 8, 2006 11:34:53 AMSubject: Re: Enhancement idea: Field Label for fields Add a text field next to the field name.John AtherlyAmerican Power Conversion[EMAIL PROTECTED]401-789-5735 Ext. 21201-800-788-2208 Ext. 2120 Joe DeSouza [EMAIL PROTECTED] .COMTo Sent by: "Actionarslist@ARSLIST.ORG Request System cc discussion list(ARSList)"Subject [EMAIL PROTECTED] Enhancement idea: Field Label for ORGfields 08/08/2006 11:26 AM Please respond to [EMAIL PROTECTED] RG **Would have been nice to have field labels having the capacity to use acarriage return within the field name label.. This would mean you couldstill have a reasonably short label lenght for a field even if the labellenght was long.I tried copying the return character in the hope to see if it works butapparently not...CheersJoe D'SouzaRemedy Developer / Consultant,BearingPoint,Virginia.__20060125___This posting was submitted with HTML init__UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org__20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: Nested SELECT table qualification?
Title: RE: Nested SELECT table qualification? ** Axton: Unless all of the underlying databases support the requested functionality, you will never see it in ARS. Thus, you probably will not see nested queries even if they are quicker and easier. James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Axton Sent: Tuesday, August 08, 2006 11:00 AM To: arslist@ARSLIST.ORG Subject: Re: Nested SELECT table qualification? My opinion on the enhancement request is that BMC will not venture anywhere near actually using a db for anything above simple select, insert, update, and delete statements. Union joins, table field grouping/aggregates (sum, avg, stddev, etc), sub-queries; keywords like 'in' and 'between'; are all beyond the capabilities of ARS. Axton Grams On 8/8/06, Thomas Bean [EMAIL PROTECTED] wrote: ** Create a database view that performs the nested select statement, then create a View form in ARS that reads from the view. You will probably need to include the C1 column in your SELECT, so that you have a valid field to use as the Request ID column in the View form. Use the View form as the source for your table field, and give it a blank qualification or something like (1 = 1). (The SELECT statement in the database view should filter the query results). HTH, Thomas - Original Message - From: Peter Joran Newsgroups: gmane.comp.crm.arsystem.general Sent: Tuesday, August 08, 2006 12:32 Subject: Nested SELECT table qualification? All I'm hoping for a simple answer for a simple question. How can you do a nested SELECT in a table field qualification? If there is no simple way what's the opinion regarding an enhancement request? Many Thanks! Pete Oracle AR7 For Example: SELECT C536870913,C536870914,C536870915 FROM T191 WHERE C536870913 != 'SID25' AND C536870914 IN (SELECT C536870914 FROM T191 WHERE C536870913 = 'SID25' AND C536870915 IN (SELECT C536870915 FROM T191 WHERE C536870913 = 'SID25')) ORDER BY C536870914;This electronic message contains information from CACI International Inc or subsidiary companies, which may be company sensitive, proprietary, privileged or otherwise protected from disclosure. The information is intended to be used solely by the recipient(s) named above. If you are not an intended recipient, be aware that any review, disclosure, copying, distribution or use of this transmission or its contents is prohibited. If you have received this transmission in error, please notify us immediately at [EMAIL PROTECTED] With the exception of messages sent by authorized CACI contracts or purchasing personnel, nothing in this message may be interpreted as a digital or electronic signature that can be used to: (a) authenticate either the submission or the acceptance of a proposal or offer to contract, or (b) modify an existing contract. __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it___
Re: Trouble with using AR System .NET API version 1.2.1761.15495
Title: Trouble with using AR System .NET API version 1.2.1761.15495 ** Remedy BMC at this point is advising us to use the newer API that they have available on the Community downloads that is a 7.0 API (but they claim is backwards compatible). We are now getting errors with "Module Not Found". This is after following the install process which was basically copy the folder locally, run regasm passing it the path to BMC.ARSystem.dll, and adding the path for BMC.ARSystem.dll to the %PATH% var. We also stripped off all the old references, and added new references. Still after all this the errors are occuring. Does anyone have ideas on this? Thanks Peter Lammey ESPN MIT Technical Services Applications Management 860-766-4761 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Houldcroft, DarrenSent: Monday, August 07, 2006 2:34 PMTo: arslist@ARSLIST.ORGSubject: Re: Trouble with using AR System .NET API version 1.2.1761.15495 ** Right -add this before your call to get list entries with fields: temp.AddField(26000, 128, "") voila - problem solved! Rgds, Darren Houldcroft LogicaCMG - RemedyTA 250 Brook Drive,Green Park,Reading,RG2 6UAT: +44 (0) 118 9650453M: +44 (0) 7968 475 015E: [EMAIL PROTECTED]W: http://www.logicacmg.com From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Lammey, Peter A.Sent: 07 August 2006 18:04To: arslist@ARSLIST.ORGSubject: Re: Trouble with using AR System .NET API version 1.2.1761.15495 ** Here is the code again. Hopefully this file will go through. Thanks Peter Lammey ESPN MIT Technical Services Applications Management 860-766-4761 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Houldcroft, DarrenSent: Monday, August 07, 2006 11:37 AMTo: arslist@ARSLIST.ORGSubject: Re: Trouble with using AR System .NET API version 1.2.1761.15495 ** Hi Peter, Are you able to post the section of code? - I've not had this problem before. Rgds, Darren Houldcroft LogicaCMG - RemedyTA 250 Brook Drive,Green Park,Reading,RG2 6UAT: +44 (0) 118 9650453M: +44 (0) 7968 475 015E: [EMAIL PROTECTED]W: http://www.logicacmg.com From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Lammey, Peter A.Sent: 07 August 2006 16:26To: arslist@ARSLIST.ORGSubject: Trouble with using AR System .NET API version 1.2.1761.15495 ** I have been working with a development team to setup a separate application that will pull and push data to our Remedy system via the .NET API that is provided from the Community Download area on the Supportweb. For some odd reason, the program they setup can only pull data on some of the fields against the forms they are pulling data from which is the SHR:Company, SHR:Categorization, and AST:ASTOuterJoinASTPeople forms that are provided and are basically the out of box forms from ITSM 5.6. For example, on SHR:Company the API can pull data from Company Name but cant pull the Company ID or Company Type. The ID they are using has all the right permissions and all the fields they are looking to pull data from has even Public view permissions. I was even able to login with the Remedy ID they are using and see all the fields with data. Our server is version is 6.3 patch 16 on a Windows 2003 server. Our database is Oracle 9.2.0.4. Any ideas are welcome since I have no clue at this point where to go from here. Thanks Peter Lammey ESPN MIT Technical Services Applications Management 860-766-4761 __20060125___This posting was submitted with HTML in it___ This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to legal privilege. It should not be copied, disclosed to, retained or used by, any other party. If you are not an intended recipient then please promptly delete this e-mail and any attachment and all copies and inform the sender. Thank you.__20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: Nested SELECT table qualification?
Thanks for the replies! I do have a need to use an EXTERNAL qualification. Pete -Action Request System discussion list(ARSList) arslist@ARSLIST.ORG wrote: - To: arslist@ARSLIST.ORG From: Axton [EMAIL PROTECTED] ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
SSO
** Hi, We have some users which log in with fsmith (first name, last name), and other users in active directory with smithf (last name, first name). Is there a way to configure SSO to recognize both formats? __20060125___This posting was submitted with HTML in it___
Re: RUG 2006 schedule is out!
I will be there also, I even get to go to the tutorals (1st time in 5 visits). Bill Clary Remedy Developer, Technology Solutions FTS | Customer Support Center Rick Cook [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]... Daily schedules are now available, so that you can plan your day(s) there. Looks like some good sessions, but there's probably better info to be gleaned outside of them. I still have to find out if I'll be joining you. What's the count of those going so far? https://www.bmcuserworld.com/catalog/eventguide/publicSchedule.jsp Rick Cook * Remedy Approved Consultant * Denali Advanced Integration * (253) 278-4112 ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org -- ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Master ARSUITE 5.1.2
HI Does anyone know where I can get a copy or can send a copy of arws.dot webservices word template Master ARSUITE. I am trying to get a webservice doc out of IT Master. If you have a copy of arws.dot, please send to [EMAIL PROTECTED] thanks... dave ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: 7.0 Installation
** Hi Kelly, Can I have the checklist for the install of 7.0 also? __20060125___This posting was submitted with HTML in it___
Mid Tier 6.3 - Change Cursor for single button image
Is it possible to change the cursor (ie. the hand cursor) for a single button on a form in mid tier 6.3? I know you can add an entry to the css file, which applies to all buttons. I am looking for greater granularity with regards to displaying controls (such as buttons) in mid tier. Thanks. Stephen ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: RUG 2006 schedule is out!
** Well, all y'all will have to enjoy S.F. without me this year. I just got the word we aren't going. I'll have to live vicariously through mobile uplinks and the like. Rick From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Don McClureSent: Tuesday, August 08, 2006 1:25 PMTo: arslist@ARSLIST.ORGSubject: Re: RUG 2006 schedule is out! ** Looks like the University of North Texas crew will be thereChris Strauss, our director, and mewith Chris and me for the tutorials as well. Don W. McClure, P.E.Systems EngineerUniversity of North Texasdwmac_at_unt.edu [EMAIL PROTECTED] 07-Aug-06 3:49 PM ** Daily schedules are now available, so that you can plan your day(s) there. Looks like some good sessions, but there's probably better info to be gleaned outside of them. I still have to find out if I'll be joining you. What's the count of those going so far? https://www.bmcuserworld.com/catalog/eventguide/publicSchedule.jsp Rick CookRemedy Approved Consultant Denali Advanced Integration (253) 278-4112 __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: Nested SELECT table qualification?
All of the items I listed are supported by every db supported by ARS. Don't think that is the cause for us never seeing these things. Axton Grams On 8/8/06, McKenzie, James J C-E LCMC HQISEC/L3 [EMAIL PROTECTED] wrote: ** Axton: Unless all of the underlying databases support the requested functionality, you will never see it in ARS. Thus, you probably will not see nested queries even if they are quicker and easier. James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Tuesday, August 08, 2006 11:00 AM To: arslist@ARSLIST.ORG Subject: Re: Nested SELECT table qualification? My opinion on the enhancement request is that BMC will not venture anywhere near actually using a db for anything above simple select, insert, update, and delete statements. Union joins, table field grouping/aggregates (sum, avg, stddev, etc), sub-queries; keywords like 'in' and 'between'; are all beyond the capabilities of ARS. Axton Grams On 8/8/06, Thomas Bean [EMAIL PROTECTED] wrote: ** Create a database view that performs the nested select statement, then create a View form in ARS that reads from the view. You will probably need to include the C1 column in your SELECT, so that you have a valid field to use as the Request ID column in the View form. Use the View form as the source for your table field, and give it a blank qualification or something like (1 = 1). (The SELECT statement in the database view should filter the query results). HTH, Thomas - Original Message - From: Peter Joran Newsgroups: gmane.comp.crm.arsystem.general Sent: Tuesday, August 08, 2006 12:32 Subject: Nested SELECT table qualification? All I'm hoping for a simple answer for a simple question. How can you do a nested SELECT in a table field qualification? If there is no simple way what's the opinion regarding an enhancement request? Many Thanks! Pete Oracle AR7 For Example: SELECT C536870913,C536870914,C536870915 FROM T191 WHERE C536870913 != 'SID25' AND C536870914 IN (SELECT C536870914 FROM T191 WHERE C536870913 = 'SID25' AND C536870915 IN (SELECT C536870915 FROM T191 WHERE C536870913 = 'SID25')) ORDER BY C536870914;This electronic message contains information from CACI International Inc or subsidiary companies, which may be company sensitive, proprietary, privileged or otherwise protected from disclosure. The information is intended to be used solely by the recipient(s) named above. If you are not an intended recipient, be aware that any review, disclosure, copying, distribution or use of this transmission or its contents is prohibited. If you have received this transmission in error, please notify us immediately at [EMAIL PROTECTED] With the exception of messages sent by authorized CACI contracts or purchasing personnel, nothing in this message may be interpreted as a digital or electronic signature that can be used to: (a) authenticate either the submission or the acceptance of a proposal or offer to contract, or (b) modify an existing contract. __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: RUG 2006 schedule is out!
** Wow! Rick, you and I will be sitting here in our respective offices missing all the fun! I have received word that I won't be going either. Now, I have to cancel the hotel room and my kennel reservations. Heck, I may still send the dogs away for a few days! Claire From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick CookSent: Tuesday, August 08, 2006 3:31 PMTo: arslist@ARSLIST.ORGSubject: Re: RUG 2006 schedule is out! ** Well, all y'all will have to enjoy S.F. without me this year. I just got the word we aren't going. I'll have to live vicariously through mobile uplinks and the like. Rick From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Don McClureSent: Tuesday, August 08, 2006 1:25 PMTo: arslist@ARSLIST.ORGSubject: Re: RUG 2006 schedule is out! ** Looks like the University of North Texas crew will be thereChris Strauss, our director, and mewith Chris and me for the tutorials as well. Don W. McClure, P.E.Systems EngineerUniversity of North Texasdwmac_at_unt.edu [EMAIL PROTECTED] 07-Aug-06 3:49 PM ** Daily schedules are now available, so that you can plan your day(s) there. Looks like some good sessions, but there's probably better info to be gleaned outside of them. I still have to find out if I'll be joining you. What's the count of those going so far? https://www.bmcuserworld.com/catalog/eventguide/publicSchedule.jsp Rick CookRemedy Approved Consultant Denali Advanced Integration (253) 278-4112 __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: RUG 2006 schedule is out!
** Just found out that I will be going after all and I will be dragging alone another employee from EDS, as well. Christopher Pruitt Consultant Specialist EDS - Bank of America I3-Inventory IW Infrastructure Team Phone: +1-972-605-7702 (8-835) mailto:[EMAIL PROTECTED] Confidentiality Notice: This message and any files transmitted with it are intended for the sole use of the entity or individual to whom it is addressed, and may contain information that is confidential, privileged, and exempt from disclosure under applicable law. If you are not the intended addressee for this e-mail, you are hereby notified that any copying, distribution, or dissemination of this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately destroy, erase, or discard this message. Please notify the sender immediately by return e-mail if you have received this e-mail by mistake. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick CookSent: Monday, August 07, 2006 3:50 PMTo: arslist@ARSLIST.ORGSubject: RUG 2006 schedule is out! ** Daily schedules are now available, so that you can plan your day(s) there. Looks like some good sessions, but there's probably better info to be gleaned outside of them. I still have to find out if I'll be joining you. What's the count of those going so far? https://www.bmcuserworld.com/catalog/eventguide/publicSchedule.jsp Rick CookRemedy Approved Consultant Denali Advanced Integration (253) 278-4112 __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: RUG 2006 schedule is out!
** And a miss as well here From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick CookSent: Tuesday, August 08, 2006 3:31 PMTo: arslist@ARSLIST.ORGSubject: Re: RUG 2006 schedule is out! ** Well, all y'all will have to enjoy S.F. without me this year. I just got the word we aren't going. I'll have to live vicariously through mobile uplinks and the like. Rick From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Don McClureSent: Tuesday, August 08, 2006 1:25 PMTo: arslist@ARSLIST.ORGSubject: Re: RUG 2006 schedule is out! ** Looks like the University of North Texas crew will be thereChris Strauss, our director, and mewith Chris and me for the tutorials as well. Don W. McClure, P.E.Systems EngineerUniversity of North Texasdwmac_at_unt.edu [EMAIL PROTECTED] 07-Aug-06 3:49 PM ** Daily schedules are now available, so that you can plan your day(s) there. Looks like some good sessions, but there's probably better info to be gleaned outside of them. I still have to find out if I'll be joining you. What's the count of those going so far? https://www.bmcuserworld.com/catalog/eventguide/publicSchedule.jsp Rick CookRemedy Approved Consultant Denali Advanced Integration (253) 278-4112 __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: Disabling the 'windows' close [X] button on Open Window Dialog....
** Any takers for this one? Joe D'Souza -Original Message-From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]On Behalf Of Joe DeSouzaSent: Monday, August 07, 2006 5:08 PMTo: arslist@ARSLIST.ORGSubject: Disabling the 'windows' close [X] button on Open Window Dialog** This worksOTBon the nativeWUT... I was always under the impression it workedOTB on the MidTier as well, until I noticed today that it doesn't.. All the default Windows title bar buttons(minimize, maximize and close) show up even though on open of the dialog I have checked the check box to not show the close button... Can someone out there verify that it doesn't work OTB on the Mid-Tier client? I could have sworn it used to work on the earlier versions. I have ARS 6.3 server patch 16.. mid-tier version and client versions are the same too. Cheers Joe D'Souza Remedy Developer / Consultant, BearingPoint, Virginia. __20060125___This posting was submitted with HTML in it___
Dawn E Triplett/OR1/AEPIN is out of the office.
I will be out of the office starting 08/09/2006 and will not return until 08/15/2006. If you have any questions about Change Management please contact Terri Welsh. For any questions about Business Logistics and IT Applications please contact Jackie Brainin. For status updates for Remedy/IKON please contact Sandy Reed and for Remedy Risk Change Management Lauren Siegler. Thanks. ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Alex Cruz is out of the office.
I will be out of the office starting 08/08/2006 and will not return until 08/13/2006. I will respond to your message when I return. ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
