Re: Impact of renaming Sites in ITSM 7.6.04..
Hey, Leonard –(blast from the past from CW ) ☺ You are right, DLD:SYS:DataWizAudit_Forms is a good starting point. FYI: Because, we had to update tens of thousands of unique sites AND since the Data Wizard is restricted to updating the Site Name and NOT the Site Group and Region; we couldn’t use the Data Wizard either. Like others, had to build our own solution. The fact that one can only update one site name, Support Group, login, Categorization at a time is one reason for the Ideas being submitted on BMC Communities for the Data Wizard. @Joe, I created two SQL scripts to assist me with the initial research. 1. Finds all references to foundation fields including Site, Categories, Support Group, etc. The results list contains the form name, schema Id, fieldname, fielded, data type, etc., of custom and ITSM forms and fields. 2. Unions the list of Region /Site Group / Site combinations found in active records of multiple application and configuration forms that are either custom or base. This will be your target data to update. The workflow to update is all Direct SQL. Warning – this update can still take hours depending on the amount of data you’ll have to change. Sorry for rambling, but hope it helps. Michelle From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Neely, Leonard Sent: Monday, August 04, 2014 10:35 PM To: arslist@ARSLIST.ORG Subject: Re: Impact of renaming Sites in ITSM 7.6.04.. ** In 8.1 (probably earlier versions as well), you can take a look at data in the DLD:SYS:DataWizAudit_Forms form, which should give you a pretty good list of candidate forms to be updated. That may be a good starting point. HTH Leonard Neely From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Thad Esser Sent: Monday, August 04, 2014 5:15 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: Impact of renaming Sites in ITSM 7.6.04.. ** Joe, The data wizard does use SQL to make all of it's updates (at least in 7.0.3, I haven't had to dig that deep in 8.1 yet). Take a look at the DLD:SYS:DataWizardFormFields form (and the other DLD:SYS.. forms). That should get you a good ways toward your goal. Sample screenshot: [Inline image 1] And one other thing that drive me bat-shtir-crazy... On the asset forms, the field labeled Site, has a database name of Building (the field ID is 26001, which is site name everywhere else). The kicker is that the field labeled Site Group has a database name of Site (and a field id that match Site Group every where else). Read that again, this time more carefully. :-) Now, that is only true for the AST forms - on the underlying CMDB forms, the label matches the database name. I hope that helps, Thad On Mon, Aug 4, 2014 at 3:55 PM, Joe D'Souza jdso...@shyle.netmailto:jdso...@shyle.net wrote: ** Yeah I was hoping for a lazy way to find a list too. Looks like I may have to use some fuzzy logic to identify fields containing Site Names. It doesn’t help when the developers might have used different label and database names to store Site Names in different places across all the ITSM apps.. Else it still would have been a relatively easy task to write up a quick SQL script to change it. Joe From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of Rick Westbrock Sent: Monday, August 04, 2014 5:57 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: Impact of renaming Sites in ITSM 7.6.04.. Silly me, I figured the Data Wizard would identify all the forms that would need to be changed, I didn’t account for the fact that it might only have core forms and not extras like WO, SRM etc. I figured at least it might be a good starting point (and it was top of mind since I was using it for something else myself today). -Rick From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of Lucero, Michelle Sent: Monday, August 04, 2014 2:55 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: Impact of renaming Sites in ITSM 7.6.04.. ** Hi, Joe: The Data Wizard is great, but just remember that it doesn’t cover everything. Work Orders is one form that comes to mind. Obviously, custom forms that may have site fields are not covered. But, there are instructions on adding new forms that the Data Wizard will update. You’ll also have to add your own workflow. BEWARE: Only the Site Name is updated using the Data Wizard. One cannot update Region or Site Group. See Ideas on the Data Wizard in BMC Community requesting enhancements to some of the limitations. Ability to rename Region and Site Grouphttps://communities.bmc.com/ideas/2663 Multiple Support Group Rename
Handling RESTful webservice using Atrium SPOON.
Hi Team, We are trying to consume a restful webservice published by external party to get data in JSON/XML format and load data in another form. In our transformation , both source and destination are ar forms. We are using HTTP Client to call restful web service and push the response xml data (coming as multiple) in other form. Please can you advice/suggest how to approach for the same. Really appreciate your help on the same. Regards, Abhi Anand ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: ENGAGE
** Speaking of Unisys folk... my topic just got accepted mid-day on Monday. See you there! Kelly DeaverUnisys Corporation kdea...@kellydeaver.com (ARSlist mail)kelly.dea...@unisys.com(Business mail) Original Message Subject: Re: ENGAGEFrom: Lynn Larsen lynn_lar...@mmi.netDate: Mon, August 04, 2014 10:04 amTo: arslist@ARSLIST.ORG** So LJ is going… aside from the Unisys folks that we know will be there, who else WILL be attending from our string of conversation here?? From:Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWingSent:Monday, August 04, 2014 9:00 AMTo:arslist@ARSLIST.ORGSubject:Re: ENGAGE ** Apparently...the process took a bit longer than anticipatedone of my two topics got accepted, so it appears I WILL be attending Engage this year :) It appears that the content of sessions has shifted a bit in the last week. I reported 120 at the end of last Monday. As of this exact moment, there are only 102 active sessions, 41 are Remedy related, 11 by non BMCers, and 4 are technical. So, the numbers are shifting a bitbut my topic isn't in that list yet, but it titled 'Remedy Java API – Basic Components' where I plan on discussing how the API is structured, how the objects relate to what you see in Remedy Dev Studio as well as Mid-Tier, and how to manipulate your Remedy system through the API to get the best out of it. :)... I'm hopeful at this point that Engage is morphing into something a bit more acceptable to the many technical resources we have here on the list. On Mon, Jul 28, 2014 at 6:27 PM, LJ LongWing lj.longw...@gmail.com wrote: I guess the best 'rejection letter' you can possibly get is the accepted list coming out and not being able to find yourself anywhere on there. Looking through the sessions, I see there are 120 sessions total. 46 are 'Remedy' related, that's ITSM or ROD (38%) in some way or another. Of those only 12 are not being done by BMCers (10%). 4 of those are listed as 'Technical' (3%). All 4 of them are directly related to ITSM (3 SRM, 1 CMDB). Nothing that's directly related to Remedy as a development platform, but as a platform to sell their OOTB toolspart of me is disappointed, but not surprised. Both of the topics I submitted were of a technical nature, relating to Remedy, not ITSM...so, I guess that's likely why neither topic was selected for presentation and due due to the fact that I was counting on not paying the admission fees, I'm not going to be able to justify the expense to attend this year...so...maybe I'll do them anyway, but post them on my site instead so everyone can benefit instead of just the ones that attend Engage...who knows. On Mon, Jul 28, 2014 at 5:57 PM, Jason Miller jason.mil...@gmail.com wrote: ** By doing our own thing we would simply be creating an overlay on ENGAGE. Once we create the overlay we can customize and changes by BMC won't have an impact. Except if they delete one of us in base, that will have an impact on the overlay. On Mon, Jul 28, 2014 at 4:42 PM, Tauf Chowdhury taufc...@gmail.com wrote: ** Not if you do it from a hotel room though? I'll pitch in for a suite. We can set up a google hang out and a live tweet session. On Mon, Jul 28, 2014 at 7:40 PM, laurent matheo lm...@me.com wrote: ** Yeah I proposed this... Somekind of "genius bar" or something, maybe panel like, or small breakouts or something...Could have been setup like a "mini community onsite" using Matt for this...Maybe we could squat the booth location for this when it's not attended? If it's like wwrug, it's just opened for lunch / not a long time, we could use the place to do some small groups about a theme or something?So, a mix between the "bird the feathers", "genius bar", "community" and whatever?We could even stream it live on the net so the others could see it (that could be a problem with BMC rules though). On 29 Jul, 2014,at 01:36 AM, Tauf Chowdhury taufc...@gmail.com wrote: ** I was willing to sponsor a technical/learning lab at the conference. Reached out to numerous people. Deaf ears. Oh well... I'm still going. Love networking (by networking I mean drinking) with you guys if you decide to go. On Mon, Jul 28, 2014 at 7:33 PM, Tauf Chowdhury taufc...@gmail.com wrote: In browsing through the sessions and speakers, the title of unnamed speaker pretty much sums up my assessment of the catalog:LeadTechnicalMarketingConsultant On Mon, Jul 28, 2014 at 7:31 PM, laurent matheo lm...@me.com wrote: ** The evening is still there, Tuesday from 6 to 8 PM:http://www.eventmgmt.aimia.com/events/bmc-engage-2014/custom-20-2bc888d975f2496db5d3f819b9735209.aspxBut that's weird... Since breakouts continue from 6 to 9 PM on tuesday... So or you go stalk the Engineers (and potentially miss 2 breakouts), or you attend the breakouts (and miss the candy)? On 29 Jul, 2014,at 01:26 AM, Rick Cook remedyr...@gmail.com wrote:
Re: ENGAGE
Congrats! On Aug 5, 2014 5:31 AM, Kelly Deaver kdea...@kellydeaver.com wrote: ** Speaking of Unisys folk... my topic just got accepted mid-day on Monday. See you there! Kelly Deaver Unisys Corporation kdea...@kellydeaver.com (ARSlist mail) kelly.dea...@unisys.com kelly.ctr.dea...@faa.gov (Business mail) Original Message Subject: Re: ENGAGE From: Lynn Larsen lynn_lar...@mmi.net Date: Mon, August 04, 2014 10:04 am To: arslist@ARSLIST.ORG ** So LJ is going… aside from the Unisys folks that we know will be there, who else WILL be attending from our string of conversation here?? *From:* Action Request System discussion list(ARSList) [ mailto:arslist@ARSLIST.ORG arslist@ARSLIST.ORG] *On Behalf Of *LJ LongWing *Sent:* Monday, August 04, 2014 9:00 AM *To:* arslist@ARSLIST.ORG *Subject:* Re: ENGAGE ** Apparently...the process took a bit longer than anticipatedone of my two topics got accepted, so it appears I WILL be attending Engage this year :) It appears that the content of sessions has shifted a bit in the last week. I reported 120 at the end of last Monday. As of this exact moment, there are only 102 active sessions, 41 are Remedy related, 11 by non BMCers, and 4 are technical. So, the numbers are shifting a bitbut my topic isn't in that list yet, but it titled 'Remedy Java API – Basic Components' where I plan on discussing how the API is structured, how the objects relate to what you see in Remedy Dev Studio as well as Mid-Tier, and how to manipulate your Remedy system through the API to get the best out of it. :)... I'm hopeful at this point that Engage is morphing into something a bit more acceptable to the many technical resources we have here on the list. On Mon, Jul 28, 2014 at 6:27 PM, LJ LongWing lj.longw...@gmail.com wrote: I guess the best 'rejection letter' you can possibly get is the accepted list coming out and not being able to find yourself anywhere on there. Looking through the sessions, I see there are 120 sessions total. 46 are 'Remedy' related, that's ITSM or ROD (38%) in some way or another. Of those only 12 are not being done by BMCers (10%). 4 of those are listed as 'Technical' (3%). All 4 of them are directly related to ITSM (3 SRM, 1 CMDB). Nothing that's directly related to Remedy as a development platform, but as a platform to sell their OOTB toolspart of me is disappointed, but not surprised. Both of the topics I submitted were of a technical nature, relating to Remedy, not ITSM...so, I guess that's likely why neither topic was selected for presentation and due due to the fact that I was counting on not paying the admission fees, I'm not going to be able to justify the expense to attend this year...so...maybe I'll do them anyway, but post them on my site instead so everyone can benefit instead of just the ones that attend Engage...who knows. On Mon, Jul 28, 2014 at 5:57 PM, Jason Miller jason.mil...@gmail.com wrote: ** By doing our own thing we would simply be creating an overlay on ENGAGE. Once we create the overlay we can customize and changes by BMC won't have an impact. Except if they delete one of us in base, that will have an impact on the overlay. On Mon, Jul 28, 2014 at 4:42 PM, Tauf Chowdhury taufc...@gmail.com wrote: ** Not if you do it from a hotel room though? I'll pitch in for a suite. We can set up a google hang out and a live tweet session. On Mon, Jul 28, 2014 at 7:40 PM, laurent matheo lm...@me.com wrote: ** Yeah I proposed this... Somekind of genius bar or something, maybe panel like, or small breakouts or something... Could have been setup like a mini community onsite using Matt for this... Maybe we could squat the booth location for this when it's not attended? If it's like wwrug, it's just opened for lunch / not a long time, we could use the place to do some small groups about a theme or something? So, a mix between the bird the feathers, genius bar, community and whatever? We could even stream it live on the net so the others could see it (that could be a problem with BMC rules though). On 29 Jul, 2014,at 01:36 AM, Tauf Chowdhury taufc...@gmail.com wrote: ** I was willing to sponsor a technical/learning lab at the conference. Reached out to numerous people. Deaf ears. Oh well... I'm still going. Love networking (by networking I mean drinking) with you guys if you decide to go. On Mon, Jul 28, 2014 at 7:33 PM, Tauf Chowdhury taufc...@gmail.com wrote: In browsing through the sessions and speakers, the title of unnamed speaker pretty much sums up my assessment of the catalog: Lead Technical Marketing Consultant On Mon, Jul 28, 2014 at 7:31 PM, laurent matheo lm...@me.com wrote: ** The evening is still there, Tuesday from 6 to 8 PM: http://www.eventmgmt.aimia.com/events/bmc-engage-2014/custom-20-2bc888d975f2496db5d3f819b9735209.aspx But that's weird... Since breakouts continue
Completed history of North American Remedy User Group annual conferences
The following is complete for the North American RUGs, we are working on the annual outside of NA. Note: the information is from a combination of sources including a few posts on the ARSlist, the archives Doug Mueller searched, Ed Reynolds and Doug Blair's attics (mind, email and boxes), and my email history: 1993 Santa Clara Westin Hotel June 3-4 RUG Remedy Corp. 1994 Santa Clara Westin Hotel June 6-8 RUG Remedy Corp. 1995 Burlingame Airport MarriottJune 5-7 RUG Remedy Corp. 1996 Burlingame Hyatt Regency June 2-5 RUG Remedy Corp. 1997 Burlingame Hyatt Regency June 2-5 RUG Remedy Corp. 1998 San Francisco Marriott June 22-26 RUG Remedy Corp. 1999 DisneyLand Disneyland Hotel July 18-22RUG Remedy Corp. 2000 Santa Clara Santa Clara Convention CenterJune 4-8 RUG Remedy Corp. 2001 Disney World Swan and Dolphin Resort July 30 to Aug 3 RUG Remedy Corp. 2002 San DiegoSan Diego Convention Center March 3-7 Synergy Peregrine 2003 San Francisco Hilton April 6-10 RUG BMC 2004 Washington DC Rennaisance Hilton July 26-29RUG BMC 2005 San Jose San Jose McEnery Convention Center July 11-15RUG BMC 2006 San Francisco Hilton Aug 28-Sept 1 BMC UserWorld BMC 2007 Vancouver Vancouver Convention Exhibition Center Oct 28-Nov. 2 BMC UserWorld BMC 2008 NONE 2009 Las VegasHard Rock HotelNov 9-13 RUG WWRUG 2010 Las VegasHard Rock HotelOct 18-22 RUG WWRUG 2011 Alexandria, VAHilton Alexandria Mark Center Sep 19-23 RUG WWRUG 2012 San Jose Fairmont Oct 15-19RUG WWRUG 2013 San Jose Fairmont Sep 30-Oct 4 RUG WWRUG 2014 Disney World Swan and Dolphin Resort Oct 13-16 BMC Engage BMC If you spot any errors or omissions, have information on the outside of NA RUGs, please let us know. Thanks Dan ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
QQ: MSSQL server name / Instance name issue
I am sure I am just missing the obvious today.. Win: 2012 - connecting to an instance of the 2012 sql server Servername :: NAME-W12-SQL-1\REMEDY,1435(mssql connection settings) Instance name :: remedy SA password it says:: - The instance name *REMEDY *is not valid for the host *NAME-w12-sql-1* / port *1435* -Detected the SQLServer instance *NAME-W12-SQL-1\ REMEDY* for the host *dtg-w12-sql-1* / port *1435* *So I put in the following::* hostname NAME-W12-SQL-1\REMEDY Instance name : remedy System installer says: - he installer is unable to resolve NAME-w12-sql-1\REMEDY into an IP address.Clients cannot communicate to the Server unless they can resolve into an IP address If I put in the IP address \ REMEDY is says same thing. I know it is something silly, it must be the fly on my nose (too close). if I put in NAME-W12-SQL-1 (it says it should be the above) do I need to create some sort of Alias? like in the /etc/hosts? or registry? for it to get accepted. -- Patrick Zandi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Completed history of North American Remedy User Group annual conferences
Hi Dan, Thanks for compiling the complete RUG list, very interesting. We had a pretty good RUG in Australia in 2000. It was called the Asia Pacific Remedy User Group and went from May 1-4 2000 at the ANA Hotel in Sydney. I'm pretty sure this was the only one run by the user group and of a similar scale to the ones held in the US. I guess the organiser was the Sydney Remedy User Group, not Remedy Corp though they did support it, just as BMC have supported recent user run RUGs. I think that this RUG should be counted as one of the official RUGs and provide credit to toward the RUG count on the conference IDs assuming BMC retains this RUG feature. Rod On 5 August 2014 22:19, arslist arsl...@danielbloom.ca wrote: ** The following is complete for the North American RUGs, we are working on the annual outside of NA. Note: the information is from a combination of sources including a few posts on the ARSlist, the archives Doug Mueller searched, Ed Reynolds and Doug Blair’s attics (mind, email and boxes), and my email history: 1993 Santa Clara Westin Hotel June 3-4 RUG Remedy Corp. 1994 Santa Clara Westin Hotel June 6-8 RUG Remedy Corp. 1995 Burlingame Airport MarriottJune 5-7 RUG Remedy Corp. 1996 Burlingame Hyatt Regency June 2-5 RUG Remedy Corp. 1997 Burlingame Hyatt Regency June 2-5 RUG Remedy Corp. 1998 San Francisco Marriott June 22-26 RUG Remedy Corp. 1999 DisneyLand Disneyland Hotel July 18-22RUG Remedy Corp. 2000 Santa Clara Santa Clara Convention CenterJune 4-8 RUG Remedy Corp. 2001 Disney World Swan and Dolphin Resort July 30 to Aug 3 RUG Remedy Corp. 2002 San DiegoSan Diego Convention Center March 3-7 Synergy Peregrine 2003 San Francisco Hilton April 6-10 RUG BMC 2004 Washington DC Rennaisance Hilton July 26-29RUG BMC 2005 San Jose San Jose McEnery Convention Center July 11-15RUG BMC 2006 San Francisco Hilton Aug 28-Sept 1 BMC UserWorld BMC 2007 Vancouver Vancouver Convention Exhibition CenterOct 28-Nov. 2 BMC UserWorld BMC 2008 NONE 2009 Las VegasHard Rock HotelNov 9-13 RUG WWRUG 2010 Las VegasHard Rock HotelOct 18-22RUG WWRUG 2011 Alexandria, VAHilton Alexandria Mark Center Sep 19-23RUG WWRUG 2012 San Jose Fairmont Oct 15-19RUG WWRUG 2013 San Jose Fairmont Sep 30-Oct 4 RUG WWRUG 2014 Disney World Swan and Dolphin Resort Oct 13-16BMC Engage BMC If you spot any errors or omissions, have information on the outside of NA RUGs, please let us know. Thanks Dan _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Handling RESTful webservice using Atrium SPOON.
Hi Experts, Anyone having any idea on it ,please revert back ASAP. Regards, Abhishek A ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: ENGAGE
A favorite from my area is Pendleton (Let er buck!). May have to bring a bottle to share. ☺ Jim From: Jason Miller [mailto:jason.mil...@gmail.com] Sent: Monday, August 04, 2014 2:19 PM Subject: Re: ENGAGE ** I caught the end of the tasting; where I met my new love... Templeton. I forget who brought their homemade stuff and what it was called but I think I was breathing fire for a little while after that. To answer Lynn's question I am all registered up to be at ENGAGE Jason On Mon, Aug 4, 2014 at 11:18 AM, Joe D'Souza jdso...@shyle.netmailto:jdso...@shyle.net wrote: ** I still recall our whiskey tasting night that we had at Misi’s Phil’s room. Some of that European Whiskey is downright awesome! Joe From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of Shellman, David Sent: Monday, August 04, 2014 2:14 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: ENGAGE Of all the years that I’ve known Misi and Magnus, I’ve never seen them turn down a free drink. If they do, beware as that would be a sign that they are sick. Dave From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of Scott Philben Sent: Monday, August 04, 2014 2:12 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: ENGAGE ** Will you be accepting free drinks? We definitely owe you big for the use of some of your products... On Aug 04, 2014, at 02:03 PM, Misi Mladoniczky m...@rrr.semailto:m...@rrr.se wrote: Hi, Me and Magnus will definitely be there. Best Regards - Misi, RRR AB, http://rrr.se So LJ is going… aside from the Unisys folks that we know will be there, who else WILL be attending from our string of conversation here?? From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: Monday, August 04, 2014 9:00 AM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: ENGAGE ** Apparently...the process took a bit longer than anticipatedone of my two topics got accepted, so it appears I WILL be attending Engage this year :) It appears that the content of sessions has shifted a bit in the last week. I reported 120 at the end of last Monday. As of this exact moment, there are only 102 active sessions, 41 are Remedy related, 11 by non BMCers, and 4 are technical. So, the numbers are shifting a bitbut my topic isn't in that list yet, but it titled 'Remedy Java API – Basic Components' where I plan on discussing how the API is structured, how the objects relate to what you see in Remedy Dev Studio as well as Mid-Tier, and how to manipulate your Remedy system through the API to get the best out of it. :)... I'm hopeful at this point that Engage is morphing into something a bit more acceptable to the many technical resources we have here on the list. On Mon, Jul 28, 2014 at 6:27 PM, LJ LongWing lj.longw...@gmail.commailto:lj.longw...@gmail.commailto:lj.longw...@gmail.commailto:lj.longw...@gmail.com wrote: I guess the best 'rejection letter' you can possibly get is the accepted list coming out and not being able to find yourself anywhere on there. Looking through the sessions, I see there are 120 sessions total. 46 are 'Remedy' related, that's ITSM or ROD (38%) in some way or another. Of those only 12 are not being done by BMCers (10%). 4 of those are listed as 'Technical' (3%). All 4 of them are directly related to ITSM (3 SRM, 1 CMDB). Nothing that's directly related to Remedy as a development platform, but as a platform to sell their OOTB toolspart of me is disappointed, but not surprised. Both of the topics I submitted were of a technical nature, relating to Remedy, not ITSM...so, I guess that's likely why neither topic was selected for presentation and due due to the fact that I was counting on not paying the admission fees, I'm not going to be able to justify the expense to attend this year...so...maybe I'll do them anyway, but post them on my site instead so everyone can benefit instead of just the ones that attend Engage...who knows. On Mon, Jul 28, 2014 at 5:57 PM, Jason Miller jason.mil...@gmail.commailto:jason.mil...@gmail.commailto:jason.mil...@gmail.commailto:jason.mil...@gmail.com wrote: ** By doing our own thing we would simply be creating an overlay on ENGAGE. Once we create the overlay we can customize and changes by BMC won't have an
Re: MSSQL server name / Instance name issue
Patrick: Years ago (maybe ARS 4.x?) I encountered a problem where the application server wouldn't connect to a database instance if the name was longer than 12 characters. Maybe try creating an alias in the LMHOSTS file? FWIW, --Phil From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] On Behalf Of patrick zandi [remedy...@gmail.com] Sent: Tuesday, August 05, 2014 08:38 To: arslist@ARSLIST.ORG Subject: QQ: MSSQL server name / Instance name issue ** I am sure I am just missing the obvious today.. Win: 2012 - connecting to an instance of the 2012 sql server Servername :: NAME-W12-SQL-1\REMEDY,1435(mssql connection settings) Instance name :: remedy SA password it says:: * The instance name REMEDY is not valid for the host NAME-w12-sql-1 / port 1435 * Detected the SQLServer instance NAME-W12-SQL-1\ REMEDY for the host dtg-w12-sql-1 / port 1435 So I put in the following:: hostname NAME-W12-SQL-1\REMEDY Instance name : remedy System installer says: * he installer is unable to resolve NAME-w12-sql-1\REMEDY into an IP address.Clients cannot communicate to the Server unless they can resolve into an IP address If I put in the IP address \ REMEDY is says same thing. I know it is something silly, it must be the fly on my nose (too close). if I put in NAME-W12-SQL-1 (it says it should be the above) do I need to create some sort of Alias? like in the /etc/hosts? or registry? for it to get accepted. -- Patrick Zandi _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: ENGAGE
So is it time to get back on topic or change the subject? *:o) Dave From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jason Miller Sent: Monday, August 04, 2014 4:40 PM To: arslist@ARSLIST.ORG Subject: Re: ENGAGE ** Holycow! This thread well over 100 replies (not sure why my Gmail split it). My guess is we are not even close to being finished with it either. [cid:image002.jpg@01CFB08F.47F58B80] On Mon, Aug 4, 2014 at 1:34 PM, Joe D'Souza jdso...@shyle.netmailto:jdso...@shyle.net wrote: ** Yup I remember. We had a group photo if I recall that we took when sampling that bottle ☺ Phil tried it the next day and found it a bit too strong. I loved it! Joe From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of Danny Kellett Sent: Monday, August 04, 2014 4:31 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: ENGAGE Carl brought that. I think he exchanged them for some manchester united top. -- Original Message -- From: Joe D'Souza jdso...@shyle.netmailto:jdso...@shyle.net To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Sent: 04/08/2014 21:21:29 Subject: Re: ENGAGE ** I bought Templeton Rye a couple of times at least.. And got a couple of my friends to try it at a bar in NYC.. Joe From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of Danny Kellett Sent: Monday, August 04, 2014 4:08 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: ENGAGE I bought a bottle of laphroaig when I got home based on that tasting night :) Kind regards Danny -- Original Message -- From: Joe D'Souza jdso...@shyle.netmailto:jdso...@shyle.net To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Sent: 04/08/2014 19:18:48 Subject: Re: ENGAGE ** I still recall our whiskey tasting night that we had at Misi’s Phil’s room. Some of that European Whiskey is downright awesome! Joe From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of Shellman, David Sent: Monday, August 04, 2014 2:14 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: ENGAGE Of all the years that I’ve known Misi and Magnus, I’ve never seen them turn down a free drink. If they do, beware as that would be a sign that they are sick. Dave From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of Scott Philben Sent: Monday, August 04, 2014 2:12 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: ENGAGE ** Will you be accepting free drinks? We definitely owe you big for the use of some of your products... On Aug 04, 2014, at 02:03 PM, Misi Mladoniczky m...@rrr.semailto:m...@rrr.se wrote: Hi, Me and Magnus will definitely be there. Best Regards - Misi, RRR AB, http://rrr.se/ So LJ is going… aside from the Unisys folks that we know will be there, who else WILL be attending from our string of conversation here?? From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: Monday, August 04, 2014 9:00 AM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: ENGAGE ** Apparently...the process took a bit longer than anticipatedone of my two topics got accepted, so it appears I WILL be attending Engage this year :) It appears that the content of sessions has shifted a bit in the last week. I reported 120 at the end of last Monday. As of this exact moment, there are only 102 active sessions, 41 are Remedy related, 11 by non BMCers, and 4 are technical. So, the numbers are shifting a bitbut my topic isn't in that list yet, but it titled 'Remedy Java API – Basic Components' where I plan on discussing how the API is structured, how the objects relate to what you see in Remedy Dev Studio as well as Mid-Tier, and how to manipulate your Remedy system through the API to get the best out of it. :)... I'm hopeful at this point that Engage is morphing into something a bit more acceptable to the many technical resources we have here on the list. On Mon, Jul 28, 2014 at 6:27 PM, LJ LongWing lj.longw...@gmail.commailto:lj.longw...@gmail.commailto:lj.longw...@gmail.commailto:lj.longw...@gmail.com wrote: I guess the best 'rejection letter' you can possibly get is the accepted list coming out and not being able to find yourself anywhere on there. Looking through the sessions, I see there are 120 sessions
Re: ENGAGE
Can the tasting be a BMC sponsored event? If so can we add some red wines? Like a Revana 2009 Cab, a Chehalem 2006 Pinot and maybe some of the Blackbirds? hbr From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jim Coryat (jcoryat) Sent: Tuesday, August 05, 2014 9:19 AM To: arslist@ARSLIST.ORG Subject: Re: [arslist] ENGAGE ** A favorite from my area is Pendleton (Let er buck!). May have to bring a bottle to share. ☺ Jim From: Jason Miller [mailto:jason.mil...@gmail.com] Sent: Monday, August 04, 2014 2:19 PM Subject: Re: ENGAGE ** I caught the end of the tasting; where I met my new love... Templeton. I forget who brought their homemade stuff and what it was called but I think I was breathing fire for a little while after that. To answer Lynn's question I am all registered up to be at ENGAGE Jason On Mon, Aug 4, 2014 at 11:18 AM, Joe D'Souza jdso...@shyle.netmailto:jdso...@shyle.net wrote: ** I still recall our whiskey tasting night that we had at Misi’s Phil’s room. Some of that European Whiskey is downright awesome! Joe From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of Shellman, David Sent: Monday, August 04, 2014 2:14 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: ENGAGE Of all the years that I’ve known Misi and Magnus, I’ve never seen them turn down a free drink. If they do, beware as that would be a sign that they are sick. Dave From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of Scott Philben Sent: Monday, August 04, 2014 2:12 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: ENGAGE ** Will you be accepting free drinks? We definitely owe you big for the use of some of your products... On Aug 04, 2014, at 02:03 PM, Misi Mladoniczky m...@rrr.semailto:m...@rrr.se wrote: Hi, Me and Magnus will definitely be there. Best Regards - Misi, RRR AB, http://rrr.se So LJ is going… aside from the Unisys folks that we know will be there, who else WILL be attending from our string of conversation here?? From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: Monday, August 04, 2014 9:00 AM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: ENGAGE ** Apparently...the process took a bit longer than anticipatedone of my two topics got accepted, so it appears I WILL be attending Engage this year :) It appears that the content of sessions has shifted a bit in the last week. I reported 120 at the end of last Monday. As of this exact moment, there are only 102 active sessions, 41 are Remedy related, 11 by non BMCers, and 4 are technical. So, the numbers are shifting a bitbut my topic isn't in that list yet, but it titled 'Remedy Java API – Basic Components' where I plan on discussing how the API is structured, how the objects relate to what you see in Remedy Dev Studio as well as Mid-Tier, and how to manipulate your Remedy system through the API to get the best out of it. :)... I'm hopeful at this point that Engage is morphing into something a bit more acceptable to the many technical resources we have here on the list. On Mon, Jul 28, 2014 at 6:27 PM, LJ LongWing lj.longw...@gmail.commailto:lj.longw...@gmail.commailto:lj.longw...@gmail.commailto:lj.longw...@gmail.com wrote: I guess the best 'rejection letter' you can possibly get is the accepted list coming out and not being able to find yourself anywhere on there. Looking through the sessions, I see there are 120 sessions total. 46 are 'Remedy' related, that's ITSM or ROD (38%) in some way or another. Of those only 12 are not being done by BMCers (10%). 4 of those are listed as 'Technical' (3%). All 4 of them are directly related to ITSM (3 SRM, 1 CMDB). Nothing that's directly related to Remedy as a development platform, but as a platform to sell their OOTB toolspart of me is disappointed, but not surprised. Both of the topics I submitted were of a technical nature, relating to Remedy, not ITSM...so, I guess that's likely why neither topic was selected for presentation and due due to the fact that I was counting on not paying the admission fees, I'm not going to be able to justify the expense to attend this year...so...maybe I'll do them anyway, but post them on my site instead so everyone can benefit instead of just the ones that attend Engage...who knows.
SAML Integration
Does anyone know if it's possible to do a SAML integration with ARS/ITSM? We use LDAP for internal customers but trying to find a way to give external customers a single sign on with several of our systems. I am doing my research and hoped someone else has already tried this. Thank you! ~~~ Terri ARS 7.6.03 ITSM 7.6.03 Midtier 7.6.04 Windows 2008 MS SQL 2008 R2 SP2 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: SAML Integration
Terri, I haven't done the actual integration but I know that's what Remedy on Demand uses to authenticate via Atrium SSO Sent from my iPhone On Aug 5, 2014, at 9:57 AM, Terri Lockwood teresa.lockw...@sungard.com wrote: ** Does anyone know if it’s possible to do a SAML integration with ARS/ITSM? We use LDAP for internal customers but trying to find a way to give external customers a single sign on with several of our systems. I am doing my research and hoped someone else has already tried this. Thank you! ~~~ Terri ARS 7.6.03 ITSM 7.6.03 Midtier 7.6.04 Windows 2008 MS SQL 2008 R2 SP2 _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: MSSQL server name / Instance name issue
I believe it is telling you it wants just the server nameNAME-w12-sql-1 as a slash is not valid in the name of a machine · The installer is unable to resolve NAME-w12-sql-1\REMEDY into an IP address. .Clients cannot communicate to the Server unless they can resolve into an IP address Fred From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Murnane, Phil Sent: Tuesday, August 05, 2014 8:23 AM To: arslist@ARSLIST.ORG Subject: Re: MSSQL server name / Instance name issue ** Patrick: Years ago (maybe ARS 4.x?) I encountered a problem where the application server wouldn't connect to a database instance if the name was longer than 12 characters. Maybe try creating an alias in the LMHOSTS file? FWIW, --Phil From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] On Behalf Of patrick zandi [remedy...@gmail.com] Sent: Tuesday, August 05, 2014 08:38 To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: QQ: MSSQL server name / Instance name issue ** I am sure I am just missing the obvious today.. Win: 2012 - connecting to an instance of the 2012 sql server Servername :: NAME-W12-SQL-1\REMEDY,1435(mssql connection settings) Instance name :: remedy SA password it says:: · The instance name REMEDY is not valid for the host NAME-w12-sql-1 / port 1435 · Detected the SQLServer instance NAME-W12-SQL-1\ REMEDY for the host dtg-w12-sql-1 / port 1435 So I put in the following:: hostname NAME-W12-SQL-1\REMEDY Instance name : remedy System installer says: · The installer is unable to resolve NAME-w12-sql-1\REMEDY into an IP address.Clients cannot communicate to the Server unless they can resolve into an IP address If I put in the IP address \ REMEDY is says same thing. I know it is something silly, it must be the fly on my nose (too close). if I put in NAME-W12-SQL-1 (it says it should be the above) do I need to create some sort of Alias? like in the /etc/hosts? or registry? for it to get accepted. -- Patrick Zandi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: MSSQL server name / Instance name issue
but if I take the slash out and put it into the instance name it fails as well. DB Information: Hostname or IP :: Hostname IP instance name : blank --- invalid instance if Hostname or IP :: Hostname IP instance name : remedy is says Instance name remedy is not validfor host ip/port Detected the sql server instance name-w12-sql-1\remedy for the host ip /port 1435 It tells you what it should be but cannot accept it.. On Tue, Aug 5, 2014 at 10:27 AM, Grooms, Frederick W frederick.w.gro...@xo.com wrote: ** I believe it is telling you it wants just the server name NAME-w12-sql-1 as a slash is not valid in the name of a machine · The installer is unable to resolve NAME-w12-sql-1\REMEDY into an IP address. .Clients cannot communicate to the Server unless they can resolve into an IP address Fred *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Murnane, Phil *Sent:* Tuesday, August 05, 2014 8:23 AM *To:* arslist@ARSLIST.ORG *Subject:* Re: MSSQL server name / Instance name issue ** Patrick: Years ago (maybe ARS 4.x?) I encountered a problem where the application server wouldn't connect to a database instance if the name was longer than 12 characters. Maybe try creating an alias in the LMHOSTS file? FWIW, --Phil -- *From:* Action Request System discussion list(ARSList) [ arslist@ARSLIST.ORG] On Behalf Of patrick zandi [remedy...@gmail.com] *Sent:* Tuesday, August 05, 2014 08:38 *To:* arslist@ARSLIST.ORG *Subject:* QQ: MSSQL server name / Instance name issue ** I am sure I am just missing the obvious today.. Win: 2012 - connecting to an instance of the 2012 sql server Servername :: NAME-W12-SQL-1\REMEDY,1435(mssql connection settings) Instance name :: remedy SA password it says:: · The instance name *REMEDY *is not valid for the host * NAME-w12-sql-1* / port *1435* · Detected the SQLServer instance *NAME-W12-SQL-1\ REMEDY* for the host *dtg-w12-sql-1* / port *1435* *So I put in the following::* hostname NAME-W12-SQL-1\REMEDY Instance name : remedy System installer says: · The installer is unable to resolve NAME-w12-sql-1\REMEDY into an IP address.Clients cannot communicate to the Server unless they can resolve into an IP address If I put in the IP address \ REMEDY is says same thing. I know it is something silly, it must be the fly on my nose (too close). if I put in NAME-W12-SQL-1 (it says it should be the above) do I need to create some sort of Alias? like in the /etc/hosts? or registry? for it to get accepted. -- Patrick Zandi _ARSlist: Where the Answers Are and have been for 20 years_ -- Patrick Zandi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Tracking Detailed Outage/Maintenance Time
I was thinking of using that same area of the system; makes sense to keep time tracking in the same part of the system. I also was thinking of using a separate form for the new data so as not to break any existing ITSM workflow. Thanks for the input. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: SAML Integration
We used JSS-SSO for single sign via Kerberos and it is working vey well. I believe the product offers SAML integration as well as several other possibilities. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: MSSQL server name / Instance name issue
Lets start with the environment: When logging into MSSQL server management studio I use the following settings. Servername : name-w12-sql-1\remedy instance name : remedy with sa password and Voila.. no problems. if I view connection properties it says: Server name:: name-w12-sql-1/remedy,1435 instance name:: remedy With 2012 sql server you can create seperate instances within itself. hope that makes sense. On Tue, Aug 5, 2014 at 11:11 AM, patrick zandi remedy...@gmail.com wrote: but if I take the slash out and put it into the instance name it fails as well. DB Information: Hostname or IP :: Hostname IP instance name : blank --- invalid instance if Hostname or IP :: Hostname IP instance name : remedy is says Instance name remedy is not validfor host ip/port Detected the sql server instance name-w12-sql-1\remedy for the host ip /port 1435 It tells you what it should be but cannot accept it.. On Tue, Aug 5, 2014 at 10:27 AM, Grooms, Frederick W frederick.w.gro...@xo.com wrote: ** I believe it is telling you it wants just the server name NAME-w12-sql-1 as a slash is not valid in the name of a machine · The installer is unable to resolve NAME-w12-sql-1\REMEDY into an IP address. .Clients cannot communicate to the Server unless they can resolve into an IP address Fred *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Murnane, Phil *Sent:* Tuesday, August 05, 2014 8:23 AM *To:* arslist@ARSLIST.ORG *Subject:* Re: MSSQL server name / Instance name issue ** Patrick: Years ago (maybe ARS 4.x?) I encountered a problem where the application server wouldn't connect to a database instance if the name was longer than 12 characters. Maybe try creating an alias in the LMHOSTS file? FWIW, --Phil -- *From:* Action Request System discussion list(ARSList) [ arslist@ARSLIST.ORG] On Behalf Of patrick zandi [remedy...@gmail.com] *Sent:* Tuesday, August 05, 2014 08:38 *To:* arslist@ARSLIST.ORG *Subject:* QQ: MSSQL server name / Instance name issue ** I am sure I am just missing the obvious today.. Win: 2012 - connecting to an instance of the 2012 sql server Servername :: NAME-W12-SQL-1\REMEDY,1435(mssql connection settings) Instance name :: remedy SA password it says:: · The instance name *REMEDY *is not valid for the host * NAME-w12-sql-1* / port *1435* · Detected the SQLServer instance *NAME-W12-SQL-1\ REMEDY* for the host *dtg-w12-sql-1* / port *1435* *So I put in the following::* hostname NAME-W12-SQL-1\REMEDY Instance name : remedy System installer says: · The installer is unable to resolve NAME-w12-sql-1\REMEDY into an IP address.Clients cannot communicate to the Server unless they can resolve into an IP address If I put in the IP address \ REMEDY is says same thing. I know it is something silly, it must be the fly on my nose (too close). if I put in NAME-W12-SQL-1 (it says it should be the above) do I need to create some sort of Alias? like in the /etc/hosts? or registry? for it to get accepted. -- Patrick Zandi _ARSlist: Where the Answers Are and have been for 20 years_ -- Patrick Zandi -- Patrick Zandi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
https vs http when using web service and a load balancer.
Hi everyone: I was wondering if anyone came across this before when developing and consuming Remedy Web Services: ARSystem - 8.1.01 ITSM - 8.1.01 Here is the configuration: I have two mid-tiers running on port 8080 (tomcat) front-ended by a load-balancer that has a virtual-IP and hostname that is running on port 8443. I have the certificate associated to port 8443 on the load balancer and it does a least connection selection of which mid-tier to use. It also decrypts the data from a secure connection (https) to a non-secure connection (http) when passing to the mid-tiers. I am using this method as I can freely add new mid-tiers without requiring additional certificates from my certificate authority (CA) . I am using a Citrix Netscaler to perform the load balancing. These mid-tiers are used only for web-services and no concurrent user sessions. However, to test it, I can log into Remedy via the load-balancer and have verified that it works just fine. To give you a clearer picture, the web service consumer connects like the following: https://loadbalancerfqdn:8443 [1] and it load-balances to the midtiers as follows: http://midtier1:8080 [2] http://midtier2:8080 [3] The issue I have is this. If I look at the WSDL associated to my webservice (let's call it MYWEBSERVICE), I can get the WSDL to display via the following: https://loadbalancerfqdn:8443:/arsys/WSDL/public/remedyservername/MYWEBSERVICE [4] If I look inside the web service WSDL, the port binding to the actual web service is : soap:address location=http://loadbalancerfqdn:8443:/arsys/WSDL/public/remedyservername/MYWEBSERVICE [5]/ (notice above it is http not https! ). When I try to call it, I obviously get errors. I am wondering, how do I get the remedy-provided WSDL to indicate https instead of http in the binding ? Is this because I am front-ending this via a https-based load balancer ? Can I do this ? Any ideas ? Terry Links: -- [1] https://loadbalancerfqdn:8443 [2] http://midtier1:8080 [3] http://midtier2:8080 [4] https://loadbalancerfqdn:8443:/arsys/WSDL/public/remedyservername/MYWEBSERVICE [5] http://loadbalancerfqdn:8443:/arsys/WSDL/public/remedyservername/MYWEBSERVICE ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Tracking Detailed Outage/Maintenance Time
Yeah, I had the separate form as well and was thinking of pushing the start/stop clock info to it but that thing is so clunky, I just disabled and hid the buttons altogether. Sent from my iPhone On Aug 5, 2014, at 11:11 AM, Frank Caruso caruso.fr...@gmail.com wrote: I was thinking of using that same area of the system; makes sense to keep time tracking in the same part of the system. I also was thinking of using a separate form for the new data so as not to break any existing ITSM workflow. Thanks for the input. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: https vs http when using web service and a load balancer.
Terry, Yes, it's because the Web server is only http, but the value in that is only 'arbitrary'...meaning that it's just how the web server knows to reference itselfso, if you turn it into a wsdl file, or once you load it into SoapUI, or some other tool, you can simply manually add the s, or point to individual nodes, or really...whatever you want without issue, as long as it can connect. In short, I'm not sure how to get the web server to know that the client is using an https, but what the WSDL thinks is irrelevant as long as you are using the proper one to actually connect. On Tue, Aug 5, 2014 at 9:43 AM, Terry Bootsma tboot...@objectpath.com wrote: ** Hi everyone: I was wondering if anyone came across this before when developing and consuming Remedy Web Services: ARSystem - 8.1.01 ITSM – 8.1.01 Here is the configuration: I have two mid-tiers running on port 8080 (tomcat) front-ended by a load-balancer that has a virtual-IP and hostname that is running on port 8443. I have the certificate associated to port 8443 on the load balancer and it does a “least connection” selection of which mid-tier to use. It also “decrypts” the data from a secure connection (https) to a non-secure connection (http) when passing to the mid-tiers. I am using this method as I can freely add new mid-tiers without requiring additional certificates from my certificate authority (CA) . I am using a Citrix Netscaler to perform the load balancing. These mid-tiers are used only for web-services and no concurrent user sessions. However, to test it, I can log into Remedy via the load-balancer and have verified that it works just fine. To give you a clearer picture, the web service consumer connects like the following: https://loadbalancerfqdn:8443 and it load-balances to the midtiers as follows: http://midtier1:8080 http://midtier2:8080 The issue I have is this. If I look at the WSDL associated to my webservice (let’s call it MYWEBSERVICE), I can get the WSDL to display via the following: https://loadbalancerfqdn:8443:/arsys/WSDL/public/remedyservername/MYWEBSERVICE If I look inside the web service WSDL, the port binding to the actual web service is : soap:address location=”http ://loadbalancerfqdn:8443:/arsys/WSDL/public/remedyservername/MYWEBSERVICE ””/ (notice above it is http not https! ). When I try to call it, I obviously get errors. I am wondering, how do I get the remedy-provided WSDL to indicate https instead of http in the binding ? Is this because I am front-ending this via a https-based load balancer ? Can I do this ? Any ideas ? Terry _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: MSSQL server name / Instance name issue
it is a NAMED INSTANCE on the SQL Server... that is why the ip/named instancethen the instance name (which is different). On Tue, Aug 5, 2014 at 11:39 AM, patrick zandi remedy...@gmail.com wrote: Lets start with the environment: When logging into MSSQL server management studio I use the following settings. Servername : name-w12-sql-1\remedy instance name : remedy with sa password and Voila.. no problems. if I view connection properties it says: Server name:: name-w12-sql-1/remedy,1435 instance name:: remedy With 2012 sql server you can create seperate instances within itself. hope that makes sense. On Tue, Aug 5, 2014 at 11:11 AM, patrick zandi remedy...@gmail.com wrote: but if I take the slash out and put it into the instance name it fails as well. DB Information: Hostname or IP :: Hostname IP instance name : blank --- invalid instance if Hostname or IP :: Hostname IP instance name : remedy is says Instance name remedy is not validfor host ip/port Detected the sql server instance name-w12-sql-1\remedy for the host ip /port 1435 It tells you what it should be but cannot accept it.. On Tue, Aug 5, 2014 at 10:27 AM, Grooms, Frederick W frederick.w.gro...@xo.com wrote: ** I believe it is telling you it wants just the server name NAME-w12-sql-1 as a slash is not valid in the name of a machine · The installer is unable to resolve NAME-w12-sql-1\REMEDY into an IP address. .Clients cannot communicate to the Server unless they can resolve into an IP address Fred *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Murnane, Phil *Sent:* Tuesday, August 05, 2014 8:23 AM *To:* arslist@ARSLIST.ORG *Subject:* Re: MSSQL server name / Instance name issue ** Patrick: Years ago (maybe ARS 4.x?) I encountered a problem where the application server wouldn't connect to a database instance if the name was longer than 12 characters. Maybe try creating an alias in the LMHOSTS file? FWIW, --Phil -- *From:* Action Request System discussion list(ARSList) [ arslist@ARSLIST.ORG] On Behalf Of patrick zandi [remedy...@gmail.com] *Sent:* Tuesday, August 05, 2014 08:38 *To:* arslist@ARSLIST.ORG *Subject:* QQ: MSSQL server name / Instance name issue ** I am sure I am just missing the obvious today.. Win: 2012 - connecting to an instance of the 2012 sql server Servername :: NAME-W12-SQL-1\REMEDY,1435(mssql connection settings) Instance name :: remedy SA password it says:: · The instance name *REMEDY *is not valid for the host * NAME-w12-sql-1* / port *1435* · Detected the SQLServer instance *NAME-W12-SQL-1\ REMEDY* for the host *dtg-w12-sql-1* / port *1435* *So I put in the following::* hostname NAME-W12-SQL-1\REMEDY Instance name : remedy System installer says: · The installer is unable to resolve NAME-w12-sql-1\REMEDY into an IP address.Clients cannot communicate to the Server unless they can resolve into an IP address If I put in the IP address \ REMEDY is says same thing. I know it is something silly, it must be the fly on my nose (too close). if I put in NAME-W12-SQL-1 (it says it should be the above) do I need to create some sort of Alias? like in the /etc/hosts? or registry? for it to get accepted. -- Patrick Zandi _ARSlist: Where the Answers Are and have been for 20 years_ -- Patrick Zandi -- Patrick Zandi -- Patrick Zandi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: MSSQL server name / Instance name issue
http://technet.microsoft.com/en-us/library/ms191229%28v=sql.105%29.aspx shows the format: but it appears remedy does not follow it? also the drop down never works, but I guessed that was another bug. On Tue, Aug 5, 2014 at 12:01 PM, patrick zandi remedy...@gmail.com wrote: it is a NAMED INSTANCE on the SQL Server... that is why the ip/named instancethen the instance name (which is different). On Tue, Aug 5, 2014 at 11:39 AM, patrick zandi remedy...@gmail.com wrote: Lets start with the environment: When logging into MSSQL server management studio I use the following settings. Servername : name-w12-sql-1\remedy instance name : remedy with sa password and Voila.. no problems. if I view connection properties it says: Server name:: name-w12-sql-1/remedy,1435 instance name:: remedy With 2012 sql server you can create seperate instances within itself. hope that makes sense. On Tue, Aug 5, 2014 at 11:11 AM, patrick zandi remedy...@gmail.com wrote: but if I take the slash out and put it into the instance name it fails as well. DB Information: Hostname or IP :: Hostname IP instance name : blank --- invalid instance if Hostname or IP :: Hostname IP instance name : remedy is says Instance name remedy is not validfor host ip/port Detected the sql server instance name-w12-sql-1\remedy for the host ip /port 1435 It tells you what it should be but cannot accept it.. On Tue, Aug 5, 2014 at 10:27 AM, Grooms, Frederick W frederick.w.gro...@xo.com wrote: ** I believe it is telling you it wants just the server name NAME-w12-sql-1 as a slash is not valid in the name of a machine · The installer is unable to resolve NAME-w12-sql-1\REMEDY into an IP address. .Clients cannot communicate to the Server unless they can resolve into an IP address Fred *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Murnane, Phil *Sent:* Tuesday, August 05, 2014 8:23 AM *To:* arslist@ARSLIST.ORG *Subject:* Re: MSSQL server name / Instance name issue ** Patrick: Years ago (maybe ARS 4.x?) I encountered a problem where the application server wouldn't connect to a database instance if the name was longer than 12 characters. Maybe try creating an alias in the LMHOSTS file? FWIW, --Phil -- *From:* Action Request System discussion list(ARSList) [ arslist@ARSLIST.ORG] On Behalf Of patrick zandi [remedy...@gmail.com] *Sent:* Tuesday, August 05, 2014 08:38 *To:* arslist@ARSLIST.ORG *Subject:* QQ: MSSQL server name / Instance name issue ** I am sure I am just missing the obvious today.. Win: 2012 - connecting to an instance of the 2012 sql server Servername :: NAME-W12-SQL-1\REMEDY,1435(mssql connection settings) Instance name :: remedy SA password it says:: · The instance name *REMEDY *is not valid for the host * NAME-w12-sql-1* / port *1435* · Detected the SQLServer instance *NAME-W12-SQL-1\ REMEDY* for the host *dtg-w12-sql-1* / port *1435* *So I put in the following::* hostname NAME-W12-SQL-1\REMEDY Instance name : remedy System installer says: · The installer is unable to resolve NAME-w12-sql-1\REMEDY into an IP address.Clients cannot communicate to the Server unless they can resolve into an IP address If I put in the IP address \ REMEDY is says same thing. I know it is something silly, it must be the fly on my nose (too close). if I put in NAME-W12-SQL-1 (it says it should be the above) do I need to create some sort of Alias? like in the /etc/hosts? or registry? for it to get accepted. -- Patrick Zandi _ARSlist: Where the Answers Are and have been for 20 years_ -- Patrick Zandi -- Patrick Zandi -- Patrick Zandi -- Patrick Zandi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: MSSQL server name / Instance name issue
What version are you running into this on? I want to say I had that problem with either 7.5 or maybe 7.6.4 but 8.1 doesn’t have that problem in my environment. I wish I could remember how I got around it. This may be my imagination, but there could be something akin to a portmapper on the SQL Server where you aren’t really using 1435. Can you connect with SSMS and then open up a command prompt and type netstat and hit enter and look for that SQL Server and see what port you are actually connecting to? That may be one thing to investigate. Thanks, Shawn Pierson Remedy Developer | Energy Transfer From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of patrick zandi Sent: Tuesday, August 05, 2014 11:16 AM To: arslist@ARSLIST.ORG Subject: Re: MSSQL server name / Instance name issue ** http://technet.microsoft.com/en-us/library/ms191229%28v=sql.105%29.aspx shows the format: but it appears remedy does not follow it? also the drop down never works, but I guessed that was another bug. On Tue, Aug 5, 2014 at 12:01 PM, patrick zandi remedy...@gmail.commailto:remedy...@gmail.com wrote: it is a NAMED INSTANCE on the SQL Server... that is why the ip/named instancethen the instance name (which is different). On Tue, Aug 5, 2014 at 11:39 AM, patrick zandi remedy...@gmail.commailto:remedy...@gmail.com wrote: Lets start with the environment: When logging into MSSQL server management studio I use the following settings. Servername : name-w12-sql-1\remedy instance name : remedy with sa password and Voila.. no problems. if I view connection properties it says: Server name:: name-w12-sql-1/remedy,1435 instance name:: remedy With 2012 sql server you can create seperate instances within itself. hope that makes sense. On Tue, Aug 5, 2014 at 11:11 AM, patrick zandi remedy...@gmail.commailto:remedy...@gmail.com wrote: but if I take the slash out and put it into the instance name it fails as well. DB Information: Hostname or IP :: Hostname IP instance name : blank --- invalid instance if Hostname or IP :: Hostname IP instance name : remedy is says Instance name remedy is not validfor host ip/port Detected the sql server instance name-w12-sql-1\remedy for the host ip /port 1435 It tells you what it should be but cannot accept it.. On Tue, Aug 5, 2014 at 10:27 AM, Grooms, Frederick W frederick.w.gro...@xo.commailto:frederick.w.gro...@xo.com wrote: ** I believe it is telling you it wants just the server nameNAME-w12-sql-1 as a slash is not valid in the name of a machine • The installer is unable to resolve NAME-w12-sql-1\REMEDY into an IP address. .Clients cannot communicate to the Server unless they can resolve into an IP address Fred From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of Murnane, Phil Sent: Tuesday, August 05, 2014 8:23 AM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: MSSQL server name / Instance name issue ** Patrick: Years ago (maybe ARS 4.x?) I encountered a problem where the application server wouldn't connect to a database instance if the name was longer than 12 characters. Maybe try creating an alias in the LMHOSTS file? FWIW, --Phil From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of patrick zandi [remedy...@gmail.commailto:remedy...@gmail.com] Sent: Tuesday, August 05, 2014 08:38 To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: QQ: MSSQL server name / Instance name issue ** I am sure I am just missing the obvious today.. Win: 2012 - connecting to an instance of the 2012 sql server Servername :: NAME-W12-SQL-1\REMEDY,1435(mssql connection settings) Instance name :: remedy SA password it says:: • The instance name REMEDY is not valid for the host NAME-w12-sql-1 / port 1435 • Detected the SQLServer instance NAME-W12-SQL-1\ REMEDY for the host dtg-w12-sql-1 / port 1435 So I put in the following:: hostname NAME-W12-SQL-1\REMEDY Instance name : remedy System installer says: • The installer is unable to resolve NAME-w12-sql-1\REMEDY into an IP address.Clients cannot communicate to the Server unless they can resolve into an IP address If I put in the IP address \ REMEDY is says same thing. I know it is something silly, it must be the fly on my nose (too close). if I put in NAME-W12-SQL-1 (it says it should be the above) do I need to create some sort of Alias? like in the /etc/hosts? or registry? for it to get accepted. -- Patrick Zandi _ARSlist: Where the Answers Are and have been for 20 years_ -- Patrick Zandi -- Patrick Zandi -- Patrick Zandi -- Patrick Zandi _ARSlist: Where the Answers Are and have been for 20 years_ Private and confidential as detailed here: http://www.energytransfer.com/mail_disclaimer.aspx . If you cannot access the link, please e-mail
Re: SAML Integration
We use the same product and it has been flawless. The problem is that BMC has a different concept of SSO than the rest of the world IMHO. I do believe the 8.0 or 8.1 version does provide SAML support, but the implementation of BMC SSO is not straight forward. Jim Coryat x34655 -Original Message- From: Frank Caruso [mailto:caruso.fr...@gmail.com] Sent: Tuesday, August 05, 2014 9:14 AM Subject: Re: SAML Integration We used JSS-SSO for single sign via Kerberos and it is working vey well. I believe the product offers SAML integration as well as several other possibilities. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: MSSQL server name / Instance name issue
2012 os, 2012 sql server (multiple instances) I am using a name instance called remedy. Checking... ssms connects fine with the ip\remedy in the hostname or hostname\remedy which is the named instance name no problem. logged on to the sql server I see the port 1435 coming in from the ip of the remedy server (SSMS) not because of remedy install. On Tue, Aug 5, 2014 at 12:28 PM, Pierson, Shawn shawn.pier...@energytransfer.com wrote: ** What version are you running into this on? I want to say I had that problem with either 7.5 or maybe 7.6.4 but 8.1 doesn’t have that problem in my environment. I wish I could remember how I got around it. This may be my imagination, but there could be something akin to a portmapper on the SQL Server where you aren’t really using 1435. Can you connect with SSMS and then open up a command prompt and type netstat and hit enter and look for that SQL Server and see what port you are actually connecting to? That may be one thing to investigate. Thanks, *Shawn Pierson * Remedy Developer | Energy Transfer *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *patrick zandi *Sent:* Tuesday, August 05, 2014 11:16 AM *To:* arslist@ARSLIST.ORG *Subject:* Re: MSSQL server name / Instance name issue ** http://technet.microsoft.com/en-us/library/ms191229%28v=sql.105%29.aspx shows the format: but it appears remedy does not follow it? also the drop down never works, but I guessed that was another bug. On Tue, Aug 5, 2014 at 12:01 PM, patrick zandi remedy...@gmail.com wrote: it is a NAMED INSTANCE on the SQL Server... that is why the ip/named instancethen the instance name (which is different). On Tue, Aug 5, 2014 at 11:39 AM, patrick zandi remedy...@gmail.com wrote: Lets start with the environment: When logging into MSSQL server management studio I use the following settings. Servername : name-w12-sql-1\remedy instance name : remedy with sa password and Voila.. no problems. if I view connection properties it says: Server name:: name-w12-sql-1/remedy,1435 instance name:: remedy With 2012 sql server you can create seperate instances within itself. hope that makes sense. On Tue, Aug 5, 2014 at 11:11 AM, patrick zandi remedy...@gmail.com wrote: but if I take the slash out and put it into the instance name it fails as well. DB Information: Hostname or IP :: Hostname IP instance name : blank --- invalid instance if Hostname or IP :: Hostname IP instance name : remedy is says Instance name remedy is not validfor host ip/port Detected the sql server instance name-w12-sql-1\remedy for the host ip /port 1435 It tells you what it should be but cannot accept it.. On Tue, Aug 5, 2014 at 10:27 AM, Grooms, Frederick W frederick.w.gro...@xo.com wrote: ** I believe it is telling you it wants just the server name NAME-w12-sql-1 as a slash is not valid in the name of a machine · The installer is unable to resolve NAME-w12-sql-1\REMEDY into an IP address. .Clients cannot communicate to the Server unless they can resolve into an IP address Fred *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Murnane, Phil *Sent:* Tuesday, August 05, 2014 8:23 AM *To:* arslist@ARSLIST.ORG *Subject:* Re: MSSQL server name / Instance name issue ** Patrick: Years ago (maybe ARS 4.x?) I encountered a problem where the application server wouldn't connect to a database instance if the name was longer than 12 characters. Maybe try creating an alias in the LMHOSTS file? FWIW, --Phil -- *From:* Action Request System discussion list(ARSList) [ arslist@ARSLIST.ORG] On Behalf Of patrick zandi [remedy...@gmail.com] *Sent:* Tuesday, August 05, 2014 08:38 *To:* arslist@ARSLIST.ORG *Subject:* QQ: MSSQL server name / Instance name issue ** I am sure I am just missing the obvious today.. Win: 2012 - connecting to an instance of the 2012 sql server Servername :: NAME-W12-SQL-1\REMEDY,1435(mssql connection settings) Instance name :: remedy SA password it says:: · The instance name *REMEDY *is not valid for the host *NAME-w12-sql-1* / port *1435* · Detected the SQLServer instance *NAME-W12-SQL-1\ REMEDY* for the host *dtg-w12-sql-1* / port *1435* *So I put in the following::* hostname NAME-W12-SQL-1\REMEDY Instance name : remedy System installer says: · The installer is unable to resolve NAME-w12-sql-1\REMEDY into an IP address.Clients cannot communicate to the Server unless they can resolve into an IP address If I put in the IP address \ REMEDY is says same thing. I know it is something silly, it must be the fly on my nose (too close). if I put in NAME-W12-SQL-1 (it says it should be the above) do I need to create some sort of Alias? like in the /etc/hosts? or
Re: MSSQL server name / Instance name issue
Just to humor the installation script, have you tried putting the IP Address and server name entry into the hosts file on the AR System server where the MS-SQL client is installed? Also try installing the full client (client tools) and see if you can connect the SQL server manager and open a Query Analyzer session. Joe _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of patrick zandi Sent: Tuesday, August 05, 2014 12:42 PM To: arslist@ARSLIST.ORG Subject: Re: MSSQL server name / Instance name issue ** 2012 os, 2012 sql server (multiple instances) I am using a name instance called remedy. Checking... ssms connects fine with the ip\remedy in the hostname or hostname\remedy which is the named instance name no problem. logged on to the sql server I see the port 1435 coming in from the ip of the remedy server (SSMS) not because of remedy install. On Tue, Aug 5, 2014 at 12:28 PM, Pierson, Shawn shawn.pier...@energytransfer.com wrote: ** What version are you running into this on? I want to say I had that problem with either 7.5 or maybe 7.6.4 but 8.1 doesn’t have that problem in my environment. I wish I could remember how I got around it. This may be my imagination, but there could be something akin to a portmapper on the SQL Server where you aren’t really using 1435. Can you connect with SSMS and then open up a command prompt and type netstat and hit enter and look for that SQL Server and see what port you are actually connecting to? That may be one thing to investigate. Thanks, Shawn Pierson Remedy Developer | Energy Transfer From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of patrick zandi Sent: Tuesday, August 05, 2014 11:16 AM To: arslist@ARSLIST.ORG Subject: Re: MSSQL server name / Instance name issue ** http://technet.microsoft.com/en-us/library/ms191229%28v=sql.105%29.aspx shows the format: but it appears remedy does not follow it? also the drop down never works, but I guessed that was another bug. On Tue, Aug 5, 2014 at 12:01 PM, patrick zandi remedy...@gmail.com wrote: it is a NAMED INSTANCE on the SQL Server... that is why the ip/named instancethen the instance name (which is different). On Tue, Aug 5, 2014 at 11:39 AM, patrick zandi remedy...@gmail.com wrote: Lets start with the environment: When logging into MSSQL server management studio I use the following settings. Servername : name-w12-sql-1\remedy instance name : remedy with sa password and Voila.. no problems. if I view connection properties it says: Server name:: name-w12-sql-1/remedy,1435 instance name:: remedy With 2012 sql server you can create seperate instances within itself. hope that makes sense. On Tue, Aug 5, 2014 at 11:11 AM, patrick zandi remedy...@gmail.com wrote: but if I take the slash out and put it into the instance name it fails as well. DB Information: Hostname or IP :: Hostname IP instance name : blank --- invalid instance if Hostname or IP :: Hostname IP instance name : remedy is says Instance name remedy is not validfor host ip/port Detected the sql server instance name-w12-sql-1\remedy for the host ip /port 1435 It tells you what it should be but cannot accept it.. On Tue, Aug 5, 2014 at 10:27 AM, Grooms, Frederick W frederick.w.gro...@xo.com wrote: ** I believe it is telling you it wants just the server nameNAME-w12-sql-1 as a slash is not valid in the name of a machine * The installer is unable to resolve NAME-w12-sql-1\REMEDY into an IP address. .Clients cannot communicate to the Server unless they can resolve into an IP address Fred From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Murnane, Phil Sent: Tuesday, August 05, 2014 8:23 AM To: arslist@ARSLIST.ORG Subject: Re: MSSQL server name / Instance name issue ** Patrick: Years ago (maybe ARS 4.x?) I encountered a problem where the application server wouldn't connect to a database instance if the name was longer than 12 characters. Maybe try creating an alias in the LMHOSTS file? FWIW, --Phil _ From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] On Behalf Of patrick zandi [remedy...@gmail.com] Sent: Tuesday, August 05, 2014 08:38 To: arslist@ARSLIST.ORG Subject: QQ: MSSQL server name / Instance name issue ** I am sure I am just missing the obvious today.. Win: 2012 - connecting to an instance of the 2012 sql server Servername :: NAME-W12-SQL-1\REMEDY,1435(mssql connection settings) Instance name :: remedy SA password it says:: * The instance name REMEDY is not valid for the host NAME-w12-sql-1 / port 1435 * Detected the SQLServer instance NAME-W12-SQL-1\ REMEDY for the host dtg-w12-sql-1 / port 1435 So I put in the following:: hostname NAME-W12-SQL-1\REMEDY
https vs http when using web service and a load balancer.
Hello, I would suggest you review the Tomcat connector documentation: http://tomcat.apache.org/tomcat-7.0-doc/config/http.html and in particular: http://tomcat.apache.org/tomcat-7.0-doc/config/http.html#Common_Attributes scheme: Set this attribute to the name of the protocol you wish to have returned by calls to request.getScheme(). For example, you would set this attribute to https for an SSL Connector. To correctly set up Tomcat behind a reverse proxy load balancer, which is essentially what happens when SSL terminates at the load balancer, the Tomcat needs to know about the scheme, host and port in order to correctly create URLs when an application says, What's the protocol we support? What's the hostname on which we run?, etc. Assuming the BMC code isn't doing anything horrific like assuming HTTP, I suspect that setting the scheme=https attribute on the connector will resolve the issue. Also, set proxyName=lbhostname and proxyPort=443. This is configured in the server.xml file on the HTTP connector, ie. Connector port=8080 protocol=HTTP/1.1 connectionTimeout=2 redirectPort=8443 scheme=https proxyName=loadbalancerfqdn proxyPort=8443 / John Baker -- SSO Plugin for the BMC product set http://www.javasystemsolutions.com/jss/ssoplugin ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Impact of renaming Sites in ITSM 7.6.04..
Thanks for all your responses. @ Joel Thought of the alias thingy. The problem however is not whether or not that would work. Sure it would work. BUT, if you want to develop a nightly job to update foundation data, based on information from another system, and if previous data has had been fed using other processes (partially automated and partially hand fed), auto generating foundation data, would be a challenge without potentially duplicating some entries in the master SIT:Site table. As far as the nightly job is concerned, it will not find a site name with the string that we develop to name that site, if a previous site name already exists for that site with a slightly different name. @ Leanard, Michell, Thad and others who suggested the use of DLD:SYS:DataWizAudit_Forms for getting a list of forms.. Thank you for suggesting DLD:SYS:DataWizAudit_Forms as a 'good candidate' to start with. While I could surely shorten my task of scripting my own script using names found here, is it a complete list? Or are there potential exceptions as someone pointed out? I'm afraid if there are exceptions, I may not gain much by starting out with that list as I might still need to comb the system to find the remainder of the fields in some other forms. At best it may be useful to get a list of Field ID's used to represent that field and then comb the system to find other forms that contain that exact same Field ID and then verify if that field stores the Site Name. Would there be any fields that may have the Site Name value set within the field contents (just like Login Name is found in Diary Fields as user stamps)? I cannot think of an example for this case but feel uncomfortable to completely ignore it. Joe _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Lucero, Michelle Sent: Tuesday, August 05, 2014 3:16 AM To: arslist@ARSLIST.ORG Subject: Re: Impact of renaming Sites in ITSM 7.6.04.. Hey, Leonard -(blast from the past from CW ) :-) You are right, DLD:SYS:DataWizAudit_Forms is a good starting point. FYI: Because, we had to update tens of thousands of unique sites AND since the Data Wizard is restricted to updating the Site Name and NOT the Site Group and Region; we couldn't use the Data Wizard either. Like others, had to build our own solution. The fact that one can only update one site name, Support Group, login, Categorization at a time is one reason for the Ideas being submitted on BMC Communities for the Data Wizard. @Joe, I created two SQL scripts to assist me with the initial research. 1. Finds all references to foundation fields including Site, Categories, Support Group, etc. The results list contains the form name, schema Id, fieldname, fielded, data type, etc., of custom and ITSM forms and fields. 2. Unions the list of Region /Site Group / Site combinations found in active records of multiple application and configuration forms that are either custom or base. This will be your target data to update. The workflow to update is all Direct SQL. Warning - this update can still take hours depending on the amount of data you'll have to change. Sorry for rambling, but hope it helps. Michelle From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Neely, Leonard Sent: Monday, August 04, 2014 10:35 PM To: arslist@ARSLIST.ORG Subject: Re: Impact of renaming Sites in ITSM 7.6.04.. ** In 8.1 (probably earlier versions as well), you can take a look at data in the DLD:SYS:DataWizAudit_Forms form, which should give you a pretty good list of candidate forms to be updated. That may be a good starting point. HTH Leonard Neely From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Thad Esser Sent: Monday, August 04, 2014 5:15 PM To: arslist@ARSLIST.ORG Subject: Re: Impact of renaming Sites in ITSM 7.6.04.. ** Joe, The data wizard does use SQL to make all of it's updates (at least in 7.0.3, I haven't had to dig that deep in 8.1 yet). Take a look at the DLD:SYS:DataWizardFormFields form (and the other DLD:SYS.. forms). That should get you a good ways toward your goal. Sample screenshot: Inline image 1 And one other thing that drive me bat-shtir-crazy... On the asset forms, the field labeled Site, has a database name of Building (the field ID is 26001, which is site name everywhere else). The kicker is that the field labeled Site Group has a database name of Site (and a field id that match Site Group every where else). Read that again, this time more carefully. :-) Now, that is only true for the AST forms - on the underlying CMDB forms, the label matches the database name. I hope that helps, Thad On Mon, Aug 4, 2014 at 3:55 PM, Joe D'Souza jdso...@shyle.net wrote: ** Yeah I was hoping for a lazy way to find a
Re: MSSQL server name / Instance name issue
I have tried host, host\named instancehost\named instance:0,porthost\named instance,port host then instance name going insane.. I can login with ssms, and I can query db no problem but the login is as hostname(or IP)\named instance,port name-W12-SQL-1\REMEDY,1435 8.1.01 does not like it with or without port (cause port is in the line below)... I actually built a server (8 of them) and after installation we had to change the ar.conf to hostname,port or they would not run.. I think someone at the Engineering area missed a step... but this was for a SQL Cluster.. it would let you install, but not bounce..now this one will not let me install.. On Tue, Aug 5, 2014 at 2:24 PM, Joe D'Souza jdso...@shyle.net wrote: ** Just to humor the installation script, have you tried putting the IP Address and server name entry into the hosts file on the AR System server where the MS-SQL client is installed? Also try installing the full client (client tools) and see if you can connect the SQL server manager and open a Query Analyzer session. Joe -- *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *patrick zandi *Sent:* Tuesday, August 05, 2014 12:42 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: MSSQL server name / Instance name issue ** 2012 os, 2012 sql server (multiple instances) I am using a name instance called remedy. Checking... ssms connects fine with the ip\remedy in the hostname or hostname\remedy which is the named instance name no problem. logged on to the sql server I see the port 1435 coming in from the ip of the remedy server (SSMS) not because of remedy install. On Tue, Aug 5, 2014 at 12:28 PM, Pierson, Shawn shawn.pier...@energytransfer.com wrote: ** What version are you running into this on? I want to say I had that problem with either 7.5 or maybe 7.6.4 but 8.1 doesn’t have that problem in my environment. I wish I could remember how I got around it. This may be my imagination, but there could be something akin to a portmapper on the SQL Server where you aren’t really using 1435. Can you connect with SSMS and then open up a command prompt and type netstat and hit enter and look for that SQL Server and see what port you are actually connecting to? That may be one thing to investigate. Thanks, *Shawn Pierson * Remedy Developer | Energy Transfer *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *patrick zandi *Sent:* Tuesday, August 05, 2014 11:16 AM *To:* arslist@ARSLIST.ORG *Subject:* Re: MSSQL server name / Instance name issue ** http://technet.microsoft.com/en-us/library/ms191229%28v=sql.105%29.aspx shows the format: but it appears remedy does not follow it? also the drop down never works, but I guessed that was another bug. On Tue, Aug 5, 2014 at 12:01 PM, patrick zandi remedy...@gmail.com wrote: it is a NAMED INSTANCE on the SQL Server... that is why the ip/named instancethen the instance name (which is different). On Tue, Aug 5, 2014 at 11:39 AM, patrick zandi remedy...@gmail.com wrote: Lets start with the environment: When logging into MSSQL server management studio I use the following settings. Servername : name-w12-sql-1\remedy instance name : remedy with sa password and Voila.. no problems. if I view connection properties it says: Server name:: name-w12-sql-1/remedy,1435 instance name:: remedy With 2012 sql server you can create seperate instances within itself. hope that makes sense. On Tue, Aug 5, 2014 at 11:11 AM, patrick zandi remedy...@gmail.com wrote: but if I take the slash out and put it into the instance name it fails as well. DB Information: Hostname or IP :: Hostname IP instance name : blank --- invalid instance if Hostname or IP :: Hostname IP instance name : remedy is says Instance name remedy is not validfor host ip/port Detected the sql server instance name-w12-sql-1\remedy for the host ip /port 1435 It tells you what it should be but cannot accept it.. On Tue, Aug 5, 2014 at 10:27 AM, Grooms, Frederick W frederick.w.gro...@xo.com wrote: ** I believe it is telling you it wants just the server name NAME-w12-sql-1 as a slash is not valid in the name of a machine · The installer is unable to resolve NAME-w12-sql-1\REMEDY into an IP address. .Clients cannot communicate to the Server unless they can resolve into an IP address Fred *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Murnane, Phil *Sent:* Tuesday, August 05, 2014 8:23 AM *To:* arslist@ARSLIST.ORG *Subject:* Re: MSSQL server name / Instance name issue ** Patrick: Years ago (maybe ARS 4.x?) I encountered a problem where the application server wouldn't connect to a database instance if the name was longer than 12
Re: MSSQL server name / Instance name issue
I am wondering if the user of special characters – in the server name is driving the MS SQL client mad. Just for fun, install MS-SQL server on the same network, on a server that has no special characters (and as per someone else’s suggestion on a server that has less than 12 characters in its server name) and see if you have better luck. If so, you could alias the server in the hosts file to REMEDYSQL or some other friendly name like that and give it a try. I had an issue recently with Oracle where the use of @ in a password drove the Oracle client mad if the password was not enclosed within “” in the auth string. And there was a good reason why that happened. Joe _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of patrick zandi Sent: Tuesday, August 05, 2014 3:00 PM To: arslist@ARSLIST.ORG Subject: Re: MSSQL server name / Instance name issue ** I have tried host, host\named instancehost\named instance:0,port host\named instance,port host then instance name going insane.. I can login with ssms, and I can query db no problem but the login is as hostname(or IP)\named instance,port name-W12-SQL-1\REMEDY,1435 8.1.01 does not like it with or without port (cause port is in the line below)... I actually built a server (8 of them) and after installation we had to change the ar.conf to hostname,port or they would not run.. I think someone at the Engineering area missed a step... but this was for a SQL Cluster.. it would let you install, but not bounce..now this one will not let me install.. On Tue, Aug 5, 2014 at 2:24 PM, Joe D'Souza jdso...@shyle.net wrote: ** Just to humor the installation script, have you tried putting the IP Address and server name entry into the hosts file on the AR System server where the MS-SQL client is installed? Also try installing the full client (client tools) and see if you can connect the SQL server manager and open a Query Analyzer session. Joe _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of patrick zandi Sent: Tuesday, August 05, 2014 12:42 PM To: arslist@ARSLIST.ORG Subject: Re: MSSQL server name / Instance name issue ** 2012 os, 2012 sql server (multiple instances) I am using a name instance called remedy. Checking... ssms connects fine with the ip\remedy in the hostname or hostname\remedy which is the named instance name no problem. logged on to the sql server I see the port 1435 coming in from the ip of the remedy server (SSMS) not because of remedy install. On Tue, Aug 5, 2014 at 12:28 PM, Pierson, Shawn shawn.pier...@energytransfer.com wrote: ** What version are you running into this on? I want to say I had that problem with either 7.5 or maybe 7.6.4 but 8.1 doesn’t have that problem in my environment. I wish I could remember how I got around it. This may be my imagination, but there could be something akin to a portmapper on the SQL Server where you aren’t really using 1435. Can you connect with SSMS and then open up a command prompt and type netstat and hit enter and look for that SQL Server and see what port you are actually connecting to? That may be one thing to investigate. Thanks, Shawn Pierson Remedy Developer | Energy Transfer From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of patrick zandi Sent: Tuesday, August 05, 2014 11:16 AM To: arslist@ARSLIST.ORG Subject: Re: MSSQL server name / Instance name issue ** http://technet.microsoft.com/en-us/library/ms191229%28v=sql.105%29.aspx shows the format: but it appears remedy does not follow it? also the drop down never works, but I guessed that was another bug. On Tue, Aug 5, 2014 at 12:01 PM, patrick zandi remedy...@gmail.com wrote: it is a NAMED INSTANCE on the SQL Server... that is why the ip/named instancethen the instance name (which is different). On Tue, Aug 5, 2014 at 11:39 AM, patrick zandi remedy...@gmail.com wrote: Lets start with the environment: When logging into MSSQL server management studio I use the following settings. Servername : name-w12-sql-1\remedy instance name : remedy with sa password and Voila.. no problems. if I view connection properties it says: Server name:: name-w12-sql-1/remedy,1435 instance name:: remedy With 2012 sql server you can create seperate instances within itself. hope that makes sense. On Tue, Aug 5, 2014 at 11:11 AM, patrick zandi remedy...@gmail.com wrote: but if I take the slash out and put it into the instance name it fails as well. DB Information: Hostname or IP :: Hostname IP instance name : blank --- invalid instance if Hostname or IP :: Hostname IP instance name : remedy is says Instance name remedy is not validfor host ip/port Detected the sql server instance name-w12-sql-1\remedy for the host ip /port 1435 It
Re: ADV: Cherwell Webinar
I didn't notice Kevin started this thread and offered to invite us to a webinar. So it appears like the questions I have would be addressed at the webinar due to be hosted by IT Partners on the 14th of August 20014 at 12:00 PM EST, so I hope to be able to juggle time between my client, lunch hour and the webinar. If not, I'm hoping IT Partners could host another webinar sometime again (to get the benefit of QA) or at least have a recording of the webinar available offline after the event? My interest is getting to know Cherwell's features as a competitor in the ITSM / workflow management tool market. Joe PS: Anyone in this business plan to hold a similar webinar on SNOW??? And RemedyForce??? _ From: Joe D'Souza [mailto:jdso...@shyle.net] Sent: Monday, August 04, 2014 4:40 PM To: ARS Discussion List Subject: RE: ADV: Cherwell Webinar You don't have to go overboard if its private. Chances are I won't probably be able to take time off from my current engagement anyways unless its during the lunch hour EST. I have a few deadlines I am on for certain deliverables and can't multitask as a result on this one occassion Joe _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Tauf Chowdhury Sent: Monday, August 04, 2014 4:37 PM To: arslist@ARSLIST.ORG Subject: Re: ADV: Cherwell Webinar Private but let me see what I can do Sent from my iPhone On Aug 4, 2014, at 4:32 PM, Joe D'Souza jdso...@shyle.net wrote: ** Is it a WebEx public demo? Or a private one? Joe _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Tauf Chowdhury Sent: Monday, August 04, 2014 4:26 PM To: arslist@ARSLIST.ORG Subject: Re: ADV: Cherwell Webinar I'm getting a demo tomorrow so will let you know Sent from my iPhone On Aug 4, 2014, at 4:24 PM, Joe D'Souza jdso...@shyle.net wrote: ** How does Cherwell compare to SNOW and the AR System from the ease of customization and implementation, TCO and end user experience perspective? Joe _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: Monday, August 04, 2014 4:13 PM To: arslist@ARSLIST.ORG Subject: Re: ADV: Cherwell Webinar ** But...RemedyForce IS another productit's not another company...but it is 100% a different product... On Mon, Aug 4, 2014 at 2:07 PM, Grassi, Christopher cgra...@columnit.com wrote: ** I've been using Remedy since Version 5 - if you are unhappy with Remedy for any reason, I would look at Remedyforce before going to another product. Feel free to reach out if you want to know more. -Chris Grassi cgras...@gmail.com On 4 Aug 2014, at 14:44, Kevin Shaffer kshaf...@partneritsm.com wrote: ** I have been hesitant to bring up the topic of Cherwell on the ARSList, but there seems to have been some interest and discussion about Cherwell last week. First of all, I have been a Remedy consultant since the late 90's, version 3.x. I have experienced all the highs and lows that everyone describes on this list. I would love to see BMC succeed and Remedy continue to lead. The reality is I have witnessed many of my colleagues drift over to SNOW and others get out of the business completely, as we watched the competitors catch up and some even surpass in some areas as others have pointed out. The majority of our business is still BMC, but a growing portion of it is now Cherwell. Most of us are all facing similar challenges and questions from management. Why does the licensing model have to be so confusing?, Why do upgrades have to be so painful?, Why can't I call support and get an onshore resource?, Why does on-premise or on-demand feel like a lifetime commitment?, etc. Whether or not you feel that any of the aforementioned questions are true about BMC Remedy, these questions are still being asked by management. Partner IT is hosting a one hour webinar on August 14, 2014 at 1 PM EST to discuss how Cherwell can address many of the Why questions we all face. The intended audience is not just Remedy users but rather companies that are evaluating options. Please contact me OFFLINE if you are interested in attending and I will send you a more formal invitation. We will have very techy people presenting to address anything that comes up. Kevin Shaffer, Senior Partner Partner IT, Inc. Office Phone: (888) 380-8899 tel:%2%29%20380-8899 Cell Phone: (316) 208-5341 tel:%28316%29%20208-5341 Fax: (708) tel:%28708%29%20887-1704 887-1704 Email: kshaf...@partneritsm.com Website: http://www.partneritsm.com Follow Us: http://www.twitter.com/partneritsm YouTube: http://www.youtube.com/partneritsm _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where
Re: ADV: Cherwell Webinar
Who would be interested in a Remedyforce one aimed at the ARS list audience? I would happily host it. Let me know if you are interested. cgras...@gmail.commailto:cgras...@gmail.com -Chris On 5 Aug 2014, at 20:56, Joe D'Souza jdso...@shyle.netmailto:jdso...@shyle.net wrote: ** I didn’t notice Kevin started this thread and offered to invite us to a webinar. So it appears like the questions I have would be addressed at the webinar due to be hosted by IT Partners on the 14th of August 20014 at 12:00 PM EST, so I hope to be able to juggle time between my client, lunch hour and the webinar. If not, I’m hoping IT Partners could host another webinar sometime again (to get the benefit of QA) or at least have a recording of the webinar available offline after the event? My interest is getting to know Cherwell’s features as a competitor in the ITSM / workflow management tool market. Joe PS: Anyone in this business plan to hold a similar webinar on SNOW??? And RemedyForce??? From: Joe D'Souza [mailto:jdso...@shyle.net] Sent: Monday, August 04, 2014 4:40 PM To: ARS Discussion List Subject: RE: ADV: Cherwell Webinar You don’t have to go overboard if its private. Chances are I won’t probably be able to take time off from my current engagement anyways unless its during the lunch hour EST. I have a few deadlines I am on for certain deliverables and can’t multitask as a result on this one occassion Joe From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Tauf Chowdhury Sent: Monday, August 04, 2014 4:37 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: ADV: Cherwell Webinar Private but let me see what I can do Sent from my iPhone On Aug 4, 2014, at 4:32 PM, Joe D'Souza jdso...@shyle.netmailto:jdso...@shyle.net wrote: ** Is it a WebEx public demo? Or a private one? Joe From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Tauf Chowdhury Sent: Monday, August 04, 2014 4:26 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: ADV: Cherwell Webinar I'm getting a demo tomorrow so will let you know Sent from my iPhone On Aug 4, 2014, at 4:24 PM, Joe D'Souza jdso...@shyle.netmailto:jdso...@shyle.net wrote: ** How does Cherwell compare to SNOW and the AR System from the ease of customization and implementation, TCO and end user experience perspective? Joe From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: Monday, August 04, 2014 4:13 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: ADV: Cherwell Webinar ** But...RemedyForce IS another productit's not another company...but it is 100% a different product... On Mon, Aug 4, 2014 at 2:07 PM, Grassi, Christopher cgra...@columnit.commailto:cgra...@columnit.com wrote: ** I’ve been using Remedy since Version 5 - if you are unhappy with Remedy for any reason, I would look at Remedyforce before going to another product. Feel free to reach out if you want to know more. -Chris Grassi cgras...@gmail.commailto:cgras...@gmail.com On 4 Aug 2014, at 14:44, Kevin Shaffer kshaf...@partneritsm.commailto:kshaf...@partneritsm.com wrote: ** I have been hesitant to bring up the topic of Cherwell on the ARSList, but there seems to have been some interest and discussion about Cherwell last week. First of all, I have been a Remedy consultant since the late 90’s, version 3.x. I have experienced all the highs and lows that everyone describes on this list. I would love to see BMC succeed and Remedy continue to lead. The reality is I have witnessed many of my colleagues drift over to SNOW and others get out of the business completely, as we watched the competitors catch up and some even surpass in some areas as others have pointed out. The majority of our business is still BMC, but a growing portion of it is now Cherwell. Most of us are all facing similar challenges and questions from management. Why does the licensing model have to be so confusing?, Why do upgrades have to be so painful?, Why can’t I call support and get an onshore resource?, Why does on-premise or on-demand feel like a lifetime commitment?, etc. Whether or not you feel that any of the aforementioned questions are true about BMC Remedy, these questions are still being asked by management. Partner IT is hosting a one hour webinar on August 14, 2014 at 1 PM EST to discuss how Cherwell can address many of the “Why” questions we all face. The intended audience is not just Remedy users but rather companies that are evaluating options. Please contact me OFFLINE if you are interested in attending and I will send you a more formal invitation. We will have very techy people presenting to address anything that comes up. Kevin Shaffer, Senior Partner
Re: Filter Phasing
I can confirm that ~! is nothing special and has no special interpretation. Notice that the ~ and ` are on the same key on many keyboards so a typo of someone hitting caps when they should not have is most likely (as LJ suggested). Doug Mueller From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: Friday, August 01, 2014 12:14 PM To: arslist@ARSLIST.ORG Subject: Re: Filter Phasing ** No...`! is to bypass filter phasingI've never heard of the other nomenclature, and don't believe it does anything, other than it might have been a typo by someone trying to use a `, but hit shift in the wrong place. On Fri, Aug 1, 2014 at 11:36 AM, S Test lak...@gmail.commailto:lak...@gmail.com wrote: What does ~! at the end of filter do? is `! same as ~! Is backtick! same as Tilda!? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.orghttp://www.arslist.org Where the Answers Are, and have been for 20 years _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: ADV: Cherwell Webinar
Yes - It’s a different product but the design pulls a lot features and functions from Remedy ITSM as well as SDE. Also from a platform perspective some would say it’s a better product because it’s True PaaS with the trusted salesforce platform behind it. Every Remedyforce Go Live we have had has been very quiet…no services falling over, no jobs’s failing to run, no architecture failings, no performance issues, no mid tiers being overloaded, no stickybit issues, etc. :) You all know the drill :) -Chris On 4 Aug 2014, at 21:12, LJ LongWing lj.longw...@gmail.commailto:lj.longw...@gmail.com wrote: ** But...RemedyForce IS another productit's not another company...but it is 100% a different product... On Mon, Aug 4, 2014 at 2:07 PM, Grassi, Christopher cgra...@columnit.commailto:cgra...@columnit.com wrote: ** I’ve been using Remedy since Version 5 - if you are unhappy with Remedy for any reason, I would look at Remedyforce before going to another product. Feel free to reach out if you want to know more. -Chris Grassi cgras...@gmail.commailto:cgras...@gmail.com On 4 Aug 2014, at 14:44, Kevin Shaffer kshaf...@partneritsm.commailto:kshaf...@partneritsm.com wrote: ** I have been hesitant to bring up the topic of Cherwell on the ARSList, but there seems to have been some interest and discussion about Cherwell last week. First of all, I have been a Remedy consultant since the late 90’s, version 3.x. I have experienced all the highs and lows that everyone describes on this list. I would love to see BMC succeed and Remedy continue to lead. The reality is I have witnessed many of my colleagues drift over to SNOW and others get out of the business completely, as we watched the competitors catch up and some even surpass in some areas as others have pointed out. The majority of our business is still BMC, but a growing portion of it is now Cherwell. Most of us are all facing similar challenges and questions from management. Why does the licensing model have to be so confusing?, Why do upgrades have to be so painful?, Why can’t I call support and get an onshore resource?, Why does on-premise or on-demand feel like a lifetime commitment?, etc. Whether or not you feel that any of the aforementioned questions are true about BMC Remedy, these questions are still being asked by management. Partner IT is hosting a one hour webinar on August 14, 2014 at 1 PM EST to discuss how Cherwell can address many of the “Why” questions we all face. The intended audience is not just Remedy users but rather companies that are evaluating options. Please contact me OFFLINE if you are interested in attending and I will send you a more formal invitation. We will have very techy people presenting to address anything that comes up. Kevin Shaffer, Senior Partner Partner IT, Inc. Office Phone: (888) 380-8899tel:%2%29%20380-8899 Cell Phone: (316) 208-5341tel:%28316%29%20208-5341 Fax: (708) 887-1704tel:%28708%29%20887-1704 Email: kshaf...@partneritsm.commailto:kshaf...@partneritsm.com Website: http://www.partneritsm.comhttp://www.partneritsm.com/ Follow Us: http://www.twitter.com/partneritsm YouTube: http://www.youtube.com/partneritsm _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Bug in 8.1 Patch 003 Installer
Everyone, I just wanted to follow up on this topic. There is no issue with the 8.1 patch 3 installer (well, there actually is because it is too harsh with the error condition when it should continue rather than fail and that is going to be worked in the next upgrade to make it more flexible around errors) BUT the key is that the problem is not related to the 8.1 patch 3 installer. There is an issue with the 8.1 SSI install. If you have installed the 8.1 Single Stack Installer image, there is a reference to an internal BMC machine in a file on that installation. The system runs just fine with this name in place as it is not used by the running system. However, when you try and upgrade, the name is picked up by the upgrade program during some if its work and the installer will fail. There is a KB article being prepared on this subject to tell you where the file that was laid down is that has the bad name and you can just remove that file and resolve the problem. I just wanted to share that the 8.1 patch 3 installer is just fine and does not have an issue and to offer information to anyone who has installed using the 8.1 SSI installer that there is an issue that they may want to address to prevent any issue with future upgrades. Doug Mueller From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of John Peters Sent: Thursday, July 17, 2014 11:30 PM To: arslist@ARSLIST.ORG Subject: Bug in 8.1 Patch 003 Installer ** Hi I am trying to apply the above patch but the installer errors with :- · Another instance of BMC Remedy Action Request System has been detected on sjc-w28vm-ar01 in path: C:\Program Files\BMC Software\ARSystem. Changing the install location is not allowed. Click Previous and specify the same location. There is no server called sjc-w28vm-ar01 what is going on? Every where I turn I seem to hit brick walls :( Thanks JP _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
BMC Remedyforce and MyIT 2.0 Webinar - Lunch and Learn
Hi All, This message comes out of a previous thread - I’m happy to run a quick 30-60 min “lunch and learn session just for the ARS list to help everyone understand some of the Remedyforce basics - plus point out some of the key differences from Remedy ITSM (which we all know and love). I can also cover off MyIT 2.0 if that is of interest as well. Please let me know if you would be interested and what day/week/time works best. I can run a few of these Demo’s in August so if we get to 10+ plus people who are interested I will coordinate. Feel free to email back on this thread or contact me directly via email / number below: Thanks, Chris Grassi Director of Professional Services Column Technologies UK cgra...@columnit.commailto:cgra...@columnit.com +44 (0) 750 658 3977 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: ADV: Cherwell Webinar
Chris, I completely agree...I was just ensuring that when you say 'If unhappy with Remedy, try Remedyforce', that people aren't confused thinking they are somehow not changing platforms/technologies. I took the Force.com training courses a few years ago and was very impressed with their capabilities. I know that BMC wouldn't agree, but moving from Remedy to Remedyforce is similar to moving from Remedy to SNOW, in that you are moving from one technology to another technology. I'm not comparing SNOW and Remedyforce in that statement, other than the fact that they are both different techonlogies from Remedy :) On Tue, Aug 5, 2014 at 2:46 PM, Grassi, Christopher cgra...@columnit.com wrote: ** Yes - It’s a different product but the design pulls a lot features and functions from Remedy ITSM as well as SDE. Also from a platform perspective some would say it’s a better product because it’s True PaaS with the trusted salesforce platform behind it. Every Remedyforce Go Live we have had has been very quiet…no services falling over, no jobs’s failing to run, no architecture failings, no performance issues, no mid tiers being overloaded, no stickybit issues, etc. :) You all know the drill :) -Chris On 4 Aug 2014, at 21:12, LJ LongWing lj.longw...@gmail.com wrote: ** But...RemedyForce IS another productit's not another company...but it is 100% a different product... On Mon, Aug 4, 2014 at 2:07 PM, Grassi, Christopher cgra...@columnit.com wrote: ** I’ve been using Remedy since Version 5 - if you are unhappy with Remedy for any reason, I would look at Remedyforce before going to another product. Feel free to reach out if you want to know more. -Chris Grassi cgras...@gmail.com On 4 Aug 2014, at 14:44, Kevin Shaffer kshaf...@partneritsm.com wrote: ** I have been hesitant to bring up the topic of Cherwell on the ARSList, but there seems to have been some interest and discussion about Cherwell last week. First of all, I have been a Remedy consultant since the late 90’s, version 3.x. I have experienced all the highs and lows that everyone describes on this list. I would love to see BMC succeed and Remedy continue to lead. The reality is I have witnessed many of my colleagues drift over to SNOW and others get out of the business completely, as we watched the competitors catch up and some even surpass in some areas as others have pointed out. The majority of our business is still BMC, but a growing portion of it is now Cherwell. Most of us are all facing similar challenges and questions from management. Why does the licensing model have to be so confusing?, Why do upgrades have to be so painful?, Why can’t I call support and get an onshore resource?, Why does on-premise or on-demand feel like a lifetime commitment?, etc. Whether or not you feel that any of the aforementioned questions are true about BMC Remedy, these questions are still being asked by management. Partner IT is hosting a one hour webinar on August 14, 2014 at 1 PM EST to discuss how Cherwell can address many of the “Why” questions we all face. The intended audience is not just Remedy users but rather companies that are evaluating options. Please contact me OFFLINE if you are interested in attending and I will send you a more formal invitation. We will have very techy people presenting to address anything that comes up. Kevin Shaffer, Senior Partner Partner IT, Inc. Office Phone: (888) 380-8899 Cell Phone: (316) 208-5341 Fax: (708) 887-1704 Email: kshaf...@partneritsm.com Website: http://www.partneritsm.com Follow Us: http://www.twitter.com/partneritsm YouTube: http://www.youtube.com/partneritsm _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: ADV: Cherwell Webinar
That sounds too good to be true. But at the same time we should try answering a very important question as honestly as we can. When building such inter product comparisons, are we attempting to compare apples to oranges. Is it as robust as the other? Is it as scalable? Is it as flexible when used as a development tool? Is it even a development tool? How easy is it to customize? What are implementation timelines? Does it encompass a broad spectrum of solutions under one umbrella? You get the drift.. If it doesn't fail, doesn't have jobs that fail, has no performance issues, does not face overload issues, etc. could mean nothing when you answer many similar questions as above. WITH ALL THAT said, sure, I would be interested to see what it is like. Joe _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grassi, Christopher Sent: Tuesday, August 05, 2014 4:46 PM To: arslist@ARSLIST.ORG Subject: Re: ADV: Cherwell Webinar Yes - It's a different product but the design pulls a lot features and functions from Remedy ITSM as well as SDE. Also from a platform perspective some would say it's a better product because it's True PaaS with the trusted salesforce platform behind it. Every Remedyforce Go Live we have had has been very quiet.no services falling over, no jobs's failing to run, no architecture failings, no performance issues, no mid tiers being overloaded, no stickybit issues, etc. :) You all know the drill :) -Chris On 4 Aug 2014, at 21:12, LJ LongWing lj.longw...@gmail.com wrote: ** But...RemedyForce IS another productit's not another company...but it is 100% a different product... On Mon, Aug 4, 2014 at 2:07 PM, Grassi, Christopher cgra...@columnit.com wrote: ** I've been using Remedy since Version 5 - if you are unhappy with Remedy for any reason, I would look at Remedyforce before going to another product. Feel free to reach out if you want to know more. -Chris Grassi cgras...@gmail.com On 4 Aug 2014, at 14:44, Kevin Shaffer kshaf...@partneritsm.com wrote: ** I have been hesitant to bring up the topic of Cherwell on the ARSList, but there seems to have been some interest and discussion about Cherwell last week. First of all, I have been a Remedy consultant since the late 90's, version 3.x. I have experienced all the highs and lows that everyone describes on this list. I would love to see BMC succeed and Remedy continue to lead. The reality is I have witnessed many of my colleagues drift over to SNOW and others get out of the business completely, as we watched the competitors catch up and some even surpass in some areas as others have pointed out. The majority of our business is still BMC, but a growing portion of it is now Cherwell. Most of us are all facing similar challenges and questions from management. Why does the licensing model have to be so confusing?, Why do upgrades have to be so painful?, Why can't I call support and get an onshore resource?, Why does on-premise or on-demand feel like a lifetime commitment?, etc. Whether or not you feel that any of the aforementioned questions are true about BMC Remedy, these questions are still being asked by management. Partner IT is hosting a one hour webinar on August 14, 2014 at 1 PM EST to discuss how Cherwell can address many of the Why questions we all face. The intended audience is not just Remedy users but rather companies that are evaluating options. Please contact me OFFLINE if you are interested in attending and I will send you a more formal invitation. We will have very techy people presenting to address anything that comes up. Kevin Shaffer, Senior Partner Partner IT, Inc. Office Phone: (888) 380-8899 tel:%2%29%20380-8899 Cell Phone: (316) 208-5341 tel:%28316%29%20208-5341 Fax: (708) tel:%28708%29%20887-1704 887-1704 Email: kshaf...@partneritsm.com Website: http://www.partneritsm.com http://www.partneritsm.com/ Follow Us: http://www.twitter.com/partneritsm YouTube: http://www.youtube.com/partneritsm _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: MSSQL server name / Instance name issue
Question … Is there any additional info in the install SQL log? I also found an older Microsoft article on setting TCP ports for named instances http://support.microsoft.com/kb/265808 This will let you use a port to specify an instance or use the server’s port and specify the instance with the \ in the server name Fred From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of patrick zandi Sent: Tuesday, August 05, 2014 2:00 PM To: arslist@ARSLIST.ORG Subject: Re: MSSQL server name / Instance name issue ** I have tried host, host\named instancehost\named instance:0,port host\named instance,port host then instance name going insane.. I can login with ssms, and I can query db no problem but the login is as hostname(or IP)\named instance,port name-W12-SQL-1\REMEDY,1435 8.1.01 does not like it with or without port (cause port is in the line below)... I actually built a server (8 of them) and after installation we had to change the ar.conf to hostname,port or they would not run.. I think someone at the Engineering area missed a step... but this was for a SQL Cluster.. it would let you install, but not bounce..now this one will not let me install.. On Tue, Aug 5, 2014 at 2:24 PM, Joe D'Souza jdso...@shyle.netmailto:jdso...@shyle.net wrote: ** Just to humor the installation script, have you tried putting the IP Address and server name entry into the hosts file on the AR System server where the MS-SQL client is installed? Also try installing the full client (client tools) and see if you can connect the SQL server manager and open a Query Analyzer session. Joe From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of patrick zandi Sent: Tuesday, August 05, 2014 12:42 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: MSSQL server name / Instance name issue ** 2012 os, 2012 sql server (multiple instances) I am using a name instance called remedy. Checking... ssms connects fine with the ip\remedy in the hostname or hostname\remedy which is the named instance name no problem. logged on to the sql server I see the port 1435 coming in from the ip of the remedy server (SSMS) not because of remedy install. On Tue, Aug 5, 2014 at 12:28 PM, Pierson, Shawn shawn.pier...@energytransfer.commailto:shawn.pier...@energytransfer.com wrote: ** What version are you running into this on? I want to say I had that problem with either 7.5 or maybe 7.6.4 but 8.1 doesn’t have that problem in my environment. I wish I could remember how I got around it. This may be my imagination, but there could be something akin to a portmapper on the SQL Server where you aren’t really using 1435. Can you connect with SSMS and then open up a command prompt and type netstat and hit enter and look for that SQL Server and see what port you are actually connecting to? That may be one thing to investigate. Thanks, Shawn Pierson Remedy Developer | Energy Transfer From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of patrick zandi Sent: Tuesday, August 05, 2014 11:16 AM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: MSSQL server name / Instance name issue ** http://technet.microsoft.com/en-us/library/ms191229%28v=sql.105%29.aspx shows the format: but it appears remedy does not follow it? also the drop down never works, but I guessed that was another bug. On Tue, Aug 5, 2014 at 12:01 PM, patrick zandi remedy...@gmail.commailto:remedy...@gmail.com wrote: it is a NAMED INSTANCE on the SQL Server... that is why the ip/named instancethen the instance name (which is different). On Tue, Aug 5, 2014 at 11:39 AM, patrick zandi remedy...@gmail.commailto:remedy...@gmail.com wrote: Lets start with the environment: When logging into MSSQL server management studio I use the following settings. Servername : name-w12-sql-1\remedy instance name : remedy with sa password and Voila.. no problems. if I view connection properties it says: Server name:: name-w12-sql-1/remedy,1435 instance name:: remedy With 2012 sql server you can create seperate instances within itself. hope that makes sense. On Tue, Aug 5, 2014 at 11:11 AM, patrick zandi remedy...@gmail.commailto:remedy...@gmail.com wrote: but if I take the slash out and put it into the instance name it fails as well. DB Information: Hostname or IP :: Hostname IP instance name : blank --- invalid instance if Hostname or IP :: Hostname IP instance name : remedy is says Instance name remedy is not validfor host ip/port Detected the sql server instance name-w12-sql-1\remedy for the host ip /port 1435 It tells you what it should be but cannot accept it.. On Tue, Aug 5, 2014 at 10:27 AM, Grooms, Frederick W frederick.w.gro...@xo.commailto:frederick.w.gro...@xo.com wrote: ** I believe it is telling you it
Re: BMC Remedyforce and MyIT 2.0 Webinar - Lunch and Learn
I would love to attend. Sent from my Verizon Wireless 4G LTE smartphone div Original message /divdivFrom: Grassi, Christopher cgra...@columnit.com /divdivDate:08/05/2014 17:00 (GMT-05:00) /divdivTo: arslist@ARSLIST.ORG /divdivSubject: BMC Remedyforce and MyIT 2.0 Webinar - Lunch and Learn /divdiv /div** Hi All, This message comes out of a previous thread - I’m happy to run a quick 30-60 min “lunch and learn session just for the ARS list to help everyone understand some of the Remedyforce basics - plus point out some of the key differences from Remedy ITSM (which we all know and love). I can also cover off MyIT 2.0 if that is of interest as well. Please let me know if you would be interested and what day/week/time works best. I can run a few of these Demo’s in August so if we get to 10+ plus people who are interested I will coordinate. Feel free to email back on this thread or contact me directly via email / number below: Thanks, Chris Grassi Director of Professional Services Column Technologies UK cgra...@columnit.com +44 (0) 750 658 3977 _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: BMC Remedyforce and MyIT 2.0 Webinar - Lunch and Learn
Since you are on UK time, what timeframe of the day would work best for you? This would help us who are on other time zones to let you know what might work for us. Yes, I would be interested. Cheers Joe _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grassi, Christopher Sent: Tuesday, August 05, 2014 5:00 PM To: arslist@ARSLIST.ORG Subject: BMC Remedyforce and MyIT 2.0 Webinar - Lunch and Learn Hi All, This message comes out of a previous thread - I'm happy to run a quick 30-60 min lunch and learn session just for the ARS list to help everyone understand some of the Remedyforce basics - plus point out some of the key differences from Remedy ITSM (which we all know and love). I can also cover off MyIT 2.0 if that is of interest as well. Please let me know if you would be interested and what day/week/time works best. I can run a few of these Demo's in August so if we get to 10+ plus people who are interested I will coordinate. Feel free to email back on this thread or contact me directly via email / number below: Thanks, Chris Grassi Director of Professional Services Column Technologies UK cgra...@columnit.com +44 (0) 750 658 3977 _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Queue Report w/ Members
Hello all, I am trying to figure out the best way to generate a report out of Remedy 7.0 that will not only tell me all of our support queues, but also who is in each queue. This sounds so painfully straight forward but every form I go looking on can't seem to report both pieces of information together. Anyone out there who can tell me the best way to accomplish this? I would be forever grateful. Tim B. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Queue Report w/ Members
Generate a join form that joins the source of both forms, and report on the join form On Aug 5, 2014 3:37 PM, Tim Buchanan tbucha...@samhealth.org wrote: Hello all, I am trying to figure out the best way to generate a report out of Remedy 7.0 that will not only tell me all of our support queues, but also who is in each queue. This sounds so painfully straight forward but every form I go looking on can't seem to report both pieces of information together. Anyone out there who can tell me the best way to accomplish this? I would be forever grateful. Tim B. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Queue Report w/ Members
Unless I have misunderstood the question, wouldn't CTM:Support Group Association give you that report? Assuming we are talking ITSM that is.. Joe _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: Tuesday, August 05, 2014 5:41 PM To: arslist@ARSLIST.ORG Subject: Re: Queue Report w/ Members ** Generate a join form that joins the source of both forms, and report on the join form On Aug 5, 2014 3:37 PM, Tim Buchanan tbucha...@samhealth.org wrote: Hello all, I am trying to figure out the best way to generate a report out of Remedy 7.0 that will not only tell me all of our support queues, but also who is in each queue. This sounds so painfully straight forward but every form I go looking on can't seem to report both pieces of information together. Anyone out there who can tell me the best way to accomplish this? I would be forever grateful. Tim B. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Queue Report w/ Members
Yes sorry, we are talking about ITSM. And I tried this form, but it gives me the queues as their ID numbers and not their names. So I can pull a report of various users and the queue ID's they are in, but I am looking for a way to get the queue names. Tim Buchanan Systems Analyst SHS|Information Services Desk: (541)768-4583 Cell: (541)974-1278 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe D'Souza Sent: Tuesday, August 05, 2014 2:43 PM To: arslist@ARSLIST.ORG Subject: Re: Queue Report w/ Members ** Unless I have misunderstood the question, wouldn't CTM:Support Group Association give you that report? Assuming we are talking ITSM that is.. Joe From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: Tuesday, August 05, 2014 5:41 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: Queue Report w/ Members ** Generate a join form that joins the source of both forms, and report on the join form On Aug 5, 2014 3:37 PM, Tim Buchanan tbucha...@samhealth.orgmailto:tbucha...@samhealth.org wrote: Hello all, I am trying to figure out the best way to generate a report out of Remedy 7.0 that will not only tell me all of our support queues, but also who is in each queue. This sounds so painfully straight forward but every form I go looking on can't seem to report both pieces of information together. Anyone out there who can tell me the best way to accomplish this? I would be forever grateful. Tim B. _ARSlist: Where the Answers Are and have been for 20 years_ Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Queue Report w/ Members
With a sub-report you should be able to get the group names using the ID numbers. For this you might need to connect to the database using the Oracle ODBC driver and use the AR System form views for reporting. Since you are reporting character fields and not date and other fields that require conversions, it should work. Joe _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Timothy Buchanan Sent: Tuesday, August 05, 2014 5:55 PM To: arslist@ARSLIST.ORG Subject: Re: Queue Report w/ Members Yes sorry, we are talking about ITSM. And I tried this form, but it gives me the queues as their ID numbers and not their names. So I can pull a report of various users and the queue ID's they are in, but I am looking for a way to get the queue names. Tim Buchanan Systems Analyst SHS|Information Services Desk: (541)768-4583 Cell: (541)974-1278 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe D'Souza Sent: Tuesday, August 05, 2014 2:43 PM To: arslist@ARSLIST.ORG Subject: Re: Queue Report w/ Members ** Unless I have misunderstood the question, wouldn't CTM:Support Group Association give you that report? Assuming we are talking ITSM that is.. Joe _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: Tuesday, August 05, 2014 5:41 PM To: arslist@ARSLIST.ORG Subject: Re: Queue Report w/ Members ** Generate a join form that joins the source of both forms, and report on the join form On Aug 5, 2014 3:37 PM, Tim Buchanan tbucha...@samhealth.org wrote: Hello all, I am trying to figure out the best way to generate a report out of Remedy 7.0 that will not only tell me all of our support queues, but also who is in each queue. This sounds so painfully straight forward but every form I go looking on can't seem to report both pieces of information together. Anyone out there who can tell me the best way to accomplish this? I would be forever grateful. Tim B. _ARSlist: Where the Answers Are and have been for 20 years_ _ Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: BMC Remedyforce and MyIT 2.0 Webinar - Lunch and Learn
I would be interested in this also. Thank you Tom On Tuesday, August 5, 2014 5:47 PM, Joe D'Souza jdso...@shyle.net wrote: ** Since you are on UK time, what timeframe of the day would work best for you? This would help us who are on other time zones to let you know what might work for us. Yes, I would be interested. Cheers Joe From:Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grassi, Christopher Sent: Tuesday, August 05, 2014 5:00 PM To: arslist@ARSLIST.ORG Subject: BMC Remedyforce and MyIT 2.0 Webinar - Lunch and Learn Hi All, This message comes out of a previous thread - I’m happy to run a quick 30-60 min “lunch and learn session just for the ARS list to help everyone understand some of the Remedyforce basics - plus point out some of the key differences from Remedy ITSM (which we all know and love). I can also cover off MyIT 2.0 if that is of interest as well. Please let me know if you would be interested and what day/week/time works best. I can run a few of these Demo’s in August so if we get to 10+ plus people who are interested I will coordinate. Feel free to email back on this thread or contact me directly via email / number below: Thanks, Chris Grassi Director of Professional Services Column Technologies UK cgra...@columnit.com +44 (0) 750 658 3977 _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: BMC Remedyforce and MyIT 2.0 Webinar - Lunch and Learn
Me too! From: David Charters da...@charterstechnologies.com To: arslist@ARSLIST.ORG Sent: Tuesday, August 5, 2014 5:19 PM Subject: Re: BMC Remedyforce and MyIT 2.0 Webinar - Lunch and Learn ** I would love to attend. Sent from my Verizon Wireless 4G LTE smartphone Original message From: Grassi, Christopher Date:08/05/2014 17:00 (GMT-05:00) To: arslist@ARSLIST.ORG Subject: BMC Remedyforce and MyIT 2.0 Webinar - Lunch and Learn ** Hi All, This message comes out of a previous thread - I’m happy to run a quick 30-60 min “lunch and learn session just for the ARS list to help everyone understand some of the Remedyforce basics - plus point out some of the key differences from Remedy ITSM (which we all know and love). I can also cover off MyIT 2.0 if that is of interest as well. Please let me know if you would be interested and what day/week/time works best. I can run a few of these Demo’s in August so if we get to 10+ plus people who are interested I will coordinate. Feel free to email back on this thread or contact me directly via email / number below: Thanks, Chris Grassi Director of Professional Services Column Technologies UK cgra...@columnit.com +44 (0) 750 658 3977 _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: ADV: Cherwell Webinar
Yes to all those :) 160,000+ customers use the SF platform to run their business. Over 1B transactions a day. Pretty impressive stuff. Full API capability, visualforce layer for HTML style coding, apex layer for server side scripting, workflow rules, approvals, realtime analytics and dashboards, eclipse developer tools, 3rd party developer tools, 5 min upgrades, objects are instantly mobile, etc. Now, there are some limitations but they all serve a purpose and are in place for a reason. Salesforce is also very good about making all platform limitations well known/published. Example - 500 fields per object. I can go into these in my session as well. Sent from my iPhone On 5 Aug 2014, at 22:13, Joe D'Souza jdso...@shyle.netmailto:jdso...@shyle.net wrote: ** That sounds too good to be true. But at the same time we should try answering a very important question as honestly as we can. When building such inter product comparisons, are we attempting to compare apples to oranges. Is it as robust as the other? Is it as scalable? Is it as flexible when used as a development tool? Is it even a development tool? How easy is it to customize? What are implementation timelines? Does it encompass a broad spectrum of solutions under one umbrella? You get the drift.. If it doesn’t fail, doesn’t have jobs that fail, has no performance issues, does not face overload issues, etc. could mean nothing when you answer many similar questions as above. WITH ALL THAT said, sure, I would be interested to see what it is like. Joe From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grassi, Christopher Sent: Tuesday, August 05, 2014 4:46 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: ADV: Cherwell Webinar Yes - It’s a different product but the design pulls a lot features and functions from Remedy ITSM as well as SDE. Also from a platform perspective some would say it’s a better product because it’s True PaaS with the trusted salesforce platform behind it. Every Remedyforce Go Live we have had has been very quiet…no services falling over, no jobs’s failing to run, no architecture failings, no performance issues, no mid tiers being overloaded, no stickybit issues, etc. :) You all know the drill :) -Chris On 4 Aug 2014, at 21:12, LJ LongWing lj.longw...@gmail.commailto:lj.longw...@gmail.com wrote: ** But...RemedyForce IS another productit's not another company...but it is 100% a different product... On Mon, Aug 4, 2014 at 2:07 PM, Grassi, Christopher cgra...@columnit.commailto:cgra...@columnit.com wrote: ** I’ve been using Remedy since Version 5 - if you are unhappy with Remedy for any reason, I would look at Remedyforce before going to another product. Feel free to reach out if you want to know more. -Chris Grassi cgras...@gmail.commailto:cgras...@gmail.com On 4 Aug 2014, at 14:44, Kevin Shaffer kshaf...@partneritsm.commailto:kshaf...@partneritsm.com wrote: ** I have been hesitant to bring up the topic of Cherwell on the ARSList, but there seems to have been some interest and discussion about Cherwell last week. First of all, I have been a Remedy consultant since the late 90’s, version 3.x. I have experienced all the highs and lows that everyone describes on this list. I would love to see BMC succeed and Remedy continue to lead. The reality is I have witnessed many of my colleagues drift over to SNOW and others get out of the business completely, as we watched the competitors catch up and some even surpass in some areas as others have pointed out. The majority of our business is still BMC, but a growing portion of it is now Cherwell. Most of us are all facing similar challenges and questions from management. Why does the licensing model have to be so confusing?, Why do upgrades have to be so painful?, Why can’t I call support and get an onshore resource?, Why does on-premise or on-demand feel like a lifetime commitment?, etc. Whether or not you feel that any of the aforementioned questions are true about BMC Remedy, these questions are still being asked by management. Partner IT is hosting a one hour webinar on August 14, 2014 at 1 PM EST to discuss how Cherwell can address many of the “Why” questions we all face. The intended audience is not just Remedy users but rather companies that are evaluating options. Please contact me OFFLINE if you are interested in attending and I will send you a more formal invitation. We will have very techy people presenting to address anything that comes up. Kevin Shaffer, Senior Partner Partner IT, Inc. Office Phone: (888) 380-8899tel:%2%29%20380-8899 Cell Phone: (316) 208-5341tel:%28316%29%20208-5341 Fax: (708) 887-1704tel:%28708%29%20887-1704 Email: kshaf...@partneritsm.commailto:kshaf...@partneritsm.com Website: http://www.partneritsm.comhttp://www.partneritsm.com/ Follow Us: http://www.twitter.com/partneritsm YouTube:
Re: OT - Larry Garlick is back!
We joked in 2000? at the announcement at the Disney Swan that Larry would be taking his share from the sale of Remedy to Peregrin and buying a small island somewhere. I can still picture the stage. I never worked for Remedy, but was a RAC when it meant something and the customer service and support gave you a strong sense of brand enthusiasm. He wouldn't know me from Adam, but I'd shake his hand and thank him for the good years. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years