Re: [EXTERNAL] Re: Using a BIRT Editor to Create or Modify Web Reports

[Elry]

Thanks Natalie...

I suspect that price will be an issue for us.  End of year - not much funds 
remaining.



On Tuesday, December 4, 2012 6:00:31 PM UTC-5, Stroud, Natalie K wrote:
>
> ** 
>  
> Analytics is a separate product – and I’ll warn you, the licensing is a 
> bit pricy.  Analytics comes with the ITSM universe by default.  If you 
> wanted to run reports that pull info from both ITSM and a custom Remedy 
> app, you’d need to customize the ITSM universe to include your custom 
> apps.  If you truly didn’t need ITSM data for reports, then I expect you’d 
> need to build a separate universe and I have no idea how complicated a 
> procedure that might be.
>
>  
>
> I would also recommend doing some research on what versions of AR System 
> Analytics can link to.  I’m thinking that we’ve had to either upgrade our 
> Analytics in parallel with another upgrade we did (couldn’t say offhand 
> whether that was AR System or ITSM) or else delay upgrading Analytics in 
> order to ensure compatibility with our existing system.
>
>  
>
> Good luck!
>
>  
>
> *Natalie Stroud*
>
> SAIC @ Sandia National Laboratories
>
> ARS-ITSM Tester
>
> Albuquerque, NM USA
>
> nkst...@sandia.gov 
>
> ITSM 7.6.04 SP2 – Windows 2003 – SQL Server 2008
>
>  
>
>  
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> ars...@arslist.org ] *On Behalf Of *Elry
> *Sent:* Tuesday, December 04, 2012 3:45 PM
> *To:* ars...@arslist.org 
> *Subject:* [EXTERNAL] Re: Using a BIRT Editor to Create or Modify Web 
> Reports
>
>  
>
> ** I have a client who would like to use Analytics with a custom 
> application and not the ITSM Suite.
>
> Should they contact the local Sales Rep for a price on Business Analytics, 
> or is this a product that comes with ARS.
>
>
>
> On Tuesday, December 4, 2012 5:28:42 PM UTC-5, Easter, David wrote:
>
> ** 
>  
> I suppose it could.  It comes with a Business Objects universe tailored to 
> BMC Remedy applications but when you purchase the Premium upgrade (which is 
> required to integrate with the Mid-Tier anyway), you get the entitlements 
> to all the features within Business Objects Premium Enterprise.  From there 
> you could create your own custom reports with AR System as the data source, 
> I’d expect.
>
>  
>
> -David J. Easter
>
> Manager of Product Management, AR System
>
> BSM & Atrium Solutions Management
>
> BMC Software, Inc.
>
>  
>
> The opinions, statements, and/or suggested courses of action expressed in 
> this E-mail do not necessarily reflect those of BMC Software, Inc.  My 
> voluntary participation in this forum is not intended to convey a role as a 
> spokesperson, liaison or public relations representative for BMC Software, 
> Inc.
>
>  
>  
> *From:* Elry [mailto:elry...@gmail.com] 
> *Sent:* Tuesday, December 04, 2012 2:24 PM
> *To:* ars...@googlegroups.com
> *Cc:* ars...@arslist.org; ars...@arslist.org; Easter, David
> *Subject:* Re: Using a BIRT Editor to Create or Modify Web Reports
>  
>  
>
> Hi David...
>
> *Can BMC Analytics be used with custom applications?*
>
>
>
> On Tuesday, December 4, 2012 11:35:22 AM UTC-5, Easter, David wrote:
>
> There are currently no short term plans to support later versions. 
>
> I do not expect that later versions will work since the editor version is 
> limited by the version of the embedded engine.  Later editors will 
> potentially insert constructs that are not recognized by the AR System web 
> reporting engine - thus later editors are not supported. 
>
> If/when the version of the embedded engine is updated to a later version, 
> I expect that an equivalent version of the editor would be supported. 
>
> If you have complicated reporting needs, BMC recommends considering the 
> BMC Analytics product - which is designed to fulfill the business needs of 
> customers with mature reporting requirements. 
>
>
> -David J. Easter 
> Manager of Product Management, AR System 
> BSM & Atrium Solutions Management 
> BMC Software, Inc. 
>   
> The opinions, statements, and/or suggested courses of action expressed in 
> this E-mail do not necessarily reflect those of BMC Software, Inc.  My 
> voluntary participation in this forum is not intended to convey a role as a 
> spokesperson, liaison or public relations representative for BMC Software, 
> Inc. 
>
>
> -Original Message- 
> From: Action Request System discussion list(ARSList) [
> mailto:ars...@arslist.org] On Behalf Of Frank Caruso 
> Sent: Tuesday, December 04, 2012 7:57 AM 
&

Re: Using a BIRT Editor to Create or Modify Web Reports

[Elry]

I have a client who would like to use Analytics with a custom application 
and not the ITSM Suite.

Should they contact the local Sales Rep for a price on Business Analytics, 
or is this a product that comes with ARS.



On Tuesday, December 4, 2012 5:28:42 PM UTC-5, Easter, David wrote:
>
> ** 
>
> I suppose it could.  It comes with a Business Objects universe tailored to 
> BMC Remedy applications but when you purchase the Premium upgrade (which is 
> required to integrate with the Mid-Tier anyway), you get the entitlements 
> to all the features within Business Objects Premium Enterprise.  From there 
> you could create your own custom reports with AR System as the data source, 
> I’d expect.
>
>  
>
> -David J. Easter
>
> Manager of Product Management, AR System
>
> BSM & Atrium Solutions Management
>
> BMC Software, Inc.
>
>  
>
> The opinions, statements, and/or suggested courses of action expressed in 
> this E-mail do not necessarily reflect those of BMC Software, Inc.  My 
> voluntary participation in this forum is not intended to convey a role as a 
> spokesperson, liaison or public relations representative for BMC Software, 
> Inc.
>
>  
>
> *From:* Elry [mailto:elry...@gmail.com ] 
> *Sent:* Tuesday, December 04, 2012 2:24 PM
> *To:* ars...@googlegroups.com 
> *Cc:* ars...@arslist.org ; ars...@arslist.org ; 
> Easter, David
> *Subject:* Re: Using a BIRT Editor to Create or Modify Web Reports
>
>  
>
> Hi David...
>
> *Can BMC Analytics be used with custom applications?*
>
>
>
> On Tuesday, December 4, 2012 11:35:22 AM UTC-5, Easter, David wrote:
>
> There are currently no short term plans to support later versions. 
>
> I do not expect that later versions will work since the editor version is 
> limited by the version of the embedded engine.  Later editors will 
> potentially insert constructs that are not recognized by the AR System web 
> reporting engine - thus later editors are not supported. 
>
> If/when the version of the embedded engine is updated to a later version, 
> I expect that an equivalent version of the editor would be supported. 
>
> If you have complicated reporting needs, BMC recommends considering the 
> BMC Analytics product - which is designed to fulfill the business needs of 
> customers with mature reporting requirements. 
>
>
> -David J. Easter 
> Manager of Product Management, AR System 
> BSM & Atrium Solutions Management 
> BMC Software, Inc. 
>   
> The opinions, statements, and/or suggested courses of action expressed in 
> this E-mail do not necessarily reflect those of BMC Software, Inc.  My 
> voluntary participation in this forum is not intended to convey a role as a 
> spokesperson, liaison or public relations representative for BMC Software, 
> Inc. 
>
>
> -Original Message- 
> From: Action Request System discussion list(ARSList) [mailto:
> ars...@arslist.org] On Behalf Of Frank Caruso 
> Sent: Tuesday, December 04, 2012 7:57 AM 
> To: ars...@arslist.org 
> Subject: Re: Using a BIRT Editor to Create or Modify Web Reports 
>
> Do you know if there are plans to support later versions? 
>
> ITSM 764 sp2 
>
> I just tried 4.2.1 and was able to create a report using the AR System ODA 
> driver but it would not run from the Midtier. I received missing object 
> errors. 
>
> Hay anyone else had luck using later versions? 
>
> Thank you 
>
> Frank 
>
> ___
>  
>
> 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" 
> _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: Using a BIRT Editor to Create or Modify Web Reports

[Elry]

Hi David...

*Can BMC Analytics be used with custom applications?*



On Tuesday, December 4, 2012 11:35:22 AM UTC-5, Easter, David wrote:
>
> There are currently no short term plans to support later versions. 
>
> I do not expect that later versions will work since the editor version is 
> limited by the version of the embedded engine.  Later editors will 
> potentially insert constructs that are not recognized by the AR System web 
> reporting engine - thus later editors are not supported. 
>
> If/when the version of the embedded engine is updated to a later version, 
> I expect that an equivalent version of the editor would be supported. 
>
> If you have complicated reporting needs, BMC recommends considering the 
> BMC Analytics product - which is designed to fulfill the business needs of 
> customers with mature reporting requirements. 
>
>
> -David J. Easter 
> Manager of Product Management, AR System 
> BSM & Atrium Solutions Management 
> BMC Software, Inc. 
>   
> The opinions, statements, and/or suggested courses of action expressed in 
> this E-mail do not necessarily reflect those of BMC Software, Inc.  My 
> voluntary participation in this forum is not intended to convey a role as a 
> spokesperson, liaison or public relations representative for BMC Software, 
> Inc. 
>
>
> -Original Message- 
> From: Action Request System discussion list(ARSList) [mailto:
> ars...@arslist.org ] On Behalf Of Frank Caruso 
> Sent: Tuesday, December 04, 2012 7:57 AM 
> To: ars...@arslist.org  
> Subject: Re: Using a BIRT Editor to Create or Modify Web Reports 
>
> Do you know if there are plans to support later versions? 
>
> ITSM 764 sp2 
>
> I just tried 4.2.1 and was able to create a report using the AR System ODA 
> driver but it would not run from the Midtier. I received missing object 
> errors. 
>
> Hay anyone else had luck using later versions? 
>
> Thank you 
>
> Frank 
>
> ___
>  
>
> 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" 
>

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: New command line tool RRR|MenuToNav added

[Elry]

Very Nice Misi...

I know - I will make use of this for the next upgrade project.


On Tuesday, December 4, 2012 7:54:18 AM UTC-5, Misi Mladoniczky wrote:
>
> Hi, 
>
> This tool converts your old-style forms with Menu Bars for starting 
> Active-Links to the new Horizontal Navigation field supported by Mid-Tier. 
>
> I am not sure exactly how much of a problem this is for you, but I had a 
> situation with a custom application with some 400 forms, where it turned 
> out that 87 of them had Menu Bar items, and many of them in multiple 
> views. The total number of Menu Bar items was 933. 
>
> To reduce the manual work of deleting these 933 fields and adding some new 
> buttons manually to trigger the underlying Active-Links, I decided to 
> create a tool to automate the process. 
>
> Sample execution: 
> rrrMenuToNav.exe -i menubar400forms.def -o navigation87forms.def 
>
> I think that further explanation might be superfluous... 
>
> Download and details here: 
> https://www.rrr.se/cgi/tools/main#rrrMenuToNav 
>
> Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) 
>
> Products from RRR Scandinavia (3 x Best R.O.I. Award at WWRUG10/11/12): 
> * RRR|License - Not enough Remedy licenses? Save money by optimizing. 
> * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. 
> Find these products, and many free tools and utilities, at http://rrr.se. 
>
> ___
>  
>
> 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: AR System & ITSM Upgrades (we are WAY behind)

[Elry]

I like Jiri's approach...

Sometimes the devil is in the details.  Even well planned out approaches 
usually result in more time and effort that originally imagined. 

Upgrades that involve major jumps between versions can become 
uncontrollable.  Maybe back in the day when the ITSM deployments were less 
complex this sort of thing could be done seamlessly, but now if you don't 
keep pace - "cut over" is a good option to explore.

Last time I did a major upgrade like this - I aged 10 years in 6 months.

Good Luck Bud!

On Wednesday, November 21, 2012 5:02:36 AM UTC-5, Jiri Pospisil wrote:
>
> Hi, 
>
> After being through upgrade from 7.0.1 to 7.6.03, I would strongly 
> recommend considering a different strategy. 
> Rather than spending tons of time making the upgrade scripts work, I would 
> recommend building a fresh version 8 environment, recreate your 
> customisations and then invest time in defining procedure for data 
> migration. 
> With the data management tool, this should not be that difficult. 
> You may also consider other tools such as rrrchive to migrate the data. 
>
> Other option might be trying to convince your stakeholders to leave 
> historical data in the old system and start fresh in the new environment 
> with the old data remaining available for reporting/viewing. 
>
> Hope this helps. 
>
> Jiri Pospisil 
> Remedy Specialist, IT Production 
> LCH Clearnet 
>
>
> -Original Message- 
> From: Action Request System discussion list(ARSList) [mailto:
> ars...@arslist.org ] On Behalf Of Mary C. 
> Sent: 21 November 2012 02:05 
> To: ars...@arslist.org  
> Subject: AR System & ITSM Upgrades (we are WAY behind) 
>
> Hi, 
>
> We are on AR System 7.0.01 Patch 006, CMDB 2.0.1, ITSM 7.0.3 Patch 006 and 
> SLM 7.0.1 Patch 4.  We were unable to consider upgrading until now, and of 
> course this is going to be a major effort from what I can see.  We have 
> some customizations, but I think I could rebuild them from scratch if I had 
> to.  We are in a Windows/SQL server setup and are running a server group. 
>  We want to upgrade everything to 8.0 
>
> Here is a high-level upgrade path that Support recommended. 
> A) Upgrade ITSM 7.0.3 patch 6 to ITSM 7.0.3 patch 9. 
> B) Run ARserver 7.6.04 patch 4 in upgrade mode. 
> C) Run the difference report to find the customization. 
> D) Create Overlay to retain customization. 
> E) Then upgrade CMDB 7.6.04 patch 4 
> F) Then upgrade ITSM 7.6.04 patch 4. 
> G) Once everything is working fine upgrade ARS, CMDB and ITSM to 8.0 
>
> Do you all agree with this upgrade path?  Would you recommend another 
> approach? 
> Any advice you can give me would be appreciated.  Many of you have listed 
> lots of gotchas, so I am semi-planning for those pitfalls. 
>
> Thank! 
>
> ___
>  
>
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org 
> attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" 
>
>
> A copy of the LCH.Clearnet e-mail disclaimer can be found at: 
> www.lchclearnet.com/disclaimer/email   
>
> LCH.Clearnet Limited, Registered Office: Aldgate House, 33 Aldgate High 
> Street, London EC3N 1EA. 
> Recognised as a Clearing House under the Financial Services & Markets Act 
> 2000. Reg in England No.25932. 
> LCH.Clearnet SA, Siège Social, 18 rue du Quatre Septembre, 75002 Paris, 
> Chambre de Compensation conformément au Code Monétaire et Financier. 
>
> ___
>  
>
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org 
> attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" 
>

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

Re: Returning to Remedy after a long hiatus

[Elry]

Hey Rick...

Welcome back!  If you really want to ramp up quick - I would suggest some 
of the online courses (they are not that expensive anymore).

http://www.bmc.com/education/learning-paths 

It's not like the old days where one guy can know all the modules - let 
alone the ARS platform.

Hey Lee - great idea about the annual fee!!!


On Wednesday, July 25, 2012 8:44:17 AM UTC-4, Lee Cullom wrote:
>
> Rick, 
>
> The Remedy culture lives on!  Welcome back!  I had to leave home for a 
> time too... in order to ensure that this home was the best home.  Let me 
> tell you this... after exploring Service-Now, CA SDM, HP SM, IBM TSRM, 
> Remedy and SDE in-depth.  Remedy still remains the best.  What's 
> interesting is that the real threat to Remedy is Remedyforce because of the 
> force.com platform.  But, what's even more interesting than that is that 
> Remedy ARS is still a better platform than force.com.  I wish BMC would 
> turn Remedy into a PaaS before it's too late! 
>
> Anyone up for paying $999/year to be part of a Remedy development 
> community for unlimited development access to Remedy?  Please vote yay now 
> on the list... BMC - please watch the revenue stack up as the yes's come 
> in... 
>
> And then, let's build some apps that go head to head with force.com... and 
> let 'em feel the ARSlist dev community heat! 
>
> Lee 
>
> Lee Cullom | Northcraft Analytics 
> IT Metrics Specialist | Business Intelligence for ITSM 
> Direct - 678-438-7244 | lee.cul...@northcraftanalytics.com 
> Main - (678) 664-ITSM 
>
> http://www.northcraftanalytics.com 
> Click on "View Demo" to see the product in action 
>
> -Original Message- 
> From: Action Request System discussion list(ARSList) [mailto:
> arslist@ARSLIST.ORG] On Behalf Of Rick Westbrock 
> Sent: Tuesday, July 24, 2012 6:34 PM 
> To: arslist@ARSLIST.ORG 
> Subject: Returning to Remedy after a long hiatus 
>
> Hello listers- 
>
> Some of you might possibly remember me from several years ago when I was 
> working at a large national retailer. I was only able to devote about 30% 
> of my time to Remedy and after several years of trying to convince 
> management that IT could provide many more benefits to the company as a 
> whole (and not just IT) I finally gave up on repeating my message to deaf 
> ears. 
>
> Fast forward quite a few years and I've left that retailer to work as a 
> full-time developer with QMX. I am very happy to be back but I've got a lot 
> to learn not only on the current version of ARS (we were still on 7.0.1 at 
> my old shop) but also learning ITSM from the ground up. I will be lurking 
> here and trying to get back to my old habit of picking up bits of knowledge 
> here and there by reading posts to the list. 
>
>
> -Rick 
> __ 
> Rick Westbrock 
> Remedy Developer 
> QMX Support Systems 
>
> ___
>  
>
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 
> www.wwrug12.com ARSList: "Where the Answers Are" 
>
> ___
>  
>
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org 
> attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" 
>

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

Re: View Form Fails With Linked Database

[Elry]

Hi Jiri...

I wanted to avoid this option because I have about 20 tables.

I have done this when I had a MSSQL to Oracle connection, but I was kind of 
hoping that I could avoid it here...

I am going to try synonyms for the database link name - if this fails then 
it's time to put on the "Bob the Builder" hat.

Thanks.


On Friday, March 23, 2012 11:53:10 AM UTC-4, Jiri Pospisil wrote:
>
> ** 
>
> Try creating a local view of the remote table first, i.e. in the Remedy 
> database.
>
> Then build the view form on the local view rather than remote table with 
> all the link connection string.
>
> This way you get much better chance that the view form gets built since 
> Remedy can see it as a simple local view.
>
>  
>
> Regards
>
> Jiri Pospisil
>
> LCH Clearnet
>
>  
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> arslist@ARSLIST.ORG] *On Behalf Of *Elry
> *Sent:* 23 March 2012 15:48
> *To:* arslist@ARSLIST.ORG
> *Subject:* View Form Fails With Linked Database
>
>  
>
> ** Hi Folks...
>
>  
>
> I am having a little trouble creating and saving a View Form based on a 
> MSSQL to MSSQL database link.
>
>  
>
> Environment:
>
>- Windows Server 2008
>- ARS 7.5 Patch 2
>- MSSQL Server 2008
>
> Preface:
>
>  
>
> We have followed what is outlined in the manual for this procedure:
>
>  
>
> ==​
>
>  Setting up a remote database for view forms
>
> ==​
>
> *SQL Server Setup*
>
> ·  Create a link to the remote database and either give ARAdmin an 
> account on the remote database or use the proper login credentials.
>
> ·  Turn on Distributed Transaction Coordinator for both the local and the 
> remote databases.
>
> ·  Specify the following server configuration setting in the ar.conf (
> ar.cfg) file:
>
> SQL-Server-Set-ANSI-Defaults: T
>
> This setting enables the DB-Library connection that AR System uses to use 
> ANSI-NULLs and ANSI warnings. There should be no impact on the performance 
> of the database. For more information about the ar.conf (ar.cfg) file, 
> see the*Configuration Guide*.
>
> The format for the table name is:
>
> LINKNAME.DATABASENAME.OWNER.​TABLENAME 
>
> ==​
>
>  
>
> What happens:
>
>1. We try to connect to this table: 
>swarsdog23\inac.arsystem.dbo.​INAC_SDS_DATA_PPL_People 
>2. The available columns that are returned are all Integers.
>3. We try to go ahead and create the View Form anyway.
>4. When we try to save we get a save failed error 552. that references 
>SQL Server 102:  Failure during SQL operation to the database syntax near 
>'\'. (SQL Server 102).
>5. The CREATE statement in the SQL Log uses the table 
>name:   swarsdog23\inac.​arsystem.dbo.INAC_SDS_DATA_​PPL_People 
>6. When I run straight SQL from the calling database we can execute 
>and return entries:  SELECT * from 
>"swarsdog23\inac".arsystem.​dbo.INAC_SDS_DATA_PPL_People 
>
> Conclusions:
>
>1. Somehow the Linked Server Name is creating a problem.
>2. We have tried "[ ]" and using double quotes in the View Table 
>creation wizard and this fails; therefore, we cannot alter the naming.
>3. Somehow in the CREATE statement - ARS fails to place quotes around 
>the LINKNAME.
>4. swarsdog23 is the name of our production database server (not the 
>real name, but the syntax is correct) - we cannot change this right now.
>
>  
>
> Query:
>
>1. Is it the name of the database server that poses the probem?  OR
>2. Is this a bug?
>
>  
>
>  
>
>
> _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_
>
>
> **​**​**​***
>
>  
>
> This email is intended for the named recipient(s) only. Its contents are 
> confidential and may only be retained by the named recipient(s) and may 
> only be copied or disclosed with the consent of LCH.Clearnet Limited and/or 
> LCH.Clearnet SA. If you are not an intended recipient please delete this 
> e-mail and notify postmas...@lchclearnet.com.
>
> LCH.Clearnet Limited, LCH.Clearnet SA and each other member of the 
> LCH.Clearnet Group accept no liability, including liability for negligence, 
> in respect of any statement in this email.
>
> The contents of this email are subject to contract in all cases, and 
> LCH.Clearnet Limited and/or LCH.Clearnet SA makes no c

Re: View Form Fails With Linked Database

[Elry]

Your right Joe - I do recall the last time I created a database link I 
restarted just to be on the safe side.

Just tried it now.  Unfortunately, we still have the same problem.


On Friday, March 23, 2012 12:13:53 PM UTC-4, Joe Martin D'Souza wrote:
>
> ** 
>   
> Did you restart your SQL server database engine after you did that change? 
> To the best of my knowledge, that change mandates a restart of the database 
> engine..
>  
> Joe
>   
>  *From:* Elry  
> *Sent:* Friday, March 23, 2012 11:48 AM
> *Newsgroups:* public.remedy.arsystem.general
> *To:* arslist@ARSLIST.ORG 
> *Subject:* View Form Fails With Linked Database
>  
> ** Hi Folks... 
>  
> I am having a little trouble creating and saving a View Form based on a 
> MSSQL to MSSQL database link.
>  
> Environment:
>  
>- Windows Server 2008
>- ARS 7.5 Patch 2
>- MSSQL Server 2008
>
> Preface:
>  
> We have followed what is outlined in the manual for this procedure:
>  
>  ==​
> Setting up a remote database for view forms
> ==​
>  *SQL Server Setup*
>  
> - Create a link to the remote database and either give ARAdmin an 
>account on the remote database or use the proper login credentials.
> - Turn on Distributed Transaction Coordinator for both the local and 
>the remote databases.
> - Specify the following server configuration setting in the ar.conf (
>ar.cfg) file:
>
>SQL-Server-Set-ANSI-Defaults: T
>
>This setting enables the DB-Library connection that AR System uses to 
>use ANSI-NULLs and ANSI warnings. There should be no impact on the 
>performance of the database. For more information about the ar.conf (
>ar.cfg) file, see the*Configuration Guide*.
>
>The format for the table name is:
>
>LINKNAME.DATABASENAME.OWNER.​TABLENAME 
>
>
> ==​
>  
> What happens:
>  
>1. We try to connect to this table: 
>swarsdog23\inac.arsystem.dbo.​INAC_SDS_DATA_PPL_People 
>2. The available columns that are returned are all Integers. 
>3. We try to go ahead and create the View Form anyway. 
>4. When we try to save we get a save failed error 552. that references 
>SQL Server 102:  Failure during SQL operation to the database syntax near 
>'\'. (SQL Server 102). 
>5. The CREATE statement in the SQL Log uses the table name:  
>swarsdog23\inac.arsystem.dbo.​INAC_SDS_DATA_PPL_People 
>6. When I run straight SQL from the calling database we can execute 
>and return entries:  SELECT * from "swarsdog23\inac".arsystem.
>dbo​.INAC_SDS_DATA_PPL_People 
>
> Conclusions:
>  
>1. Somehow the Linked Server Name is creating a problem. 
>2. We have tried "[ ]" and using double quotes in the View Table 
>creation wizard and this fails; therefore, we cannot alter the naming. 
>3. Somehow in the CREATE statement - ARS fails to place quotes around 
>the LINKNAME. 
>4. swarsdog23 is the name of our production database server (not the 
>real name, but the syntax is correct) - we cannot change this right now.
>
>  
> Query:
>  
>1. Is it the name of the database server that poses the probem?  OR 
>2. Is this a bug?
>
> _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

View Form Fails With Linked Database

[Elry]

Hi Folks...

I am having a little trouble creating and saving a View Form based on a 
MSSQL to MSSQL database link.

Environment:

   - Windows Server 2008
   - ARS 7.5 Patch 2
   - MSSQL Server 2008
   
Preface:

We have followed what is outlined in the manual for this procedure:

==
 Setting up a remote database for view forms
==
*SQL Server Setup*

   - Create a link to the remote database and either give ARAdmin an 
   account on the remote database or use the proper login credentials.
   - Turn on Distributed Transaction Coordinator for both the local and the 
   remote databases.
   - Specify the following server configuration setting in the ar.conf (
   ar.cfg) file:
   
   SQL-Server-Set-ANSI-Defaults: T
   
   This setting enables the DB-Library connection that AR System uses to 
   use ANSI-NULLs and ANSI warnings. There should be no impact on the 
   performance of the database. For more information about the ar.conf (
   ar.cfg) file, see the*Configuration Guide*.
   
   The format for the table name is:
   
   LINKNAME.DATABASENAME.OWNER.TABLENAME 
   
   
==

What happens:

   1. We try to connect to this table: 
   swarsdog23\inac.arsystem.dbo.INAC_SDS_DATA_PPL_People 
   2. The available columns that are returned are all Integers.
   3. We try to go ahead and create the View Form anyway.
   4. When we try to save we get a save failed error 552. that references 
   SQL Server 102:  Failure during SQL operation to the database syntax near 
   '\'. (SQL Server 102).
   5. The CREATE statement in the SQL Log uses the table name:  
swarsdog23\inac.arsystem.dbo.INAC_SDS_DATA_PPL_People 
   6. When I run straight SQL from the calling database we can execute and 
   return entries:  SELECT * from "swarsdog23\inac".arsystem.
   dbo.INAC_SDS_DATA_PPL_People 

Conclusions:

   1. Somehow the Linked Server Name is creating a problem.
   2. We have tried "[ ]" and using double quotes in the View Table 
   creation wizard and this fails; therefore, we cannot alter the naming.
   3. Somehow in the CREATE statement - ARS fails to place quotes around 
   the LINKNAME.
   4. swarsdog23 is the name of our production database server (not the 
   real name, but the syntax is correct) - we cannot change this right now.


Query:

   1. Is it the name of the database server that poses the probem?  OR
   2. Is this a bug?





___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

Re: Job opportunities for foreigners

[Elry]

Jose...

Come to Canada buddy.

Lots of work in Vancouver, Toronto, and Montreal.

Canada is always looking for technical professionals.


On Feb 23, 1:31 am, Jose Huerta  wrote:
> Hi all,
>
> Thank you for your answers (including the ones from people that reply me
> directly).
>
> I'm not restricted to USA. I have no particular interest in USA. I planning
> to go wherever is needed. But I have a "handicap": My languages are
> Spanish, Catalan and English. That restricts my options to countries with
> these languages: USA, Canada, UK, New Zealand, Australia,  Since I
> don't want to go to Mexico or South America.
>
> And all the job optiions I see from this countries are from USA.
>
> Regards,
>
> Jose M. Huerta
> Project Manager**
>
> Movil: 661 665 088
>
> Telf.: 971 75 03 24
>
> Fax: 971 75 07 94
>
>  
>
> SM2 Baleares S.A.
> C/Rita Levi 
>
> Edificio SM2 Parc Bit
>
> 07121 Palma de Mallorca
>
>           
>   
>      
>
> La información contenida en este mensaje de correo electrónico es
> confidencial. La misma, es enviada con la intención de que únicamente sea
> leída por la persona(s) a la(s) que va dirigida. El acceso a este mensaje
> por otras personas no está autorizado, por lo que en tal caso, le rogamos
> que nos lo comunique por la misma vía, se abstenga de realizar copias del
> mensaje o remitirlo o entregarlo a otra persona y proceda a borrarlo de
> inmediato.
>
> P Por favor, no imprima este mensaje ni sus documentos adjuntos si no es
> necesario.
>
>
>
>
>
>
>
>
>
> On Wed, Feb 22, 2012 at 18:19,  wrote:
> > **
> > That made me laugh... Been there too. Got stuck in an airport for 24 hours
> > trying to straighten the mess it created.
>
> > But getting work in the US as a non us citizen and as a non permanent
> > resident is harder now then it used to be. But still possible.
>
> > Thank you,
>
> > Pascale Sterrett
>
> > *p.romain.arsl...@parsolutions.co.uk*
> > Sent by: arsl...@arslist.org
>
> > 02/22/2012 09:07 AM
> > Please respond to
> > arsl...@arslist.org
>
> > To
> > arsl...@arslist.org
> > cc
> > Subject
> > Re: Job opportunities for foreigners
>
> > **
> > That reminds me of the time many years ago when I arrived in the US and
> > replied ‘Yes’ to the question of whether I was there to work.
>
> > Had I said ‘No’, I was on business I’d have got out of the airport a lot
> > quicker!!
>
> > *From:* Action Request System discussion list(ARSList) [mailto:
> > arsl...@arslist.org] *On Behalf Of *Rick Cook*
> > Sent:* 22 February 2012 15:40*
> > To:* arsl...@arslist.org*
> > Subject:* Re: Job opportunities for foreigners
>
> > **
>
> > Jose, there are lots of jobs open at non-government places that would
> > require neither citizenship nor a security clearance, and you can sometimes
> > get a contract firm to sponsor an H1-B.  Might look at it from that angle.
>
> > Rick
> > On Feb 22, 2012 10:29 AM, "Drew Shuller" 
> > <*drew.shul...@gmail.com*>
> > wrote:
> > Jose,
>
> > The positions that you refer to are for US government institutions
> > that require security clearances for the people doing the work. For
> > regular clearances, you must be a US citizen. Someone correct me if
> > I'm wrong.
>
> > I certainly wouldn't concentrate solely on US positions. There should
> > be positions open in other countries.
>
> > Drew Shuller
> > Soto Cano Air Base
> > Honduras
>
> > On Wed, Feb 22, 2012 at 9:18 AM, Jose Huerta 
> > <*jose.hue...@sm2baleares.es*>
> > wrote:
> > > ** Hi all,
>
> > > Recently I started to think in the option to go outside my country to
> > look
> > > for a better job. Well, I think I'm unpaid for the kind of job I'm doing
> > > right know and don't see to many opportunities in my birthplace
> > (Mallorca,
> > > Spain). Also the economical crisis we are suffering, places us in a very
> > > difficult situation, where the public administration doesn't pays the
> > bills,
> > > and everybody is susceptible to be fired. We are not like in Greece, but
> > the
> > > fear to be fired is flying over us.
>
> > > I see all the jobs positions that you are publishing on this list, and I
> > > always see the same sentence: "US citized, and ability to obtain a secret
> > > level clearance." I'm starting to think that it is impossible to work as
> > a
> > > Remedy consultant in USA. Am I right?
>
> > > Regards,
>
> > > Jose Huerta
> > > *http://theremedyforit.com/*
>
> > > _attend WWRUG12 *www.wwrug.com*ARSlist: "Where
> > the Answers Are"_
>
> > ___ 
> > 
> > UNSUBSCRIBE or access ARSlist Archives at
> > *www.arslist.org*
> > attend wwrug12 *www.wwrug12.com*ARSList: "Where
> > the Answers Are"
> > _attend WWRUG12 *ww

Re: 7.5 to 7.6.04 upgrade estimate?

[Elry]

Sammy...

If you were following a thread - it somehow got lost...


On Feb 21, 1:30 pm, Samuel J Albury III  wrote:
> Are there customizations ?
>
> ___ 
> 
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> attend wwrug12www.wwrug12.comARSList: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

Re: How to create an archival server in remedy in windows platform!!!

[Elry]

Now I have a clearer picture of what you are trying to do...

The key to your success will be in understanding the underlying data
dictionary (not in the traditional sense either).  You will need some
help in this area.  You may want to ask Joe D. for help.

1. ITSM is very complex system and difficult to archive.  Most folks
just run one instance and when a new version comes out - they cut over
completely and just import the Foundation data.  The more modules you
use the more complex the archiving strategy.
2. BMC could have simplified archiving for us if they would have
allowed archiving forms to be used between servers.
3. You are going to have to first decide what pieces of data you would
like to keep.  For example if you were going to keep Incidents - you
would have to know what  associated elements are required to show
incidents for example:
        - Attachments
        - Impacted Areas
        - Associations
        - Work Logs
        - Etc
I guess - the rule of thumb - would be to look at the table fields
that display data for the key forms in the modules and make sure that
data is brought over.
4.  You will then have to deal with the issue of workflow.  If these
are archived records - all you want to do is view the data and not
modify; therefore, you would want to lock down the forms(all fields
read only) and disable workflow that would allow modifications.
5. When it comes to licensing - you should check with your local
Remedy Sales person.  The licensing model is constantly changing -
they may have something reasonable once they are aware of your needs.
My suggestion though would be to stress that you need read only
licenses, since you will never modify any data.
6. Well since you don't have a lot of data - I think you could really
leverage DSO to sync your Archive server.  Again - you will want to be
careful about how much and what you archive.  If you try to archive
the whole ITSM Suite - I think you will not have much luck.
7. Remember Archive Forms must exist on the same server.  You cannot
use Archive forms between servers. Once you have the data in the
Archive forms - you are going to have to come up with a Strategy that
will help you move the data from the Archive forms to the new Archive
Box.  Naturally, you will also need a mechanism to remove the old
entries off the Archive Box.  I suppose you could use DSO to do this
part.
8. The frequency of archiving - will have to be yours to determine.  I
usually - look at the rate of record accumulation.  I would look at
the tables that I want to archive and determine their rate of growth -
then archive according to how much data you want to have in your
Production tables.

Unfortunately, I do not have any documents specific to this - I have
found that for the most part - I have to determine what needs to be
done - then draw up strategy that can be documented for the specific
case.  Then there is the issue of what technologies to use?

On Feb 15, 2:57 pm, Hari Vishwakarma  wrote:
> Hi All,
> @Allen,
> Thanks for your valuable suggestions. But out of the available options, i
> think i need to choose the best otherwise i will be playing with fire.
>
> I am looking to archive the data in the following way:
>
> 1. Selective archiving( with conditions such as all the tickets which are
> closed by the system, cancelled tickets with work logs,attachments), but
> here full archiving of data is also open and in mind.
> 2. As far as archived data is concerned, we will be using that data for
> reporting as well as for audit purpose.
> 3.We are ready to stand up another instance of remedy(But not sure about
> the licensing terms of BMC like AR server license,ITSM Apps
> license,Database license.)
> 4.We have implemented Remedy in our company four months back,so data is not
> so huge, but as the time passes on, it will grow further.So, can you
> suggest what frequency should we adopt for archiving(like daily,
> weekly,monthly)
> 5.Initially i am thinking of using DSO,but seems it is complex, so i am
> going for archive forms. While archiving, i want to move the data
> completely to newly created remedy instance which will reduce the load on
> the production and can be used for reporting purpose on the newly created
> remedy instance. On production, only the current data will resides like 3-4
> months old data.
>
> I also request you to share any document which will guide me step by step
> approach or plan, which will help me to achieve the required goal.
>
> Guidance is always a ray of light to eliminate the darkness of ignorance.
>
> With a smiling face
>
> Regards
>
> Hari
>
>
>
>
>
>
>
>
>
> On Tue, Feb 14, 2012 at 8:23 PM, Elry  wrote:
> > Hey Hari...
>
> > Some quick opinions :
>
> > 1. Looks like you will be doing selective archiving & not fixed
> > archiving.  What thi

Re: How to create an archival server in remedy in windows platform!!!

[Elry]

Hey Hari...

Some quick opinions :

1. Looks like you will be doing selective archiving & not fixed
archiving.  What this means for us is that you will be selecting
criteria for tickets that will be archived as opposed to archiving all
tickets for a fixed time period.  This means that you will have to
make multiple passes during each archive transaction to get older
tickets.
2. If you are going to close tickets - then you will probably want to
get all the data associated with the ticket (i.e. work logs,
attachments etc.).
3. You have to decide whether or not you want to use the same Remedy
interface to look at and retrieve the archived data (you could just
rely on reports).
4. If you use the Remedy interface then - you will have to stand up
another Remedy instance (granted - that there will be only viewing of
data - so there will not be a need for write licenses).
5. Frequency of archiving, and server performance will depend on how
much data you will be moving.
6. DSO may not be the best method for data migration.
7. If you use archive forms - note that the archive forms must be on
the same server as your Remedy instance (this still leaves your data
on your production box).
8. Remedy Migrator is another option (if you can afford it).  You are
able to configure private TCP ports to help reduce the load on the
server. Only drawback - it does not look like there is a way to delete
your record after archiving; therefore, this will have to be an
escalation or some other workflow.
9. In the past I have used EIE OR AIE OR AI - not sure what they are
calling it now.  This works ok, but it's newest incarnation that
leverages the Pentaho Spoon ETL engine looks to be superior (I think
you need version 7.6.04 of ITSM).

There are third party options like (rrchive is free and picks up where
the Migrator left off):

META-UPDATE: http://www.softwaretoolhouse.com/product/SthMupd/index.html
RRCHIVE:  http://www.rrr.se/en/


On Feb 14, 8:31 am, Hari Vishwakarma  wrote:
> Hi,
>
> We are planning to have archiving server with the following strategies in 
> place:
>
> 1. We will be moving our production server data to the newly created
> archiving server with certain conditions like incident=closed or
> cancelled, and we will be archiving the data on an interval of 2-3
> months.
>
> Here, i have few queries:
> a.Will this archival server requires any new hardware,os,remedy ars,
> remedy apps, licenses.
> Plz note that my current remedy environment is on windows 2003 server, sql 
> serv
>  er 2005 database,ARS 7.5.04,remedy ITSM apps7.6.01
> b. Can this archival server be synched on an database level, if yes then how?
>
> 2. what frequency shall we use to archive the data from the production?
>
> 3. will this hamper my production server performance?
>
> 4. We are planning to use archiving forms or DSO, please suggest its
> pros & cons while implementing.
>
> Please suggest .
>
> Regards
>
> Hari
>
> One more thing, how this movement of data will happen even after
> 1.We want our production data to be moved from production to archival se
>
>
>
>
>
>
>
>
>
> On Tue, Feb 14, 2012 at 1:17 AM, Elry  wrote:
>
> > Well Hari...
>
> > We currently just finishing up the creation of an archival server.
>
> > I guess my key questions would be:
>
> > 1. Do you have any Archive Policies in place (i.e. Incident Tickets
> > will be automatically closed after 90 Days).
> > 2. What applications are you running (i.e. ITSM or Custom
> > Applications)?
> > 3. What do you want to archive?
> > 4. How are you going to archive (Archive forms, DSO, Remedy Migrator,
> > DRIVER.EXE, etc.)?
>
> > On Feb 13, 1:32 pm, Hari Vishwakarma  wrote:
> > > Hi All,
>
> > > I want to create an archival server which will offload my production 
> > > server
> > > load & improves my production server performance
> > > Can anyone suggest what are all the prerequisites for the required 
> > > archival
> > > server.And what need to be kept in mind while configuring this. Also will
> > > it require any short of customizations for achieveing an archival server.
>
> > > Please suggest to achieve the same.
>
> > > --
> > > Best Regards,
>
> > > Hari shankar Vishwakarma
> > > Mobile:- +91-9833675872
> > > E-mail:- hsvishwaka...@gmail.com
>
> > > ___
> > >  
> > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> > > attend wwrug12www.wwrug12.comARSList:"Where the Answers Are"
>
> > ___ 
> > 
>

Re: How to create an archival server in remedy in windows platform!!!

[Elry]

Well Hari...

We currently just finishing up the creation of an archival server.

I guess my key questions would be:

1. Do you have any Archive Policies in place (i.e. Incident Tickets
will be automatically closed after 90 Days).
2. What applications are you running (i.e. ITSM or Custom
Applications)?
3. What do you want to archive?
4. How are you going to archive (Archive forms, DSO, Remedy Migrator,
DRIVER.EXE, etc.)?



On Feb 13, 1:32 pm, Hari Vishwakarma  wrote:
> Hi All,
>
> I want to create an archival server which will offload my production server
> load & improves my production server performance
> Can anyone suggest what are all the prerequisites for the required archival
> server.And what need to be kept in mind while configuring this. Also will
> it require any short of customizations for achieveing an archival server.
>
> Please suggest to achieve the same.
>
> --
> Best Regards,
>
> Hari shankar Vishwakarma
> Mobile:- +91-9833675872
> E-mail:- hsvishwaka...@gmail.com
>
> ___ 
> 
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> attend wwrug12www.wwrug12.comARSList: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

Re: Abydos - experiences

[Elry]

We currently have it deployed at one of the largest Canadian
government departments. We have nearly 1,000 processes configured
using Designer.  You are right the beauty of it is - you leave it in
the hands of the Business Analysts to draw up the process using a
Visio like IDE.  This means that ITSM will require minimal if any
custom modifications.  Unfortunately, this is great for the client but
bad for those who do custom development of ITSM.

On Feb 9, 10:19 am, Tauf Chowdhury  wrote:
> Designer is a good tool and makes sense for organizations that want to
> really automate task management and enable their "hybrid IT" people like
> Business Analysts. Before I left my previous employer, I was trying to get
> them to use Designer to design the business process flows and decrease the
> bottleneck it causes for the remedy admin team to do it. Alas, I left and
> they are probably not pursuing that as priority right now.
>
>
>
>
>
>
>
>
>
> On Thu, Feb 9, 2012 at 9:31 AM, Elry  wrote:
> > Yes agreed...
>
> > Version 8.0 of BMC Remedy should include both the Analyzer and
> > Designer as standard toolsets.
>
> > Much like how the Ostream Migrator become the Remedy Migrator.
>
> > This would be a wonderful marriage - we just have to set up a blind
> > date first...;-)
>
> > On Feb 8, 4:34 pm, Jose Huerta  wrote:
> > > My opinion is that Abydos Analyzer features had to be included in the
> > > standard developer studio.
>
> > > Jose M. Huerta
> > > Project Manager**
>
> > > Movil: 661 665 088
>
> > > Telf.: 971 75 03 24
>
> > > Fax: 971 75 07 94
>
> > >  <http://www.sm2baleares.es/>
>
> > > SM2 Baleares S.A.
> > > C/Rita Levi 
>
> > > Edificio SM2 Parc Bit
>
> > > 07121 Palma de Mallorca
>
> > >           <http://es-es.facebook.com/pages/SM2-Baleares/158608627954>
> > >   <http://twitter.com/#!/SM2Baleares>
> > >      <http://www.linkedin.com/company/sm2-baleares>
>
> > > La información contenida en este mensaje de correo electrónico es
> > > confidencial. La misma, es enviada con la intención de que únicamente sea
> > > leída por la persona(s) a la(s) que va dirigida. El acceso a este mensaje
> > > por otras personas no está autorizado, por lo que en tal caso, le rogamos
> > > que nos lo comunique por la misma vía, se abstenga de realizar copias del
> > > mensaje o remitirlo o entregarlo a otra persona y proceda a borrarlo de
> > > inmediato.
>
> > > P Por favor, no imprima este mensaje ni sus documentos adjuntos si no es
> > > necesario.
>
> > > On Wed, Feb 8, 2012 at 16:06, Andrew C Goodall 
> > wrote:
>
> > > > ** ** ** ** ** ** **
>
> > > > We own and use Abydos Analyzer too. 
>
> > > > It’s one of those tools which you might not use everyday, but when you
> > do
> > > > it saves you a ton of time.
>
> > > > It’s easy to work with and use, and very quick and powerful. I would
> > > > definitely recommend it.
>
> > > > Love that it uses standard Microsoft products for the output to Visio
> > and
> > > > Excel.
>
> > > > ** **
>
> > > > Regards,
>
> > > >  
>
> > > > *Andrew Goodall*
>
> > > > Software Engineer 2 | Development Services |  jcpenney .www.jcp.com<
> >http://www.jcp.com/>
> > > > 
> > > >   --
>
> > > > *From:* Action Request System discussion list(ARSList) [mailto:
> > > > arsl...@arslist.org] *On Behalf Of *John Sundberg
> > > > *Sent:* Wednesday, February 08, 2012 8:42 AM
> > > > *To:* arsl...@arslist.org
> > > > *Subject:* Abydos - experiences
>
> > > > ** **
>
> > > > ** 
>
> > > > (BTW - I have no connection to Abydos, except that we share the
> > > > same earth, air, etc…)
>
> > > > ** **
>
> > > > FYI - we purchased Abydos Analyzer a month or so ago. 
>
> > > > ** **
>
> > > > I thought I would relay back that 2 times in the last week alone -- it
> > was
> > > > quite helpful.
>
> > > > ** **
>
> > > > One scenario was to track down and give insight into a design decision
> > we
> > > > were making for the next version of Request.
>
> > > > ** **
>
> > > > We were a

Re: Abydos - experiences

[Elry]

Yes agreed...

Version 8.0 of BMC Remedy should include both the Analyzer and
Designer as standard toolsets.

Much like how the Ostream Migrator become the Remedy Migrator.

This would be a wonderful marriage - we just have to set up a blind
date first...;-)


On Feb 8, 4:34 pm, Jose Huerta  wrote:
> My opinion is that Abydos Analyzer features had to be included in the
> standard developer studio.
>
> Jose M. Huerta
> Project Manager**
>
> Movil: 661 665 088
>
> Telf.: 971 75 03 24
>
> Fax: 971 75 07 94
>
>  
>
> SM2 Baleares S.A.
> C/Rita Levi 
>
> Edificio SM2 Parc Bit
>
> 07121 Palma de Mallorca
>
>           
>   
>      
>
> La información contenida en este mensaje de correo electrónico es
> confidencial. La misma, es enviada con la intención de que únicamente sea
> leída por la persona(s) a la(s) que va dirigida. El acceso a este mensaje
> por otras personas no está autorizado, por lo que en tal caso, le rogamos
> que nos lo comunique por la misma vía, se abstenga de realizar copias del
> mensaje o remitirlo o entregarlo a otra persona y proceda a borrarlo de
> inmediato.
>
> P Por favor, no imprima este mensaje ni sus documentos adjuntos si no es
> necesario.
>
> On Wed, Feb 8, 2012 at 16:06, Andrew C Goodall  wrote:
>
>
>
>
>
>
>
>
>
> > ** ** ** ** ** ** **
>
> > We own and use Abydos Analyzer too. 
>
> > It’s one of those tools which you might not use everyday, but when you do
> > it saves you a ton of time.
>
> > It’s easy to work with and use, and very quick and powerful. I would
> > definitely recommend it.
>
> > Love that it uses standard Microsoft products for the output to Visio and
> > Excel.
>
> > ** **
>
> > Regards,
>
> >  
>
> > *Andrew Goodall*
>
> > Software Engineer 2 | Development Services |  jcpenney 
> > .www.jcp.com
> > 
> >   --
>
> > *From:* Action Request System discussion list(ARSList) [mailto:
> > arsl...@arslist.org] *On Behalf Of *John Sundberg
> > *Sent:* Wednesday, February 08, 2012 8:42 AM
> > *To:* arsl...@arslist.org
> > *Subject:* Abydos - experiences
>
> > ** **
>
> > ** 
>
> > (BTW - I have no connection to Abydos, except that we share the
> > same earth, air, etc…)
>
> > ** **
>
> > FYI - we purchased Abydos Analyzer a month or so ago. 
>
> > ** **
>
> > I thought I would relay back that 2 times in the last week alone -- it was
> > quite helpful.
>
> > ** **
>
> > One scenario was to track down and give insight into a design decision we
> > were making for the next version of Request.
>
> > ** **
>
> > We were able to easily look at the code areas and get a rough feel of
> > level of effort to implement the change.
>
> > We could see all the areas that were using a certain table and fields --
> > and then -- we could estimate the impact.
>
> > To me - this is very valuable -- as - if you were going blind (I mean
> > using the normal Admin tool) -- you would have to uncover this stuff over
> > time -- and you may be walking into a mine-field of a problem. In our case
> > - we were not walking into a mine-field -- and therefore had confidence in
> > moving forward.
>
> > ** **
>
> > ** **
>
> > The other scenario was a bit of an overall analysis of high-level
> > workflow. We had Abydos analyze what happens on a submit of a
> > Kinetic Request. We printed it out -- and then discussed the flow/process
> > as a group. Without the printout -- it would have been "practically
> > impossible" to have that kind of discussion.
>
> > ** **
>
> > ** **
>
> > I thought I would relay these experiences - as I find design to be the
> > most important step in the creation of software. The traditional tools for
> > ARS are designed to program -- not designed for design :) I think it is a
> > critically missing piece to the toolset.
>
> > ** **
>
> > ** **
>
> > Abydos would be a great addition to any Remedy system.
>
> > ** **
>
> > ** **
>
> > ** **
>
> > -John
>
> > ** **
>
> > ** **
>
> > ** **
>
> > 
>
> > ** **
>
> > --
> > John David Sundberg
> > 235 East 6th Street, Suite 400B
> > St. Paul**, **MN** **55101
> > (651) 556-0930-work
> > (651) 247-6766-cell
> > (651) 695-8577-fax
> > john.sundb...@kineticdata.com
> > _attend WWRUG12www.wwrug.comARSlist: "Where the Answers Are"_ 
>
> > The information transmitted is intended only for the person or entity to
> > which it is addressed and
> > may contain confidential and/or privileged material. If the reader of this
> > message is not the intended
> > recipient, you are hereby notified that your access is unauthorized, and
> > any review, dissemination,
> > distribution or copying of this message including any attachments is
> > strictly prohibited. If

Re: WWRUG12 - Prepare for the Call For Papers!

[Elry]

That's too bad Jose...

You are going to miss a really good time, and opportunity to interact
with your peers.

I say we start a new movement:  Bring Jose Huerta to WWRUG 2012


On Feb 2, 9:14 pm, Jose Huerta  wrote:
> It's not about having time, but about the cost of travelling.
>
> I can't afford a Spain <-> USA travel right now.
>
>
>
>
>
>
>
>
>
> On Thu, Feb 2, 2012 at 20:33, Jason Miller  wrote:
> > ** And don't forget the RRR flashlights!  I use mine all the time.
>
> > Jason
>
> > On Thu, Feb 2, 2012 at 6:54 AM, Misi Mladoniczky  wrote:
>
> >> Hi,
>
> >> You should make an effort to make room in your schedule, it is well worth
> >> while to attend!
>
> >>        Best Regards - Misi, RRR AB,http://www.rrr.se(ARSList MVP 2011)
>
> >> Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11):
> >> * RRR|License - Not enough Remedy licenses? Save money by optimizing.
> >> * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
> >> Find these products, and many free tools and utilities, athttp://rrr.se.
>
> >> > I have no possibility to attend the conference. My question is: What are
> >> > my
> >> > options?
> >> > Can I attend it remotely (via webex, for instance, or recorded videos?).
> >> > Also, will the papers released to public or will be only delivered to
> >> > attendants?
>
> >> > Also, Can I access previous years papers?
>
> >> > Regards,
>
> >> > Jose M. Huerta
> >> > Project Manager**
>
> >> > Movil: 661 665 088
>
> >> > Telf.: 971 75 03 24
>
> >> > Fax: 971 75 07 94
>
> >> >  
>
> >> > SM2 Baleares S.A.
> >> > C/Rita Levi 
>
> >> > Edificio SM2 Parc Bit
>
> >> > 07121 Palma de Mallorca
>
> >> >           
> >> >   
> >> >      
>
> >> > La información contenida en este mensaje de correo electrónico es
> >> > confidencial. La misma, es enviada con la intención de que únicamente
> >> sea
> >> > leída por la persona(s) a la(s) que va dirigida. El acceso a este
> >> mensaje
> >> > por otras personas no está autorizado, por lo que en tal caso, le
> >> rogamos
> >> > que nos lo comunique por la misma vía, se abstenga de realizar copias
> >> del
> >> > mensaje o remitirlo o entregarlo a otra persona y proceda a borrarlo de
> >> > inmediato.
>
> >> > P Por favor, no imprima este mensaje ni sus documentos adjuntos si no es
> >> > necesario.
>
> >> > On Thu, Feb 2, 2012 at 07:53, bullcreek.com 
> >> > wrote:
>
> >> >> Hi Listers,
>
> >> >> Just a heads up to let you all know that we will soon be putting out a
> >> >> call for papers for the WWRUG12 to be held this year in San Jose,
> >> >> California.  Now is the time to prepare your topics for our upcoming
> >> >> conference.  We are looking for topics that fall into categories such
> >> as
> >> >> Case Studies (challenges you or your customers have faced and how you
> >> >> overcame them), Tips and Tricks (not just limited to ITSM, but anything
> >> >> Remedy related that you feel could help your fellow listers), Tools and
> >> >> Applications that help you get your daily work done (or ways to
> >> leverage
> >> >> existing tools/apps), Integrations that are related to our beloved AR
> >> >> System or apps built on it, etc.
>
> >> >> You will need to provide us with a synopsis of your proposed paper, how
> >> >> it
> >> >> relates to the AR System, the benefits it provides, the level of
> >> >> technical
> >> >> expertise it pertains to, which category it falls into (Case Study,
> >> Tips
> >> >> &
> >> >> Tricks, Tools, Applications, Integrations, etc.), be able to present it
> >> >> in
> >> >> a 45 minute timeslot that includes a brief introduction, your topic,
> >> >> preferably a live working demo of your idea (not just powerpoint
> >> >> slides),
> >> >> and at least ten minutes for questions and answers at the end of your
> >> 45
> >> >> minute window.
>
> >> >> For those of you that have come across some valuable information you
> >> are
> >> >> just dying to share with your colleagues, now is the time to gear up to
> >> >> be
> >> >> a Remedy Rockstar and share your knowledge with your Remedy family.
> >>  For
> >> >> those with updates to tools/apps that have made their way into our
> >> >> lives,
> >> >> we look forward to learning about the new functionality in the latest
> >> >> releases.  It doesn't have to be Earth Shattering but needs to be of
> >> >> value
> >> >> at any level (remember we always have some new folks every year).
>
> >> >> I talk to enough of you who are Customers, Partners, or Employees of
> >> BMC
> >> >> to know that in addition to the ideas presented on the List there are
> >> >> some
> >> >> very cool ideas being shared about how to do things that either haven't
> >> >> been done before, reminders of things that we take for granted, or
> >> >> improvements on the way things have been done in th

Re: WWRUG12 - Prepare for the Call For Papers!

[Elry]

Hey Phil...

If we present - do you waive the admission fee


On Feb 2, 1:53 am, "bullcreek.com"  wrote:
> Hi Listers,
>
> Just a heads up to let you all know that we will soon be putting out a call 
> for papers for the WWRUG12 to be held this year in San Jose, California.  Now 
> is the time to prepare your topics for our upcoming conference.  We are 
> looking for topics that fall into categories such as Case Studies (challenges 
> you or your customers have faced and how you overcame them), Tips and Tricks 
> (not just limited to ITSM, but anything Remedy related that you feel could 
> help your fellow listers), Tools and Applications that help you get your 
> daily work done (or ways to leverage existing tools/apps), Integrations that 
> are related to our beloved AR System or apps built on it, etc.
>
> You will need to provide us with a synopsis of your proposed paper, how it 
> relates to the AR System, the benefits it provides, the level of technical 
> expertise it pertains to, which category it falls into (Case Study, Tips & 
> Tricks, Tools, Applications, Integrations, etc.), be able to present it in a 
> 45 minute timeslot that includes a brief introduction, your topic, preferably 
> a live working demo of your idea (not just powerpoint slides), and at least 
> ten minutes for questions and answers at the end of your 45 minute window.
>
> For those of you that have come across some valuable information you are just 
> dying to share with your colleagues, now is the time to gear up to be a 
> Remedy Rockstar and share your knowledge with your Remedy family.  For those 
> with updates to tools/apps that have made their way into our lives, we look 
> forward to learning about the new functionality in the latest releases.  It 
> doesn't have to be Earth Shattering but needs to be of value at any level 
> (remember we always have some new folks every year).
>
> I talk to enough of you who are Customers, Partners, or Employees of BMC to 
> know that in addition to the ideas presented on the List there are some very 
> cool ideas being shared about how to do things that either haven't been done 
> before, reminders of things that we take for granted, or improvements on the 
> way things have been done in the past using our current toolsets and 
> methodologies.
>
> In addition we will be looking for BMC to share with us some of their new 
> developments in the AR System, Applications and Integrations and how we can 
> leverage them at our jobs and for our customers.
>
> Our goal is to get the papers approved and the topics published as early as 
> possible to allow you more time to take the agenda to your management and get 
> approval to attend along with the growing number of attendees (yes we have 
> grown each year).
>
> In just a few short weeks, we will open the Call for Papers, publish the 
> timeline and provide an online (Remedy based) app for you to enter your 
> proposed topics.
>
> I am thrilled to let you know that the Board has already had several really 
> great and relevant topics already even before we officially launch the Call 
> for Papers!
>
> So put your fingers to the keyboard and prepare to submit your topics very 
> soon.
>
> We look forward to hearing from You!
>
> Phil Bautista
> WWRUG12 Technical Session Manager
>
> ___ 
> 
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> attend wwrug12www.wwrug12.comARSList: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

Re: Data Visualization Field - Developer Tool

[Elry]

Hey Ven...

Which documentation are you looking at?

Chapter 10 of the BMC Integration Guide for 7.6.04 looks pretty good.


On Jan 31, 5:53 pm, Ven  wrote:
> Mid-tier is installed. Developer tool points to midtier's url.
>
> Running it from the remedy client gives the usual:
> "The page cannot be displayed"
>
> Running it from a web browser seems to get the object to appear. (For 
> example, the visualizer), but I still don't know how to send data into it.
> Do you know where is documentation for sending data to the data visualization 
> field?
>
> Thanks,
> Ven
>
> ___ 
> 
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> attend wwrug12www.wwrug12.comARSList: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

Re: Numera Acquisition

[Elry]

Wow...

I agree - what an interesting deal that is...

Now they own the small, medium and large product markets for ITSM
style tools.


On Jan 31, 9:52 am, Andrew C Goodall  wrote:
> Interesting acquisition - there sure is a lot of overlap with Remedy. I
> wonder how this will play out?
>
> http://www.numarasoftware.com
>
> GaryHoagland   GaryHoagland
>
> Fear Uncertainty and Doubt being spread about the BMC Acquisition of
> Numara. #GiveMeABreak 
> Truth is the Best just got Better - BMC+Numara!
>
> Andrew
>
> The information transmitted is intended 
> only for the person or entity to which it is addressed and may contain 
> confidential and/or privileged material. If the reader of this message is not 
> the intendedrecipient, you are hereby notified that your access is 
> unauthorized, and any review, dissemination,distribution or copying of 
> this message including any attachments is strictly prohibited. If you are 
> notthe intended recipient, please contact the sender and delete the 
> material from any computer.
>
> ___ 
> 
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> attend wwrug12www.wwrug12.comARSList: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

Re: Exporting a full server def file using Dev Studio

[Elry]

I agree...

With our larger custom applications - we have actually created
multiple def files by object types (in some cases multiple form def
files too).

Then you would import one object type at a time (first forms - then
workflow objects - then guides).

This should work - you may have to repeat it a couple times to get it
right.



On Jan 19, 10:11 pm, "Grooms, Frederick W" 
wrote:
> You could always export by object type and just append to the same def file.  
>  (All Forms, then all Active Links, ...)
>
> Fred
>
> From: Action Request System discussion list(ARSList) 
> [mailto:arsl...@arslist.org] On Behalf Of Jason Miller
> Sent: Thursday, January 19, 2012 6:19 PM
> To: arsl...@arslist.org
> Subject: Exporting a full server def file using Dev Studio
>
> ** Here is an update (just to complete the loop) on a topic as old as Dev 
> Studio...  I had given up exporting full server def files after moving to AR 
> 7.5 (ARInside and Object Modification defs provided backup/restore/historical 
> reference comfort).  For fun I tried again yesterday on our very custom AR 
> 7.5 server with Help Desk 6 and a bunch of homegrown apps (25,513 objects).  
> I was able to export a full def finally!  The setup used is Dev Studio 7.6.04 
> SP2 on a Windows 7 Pro PC with 16gb of RAM, 4gb of which are given to DS in 
> the devstudio.ini file.
>
> Since we are moving away from much of our homegrown apps, transitioning to 
> the full ITSM suite and I was feeling a bit froggy I tried our ITSM 7.6.04 
> SP2 environment this morning (74,599 objects).  I am sad to report it failed 
> with the following error: Failed to export to the file. ERROR (91): RPC call 
> failed; Connection reset by peer: socket write error,  5190,
>
> I think current day with an ITSM 7.6.x server there is probably little value 
> in pulling a full def file though.  My reasoning for wanting a full server 
> def has always been because the system was highly customize and largely 
> homegrown; building a fresh server and installing ITSM would provide only a 
> small piece of the environment.  Now with overlays, exporting only overlaid 
> objects would probably be sufficient to re-customize and restore homegrown 
> objects from a fresh install using the SSI (of course this isn't a 
> replacement for db backups).  If you are a custom only shop then a full 
> server export is possible (figuring you don't have nearly as many objects as 
> a full ITSM install).
>
> Jason
>
> ___ 
> 
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> attend wwrug12www.wwrug12.comARSList: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

Re: WWRUG: WWRUG12 Registration and Conference Hotel Booking are Open, as is the web site

[Elry]

Hey Dan...

I should have noticed this before...

The link re-directs to: http://www.google.com/www.wwrug12.com

Typing in www.wwrug12.com works just fine.

Thanks.


On Jan 17, 8:40 am, Elry  wrote:
> Hi Dan...
>
> I get this error...
>
> --- 
> --
>
> 404. That’s an error.
>
> The requested URL /www.wwrug12.comwas not found on this server.
> That’s all we know.
>
> --- 
> --
>
> Maybe doesn't work from Canad EH...;-)
>
> On Jan 16, 12:46 pm, arslist  wrote:
>
>
>
>
>
>
>
>
>
> >www.wwrug12.comseemsfine
>
> > -Original Message-
> > From: Action Request System discussion list(ARSList)
>
> > [mailto:arsl...@arslist.org] On Behalf Of Elry
> > Sent: January 16, 2012 12:44 PM
> > To: arsl...@arslist.org
> > Subject: Re: WWRUG: WWRUG12 Registration and Conference Hotel Booking are
> > Open, as is the web site
>
> > Hi Dan...
>
> > Looks like this link might be down...???
>
> > On Jan 13, 5:15 pm, Daniel Bloom  wrote:
> > > On behalf of the Advisory Board for the World Wide Remedy Users Group
> > > (WWRUG),
>
> > > I am happy to announce that our upcoming conference: "WWRUG12 -
> > > Sharing Tools, Technology and Training"
>
> > > will be October 15 - 19, 2012 - San Jose, California in the Fairmont
> > > San Jose
>
> > > Well, okay, so we announced that at WWRUG11.
>
> > > Now you can actually register and book your hotel atwww.wwrug12.com
>
> > > There will be an official announcement going out soon, but the ARSlist
> > > has never been formal.
>
> > > I decided it was best to get an early start so we can spread our
> > > absurd workload out over the year.
>
> > > Remember, the entire Advisory Board are actually BMC Remedy
> > > consultants of one sort or another and most of us
>
> > > have full time jobs. Those of us that aren't full time employees seem
> > > to work 3 types of jobs including being Remedy Consultants so have the
> > > equivalent
>
> > > of 2 full time jobs to begin with.
>
> > > Ditto with all our volunteers.
>
> > > We have a great venue and location this year, and it is expected to be
> > > a stellar event, so join us!
>
> > > The content will be better than ever. Why? Well, bribery. Yes, this
> > > year if you present, the conference fees are: 0 dollars.
>
> > > So get your topics and papers ready and your travel approved.
>
> > > BMC has guaranteed that they will offer up Senior Management to either
> > > be applauded for their efforts
>
> > > to improve service and build quality or, if hotel rules permit, to be
> > > burnt at the stake. Oh, sorry, that was grilled by the Customers.
>
> > > (Disclaimer: the only part BMC said was the Senior Management
> > > available part).
>
> > > [For those competitors and lurkers on the list: don't get too excited,
> > > we are still loyal customers, just we have come to expect the best
> > > from BMC Remedy,
>
> > > And most of the time have gotten it.]
>
> > > Daniel
>
> > > Chairman, WWRUG12
>
> > > Founder, ARSlist: Serving up email since 1993
>
> > > Disclaimer: The wording of this has not been cleared by anyone, and is
> > > purely my opinion, a loyal long term BMC Remedy
> > > customer/developer/architect/consultant
>
> > > p.s. no Senior Management has ever been harmed during a RUG, unless
> > > you call throwing each other into the pool while wearing wigs harm
>
> > > p.p.s. since I was never present for the wigs on stage or pool dumping
> > > I may have the details wrong. My keynote was always the next morning
> > > in the era that was going on
>
> > > p.p.p.s. yes, it is Friday, that was deliberate
>
> > > __
> > > _  UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> > > attend wwrug12www.wwrug12.comARSList:"Where the Answers Are"
>
> > ___ 
> > _
> > ___
> > UNSUBSCRIBE or access ARSlist Archives 
> > atwww.arslist.orgattendwwrug12www.wwrug12.comARSList:"Where the Answers Are"
>
> > ___ 
> > 
> > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> > attend wwrug12www.wwrug12.comARSList:"Where the Answers Are"
>
> ___ 
> 
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> attend wwrug12www.wwrug12.comARSList: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

Re: Can RUG 12 survive this...

[Elry]

Don't worry - Canada is stepping in to fill this void:

http://www.vachon.com/en/

Shipping will commence January 17, 2012.


On Jan 11, 4:30 pm, Peter Romain 
wrote:
> End of an era?
>
> http://www.bbc.co.uk/news/business-16514426
>
> Cheers
>
> Peter
>
> ___ 
> 
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> attend wwrug12www.wwrug12.comARSList: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

Re: WWRUG: WWRUG12 Registration and Conference Hotel Booking are Open, as is the web site

[Elry]

Hi Dan...

I get this error...

-

404. That’s an error.

The requested URL /www.wwrug12.com was not found on this server.
That’s all we know.

-

Maybe doesn't work from Canad EH...;-)


On Jan 16, 12:46 pm, arslist  wrote:
> www.wwrug12.comseems fine
>
>
>
>
>
>
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
>
> [mailto:arsl...@arslist.org] On Behalf Of Elry
> Sent: January 16, 2012 12:44 PM
> To: arsl...@arslist.org
> Subject: Re: WWRUG: WWRUG12 Registration and Conference Hotel Booking are
> Open, as is the web site
>
> Hi Dan...
>
> Looks like this link might be down...???
>
> On Jan 13, 5:15 pm, Daniel Bloom  wrote:
> > On behalf of the Advisory Board for the World Wide Remedy Users Group
> > (WWRUG),
>
> > I am happy to announce that our upcoming conference: "WWRUG12 -
> > Sharing Tools, Technology and Training"
>
> > will be October 15 - 19, 2012 - San Jose, California in the Fairmont
> > San Jose
>
> > Well, okay, so we announced that at WWRUG11.
>
> > Now you can actually register and book your hotel atwww.wwrug12.com
>
> > There will be an official announcement going out soon, but the ARSlist
> > has never been formal.
>
> > I decided it was best to get an early start so we can spread our
> > absurd workload out over the year.
>
> > Remember, the entire Advisory Board are actually BMC Remedy
> > consultants of one sort or another and most of us
>
> > have full time jobs. Those of us that aren't full time employees seem
> > to work 3 types of jobs including being Remedy Consultants so have the
> > equivalent
>
> > of 2 full time jobs to begin with.
>
> > Ditto with all our volunteers.
>
> > We have a great venue and location this year, and it is expected to be
> > a stellar event, so join us!
>
> > The content will be better than ever. Why? Well, bribery. Yes, this
> > year if you present, the conference fees are: 0 dollars.
>
> > So get your topics and papers ready and your travel approved.
>
> > BMC has guaranteed that they will offer up Senior Management to either
> > be applauded for their efforts
>
> > to improve service and build quality or, if hotel rules permit, to be
> > burnt at the stake. Oh, sorry, that was grilled by the Customers.
>
> > (Disclaimer: the only part BMC said was the Senior Management
> > available part).
>
> > [For those competitors and lurkers on the list: don't get too excited,
> > we are still loyal customers, just we have come to expect the best
> > from BMC Remedy,
>
> > And most of the time have gotten it.]
>
> > Daniel
>
> > Chairman, WWRUG12
>
> > Founder, ARSlist: Serving up email since 1993
>
> > Disclaimer: The wording of this has not been cleared by anyone, and is
> > purely my opinion, a loyal long term BMC Remedy
> > customer/developer/architect/consultant
>
> > p.s. no Senior Management has ever been harmed during a RUG, unless
> > you call throwing each other into the pool while wearing wigs harm
>
> > p.p.s. since I was never present for the wigs on stage or pool dumping
> > I may have the details wrong. My keynote was always the next morning
> > in the era that was going on
>
> > p.p.p.s. yes, it is Friday, that was deliberate
>
> > __
> > _  UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> > attend wwrug12www.wwrug12.comARSList:"Where the Answers Are"
>
> ___ _
> ___
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgattend 
> wwrug12www.wwrug12.comARSList: "Where the Answers Are"
>
> ___ 
> 
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> attend wwrug12www.wwrug12.comARSList: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

Re: WWRUG: WWRUG12 Registration and Conference Hotel Booking are Open, as is the web site

[Elry]

Hi Dan...

Looks like this link might be down...???


On Jan 13, 5:15 pm, Daniel Bloom  wrote:
> On behalf of the Advisory Board for the World Wide Remedy Users Group
> (WWRUG),
>
> I am happy to announce that our upcoming conference: "WWRUG12 - Sharing
> Tools, Technology and Training"
>
> will be October 15 - 19, 2012 - San Jose, California in the Fairmont San
> Jose
>
> Well, okay, so we announced that at WWRUG11.
>
> Now you can actually register and book your hotel atwww.wwrug12.com
>
> There will be an official announcement going out soon, but the ARSlist has
> never been formal.
>
> I decided it was best to get an early start so we can spread our absurd
> workload out over the year.
>
> Remember, the entire Advisory Board are actually BMC Remedy consultants of
> one sort or another and most of us
>
> have full time jobs. Those of us that aren't full time employees seem to
> work 3 types of jobs including being Remedy Consultants so have the
> equivalent
>
> of 2 full time jobs to begin with.
>
> Ditto with all our volunteers.
>
> We have a great venue and location this year, and it is expected to be a
> stellar event, so join us!
>
> The content will be better than ever. Why? Well, bribery. Yes, this year if
> you present, the conference fees are: 0 dollars.
>
> So get your topics and papers ready and your travel approved.
>
> BMC has guaranteed that they will offer up Senior Management to either be
> applauded for their efforts
>
> to improve service and build quality or, if hotel rules permit, to be burnt
> at the stake. Oh, sorry, that was grilled by the Customers.
>
> (Disclaimer: the only part BMC said was the Senior Management available
> part).
>
> [For those competitors and lurkers on the list: don't get too excited, we
> are still loyal customers, just we have come to expect the best from BMC
> Remedy,
>
> And most of the time have gotten it.]
>
> Daniel
>
> Chairman, WWRUG12
>
> Founder, ARSlist: Serving up email since 1993
>
> Disclaimer: The wording of this has not been cleared by anyone, and is
> purely my opinion, a loyal long term BMC Remedy
> customer/developer/architect/consultant
>
> p.s. no Senior Management has ever been harmed during a RUG, unless you call
> throwing each other into the pool while wearing wigs harm
>
> p.p.s. since I was never present for the wigs on stage or pool dumping I may
> have the details wrong. My keynote was always the next morning in the era
> that was going on
>
> p.p.p.s. yes, it is Friday, that was deliberate
>
> ___ 
> 
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> attend wwrug12www.wwrug12.comARSList: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

Re: Mid-tier Pros and Cons of running mid-tier with or without IIS?

[Elry]

I agree John

We now have 7.6.04 (and the ITSM suite) running in our Sandbox with
Tomcat alone...

So far we have no difficulties.



On Jan 3, 2:58 pm, John Baker  wrote:
> Hello,
>
> There are no good reasons to run IIS in 99% of cases. IIS is acting as a 
> front end to Tomcat, doing nothing more than passing on requests using an old 
> connector called mod_jk, which isn't heavily tested on Windows judging by the 
> recent 64bit builds not working properly. Indeed, we were asked by BMC to do 
> an SSO installation for one of their clients last year and our first job was 
> to "fix" the MId Tier, because the problematic mod_jk build had 'escaped' 
> into a 7603/7604 release (I can't recall which). It just wouldn't work, and 
> we found ourselves spending more time debugging IIS than installing SSO 
> Plugin.
>
> All you need is Tomcat standalone, or a farm of Tomcats and a load balanacer 
> if you are going to be supporting many hundreds of users.
>
> John
>
> ___ 
> 
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> attend wwrug12www.wwrug12.comARSList: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

Re: POLL: would you like the user tool back (7.6.04)

[Elry]

I think

YES.

The mid-tier is great for enterprise deployment, but there will always
be a need for a power tool for power users to perform advanced
queries, macros and reports.

Unless we agree not to empower the Power Users and have them tell
Developers what to add to the interface to make their jobs easier
(then pray that apathy does not "seep" in...).


On Jan 3, 2:16 pm, Chuck  wrote:
> As soon as they incorporate the following for the web then get rid of
> user tool:
> 1) Fix issues with browser caching as it pertains to ITSM apps viewed
> inside the SHARE: Landing *&%^$&%% Console. Hard to refresh.
> Actually I hate it, get rid of it.
> 2) Able to Open object list using hot keys.
> 3) Able to do server side logging.
> 4) Able to block direct access URLS for certain forms /views
> (configurable).
> IE you can only get to the form using workflow or possibly the object
> list. Lotsa people can start guessing form names (Its how they break
> into supportweb at BMC)
>
> 5) Session about to expire warning.
> 6) Built in configurable SSO support for the more prevalent SSO
> schemes, kerberos...etc.
> 7) True web style event handlers
> onKeyDown, onKeyup, MouseDown, MouseUp, OnMouseOver.. etc.
>
> 8) Start using a verified javascript library with cool effects.
> Incorporate jQuery and get rid of legacy built js.
> Multiple file uploads.. etc.
>
> 9) Start looking into HTML 5 to build up the web apps.
>
> ...thats it , im tired.
>
> On Jan 3, 2:02 pm, Michael  wrote:
>
>
>
>
>
>
>
>
>
> > No...IF...and this needs a lot of work...IF they fix mid-tier to be a
> > true web application.
>
> > On Tue, Jan 3, 2012 at 7:10 AM, patrick zandi  wrote:
> > > ** Curiosity poll:
> > > Of those who have tested, or used   7.6.04 ((only)) please:
>
> > > Would you like to see the user tool come back?  (don't need comments:: 
> > > just
> > > yes or no: OR yes yes yes to show your support is allowed.. lol)
>
> > > yes or no:
>
> > > I am not saying it is going to happen: I am not giving any indication it
> > > ever will ! I know nothing:: just asking..
>
> > > --
> > > Patrick Zandi
> > > _attend WWRUG12www.wwrug.comARSlist:"Where the Answers Are"_
>
> > --
> > Michael Hirst
> > University of Arizona,
> > UITS520-621-0867begin_of_the_skype_highlighting  520-621-0867  end_of_the_skype_highlighting
>
> > ___ 
> > ­
> > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> > attend wwrug12www.wwrug12.comARSList:"Where the Answers Are"- Hide quoted 
> > text -
>
> > - Show quoted text -
>
> ___ 
> 
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> attend wwrug12www.wwrug12.comARSList: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

Re: Request for Comments

[Elry]

Hey Ken...

I guess what I am trying to say is that - I don't think you could
build such a generic interface. Maybe some approximation thereof, but
not completely. Once you have this API, then what - build a new suite
of toolsets to leverage the API?

We are currently using Abydos - I am extrapolating from this concept -
to suggest that process definition/engineering should supersede API
augmentation if we are looking at a way to make ITSM more efficient.



On Nov 4, 9:58 am, "Cecil, Ken"  wrote:
> I would think that any interface designed would be agnostic to processes and 
> just be concerned with providing the services agreed upon in the contract. No 
> matter what happens behind the scene, the interface would handle the request 
> the same whether it be for interactive users, service consumers, other ITSM 
> apps, or other integrated apps/processes. The interface should be somewhat 
> abstracted from the underlying forms, processes, and customizations. The 
> interface contract should be generic and flexible enough to handle/anticipate 
> customizations and schema changes (similar to xml).
>
> Elry,  I believe Abydos Designer already does most of what you were referring 
> to about diagramming and creating workflow via a visio type diagram.
>
> Ken Cecil
>
>
>
>
>
>
>
> -Original Message-
> From: Action Request System discussion list(ARSList) 
> [mailto:arsl...@arslist.org] On Behalf Of Elry
> Sent: Friday, November 04, 2011 9:26 AM
> To: arsl...@arslist.org
> Subject: Re: Request for Comments
>
> This interface discussion is interesting and all , but I do not think
> that the ITSM application will readily conform to this approach. I
> think we are forgetting that ITSM is meant to be ITIL compliant.  For
> those who have worked on the process side of ITIL - I am certain that
> you will be aware of how tightly coupled the ITIL proceses are...
>
> Keep in mind that the ITIL process is a blueprint for how things
> should work and not necessarily the "cookie cutter" approach for all
> organizations.  This is why many of us find work "customizing" the
> ITSM application.  I use the term customize loosely, since this could
> mean adding a few fields to revamping large portions of the process
> model.  Now, if you put fixed structures in place and standardize the
> interactions between processes - you are effectively making a flexible
> model "rigid".
>
> I think that if we keep in mind that this is a process driven
> application; therefore, it must remain as flexible as possible - then
> we would have to conclude that the current architecture - offers the
> greatest degree of flexibility.
>
> BMC has done an excellent job giving us some base structures and
> processes as well as amazing integration tools (by BMC and third party
> vendors).  I believe that Overlays are a great concept - that once
> refined will be a formidable tool for our customization tool set.
>
> To me (keeping in mind that this is an ITIL tool set) - the only
> missing component for ITSM is a tool that would enable the BMC
> Engineer to modify the ITSM process "on the fly".  We have the
> technology, and the people (all you arlisters), now all we need for
> our tool belt is something that could effectively change a process "on
> the fly", or build/re-engineer a process "on the fly".
>
> Imagine if you would that there is a tool that would:
>
> 1.  Allow you to design your process in Visio.
> 2.  Link your process to the underlying ITSM structures.
> 3.  Link your process to the underlying categorization structure, and
> product catalog.
> 4.  Enable customization to be defined through process definitions.
> 5.  These processes that are graphically designed can then be called
> from the ITSM application and executed based on the underlying ITSM
> structures and workflow.
>
> This would mean that:
>
> 1. You utilize the underlying ITSM application to hold your data and
> basic workflow.
> 2. Overlays are utilized to make structural changes that or
> Organizationally dependent.
> 3. Workflow is designed and executed through process diagrams that are
> written in a Visio like environment.
> 4. API integration would focus on integration between enterprise
> applications.
> 5. BMC could and will continue to focus on "plugins" for the purpose
> of integration.
>
> Process, process, process...
>
> This is "my take" on this...
>
> On Nov 2, 3:55 pm, Richard Baird  wrote:
> > That works for me Axton. If they wanted to get even fancier, they could
> > implement it via the "Interface Form" model I described, and have the saving
> > of the form (along with

Re: Request for Comments

[Elry]

This interface discussion is interesting and all , but I do not think
that the ITSM application will readily conform to this approach. I
think we are forgetting that ITSM is meant to be ITIL compliant.  For
those who have worked on the process side of ITIL - I am certain that
you will be aware of how tightly coupled the ITIL proceses are...

Keep in mind that the ITIL process is a blueprint for how things
should work and not necessarily the "cookie cutter" approach for all
organizations.  This is why many of us find work "customizing" the
ITSM application.  I use the term customize loosely, since this could
mean adding a few fields to revamping large portions of the process
model.  Now, if you put fixed structures in place and standardize the
interactions between processes - you are effectively making a flexible
model "rigid".

I think that if we keep in mind that this is a process driven
application; therefore, it must remain as flexible as possible - then
we would have to conclude that the current architecture - offers the
greatest degree of flexibility.

BMC has done an excellent job giving us some base structures and
processes as well as amazing integration tools (by BMC and third party
vendors).  I believe that Overlays are a great concept - that once
refined will be a formidable tool for our customization tool set.

To me (keeping in mind that this is an ITIL tool set) - the only
missing component for ITSM is a tool that would enable the BMC
Engineer to modify the ITSM process "on the fly".  We have the
technology, and the people (all you arlisters), now all we need for
our tool belt is something that could effectively change a process "on
the fly", or build/re-engineer a process "on the fly".

Imagine if you would that there is a tool that would:

1.  Allow you to design your process in Visio.
2.  Link your process to the underlying ITSM structures.
3.  Link your process to the underlying categorization structure, and
product catalog.
4.  Enable customization to be defined through process definitions.
5.  These processes that are graphically designed can then be called
from the ITSM application and executed based on the underlying ITSM
structures and workflow.

This would mean that:

1. You utilize the underlying ITSM application to hold your data and
basic workflow.
2. Overlays are utilized to make structural changes that or
Organizationally dependent.
3. Workflow is designed and executed through process diagrams that are
written in a Visio like environment.
4. API integration would focus on integration between enterprise
applications.
5. BMC could and will continue to focus on "plugins" for the purpose
of integration.

Process, process, process...

This is "my take" on this...






On Nov 2, 3:55 pm, Richard Baird  wrote:
> That works for me Axton. If they wanted to get even fancier, they could
> implement it via the "Interface Form" model I described, and have the saving
> of the form (along with it's attached/embedded XML legal operations,
> exceptions, etc...) automatically create and publish the web service.
>
> That way every integration method/mechanism would have the same behaviour,
> because it would be based on the same source (the "Interface Form" for the
> specific interface)
>
> Cheers!
>
> Subject: Re: Request for Comments
> From: Axton 
> Reply-To: arsl...@arslist.org
> Date: Wed, 2 Nov 2011 14:45:38 -0500
>
> ** I envisioned the interfaces implemented as web services, not as an API.
> A web service layer makes plugging into other things easier.  One of the
> drivers for me starting this conversation is what I see many of the cloud
> providers offering and leveraging as their interfaces into and out of their
> applications.  I have some exposure to the service oriented architecture as
> well, which plays into this paradigm nicely.
>
> If, within Remedy, all the interfaces were exposed as web services and
> Remedy had a native way to consumer those web service based interfaces, it
> opens the door nicely for other things to operate at that level.  Web
> services seem to be a common method of integration in the cloud space.  SOA
> infrastructure deployments seem to be in their infancy, but I see them
> gaining traction, as long as they are capable of delivering on their value
> proposition.http://www.zapthink.com/2005/01/27/the-roi-of-soa/
>
> The lifecycle around services is pretty well defined in this space as 
> well.http://www.soablueprint.com/whitepapers/SOAPGPart3.pdf
>
> Axton Grams
>
> On Wed, Nov 2, 2011 at 2:20 PM, Richard Baird 
> wrote:
>
> LJ,
>
> Having done lots of OO stuff as well as ARS over the years, I fully grasp
> the concepts you're putting forward, however, I think the goal should be
> "Interfaces", not necessarily "API Interfaces". For most apps built using
> java or .net (or some other OO platform) as a base, I agree that tightly
> defined api interfaces are the way to go. But ARS is somewhat different in
> that the integration tools already in existence are w

Re: Request for Comments

[Elry]

Excellent Points...

Now how do we do that - that is the million dollar question.

They would probably have to rebuild the application from the ground
up!

I do a lot of R&D in this space and we are working on a prototype
with

similar capabilities that would allow the client to do "plug and play"

with the different modules (Change, Incident, etc.).  Not only that,
but

it would have auto-archiving built in...

The ITSM 7 product could be rebuilt and re-engineered to do what

you are suggesting, but we may have to wait for version 10.



On Nov 1, 7:59 pm, Axton  wrote:
> This is more a high level discussion and is concept/design oriented.
>  Please feel free to chime in with your thoughts.  I look forward to the
> collective wisdom of this list.  I is my hope that a a constructive
> discussion can happen around this subject and the powers that be can gain
> insight gleaned from the discussion.
>
> First, a little background.  I was in the Help Desk/ITSM space, left that
> arena for a few years, and have since returned.  After working with the
> ITSM application for a few short months I am realizing how
> tightly ingrained these applications are with one another (incident,
> problem, asset, change, cmdb, etc.).  The tightly coupled integrations make
> certain tasks exceedingly difficult, for example:
> - using an outside system for change management (or any other process, for
> that matter)
> - upgrading a single application in the stack (e.g., change management)
> - integrating outside applications with the ITSM applications
>
> Non-remedy or custom remedy applications are unable to easily or
> effectively communicate with the ITSM applications in the same way that the
> ITSM applications communicate with one another.  Even different versions of
> the applications are unable to effectively communicate.
>
> Consider that each application facilitates a well defined process.  Each
> process has inputs, outputs, and actions.  The ITSM applications could have
> (and leverage, internally) interfaces to communicate their inputs and
> inputs, outputs, and actions.  Java Interfaces are an implementation of
> this design pattern that are a prime example of the flexibilities that this
> can afford.
>
> *Interfaces form a contract between the class and the outside world...*
> *-- *http://download.oracle.com/javase/tutorial/java/concepts/interface.html
>
> Interfaces can be versioned (e.g., 'Create Incident' interface version 1
> supports a field ,Priority; 'Create Incident' interface version 2 supports
> a new field, Urgency, etc.).  By creating an interface (i.e., a contract)
> and back-end instrumentation to implement the interface, applications could
> be upgraded independent of one another; all the communicating components
> need to know is the version of the interface and that dictates the
> capabilities of said interface.  With this idea, I am borrowing from the
> approach that many of the SOA stacks are implementing:
>
> *One the most popular approaches for dealing with changes is versioning.
> Versioning assumes simultaneous existence of multiple (different)
> implementations of the same thing, with every implementation
> distinguishable and individually addressable. In the case of SOA, service
> versioning equates to coexistence of multiple versions of the same service,
> which allows each consumer to use the version that it is designed and
> tested for (see Figure 1). In this case, a new version of a service is
> created based on the requirements of one or more consumers, which can start
> using this new version immediately. The other consumers of this service do
> not need to switch to using the latest version immediately, but can
> continue to use the versions of the service they were designed for and
> tested with. They can switch to the latest version of service, based on
> their own development and testing schedule. Multiple coexisting versions of
> the same service in the system allows for the independent life cycles of
> services and their consumers and minimizes the overall impact of the
> introduction of changes. Although the necessity of such versioning
> mechanism may be obvious to anyone who has ever dealt with services, this
> topic still has not penetrated the mainstream of SOA publications and
> implementations. *
> --http://msdn.microsoft.com/en-us/library/bb491124.aspx#jour11version_t...
>
> A few key concepts here:
> - Interfaces and versioning
>   - Well defined interfaces
>   - Interface life-cycle (e.g., the last 3 major versions of the interfaces
> will remain supported, after which, they are deprecated)
> - Loosely coupled applications (to the extent that the applications could
> run on different physical servers/databases) that leverage only the
> interfaces the applications provide as a means of communication
>
> Such a change to the current paradigm would open the doors to a lot of
> things that are simply not feasible at this time, all of which start with
> better interoperabilit

Re: Job Washing DC area

[Elry]

Hey Tom..

The title threw me off - I said to myself - I think we are in tough
economic times when IT guys have to go out and cleanup DC to put food
on the table.

On Oct 31, 8:02 pm, Tom Hamill  wrote:
> Hi All,
>
> Acuity, named one of the "2011 Best Places to Work" by Washington Business
> Journal, is currently seeking full time Senior Remedy Developers to join
> our Department of State team. We are looking for an experienced developer
> that can work closely with customers as well as act as a lead when needed.
> Qualifications:
> - 3+ years with design, configuration, development and support of 7.5
> Server and ITSM 7.6 Applications.
> - Experience with Incident Management,Change Management, Asset Management
> and Problem Management.
> - Experience with CMDB and AIE
> - Experience with custom Remedy workflow to meet specified requirements
> - Strong analytical and creative problem solving skills to resolve highly
> complex software design issues
> - Knowledge of ITIL Framework and best practice processes
> - US Citizen w/ Clearance
>
> Thank You,
>
> Tom Hamill 
> Acuity 
>
> 
>
> ___ 
> 
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> attend wwrug12www.wwrug12.comARSList: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

Re: Complicated Table Loops

[Elry]

Hi Lisa.

Table Looping can get a little wonky - when you try to walk them in a
filter guide.

I for one cannot think of a way to refresh a table field in a
filter.

At this point I am at a bit of loss trying to figure out what you are
trying to accomplish - I have questions like:

1.  Do you want to do all the workflow through filters?
2.  Are you firing on a Display only form or a regular form?
3.  When looping through the first table are you dynamically changing
the qualification on the other two tables?
4.  Can you use an active link to trigger the workflow; hence, taking
advantage of the new "Service Action"?

Let me know - maybe we can think of a way to get you going.







On Oct 31, 6:20 pm, "Kemes, Lisa"  wrote:
> I've done multiple table loops on one form using an active link guide, but 
> when I need to do this in an automated Filter Guide, for some reason it gets 
> tricky.
>
> I have 3 tables on my form.  I want to loop through the first table and then 
> the 2nd and 3rd table will give me data based on the record in the first 
> table.
>
> It's easy when I do an active link guide because I can refresh the tables 2 
> and 3 when the records in the first table get looped.  But it doesn't seem to 
> happen in filters (or filter guides).
>
> I have my first table set to fire workflow when selected, but how to I "fire" 
> a refresh of table 2 and 3 in a filter?
>
> Lisa Kames
> AR System Developer
> TEIS - USA
> +1 717 810 2408 tell
> +1 717 602 9460 mobile
> lisa.ke...@te.com
> 100 Amp Drive
> Harrisburg, PA 17112
>
> [http://www.te.com/images/socialmedia/smallTElogo.gif]
>
> www.te.com
>
> [http://www.te.com/images/socialmedia/twitter.png]
>  [http://www.te.com/images/socialmedia/facebook.png] 
>   
> [http://www.te.com/images/socialmedia/flickr.png] 
>   
> [http://www.te.com/images/socialmedia/linkedin.png] 
>   
> [http://www.te.com/images/socialmedia/youtube.png] 
> 
>
> ___ 
> 
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> attend wwrug12www.wwrug12.comARSList: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

Re: RRRChive

[Elry]

Gentlemen...

Thank you for your responses.

Misi - thanks for the more detailed email.

We are now moving forward with testing.

I must say that we are very pleased with the speed of the transactions
and the ease of use of the Configurator.

We have tried a number of command line utilities and this is by far
the fastest and most robust.


On Oct 4, 6:27 am, Misi Mladoniczky  wrote:
> Hi Mark,
>
> Thank you for the input.
>
> You can also add parameters on the command line that completely overrides
> anything in the config:
>
> rrrchive --qual="'2' = \"Demo\"" rrr.cfg
> (Note that this example is complicated, as it contains both spaces,
> single- and double-quotes that needs to be taken into account.)
>
> Also note that if you want to do an wild-card match, you need to double
> your %-signs:
> qual = ('8' LIKE "%%twinkie%%")
>
> Another important thing is the transfertype, that will usually not be
> SYNCTOTARGET if you have complex, and especially date-based,
> qualifications. You would then probably use transfertype=COPY instead.
>
>         Best Regards - Misi, RRR AB,http://www.rrr.se(ARSList MVP 2011)
>
> Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11):
> * RRR|License - Not enough Remedy licenses? Save money by optimizing.
> * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
> Find these products, and many free tools and utilities, athttp://rrr.se.
>
>
>
>
>
>
>
>
>
> > No doubt Misi will be along shortly with definitive information but in the
> > meantime...
>
> > Qualifications are pretty much what you would expect, for example -
>
> > qual            = '2' = "Demo"
>
> > would select records where the Submitter (fieldID 2) is Demo.   This one -
>
> > qual            = ('Group Role' = "Support Staff" OR 'Group Role' =
> > "Technical Publications" OR 'Group Role' = "Engineering" OR 'Group Role' =
> > "QA") AND 'System Status' = "Active"
>
> > selects records where the System Status is Active and Group Role is one of
> > the listed groups.
>
> > Parameters are referenced by using %s in the qual string -
>
> > qual            = 'Submitter' = "%s"
>
> > would substitute the %s for whatever was passed as the final parameter on
> > the command line -
>
> > rrrchive copy.cfg Demo
>
> > results in a qualification of 'Submitter' = "Demo"
>
> > Multiple parameters are passed and substituted in order -
>
> > qual            = ('Submitter' = "%s" OR 'Submitter' = "%s") AND 'Status'
> > = "%s"
> > rrrchive copy.cfg Demo Bob New
>
> > becomes
>
> > qual            = ('Submitter' = "Demo" OR 'Submitter' = "Bob") AND
> > 'Status' = "New"
>
> > I hope that helps.  Don't forget to make use of the -test command line
> > option to check out what your config is going to do first.
>
> > Mark
>
> > -Original Message-
> > From: Action Request System discussion list(ARSList)
> > [mailto:arsl...@arslist.org] On Behalf Of Elry
> > Sent: 04 October 2011 01:33
> > To: arsl...@arslist.org
> > Subject: RRRChive
>
> > Hi Folks...
>
> > We just started using the RRRChive utilitty to do a large migration.
> > I was wondering if any of the power users - could provide examples of how
> > to:
>
> > 1) Create qualifications.
> > 2) Pass parameters to the "cfg" file.
>
> > Any help that could be provided - would be greatly appreciated.
>
> > Thanks.
>
> > ___ 
> > 
> > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgattend wwrug11
> >www.wwrug.comARSList: "Where the Answers Are"
>
> > ___ 
> > 
> > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> > attend wwrug11www.wwrug.comARSList: "Where the Answers Are"
>
> ___ 
> 
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> attend wwrug11www.wwrug.comARSList: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

RRRChive

[Elry]

Hi Folks...

We just started using the RRRChive utilitty to do a large migration.
I was wondering if any of the power users - could provide examples of
how to:

1) Create qualifications.
2) Pass parameters to the "cfg" file.

Any help that could be provided - would be greatly appreciated.

Thanks.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Re: Where are the WWRUG11 document

[Elry]

Hey David..

Unfortunately, if you did not attend WWRUG - they are not available.
They are available to WWRUG attendees.  You would have to contact the
WWRUG organizers and ask them if they can make the information
available.


On Sep 29, 10:45 am, David Durling  wrote:
> Does anyone know if some of the WWRUG presentations will be made available at 
> some point to those who did not attend?
>
> Maybe I'll make it to a WWRUG sometime...
>
> David Durling
> Enterprise IT Services
> University of Georgia
>
>
>
>
>
>
>
>
>
> > -Original Message-
> > From: Action Request System discussion list(ARSList)
> > [mailto:arsl...@arslist.org] On Behalf Of Misi Mladoniczky
> > Sent: Friday, September 23, 2011 8:06 PM
> > To: arsl...@arslist.org
> > Subject: Where are the WWRUG11 document SOLVED
>
> > Hi all WWRUG11 participants,
>
> > I have attached an image, showing where to find all the WWRUG11
> > presentation PDFs from thehttp://manager.mingle360.comwebsite.
>
> > You may noticed that my mouse action is a little bit shaky at the moment,
> > which may be a result of yesterdays celebration...
>
> > Note that you will need your WWRUG11 minglestick login to be able to get
> > them.
>
> >         Best Regards - Misi, RRR AB,http://www.rrr.se
>
> ___ 
> 
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> attend wwrug11www.wwrug.comARSList: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Re: Why ITIL is not standardize till now?

[Elry]

Well...

In the past I have completed a lot of R&D on ITIL software vendors for
pure research or for the creation/response to RFP's.

Amanullah if it is research you are doing - then I would suggest EMA.
I don't know how well funded you are to do research, but you can set
up a free account with EMA and look at some of the free advice they
offer:


(1) Website

http://www.enterprisemanagement.com

(2) ITIL Process Research

http://www.enterprisemanagement.com/coverage/ITIL.php

(3) IT Vendor Research

http://www.enterprisemanagement.com/vendors/subscriptions.php

(4) IT Management Solution Center (This is a free tool for getting
some basic knowledge on vendors).

http://itsolutions.enterprisemanagement.com/


I hope this helps.

Good luck on the research.

Be sure to send me a copy when you are done.


On Sep 28, 11:38 am, David Sanders
 wrote:
> For a list of ITIL processes and toolsets take a look 
> athttp://www.pinkelephant.com/PinkVERIFY/
> And follow the 4 links at the bottom of the page... there are many more
> products than the four you list.  The pages list which ITIL processes each
> vendor is verified for
>
> David Sanders
> Solution Architect
> Enterprise Service Suite @ Work
> ==
>
> tel +44 1494 468980
> mobile +44 7710 377761
> email david.sand...@westoverconsulting.co.uk
>
> webhttp://www.westoverconsulting.co.uk
>
>
>
>
>
>
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
>
> [mailto:arsl...@arslist.org] On Behalf Of IT (Amanullah Bashir Ahmed)
> Sent: Wednesday, September 28, 2011 2:16 PM
> To: arsl...@arslist.org
> Subject: Re: Why ITIL is not standardize till now?
>
> Hi Elry,
>
> Thanks for your response. I am doing research on it, my research topic is
> "Towards ITIL Processes Standardization". I want to study the processes of
> all companies(e.g. BMC Remedy, HP Openview, IBM Tivoli, and CA inc) which
> are using ITIL concepts. For BMC Remedy I have all processes of Incident
> Management, Problem Management, Change Management, Service Level Management,
> and Release Management. I don't have processes of HP Openview, IBM Tivoli,
> and CA inc. How can I get documents of processes? After studying all
> processes I can write something on my topic.
> Again thanks for your response and waiting for again response.
>
> Thanks & Regards
>
> Amanullah
> IT Enterprise Applications
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:arsl...@arslist.org] On Behalf Of Elry
> Sent: Wednesday, September 28, 2011 4:19 PM
> To: arsl...@arslist.org
> Subject: Re: Why ITIL is not standardize till now?
>
> Good Question...
>
> They seem to like to deal only with the academic generalities and
> refuse to roll up their sleeves and do the real work.
> I was fortunate do my ITIL Masters with one of the original founders
> of ITIL.  He intimated that their goal was to provide
> a blueprint with general guidelines that could be adapted to various
> organizations; therefore, to actually get into the
> details would deter from their "prime directive"; ergo, organizations
> like "Pink Elephant" and guidelines like "Pink Verify".
>
> Maybe in time as ITIL V3 matures - there will be more conclusive
> guidelines.
>
> On Sep 28, 1:15 am, "IT (Amanullah Bashir Ahmed)"
>  wrote:
> > Hi there,
> > I visited the link and got good information thanks for the link. But my
> query is Why ITIL itself is not making its own standards?
>
> > Thanks & Regards
>
> > Amanullah
> > IT Enterprise Applications
>
> > -Original Message-
> > From: Action Request System discussion list(ARSList)
> [mailto:arsl...@arslist.org] On Behalf Of Elry
> > Sent: Monday, September 26, 2011 12:45 AM
> > To: arsl...@arslist.org
> > Subject: Re: Why ITIL is not standardize till now?
>
> > To further add to that - check the following links see if they help...
>
> > 1) Pink Verify Standards
>
> >http://www.pinkelephant.com/pinkverify/
>
> > 2) OGC Standards
>
> >http://www.itil-officialsite.com/SoftwareScheme/ITILSoftwareScheme.aspx
>
> > 3) BMC is gold level member of the OGC Standards.
>
> >http://www.itil-officialsite.com/SoftwareScheme/EndorsedSoftwareTools...
>
> > On Sep 25, 7:25 am, Brian Pancia  wrote:
> > > Look at ISO 2.  This is pretty much the standard for ITIL.
>
> > > From: Action Request System discussion list(ARSList)
> > > [mailto:arsl...@arslist.or

Re: Why ITIL is not standardize till now?

[Elry]

Good Question...

They seem to like to deal only with the academic generalities and
refuse to roll up their sleeves and do the real work.
I was fortunate do my ITIL Masters with one of the original founders
of ITIL.  He intimated that their goal was to provide
a blueprint with general guidelines that could be adapted to various
organizations; therefore, to actually get into the
details would deter from their "prime directive"; ergo, organizations
like "Pink Elephant" and guidelines like "Pink Verify".

Maybe in time as ITIL V3 matures - there will be more conclusive
guidelines.


On Sep 28, 1:15 am, "IT (Amanullah Bashir Ahmed)"
 wrote:
> Hi there,
> I visited the link and got good information thanks for the link. But my query 
> is Why ITIL itself is not making its own standards?
>
> Thanks & Regards
>
> Amanullah
> IT Enterprise Applications
>
>
>
>
>
>
>
> -Original Message-
> From: Action Request System discussion list(ARSList) 
> [mailto:arsl...@arslist.org] On Behalf Of Elry
> Sent: Monday, September 26, 2011 12:45 AM
> To: arsl...@arslist.org
> Subject: Re: Why ITIL is not standardize till now?
>
> To further add to that - check the following links see if they help...
>
> 1) Pink Verify Standards
>
> http://www.pinkelephant.com/pinkverify/
>
> 2) OGC Standards
>
> http://www.itil-officialsite.com/SoftwareScheme/ITILSoftwareScheme.aspx
>
> 3) BMC is gold level member of the OGC Standards.
>
> http://www.itil-officialsite.com/SoftwareScheme/EndorsedSoftwareTools...
>
> On Sep 25, 7:25 am, Brian Pancia  wrote:
> > Look at ISO 2.  This is pretty much the standard for ITIL.
>
> > From: Action Request System discussion list(ARSList)
> > [mailto:arsl...@arslist.org] On Behalf Of IT (Amanullah Bashir Ahmed)
> > Sent: Sunday, September 25, 2011 3:31 AM
> > To: arsl...@arslist.org
> > Subject: Why ITIL is not standardize till now?
>
> > **
>
> > Hi,
>
> > Why ITIL is not standardize till now?
>
> > If we see IEEE, they have their standards but ITIL don't have.
>
> > Anybody knows about white paper on ITIL  Standardization. Standards work
> > best when they describe something in measureable terms that can be
> > independently tested and verified. Standards define a definite output in
> > unambiguous language to prevent miscommunications and misunderstandings.
>
> > Thanks & Regards
>
> > Amanullah
>
> > IT Enterprise Applications
>
> > DISCLAIMER:"This e-mail message including any of its attachments is intended
> > solely for the addressee(s) and may contain privileged information. If you
> > are not the addressee or you have received this email message in error,
> > please notify the sender who will remove your details from its database. You
> > are not authorized to read, copy, disseminate, distribute or use this e-mail
> > message or any attachment to it in any manner and must delete the email and
> > destroy any hard copies of it. This e-mail message does not contain
> > financial instructions or commitments of any kind. Any views expressed in
> > this message are those of the individual sender and do not necessarily
> > reflect the views of Emirates NBD PJSC, or any other related subsidiaries,
> > entities or persons."
>
> > _attend WWRUG11www.wwrug.comARSlist:"Where the Answers Are"_
>
> > ___ 
> > 
> > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> > attend wwrug11www.wwrug.comARSList:"Where the Answers Are"
>
> ___ 
> 
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> attend wwrug11www.wwrug.comARSList: "Where the Answers Are"
>
> ___ 
> 
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> attend wwrug11www.wwrug.comARSList: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Re: Where are the WWRUG11 document SOLVED

[Elry]

Thanks Misi...

I don't think I would have found this unless - someone sent me a link.


On Sep 23, 8:05 pm, Misi Mladoniczky  wrote:
> Hi all WWRUG11 participants,
>
> I have attached an image, showing where to find all the WWRUG11
> presentation PDFs from thehttp://manager.mingle360.comwebsite.
>
> You may noticed that my mouse action is a little bit shaky at the moment,
> which may be a result of yesterdays celebration...
>
> Note that you will need your WWRUG11 minglestick login to be able to get
> them.
>
>         Best Regards - Misi, RRR AB,http://www.rrr.se
>
> Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11):
> * RRR|License - Not enough Remedy licenses? Save money by optimizing.
> * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
> Find these products, and many free tools and utilities, athttp://rrr.se.
>
> ___ 
> 
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> attend wwrug11www.wwrug.comARSList: "Where the Answers Are"
>
>  wwrug11docs.jpg
> 124KViewDownload

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Re: Why ITIL is not standardize till now?

[Elry]

To further add to that - check the following links see if they help...

1) Pink Verify Standards

http://www.pinkelephant.com/pinkverify/

2) OGC Standards

http://www.itil-officialsite.com/SoftwareScheme/ITILSoftwareScheme.aspx

3) BMC is gold level member of the OGC Standards.

http://www.itil-officialsite.com/SoftwareScheme/EndorsedSoftwareTools/EndorsedSoftwareTools.aspx


On Sep 25, 7:25 am, Brian Pancia  wrote:
> Look at ISO 2.  This is pretty much the standard for ITIL.
>
> From: Action Request System discussion list(ARSList)
> [mailto:arsl...@arslist.org] On Behalf Of IT (Amanullah Bashir Ahmed)
> Sent: Sunday, September 25, 2011 3:31 AM
> To: arsl...@arslist.org
> Subject: Why ITIL is not standardize till now?
>
> **
>
> Hi,
>
> Why ITIL is not standardize till now?
>
> If we see IEEE, they have their standards but ITIL don't have.
>
> Anybody knows about white paper on ITIL  Standardization. Standards work
> best when they describe something in measureable terms that can be
> independently tested and verified. Standards define a definite output in
> unambiguous language to prevent miscommunications and misunderstandings.
>
> Thanks & Regards
>
> Amanullah
>
> IT Enterprise Applications
>
> DISCLAIMER:"This e-mail message including any of its attachments is intended
> solely for the addressee(s) and may contain privileged information. If you
> are not the addressee or you have received this email message in error,
> please notify the sender who will remove your details from its database. You
> are not authorized to read, copy, disseminate, distribute or use this e-mail
> message or any attachment to it in any manner and must delete the email and
> destroy any hard copies of it. This e-mail message does not contain
> financial instructions or commitments of any kind. Any views expressed in
> this message are those of the individual sender and do not necessarily
> reflect the views of Emirates NBD PJSC, or any other related subsidiaries,
> entities or persons."
>
> _attend WWRUG11www.wwrug.comARSlist: "Where the Answers Are"_
>
> ___ 
> 
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> attend wwrug11www.wwrug.comARSList: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

News From WWRUG

[Elry]

Hi Folks...

If you are a developer - you definitely have to check this out:

http://www.corear.se/corear_products.html

Create and ERD & Control Field ID's.

We got a peek at this thanks to Anders Wilhelm.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Re: Enable trace (SQL and Filter logs) for single user

[Elry]

Has anyone tried setting this on the AR System User Preference form
when
a Preference server is setup.

I am curious to see if the same permissions would be required under
this
scenario.

If permissions is not an issue - then this would be a nice "segway"
into
administrator controlled logging for any individual user.


On Aug 17, 1:16 am, Mikhail Kovrizhnykh 
wrote:
> Rick Cook-3 wrote:
>
> > Yes.  The User tool allows that, though you have to be logged in as a user
> > with the permissions to run those.
>
> > Rick
>
> Thank you, Rick.
>
> --
> View this message in 
> context:http://old.nabble.com/Enable-trace-%28SQL-and-Filter-logs%29-for-sing...
> Sent from the ARS (Action Request System) mailing list archive at Nabble.com.
>
> ___ 
> 
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> attend wwrug11www.wwrug.comARSList: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Re: Dymanic Text in Trim Text field

[Elry]

For those that are HTML savvy - try using a VIEW FIELD and using an
active link to
dynamically change the HTML.

Here is a procedure for creating a dynamic text field using a View
Field.

I can't take credit for it - someone posted something about a
scrolling marquee
a couple of years ago - I just extrapolated.

Procedure for using a View Field:

1. Create a View Field (i.e. "Z_DYNAMIC_TEXT_FIELD" )
2. Create the HTML Text using your favorite HTML Editor (i.e. Coffee
Cup Free HTML Editor).
3. Create an Active Link that Sets the View Field to the HTML that you
created.

==
   SAMPLE DYNAMIC HTML (SCROLLING MARQUEE)
   ENTER THIS TEXT INTO A SET FIELD ACTIVE LINK ACTION...
==
("





Nouvelle page 1





" + $Z_DYNAMIC_TEXT_FIELD$) + "




"

==

Tips, Tricks & Traps

1. The entire HTML code must be enclosed in single quotes.
2. First do a Search and replace on single quotes and replace them
with double quotes.
3. When you add a field to the HTML to make it dynamic - be sure to
use the
standard concatenation technique (i.e. brackets & the "+" symbol).

Give it a go - I have been using it for the last two years.

Works just fine.


On Aug 16, 4:51 pm, Mahesh  wrote:
> "Change Field" action with field label Changed.
>
> On Tue, Aug 16, 2011 at 1:29 AM, Bhupesh Gupta
> wrote:
>
> > **
> > Dear all - Can some one please suggesr , how to change text of a trim text
> > field during runtime via workflow? Really urgent help required
>
> > --
> > Regards,
> > Bhupesh Gupta
> > _attend WWRUG11www.wwrug.comARSlist: "Where the Answers Are"_
>
> ___ 
> 
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> attend wwrug11www.wwrug.comARSList: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Re: ODBC not returning the expected values from Incident form

[Elry]

ARODBC Can return odd things if there is no "WHERE" clause.

Even if the "WHERE" clause returns all entries.


On Aug 2, 8:42 am, Jonas Stumph stevnsvig  wrote:
> Hi again, I'll try not to hit ctrl+enter again... sorry for the triple
> posts.
>
> I am still fiddling with this problem, concering ARODBC and the number
> of records to be returned.
>
> I and querying the incident form on a server with 12000 records, and
> getting very big variations in how many records are being returned. I
> started in excel, and moved to VBscript to
> 1) ascertain whether it was an excel or ARODBC error.
> and
> 2) to be able to correct and experiment faster than waiting for the GUIs in 
> the ODBC system in excel to refresh.
>
> I have tried several different variations of where clauses, as previously 
> suggested (eg. WHERE Incident_Number<>  'ThisOldString') but to no avail.
>
> BMC support is misunderstanding me, and thinks that I am trying on different 
> databases, wih different numbers of records, so I have tried to clarfy my 
> query to them.
>
> Does anyone else have any ideas of what else I can try?
>
> Best regards, Jonas Stevnsvig
>
> ** SELECT with approximately 60 records returned, of 12000 total
> SELECT
>   *
> FROM
>   HPD_Help_Desk
> ORDER BY
>   Incident_Number DESC
>
> ** SELECT with approximately 1000 records returned, of 12000 total
> SELECT
>   Incident_Number,
>   Product_Categorization_Tier_1,
>   Product_Categorization_Tier_2,
>   Product_Categorization_Tier_3,
>   First_Name,
>   Last_Name,
>   Site,
>   Status,
>   Priority,
>   Assignee,
>   Assigned_Group,
>   Assignee_Login_ID,
>   Categorization_Tier_1,
>   Categorization_Tier_2,
>   Categorization_Tier_3,
>   Corporate_ID,
>   Reported_Source,
>   Service_Type,
>   Submit_Date,
>   Submitter
> FROM
>   HPD_Help_Desk
> ORDER BY
>   Incident_Number DESC
>
> ** SELECT with approximately 9500 records returned, of 12000 total
> SELECT
>   Incident_Number,
>   Product_Categorization_Tier_1,
>   Product_Categorization_Tier_2,
>   Product_Categorization_Tier_3,
>   First_Name,
>   Last_Name,
>   Site,
>   Status,
>   Priority,
>   Assignee,
>   Assigned_Group,
>   Assignee_Login_ID,
>   Categorization_Tier_1,
>   Categorization_Tier_2,
>   Categorization_Tier_3,
>   Corporate_ID,
>   Reported_Source,
>   Submit_Date,
>   Submitter
> FROM
>   HPD_Help_Desk
> ORDER BY
>   Incident_Number DESC
>
>   ** SELECT with 12000 records returned, of 12000 total
> SELECT
>   Incident_Number,
>   Product_Categorization_Tier_1,
>   Product_Categorization_Tier_2,
>   Product_Categorization_Tier_3,
>   First_Name,
>   Last_Name,
>   Site,
>   Status,
>   Priority,
>   Assignee,
>   Assigned_Group,
>   Assignee_Login_ID,
>   Corporate_ID,
>   Reported_Source,
>   Submit_Date,
>   Submitter
> FROM
>   HPD_Help_Desk
> ORDER BY
>   Incident_Number DESC
>
> ___ 
> 
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> attend wwrug11www.wwrug.comARSList: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Re: ITSM ERD

[Elry]

Hi Gary...

I don't think there is an ERD in the traditional sense for ITSM.  The
only way one could create an ERD would be to treat each form as a
virtual table.  With that being said - we created a type of ERD for
ITSP4 (the predecessor for current ITSM Suite).  That ERD was massive
and time consuming.  We had to create some proprietary methods for
representing tables fields and some of the other components.  Even
then - we still did not feel that we captured all the elements.

I would be very interested to see if there is a "ERD" for the ITSM
suite.

We abandoned the notion of trying to create ERD's - and replaced it
with the Abydos Analyzer.  We found that we could use this tool to
discover just about all any developer needs to know in terms of what
is related to any given form.

And no - I don't work for Abydos.  Analyzer is just a good tool for
looking at ERD type relationships.


On Jul 13, 1:39 am, Mark Herring  wrote:
> You can use Abydos Analyser to generate ERDs for any ITSM application by
> using the Form Relationship Diagram.
> Seewww.abydos-workflow.comfor more information and free trial.
>
> Mark Herring
> Abydos
>
>
>
>
>
>
>
> -Original Message-
> From: Gary Dries [mailto:gary.dr...@gmail.com]
> Sent: 12 July 2011 21:57
> Subject: ITSM ERD
>
> Lister's,
>
> Has anyone produced a full or segmented by module ERD for any version
> of ITSM from 7.0.01 to 7.6.04?
>
> BMC has not produce anything as good as the BMCR RemedyR IT Service
> Management 7.0 Architecture document for any more recent version that
> I could find.
>
> I have made a request to BMC via my Sales Rep and their Help Desk
>
> I know this is a huge ERD with 7.1 at 1600 plus table to 7.6.04 to
> 2500 plus tables
>
> Thanks in advance for any assistance.
> --
> GARY DRIES
> Remedy Administration and Development
> Contractor - HP Enterprise Services
> US Army
>
> ___ _
> ___
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> attend wwrug11www.wwrug.comARSList: "Where the Answers Are"
>
> ___ 
> 
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> attend wwrug11www.wwrug.comARSList: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Re: ODBC not returning the expected values from Incident form

[Elry]

Hey Jonas...

ODBC Connections can sometimes return unusual results.  Here are some
quick points that might help:

1) Historically different versions of the ODBC Drivers have had
problems returning data when there are not qualifications (where
clause) even if the qualification returns all records.
2) Check to see if there is limit on the server for the number of
records that can be returned by a query.
3) Are you using ARODBC or are you using a Database ODBC connection.
I prefer the ARODBC connection when I don't want to have translate
Enumerated lists or figure out the Epoch Date.
4) When importing into Excel, or Access - remember that there is a
Microsoft Office limitation for the number of columns that can be
returned.

That's about all I can think of right now...

Let me know.


On Jul 8, 6:11 am, Jonas Stumph Stevnsvig  wrote:
> Hi listers
>
> I have an interesting problem.
>
> I have been tasked with fetching some data from HPD:Help Desk (ITSM v
> 7.6.03 both client and ARS server, v 7.6.03)
>
> I ran into an oddity; When Fetching data through ODC (I used Excel to
> start with) I only got about 1000 Records. But i expected 12000. I then
> removed a couple of fields from the list of those i wanted returned, and
> received the full 12k.
>
> To further investigate I copied the connection string and SQL to a vbs
> script I had for another purpose, and altered the sql to find the culprit.
>
> By only altering the FROM part of the SQL clause (note - no WHERE clause
> at all) I got significantly different results (see below)
>
> My question is: have any of you experienced this?
>
> I hope that is is something to do with data corruption (and then again I
> pray that it isn't), since if it's not corrupted data, the ODBC driver is
> not to be trusted to provide correct data, which would be catastrophic.
>
> ** SELECT with approx 60 records
> SELECT
>  *
> FROM
>  HPD_Help_Desk
> ORDER BY
>  Incident_Number DESC
>
> ** SELECT with approx 1000 records
> SELECT
>  Incident_Number,
>  Product_Categorization_Tier_1, Product_Categorization_Tier_2,
> Product_Categorization_Tier_3,
>  First_Name, Last_Name, Site, Status, Priority, Assignee, Assigned_Group,
> Assignee_Login_ID,
>  Categorization_Tier_1, Categorization_Tier_2, Categorization_Tier_3,
>  Corporate_ID, Reported_Source, Service_Type, Submit_Date, Submitter
> FROM
>  HPD_Help_Desk
> ORDER BY
>  Incident_Number DESC
>
> ** SELECT with approx 9500 records
> SELECT
>  Incident_Number,
>  Product_Categorization_Tier_1, Product_Categorization_Tier_2,
> Product_Categorization_Tier_3,
>  First_Name, Last_Name, Site, Status, Priority, Assignee, Assigned_Group,
> Assignee_Login_ID,
>  Categorization_Tier_1, Categorization_Tier_2, Categorization_Tier_3,
>  Corporate_ID, Reported_Source, Submit_Date, Submitter
> FROM
>  HPD_Help_Desk
> ORDER BY
>  Incident_Number DESC
>
> ** FULL VBS SCRIPT BELOW HERE 
>
> Dim objConnection
> Dim sql_query, strOutputLine
> Dim arrInputLine, strInputLine
> Dim objFSO, objOutFile
> Dim intCount, intCountNumber
> Dim currDir, connStr
> Dim fso, folder, files, NewsFile,sFolder, strFileName
> Dim bolDEBUG
> Dim strServer, strUser, strPass, strPort
>
> 'For DB connections
> Const adOpenStatic = 3, adLockOptimistic = 3
>
> 'bolDEBUG Flag
> bolDEBUG = false
>
> 'Define variables for folders and files
> Set objFSO = CreateObject("Scripting.FileSystemObject")
> Const ForReading = 1, ForWriting = 2, ForAppending = 8
>
> currDir   = CreateObject("Wscript.shell").currentdirectory
> dbFile    = currDir & "\RKS-Medlemmer.mdb"
> inputDir  = currDir & "\Input"
> strFileName = "Output_" & Date & "_" & DatePart("h", Now) & "-" &
> DatePart("n", Now) & "-" & DatePart("s", Now) & ".csv"
> Set objOutFile = objFSO.OpenTextFile(strFileName, ForAppending, True)
>
> 'Set Variables for connection
> strServer = "servername"
> strUser = "username"
> strPass = "password"
> strPort = "5500"
>
> 'build Connection String
> connStr = "DRIVER={AR System ODBC Driver};ARUseUnderscores=1;ARServer=" &
> strServer & ";" & _
> "ARServerPort=" & strPort & ";" & _
> "UID=" & strUser & ";" & _
> "PWD=" & strPass & ";" & _
> "ARAuthentication=;SERVER=NotTheServer"
>
> '** SELECT with approx 60 records
>
> 'sql_query = "SELECT " & _
> '"* " & _
> '"FROM HPD_Help_Desk " & _
> '"ORDER BY Incident_Number DESC"
>
> '** SELECT with approx 1000 records
>
> 'sql_query = "SELECT " & _
> '       "Incident_Number, " & _
> '       "Product_Categorization_Tier_1, Product_Categorization_Tier_2,
> Product_Categorization_Tier_3, " & _
> '       "First_Name, " & _
> '       "Last_Name, " & _
> '       "Site, " & _
> '       "Status, " & _
> '       "Priority, " & _
> '       "Assignee, " & _
> '       "Assigned_Group, " & _
> '       "Assignee_Login_ID, " & _
> '       "Categorization_Tier_1, Categorization_Tier_2, Categorization_Tier_3, 
> " & _
> '       "Corporate_ID, " & _
> '       "Reported_Source, " & _
> '

Re: Version 8.0

[Elry]

Gentlemen...

Thank you.

This helps a lot.


On Jul 6, 10:36 am, LJ LongWing  wrote:
> Elry,
> 7.0 is already retired earlier this year with the release of 7.67.1 is
> next to go with the next release...their policy has been for quite some tim
> R-2...current R is 7.6, that means they currently support 7.6, 7.5, and
> 7.1only BMC knows when the next release is...but they are typically
> about yearly or so7.6 was released in Jan...so you can do the math.
> They haven't entered any sort of beta for the next release yet, nor have
> they released a versionso both of the other questions are not answerable
> at the momentand 7.1 will be unsupported when the next version comes out
> and 7.5 unsupported the release after that:)
>
>
>
>
>
>
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
>
> [mailto:arsl...@arslist.org] On Behalf Of Elry
> Sent: Wednesday, July 06, 2011 7:38 AM
> To: arsl...@arslist.org
> Subject: Version 8.0
>
> Hi Folks...
>
> I suppose there are other folks out there with questions about
> ARSystem Releases.  Here are a couple of mine:
>
> 1) When will versions 7.5, 7.1, 7.0 be retired?
> 2) When is the next scheduled release?
> 3) Will the next release be version 8.0?
>
> Can anyone help with these Questions?
>
> Thanks.
>
> ___ _
> ___
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> attend wwrug11www.wwrug.comARSList: "Where the Answers Are"
>
> ___ 
> 
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> attend wwrug11www.wwrug.comARSList: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Version 8.0

[Elry]

Hi Folks...

I suppose there are other folks out there with questions about
ARSystem Releases.  Here are a couple of mine:

1) When will versions 7.5, 7.1, 7.0 be retired?
2) When is the next scheduled release?
3) Will the next release be version 8.0?

Can anyone help with these Questions?

Thanks.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Re: Urgent please help! how to refresh table using filters

[Elry]

Sounds right to me - unless she is trying to use a dynamic
qualification.

If so - I don't think this will work on a server side table walk.


On Mar 14, 1:25 pm, Thad Esser  wrote:
> Mary,
>
> I think Jason hit the nail on the head.  Just remember:
> Server Side Table Field + Filter Guide table looping = Phasing Issues
> (considerations at least).
>
> When using a table field on the server side (i.e. in a filter), it doesn't
> need to be refreshed, it will always have the current data (within the
> context of phasing of course).
>
> Hopefully that point you in the right direction. :-)
> Thad
>
> On Sun, Mar 13, 2011 at 3:49 PM, Mary Estrada  wrote:
> > Thanks in advance.
>
> > Having email update a back end table, then call filter guide to check data
> > in columns in table.
> > Need to refresh the table before filter call guide to loop thru all rows.
>
> > Thanks,
>
> > ~Mary
>
> ___­
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> attend wwrug11www.wwrug.comARSList: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Re: Question about NULL

[Elry]

Just a quick question Mark...

Did you mean $NULL$ OR NULL.


On Mar 14, 2:05 pm, "Brittain, Mark"  wrote:
> HI All,
>
> I have a table that uses the following query which searches for any open 
> record that is not assigned to me.
>
> 'Status' < "Closed" AND ('Assigned Person' != "Mark Brittain" OR 'Assigned 
> Person' = NULL)
>
> If I use the query without the Assigned Person' = NULL the result does not 
> include any records that are not assigned.  Both fields are indexed but the 
> NULL causes the full table scan. Is there a way  to write query so that 
> indexing is used but I get the records that are unassigned?
>
> Thanks
> Mark
>
> 
> Mark Brittain
> Remedy Developer
> NaviSite
> mbritt...@navisite.com
> (315) 453-2912 x5335 (Office)
> (315) 317.2897 (Cell)
>
>   
> This e-mail is the property of NaviSite, Inc. It is intended only for the 
> person or entity to which it is addressed and may contain information that is 
> privileged, confidential, or otherwise protected from disclosure. 
> Distribution or copying of this e-mail, or the information contained herein, 
> to anyone other than the intended recipient is prohibited.
>
> ___­
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> attend wwrug11www.wwrug.comARSList: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Re: 'The End' of support for Remedy 6.3.

[Elry]

I agree John...

I have been around since version 2.0 and I would have to say 6.3 was a
good one.


On Mar 8, 8:07 am, John Baker  wrote:
> It's a shame as it was a good solid release.
>
> Good news, we still support SSO Plugin for AR System 6.3 and I believe
> others have had success connecting Midtier 7.0 (for better performance)
> to AR System 6.3, so there's still life in the system yet.
>
> ___­
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> attend wwrug11www.wwrug.comARSList: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Re: Abydos Analyser Recommendation

[Elry]

Abydos Analyzer is the way to go...

We have been using this product for over 2 years now.  We have a
custom solution.  Once our developers know how to use Abydos - it is
all the documentation they need to get going...



On Mar 7, 11:22 am, Support  wrote:
> ** Hi Mark,
> Don't forget to check ARSmarts as well ;-) :-) .  The best solution to 
> find your way in your Remedy applications
> Workflow documentation, graphical representation, search,  it's all there.
> Best regards.
> Kaïskais.albas...@arsmarts.comwww.arsmarts.com
> On 4/03/2011 15:20, Brittain, Mark wrote:**
>
> Interesting. What do you call a small investment?
>
>
>
>  
>
>
>
> Thanks
>
>
>
> Mark
>
>
>
>  
>
> _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Re: ARS 7.5 Flashboard Issue

[Elry]

Hey Kevin ...

We have a similar setup.  I did notice that we had problems displaying
and refreshing the flashboards when we made them dynamic.  I found I
could make the problem go away by giving the flashboard default
parameters that load when the form the loads.  That way a default
flashboard is seen when the form opens.   I then allow the User to
make choices in fields that will change the nature of the flashboard.
This seems to work for me.

Good Luck Bud.


On Mar 4, 7:40 am, Kevin Begosh  wrote:
> List,
> I have a flashboard console form, display only, where I have 5 flashboard
> data visualization items.  On that same console I have some fields lets say
> a, b and c.  A is a list of all the dashboards and when you select it, it
> hides and unhides all of them based on which one you select.  Fields b and c
> are data fields that drive the qualification of the flashboards.  So when
> you select a or b I am changing the qualification of the flashboard and
> refreshing it to show the new data.  Everything so far works fine with
> this.  The problem I just noticed is that after the select the B or C a
> couple of times the FB stop refreshing.  If I closed the form and come back
> in everything works fine again and the FB refresh when I select the menu.
> The again after a couple of menu selections, lets say 4 or 5 of B or C, the
> FB stop refreshing again.  This is only happening on the mid tier, the user
> tool does not appear to "lock up" as I am calling it, at all.  This may
> sound dumb but it almost seems like there is so many times you can refresh
> the FB before it just locks up.  Has anyone seen this before?
>
> AR Server 7.5 patch 7
> ITSM 7.6.00
> Windows 2003
> SQL 2005
>
> --
> Kevin Begosh
>
> ___­
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> attend wwrug11www.wwrug.comARSList: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Re: ARERR 1900: No Applications in Application List

[Elry]

Thanks Folks...

I have two new things to check on now.

On Nov 15, 4:04 pm, "Murnane, Phil"  wrote:
> Elry:
>
> I've run into something similar where the links are displayed but don't work 
> when clicked.  In our case it was a Windows security policy for IE that was 
> the root cause.  Our fix in Windows Server 2003 was to enable Active 
> Scripting in the policy under Computer Configuration->Administrative 
> Templates->Windows Components->Internet Explorer->Internet Control 
> Panel->Security Page->Local Machine Zone.
>
> FWIW,
> --Phil
>
>
>
> -Original Message-
> From: Action Request System discussion list(ARSList) 
> [mailto:arsl...@arslist.org] On Behalf Of Ramey, Anne
> Sent: Monday, November 15, 2010 15:51
> To: arsl...@arslist.org
> Subject: Re: ARERR 1900: No Applications in Application List
>
> Sounds like yours is a different situation than ours, but when I saw that, it 
> turned out to be a damaged AL guide.  Finding it was a pain, but once we 
> found it and could restore it, it was a simple fix.
>
> Anne Ramey
> ***
> E-mail correspondence to and from this address may be subject to the North 
> Carolina Public Records Law and may be disclosed to third parties only by an 
> authorized State Official.
>
> -Original Message-
> From: Action Request System discussion list(ARSList) 
> [mailto:arsl...@arslist.org] On Behalf Of Elry
> Sent: Monday, November 15, 2010 2:21 PM
> To: arsl...@arslist.org
> Subject: ARERR 1900: No Applications in Application List
>
> Hi Guys...
>
> I have seen several posts for this issue.  We have a situation where a
> number of microsoft patches were applied to our servers over the
> weekend.  We have a Development and a Staging environment that are all
> on VMWare, but our production environment are three tiered standalone
> servers.
>
> Specs:
>
> Windows Server 2003
> MSSQL Database 2005
> ARS 7.5 Patch 2
>
> Only our Production environment appears to be affected.  Our homepage
> refuses to display an application list.  This is true for all clients
> and for the mid-tier as well as the WUT.  Now we have tried the
> following:
>
> 1)  "regsvr32 c:\windows\system32\msxml3.dll" at Start -> Run.
> 2)  Removing and re-installing clients.
> 3)  Clearing Client caches.
> 4)  Restarting the Services.
> 5)  Re-booting Application & Database Servers.
>
> Are there other files like msxml3.dll that may be problematic when
> rendering Application lists. Can anyone lend "a helping hand"?
>
> Thanks.
>
> ___­
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> attend wwrug11www.wwrug.comARSList: "Where the Answers Are"
>
> ___­
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> attend wwrug11www.wwrug.comARSList: "Where the Answers Are"
>
> ___­
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> attend wwrug11www.wwrug.comARSList: "Where the Answers Are"- Hide quoted text 
> -
>
> - Show quoted text -

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

ARERR 1900: No Applications in Application List

[Elry]

Hi Guys...

I have seen several posts for this issue.  We have a situation where a
number of microsoft patches were applied to our servers over the
weekend.  We have a Development and a Staging environment that are all
on VMWare, but our production environment are three tiered standalone
servers.

Specs:

Windows Server 2003
MSSQL Database 2005
ARS 7.5 Patch 2

Only our Production environment appears to be affected.  Our homepage
refuses to display an application list.  This is true for all clients
and for the mid-tier as well as the WUT.  Now we have tried the
following:

1)  "regsvr32 c:\windows\system32\msxml3.dll" at Start -> Run.
2)  Removing and re-installing clients.
3)  Clearing Client caches.
4)  Restarting the Services.
5)  Re-booting Application & Database Servers.

Are there other files like msxml3.dll that may be problematic when
rendering Application lists. Can anyone lend "a helping hand"?

Thanks.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Re: Software Tool House Meta-Update

[Elry]

Thanks Jason...

I spoke to Ben and he is going to give me a demo on Monday.

On Oct 21, 4:02 am, Jason Miller  wrote:
> Absolutely.  You can write a query as simple or complex as you wish to pull
> the source records.  Then additional comparison queries against the target
> system (or a form on the same system) to make sure you ignore/update/create
> if an existing record is found or not.  You also have the ability to
> suppress workflow so your data does not change as you are loading it into
> the new system/form.
>
> Admittedly we are just pretty new to it and have not used it extensively.  I
> have written a few semi-basic scripts to get started.  One of them will look
> to our home grown inventory form for IT assets (old environment) and create
> CI's in the correct class (new environment) based on the CTI from the source
> record.  You can do conditional statements and loops as well as get data
> from multiple sources (forms and even do a look up against Excel in the same
> run) to build the new "asset" record in memory and then load it into the
> CMDB.
>
> You can also use regex to manipulate data while "building" the new record in
> memory.  In the past I have written AR workflow to perform some type of data
> manipulation/parsing.  Depending on the complexity it can take quite a few
> workflow objects and display only fields.  In more recent history I have
> been known to write scripts that I call from ARS to manipulate data and pass
> a value back.  That still has advantages and disadvantages as well as some
> limitations.  With Meta-Update I can do the scripting pieces with actual
> lines of code (vs temp fields and workflow objects) as well as interact with
> the AR server while running the script.  We are still working on many
> aspects of our migration path from Help Desk 6 with a ton of custom apps to
> ITSM 7.6 and during our meetings where we discuss "migration opportunities"
> with our customers I pick out pieces of the process where I plan to use
> Meta-Update to help with the transition.
>
> HTH,
> Jason
>
> (Yes Dave, I am off to bed now (WWRUG humor))
>
>
>
>
>
> On Wed, Oct 20, 2010 at 5:05 PM, Elry  wrote:
> > Are you finding it useful for data ETL JOBS?
>
> > We have custom applications that need movement of a lot of data based
> > on record status.  Have you it in this capacity?
>
> > On Oct 20, 4:21 pm, Jason Miller  wrote:
> > > We are a new customer and are just starting to use it for our transition
> > > from a ton of custom apps and Help Desk 6 to ITSM 7.6 (two different
> > > environment where data needs to be "translated" before being copied).
> >  Just
> > > like many software purchases you would have to contact Software Tool
> > House
> > > for pricing though.  I don't want to speak on their behalf when it comes
> > to
> > > license model and pricing.
>
> > > Jason
>
> > > On Wed, Oct 20, 2010 at 10:09 AM, Elry  wrote:
> > > > Has anyone used this product or know the pricing/llicensing scheme?
>
> > ___
> > 
> > > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> > > > attend wwrug10www.wwrug.comARSlist:"Where the Answers Are"
>
> > ___
> > 
> > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> > > attend wwrug10www.wwrug.comARSlist:"Where the Answers Are"
>
> > ___­
> > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> > attend wwrug10www.wwrug.comARSlist: "Where the Answers Are"
>
> ___­
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> attend wwrug10www.wwrug.comARSlist: "Where the Answers Are"- Hide quoted text 
> -
>
> - Show quoted text -

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

Re: Software Tool House Meta-Update

[Elry]

Are you finding it useful for data ETL JOBS?

We have custom applications that need movement of a lot of data based
on record status.  Have you it in this capacity?


On Oct 20, 4:21 pm, Jason Miller  wrote:
> We are a new customer and are just starting to use it for our transition
> from a ton of custom apps and Help Desk 6 to ITSM 7.6 (two different
> environment where data needs to be "translated" before being copied).  Just
> like many software purchases you would have to contact Software Tool House
> for pricing though.  I don't want to speak on their behalf when it comes to
> license model and pricing.
>
> Jason
>
> On Wed, Oct 20, 2010 at 10:09 AM, Elry  wrote:
> > Has anyone used this product or know the pricing/llicensing scheme?
>
> > ___ 
> > 
> > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> > attend wwrug10www.wwrug.comARSlist: "Where the Answers Are"
>
> ___ 
> 
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> attend wwrug10www.wwrug.comARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

Software Tool House Meta-Update

[Elry]

Has anyone used this product or know the pricing/llicensing scheme?

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

Re: SQL Database Replication

[Elry]

Sorry forgot to add the following:

Lessons Learned:

1) Restoring a 2005 SQL database to a 2008 SQL database may have been
the culprit.
2) Even if your 2008 database is running in 2005 Mode - this will
cause unusual problems.
3) ar.cfg needs to be updated.
4) For some reason the ARAdmin User gets dropped in some cases - so
you have to recreate it.
5) Verify that ARAdmin has the right privileges or it will fail...
5) If you change your ARAdmin password in production, but keep the
default elsewhere - you will have to:
a) Make it consistent across all servers.
b) Hard code it in the ar.cfg File if this is "after the restore".
c) If you hard code any passwords - change it from the System
Console to re-encrypt.

I think these were key to getting the system up and operational.

I hope this will help someone else in the future.


On Jul 21, 2:39 pm, Elry  wrote:
> Thanks Folks...
>
> There were a few issues to address witht the DBA, but once we were
> both on the same page - we got everything up and running.
>
> It was at least comforting to know that others had been successful at
> this endeavour; therefore, all that was needed was a little BST (Blood
> Sweat and Tears)...:)
>
> On Jul 20, 11:20 am, Robert Molenda  wrote:
>
>
>
>
>
> >  We have a complete automated solution utilizing SSIS Scripts which will:
>
> >    1. 7zip the complete "last night full backup" of production
> >    2. FTP the compressed file to the target system (test / dev / etc)
> >    3. Uncompress the remote file
> >    4. shutdown remedy processes
> >    5. restore the database
> >    6. grant User Permissions (Restore removes the permissions for ARAdmin
> >    account)
> >    7. Updates the various remedy tables replacing the server name, etc
> >    (Configurable)
> >    8. Starts up remedy
>
> > This works quite well - including the logging of activities into a remedy
> > table in order to provide timing and alerting on success / failures...
> > The only "issues" are:
>
> >    1. Duration of / and sometimes failure of FTP - The SSIS Script can
> >    detect it can generate error to restart job - but unfortunately the 
> > systems
> >    don't support restartable FTP :(
> >    2. Target DB Size - you are transferring production of XX GB to DEV
> >    where really only foundation data only is needed
> >    3. Target DB Size - the nightly full backups of DEV / Test are now XX GB
> >    4. SQL Performance on DEV / TEST - since the DB is now HUGE - so the SQL
> >    Servers for Performance must be capable of supporting a huge database -
> >    Normally Dev / Test are a shared SQL environment because of the size and
> >    performance requirements
>
> > If you would like more information - please contact me directly
> > Robert Molenda - Principal Consultant - Infosys Technologies
>
> > (Note original message thread deleted because of "maximum size" by the list
> > server caused it to be rejected)
>
> > ___­­
> > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> > attend wwrug10www.wwrug.comARSlist:"Where the Answers Are"
>
> ___­
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> attend wwrug10www.wwrug.comARSlist: "Where the Answers Are"- Hide quoted text 
> -
>
> - Show quoted text -

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

Re: SQL Database Replication

[Elry]

Thanks Folks...

There were a few issues to address witht the DBA, but once we were
both on the same page - we got everything up and running.

It was at least comforting to know that others had been successful at
this endeavour; therefore, all that was needed was a little BST (Blood
Sweat and Tears)...:)


On Jul 20, 11:20 am, Robert Molenda  wrote:
>  We have a complete automated solution utilizing SSIS Scripts which will:
>
>    1. 7zip the complete "last night full backup" of production
>    2. FTP the compressed file to the target system (test / dev / etc)
>    3. Uncompress the remote file
>    4. shutdown remedy processes
>    5. restore the database
>    6. grant User Permissions (Restore removes the permissions for ARAdmin
>    account)
>    7. Updates the various remedy tables replacing the server name, etc
>    (Configurable)
>    8. Starts up remedy
>
> This works quite well - including the logging of activities into a remedy
> table in order to provide timing and alerting on success / failures...
> The only "issues" are:
>
>    1. Duration of / and sometimes failure of FTP - The SSIS Script can
>    detect it can generate error to restart job - but unfortunately the systems
>    don't support restartable FTP :(
>    2. Target DB Size - you are transferring production of XX GB to DEV
>    where really only foundation data only is needed
>    3. Target DB Size - the nightly full backups of DEV / Test are now XX GB
>    4. SQL Performance on DEV / TEST - since the DB is now HUGE - so the SQL
>    Servers for Performance must be capable of supporting a huge database -
>    Normally Dev / Test are a shared SQL environment because of the size and
>    performance requirements
>
> If you would like more information - please contact me directly
> Robert Molenda - Principal Consultant - Infosys Technologies
>
> (Note original message thread deleted because of "maximum size" by the list
> server caused it to be rejected)
>
> ___­
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> attend wwrug10www.wwrug.comARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

Re: Preference Server in a Server Group (7.5)

[Elry]

William...

We use the option: "Use This Server"

In addition to that we created a AR Sysem User Preferecne entry in the
Preference form for every User Profile.

On the Preference Form there are a number of useful parameters that
you can set for End Users that are logging into the system.

i.e. 1) Server Login List
  2) Locale
  3) Alert Servers
  etc

We found this useful - it dramatically reduced End User issues.


On Jul 16, 9:15 am, William Rentfrow 
wrote:
> Doug -
>
> Thanks for the repsonse - and I agree with everything you said.  The
> question is how do we actually configure it that way so users don't have
> to choose it?
>
> The issue here is that we do not want the users to specify the
> preference server in the WUT.  Consequently the server side
> configuration has to be used.  The possible choices are:
>
> -User Defined (not our first choice)
> -Use This Server
> -Use Other Server
>
> If I understand what you're saying then the second option would be
> appropriate.  This conflicts with what support has been telling us so
> far - but our regular dedicated support person is on vacation.
>
> William Rentfrow
> Principal Consultant, StrataCom Inc.
> wrentf...@stratacominc.com
> Corporate Website,www.stratacominc.com
> Blog,www.williamrentfrow.com
> 715-410-8156 C
>
> 
>
> From: Action Request System discussion list(ARSList)
> [mailto:arsl...@arslist.org] On Behalf Of Mueller, Doug
> Sent: Thursday, July 15, 2010 5:59 PM
> To: arsl...@arslist.org
> Subject: Re: Preference Server in a Server Group (7.5)
>
> **
> William,
>
> I am confused by your description.
>
> You have 4 AR System servers pointing to one DB in a server group.
> These are then behind a load balancer.
>
> Is this your entire environment?
>
> If so, you really have ONE logical server.  The load balancer.  PERIOD.
> This is your server.  This is your only
> server.  This is the server you talk to from your client.
>
> So, your mid-tier has one server registered.
> So, your windows clients have one server registered.
>
> All access is to that one logical server -- ignore the fact that behind
> the scenes there are 4 servers.  There is
> ONE logical server.
>
> That one server is your preference server.
>
> There is no need to hunt across servers.  There is ONE server.  If the
> load balancer routes to any of the four,
> you are accessing the same DB and get the same data.
>
> Don't confuse the fact that you have multiple servers doing the work
> make it seem like there are 4 servers.
> There is one logical server and if you put them all behind the load
> balancer, that one name of the load
> balancer level is the ONE and ONLY server for the environment (OK, not
> really as you could go direct as
> well, but if you go to the load balancer that is a single server
> instance -- logically -- regardless of whether it
> really goes to one or multiple physical servers.
>
> So, just configure your system to talk to the ONE server at the logical
> load balancer level and treat that as
> your server -- and your preference server.
>
> I hope this helps,
>
> Doug Mueller
>
> 
>
> From: Action Request System discussion list(ARSList)
> [mailto:arsl...@arslist.org] On Behalf Of William Rentfrow
> Sent: Tuesday, July 13, 2010 8:05 AM
> To: arsl...@arslist.org
> Subject: Preference Server in a Server Group (7.5)
>
> **
> I have a server group with 4 AR Servers.
>
> None of the servers are directly routable to directly by the end users -
> they all access the servers through a virtual name which passes them to
> the load balancer and on down to the server group.
>
> We'd prefer users do not have to enter the preference server name.  BMC
> has advised us to add the actual AR Server names to the WUT and set this
> in the ar.conf on each server.
>
> Preference-Server-Option: 2
>
> In the non-secure world that would make the WUT search through the
> servers until it found the preference server that was defined.
>
> That won't work for us due to security reasons because users can not get
> to the AR Servers directly.
>
> Anyone know a way around this?
>
> William Rentfrow
> Principal Consultant, StrataCom Inc.
> wrentf...@stratacominc.com
> Corporate Website,www.stratacominc.com
> Blog,www.williamrentfrow.com
> 715-410-8156 C
>
> _attend WWRUG10www.wwrug.comARSlist: "Where the Answers Are"_ _attend
> WWRUG10www.wwrug.comARSlist: "Where the Answers Are"_
>
> ___­
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> attend wwrug10www.wwrug.comARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

Re: SQL Database Replication

[Elry]

he SQL database
(ARERR 556)
Thu Jul 15 16:55:57 2010  390600 : Form does not exist on server
(ARERR 303)
Thu Jul 15 16:55:57 2010  390600 : Error in definition for a filter
(ARERR 343)
Thu Jul 15 16:55:57 2010 User Password Change:UpdatePassword`!
Thu Jul 15 16:55:57 2010  390600 : Error in definition for a filter
(ARERR 343)
Thu Jul 15 16:55:57 2010 User Password Change:UpdatePassword`!
Thu Jul 15 16:55:57 2010  390600 : Form does not exist on server
(ARERR 303)
Thu Jul 15 16:55:57 2010  390600 : Error in definition for a filter
(ARERR 343)
Thu Jul 15 16:55:57 2010 User Password
Change:UpdatePasswordErrorHandler
Thu Jul 15 16:55:57 2010  390600 : Error in definition for a filter
(ARERR 343)
Thu Jul 15 16:55:57 2010 User Password
Change:UpdatePasswordErrorHandler
Thu Jul 15 16:55:57 2010  390600 : Form does not exist on server
(ARERR 303)
Thu Jul 15 16:55:57 2010  390600 : Error in definition for a filter
(ARERR 343)
Thu Jul 15 16:55:57 2010 User Password
Change:UpdatePasswordMessage
Thu Jul 15 16:55:57 2010  390600 : Error in definition for a filter
(ARERR 343)
Thu Jul 15 16:55:57 2010 User Password
Change:UpdatePasswordMessage
Thu Jul 15 16:55:57 2010  390600 : Form does not exist on server
(ARERR 303)
Thu Jul 15 16:55:57 2010  390600 : Error in definition for a filter
(ARERR 343)
Thu Jul 15 16:55:57 2010 User Password Management:RestrictSubmit
Thu Jul 15 16:55:57 2010  390600 : Error in definition for a filter
(ARERR 343)

---

I am currently asking the DBA to make sure permissions on the Sandbox
are the same as the permissions on Production.

Thanks - All.

Time for some sleep - then try again in the Morning.




On Jul 15, 3:13 pm, Guillaume Rheault  wrote:
> Hey Elry,
>
> One more thing that I forgot to mention to you, that is a new feature with 
> ARS 7.5, I believe.
> As you may know, AR Server license keys are stored in the database, not in a 
> file as it used be before.
> However, the new feature in ARS 7.5 is that you can enter ARS licenses for 
> servers for which the Host ID is not the one of the current server.
> When the ARS server starts, it picks the license key that matches its host id.
>
> In our case, we entered the DEV and UA ARS serverlicense keys in production, 
> so when we do the database restore, we don't have to key in the ARS Server 
> license key. Very handy.
>
> Myself and other listers have accomplished this task, so it's doable.
>
> So don't give up, and make sure you document all the issues you run into for 
> your specific environment, create a checklist as I suggested, so the next 
> time it will be smoother.
>
> Guillaume
>
> 
> From: Action Request System discussion list(ARSList) [arsl...@arslist.org] on 
> behalf of Elry [elryal...@gmail.com]
> Sent: Thursday, July 15, 2010 2:12 PM
> To: arsl...@arslist.org
> Subject: Re: SQL Database Replication
>
> Well...
>
> We were able to get the system up and running, but I noticed that
> there are some odd things:
>
> 1) All structures and data appear to be available at the database
> level.
> 2) Server Information had no data.
> 3) User form cannot be pulled up in the User Tool/ Dev Studio.
> 4) Forms that are large (300 + fields) cannot be pulled up in the User
> Tool/ Dev Studio.
> 5) ARERR 556 Missing data in the SQL Database is "littered" throughout
>     the arerror.log for forms and workflow.
>
> This begs the question:  Has anyone out there had any such experience
> with 7.5
>
> On Jul 15, 12:20 pm, Elry  wrote:
>
>
>
> > Hi Guys...
>
> > Thanks for all the responses so far.
>
> > Guillame:  I am checking the ar.cfg file right now and correcting a
> > few discrepancies (i.e. the ARAdmin password in production is not the
> > default).
>
> > LJ:  I agree with Oracle last year - we were able to drop and attach
> > database instances without a "hitch".
>
> > Right now - it looks like it is probably the differences with the
> > ar.cfg that might be the issue.
>
> > On Jul 15, 12:03 pm, LJ LongWing  wrote:
>
> > > Elry,
> > > This is how we manage our refreshes of Dev/Test, I can let you know that 
> > > for
> > > our custom application, that function works just fine.
>
> > > -Original Message-
> > > From: Action Request System discussion list(ARSList)
>
> > > [mailto:arsl...@arslist.org] On Behalf Of Elry
> > > Sent: Thursday, July 15, 2010 9:36 AM
> > > To: arsl...@arslist.org
> > > Subject: Re: SQL Database Replication
>
> > > Thanks Terry...
>
> > > Just spoke to the DBA - what he actually di

Re: SQL Database Replication

[Elry]

Agreed...

I am now begining this tedious task of determining if there are any
server references embedded in the workflow and forms that cannot be
displayed.

Thanks Joe.


On Jul 15, 2:38 pm, Joe DeSouza  wrote:
> The only way to check for server references is exporting the definitions and
> looking for server names in those definitions. Everything looks normal viewing
> these objects through the Admin or the Developer tool.. Personally I prefer 
> XML
> definitions as its easier to edit these from XML files and not worrying
> about string lengths and all that good stuff..
>
> Sometimes you cannot blame your developers if server names have still crept 
> in,
> as with some versions of the older Admin tool, there were bugs, where certain
> workflow objects would save the server names instead of making them server
> independent when those objects were created of modified. I have not quite 
> seen a
> pattern on when and how these server names creep in, but did notice that using
> the IP Address as the server name in the Accounts while connecting to the
> server, can cause these kind of issues and would save the IP address instead
> of @ in the database.
>
> Joe
>
> 
> From: Elry 
> To: arsl...@arslist.org
> Sent: Thu, July 15, 2010 11:50:26 AM
> Subject: Re: SQL Database Replication
>
> Thanks Joe...
>
> The application that we are using is not ITSM.  It is a custom application 
> that
> we have built.
>
> All the developers were warned not to hard-code server names, but I have never
> actually checked for this ( I will now).
>
> We are not using AIE or LDAP.
>
> I did not alter the ar.cfg file - shoud we try starting it up with the ar.cfg
> adapted to look like the original?
>
> On Jul 15, 11:44 am, Joe DeSouza  wrote:
>
>
>
>
>
> > Elry,
>
> > One of the reasons answers differ and vary is the configuration. All depends
> on
> > what applications you are using. Does the application have configuration
> > data that hard codes server names like AIE would in its configuration. Some
> > applications store some environment specific information like LDAP server
> names
> > and login credentials. Then there are odd cases where under certain 
> > conditions
> > you get server names or IP Addresses of the server hardcoded into workflow
> such
> > as table fields. Sometimes you need to consider looking up the meta data and
> > make sure you do not have hard coded server name references in workflow.
>
> > So for the most part, yes a simple backup and restore of the database works
> > directly unless you need to tweak some of the application or configuration
> data
> > and meta data to remove hard coded or wrong server references. Also if you
> > choose to replicate the ar.cfg file, make sure you point that file to the
> right
> > database server, or you might end up having a test server point to
> >production...
>
> > Joe
>
> > 
> > From: Elry 
> > To: arsl...@arslist.org
> > Sent: Thu, July 15, 2010 8:46:57 AM
> > Subject: SQL Database Replication
>
> > Hi Folks...
>
> > I am going to ask this question again - because I have never seen a 
> > definitive
> > answer.
>
> > Here is what we have:
>
> > 1) Independent SQL Database Tier (2005).
> > 2) ARSystem Application Tier (7.5 Patch 2).
> > 3) Mid-tier (7.5 Patch 2).
>
> > Environments:
>
> > 1) Sandbox
> > 2) Development
> > 3) Staging
> > 4) Production
> > 5) Reporting/Archiving (to be deployed).
>
> > What we need to do is the following:
>
> > 1) Update the Staging and Development environments with data from production
> > 2) Replicate the Production database to our new Reporting/Archiving
> >environment.
>
> > Options being considered:
>
> > A) Database Replication.
> > B) BMC Remedy Migrator.
> > C) DSO.
>
> > We understand and know how to use options B) and C).  We are looking
> > for feedback from anyone who is successfully using option A). 
> > Specifically...
>
> > 1) What type of replication.
> > 2) Are there configuration paramaters that are retained at the database 
> > level
> > that need to be changed.
> > 3) Are there any considerations for ar.cfg.
>
> > I have never seen a white paper on database replication ( I understand that
> >this
> > method is unsupported).
>
> > Any feedback would be greatly appreciated.
>
> ___­
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> attend wwrug10www.wwrug.comARSlist: "Where the Answers Are"- Hide quoted text 
> -
>
> - Show quoted text -

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

Re: SQL Database Replication

[Elry]

Well...

We were able to get the system up and running, but I noticed that
there are some odd things:

1) All structures and data appear to be available at the database
level.
2) Server Information had no data.
3) User form cannot be pulled up in the User Tool/ Dev Studio.
4) Forms that are large (300 + fields) cannot be pulled up in the User
Tool/ Dev Studio.
5) ARERR 556 Missing data in the SQL Database is "littered" throughout
the arerror.log for forms and workflow.

This begs the question:  Has anyone out there had any such experience
with 7.5




On Jul 15, 12:20 pm, Elry  wrote:
> Hi Guys...
>
> Thanks for all the responses so far.
>
> Guillame:  I am checking the ar.cfg file right now and correcting a
> few discrepancies (i.e. the ARAdmin password in production is not the
> default).
>
> LJ:  I agree with Oracle last year - we were able to drop and attach
> database instances without a "hitch".
>
> Right now - it looks like it is probably the differences with the
> ar.cfg that might be the issue.
>
> On Jul 15, 12:03 pm, LJ LongWing  wrote:
>
>
>
>
>
> > Elry,
> > This is how we manage our refreshes of Dev/Test, I can let you know that for
> > our custom application, that function works just fine.
>
> > -Original Message-
> > From: Action Request System discussion list(ARSList)
>
> > [mailto:arsl...@arslist.org] On Behalf Of Elry
> > Sent: Thursday, July 15, 2010 9:36 AM
> > To: arsl...@arslist.org
> > Subject: Re: SQL Database Replication
>
> > Thanks Terry...
>
> > Just spoke to the DBA - what he actually did was:
>
> > 1) Made a backup copy of Production.
> > 2) Restored the backup copy to the Sandbox.
>
> > This appears to be quite different from replication - could this be
> > the source of the problem.
>
> > On Jul 15, 11:30 am, Terry Bootsma  wrote:
> > > ** Elry:
> > > One thing to consider is that when you replicate from server A to server
> > B, the replicated database may not be in an "active" state.   You may have
> > to take it out of this state to actually start Remedy and have it connect to
> > it...  have you tried this?
> > > Terry
>
> > > On Jul 15, 2010,Elry wrote:
>
> > > Hi Guillaume...
> > > We just gave it a try this morning and got the following error:
> > > Incorrect format in the definition file (ARERR 402). This is when the
> > > ARS Service tries to start - this ouput occurs in the arrerror.log
> > > Looks like ARMonitor shuts it down with a ARERR 33 AND ARERR 32.
> > > Anyone familiar with this 
> > > On Jul 15, 10:58 am, Guillaume Rheault  wrote:
> > > > Elry,
>
> > > > I believe option A is the best, because you will get all the data from
> > production on your development and test environments. This is a huge plus.
> > > > There are a few things that you would need to change once the database
> > is overwritten, such as updating the ARS and ITSM licenses assigend to users
> > (assuming your fixed and floating counts are different from production to
> > dev and UAT), and disabling the outgoing mailbox from your dev and UAT
> > environments, to make sure no email goes out accidentally.
>
> > > > Keep in mind that BMC (well really the old Remedy) architected ARS from
> > its inception do perform this very task, so it's definitely doable. There
> > were some bugs in older ARS versions where the server references were
> > hardcoded, but this is not the case with latest versions (i.e. 7.x and 6.3,
> > I believe).
>
> > > > You may find some sporadic server references in entries in configuration
> >  forms in ITSM, but BMC is working towards making sure there are no server
> > references in the next version.
> > > > It's only a matter of keeping for yourself a checklist of things to do
> > after the DB overwrite.
>
> > > > I suggest creating a ticket with BMC support specifying your ITSM
> > version and patch, so BMC can tell you where, if any, server references are
> > found in your  ITSM version.
>
> > > > I think you'll find this the best option once you get going.
>
> > > > Guillaume
>
> > > > 
> > > > From: Action Request System discussion list(ARSList)
> > [arsl...@arslist.org] on behalf of Elry [elryal...@gmail.com]
> > > > Sent: Thursday, July 15, 2010 8:46 AM
> > > > To:arsl...@arslist.org
> > > > Subject: SQL Database Replication
>
> > > > Hi Folks...
>
> &

Re: Automate Report from Table

[Elry]

Mark ...

There is a form called: "Report"

I use this form to store all reports on the server (both ARR reports
and Crystal Reports).

I then use the Open window command to call the report.

Now that you have a way of selecting the table field records - this
could be the finishing touch.

Let me know.


On Jul 15, 12:50 pm, "Brittain, Mark"  wrote:
> Hi Ely,
>
> Thanks for your suggestion.  I can
> Select all the records using PERFORM-ACTION-TABLE-SELECTALL 600100105
> Got to the Report Styles using PERFORM-ACTION-TABLE-REPORT 600100105
>
> There it stops. My guess it is expecting the report to be selected however 
> the parameter is not in the book. Also the report would have to be on the 
> server so all could use it.
>
> Thanks
> Mark
>
>
>
> -Original Message-
> From: Action Request System discussion list(ARSList) 
> [mailto:arsl...@arslist.org] On Behalf Of Elry
> Sent: Thursday, July 15, 2010 11:31 AM
> To: arsl...@arslist.org
> Subject: Re: Automate Report from Table
>
> Scratch that...
>
> I think you are trying to right click on a table field to create a
> report and record it in a macro.
>
> I don't think that think this is supported.
>
> On Jul 15, 11:21 am, Elry  wrote:
> > Hey Mark...
>
> > I am assuming that you are doing the following with the macro:
>
> > 1) Turn on macro recording.
> > 2) Open the form in search mode.
> > 3) Define a Query.
> > 4) Select Menu:Tools/ Reporting
> > 5) Select New Style
> > 6) Select Fields and set parameters.
> > 7) Preview the report.
> > 8) Stop Recording and Name Macro.
> > 9) Close all windows.
> > 10) Test Macro
>
> > This should work - just tried it...
>
> > Now you can use the Active link attached to a button to a run macro
> > action.
>
> > The better alternative to a run macro action - would be the Open
> > Window command (for running a report).
>
> > Hope this helps.
>
> > On Jul 15, 11:06 am, "Brittain, Mark"  wrote:
>
> > > Hi All,
>
> > > I have a form called Incident Management. On the form contains a table 
> > > called Notes. In the Notes form is the Request ID for the parent Incident 
> > > Management form. I would like to run a report directly from the table 
> > > using a button/active link but cannot seem to get it to work with a macro.
>
> > > The manual steps are:
> > > Right click over the table, and select all
> > > Right click over the table and select report
> > > Select the report
> > > Select Print Preview
> > > Close the Report Styles window.
>
> > > Any suggestions greatly appreciated.
>
> > > Mark
>
> > > 
> > > Mark Brittain
> > > Remedy Developer
> > > NaviSite
> > > mbritt...@navisite.com<mailto:mbritt...@navisite.com>
> > > (315) 453-2912 x5335 (Phone)
> > > (315) 317.2897 (Cell)
>
> > >   
> > > This e-mail is the property of NaviSite, Inc. It is intended only for the 
> > > person or entity to which it is addressed and may contain information 
> > > that is privileged, confidential, or otherwise protected from disclosure. 
> > > Distribution or copying of this e-mail, or the information contained 
> > > herein, to anyone other than the intended recipient is prohibited.
>
> > > ___­­­
> > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> > > attend wwrug10www.wwrug.comARSlist:"Where the Answers Are"
>
> > ___­­
> > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> > attend wwrug10www.wwrug.comARSlist:"Where the Answers Are"- Hide quoted 
> > text -
>
> > - Show quoted text -
>
> ___­
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> attend wwrug10www.wwrug.comARSlist: "Where the Answers Are"
>
> ___­
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> attend wwrug10www.wwrug.comARSlist: "Where the Answers Are"- Hide quoted text 
> -
>
> - Show quoted text -

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

Re: SQL Database Replication

[Elry]

Hi Guys...

Thanks for all the responses so far.

Guillame:  I am checking the ar.cfg file right now and correcting a
few discrepancies (i.e. the ARAdmin password in production is not the
default).

LJ:  I agree with Oracle last year - we were able to drop and attach
database instances without a "hitch".

Right now - it looks like it is probably the differences with the
ar.cfg that might be the issue.



On Jul 15, 12:03 pm, LJ LongWing  wrote:
> Elry,
> This is how we manage our refreshes of Dev/Test, I can let you know that for
> our custom application, that function works just fine.
>
>
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
>
> [mailto:arsl...@arslist.org] On Behalf Of Elry
> Sent: Thursday, July 15, 2010 9:36 AM
> To: arsl...@arslist.org
> Subject: Re: SQL Database Replication
>
> Thanks Terry...
>
> Just spoke to the DBA - what he actually did was:
>
> 1) Made a backup copy of Production.
> 2) Restored the backup copy to the Sandbox.
>
> This appears to be quite different from replication - could this be
> the source of the problem.
>
> On Jul 15, 11:30 am, Terry Bootsma  wrote:
> > ** Elry:
> > One thing to consider is that when you replicate from server A to server
> B, the replicated database may not be in an "active" state.   You may have
> to take it out of this state to actually start Remedy and have it connect to
> it...  have you tried this?
> > Terry
>
> > On Jul 15, 2010,Elry wrote:
>
> > Hi Guillaume...
> > We just gave it a try this morning and got the following error:
> > Incorrect format in the definition file (ARERR 402). This is when the
> > ARS Service tries to start - this ouput occurs in the arrerror.log
> > Looks like ARMonitor shuts it down with a ARERR 33 AND ARERR 32.
> > Anyone familiar with this 
> > On Jul 15, 10:58 am, Guillaume Rheault  wrote:
> > > Elry,
>
> > > I believe option A is the best, because you will get all the data from
> production on your development and test environments. This is a huge plus.
> > > There are a few things that you would need to change once the database
> is overwritten, such as updating the ARS and ITSM licenses assigend to users
> (assuming your fixed and floating counts are different from production to
> dev and UAT), and disabling the outgoing mailbox from your dev and UAT
> environments, to make sure no email goes out accidentally.
>
> > > Keep in mind that BMC (well really the old Remedy) architected ARS from
> its inception do perform this very task, so it's definitely doable. There
> were some bugs in older ARS versions where the server references were
> hardcoded, but this is not the case with latest versions (i.e. 7.x and 6.3,
> I believe).
>
> > > You may find some sporadic server references in entries in configuration
>  forms in ITSM, but BMC is working towards making sure there are no server
> references in the next version.
> > > It's only a matter of keeping for yourself a checklist of things to do
> after the DB overwrite.
>
> > > I suggest creating a ticket with BMC support specifying your ITSM
> version and patch, so BMC can tell you where, if any, server references are
> found in your  ITSM version.
>
> > > I think you'll find this the best option once you get going.
>
> > > Guillaume
>
> > > 
> > > From: Action Request System discussion list(ARSList)
> [arsl...@arslist.org] on behalf of Elry [elryal...@gmail.com]
> > > Sent: Thursday, July 15, 2010 8:46 AM
> > > To:arsl...@arslist.org
> > > Subject: SQL Database Replication
>
> > > Hi Folks...
>
> > > I am going to ask this question again - because I have never seen a
> > > definitive answer.
>
> > > Here is what we have:
>
> > > 1) Independent SQL Database Tier (2005).
> > > 2) ARSystem Application Tier (7.5 Patch 2).
> > > 3) Mid-tier (7.5 Patch 2).
>
> > > Environments:
>
> > > 1) Sandbox
> > > 2) Development
> > > 3) Staging
> > > 4) Production
> > > 5) Reporting/Archiving (to be deployed).
>
> > > What we need to do is the following:
>
> > > 1) Update the Staging and Development environments with data from
> > > production
> > > 2) Replicate the Production database to our new Reporting/Archiving
> > > environment.
>
> > > Options being considered:
>
> > > A) Database Replication.
> > > B) BMC Remedy Migrator.
> > > C) DSO.
>
> > > We understand and know how to us

Re: SQL Database Replication

[Elry]

Thanks Joe...

The application that we are using is not ITSM.  It is a custom
application that we have built.

All the developers were warned not to hard-code server names, but I
have never actually checked for this ( I will now).

We are not using AIE or LDAP.

I did not alter the ar.cfg file - shoud we try starting it up with the
ar.cfg adapted to look like the original?



On Jul 15, 11:44 am, Joe DeSouza  wrote:
> Elry,
>
> One of the reasons answers differ and vary is the configuration. All depends 
> on
> what applications you are using. Does the application have configuration
> data that hard codes server names like AIE would in its configuration. Some
> applications store some environment specific information like LDAP server 
> names
> and login credentials. Then there are odd cases where under certain conditions
> you get server names or IP Addresses of the server hardcoded into workflow 
> such
> as table fields. Sometimes you need to consider looking up the meta data and
> make sure you do not have hard coded server name references in workflow.
>
> So for the most part, yes a simple backup and restore of the database works
> directly unless you need to tweak some of the application or configuration 
> data
> and meta data to remove hard coded or wrong server references. Also if you
> choose to replicate the ar.cfg file, make sure you point that file to the 
> right
> database server, or you might end up having a test server point to 
> production...
>
> Joe
>
> 
> From: Elry 
> To: arsl...@arslist.org
> Sent: Thu, July 15, 2010 8:46:57 AM
> Subject: SQL Database Replication
>
> Hi Folks...
>
> I am going to ask this question again - because I have never seen a definitive
> answer.
>
> Here is what we have:
>
> 1) Independent SQL Database Tier (2005).
> 2) ARSystem Application Tier (7.5 Patch 2).
> 3) Mid-tier (7.5 Patch 2).
>
> Environments:
>
> 1) Sandbox
> 2) Development
> 3) Staging
> 4) Production
> 5) Reporting/Archiving (to be deployed).
>
> What we need to do is the following:
>
> 1) Update the Staging and Development environments with data from production
> 2) Replicate the Production database to our new Reporting/Archiving 
> environment.
>
> Options being considered:
>
> A) Database Replication.
> B) BMC Remedy Migrator.
> C) DSO.
>
> We understand and know how to use options B) and C).  We are looking
> for feedback from anyone who is successfully using option A). Specifically...
>
> 1) What type of replication.
> 2) Are there configuration paramaters that are retained at the database level
> that need to be changed.
> 3) Are there any considerations for ar.cfg.
>
> I have never seen a white paper on database replication ( I understand that 
> this
> method is unsupported).
>
> Any feedback would be greatly appreciated.
>
> ___­
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> attend wwrug10www.wwrug.comARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

Re: SQL Database Replication

[Elry]

Thanks Terry...

Just spoke to the DBA - what he actually did was:

1) Made a backup copy of Production.
2) Restored the backup copy to the Sandbox.

This appears to be quite different from replication - could this be
the source of the problem.


On Jul 15, 11:30 am, Terry Bootsma  wrote:
> ** Elry:
> One thing to consider is that when you replicate from server A to server B, 
> the replicated database may not be in an "active" state.   You may have to 
> take it out of this state to actually start Remedy and have it connect to 
> it...  have you tried this?
> Terry
>
> On Jul 15, 2010,Elry wrote:
>
> Hi Guillaume...
> We just gave it a try this morning and got the following error:
> Incorrect format in the definition file (ARERR 402). This is when the
> ARS Service tries to start - this ouput occurs in the arrerror.log
> Looks like ARMonitor shuts it down with a ARERR 33 AND ARERR 32.
> Anyone familiar with this ....
> On Jul 15, 10:58 am, Guillaume Rheault  wrote:
> > Elry,
> >
> > I believe option A is the best, because you will get all the data from 
> > production on your development and test environments. This is a huge plus.
> > There are a few things that you would need to change once the database is 
> > overwritten, such as updating the ARS and ITSM licenses assigend to users 
> > (assuming your fixed and floating counts are different from production to 
> > dev and UAT), and disabling the outgoing mailbox from your dev and UAT 
> > environments, to make sure no email goes out accidentally.
> >
> > Keep in mind that BMC (well really the old Remedy) architected ARS from its 
> > inception do perform this very task, so it's definitely doable. There were 
> > some bugs in older ARS versions where the server references were hardcoded, 
> > but this is not the case with latest versions (i.e. 7.x and 6.3, I believe).
> >
> > You may find some sporadic server references in entries in configuration  
> > forms in ITSM, but BMC is working towards making sure there are no server 
> > references in the next version.
> > It's only a matter of keeping for yourself a checklist of things to do 
> > after the DB overwrite.
> >
> > I suggest creating a ticket with BMC support specifying your ITSM version 
> > and patch, so BMC can tell you where, if any, server references are found 
> > in your  ITSM version.
> >
> > I think you'll find this the best option once you get going.
> >
> > Guillaume
> >
> > 
> > From: Action Request System discussion list(ARSList) [arsl...@arslist.org] 
> > on behalf of Elry [elryal...@gmail.com]
> > Sent: Thursday, July 15, 2010 8:46 AM
> > To:arsl...@arslist.org
> > Subject: SQL Database Replication
> >
> > Hi Folks...
> >
> > I am going to ask this question again - because I have never seen a
> > definitive answer.
> >
> > Here is what we have:
> >
> > 1) Independent SQL Database Tier (2005).
> > 2) ARSystem Application Tier (7.5 Patch 2).
> > 3) Mid-tier (7.5 Patch 2).
> >
> > Environments:
> >
> > 1) Sandbox
> > 2) Development
> > 3) Staging
> > 4) Production
> > 5) Reporting/Archiving (to be deployed).
> >
> > What we need to do is the following:
> >
> > 1) Update the Staging and Development environments with data from
> > production
> > 2) Replicate the Production database to our new Reporting/Archiving
> > environment.
> >
> > Options being considered:
> >
> > A) Database Replication.
> > B) BMC Remedy Migrator.
> > C) DSO.
> >
> > We understand and know how to use options B) and C).  We are looking
> > for feedback from anyone who is successfully using option A).
> > Specifically...
> >
> > 1) What type of replication.
> > 2) Are there configuration paramaters that are retained at the
> > database level that need to be changed.
> > 3) Are there any considerations for ar.cfg.
> >
> > I have never seen a white paper on database replication ( I understand
> > that this method is unsupported).
> >
> > Any feedback would be greatly appreciated.
> >
> > ___­
> > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> > attend wwrug10www.wwrug.comARSlist:"Where the Answers Are"
> >
> > ___­
> > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> > attend wwrug10www.wwrug.comARSlist:"Where the Answers Are"
> ___
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> attend wwrug10www.wwrug.comARSlist: "Where the Answers Are"
>
> _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

Re: Automate Report from Table

[Elry]

Scratch that...

I think you are trying to right click on a table field to create a
report and record it in a macro.

I don't think that think this is supported.


On Jul 15, 11:21 am, Elry  wrote:
> Hey Mark...
>
> I am assuming that you are doing the following with the macro:
>
> 1) Turn on macro recording.
> 2) Open the form in search mode.
> 3) Define a Query.
> 4) Select Menu:Tools/ Reporting
> 5) Select New Style
> 6) Select Fields and set parameters.
> 7) Preview the report.
> 8) Stop Recording and Name Macro.
> 9) Close all windows.
> 10) Test Macro
>
> This should work - just tried it...
>
> Now you can use the Active link attached to a button to a run macro
> action.
>
> The better alternative to a run macro action - would be the Open
> Window command (for running a report).
>
> Hope this helps.
>
> On Jul 15, 11:06 am, "Brittain, Mark"  wrote:
>
>
>
>
>
> > Hi All,
>
> > I have a form called Incident Management. On the form contains a table 
> > called Notes. In the Notes form is the Request ID for the parent Incident 
> > Management form. I would like to run a report directly from the table using 
> > a button/active link but cannot seem to get it to work with a macro.
>
> > The manual steps are:
> > Right click over the table, and select all
> > Right click over the table and select report
> > Select the report
> > Select Print Preview
> > Close the Report Styles window.
>
> > Any suggestions greatly appreciated.
>
> > Mark
>
> > 
> > Mark Brittain
> > Remedy Developer
> > NaviSite
> > mbritt...@navisite.com<mailto:mbritt...@navisite.com>
> > (315) 453-2912 x5335 (Phone)
> > (315) 317.2897 (Cell)
>
> >   
> > This e-mail is the property of NaviSite, Inc. It is intended only for the 
> > person or entity to which it is addressed and may contain information that 
> > is privileged, confidential, or otherwise protected from disclosure. 
> > Distribution or copying of this e-mail, or the information contained 
> > herein, to anyone other than the intended recipient is prohibited.
>
> > ___­­
> > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> > attend wwrug10www.wwrug.comARSlist:"Where the Answers Are"
>
> ___­
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> attend wwrug10www.wwrug.comARSlist: "Where the Answers Are"- Hide quoted text 
> -
>
> - Show quoted text -

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

Re: SQL Database Replication

[Elry]

Hi Guillaume...

We just gave it a try this morning and got the following error:

Incorrect format in the definition file (ARERR 402).  This is when the
ARS Service tries to start - this ouput occurs in the arrerror.log
Looks like ARMonitor shuts it down with a ARERR 33 AND ARERR 32.

Anyone familiar with this 


On Jul 15, 10:58 am, Guillaume Rheault  wrote:
> Elry,
>
> I believe option A is the best, because you will get all the data from 
> production on your development and test environments. This is a huge plus.
> There are a few things that you would need to change once the database is 
> overwritten, such as updating the ARS and ITSM licenses assigend to users 
> (assuming your fixed and floating counts are different from production to dev 
> and UAT), and disabling the outgoing mailbox from your dev and UAT 
> environments, to make sure no email goes out accidentally.
>
> Keep in mind that BMC (well really the old Remedy) architected ARS from its 
> inception do perform this very task, so it's definitely doable. There were 
> some bugs in older ARS versions where the server references were hardcoded, 
> but this is not the case with latest versions (i.e. 7.x and 6.3, I believe).
>
> You may find some sporadic server references in entries in configuration  
> forms in ITSM, but BMC is working towards making sure there are no server 
> references in the next version.
> It's only a matter of keeping for yourself a checklist of things to do after 
> the DB overwrite.
>
> I suggest creating a ticket with BMC support specifying your ITSM version and 
> patch, so BMC can tell you where, if any, server references are found in your 
>  ITSM version.
>
> I think you'll find this the best option once you get going.
>
> Guillaume
>
> ____
> From: Action Request System discussion list(ARSList) [arsl...@arslist.org] on 
> behalf of Elry [elryal...@gmail.com]
> Sent: Thursday, July 15, 2010 8:46 AM
> To: arsl...@arslist.org
> Subject: SQL Database Replication
>
> Hi Folks...
>
> I am going to ask this question again - because I have never seen a
> definitive answer.
>
> Here is what we have:
>
> 1) Independent SQL Database Tier (2005).
> 2) ARSystem Application Tier (7.5 Patch 2).
> 3) Mid-tier (7.5 Patch 2).
>
> Environments:
>
> 1) Sandbox
> 2) Development
> 3) Staging
> 4) Production
> 5) Reporting/Archiving (to be deployed).
>
> What we need to do is the following:
>
> 1) Update the Staging and Development environments with data from
> production
> 2) Replicate the Production database to our new Reporting/Archiving
> environment.
>
> Options being considered:
>
> A) Database Replication.
> B) BMC Remedy Migrator.
> C) DSO.
>
> We understand and know how to use options B) and C).  We are looking
> for feedback from anyone who is successfully using option A).
> Specifically...
>
> 1) What type of replication.
> 2) Are there configuration paramaters that are retained at the
> database level that need to be changed.
> 3) Are there any considerations for ar.cfg.
>
> I have never seen a white paper on database replication ( I understand
> that this method is unsupported).
>
> Any feedback would be greatly appreciated.
>
> ___­
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> attend wwrug10www.wwrug.comARSlist: "Where the Answers Are"
>
> ___­
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> attend wwrug10www.wwrug.comARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

Re: Automate Report from Table

[Elry]

Hey Mark...

I am assuming that you are doing the following with the macro:

1) Turn on macro recording.
2) Open the form in search mode.
3) Define a Query.
4) Select Menu:Tools/ Reporting
5) Select New Style
6) Select Fields and set parameters.
7) Preview the report.
8) Stop Recording and Name Macro.
9) Close all windows.
10) Test Macro

This should work - just tried it...

Now you can use the Active link attached to a button to a run macro
action.

The better alternative to a run macro action - would be the Open
Window command (for running a report).

Hope this helps.

On Jul 15, 11:06 am, "Brittain, Mark"  wrote:
> Hi All,
>
> I have a form called Incident Management. On the form contains a table called 
> Notes. In the Notes form is the Request ID for the parent Incident Management 
> form. I would like to run a report directly from the table using a 
> button/active link but cannot seem to get it to work with a macro.
>
> The manual steps are:
> Right click over the table, and select all
> Right click over the table and select report
> Select the report
> Select Print Preview
> Close the Report Styles window.
>
> Any suggestions greatly appreciated.
>
> Mark
>
> 
> Mark Brittain
> Remedy Developer
> NaviSite
> mbritt...@navisite.com
> (315) 453-2912 x5335 (Phone)
> (315) 317.2897 (Cell)
>
>   
> This e-mail is the property of NaviSite, Inc. It is intended only for the 
> person or entity to which it is addressed and may contain information that is 
> privileged, confidential, or otherwise protected from disclosure. 
> Distribution or copying of this e-mail, or the information contained herein, 
> to anyone other than the intended recipient is prohibited.
>
> ___­
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> attend wwrug10www.wwrug.comARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

Re: SQL Database Replication

[Elry]

Hi Fred...

It would be a one time copy that is repeatable on a 3-6 month cycle
for Staging and Dev.

We would just want to be able to dump real data to make sure that
nothing is missed in Q&A for Testing.

However for reporting it would be a constant sync for about 12 metric
collection tables that have been developed (Migrator will work for
this).



On Jul 15, 9:50 am, "Grooms, Frederick W" 
wrote:
> Is this a one-time copy (or maybe like once a quarter type of thing), or a 
> constant sync.
>
> Fred
>
>
>
> -Original Message-
> From: Action Request System discussion list(ARSList) 
> [mailto:arsl...@arslist.org] On Behalf Of Elry
> Sent: Thursday, July 15, 2010 7:47 AM
> To: arsl...@arslist.org
> Subject: SQL Database Replication
>
> Hi Folks...
>
> I am going to ask this question again - because I have never seen a
> definitive answer.
>
> Here is what we have:
>
> 1) Independent SQL Database Tier (2005).
> 2) ARSystem Application Tier (7.5 Patch 2).
> 3) Mid-tier (7.5 Patch 2).
>
> Environments:
>
> 1) Sandbox
> 2) Development
> 3) Staging
> 4) Production
> 5) Reporting/Archiving (to be deployed).
>
> What we need to do is the following:
>
> 1) Update the Staging and Development environments with data from
> production
> 2) Replicate the Production database to our new Reporting/Archiving
> environment.
>
> Options being considered:
>
> A) Database Replication.
> B) BMC Remedy Migrator.
> C) DSO.
>
> We understand and know how to use options B) and C).  We are looking
> for feedback from anyone who is successfully using option A).
> Specifically...
>
> 1) What type of replication.
> 2) Are there configuration paramaters that are retained at the
> database level that need to be changed.
> 3) Are there any considerations for ar.cfg.
>
> I have never seen a white paper on database replication ( I understand
> that this method is unsupported).
>
> Any feedback would be greatly appreciated.
>
> ___­
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> attend wwrug10www.wwrug.comARSlist: "Where the Answers Are"- Hide quoted text 
> -
>
> - Show quoted text -

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

SQL Database Replication

[Elry]

Hi Folks...

I am going to ask this question again - because I have never seen a
definitive answer.

Here is what we have:

1) Independent SQL Database Tier (2005).
2) ARSystem Application Tier (7.5 Patch 2).
3) Mid-tier (7.5 Patch 2).

Environments:

1) Sandbox
2) Development
3) Staging
4) Production
5) Reporting/Archiving (to be deployed).

What we need to do is the following:

1) Update the Staging and Development environments with data from
production
2) Replicate the Production database to our new Reporting/Archiving
environment.

Options being considered:

A) Database Replication.
B) BMC Remedy Migrator.
C) DSO.

We understand and know how to use options B) and C).  We are looking
for feedback from anyone who is successfully using option A).
Specifically...

1) What type of replication.
2) Are there configuration paramaters that are retained at the
database level that need to be changed.
3) Are there any considerations for ar.cfg.

I have never seen a white paper on database replication ( I understand
that this method is unsupported).

Any feedback would be greatly appreciated.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

Re: ARLABEL UTILITY AND ARTEXT UTILITY FOR 7.5

[Elry]

Ok - looks like it was a silly question:

Turns out that all the utilities are automatically installed in the
same
directory as the AR System server; therefore, if you have the product
installed you have all the utilities.


On Jun 3, 10:41 am, Elry  wrote:
> Hi Folks...
>
> I am looking for the artext/arlable utility for the 7.5 API.  Tried
> using the 6.0 utility - it can export, but the import fails miserably.
>
> Can't seem to find it in the BMC Community.
>
> Maybe I am just not conducting my search properly.
>
> I would hate to have translate forms manually.
>
> Anyone know where to find this?
>
> ___
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> attend wwrug10www.wwrug.comARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

ARLABEL UTILITY AND ARTEXT UTILITY FOR 7.5

[Elry]

Hi Folks...

I am looking for the artext/arlable utility for the 7.5 API.  Tried
using the 6.0 utility - it can export, but the import fails miserably.

Can't seem to find it in the BMC Community.

Maybe I am just not conducting my search properly.

I would hate to have translate forms manually.

Anyone know where to find this?

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

Re: Top Positions SSO Solution

[Elry]

Thanks Danny...

I will be in contact with your company shortly re: assembling our team
for a product Demo and Q&A.

Cheers!


On Mar 30, 12:11 pm, Danny Kellett
 wrote:
> Konrad,
>
> That's incorrect. We do not use the authentication string any more as many
> of the BMC products have bugs in them which prevent SSO being implemented
> correctly and safely. I can provide an official list of SW numbers if you
> wish, where the authentication string is not passed correctly. To name a
> few, Crystal Reports integration and Flashboards within the Windows User
> Tool. So good luck when you find your first customer who wants to use
> reports on the web or flashboards in the WUT.
>
> Sean, et al,
>
> Java System Solutions has been working with BMC as an SSO solution provider
> for four years now. We have partners that support and sell our product such
> as BMC themselves, Materna in Germany and Denmark, at which this month they
> have published an article about our solution in their magazine (including an
> embarrassing picture of John Baker and myself, I'm only 34 years old
> honest!), Comfort in Poland from which Konrad used to work for, SoftwareOne
> and Zones. So we have customers which are Banks where security has become an
> priority and we were happy to modify our product as required, in partnership
> with these customers.
>
> So I can confidently let you know, and provide references, from customers
> and partners who can verify our security.
>
> In version 2.1, for the WUT SSO, we did store a password in the registry
> encrypted by AEShttp://en.wikipedia.org/wiki/Advanced_Encryption_Standard
> This was seen as secure enough for two large American banks and one Polish
> Bank.
> In version 3.0, due for release in April, we have added another layer of
> encryption for the WUT where the password uses rotating keys very similar 
> tohttp://www.freshpatents.com/Rotation-of-keys-during-encryption-decryp...
> 20061214ptan20060280298.php
> Again, all this is passed in the password field instead of the
> authentication field, and thus is again encrypted by BMCs own DES encryption
> over the wire.
>
> I believe with all that above, we are confidently happy with our product and
> so could many BMC representatives and partners alike.
>
> Elry,
>
> This is turning into a bit of an advert, and for that I apologise Dan/List,
> but you can find out more information fromwww.javasystemsolutions.comor
> send me an email off the list dkell...@javasystemsolutions.com
>
> Kind regards
> Danny
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
>
> [mailto:arsl...@arslist.org] On Behalf Of Konrad Banasiak
> Sent: 30 March 2010 16:17
> To: arsl...@arslist.org
> Subject: Re: Top Positions SSO Solution
>
> Sean,
>
> Java System's plugin use authentication password saved in the windows
> register on all workstations to authenticate users through the RUT.
> All users have the same password. In my opinion it is not very save method.
>
> Mid-tier use the ARSAPI to communicate with ARS so communication between mt
> and ars is crypted.
> Of course we must believe that crypted method between ars an mt used by BMC
> is save.
>
> In this document you can read about ars 
> security.http://documents.bmc.com/supportu/documents/22/39/92239/92239.pdf
>
> Cheers
>
> Konrad
>
> TopPositions
> Really only one secure Plugin SSO for BM Remedy AR System.
> Http://www.remedy-sso.com
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:arsl...@arslist.org] On Behalf Of Elry
> Sent: Tuesday, March 30, 2010 4:54 PM
> To: arsl...@arslist.org
> Subject: Re: Top Positions SSO Solution
>
> Thanks for all the responses...
>
> Konrad - quick question:  Seems like you are saying that by signing on
> through the WUT - there is a secure protocol that is followed when
> using java system's  plugin.
>
> Are there any issues when trying to do SSO through the Mid-Tier?
>
> Not that I perceive this as an issue for us, since we are primarily
> focused on the WUT.
>
> On Mar 30, 10:35 am, Konrad Banasiak  wrote:
> > Sean,
>
> > You have right. I agree with you.
> > I will try to explain you how Plugin SSO works from TopPositions.
>
> > If you connect to ARS through the Mid-Tier. Md-Tier is authenticating in
> the ARS through the special password.
> > Of course the mid-tier-ip is on the whitelist (see the Installation guide
> page 15, MidTier-IP parameter).
>
> > But if client connect to ARS through the Windows client you have the
> followed process:
> > 1. Remedy User authenticate user in the special Authenticati

Re: Top Positions SSO Solution

[Elry]

Thanks for all the responses...

Konrad - quick question:  Seems like you are saying that by signing on
through the WUT - there is a secure protocol that is followed when
using java system's  plugin.

Are there any issues when trying to do SSO through the Mid-Tier?

Not that I perceive this as an issue for us, since we are primarily
focused on the WUT.



On Mar 30, 10:35 am, Konrad Banasiak  wrote:
> Sean,
>
> You have right. I agree with you.
> I will try to explain you how Plugin SSO works from TopPositions.
>
> If you connect to ARS through the Mid-Tier. Md-Tier is authenticating in the 
> ARS through the special password.
> Of course the mid-tier-ip is on the whitelist (see the Installation guide 
> page 15, MidTier-IP parameter).
>
> But if client connect to ARS through the Windows client you have the followed 
> process:
> 1. Remedy User authenticate user in the special Authentication Service 
> through the NTLM negotiation(NTLMv2) in the Domain Controler.
> 2. If user is confirmed the Service return generated token to the Remedy 
> User. (Token is unique for every User)
> 3. Remedy User passed into the "Authentication" field in area this token to 
> ARESSO.
> 4. AREA SSO confirm in the Authentication Service this token, If token is 
> correct user is authenticate, if no user is no authenticate. Of course the 
> Authentication Service confirm client IP address. And the token expired if is 
> not use to long time.
>
> Cheers
>
> Konrad
>
> TopPositions
> Really only one secure Plugin SSO for BM Remedy AR System.
> Http://www.remedy-sso.com
>
> -Original Message-
> From: Action Request System discussion list(ARSList) 
> [mailto:arsl...@arslist.org] On Behalf Of Garrison, Sean (Norcross)
> Sent: Tuesday, March 30, 2010 4:01 PM
> To: arsl...@arslist.org
> Subject: Re: Top Positions SSO Solution
>
> Without being too technical I don't really trust an ARS SSO integration that 
> much.  In order to build an sso you have to follow a process:
>
> 1.  Modify the authentication to the mid-tier to check the users credentials.
> 2.  If the user is valid allow them to log into remedy
> 3.  If the user is from mid-tier and they have valid credentials bypass the 
> AREA authentication and let them in.
>
> It is at step 3 where I believe the security hole lies in an SSO 
> implementation.  Granted there is some security but it is relatively weak.  
> Typically they ask you to enter in a list of ip addresses and a password of 
> some type.  This password is usually passed into the "Authentication" field 
> in area.  The IP address is a "whitelist" to tell area whether or not this is 
> a mid-tier ip.  So let's say you added your ip address to the whitelist that 
> you configure for the sso implementation.  Using the User tool you enter in 
> the mid-tier password into the authentication field and put in your username 
> leaving the password field blank.  My guess is that you would log right into 
> ars with no problems.  Go further and you could probably spoof one of the 
> mid-tier ip addresses so that ars thinks your ip address is one of the 
> mid-tiers you could do the same thing with entering in no password just the 
> mid-tier password.  I don't know what java system solutions does for this 
> issue nor what the remedy-sso does.  But in both flowcharts you see a little 
> arrow going from mid-tier to ARS.  Before implementing either SSO I would 
> recommend validating with the vendor how secure that data is that is passed 
> between mid-tier and ars and your comfort level with this type of security.  
> The only reason I know this is because I have tried to build an SSO solution 
> before.
>
> Thanks,
>
> Sean
>
> -Original Message-
> From: Action Request System discussion list(ARSList) 
> [mailto:arsl...@arslist.org] On Behalf Of Shellman, David
> Sent: Tuesday, March 30, 2010 8:25 AM
> To: arsl...@arslist.org
> Subject: Re: Top Positions SSO Solution
>
> Top Positions is spamming every email address that they can associate with an 
> Remedy Admin.  They hit a new email address of mine that was added to 
> thewww.wwrug.comwebsite a couple of weeks ago.
> Dave
> -
> dave.shell...@tycoelectronics.com
> (Wireless)
>
> - Original Message -
> From: Action Request System discussion list(ARSList)
> ___
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> attend wwrug10www.wwrug.comARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

Re: Top Positions SSO Solution

[Elry]

Addendum:

Just visited their website.  Right...

Just visited another website: http://www.javasystemsolutions.com.
This is more like it.

I think I will stick with exploring a solution with: 
http://www.javasystemsolutions.com

The term "caveat emptor" comes to mind.

Still interested in hearing other feedback.


On Mar 30, 8:01 am, Elry  wrote:
> Hi Guys...
>
> Got an email from a company called Top Positions.
>
> http://www.remedy-sso.com/
>
> They are offering a SSO solution out of the box for Remedy products.
>
> Has anyone heard of them or tried their product???
>
> ___
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> attend wwrug10www.wwrug.comARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

Top Positions SSO Solution

[Elry]

Hi Guys...

Got an email from a company called Top Positions.

http://www.remedy-sso.com/

They are offering a SSO solution out of the box for Remedy products.

Has anyone heard of them or tried their product???

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

Re: Archive data to file - ARX

[Elry]

Hi Anand...

I have built something like this for a client - it utilizes the
runmacro utility that was suggested above.  See Page 215-220 of the
Integration Guide.

You would do something like this:
-
1) Either hard code or create  CLI statement "on the fly".  In my case
I built it on the fly and put it in a field on a form:

-o "C:\ARS_WLV_DEV\AR_IMPORT\DATA\StagingPrep
\INAC_CFG_DATA_CATG_Generic_Catalog.ARX" -x "DEVSERVER" -U "George" -P
"password" -f "SDS:CFG:Generic_Catalog" -t "ARX"

2) Run the Process:

C:\ARS_WLV_DEV\AR_EXPORT\EXECUTE\runmacro.exe $CLI Statement$
-
Syntax:
-
runmacro [-h homeDir] [-d macroDir]
[{-x serverName} ...] { -e | -i } macroName
[-p parameter=value ...] [-U userName] [-P password]
[-Q internalQualificationFormat]
[-q clientToolQualificationFormat]
[-Z internalFormatQualificationFileName]
[-z clientToolFormatQualificationFileName]
[{-w | -W } externalAuthenticationString] [-a portNumber]
[-O]
-

Good Luck.

On Feb 3, 7:39 am, "Nair, Rajesh IN BOM SISL" 
wrote:
> Dear Anand
> Please check if this will help you Create a batch file which will run the 
> macros which in turn will have all the field required to be backup.
> Write a Escalation with RUN Process $PROCESS$ @:  file/runmacro path>
>
> Regards
> Rajesh Nair
>
> 
>
> 
> From: Action Request System discussion list(ARSList) 
> [mailto:arsl...@arslist.org] On Behalf Of anand.di...@wipro.com
> Sent: Tuesday, February 02, 2010 6:45 PM
> To: arsl...@arslist.org
> Subject: Archive data to file - ARX
>
> **
> Hi list,
>
> I have a requirement,
> Where at every specific time period, an escalation should run on a form and 
> archive old data (of particular time period), to an arx file and save to the 
> disc.
> Please let me if anybody has idea.
>
> THANKS.
> Anand
>
> Please do not print this email unless it is absolutely necessary.
>
> The information contained in this electronic message and any attachments to 
> this message are intended for the exclusive use of the addressee(s) and may 
> contain proprietary, confidential or privileged information. If you are not 
> the intended recipient, you should not disseminate, distribute or copy this 
> e-mail. Please notify the sender immediately and destroy all copies of this 
> message and any attachments.
>
> WARNING: Computer viruses can be transmitted via email. The recipient should 
> check this email and any attachments for the presence of viruses. The company 
> accepts no liability for any damage caused by any virus transmitted by this 
> email.
>
> www.wipro.com
>
> _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_
> 
> Important notice: This e-mail and any attachment there to contains corporate 
> proprietary information. If you have received it by mistake, please notify us 
> immediately by reply e-mail and delete this e-mail and its attachments from 
> your system.
> Thank You.
>
> ___
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Making sense of user.log

[Elry]

Hi Robert...

I agree the login/logout lines can be confusing, I am not sure why
there are multiple login/logout lines.
Maybe one of the other listers can shed some light on this.

Try the Optimizing and Troubleshooting Guide (page 64-65).
===

The line starts with a tag that identifies it as a user log entry
(), followed by
the thread ID, RPC ID, queue, and Client RPC information. Next, the
user is
identified, followed by the time stamp. The entry detail starts with
the type of
license used (READ, FIXED, or FLOAT). After the license type is the
operation that
was performed.

If the type of license is FLOAT, additional information reports the
number of
licenses in use at that time and the number that are available. Also
included is the
name of the user performing the operation.

On Feb 2, 8:41 am, "Martin, Robert"  wrote:
> Dear List,
> We are running server "User" logs to see who logs in to the system and for 
> how long.  When we look at the log file we see that there are several 
> "LOGOUT"s and "LOGIN"s within the main session.
> EG in this simplified sequence it seems obvious that "blandrl" logged in at 
> 7:03 and out at 7:13.   But it also looks like he logged out and back in 
> again twice, then logged out twice at the end.
>  /* Fri Jan 29 2010 07:03:28.0700 */         LOGIN          
> blandrl
>  /* Fri Jan 29 2010 07:03:28.0726 */         LOGOUT         
> blandrl
>  /* Fri Jan 29 2010 07:03:28.1907 */         LOGIN          
> blandrl
>  /* Fri Jan 29 2010 07:03:28.1934 */  FIXED  GRANT WRITE    
> blandrl
>  /* Fri Jan 29 2010 07:03:28.9864 */         LOGIN          
> blandrl
>  /* Fri Jan 29 2010 07:03:28.9932 */         LOGOUT         
> blandrl
>  /* Fri Jan 29 2010 07:03:38.2373 */         LOGIN          
> blandrl
>  /* Fri Jan 29 2010 07:13:01.3085 */         LOGOUT         
> blandrl
>  /* Fri Jan 29 2010 07:13:01.3231 */  FIXED  RELEASE        
> blandrl
>  /* Fri Jan 29 2010 07:13:01.3232 */         LOGOUT         
> blandrl
> Any idea what all these extra "LOGOUT"s and "LOGIN"s mean?
> Dwayne Martin
> James Madison University
> (ARS 7.1 P3, RH Linux ARS Server)
>
> ___
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

ARERR 1904 Invalid TLV Record

[Elry]

Hi Folks...

Got the following error when trying to run a Crystal Report using the
Open Window active link action:


An error occurred while generating the Crystal report: 0x80043ae3 -
Invalid TLV record. (ARERR 1904)


We discovered that all our Crystal Reports that were embedded in the
Form "Report"  had a File Size of  OKB.

To solve this you can do one of the following:

1) Re-attach the reports.
2) Delete the records and re-import from a backup *ARX.

Just thought I would share this - searched everywhere and could not
find any information on this specific Crystal Report error message.

Cheers!

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

ARS Server & Client Patch 3 Released

[Elry]

Hi Folks...

We are scheduled to go live this Monday with ARS Server 7.5 Patch 2.

Just wondering if anyone has tried Patch 3 yet?

If you have tried Patch 3 - is it stable?

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Crystal Reports: Passing Parameters

[Elry]

Hi Folks...

I though I would post this - for others who might find themselves in a
similar position.

Here is quick and easy way to pass parameters to Crystal reports.

1) Create your own console and add the following fields:
 - Server Name
 - Form Name
 - Default View
 - Report Name
 - Query
 - Selected IDs
2) Create your Crystal Report and store it in the Remedy form called
Report
3) Create an active link that executes an Open Window Action.
4) Use Sample Data in the Open Window Action and use the fields shown
in item 1) as variables that are passed to Crystal.
5) In the active link qualification use the External command to pass
the Query field value to Crystal Reports.
6) In the User Tool create queries that you need by using the Advanced
Query Line - then copying this qualification to the Query field.
7) For this to work - make sure that you select Query Override in the
Open Window Command.

Whatever query you pass will act as though you selected the form and
placed the query in the Advanced Query line...

I tried this and it appears to work ...

Note:  I am using the Developer Studio to do this.  This feature was
available from 6.3 and up, but it was a bit more complex to execute.



On Sep 17, 6:55 am, Elry  wrote:
> Hi Rod...
>
> Thanks buddy.
>
> We will try using subreports.
>
> The only other technique I have read about is to create a table that
> stores the selected report number - then use a join to generate the
> desired results.  I was looking for a cleaner way to do this...and it
> looks like subreports might do it...
>
> Thanks Again.
>
> On Sep 16, 10:25 pm, Rod Harris  wrote:
>
>
>
> > I hope I understand what you are trying to do.
>
> > As far as I know you can't pass parameters to crystal as such. You can
> > allow the crystal report to ask for parameters and you can control the
> > report by specifying the record selection query in the open window
> > action.This is fine in most cases. There are some occasions where this
> > is not sufficient.
>
> > One feature I use to simulate passing parameters from Remedy to
> > Crystal is the use of subreports. If you place your report inside
> > another report as a subreport, parameters can be passed to the
> > subreport from the wrapper report. These paramaters are typically used
> > to build the record selection query. Using this technique you can get
> > a lot of control of your report from Remedy.
>
> > In simple terms you can call a crystal report with a qualification
> > that acts as a parameter. You then use this qualification to construct
> > the real report qualification inside the subreport. In the subreport
> > you have access to the paramater as well as a record selection derived
> > from it. Without doing something like this you can have a tough time
> > trying to work out what the report is trying to show from the results
> > returned by its qualification.
>
> > I hope this makes some sense to you. I'm assuming that you know about
> > crystal subreports. If you don't it's worth learning about them as
> > they are a very useful feature.
>
> > Rod
>
> > On 17/09/2009, Elry  wrote:
>
> > > Hi Folks..
>
> > > Environment:
>
> > > SQL Server 2005
> > > Windows Server 2003
> > > ARS 7.5.2
> > > Crystal Reports XI
>
> > > Issue:
>
> > > How do you pass a a simple parameter like Request ID to a Crystal
> > > report to ensure that you can generate a fixed report from a Dialog
> > > form.
>
> > > Any ideas.
>
> > > ___
> > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> > > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
>
> > ___
> > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
>
> ___
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Crystal Reports: Passing Parameters

[Elry]

Hi Rod...

Thanks buddy.

We will try using subreports.

The only other technique I have read about is to create a table that
stores the selected report number - then use a join to generate the
desired results.  I was looking for a cleaner way to do this...and it
looks like subreports might do it...

Thanks Again.


On Sep 16, 10:25 pm, Rod Harris  wrote:
> I hope I understand what you are trying to do.
>
> As far as I know you can't pass parameters to crystal as such. You can
> allow the crystal report to ask for parameters and you can control the
> report by specifying the record selection query in the open window
> action.This is fine in most cases. There are some occasions where this
> is not sufficient.
>
> One feature I use to simulate passing parameters from Remedy to
> Crystal is the use of subreports. If you place your report inside
> another report as a subreport, parameters can be passed to the
> subreport from the wrapper report. These paramaters are typically used
> to build the record selection query. Using this technique you can get
> a lot of control of your report from Remedy.
>
> In simple terms you can call a crystal report with a qualification
> that acts as a parameter. You then use this qualification to construct
> the real report qualification inside the subreport. In the subreport
> you have access to the paramater as well as a record selection derived
> from it. Without doing something like this you can have a tough time
> trying to work out what the report is trying to show from the results
> returned by its qualification.
>
> I hope this makes some sense to you. I'm assuming that you know about
> crystal subreports. If you don't it's worth learning about them as
> they are a very useful feature.
>
> Rod
>
> On 17/09/2009, Elry  wrote:
>
>
>
> > Hi Folks..
>
> > Environment:
>
> > SQL Server 2005
> > Windows Server 2003
> > ARS 7.5.2
> > Crystal Reports XI
>
> > Issue:
>
> > How do you pass a a simple parameter like Request ID to a Crystal
> > report to ensure that you can generate a fixed report from a Dialog
> > form.
>
> > Any ideas.
>
> > ___
> > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
>
> ___
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Crystal Reports: Passing Parameters

[Elry]

Hi Folks..

Environment:

SQL Server 2005
Windows Server 2003
ARS 7.5.2
Crystal Reports XI

Issue:

How do you pass a a simple parameter like Request ID to a Crystal
report to ensure that you can generate a fixed report from a Dialog
form.

Any ideas.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: generate custom reports(GUI mode) using BMC Remedy AR System

[Elry]

Hey Bud...

Try looking at flashboards.  Especially in version 7.5  (uses Adobe
Flash Technology).



On Jul 21, 3:39 am, RKVKRKVK  wrote:
> Hi,
>
> Can anyone tell me how to generate Custom Reports(GUI Mode) like HTML or any
> other format which is in GUI mode using BMC Remedy AR System.
>
> Best Regards,
> Krishna B
> --
> View this message in 
> context:http://www.nabble.com/generate-custom-reports%28GUI-mode%29-using-BMC...
> Sent from the ARS (Action Request System) mailing list archive at Nabble.com.
>
> ___
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: DEF File Manipulator

[Elry]

I agree..

The migrator is great tool for def file manipulation.  The only
drawback is that the def files gets translated into migrator format;
therefore, you would have to do a little manipulation to get it back
to regular def file format.

On Jul 15, 7:02 am, Jonas Stumph Stevnsvig
 wrote:
> It might be overkill, but I think that the Remedy Migrator package offers 
> extensive def file manipulation.
>
> Med venlig hilsen
>
> Jonas Stumph Stevnsvig
> Remedy Udvikler
> BEC Kompetence Centret
> Telefon (+45) 46 38 20 08
> Mobil   (+45) 61 56 20 08
> jonas.stumph.stevns...@bec.dk
>
> Til remedy spørgsmål: becrem...@bec.dk
>
> BEC - det fælles it-hus, der gør forskellen for finansielle virksomheder
>
> 
> Fra: Action Request System discussion list(ARSList) 
> [mailto:arsl...@arslist.org] På vegne af Frank Caruso
> Sendt: 15. juli 2009 10:41
> Til: arsl...@arslist.org
> Emne: DEF File Manipulator
>
> **
> Is there a utility that will allow me to easily remove objects from a DEF 
> file?
>
> Would like to be able to view all of the objects in a DEF file and 
> selectively remove items. I could manually edit the file but I have had 
> issues with this in the past.
>
> Thank you.
>
> Frank
> _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_
>
> ___
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Push Fields creating loop

[Elry]

Hi Akos...

That kind of push can easily loop on you...

I would suggest doing one of the following:

1) Using LastId keyword to locate the ID (providing that this is the
only creation initiated by this process).
2) Put a GUID on form A that gets pushed to form B.  Then you can fire
another filter that looks up the GUID on form B to return the form
Request ID

Hope this helps.


On Jul 15, 5:08 am, Akos Malindovszky  wrote:
> Hi all!
>
> 'm having a problem with the Push fields action in a Filter.
> I have two forms A & B. When a ticket is created on A that matches certain
> qualifications, then a new ticket is created on form B via a at Push field
> action in a filter. I want to store the request-ID of the new ticket on form
> A also, so there is a filter running on submit on B which pushes the info
> back to the matching request on A.
> My problem is that when the ID is pushed back from B to A, then A starts
> running all the filters again triggered by this modification. Is there any
> way to avoid this step. Can I push a value to a form without triggering a
> modification?
>
> Thank you in advance.
>
> best regards,
> Akos Malindovszky
> Helpdesk Administrator
> --
> View this message in 
> context:http://www.nabble.com/Push-Fields-creating-loop-tp24494356p24494356.html
> Sent from the ARS (Action Request System) mailing list archive at Nabble.com.
>
> ___
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Developer Studio 7.5 : Patch 2 - Large Forms Fail To Load

[Elry]

Hey Joe...

Made the following changes:

Memory Pool = 512 MB
Maximum Memory Pool = 1024 MB
Thread Stack Size = 3000KB

We did not see any change in behavior, but we did notice the
following:

1) We noticed the problem when we disabled a group of 8 buttons that
had a 24X24 embedded JPEG image.
2) When the buttons are enabled - the behavior stops.
3) We deleted these buttons and recreated them from scratch using the
same field IDs.
4) The forms now behave accordingly.

The log files did not show anything, but the Dev Studio Configuration
Log files shows:

1) Save Failures.
2) java.lang.IllegalArgumentException: Argument not valid.
3) Errors include SWT.error:3761, SWT.error:3766, SWT.error:3795

Looks like a BUG!


On Jul 13, 11:52 am, Joe DeSouza  wrote:
> No problem. Also make sure you have a reasonable amount of free available 
> memory on your client. Turning off applications or services that aren't being 
> used at the time of using the Dev studio may also be a good idea.
>
> JoeP
>
> ____
> From: Elry 
> To: arsl...@arslist.org
> Sent: Monday, July 13, 2009 11:08:34 AM
> Subject: Re: Developer Studio 7.5 : Patch 2 - Large Forms Fail To Load
>
> Thanks Joe - let me give that a try.
>
> On Jul 13, 10:55 am, Joe DeSouza  wrote:
>
>
>
> > Elry,
>
> > Have you tried allocating more memory to java?
>
> > Joe
>
> > 
> > From: Elry 
> > To: arsl...@arslist.org
> > Sent: Monday, July 13, 2009 7:51:53 AM
> > Subject: Developer Studio 7.5 : Patch 2 - Large Forms Fail To Load
>
> > Hi Folks ...
>
> > Environment:
>
> > Windows Server 2003
>
> > MSSQL Database 2005
>
> > BMC ARS 7.5.0 Patch 2
>
> > We are currently working with a number of forms in the Developer Studio.
>
> > We have found that forms with 330 fields or more cannot be "rendered" 
> > properly in the Developer Studio after being modified.
>
> > This means that only parts of the forms can be seen or none of the form 
> > detail can be seen.
>
> > We have rolled back the Studio to the original unpatched version - only to 
> > find that we get the same results.
>
> > The only time we can see these forms completely is when we use the 7.1 
> > Administrator Tool.
>
> > In the user tool (WUT) and the Mid-tier - these forms appear as they 
> > normally should...
>
> > Anyone else experiencing the same difficulties?
>
> ___
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Developer Studio 7.5 : Patch 2 - Large Forms Fail To Load

[Elry]

Thanks Joe - let me give that a try.


On Jul 13, 10:55 am, Joe DeSouza  wrote:
> Elry,
>
> Have you tried allocating more memory to java?
>
> Joe
>
> 
> From: Elry 
> To: arsl...@arslist.org
> Sent: Monday, July 13, 2009 7:51:53 AM
> Subject: Developer Studio 7.5 : Patch 2 - Large Forms Fail To Load
>
> Hi Folks ...
>
> Environment:
>
> Windows Server 2003
>
> MSSQL Database 2005
>
> BMC ARS 7.5.0 Patch 2
>
> We are currently working with a number of forms in the Developer Studio.
>
> We have found that forms with 330 fields or more cannot be "rendered" 
> properly in the Developer Studio after being modified.
>
> This means that only parts of the forms can be seen or none of the form 
> detail can be seen.
>
> We have rolled back the Studio to the original unpatched version - only to 
> find that we get the same results.
>
> The only time we can see these forms completely is when we use the 7.1 
> Administrator Tool.
>
> In the user tool (WUT) and the Mid-tier - these forms appear as they normally 
> should...
>
> Anyone else experiencing the same difficulties?
>
> ___
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Developer Studio 7.5 : Patch 2 - Large Forms Fail To Load

[Elry]

Hi Folks ...

Environment:

Windows Server 2003

MSSQL Database 2005

BMC ARS 7.5.0 Patch 2

We are currently working with a number of forms in the Developer
Studio.

We have found that forms with 330 fields or more cannot be "rendered"
properly in the Developer Studio after being modified.

This means that only parts of the forms can be seen or none of the
form detail can be seen.

We have rolled back the Studio to the original unpatched version -
only to find that we get the same results.

The only time we can see these forms completely is when we use the 7.1
Administrator Tool.

In the user tool (WUT) and the Mid-tier - these forms appear as they
normally should...

Anyone else experiencing the same difficulties?

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: AR System 7.5 Silent Install issues

[Elry]

Hi Rick ...

We are having issues with the 7.5 Silent Install.  We did not have any
issues with 7.1.

I am hoping with the release of Patch 2 for 7.5 - that some of these
issues will be addressed - the other alternative would be to push more
clients toward the mid-tier.

The future of the WUT looks very bleak.


On Jul 2, 8:50 am, Rick Cook  wrote:
> Just a heads-up for anyone who has this little task on their "to-do" list.
> Basically, there are three issues:
>
> 1)  It doesn't work.  It fails about 5 minutes into whatever its doing.
> 2)  There are no logs (that I can find) to tell me why it doesn't work, or
> even where it fails.
> 3)  The documentation is NO help at all in troubleshooting, and almost
> barely adequate for setup.
>
> Rick
>
> P.S.  The 7.1 AR Server silent install isn't working (for me, anyway)
> either, but at least there are logs I can send to support, and the
> documentation on how to set it up, including what each parameter is
> expecting, is pretty good.  Support can't figure out why it isn't working,
> and as yet (AFAIK), engineering hasn't either.  7.1 client installs worked
> like a charm on the first try, though!
>
> ___
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Progress Bar

[Elry]

Hi Folks...

We have created a number of custom reconciliation jobs that migrate
data from external Databases.

These jobs can take anywhere from 1 minute to 10 minutes.

We would like to create some sort of progress bar to indicate how much
time is remaining.

Has anyone tried to do this?

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Fw: transaction for parent/child changes

[Elry]

I agree...

We have had the same difficulty.

In our situation we had a CMDB for which we needed rollback capability
for updating CI/Child records.

For each table field we built a transaction storage form that stored
all the Child Record transactions until the

Parent record was committed.  Once the Parent Record was committed -
the child updates were then

sent to their respective tables and the temporary record(s) deleted.

Probably another way to do it under the 7.x paradigm - would be to
take advantage of  the "Audit" feature for

rollback (depending on the amount of fields involved).

As for when multiple people are editing a single Parent record - I
thought there was a Remedy error trapping

mechanism that let you know when you tried to commit that there were
new changes to the record that you

were editing - then it asks you if you want to save anyway???



On May 26, 12:13 pm, Robert Halstead  wrote:
> As I understand it, Remedy doesn't provide a check on who is looking/editing
> a record.  The only check Remedy does is a last modified time check.  We are
> running into this same issue when multiple people edit the same record.  We
> plan to implement a read/read-write locking feature in our own system though
> I wish remedy had the ability to lock records down.
>
> On Fri, Feb 6, 2009 at 12:17 PM, Michael Drew 
> wrote:
>
>
>
> > Depending on the nature of the data, you could perhaps use the table field
> > as your temporary storage (I.e. Set field local action to place your various
> > values into the currently selected row in the table) and do a table walk to
> > send the table values back to the actual child entry's records when you hit
> > save on the parent.
> > Michael.
>
> > --Original Message--
> > From: Brien Dieterle
> > Sender: Action Request System discussion list(ARSList)
> > To: arsl...@arslist.org
> > ReplyTo: arsl...@arslist.org
> > Sent: Feb 6, 2009 3:34 PM
> > Subject: transaction for parent/child changes
>
> > ** We've designed a form that has child requests displayed in a table list
> > field.  You can interact with these child requests through this form and
> > update them via display only fields and push-fields activelink buttons etc.
> > So the problem is you can update some things on the main form, and update
> > some children requests, close the main request and say "yes, lose changes".
> > A user might expect that the changes to the children would be reverted back
> > to what they were.
>
> > Is there any way to encapsulate the whole process of editing the primary
> > requests and N children requests into a single transaction that gets
> > committed only upon saving of the primary request?
>
> > Thanks!
>
> > Brien Dieterle
> >  __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___
>
> --
> "A fool acts, regardless; knowing well that he is wrong. The ignoramus acts
> on only what he knows, but all that he knows.
> The ignoramus may be saved, but the fool knows that he is doomed."
>
> Robert Halstead
>
> ___
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: ARS 7.5 Install Issue

[Elry]

Hi Guys...

We did an upgrade recently in our development and staging environment
much like what started this "thread".

We found that:

1) 7.5 had installations issues - that were dealt with by using patch
1.
2) Even when using patch 1 - we found that we had to do a clean
uninstall before trying again...
3) When you go to install the Clients - 7.5 has a completely different
file structure than 7.1
4) If you install the Clients based on the install defaults - you will
"wind up" with 7.1 & 7.5 on your system.
5) For a complete install of 7.5 without 7.1 - you will have to
uninstall 7.1 before installing 7.5..
6) Our Silent Install script no longer worked because 7.5 uses a
different installer with different prompts...

I am sure there are folks out there with similar insights



On May 26, 9:40 am, Howard Richter  wrote:
> Rafael,
>
> So it sounds like 7.5 should be a new install only.
>
> Howard
>
> On Tue, May 26, 2009 at 8:46 AM, Rodriguez, Rafael J x23718 <
>
>
>
> rafael.rodrig...@broadridge.com> wrote:
> > ** Howard thanks for you reply, actually there were some issues with forms
> > and workflow that did not exists. Funny that 7.0.1 Patch6 never through any
> > exemptions and now on 7.5 there were errors all over the place. The worst
> > part about it is the new suite install that only allow you to install it
> > once. THIS IS A PAIN IN THE BUTT!
>
> > I got it resolved but had to literally unistall it and clean it out
> > numerous times before it would take.
>
> > Rafael
>
> >  --
> > *From:* Action Request System discussion list(ARSList) [mailto:
> > arsl...@arslist.org] *On Behalf Of *Howard Richter
> > *Sent:* Friday, May 22, 2009 9:33 PM
> > *To:* arsl...@arslist.org
> > *Subject:* Re: ARS 7.5 Install Issue
>
> > ** Rafael,
>
> > Any issues with the database?
>
> > Howard
>
> > On Fri, May 22, 2009 at 3:30 PM, Rodriguez, Rafael J x23718 <
> > rafael.rodrig...@broadridge.com> wrote:
>
> >> **
>
> >> Hello list,
>
> >> WIN2003 Server
>
> >> SQL2005
>
> >> I was attempting to upgrade my current dev environment remedy installation
> >> from 7.0.1 patch 6 to 7.5 Patch 1 and I’m getting an error during
> >> installation. The error appears in the event log but there is no errors in
> >> the install_log:
>
> >> Event Type: Error
> >> Event Source: AR System Monitor
> >> Event Category: None
> >> Event ID: 0
> >> Date: 05/22/2009
> >> Time: 1:45:48 PM
> >> User: N/A
> >> Computer: REM4DEV
> >> Description:
> >> 390600 : Failure during SQL operation to the database (ARERR 552)
>
> >> Any ideas?
>
> >> Rafael Rodriguez*|*Manager Remedy/Mid-Tier Enterprise*|*Broadridge
> >> Financial Solutions
>
> >> 2 Journal Square Plaza*|*Jersey City, NJ 07306*|* 201.714.3718 p
>
> >> This message and any attachments are intended only for the use of the 
> >> addressee and
> >> may contain information that is privileged and confidential. If the reader 
> >> of the
> >> message is not the intended recipient or an authorized representative of 
> >> the
> >> intended recipient, you are hereby notified that any dissemination of this
> >> communication is strictly prohibited. If you have received this 
> >> communication in
> >> error, please notify us immediately by e-mail and delete the message and 
> >> any
> >> attachments from your system.
>
> >> _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers 
> >> Are"_
>
> > --
> > Howard Richter
> > Red Hat Certified Technician
> > CompTIA Linux+ Certified
> > ITIL Foundation Certified
> > E-Mail = hbr4...@gmail.com
> > LinkedIn Profile =http://www.linkedin.com/in/hbr4270
> > _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
> > Are"_
>
> > This message and any attachments are intended only for the use of the 
> > addressee and
> > may contain information that is privileged and confidential. If the reader 
> > of the
> > message is not the intended recipient or an authorized representative of the
> > intended recipient, you are hereby notified that any dissemination of this
> > communication is strictly prohibited. If you have received this 
> > communication in
> > error, please notify us immediately by e-mail and delete the message and any
> > attachments from your system.
>
> > _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers 
> > Are"_
>
> --
> Howard Richter
> Red Hat Certified Technician
> CompTIA Linux+ Certified
> ITIL Foundation Certified
> E-Mail = hbr4...@gmail.com
> LinkedIn Profile =http://www.linkedin.com/in/hbr4270
>
> ___
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Best way to organize the Dev studio

[Elry]

Sweet.

This is a very nice feature.

On May 22, 8:33 am, "Walters, Mark"  wrote:
> Something I discovered recently that's handy, especially with multiple 
> monitors - you can drag tabs out of the main Eclipse window and they turn 
> into independent floating windows that you can move to other monitors.  I can 
> keep the main eclipse window for the form design and arrange everything else 
> on another monitor.
>
> Mark
>
> -Original Message-
> From: Action Request System discussion list(ARSList) 
> [mailto:arsl...@arslist.org] On Behalf Of Elry
> Sent: 22 May 2009 13:17
> To: arsl...@arslist.org
> Subject: Re: Best way to organize the Dev studio
>
> Well
>
> That is difficult to answer - it really is up to your own personal
> preference.
>
> Here is what I have done:
>
> 1) In my SOHO (home office) I have a very large monitor and it is easy
> to organize, but at work I do not.
> 2) At work I use two monitors of the same size.
> 3) At work I stretch the Studio across both screens.
> 4) In the Developer Perspective I have:
>     a) The Navigator on the far right.
>     b) The forms in the Middle (I can see the full form).
>     c) Relationships Messages & Progress tabs together in a mini
> window below the form.
>     d) On the far right I have the Properties, Outlines and all the
> active object windows in one tabbed window.
>
> With this approach I can see everything without having to maximize any
> given window.
>
> This works for me...
>
> On May 22, 6:12 am, Murtuza B  wrote:
> > Hello listers,
>
> > I have recently begun to use the Developer Studio with ARS 7.5 and ARS
> > 7.1.
>
> > I use 2 monitor screens, since it is quite difficult to fit everything
> > in 1.
> > What I would like to know is how people are organizing their dev studio
> > to optimally use the 2 screens and have a good layout of functions and
> > panes. What I want to avoid is having to move the mouse pointer
> > frequently between screens and to split any pane across the screen
> > boundaries.
>
> > Regards,
> > Murtuza.
>
> > ___
> > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
>
> > [disclaim.txt1K ]Visit our website athttp://www.ubs.com
>
> > This message contains confidential information and is intended only
> > for the individual named.  If you are not the named addressee you
> > should not disseminate, distribute or copy this e-mail.  Please
> > notify the sender immediately by e-mail if you have received this
> > e-mail by mistake and delete this e-mail from your system.
>
> > E-mails are not encrypted and cannot be guaranteed to be secure or
> > error-free as information could be intercepted, corrupted, lost,
> > destroyed, arrive late or incomplete, or contain viruses.  The sender
> > therefore does not accept liability for any errors or omissions in the
> > contents of this message which arise as a result of e-mail transmission.
> > If verification is required please request a hard-copy version.  This
> > message is provided for informational purposes and should not be
> > construed as a solicitation or offer to buy or sell any securities
> > or related financial instruments.
>
> > UBS reserves the right to retain all messages. Messages are protected
> > and accessed only in legally justified cases.
>
> > ___
> > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
>
> ___
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
>
> ___
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Best way to organize the Dev studio

[Elry]

Well

That is difficult to answer - it really is up to your own personal
preference.

Here is what I have done:

1) In my SOHO (home office) I have a very large monitor and it is easy
to organize, but at work I do not.
2) At work I use two monitors of the same size.
3) At work I stretch the Studio across both screens.
4) In the Developer Perspective I have:
a) The Navigator on the far right.
b) The forms in the Middle (I can see the full form).
c) Relationships Messages & Progress tabs together in a mini
window below the form.
d) On the far right I have the Properties, Outlines and all the
active object windows in one tabbed window.

With this approach I can see everything without having to maximize any
given window.

This works for me...

On May 22, 6:12 am, Murtuza B  wrote:
> Hello listers,
>
> I have recently begun to use the Developer Studio with ARS 7.5 and ARS
> 7.1.
>
> I use 2 monitor screens, since it is quite difficult to fit everything
> in 1.
> What I would like to know is how people are organizing their dev studio
> to optimally use the 2 screens and have a good layout of functions and
> panes. What I want to avoid is having to move the mouse pointer
> frequently between screens and to split any pane across the screen
> boundaries.
>
> Regards,
> Murtuza.
>
> ___
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
>
> [disclaim.txt1K ]Visit our website athttp://www.ubs.com
>
> This message contains confidential information and is intended only
> for the individual named.  If you are not the named addressee you
> should not disseminate, distribute or copy this e-mail.  Please
> notify the sender immediately by e-mail if you have received this
> e-mail by mistake and delete this e-mail from your system.
>
> E-mails are not encrypted and cannot be guaranteed to be secure or
> error-free as information could be intercepted, corrupted, lost,
> destroyed, arrive late or incomplete, or contain viruses.  The sender
> therefore does not accept liability for any errors or omissions in the
> contents of this message which arise as a result of e-mail transmission.  
> If verification is required please request a hard-copy version.  This
> message is provided for informational purposes and should not be
> construed as a solicitation or offer to buy or sell any securities
> or related financial instruments.
>
> UBS reserves the right to retain all messages. Messages are protected
> and accessed only in legally justified cases.
>
> ___
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Pushing a Dialog Window Results

[Elry]

Hey Mark...

I remember running into a similar situation recently...

Try looking at Page 218-222 of the Workflow Objects Manual.

There are some good examples there of using Scoped & Window Scoped
variables to send events between window.


On May 20, 9:58 am, Mark Lev  wrote:
> Perhaps you can use 1 dialog, with 1 page holder/4 pages.  1st visible,
> 2 - 4 hidden.  User answers, click a Next button which would hide 1st,
> show 2nd etc.
>
> Last page would have save button, then you can save all in one step.
>
> Thanks,
>
> Mark
>
> From: Action Request System discussion list(ARSList)
> [mailto:arsl...@arslist.org] On Behalf Of Brittain, Mark
> Sent: Wednesday, May 20, 2009 9:43 AM
> To: arsl...@arslist.org
> Subject: Pushing a Dialog Window Results
>
> **
>
> Hi Everyone,
>
> What I would like to do is have an active link that opens 4 dialog boxes
> in order that contains a Yes/No questions. The answers I want to place
> in the diary field of the main form where the active link was launched.
>
> I tried using a push field, commit and close window to place the answers
> in the diary field and this works fine. However if I then try to update
> the record after answering the questions, I get the 1203 Warning that
> another user has updated the record. This is not going to work. I also
> don't want to answer the questions after I have saved the ticket.
>
> I then tried a Global field figuring I could move the information from
> the dialog form to the main form and then doing a set field to the diary
> field and setting the Global field to NULL. What I am finding is that
> the data in the Global Field of the main form of all records unless I
> log out. This also won't work because if the user executes the 4
> questions or "x" out part way through and then does no save the ticket,
> the Global field does not get cleared and would be in the next ticket
> displayed. There has to be an easier way but I can't see it.
>
> ARS 6.3 patch 20.
>
> Thanks
>
> Mark
>
> 
> Mark Brittain
> Remedy Developer
> NaviSite
> mbritt...@navisite.com 
> (315) 453-2912 x5418 (Phone)
>
> (315) 317.2897 (Cell)
>
> Reduce Cost of IT with Managed Hosting and Application Services from
> NaviSite.
> Visitwww.NaviSite.comToday.
>
> _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
> Are"_
>
> ___
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Need some feedback on AR Server in a multiple language environment?

[Elry]

Hey Chris

I have been involved in a number of localization projects here in
Canada - due to the fact that we are a bilingual culture - in theory
anyway.

The answer to your question is quite simple actually - "It
Depends"

Once you have the answer to these basic questions - I can tell you how
complex it will get:

1) Will your data language be one language (i.e. English - the data
language is the language that you enter the information into the
application)?
2) How many different language interfaces will you need?
3) Will you need to provide menus and table fields in multiple
languages?

The localization process goes something like this:

1) Install the appropriate language DLL's (done during the
installation process - this assumes windows environment).
2) Create localized views of the forms.
3) Localize UI components.
4) Localize messages, Character Menus
5) Localize Non-character Menus
6) Apply Locale Settings.

I have a Visio of this process - let me know if you want me to email
it to you...

We currently have three localized applications running in the Canadian
Federal Government.

I will be more than happy to help you with any questions (where
possible)...

Good Luck Bud...



Rick Cook wrote:
> Tony brings up a good point.  After you get everyone to agree on a common
> definition for "multiple language environment" and all that entails, then
> you can look at whether upgrading to 7.5 might be a good time to switch to
> unicode (should you need to).
>
> This is NOT a trivial operation.
>
> Rick
> On Thu, May 14, 2009 at 10:18 AM, Tony Worthington <
> tony.worthing...@kohls.com> wrote:
>
> > Are you Unicode now?  If not, I can see that as the major hurdle.
> >
> >
> > * Tony Worthington*
> >  Sr. Technical Analyst
> >  Kohl's Department Stores
> >  N56 W17000 Ridgewood Drive
> >  Menomonee Falls, WI 53051
> >  262.703.7763 (phone)
> >  *tony.worthing...@kohls.com* 
> >  *www.kohls.com* 
> >
> >
> >
> >   From: "Pruitt, Christopher J"  To:
> > arslist@ARSLIST.ORG Date: 05/14/2009 11:58 AM Subject: Need some feedback
> > on AR Server in a multiple language environment? Sent by: "Action Request
> > System discussion list(ARSList)" 
> > --
> >
> >
> >
> > **
> >
> >  I could really use some feedback from anyone on the list who has dealt
> > with moving AR System from a English Only version to a multiple language
> > environment. I am looking to information on how hard would it be to 
> > accomplish
> > and what are some of the pitfalls, issues, need to knows, etc.
> >
> >  We currently run on a
> >
> >  OS: SUN OS 5.9
> >
> > DB: Oracle 10g
> >
> >  AR Server: Version 7.1 unpatched.
> >
> >  *Christopher Pruitt*
> > Consultant Specialist*
> > EDS,* an HP Company
> > mailto:* **christopher.pru...@eds.com*
> >
> >  We deliver on our commitments
> > so you can deliver on yours.
> >
> >  *Confidentiality Notice:* This message and any files transmitted with it
> > are intended for the sole use of the entity or individual to whom it is
> > addressed, and may contain information that is confidential, privileged, and
> > exempt from disclosure under applicable law. If you are not the intended
> > addressee for this e-mail, you are hereby notified that any copying,
> > distribution, or dissemination of this e-mail is strictly prohibited. If you
> > have received this e-mail in error, please immediately destroy, erase, or
> > discard this message. Please notify the sender immediately by return
> > e-mail if you have received this e-mail by mistake.
> >
> >  _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
> > Are"_
> >
> >  --
> > CONFIDENTIALITY NOTICE:
> > This is a transmission from Kohl's Department Stores, Inc.
> > and may contain information which is confidential and proprietary.
> > If you are not the addressee, any disclosure, copying or distribution or
> > use of the contents of this message is expressly prohibited.
> > If you have received this transmission in error, please destroy it and
> > notify us immediately at 262-703-7000.
> >
> > CAUTION:
> > Internet and e-mail communications are Kohl's property and Kohl's reserves
> > the right to retrieve and read any message created, sent and received.
> > Kohl's reserves the right to monitor messages by authorized Kohl's
> > Associates at any time
> > without any further consent.
> >
> >
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: ARDBC LDAP & Novell eDirectory & ARS 7.5

[Elry]

Hey Fred...

I Thank you...

In the case of Novell Directory I used "createTimestamp" - this worked
perfectly

I can now see all the data and work with it accordingly

You won't believe this excerpt taken from page 131 of the Integration
Guide:

"AR System Request IDs are 15 bytes maximum in length and are assigned
by
AR System when the entry is created. Distinguished names, on the other
hand, are
often longer than 15 bytes. However, you can map distinguished names
longer
than 15 bytes to AR System Request IDs."

Thanks Again...


On May 13, 10:39 am, "Grooms, Frederick W" 
wrote:
> This line in your method below makes me think it is your problem
>
> 6) Pointing the Request ID to the "DN"
>
> A Request ID can only be 15 characters and must be unique.  We usually set 
> the Request ID to something like uSNCreated (The create date and time of the 
> LDAP record).
>
> Fred
>
> -Original Message-
> From: Action Request System discussion list(ARSList) 
> [mailto:arsl...@arslist.org] On Behalf Of Elry
> Sent: Wednesday, May 13, 2009 9:32 AM
> To: arsl...@arslist.org
> Subject: Re: ARDBC LDAP & Novell eDirectory & ARS 7.5
>
> We now have another unusual situation = ldaperr 93:  Result list pane
> returned, but no individual entries.
>
> Here is an excerpt from the arplugin logfile:
>
> ===
>
> Entering ARDBCGetListEntryWithFields
>
> timeout previously: -1
>
> timeout used: 85000
>
> ldap_simple_bind("cn=test,o=TEST_adm", hidden)
>
> CLDAPSearch::Execute - ldap_search("o=TEST_Adm", 2,
> "(objectclass=inetOrgPerson)")
>
> CLDAPSearch::Execute - ldap_search(page size = 1)
>
> CLDAPSearch::Execute - ldap_search() control not found (ldaperr 93)
>
> Execute - No more pages
>
> Execute - ldap_search returned 264 entries
>
> CLDAPSearch::FillFieldValueList ..(VALUE ATTRIBUTE PAIRS
> FOLLOW AT THIS POINT)
>
> Leaving  ARDBCGetListEntryWithFields
>
> OK
>
> /+GE    ARDBCGetEntry                    -- vendor ARSYS.ARDBC.LDAP
> table ldap://...
>
> Entering ARDBCGetEntry
>
> ===
>
> AT THIS POINT I TRY TO DOUBLE CLICK IN THE RESULT LIST TO RETURN
> SINGLE ENTRIES
>
> (AT THIS POINT IT ATTEMPTS TO RETURN ENTRIES, BUT STOPS)
>
> Execute - ldap_search returned 0 entries
>
> Execute - ldap_search returned 0 references
>
> ===
>
> THIS URL APPEARS TO BE THE CULPRIT
>
> CLDAPSearch::Execute - ldap_search("o=TEST_Adm", 2, "(&
> (objectclass=inetOrgPerson)(DN=cn=Fred,ou=HR,o=TEST_Adm))")
>
> Each time ARDBC GetEntry executes this URL search ite appears to
> randomly add a "|"  character into the string.
>
> ===
>
> Our method consists of:
>
> 1) Using Softerra LDAP Browser 2.6 to create searches that we are sure
> about...
>
> 2) Gone through the process of creating a Vendor Form...
>
> 3) Validated the LDAP URL during creation of the Vendor Form...
>
> 4) Selected the fields from the list during Vendor Form creation
>
> 5) Tried selecting the fields after Vendor Form creation...
>
> 6) Pointing the Request ID to the "DN"
>
> 7) Creating a new character field that was pointed to the "DN"
>
> In all cases this is what occured when we opened the form to do a
> search:
>
> 1) We saw results in the results list pane, but the actual fields on
> the form were empty.
>
> 2) We added more fields to the results list pane - we were able to see
> all values in the results list pane, but there were no entries in the
> actual fields on the form.
>
> 3) We qualified the query by specifying a 'sn" for the Object Class
> Person.  This returned the single correct entry (which we could only
> see in the results pane and not the actual form itself).
>
> 4) We exported the data to a ARX and a CSV, but found the files to be
> empty (although the entries were processes as normally should be -
> with a progression bar etc...)
>
> Is this a bug in ARDBC?
>
> Anyone
>
> On May 6, 2:43 pm, Elry  wrote:
> > Mark
>
> > You are a gentleman and a scholar!
>
> > This worked perfectly.  Once an chose a branch instead of the Tree - I
> > saw immediate success.
>
> > Thanks Again.
>
> > On May 6, 2:07 pm, "Walters, Mark"  wrote:
>
> > > It looks like you have set the base dn to c=ca;
>
> > > Base Table Name: ldap://142.212.154.39/c=ca??sub
>