Re: suggestions
When I was new to this stuff (but back then the system was not as complex as it may be now) I found that my learning path grew really fast once I started to take a view of what happens under the covers – especially the database. Its good to have a solid understanding of the database, although you could pretty much get by without knowing a damn thing about it, but then your skills would be more administrative/developer type than a real AR System application developer.. I began with investigating the purpose of all the non-T, non-H and non-B tables Joe From: Sam Anderson Sent: Thursday, March 29, 2012 2:11 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: suggestions ** Hi All, As a beginner . Is there any other helpful material or website other than BMC product documents and BMC training programs by which one can start to improve their knowledge in Remedy. Or any tutorials ..? Not to mention Arlist, BMC docs..as everyone knows that they are of great use...:) -- Thanks Regards Sam ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: suggestions
If you are inheriting a system, go thru and map out the processes and look at how the active links/filters/etc written. Stuff I come across, I don't see these tricks in any training guide/document from 6.3 upwards, can't speak to doc/training guides prior. (`!) - at the end of filter name - force process to run immediately (@@: ) - run process in active link - forces it to run like active link. and so forth. -- View this message in context: http://ars-action-request-system.1093659.n2.nabble.com/suggestions-tp7418697p7418834.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: suggestions
CORRECTION.. If you are inheriting a system, go thru and map out the processes and look at how the active links/filters/etc written. Stuff I come across, I don't see these tricks in any training guide/document from 6.3 upwards, can't speak to doc/training guides prior. (`!) - at the end of filter name - force process to run immediately Corrected (@@: ) - run process in active link - forces it to run like filter link. and so forth. -- View this message in context: http://ars-action-request-system.1093659.n2.nabble.com/suggestions-tp7418697p7418842.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: suggestions
Sam, Not sure where you live/work. If you're lucky enough to be in an area that has a local RUG, these are great to places to learn and make connections with other users in the area. Of course there is WWRUG12 in San Jose in October. Dave From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Sam Anderson Sent: Thursday, March 29, 2012 2:12 PM To: arslist@ARSLIST.ORG Subject: suggestions ** Hi All, As a beginner . Is there any other helpful material or website other than BMC product documents and BMC training programs by which one can start to improve their knowledge in Remedy. Or any tutorials ..? Not to mention Arlist, BMC docs..as everyone knows that they are of great use...:) -- Thanks Regards Sam _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: suggestions
There are also the BMC Communities (BMC Developer Network): https://communities.bmc.com/communities/ -David J. Easter Manager of Product Management, Remedy Platform 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: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Shellman, David Sent: Thursday, March 29, 2012 1:06 PM To: arslist@ARSLIST.ORG Subject: Re: suggestions ** Sam, Not sure where you live/work. If you're lucky enough to be in an area that has a local RUG, these are great to places to learn and make connections with other users in the area. Of course there is WWRUG12 in San Jose in October. Dave From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Sam Anderson Sent: Thursday, March 29, 2012 2:12 PM To: arslist@ARSLIST.ORG Subject: suggestions ** Hi All, As a beginner . Is there any other helpful material or website other than BMC product documents and BMC training programs by which one can start to improve their knowledge in Remedy. Or any tutorials ..? Not to mention Arlist, BMC docs..as everyone knows that they are of great use...:) -- Thanks Regards Sam _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Suggestions requested for bringing in data from a separate database
Hi Susan While this is good you will need a bunch of SQL skills to write the scripts needed. With Meta-Update you will not need these SQL skills and Meta-Update is driven through the API. You will still need to link the databases as Meta-Update communicates with the ARS server. The advantage of Meta-Update is in this case one of time. You will find the efforts required for SQL Scripts rather larger than the efforts required for Meta-Update scripts. Further Meta-Update automatically has replete logging and since it goes through the API all workflow fires. Finally Meta-Update can automatically have any value transformation required. View forms seem to take considerable time in ARS as the view is rebuilt each access. This is of-course not true on instantiated views. In Meta-Update (and the API) all data in an SQL Query is brought in local memory at the time of the query. So there is no real advantage to a local view as the casts, sub-queries, etc may be done right in the SQL field definition of Meta-Update. I agree that a local view is better as any SQL types that ARS does not understand must be cast to a type understood. The value transformation facility in Meta-Update is very robust. You can refer to SQL and ARS queries (cached), Excel spreadsheets, script statements, etc. This allows you to transform and generate data that may not be in your database, to use several SQL and ARS records for your assignments. The key here is that you do not need to be a programmer or an SQL programmer. Meta-Update was designed to allow the ARS Administrator / Developer power over data without any programming at all. (Yes there is a single step debugger so that means that it is approaching programming but it is still much much simpler than either SQL or Java.) As an example, I got a people loading script working in 1 day and another fellow charged with using a view form took 1.5 months. Plus the script is a single ASCII file and not a bunch of ARS objects (view forms, workflow, etc). I expect that if you were to use Meta-Update you would take more than one day but still be far faster than writing your own SQL scripts. Cheers Ben Chernys Senior Software Architect Description: logoSthInc-sm Canada / Deutschland / Germany Mobile: +49 171 380 2329GMT + 1 + [ DST ] Email: Ben.Chernys _AT softwaretoolhouse.com mailto:Ben.Chernys%20_AT%20_%20softwaretoolhouse.com Web: http://www.softwaretoolhouse.com/ www.softwaretoolhouse.com Check out Software Tool House's free Diary Editor. Meta-Update, our premium ARS Data tool, lets you automate your imports, migrations, in no time at all, without programming, without staging forms, without merge workflow. http://www.softwaretoolhouse.com/ http://www.softwaretoolhouse.com/ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Susan Palmer Sent: January-20-12 01:33 To: arslist@ARSLIST.ORG Subject: Re: Suggestions requested for bringing in data from a separate database ** Thank you Fred ! I have generally stayed away from 'normalized' data here since the quantity is relatively low. It may be time to rethink that in this situation. A dblink was my initial choice. I will try both methods and see which fits best. Susan On Thu, Jan 19, 2012 at 5:45 PM, Grooms, Frederick W frederick.w.gro...@xo.com wrote: ** Susan, Since you are on Oracle there are a couple of ways to get the Org data. (MS SQL and others have similar abilities, just different names) You can link across a dbLink (I personally prefer to make a local Oracle view that access the data across the dbLink. This way the Remedy View form is against nothing but the local database). You can use a Materialized View to pull the Org data into the Remedy database (A Materialized view can be told to auto refresh every X interval behind the scene). You can use scripts to update the data in Remedy from the master. With any of these you can create a View form in Remedy against the Org data (I have used all 3 and they all have their place where they work the best). With the last 2 you have the advantage that you can add whatever indexes you need without affecting the master copy. The View form can be created with every field's change flag disabled so no one can mess with the data in Remedy, they would have to update the master. Next thing to look at is normalization of data. Do you really need 30 fields from Org into Site? Personally I only store a key of the parent Org into the child Site (unless you are in a many to many situation, then you need an intermediate mapping form, but I don't want to get into that here). i.e. In Site you would have an Org_ID field that holds a unique key for the Org data. (This is the way I have always designed my Remedy forms). If you want to view the combined data exactly like they see now for Site you can create a Join form (While
Re: Suggestions requested for bringing in data from a separate database
I don't know if I uderstood your mail completelly, but I'll try to help you. You can create a view at the database that points to an external database. Depending on your database engine this is done by one or another way. Then you can access this view from Remedy using a view form. Regards, Jose Huerta http://theremedyforit.com/ On Thu, Jan 19, 2012 at 23:32, Susan Palmer suzanpal...@gmail.com wrote: ** Hi Everyone, Currently we house all data necessary for various Remedy operations in Remedy forms. It has a 'flow-down' mentality so top feeds to next level and that level feeds to next level etc. All other systems we have access the necessary data from Remedy. Of course there is always the issue of data correctness, which really has nothing to do with Remedy specifically. But it's been decided that some specific data will be stored in another separate database and all systems will access it from there (much like they do now accessing it from Remedy). The new database will be much more accurate (tongue in cheek) and will not have data correctness issues. That's the basic background. So I'm looking for solutions that provide me the easiest way to access that data stored in the separate database seamlessly. I don't want to bring it all into a Remedy form and then access it from there since basically that takes me to where I currently am (which works just fine but is being discouraged). For instance, all information about an Organization is in the Organization Information form and when a 'Site' belonging to that Organization is created much of the Org info is automatically set into the new Site record. So instead of starting at the Org form to create a Site I need to start at the Site form and pull in the Org data (sql set fields). Or maybe I do a display form for the Org data (view form with data displayed) and still create the Site from that display record via set fields. Either way how do I get that Org info without using a menu selection (600 choices) or needing to know exact verbiage. We need to have the Org information stored in the Site record for easy reporting and querying, although maybe that's just my mindset. I would think it would be less efficient to always be calling to another database. We're talking about approximately 30 fields from the Org record. I'm just having a little trouble putting my arms around this and shifting my Remedy centric thinking. We're talking about 600 Org and 50,000 Sites but that number will double in 1-2 years and continue at that growth. Relatively small in comparison to many systems but needs to be scalable. I'd appreciate any help triggering my thought process towards the most correct path which may be one that hasn't even crossed that mind. Thanks, Susan Palmer ShopperTrak 200 W Monroe St 11th Fl Chicago, IL 60606 312-529-5325 spal...@shoppertrak.com ARS v7.5P4 Oracle 10.2 We currently use v7.5P7 client tool but will be moving to web (although many postings question that decision) Our prod server services US, CH, UK, Middle East _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Suggestions requested for bringing in data from a separate database
Susan, Since you are on Oracle there are a couple of ways to get the Org data. (MS SQL and others have similar abilities, just different names) You can link across a dbLink (I personally prefer to make a local Oracle view that access the data across the dbLink. This way the Remedy View form is against nothing but the local database). You can use a Materialized View to pull the Org data into the Remedy database (A Materialized view can be told to auto refresh every X interval behind the scene). You can use scripts to update the data in Remedy from the master. With any of these you can create a View form in Remedy against the Org data (I have used all 3 and they all have their place where they work the best). With the last 2 you have the advantage that you can add whatever indexes you need without affecting the master copy. The View form can be created with every field's change flag disabled so no one can mess with the data in Remedy, they would have to update the master. Next thing to look at is normalization of data. Do you really need 30 fields from Org into Site? Personally I only store a key of the parent Org into the child Site (unless you are in a many to many situation, then you need an intermediate mapping form, but I don't want to get into that here). i.e. In Site you would have an Org_ID field that holds a unique key for the Org data. (This is the way I have always designed my Remedy forms). If you want to view the combined data exactly like they see now for Site you can create a Join form (While the Admin tool would not let you use a View form in a Join, Developer Studio 7.6 does). Hope this helps Fred From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Susan Palmer Sent: Thursday, January 19, 2012 4:32 PM To: arslist@ARSLIST.ORG Subject: Suggestions requested for bringing in data from a separate database ** Hi Everyone, Currently we house all data necessary for various Remedy operations in Remedy forms. It has a 'flow-down' mentality so top feeds to next level and that level feeds to next level etc. All other systems we have access the necessary data from Remedy. Of course there is always the issue of data correctness, which really has nothing to do with Remedy specifically. But it's been decided that some specific data will be stored in another separate database and all systems will access it from there (much like they do now accessing it from Remedy). The new database will be much more accurate (tongue in cheek) and will not have data correctness issues. That's the basic background. So I'm looking for solutions that provide me the easiest way to access that data stored in the separate database seamlessly. I don't want to bring it all into a Remedy form and then access it from there since basically that takes me to where I currently am (which works just fine but is being discouraged). For instance, all information about an Organization is in the Organization Information form and when a 'Site' belonging to that Organization is created much of the Org info is automatically set into the new Site record. So instead of starting at the Org form to create a Site I need to start at the Site form and pull in the Org data (sql set fields). Or maybe I do a display form for the Org data (view form with data displayed) and still create the Site from that display record via set fields. Either way how do I get that Org info without using a menu selection (600 choices) or needing to know exact verbiage. We need to have the Org information stored in the Site record for easy reporting and querying, although maybe that's just my mindset. I would think it would be less efficient to always be calling to another database. We're talking about approximately 30 fields from the Org record. I'm just having a little trouble putting my arms around this and shifting my Remedy centric thinking. We're talking about 600 Org and 50,000 Sites but that number will double in 1-2 years and continue at that growth. Relatively small in comparison to many systems but needs to be scalable. I'd appreciate any help triggering my thought process towards the most correct path which may be one that hasn't even crossed that mind. Thanks, Susan Palmer ShopperTrak 200 W Monroe St 11th Fl Chicago, IL 60606 312-529-5325 spal...@shoppertrak.commailto:spal...@shoppertrak.com ARS v7.5P4 Oracle 10.2 We currently use v7.5P7 client tool but will be moving to web (although many postings question that decision) Our prod server services US, CH, UK, Middle East ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Suggestions requested for bringing in data from a separate database
Thank you Fred ! I have generally stayed away from 'normalized' data here since the quantity is relatively low. It may be time to rethink that in this situation. A dblink was my initial choice. I will try both methods and see which fits best. Susan On Thu, Jan 19, 2012 at 5:45 PM, Grooms, Frederick W frederick.w.gro...@xo.com wrote: ** Susan, ** ** Since you are on Oracle there are a couple of ways to get the Org data. (MS SQL and others have similar abilities, just different names) You can link across a dbLink (I personally prefer to make a local Oracle view that access the data across the dbLink. This way the Remedy View form is against nothing but the local database). You can use a Materialized View to pull the Org data into the Remedy database (A Materialized view can be told to auto refresh every X interval behind the scene). You can use scripts to update the data in Remedy from the “master”. With any of these you can create a View form in Remedy against the Org data (I have used all 3 and they all have their place where they work the best). With the last 2 you have the advantage that you can add whatever indexes you need without affecting the master copy. The View form can be created with every field’s change flag disabled so no one can mess with the data in Remedy, they would have to update the master. ** ** Next thing to look at is normalization of data. Do you really need 30 fields from Org into Site? Personally I only store a key of the parent “Org” into the child “Site” (unless you are in a many to many situation, then you need an intermediate “mapping” form, but I don’t want to get into that here). i.e. In Site you would have an Org_ID field that holds a unique key for the Org data. (This is the way I have always designed my Remedy forms).*** * ** ** If you want to view the combined data exactly like they see now for Site you can create a Join form (While the Admin tool would not let you use a View form in a Join, Developer Studio 7.6 does). ** ** Hope this helps Fred ** ** ** ** ** ** *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Susan Palmer *Sent:* Thursday, January 19, 2012 4:32 PM *To:* arslist@ARSLIST.ORG *Subject:* Suggestions requested for bringing in data from a separate database ** ** ** Hi Everyone, Currently we house all data necessary for various Remedy operations in Remedy forms. It has a 'flow-down' mentality so top feeds to next level and that level feeds to next level etc. All other systems we have access the necessary data from Remedy. Of course there is always the issue of data correctness, which really has nothing to do with Remedy specifically. But it's been decided that some specific data will be stored in another separate database and all systems will access it from there (much like they do now accessing it from Remedy). The new database will be much more accurate (tongue in cheek) and will not have data correctness issues. That's the basic background. So I'm looking for solutions that provide me the easiest way to access that data stored in the separate database seamlessly. I don't want to bring it all into a Remedy form and then access it from there since basically that takes me to where I currently am (which works just fine but is being discouraged). For instance, all information about an Organization is in the Organization Information form and when a 'Site' belonging to that Organization is created much of the Org info is automatically set into the new Site record. So instead of starting at the Org form to create a Site I need to start at the Site form and pull in the Org data (sql set fields). Or maybe I do a display form for the Org data (view form with data displayed) and still create the Site from that display record via set fields. Either way how do I get that Org info without using a menu selection (600 choices) or needing to know exact verbiage. We need to have the Org information stored in the Site record for easy reporting and querying, although maybe that's just my mindset. I would think it would be less efficient to always be calling to another database. We're talking about approximately 30 fields from the Org record. I'm just having a little trouble putting my arms around this and shifting my Remedy centric thinking. We're talking about 600 Org and 50,000 Sites but that number will double in 1-2 years and continue at that growth. Relatively small in comparison to many systems but needs to be scalable.** ** I'd appreciate any help triggering my thought process towards the most correct path which may be one that hasn't even crossed that mind. Thanks, Susan Palmer ShopperTrak 200 W Monroe St 11th Fl
Re: Suggestions for daily auto Crystal Report export email?
Alan; The problem with most of the freeware are the limitations (it is free after all). So the more options you want to do the harder it is to use a free one. The cheapest product I have found that has the most options is CRD from Christiansteven software. http://www.christiansteven.com/index.html Bill Clary Bright House R. Alan Monroe amon...@columbus.rr.com wrote in message news:199439918178.20100403093...@columbus.rr.com... I'm looking for some freeware that can export _standalone .rpt files_ created with Crystal Reports 9.x (we DON'T have any Crystal Enterprise etc. backend infrastructure nor any web server) daily with changing date parameters and email them to a short list of recipients. At the moment I have to manually run them from the user tool, save pdfs and email them by hand. My top candidate from the handful I found on the top google hits was Crystal Delivery from groffautomation.com, which worked great on my local workstation, but fails to output reports when run on the server (Win 2003 server x64). As best I can tell it's some kind of incompatibility with 64-bit Crystal runtimes not talking to 32-bit AR System ODBC driver (I'm at home at the moment and don't have the logs handy, something like error 193 in the logs). I am open to just about any solutions, gui, commandline, or even source code (this seemed like something one could cobble together using VBScript and COM, but I couldn't google up a Crystal COM API reference sheet). Alan CONFIDENTIALITY NOTICE: This e-mail may contain information that is privileged, confidential or otherwise protected from disclosure. If you are not the intended recipient of this e-mail, please notify the sender immediately by return e-mail, purge it and do not disseminate or copy it. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Suggestions for daily auto Crystal Report export email?
HI Bill, good to see you on the list. We also use CRD. It is a wonderful product. We dropped CRD a few years ago when we went to Crystal 11 and had a full Crystal Reports Server that can also automate reports. We found that CR Server had many limitations, it was kind of clunky and we had to use all kinds of work arounds to things that were easy in CRD (like suppress sending a blank report). When talking to BO/SAP they were trying to up sell us to other products. We brought back CRD and have been happy since. I highly recommend CRD for report automation. Jason On Tue, Apr 6, 2010 at 11:07 AM, Clary, William M. william.cl...@mybrighthouse.com wrote: Alan; The problem with most of the freeware are the limitations (it is free after all). So the more options you want to do the harder it is to use a free one. The cheapest product I have found that has the most options is CRD from Christiansteven software. http://www.christiansteven.com/index.html Bill Clary Bright House R. Alan Monroe amon...@columbus.rr.com wrote in message news: 199439918178.20100403093...@columbus.rr.com... I'm looking for some freeware that can export _standalone .rpt files_ created with Crystal Reports 9.x (we DON'T have any Crystal Enterprise etc. backend infrastructure nor any web server) daily with changing date parameters and email them to a short list of recipients. At the moment I have to manually run them from the user tool, save pdfs and email them by hand. My top candidate from the handful I found on the top google hits was Crystal Delivery from groffautomation.com, which worked great on my local workstation, but fails to output reports when run on the server (Win 2003 server x64). As best I can tell it's some kind of incompatibility with 64-bit Crystal runtimes not talking to 32-bit AR System ODBC driver (I'm at home at the moment and don't have the logs handy, something like error 193 in the logs). I am open to just about any solutions, gui, commandline, or even source code (this seemed like something one could cobble together using VBScript and COM, but I couldn't google up a Crystal COM API reference sheet). Alan CONFIDENTIALITY NOTICE: This e-mail may contain information that is privileged, confidential or otherwise protected from disclosure. If you are not the intended recipient of this e-mail, please notify the sender immediately by return e-mail, purge it and do not disseminate or copy it. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org 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: Suggestions for daily auto Crystal Report export email?
The cheapest product I have found that has the most options is CRD from Christiansteven software. We also use CRD. It is a wonderful product. Thanks for the tip. I'll try the demo tomorrow. Alan ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Suggestions for daily auto Crystal Report export email?
(Win 2003 server x64). As best I can tell it's some kind of incompatibility with 64-bit Crystal runtimes not talking to 32-bit AR System ODBC driver (I'm at home at the moment and don't have the logs handy, something like error 193 in the logs). Actual error is: 4/2/2010 1:48:57 PM Logon failed. Details: IM003:Specified driver could not be loaded due to system error 193 (AR System ODBC Driver). Error in File C:\DOCUME~1\username\LOCALS~1\Temp\6\ARCategorizationHistory {7CC59A4C-3C60-4442-9E63-10D9949C30CB}.rpt: Unable to connect: incorrect log on parameters. 4/2/2010 1:50:57 PM Logon failed. Details: IM003:Specified driver could not be loaded due to system error 193 (AR System ODBC Driver). Error in File C:\DOCUME~1\username\LOCALS~1\Temp\6\ARCategorizationHistory {297C4630-A592-4FF3-8EF3-0823FBDDE455}.rpt: Unable to connect: incorrect log on parameters. Crystal Reports Exporter is a free command line utility that can easily be setup to run from a batch file. Here is the URL: http://www.rainforestnet.com/crexport-download.htm This one errors out with: Unhandled Exception: System.IO.FileNotFoundException: Could not load file or assembly 'CrystalDecisions.CrystalReports.Engine, Versi on=9.1.5000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304' or one of its dependencies. The system cannot find the file specifi ed. File name: 'CrystalDecisions.CrystalReports.Engine, Version=9.1.5000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304' at crexport.crexport.Main(String[] args) Alan ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Suggestions for daily auto Crystal Report export email?
Hi Alan, Crystal Reports Exporter is a free command line utility that can easily be setup to run from a batch file. Here is the URL: http://www.rainforestnet.com/crexport-download.htm It is simple open source .NET app. I have not used it on 64-bit before but I suspect it won't be a problem. Here is the user guide with some sample usage: http://www.rainforestnet.com/crexportguide.htm You could write a Remedy app that calls with an it Escalation at the appropriate time and pass it the date parameters. Even with this app I don't think it is going to fix the issues with the 64-bit Crystal runtimes and ARODBC. We created a 32-bit VM utility server for all of these *little* things that do not work well on 64-bit. HTH, Jason On Sat, Apr 3, 2010 at 6:35 AM, R. Alan Monroe amon...@columbus.rr.comwrote: I'm looking for some freeware that can export _standalone .rpt files_ created with Crystal Reports 9.x (we DON'T have any Crystal Enterprise etc. backend infrastructure nor any web server) daily with changing date parameters and email them to a short list of recipients. At the moment I have to manually run them from the user tool, save pdfs and email them by hand. My top candidate from the handful I found on the top google hits was Crystal Delivery from groffautomation.com, which worked great on my local workstation, but fails to output reports when run on the server (Win 2003 server x64). As best I can tell it's some kind of incompatibility with 64-bit Crystal runtimes not talking to 32-bit AR System ODBC driver (I'm at home at the moment and don't have the logs handy, something like error 193 in the logs). I am open to just about any solutions, gui, commandline, or even source code (this seemed like something one could cobble together using VBScript and COM, but I couldn't google up a Crystal COM API reference sheet). Alan ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org 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: Suggestions for daily auto Crystal Report export email?
Crystal Reports Exporter is a free command line utility that can easily be setup to run from a batch file. Here is the URL: http://www.rainforestnet.com/crexport-download.htm It is simple open source .NET app. I have not used it on 64-bit before but I suspect it won't be a problem. I tried that one too. Ran on my workstation but bombed out with an unhandled exception on the server. I can post the exact error later if anyone's curious. Alan ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Suggestions for storing/retrieving Remedy Data Attachments
Deidre, I think you will find that after the arx export there is simply a directory created with all of the original files in their original form. Note the original name of the file looks like it is mangled a bit by the process, but It likely is not a significant, nor confusing, change. As a quick test I attached a doc named 2009.09.15.summary.xlsx and the ARX directory contained a file named 2009.09.15.summary_0.xlsx. (So in this case _0 was added to the end of the original file name.) Now if you have more data in the ARS record than just the attachment, then that part of the data is held in the ARX file. However you could also export a csv file format to make that data more accessible without AR System too. It looks like the CSV file only has the original file name. ( However, I am not sure that will be much of a problem either. ) The ARX does have the map from the original file to the name of the file in the attachment directory. HTH. -- Carey Matthew Black BMC Remedy AR System Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On Thu, Sep 17, 2009 at 3:07 PM, Deidre Nail dn...@us.ibm.com wrote: ** I have a company that no longer wishes to use our Remedy System. They are requesting an extract of their data in a fashion that could be read at a later time and also contain attachments. I am aware that attachments can be pulled from Remedy in a .arx or .html file. However, in order to read the .arx and the attachments, you would need to re-import the data into a Remedy System. Does anyone have any suggestions as to how I can pull the data from Remedy with attachments in a way that can be used by a different tool for later reference for this company. Thanks, Deidre Nail Remedy Developer Phone: (770) 858-7053 T/L 88810 1600 RiverEdge Parkway, Atlanta GA 30328 _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: Suggestions for storing/retrieving Remedy Data Attachments
You would come across an issue (I think, maybe) if two different records had attachments with the same name? -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Carey Matthew Black Sent: Friday, September 18, 2009 8:59 AM To: arslist@ARSLIST.ORG Subject: Re: Suggestions for storing/retrieving Remedy Data Attachments Deidre, I think you will find that after the arx export there is simply a directory created with all of the original files in their original form. Note the original name of the file looks like it is mangled a bit by the process, but It likely is not a significant, nor confusing, change. As a quick test I attached a doc named 2009.09.15.summary.xlsx and the ARX directory contained a file named 2009.09.15.summary_0.xlsx. (So in this case _0 was added to the end of the original file name.) Now if you have more data in the ARS record than just the attachment, then that part of the data is held in the ARX file. However you could also export a csv file format to make that data more accessible without AR System too. It looks like the CSV file only has the original file name. ( However, I am not sure that will be much of a problem either. ) The ARX does have the map from the original file to the name of the file in the attachment directory. HTH. -- Carey Matthew Black BMC Remedy AR System Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On Thu, Sep 17, 2009 at 3:07 PM, Deidre Nail dn...@us.ibm.com wrote: ** I have a company that no longer wishes to use our Remedy System. They are requesting an extract of their data in a fashion that could be read at a later time and also contain attachments. I am aware that attachments can be pulled from Remedy in a .arx or .html file. However, in order to read the .arx and the attachments, you would need to re-import the data into a Remedy System. Does anyone have any suggestions as to how I can pull the data from Remedy with attachments in a way that can be used by a different tool for later reference for this company. Thanks, Deidre Nail Remedy Developer Phone: (770) 858-7053 T/L 88810 1600 RiverEdge Parkway, Atlanta GA 30328 _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 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Suggestions for storing/retrieving Remedy Data Attachments
Hi, WIth a little workflow involved you can save all attachments on disk, take a look at filter action run RERFORM-ACTION-SAVE-ATTACHMENT and use the request id to create directory structure before saving. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Deidre Nail Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Thursday, September 17, 2009 3:07 PM Subject: Suggestions for storing/retrieving Remedy Data Attachments ** I have a company that no longer wishes to use our Remedy System. They are requesting an extract of their data in a fashion that could be read at a later time and also contain attachments. I am aware that attachments can be pulled from Remedy in a .arx or .html file. However, in order to read the .arx and the attachments, you would need to re-import the data into a Remedy System. Does anyone have any suggestions as to how I can pull the data from Remedy with attachments in a way that can be used by a different tool for later reference for this company. Thanks, Deidre Nail Remedy Developer Phone: (770) 858-7053 T/L 88810 1600 RiverEdge Parkway, Atlanta GA 30328 _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: Suggestions wanted for backing up....
Hi Richard, We have a similar situation. I have no idea of how Tivoli operates but we are using a network backup product called NetBackup. Having had the unfortunate experience of having to recover from a hardware failure, I got the bad news that the backup guys could not create a server in the state of the last successful backup, they could only dump data contained in the directories. So I had to do a full OS install with all the apps etc and them took specific data contained in the backups and used it, like the AR licensing, config etc. This took me nearly a week. To say that the business was not happy would be an understatement. There are a few virtual products availabe, we are now moving to the VMWare environment. This now brings along the possibilities of snap shots. This means that if your vm server instance dies, using the snap shot you basically have an image of it and it can be used to rebuild the exact server as it was (at the time of the snap shot). Having a snap shot is great but I believe that it requires the same space allocation that the original server has. This is where I am having a battle with my server guys. You could also look at server groups. Having more than one app server under a load balancer would allow you to operate on the balance of the servers if one was to become inoperable. It's a cash thing though. I have put the ball back in the businesses court requesting that they need to determine the max downtime of a critical service and then based on that, what are they prepared to pay to make it possible, or pay in penalties. Kind Regards, Basil Webster Remedy Developer Siemens Southern Africa IT Solutions and Services (Pty) Ltd Infrastructure Operations 300 Janadel Avenue, Halfway House, 1685 T : +27 11 652 7523 F : +27 86 506 2883 M : +27 82 452 9389 basil.webs...@siemens.com mailto:basil.webs...@siemens.com www.siemens.co.za From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Richard Copits Sent: 03 March 2009 20:13 To: arslist@ARSLIST.ORG Subject: Suggestions wanted for backing up We are in the final stages of getting our Remedy 7.1 ITSM application ready to go to production status. We have an application server, a Web server and a Database server. The application and web servers are on virtual servers. We currently use Tivoli to do backups of the Other servers that we have. I'd like to see if we can use Tivoli to backup our Remedy system but I'm not sure of just what needs to Be backed up on the app and web servers. The SQL database is backed up by the database group so that's no worry. However, I want To be sure that I get what needs to be backed up for the app and web servers to be recoverable. I don't want to spend another two or Three days rebuilding everything if the MS server that hosts the vm's goes down. So, what should I be backing up? Best practices? Are There any good documents I should be reading to make the systems reasonably easy to recover? Thank you!! Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. __Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are html___ Disclaimer and Confidentiality Note This e-mail communication, its attachments, if any, and any rights attaching to it are, unless the context clearly indicates otherwise, the property of Siemens Limited. It is confidential, private and intended for the addressee only. If you are not the intended recipient and receive this communication in error, you are hereby notified that any review, copying, use, discloser or distribution in any manner whatsoever is strictly prohibited. Please notify the sender immediately that you have received this e-mail in error and delete the e-mail and any copies of it. Views and opinions expressed in this e-mail are those of the sender unless clearly stated as those of Siemens Limited. Siemens Limited accepts no liability for any loss or damage whatsoever, and howsoever incurred or suffered resulting or arising from the use of this e-mail communication and/or its attachments. Siemens Limited does not warrant the integrity of this e-mail communication nor that it is free of errors, viruses, interception or interference. For more information about Siemens Limited, visit our website at www.siemens.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
Re: Suggestions wanted for backing up....
My advice for you to do REMEDY recovery to do the following 1. Use REMEDY Migrator 2. Use traditional process of backup * Backup Definitions each in a single .def file (i.e. forms, active-links, filter, etc ) * Backup Data using third-party utilities such as (fast-Export) to do Copy-from-schema to identical schema. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Webster, Basil Sent: Wednesday, March 04, 2009 12:19 PM To: arslist@ARSLIST.ORG Subject: Re: Suggestions wanted for backing up Hi Richard, We have a similar situation. I have no idea of how Tivoli operates but we are using a network backup product called NetBackup. Having had the unfortunate experience of having to recover from a hardware failure, I got the bad news that the backup guys could not create a server in the state of the last successful backup, they could only dump data contained in the directories. So I had to do a full OS install with all the apps etc and them took specific data contained in the backups and used it, like the AR licensing, config etc. This took me nearly a week. To say that the business was not happy would be an understatement. There are a few virtual products availabe, we are now moving to the VMWare environment. This now brings along the possibilities of snap shots. This means that if your vm server instance dies, using the snap shot you basically have an image of it and it can be used to rebuild the exact server as it was (at the time of the snap shot). Having a snap shot is great but I believe that it requires the same space allocation that the original server has. This is where I am having a battle with my server guys. You could also look at server groups. Having more than one app server under a load balancer would allow you to operate on the balance of the servers if one was to become inoperable. It's a cash thing though. I have put the ball back in the businesses court requesting that they need to determine the max downtime of a critical service and then based on that, what are they prepared to pay to make it possible, or pay in penalties. Kind Regards, Basil Webster Remedy Developer Siemens Southern Africa IT Solutions and Services (Pty) Ltd Infrastructure Operations 300 Janadel Avenue, Halfway House, 1685 T : +27 11 652 7523 F : +27 86 506 2883 M : +27 82 452 9389 basil.webs...@siemens.commailto:basil.webs...@siemens.com www.siemens.co.za From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Richard Copits Sent: 03 March 2009 20:13 To: arslist@ARSLIST.ORG Subject: Suggestions wanted for backing up We are in the final stages of getting our Remedy 7.1 ITSM application ready to go to production status. We have an application server, a Web server and a Database server. The application and web servers are on virtual servers. We currently use Tivoli to do backups of the Other servers that we have. I'd like to see if we can use Tivoli to backup our Remedy system but I'm not sure of just what needs to Be backed up on the app and web servers. The SQL database is backed up by the database group so that's no worry. However, I want To be sure that I get what needs to be backed up for the app and web servers to be recoverable. I don't want to spend another two or Three days rebuilding everything if the MS server that hosts the vm's goes down. So, what should I be backing up? Best practices? Are There any good documents I should be reading to make the systems reasonably easy to recover? Thank you!! Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. Disclaimer and Confidentiality Note This e-mail communication, its attachments, if any, and any rights attaching to it are, unless the context clearly indicates otherwise, the property of Siemens Limited. It is confidential, private and intended for the addressee only. If you are not the intended recipient and receive this communication in error, you are hereby notified that any review, copying, use, discloser or distribution in any manner whatsoever is strictly prohibited. Please notify the sender immediately that you have received this e-mail in error and delete the e-mail and any copies of it. Views and opinions expressed in this e-mail are those of the sender unless clearly stated as those of Siemens Limited. Siemens Limited accepts no liability for any loss or damage whatsoever, and howsoever incurred or suffered resulting or arising from the use of this e-mail communication and/or its
Re: Suggestions wanted for backing up....
Hi, Since your Application and Webserver are on VMWare I would do a snapshot of the whole machine. If you're on VM ESX server it has some options for that. The best would be to ask your VMWare administrators. Cheers, Sebastiaan de Man 2009/3/4 Ali Musa aam...@stc.com.sa ** My advice for you to do REMEDY recovery to do the following 1. Use REMEDY Migrator 2. Use traditional process of backup - Backup Definitions each in a single .def file (i.e. forms, active-links, filter, etc ) - Backup Data using third-party utilities such as (fast-Export) to do Copy-from-schema to identical schema. -- *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Webster, Basil *Sent:* Wednesday, March 04, 2009 12:19 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Suggestions wanted for backing up Hi Richard, We have a similar situation. I have no idea of how Tivoli operates but we are using a network backup product called NetBackup. Having had the unfortunate experience of having to recover from a hardware failure, I got the bad news that the backup guys could not “create” a server in the state of the last successful backup, they could only dump data contained in the directories. So I had to do a full OS install with all the apps etc and them took specific data contained in the backups and used it, like the AR licensing, config etc. This took me nearly a week. To say that the business was not happy would be an understatement. There are a few virtual products availabe, we are now moving to the VMWare environment. This now brings along the possibilities of snap shots. This means that if your vm server instance dies, using the snap shot you basically have an image of it and it can be used to rebuild the exact server as it was (at the time of the snap shot). Having a snap shot is great but I believe that it requires the same space allocation that the original server has. This is where I am having a battle with my server guys. You could also look at server groups. Having more than one app server under a load balancer would allow you to operate on the balance of the servers if one was to become inoperable. It’s a cash thing though. I have put the ball back in the businesses court requesting that they need to determine the max downtime of a critical service and then based on that, what are they prepared to pay to make it possible, or pay in penalties. Kind Regards, Basil Webster Remedy Developer Siemens Southern Africa IT Solutions and Services (Pty) Ltd Infrastructure Operations 300 Janadel Avenue, Halfway House, 1685 T : +27 11 652 7523 F : +27 86 506 2883 M : +27 82 452 9389 basil.webs...@siemens.com *www.siemens.co.za* -- *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Richard Copits *Sent:* 03 March 2009 20:13 *To:* arslist@ARSLIST.ORG *Subject:* Suggestions wanted for backing up We are in the final stages of getting our Remedy 7.1 ITSM application ready to go to production status. We have an application server, a Web server and a Database server. The application and web servers are on virtual servers. We currently use Tivoli to do backups of the Other servers that we have. I’d like to see if we can use Tivoli to backup our Remedy system but I’m not sure of just “what” needs to Be backed up on the app and web servers. The SQL database is backed up by the database group so that’s no worry. However, I want To be sure that I get what needs to be backed up for the app and web servers to be recoverable. I don’t want to spend another two or Three days rebuilding everything if the MS server that hosts the vm’s goes down. So, what should I be backing up? Best practices? Are There any good documents I should be reading to make the systems reasonably easy to recover? Thank you!! Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. Disclaimer and Confidentiality Note This e-mail communication, its attachments, if any, and any rights attaching to it are, unless the context clearly indicates otherwise, the property of Siemens Limited. It is confidential, private and intended for the addressee only. If you are not the intended recipient and receive this communication in error, you are hereby notified that any review, copying, use, discloser or distribution in any manner whatsoever is strictly prohibited. Please notify the sender immediately that you have received
Re: Suggestions wanted for backing up....
Thanks Joe. we're using a VM and have thought about using snapshots, but if the server fails then the snapshot Is gone also...unless we move the snapshot off to another sever.. but the gating factor for me is how long the Service desk is willing to be down if I have to rebuildand I estimate that it could take three or four days to do That, patch everything, etc. I think I'm going to be looking at something like Ghost that will image the server and everything. After imaging I can move the image to another server so it's relatively safe. A product like Acronis will allow me to make a Master backup and then ongoing differential backups, so that may be a good solution. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Webster, Basil Sent: Wednesday, March 04, 2009 4:19 AM To: arslist@ARSLIST.ORG Subject: Re: Suggestions wanted for backing up ** Hi Richard, We have a similar situation. I have no idea of how Tivoli operates but we are using a network backup product called NetBackup. Having had the unfortunate experience of having to recover from a hardware failure, I got the bad news that the backup guys could not create a server in the state of the last successful backup, they could only dump data contained in the directories. So I had to do a full OS install with all the apps etc and them took specific data contained in the backups and used it, like the AR licensing, config etc. This took me nearly a week. To say that the business was not happy would be an understatement. There are a few virtual products availabe, we are now moving to the VMWare environment. This now brings along the possibilities of snap shots. This means that if your vm server instance dies, using the snap shot you basically have an image of it and it can be used to rebuild the exact server as it was (at the time of the snap shot). Having a snap shot is great but I believe that it requires the same space allocation that the original server has. This is where I am having a battle with my server guys. You could also look at server groups. Having more than one app server under a load balancer would allow you to operate on the balance of the servers if one was to become inoperable. It's a cash thing though. I have put the ball back in the businesses court requesting that they need to determine the max downtime of a critical service and then based on that, what are they prepared to pay to make it possible, or pay in penalties. Kind Regards, Basil Webster Remedy Developer Siemens Southern Africa IT Solutions and Services (Pty) Ltd Infrastructure Operations 300 Janadel Avenue, Halfway House, 1685 T : +27 11 652 7523 F : +27 86 506 2883 M : +27 82 452 9389 basil.webs...@siemens.com mailto:basil.webs...@siemens.com www.siemens.co.za From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Richard Copits Sent: 03 March 2009 20:13 To: arslist@ARSLIST.ORG Subject: Suggestions wanted for backing up We are in the final stages of getting our Remedy 7.1 ITSM application ready to go to production status. We have an application server, a Web server and a Database server. The application and web servers are on virtual servers. We currently use Tivoli to do backups of the Other servers that we have. I'd like to see if we can use Tivoli to backup our Remedy system but I'm not sure of just what needs to Be backed up on the app and web servers. The SQL database is backed up by the database group so that's no worry. However, I want To be sure that I get what needs to be backed up for the app and web servers to be recoverable. I don't want to spend another two or Three days rebuilding everything if the MS server that hosts the vm's goes down. So, what should I be backing up? Best practices? Are There any good documents I should be reading to make the systems reasonably easy to recover? Thank you!! Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. Disclaimer and Confidentiality Note This e-mail communication, its attachments, if any, and any rights attaching to it are, unless the context clearly indicates otherwise, the property of Siemens Limited. It is confidential, private and intended for the addressee only. If you are not the intended recipient and receive this communication in error, you are hereby notified that any review, copying, use, discloser or distribution in any manner whatsoever is strictly prohibited. Please notify the sender immediately that you have received this e-mail in error
Re: Suggestions wanted for backing up....
Richard, Why don't you look at the option of having server groups where it really wont impact that much apart from a performance standpoint if one server is down for a slightly extended period of time while being rebuilt? Joe From: Richard Copits richard.cop...@bwc.state.oh.us To: arslist@ARSLIST.ORG Sent: Wednesday, March 4, 2009 7:27:10 AM Subject: Re: Suggestions wanted for backing up ** Thanks Joe….. we’re using a VM and have thought about using snapshots, but if the server fails then the snapshot Is gone also…unless we move the snapshot off to another sever.. but the gating factor for me is how long the Service desk is willing to be down if I have to rebuild….and I estimate that it could take three or four days to do That, patch everything, etc. I think I’m going to be looking at something like Ghost that will image the server and everything. After imaging I can move the image to another server so it’s relatively safe. A product like Acronis will allow me to make a Master backup and then ongoing differential backups, so that may be a good solution. From:Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Webster, Basil Sent: Wednesday, March 04, 2009 4:19 AM To: arslist@ARSLIST.ORG Subject: Re: Suggestions wanted for backing up ** Hi Richard, We have a similar situation. I have no idea of how Tivoli operates but we are using a network backup product called NetBackup. Having had the unfortunate experience of having to recover from a hardware failure, I got the bad news that the backup guys could not “create” a server in the state of the last successful backup, they could only dump data contained in the directories. So I had to do a full OS install with all the apps etc and them took specific data contained in the backups and used it, like the AR licensing, config etc. This took me nearly a week. To say that the business was not happy would be an understatement. There are a few virtual products availabe, we are now moving to the VMWare environment. This now brings along the possibilities of snap shots. This means that if your vm server instance dies, using the snap shot you basically have an image of it and it can be used to rebuild the exact server as it was (at the time of the snap shot). Having a snap shot is great but I believe that it requires the same space allocation that the original server has. This is where I am having a battle with my server guys. You could also look at server groups. Having more than one app server under a load balancer would allow you to operate on the balance of the servers if one was to become inoperable. It’s a cash thing though. I have put the ball back in the businesses court requesting that they need to determine the max downtime of a critical service and then based on that, what are they prepared to pay to make it possible, or pay in penalties. Kind Regards, Basil Webster Remedy Developer Siemens Southern Africa IT Solutions and Services (Pty) Ltd Infrastructure Operations 300 Janadel Avenue, Halfway House, 1685 T : +27 11 652 7523 F : +27 86 506 2883 M : +27 82 452 9389 basil.webs...@siemens.com www.siemens.co.za From:Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Richard Copits Sent: 03 March 2009 20:13 To: arslist@ARSLIST.ORG Subject: Suggestions wanted for backing up We are in the final stages of getting our Remedy 7.1 ITSM application ready to go to production status. We have an application server, a Web server and a Database server. The application and web servers are on virtual servers. We currently use Tivoli to do backups of the Other servers that we have. I’d like to see if we can use Tivoli to backup our Remedy system but I’m not sure of just “what” needs to Be backed up on the app and web servers. The SQL database is backed up by the database group so that’s no worry. However, I want To be sure that I get what needs to be backed up for the app and web servers to be recoverable. I don’t want to spend another two or Three days rebuilding everything if the MS server that hosts the vm’s goes down. So, what should I be backing up? Best practices? Are There any good documents I should be reading to make the systems reasonably easy to recover? Thank you!! Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. Disclaimer and Confidentiality Note This e-mail communication, its attachments, if any, and any rights attaching to it are, unless the context clearly indicates
Re: Suggestions wanted for backing up....
Interesting thought……since we have the applications on one server and the web stuff on another, is this still possible? Is there a reference you could recommend where I could read more about that? Thanks! From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe DeSouza Sent: Wednesday, March 04, 2009 10:12 AM To: arslist@ARSLIST.ORG Subject: Re: Suggestions wanted for backing up ** Richard, Why don't you look at the option of having server groups where it really wont impact that much apart from a performance standpoint if one server is down for a slightly extended period of time while being rebuilt? Joe From: Richard Copits richard.cop...@bwc.state.oh.us To: arslist@ARSLIST.ORG Sent: Wednesday, March 4, 2009 7:27:10 AM Subject: Re: Suggestions wanted for backing up ** Thanks Joe….. we’re using a VM and have thought about using snapshots, but if the server fails then the snapshot Is gone also…unless we move the snapshot off to another sever.. but the gating factor for me is how long the Service desk is willing to be down if I have to rebuild….and I estimate that it could take three or four days to do That, patch everything, etc. I think I’m going to be looking at something like Ghost that will image the server and everything. After imaging I can move the image to another server so it’s relatively safe. A product like Acronis will allow me to make a Master backup and then ongoing differential backups, so that may be a good solution. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Webster, Basil Sent: Wednesday, March 04, 2009 4:19 AM To: arslist@ARSLIST.ORG Subject: Re: Suggestions wanted for backing up ** Hi Richard, We have a similar situation. I have no idea of how Tivoli operates but we are using a network backup product called NetBackup. Having had the unfortunate experience of having to recover from a hardware failure, I got the bad news that the backup guys could not “create” a server in the state of the last successful backup, they could only dump data contained in the directories. So I had to do a full OS install with all the apps etc and them took specific data contained in the backups and used it, like the AR licensing, config etc. This took me nearly a week. To say that the business was not happy would be an understatement. There are a few virtual products availabe, we are now moving to the VMWare environment. This now brings along the possibilities of snap shots. This means that if your vm server instance dies, using the snap shot you basically have an image of it and it can be used to rebuild the exact server as it was (at the time of the snap shot). Having a snap shot is great but I believe that it requires the same space allocation that the original server has. This is where I am having a battle with my server guys. You could also look at server groups. Having more than one app server under a load balancer would allow you to operate on the balance of the servers if one was to become inoperable. It’s a cash thing though. I have put the ball back in the businesses court requesting that they need to determine the max downtime of a critical service and then based on that, what are they prepared to pay to make it possible, or pay in penalties. Kind Regards, Basil Webster Remedy Developer Siemens Southern Africa IT Solutions and Services (Pty) Ltd Infrastructure Operations 300 Janadel Avenue, Halfway House, 1685 T : +27 11 652 7523 F : +27 86 506 2883 M : +27 82 452 9389 basil.webs...@siemens.com mailto:basil.webs...@siemens.com www.siemens.co.za http://www.siemens.co.za/ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Richard Copits Sent: 03 March 2009 20:13 To: arslist@ARSLIST.ORG Subject: Suggestions wanted for backing up We are in the final stages of getting our Remedy 7.1 ITSM application ready to go to production status. We have an application server, a Web server and a Database server. The application and web servers are on virtual servers. We currently use Tivoli to do backups of the Other servers that we have. I’d like to see if we can use Tivoli to backup our Remedy system but I’m not sure of just “what” needs to Be backed up on the app and web servers. The SQL database is backed up by the database group so that’s no worry. However, I want To be sure that I get what needs to be backed up for the app and web servers to be recoverable. I don’t want to spend another two or Three days rebuilding everything if the MS server that hosts the vm’s goes down. So, what should I be backing up? Best practices? Are There any good documents I should be reading to make the systems reasonably easy to recover? Thank you!! Portions of this message
Re: Suggestions wanted for backing up....
Absolutely.. I am assuming you mean you have your ARS on one server and the Mid-Tier application on another? Both can be load balanced separately. Thats how most load balanced environments are like. I am not sure if I have documents on it, but I've been through this exercise several times over. I'll see if I can find some white paper or something that I can send you.. Cheers Joe From: Richard Copits richard.cop...@bwc.state.oh.us To: arslist@ARSLIST.ORG Sent: Wednesday, March 4, 2009 10:16:10 AM Subject: Re: Suggestions wanted for backing up Interesting thought……since we have the applications on one server and the web stuff on another, is this still possible? Is there a reference you could recommend where I could read more about that? Thanks! From:Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe DeSouza Sent: Wednesday, March 04, 2009 10:12 AM To: arslist@ARSLIST.ORG Subject: Re: Suggestions wanted for backing up ** Richard, Why don't you look at the option of having server groups where it really wont impact that much apart from a performance standpoint if one server is down for a slightly extended period of time while being rebuilt? Joe From:Richard Copits richard.cop...@bwc.state.oh.us To: arslist@ARSLIST.ORG Sent: Wednesday, March 4, 2009 7:27:10 AM Subject: Re: Suggestions wanted for backing up ** Thanks Joe….. we’re using a VM and have thought about using snapshots, but if the server fails then the snapshot Is gone also…unless we move the snapshot off to another sever.. but the gating factor for me is how long the Service desk is willing to be down if I have to rebuild….and I estimate that it could take three or four days to do That, patch everything, etc. I think I’m going to be looking at something like Ghost that will image the server and everything. After imaging I can move the image to another server so it’s relatively safe. A product like Acronis will allow me to make a Master backup and then ongoing differential backups, so that may be a good solution. From:Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Webster, Basil Sent: Wednesday, March 04, 2009 4:19 AM To: arslist@ARSLIST.ORG Subject: Re: Suggestions wanted for backing up ** Hi Richard, We have a similar situation. I have no idea of how Tivoli operates but we are using a network backup product called NetBackup. Having had the unfortunate experience of having to recover from a hardware failure, I got the bad news that the backup guys could not “create” a server in the state of the last successful backup, they could only dump data contained in the directories. So I had to do a full OS install with all the apps etc and them took specific data contained in the backups and used it, like the AR licensing, config etc. This took me nearly a week. To say that the business was not happy would be an understatement. There are a few virtual products availabe, we are now moving to the VMWare environment. This now brings along the possibilities of snap shots. This means that if your vm server instance dies, using the snap shot you basically have an image of it and it can be used to rebuild the exact server as it was (at the time of the snap shot). Having a snap shot is great but I believe that it requires the same space allocation that the original server has. This is where I am having a battle with my server guys. You could also look at server groups. Having more than one app server under a load balancer would allow you to operate on the balance of the servers if one was to become inoperable. It’s a cash thing though. I have put the ball back in the businesses court requesting that they need to determine the max downtime of a critical service and then based on that, what are they prepared to pay to make it possible, or pay in penalties. Kind Regards, Basil Webster Remedy Developer Siemens Southern Africa IT Solutions and Services (Pty) Ltd Infrastructure Operations 300 Janadel Avenue, Halfway House, 1685 T : +27 11 652 7523 F : +27 86 506 2883 M : +27 82 452 9389 basil.webs...@siemens.com www.siemens.co.za From:Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Richard Copits Sent: 03 March 2009 20:13 To: arslist@ARSLIST.ORG Subject: Suggestions wanted for backing up We are in the final stages of getting our Remedy 7.1 ITSM application ready to go to production status. We have an application server, a Web server and a Database server. The application and web servers are on virtual servers. We currently use Tivoli to do backups of the Other servers that we have. I’d like to see if we can use Tivoli to backup our Remedy system but I’m not sure of just “what” needs to Be backed up on the app and web servers. The SQL
Re: Suggestions wanted for backing up....
Thank you! From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe DeSouza Sent: Wednesday, March 04, 2009 10:23 AM To: arslist@ARSLIST.ORG Subject: Re: Suggestions wanted for backing up ** Absolutely.. I am assuming you mean you have your ARS on one server and the Mid-Tier application on another? Both can be load balanced separately. Thats how most load balanced environments are like. I am not sure if I have documents on it, but I've been through this exercise several times over. I'll see if I can find some white paper or something that I can send you.. Cheers Joe From: Richard Copits richard.cop...@bwc.state.oh.us To: arslist@ARSLIST.ORG Sent: Wednesday, March 4, 2009 10:16:10 AM Subject: Re: Suggestions wanted for backing up Interesting thought……since we have the applications on one server and the web stuff on another, is this still possible? Is there a reference you could recommend where I could read more about that? Thanks! From: Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message.
Re: Suggestions wanted for backing up....
It may be very useful to know if you are on Windows or UNIX.. If you are on UNIX, backing up the file structure where the ARS is installed along with the backup of /etc/arsystem directories and the /etc/rpc file is more than enough. Also it would be useful to backup the 2 .cat files in the UNIX catalog directories.. If you are on windows you might have to backup your registry besides just the install path. Joe From: Richard Copits richard.cop...@bwc.state.oh.us To: arslist@ARSLIST.ORG Sent: Tuesday, March 3, 2009 1:13:02 PM Subject: Suggestions wanted for backing up ** We are in the final stages of getting our Remedy 7.1 ITSM application ready to go to production status. We have an application server, a Web server and a Database server. The application and web servers are on virtual servers. We currently use Tivoli to do backups of the Other servers that we have. I’d like to see if we can use Tivoli to backup our Remedy system but I’m not sure of just “what” needs to Be backed up on the app and web servers. The SQL database is backed up by the database group so that’s no worry. However, I want To be sure that I get what needs to be backed up for the app and web servers to be recoverable. I don’t want to spend another two or Three days rebuilding everything if the MS server that hosts the vm’s goes down. So, what should I be backing up? Best practices? Are There any good documents I should be reading to make the systems reasonably easy to recover? Thank you!! Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
Re: Suggestions wanted for backing up....
We’re on windows…..but it would seem that backing up the registry would also catch a lot Of “transitory” data that wouldn’t really be of any use and just take up space. It’s not clear to Me that I’d know just what (other than the stuff under the software tab…) such as PID’s to Back up… From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe DeSouza Sent: Tuesday, March 03, 2009 2:35 PM To: arslist@ARSLIST.ORG Subject: Re: Suggestions wanted for backing up ** It may be very useful to know if you are on Windows or UNIX.. If you are on UNIX, backing up the file structure where the ARS is installed along with the backup of /etc/arsystem directories and the /etc/rpc file is more than enough. Also it would be useful to backup the 2 .cat files in the UNIX catalog directories.. If you are on windows you might have to backup your registry besides just the install path. Joe From: Richard Copits richard.cop...@bwc.state.oh.us To: arslist@ARSLIST.ORG Sent: Tuesday, March 3, 2009 1:13:02 PM Subject: Suggestions wanted for backing up ** We are in the final stages of getting our Remedy 7.1 ITSM application ready to go to production status. We have an application server, a Web server and a Database server. The application and web servers are on virtual servers. We currently use Tivoli to do backups of the Other servers that we have. I’d like to see if we can use Tivoli to backup our Remedy system but I’m not sure of just “what” needs to Be backed up on the app and web servers. The SQL database is backed up by the database group so that’s no worry. However, I want To be sure that I get what needs to be backed up for the app and web servers to be recoverable. I don’t want to spend another two or Three days rebuilding everything if the MS server that hosts the vm’s goes down. So, what should I be backing up? Best practices? Are There any good documents I should be reading to make the systems reasonably easy to recover? Thank you!! Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. __Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are html___ Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message.
Re: Suggestions wanted for backing up....
Richard, Thats what I hate about Windows. Program installations keeps junk all over the place. The best you could do in that situation is find the keys, and export just the keys and then hope that merging the backed up .reg file that is generated is enough to recreate that entry in the registry. I just tried a simple experiment of backing up my Remedy client key Remedy, deleting that key after exporting it and then merging the exported key, and it looks like it is working as it did recreate the key. Beyond that I am not much of a windows guru to comment on whether or not that would be fool proof.. Cheers Joe From: Richard Copits richard.cop...@bwc.state.oh.us To: arslist@ARSLIST.ORG Sent: Tuesday, March 3, 2009 4:03:27 PM Subject: Re: Suggestions wanted for backing up We’re on windows…..but it would seem that backing up the registry would also catch a lot Of “transitory” data that wouldn’t really be of any use and just take up space. It’s not clear to Me that I’d know just what (other than the stuff under the software tab…) such as PID’s to Back up… From:Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe DeSouza Sent: Tuesday, March 03, 2009 2:35 PM To: arslist@ARSLIST.ORG Subject: Re: Suggestions wanted for backing up ** It may be very useful to know if you are on Windows or UNIX.. If you are on UNIX, backing up the file structure where the ARS is installed along with the backup of /etc/arsystem directories and the /etc/rpc file is more than enough. Also it would be useful to backup the 2 .cat files in the UNIX catalog directories.. If you are on windows you might have to backup your registry besides just the install path. Joe From:Richard Copits richard.cop...@bwc.state.oh.us To: arslist@ARSLIST.ORG Sent: Tuesday, March 3, 2009 1:13:02 PM Subject: Suggestions wanted for backing up ** We are in the final stages of getting our Remedy 7.1 ITSM application ready to go to production status. We have an application server, a Web server and a Database server. The application and web servers are on virtual servers. We currently use Tivoli to do backups of the Other servers that we have. I’d like to see if we can use Tivoli to backup our Remedy system but I’m not sure of just “what” needs to Be backed up on the app and web servers. The SQL database is backed up by the database group so that’s no worry. However, I want To be sure that I get what needs to be backed up for the app and web servers to be recoverable. I don’t want to spend another two or Three days rebuilding everything if the MS server that hosts the vm’s goes down. So, what should I be backing up? Best practices? Are There any good documents I should be reading to make the systems reasonably easy to recover? Thank you!! Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
Re: Suggestions wanted....
I sent it Joe to your Yahoo account. Ty On Wed, Aug 6, 2008 at 3:20 PM, Joe DeSouza [EMAIL PROTECTED] wrote: ** Could you throw a copy my way? I would try logging in but I think I may have forgotten my username and password on the dev network as its been a while I've been there.. Joe - Original Message From: T. Dee [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Wednesday, August 6, 2008 2:05:57 PM Subject: Re: Suggestions wanted I got it from Sean - if you want I can send it to you - just email me. Ty On Wed, Aug 6, 2008 at 1:27 PM, Richard Copits [EMAIL PROTECTED] wrote: I went on the Developer network site but didn't see any program that looked like the log analyzer. Any idea where else it might be or anyone who would be comfortable sending a copy via email to my alternate email address (the spam filter here kills most attachments...). Thanks. -Original Message- From: Action Request System discussion __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Suggestions wanted....
I went on the Developer network site but didn't see any program that looked like the log analyzer. Any idea where else it might be or anyone who would be comfortable sending a copy via email to my alternate email address (the spam filter here kills most attachments...). Thanks. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Matt Reinfeldt Sent: Tuesday, August 05, 2008 12:59 PM To: arslist@ARSLIST.ORG Subject: Re: Suggestions wanted Sean, I use that tool all the time. I believe it is still available for download if you're logged in to the Developer's Network site. Enjoy! Matt R. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Garrison, Sean (Norcross) Sent: Tuesday, August 05, 2008 11:28 AM To: arslist@ARSLIST.ORG Subject: Re: Suggestions wanted Although this won't solve all of your requirements ... there used to be a tool called AR System Log Analyzer (arwklga.exe) that a BMC rep gave me. I don't know where to get it anymore (maybe someone on the list knows?). I think BMC wrote it. It compiled all of your SQL, API, Arerror, ARFilter logs into one and then analyzed the performance for you. It even could put it into a html file for you to be able to read it. I don't think it would combine things like your assignment engine logs, CMDB Logs etc. though. It might It doesn't do it real-time though. You have to generate the logs, run a command that compiles them all into one giant file and then run the analyzer. It is a major chore but the results can be sometimes worth it. Sean -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kurniadi Sent: Tuesday, August 05, 2008 12:04 PM To: arslist@ARSLIST.ORG Subject: Re: Suggestions wanted I use Notepad++ to read any ARS log, it's free and you can create user define syntax highlighting there. For example, It's much easier to focus debugging a filter log by assigning line containing these string: -- Failed qualification with red color, Passed -- perform actions with green color, and Checking with blue color. -- Kur Niadi On Sat, Aug 2, 2008 at 1:14 AM, Richard Copits [EMAIL PROTECTED] wrote: ** I'm trying to find a couple of utility programs to run and hoping that someone may have some suggestions on where to find them: 1. A program that will make it easier to read the contents of any of the many log files that are available under a full 7.x ITIL system. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Suggestions wanted....
I got it from Sean - if you want I can send it to you - just email me. Ty On Wed, Aug 6, 2008 at 1:27 PM, Richard Copits [EMAIL PROTECTED] wrote: I went on the Developer network site but didn't see any program that looked like the log analyzer. Any idea where else it might be or anyone who would be comfortable sending a copy via email to my alternate email address (the spam filter here kills most attachments...). Thanks. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Matt Reinfeldt Sent: Tuesday, August 05, 2008 12:59 PM To: arslist@ARSLIST.ORG Subject: Re: Suggestions wanted Sean, I use that tool all the time. I believe it is still available for download if you're logged in to the Developer's Network site. Enjoy! Matt R. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Garrison, Sean (Norcross) Sent: Tuesday, August 05, 2008 11:28 AM To: arslist@ARSLIST.ORG Subject: Re: Suggestions wanted Although this won't solve all of your requirements ... there used to be a tool called AR System Log Analyzer (arwklga.exe) that a BMC rep gave me. I don't know where to get it anymore (maybe someone on the list knows?). I think BMC wrote it. It compiled all of your SQL, API, Arerror, ARFilter logs into one and then analyzed the performance for you. It even could put it into a html file for you to be able to read it. I don't think it would combine things like your assignment engine logs, CMDB Logs etc. though. It might It doesn't do it real-time though. You have to generate the logs, run a command that compiles them all into one giant file and then run the analyzer. It is a major chore but the results can be sometimes worth it. Sean -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kurniadi Sent: Tuesday, August 05, 2008 12:04 PM To: arslist@ARSLIST.ORG Subject: Re: Suggestions wanted I use Notepad++ to read any ARS log, it's free and you can create user define syntax highlighting there. For example, It's much easier to focus debugging a filter log by assigning line containing these string: -- Failed qualification with red color, Passed -- perform actions with green color, and Checking with blue color. -- Kur Niadi On Sat, Aug 2, 2008 at 1:14 AM, Richard Copits [EMAIL PROTECTED] wrote: ** I'm trying to find a couple of utility programs to run and hoping that someone may have some suggestions on where to find them: 1. A program that will make it easier to read the contents of any of the many log files that are available under a full 7.x ITIL system. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Suggestions wanted....
Thanks! Please send to [EMAIL PROTECTED] -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of T. Dee Sent: Wednesday, August 06, 2008 2:06 PM To: arslist@ARSLIST.ORG Subject: Re: Suggestions wanted I got it from Sean - if you want I can send it to you - just email me. Ty On Wed, Aug 6, 2008 at 1:27 PM, Richard Copits [EMAIL PROTECTED] wrote: I went on the Developer network site but didn't see any program that looked like the log analyzer. Any idea where else it might be or anyone who would be comfortable sending a copy via email to my alternate email address (the spam filter here kills most attachments...). Thanks. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Matt Reinfeldt Sent: Tuesday, August 05, 2008 12:59 PM To: arslist@ARSLIST.ORG Subject: Re: Suggestions wanted Sean, I use that tool all the time. I believe it is still available for download if you're logged in to the Developer's Network site. Enjoy! Matt R. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Garrison, Sean (Norcross) Sent: Tuesday, August 05, 2008 11:28 AM To: arslist@ARSLIST.ORG Subject: Re: Suggestions wanted Although this won't solve all of your requirements ... there used to be a tool called AR System Log Analyzer (arwklga.exe) that a BMC rep gave me. I don't know where to get it anymore (maybe someone on the list knows?). I think BMC wrote it. It compiled all of your SQL, API, Arerror, ARFilter logs into one and then analyzed the performance for you. It even could put it into a html file for you to be able to read it. I don't think it would combine things like your assignment engine logs, CMDB Logs etc. though. It might It doesn't do it real-time though. You have to generate the logs, run a command that compiles them all into one giant file and then run the analyzer. It is a major chore but the results can be sometimes worth it. Sean -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kurniadi Sent: Tuesday, August 05, 2008 12:04 PM To: arslist@ARSLIST.ORG Subject: Re: Suggestions wanted I use Notepad++ to read any ARS log, it's free and you can create user define syntax highlighting there. For example, It's much easier to focus debugging a filter log by assigning line containing these string: -- Failed qualification with red color, Passed -- perform actions with green color, and Checking with blue color. -- Kur Niadi On Sat, Aug 2, 2008 at 1:14 AM, Richard Copits [EMAIL PROTECTED] wrote: ** I'm trying to find a couple of utility programs to run and hoping that someone may have some suggestions on where to find them: 1. A program that will make it easier to read the contents of any of the many log files that are available under a full 7.x ITIL system. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Suggestions wanted....
Richard, I just logged in and searched for ARLogAnalyzer and found 3 links for it. Here is one of them: http://developer.bmc.com:8080/jiveProd/entry!default.jspa?categoryID=507ext ernalID=1010fromSearchPage=true Matt -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Richard Copits Sent: Wednesday, August 06, 2008 12:27 PM To: arslist@ARSLIST.ORG Subject: Re: Suggestions wanted I went on the Developer network site but didn't see any program that looked like the log analyzer. Any idea where else it might be or anyone who would be comfortable sending a copy via email to my alternate email address (the spam filter here kills most attachments...). Thanks. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Matt Reinfeldt Sent: Tuesday, August 05, 2008 12:59 PM To: arslist@ARSLIST.ORG Subject: Re: Suggestions wanted Sean, I use that tool all the time. I believe it is still available for download if you're logged in to the Developer's Network site. Enjoy! Matt R. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Garrison, Sean (Norcross) Sent: Tuesday, August 05, 2008 11:28 AM To: arslist@ARSLIST.ORG Subject: Re: Suggestions wanted Although this won't solve all of your requirements ... there used to be a tool called AR System Log Analyzer (arwklga.exe) that a BMC rep gave me. I don't know where to get it anymore (maybe someone on the list knows?). I think BMC wrote it. It compiled all of your SQL, API, Arerror, ARFilter logs into one and then analyzed the performance for you. It even could put it into a html file for you to be able to read it. I don't think it would combine things like your assignment engine logs, CMDB Logs etc. though. It might It doesn't do it real-time though. You have to generate the logs, run a command that compiles them all into one giant file and then run the analyzer. It is a major chore but the results can be sometimes worth it. Sean -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kurniadi Sent: Tuesday, August 05, 2008 12:04 PM To: arslist@ARSLIST.ORG Subject: Re: Suggestions wanted I use Notepad++ to read any ARS log, it's free and you can create user define syntax highlighting there. For example, It's much easier to focus debugging a filter log by assigning line containing these string: -- Failed qualification with red color, Passed -- perform actions with green color, and Checking with blue color. -- Kur Niadi On Sat, Aug 2, 2008 at 1:14 AM, Richard Copits [EMAIL PROTECTED] wrote: ** I'm trying to find a couple of utility programs to run and hoping that someone may have some suggestions on where to find them: 1. A program that will make it easier to read the contents of any of the many log files that are available under a full 7.x ITIL system. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Suggestions wanted....
Found it - Thanks! However, there's a note at the bottom of the program download page that says it doesn't work for 7.x and higher and asks if the sources are available.bummer. Could one of the BMC folk listening in speak to the possibility of the sources being made available - if indeed there is not a working version for 7.x systems? Thanks!! -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Matt Reinfeldt Sent: Wednesday, August 06, 2008 2:47 PM To: arslist@ARSLIST.ORG Subject: Re: Suggestions wanted Richard, I just logged in and searched for ARLogAnalyzer and found 3 links for it. Here is one of them: http://developer.bmc.com:8080/jiveProd/entry!default.jspa?categoryID=507 ext ernalID=1010fromSearchPage=true Matt -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Richard Copits Sent: Wednesday, August 06, 2008 12:27 PM To: arslist@ARSLIST.ORG Subject: Re: Suggestions wanted I went on the Developer network site but didn't see any program that looked like the log analyzer. Any idea where else it might be or anyone who would be comfortable sending a copy via email to my alternate email address (the spam filter here kills most attachments...). Thanks. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Matt Reinfeldt Sent: Tuesday, August 05, 2008 12:59 PM To: arslist@ARSLIST.ORG Subject: Re: Suggestions wanted Sean, I use that tool all the time. I believe it is still available for download if you're logged in to the Developer's Network site. Enjoy! Matt R. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Garrison, Sean (Norcross) Sent: Tuesday, August 05, 2008 11:28 AM To: arslist@ARSLIST.ORG Subject: Re: Suggestions wanted Although this won't solve all of your requirements ... there used to be a tool called AR System Log Analyzer (arwklga.exe) that a BMC rep gave me. I don't know where to get it anymore (maybe someone on the list knows?). I think BMC wrote it. It compiled all of your SQL, API, Arerror, ARFilter logs into one and then analyzed the performance for you. It even could put it into a html file for you to be able to read it. I don't think it would combine things like your assignment engine logs, CMDB Logs etc. though. It might It doesn't do it real-time though. You have to generate the logs, run a command that compiles them all into one giant file and then run the analyzer. It is a major chore but the results can be sometimes worth it. Sean -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kurniadi Sent: Tuesday, August 05, 2008 12:04 PM To: arslist@ARSLIST.ORG Subject: Re: Suggestions wanted I use Notepad++ to read any ARS log, it's free and you can create user define syntax highlighting there. For example, It's much easier to focus debugging a filter log by assigning line containing these string: -- Failed qualification with red color, Passed -- perform actions with green color, and Checking with blue color. -- Kur Niadi On Sat, Aug 2, 2008 at 1:14 AM, Richard Copits [EMAIL PROTECTED] wrote: ** I'm trying to find a couple of utility programs to run and hoping that someone may have some suggestions on where to find them: 1. A program that will make it easier to read the contents of any of the many log files that are available under a full 7.x ITIL system. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist
Re: Suggestions wanted....
I use Notepad++ to read any ARS log, it's free and you can create user define syntax highlighting there. For example, It's much easier to focus debugging a filter log by assigning line containing these string: -- Failed qualification with red color, Passed -- perform actions with green color, and Checking with blue color. -- Kur Niadi On Sat, Aug 2, 2008 at 1:14 AM, Richard Copits [EMAIL PROTECTED] wrote: ** I'm trying to find a couple of utility programs to run and hoping that someone may have some suggestions on where to find them: 1. A program that will make it easier to read the contents of any of the many log files that are available under a full 7.x ITIL system. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Suggestions wanted....
Although this won't solve all of your requirements ... there used to be a tool called AR System Log Analyzer (arwklga.exe) that a BMC rep gave me. I don't know where to get it anymore (maybe someone on the list knows?). I think BMC wrote it. It compiled all of your SQL, API, Arerror, ARFilter logs into one and then analyzed the performance for you. It even could put it into a html file for you to be able to read it. I don't think it would combine things like your assignment engine logs, CMDB Logs etc. though. It might It doesn't do it real-time though. You have to generate the logs, run a command that compiles them all into one giant file and then run the analyzer. It is a major chore but the results can be sometimes worth it. Sean -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kurniadi Sent: Tuesday, August 05, 2008 12:04 PM To: arslist@ARSLIST.ORG Subject: Re: Suggestions wanted I use Notepad++ to read any ARS log, it's free and you can create user define syntax highlighting there. For example, It's much easier to focus debugging a filter log by assigning line containing these string: -- Failed qualification with red color, Passed -- perform actions with green color, and Checking with blue color. -- Kur Niadi On Sat, Aug 2, 2008 at 1:14 AM, Richard Copits [EMAIL PROTECTED] wrote: ** I'm trying to find a couple of utility programs to run and hoping that someone may have some suggestions on where to find them: 1. A program that will make it easier to read the contents of any of the many log files that are available under a full 7.x ITIL system. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Suggestions wanted....
Sean, I use that tool all the time. I believe it is still available for download if you're logged in to the Developer's Network site. Enjoy! Matt R. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Garrison, Sean (Norcross) Sent: Tuesday, August 05, 2008 11:28 AM To: arslist@ARSLIST.ORG Subject: Re: Suggestions wanted Although this won't solve all of your requirements ... there used to be a tool called AR System Log Analyzer (arwklga.exe) that a BMC rep gave me. I don't know where to get it anymore (maybe someone on the list knows?). I think BMC wrote it. It compiled all of your SQL, API, Arerror, ARFilter logs into one and then analyzed the performance for you. It even could put it into a html file for you to be able to read it. I don't think it would combine things like your assignment engine logs, CMDB Logs etc. though. It might It doesn't do it real-time though. You have to generate the logs, run a command that compiles them all into one giant file and then run the analyzer. It is a major chore but the results can be sometimes worth it. Sean -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kurniadi Sent: Tuesday, August 05, 2008 12:04 PM To: arslist@ARSLIST.ORG Subject: Re: Suggestions wanted I use Notepad++ to read any ARS log, it's free and you can create user define syntax highlighting there. For example, It's much easier to focus debugging a filter log by assigning line containing these string: -- Failed qualification with red color, Passed -- perform actions with green color, and Checking with blue color. -- Kur Niadi On Sat, Aug 2, 2008 at 1:14 AM, Richard Copits [EMAIL PROTECTED] wrote: ** I'm trying to find a couple of utility programs to run and hoping that someone may have some suggestions on where to find them: 1. A program that will make it easier to read the contents of any of the many log files that are available under a full 7.x ITIL system. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Suggestions wanted....
Where might I find it? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kurniadi Sent: Tuesday, August 05, 2008 12:04 PM To: arslist@ARSLIST.ORG Subject: Re: Suggestions wanted I use Notepad++ to read any ARS log, it's free and you can create user define syntax highlighting there. For example, It's much easier to focus debugging a filter log by assigning line containing these string: -- Failed qualification with red color, Passed -- perform actions with green color, and Checking with blue color. -- Kur Niadi On Sat, Aug 2, 2008 at 1:14 AM, Richard Copits [EMAIL PROTECTED] wrote: ** I'm trying to find a couple of utility programs to run and hoping that someone may have some suggestions on where to find them: 1. A program that will make it easier to read the contents of any of the many log files that are available under a full 7.x ITIL system. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Suggestions wanted....
The User Tool installs ARLogDisplay.exe Check your User Tool install directory. James On Aug 1, 9:20 pm, Joe D'Souza [EMAIL PROTECTED] wrote: I am not sure if there is anything available for reading logs - there used to be a log timer utility years ago to measure time between the send and receive of an API to measure performance benchmarks.. Richard, However for checking the versions, all you need to do is query the SHARE:Applications Properties form in the AR System to get the complete versioning information down to patch level. If that is not enough you could create a report to report that form. To get the version of the AR System you can run the arsignal command with the -version switch to get the version and patch level of the AR System server.. you can also run the admin tool from the command line to get some configuration information of the AR Server. Type aradmin /? to get complete help on how to use the aradmin tool from the command line. Hope this helps.. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Richard Copits Sent: Friday, August 01, 2008 2:14 PM To: [EMAIL PROTECTED] Subject: Suggestions wanted ** I’m trying to find a couple of utility programs to run and hoping that someone may have some suggestions on where to find them: 1. A program that will make it easier to read the contents of any of the many log files that are available under a full 7.x ITIL system. 2. A program that will display the version and patch level of each component of a fully configured/installed Remedy 7.x ITIL system. Thank you for any help, suggestions, etc. Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. No virus found in this outgoing message. Checked by AVG. Version: 7.5.526 / Virus Database: 270.5.10/1585 - Release Date: 8/1/2008 6:39 AM ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org Platinum Sponsor:www.rmsportal.comARSlist: Where the Answers Are- Hide quoted text - - Show quoted text - ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Suggestions wanted....
I am not sure if there is anything available for reading logs - there used to be a log timer utility years ago to measure time between the send and receive of an API to measure performance benchmarks.. Richard, However for checking the versions, all you need to do is query the SHARE:Applications Properties form in the AR System to get the complete versioning information down to patch level. If that is not enough you could create a report to report that form. To get the version of the AR System you can run the arsignal command with the -version switch to get the version and patch level of the AR System server.. you can also run the admin tool from the command line to get some configuration information of the AR Server. Type aradmin /? to get complete help on how to use the aradmin tool from the command line. Hope this helps.. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Richard Copits Sent: Friday, August 01, 2008 2:14 PM To: arslist@ARSLIST.ORG Subject: Suggestions wanted ** I’m trying to find a couple of utility programs to run and hoping that someone may have some suggestions on where to find them: 1. A program that will make it easier to read the contents of any of the many log files that are available under a full 7.x ITIL system. 2. A program that will display the version and patch level of each component of a fully configured/installed Remedy 7.x ITIL system. Thank you for any help, suggestions, etc. Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. No virus found in this outgoing message. Checked by AVG. Version: 7.5.526 / Virus Database: 270.5.10/1585 - Release Date: 8/1/2008 6:39 AM ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Suggestions for Tool to automate/document task management workflow
Since you're already a BMC customer, you may wish to ask this question of your BCM sales representative. BMC has several solutions that can help you on this subject. Specifically, ask about Service Automation and Run Book Automation (RBA). Because they are BMC solutions they also have the added benefit of leveraging your existing CMDB and ITSM implementations. -David J. Easter Sr. Product Manager, Service Management Business Unit 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: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Payne, George Sent: Wednesday, February 27, 2008 1:52 PM To: arslist@ARSLIST.ORG Subject: OT:Suggestions for Tool to automate/document task management workflow ** Dear Listers, Current Environment: ARS 7.0.01 P05 on AIX 5.3 Mid-Tier 7.0.01 P05 on separate AIX 5.3 Oracle 10g Database on a third AIX 5.3 ITSM 7.0.01 P05 - Asset, Change, Incident, Problem, and Service Level Management CMDB 2.0.1 not patched My management team is very interested in finding a tool to help with our implementation of ITIL and Best Practices. The best possible solution would help us focus on the Best Practices or Industry Standards for common tasks such as standing up new servers, decommissioning items from Data Center and moving items within the data center. This tool would help us both document our current workflows (preferably by loading task group templates that have already been created in Change Management) and allow us to compare and contrast that to Industry Standards as well as plan future improvements. Is there anything out there like that already? Thanks, Gp George Payne Corporate Applications Developer Electric Reliability Council of Texas (512) 248-3940 [EMAIL PROTECTED] __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Suggestions for Tool to automate/document task management workflow
George, Blatant Plug: Yes there sure is, it's called [EMAIL PROTECTED] and unlike ISTMx our application works ! While the boyz over an BMC struggle to refine their solution, ours is rock solid and we don't charge seat or individual application licenses. Need an ITIL application ? - We are that ! Our application is easily 80% Data driven - We do Templates !! Need to Model Facilities in a CMDB ? - We do that ! Need to Model a Telephony system in a CMDB ? - We do that ! Need to Model an F15 Tomcat and armaments in a CMDB ? - We do that ! Need to graphically display any CI hierarchy in your CMDB (Facilities, Aircraft, IT assets etc) ? - We do that with our own developed Xtreme Asset tool. Need a (RIA) User Friendly interface to allow your customers on create requests for service - We do that with our own developed Xtreme Console. Yes it works on a MAC, or any browser and Yes you get the source code Need a (RIA) flexible Dashboard interface to graphically depict Metrics in real-time - We do that with our own developed Xtreme Dashboard. Want to PAY extra for your Test Server software seat licenses - we DON'T do that ! Want to PAY extra for your support $$$ - we DON'T do that, actually our support is $25,000 per year BECAUSE IT IS A FAIR PRICE !!! Do you want a solution provider that is interested in your business the way you do business or would you prefer to shoe-horn an application that may take you a year to implement Visit us and take a look at what we can offer: http://www.buoyantsolutions.net/ESS.html http://www.buoyantsolutions.net/ESS.html http://www.buoyantsolutions.net/essaw.htm Look at our bundled fixed price solution that is truly end-to-end and includes full implementation in 12 weeks or less ! Contact us off list to arrange a convenient webcast to review what we can do for you today. Regards...Gidd _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Payne, George Sent: Wednesday, February 27, 2008 1:52 PM To: arslist@ARSLIST.ORG Subject: OT:Suggestions for Tool to automate/document task management workflow ** Dear Listers, Current Environment: ARS 7.0.01 P05 on AIX 5.3 Mid-Tier 7.0.01 P05 on separate AIX 5.3 Oracle 10g Database on a third AIX 5.3 ITSM 7.0.01 P05 - Asset, Change, Incident, Problem, and Service Level Management CMDB 2.0.1 not patched My management team is very interested in finding a tool to help with our implementation of ITIL and Best Practices. The best possible solution would help us focus on the Best Practices or Industry Standards for common tasks such as standing up new servers, decommissioning items from Data Center and moving items within the data center. This tool would help us both document our current workflows (preferably by loading task group templates that have already been created in Change Management) and allow us to compare and contrast that to Industry Standards as well as plan future improvements. Is there anything out there like that already? Thanks, Gp George Payne Corporate Applications Developer Electric Reliability Council of Texas (512) 248-3940 [EMAIL PROTECTED] __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Suggestions for Tool to automate/document task management workflow
Recently I had Gidd and his colleague David Sanders demo the product to me and it does look very impressive. Definitely worth checking out if you aren't already committed to implementing ITSM 7 as in if you have already purchased ITSM 7... [EMAIL PROTECTED] is everything Gidd says, and most of it resides on the Core Remedy AR System Server - so you got to invest very little in other third party core technologies to implement it.. Besides the functionality and the aesthetic value of their system what I like most is the time taken to implement it... With that kind of a timeframe, you do not have to be ready to gear for another project to update the system with your changing business needs by the time you are ready to deploy your applications.. (RANT) which is how Remedy applications 'used' to be... Joe - Original Message From: Gidd [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Wednesday, February 27, 2008 6:17:06 PM Subject: Re: Suggestions for Tool to automate/document task management workflow ** George, Blatant Plug: Yes there sure is, it's called [EMAIL PROTECTED] and unlike ISTMx our application works ! While the boyz over an BMC struggle to refine their solution, ours is rock solid and we don't charge seat or individual application licenses. Need an ITIL application ? - We are that ! Our application is easily 80% Data driven - We do Templates !! Need to Model Facilities in a CMDB ? - We do that ! Need to Model a Telephony system in a CMDB ? - We do that ! Need to Model an F15 Tomcat and armaments in a CMDB ? - We do that ! Need to graphically display any CI hierarchy in your CMDB (Facilities, Aircraft, IT assets etc) ? - We do that with our own developed Xtreme Asset tool. Need a (RIA) User Friendly interface to allow your customers on create requests for service - We do that with our own developed Xtreme Console. Yes it works on a MAC, or any browser and Yes you get the source code Need a (RIA) flexible Dashboard interface to graphically depict Metrics in real-time - We do that with our own developed Xtreme Dashboard. Want to PAY extra for your Test Server software seat licenses - we DON'T do that ! Want to PAY extra for your support $$$ - we DON'T do that, actually our support is $25,000 per year BECAUSE IT IS A FAIR PRICE !!! Do you want a solution provider that is interested in your business the way you do business or would you prefer to shoe-horn an application that may take you a year to implement Visit us and take a look at what we can offer: http://www.buoyantsolutions.net/ESS.html Look at our bundled fixed price solution that is truly end-to-end and includes full implementation in 12 weeks or less ! Contact us off list to arrange a convenient webcast to review what we can do for you today. Regards...Gidd From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Payne, George Sent: Wednesday, February 27, 2008 1:52 PM To: arslist@ARSLIST.ORG Subject: OT:Suggestions for Tool to automate/document task management workflow ** Dear Listers, Current Environment: ARS 7.0.01 P05 on AIX 5.3 Mid-Tier 7.0.01 P05 on separate AIX 5.3 Oracle 10g Database on a third AIX 5.3 ITSM 7.0.01 P05 – Asset, Change, Incident, Problem, and Service Level Management CMDB 2.0.1 not patched My management team is very interested in finding a tool to help with our implementation of ITIL and Best Practices. The best possible solution would help us focus on the Best Practices or Industry Standards for “common tasks” such as standing up new servers, decommissioning items from Data Center and moving items within the data center. This tool would help us both document our current “workflows” (preferably by loading task group templates that have already been created in Change Management) and allow us to compare and contrast that to Industry Standards as well as plan future improvements. Is there anything out there like that already? Thanks, Gp George Payne Corporate Applications Developer Electric Reliability Council of Texas (512) 248-3940 [EMAIL PROTECTED] Never miss a thing. Make Yahoo your home page. http://www.yahoo.com/r/hs ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Suggestions Anyone?
** How about using Web Services? All of your code is contained within Remedy and it is up to you how simple or complex you want to make it. Mike. Valerie Balloon [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 30/10/2006 12:31 Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Suggestions Anyone? I'm looking for any suggestions on how to cleanly pull/push data realtime from one AR System to another without the use of EIE or utilizing the API. One server is v6.3 and the other 7.0. Our Tier 1 helpdesk uses a customized 6.3 Helpdesk application while our Tier 2 Helpdesk will be using the 7.0 ITSM suite.Note: We do not have a programmer to build the API interface nor can we afford 30K for EIE. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are __20060125___This posting was submitted with HTML in it___
Re: Suggestions Anyone?
rrrChive may help you. http://www.rrr.se/en/, look for rrrChive. -- Jarl On 10/30/06, Valerie Balloon [EMAIL PROTECTED] wrote: I'm looking for any suggestions on how to cleanly pull/push data realtime from one AR System to another without the use of EIE or utilizing the API. One server is v6.3 and the other 7.0. Our Tier 1 helpdesk uses a customized 6.3 Helpdesk application while our Tier 2 Helpdesk will be using the 7.0 ITSM suite.Note: We do not have a programmer to build the API interface nor can we afford 30K for EIE. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Suggestions - DOB
Title: RE: Suggestions - DOB ** Jamie Use a Date field. You can go back to 4173 BC! James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Blodgett, Jamie Sent: Tuesday, July 18, 2006 7:51 AM To: arslist@ARSLIST.ORG Subject: Suggestions - DOB How are other's handling dates needed in ARS prior to 1/1/70? (such as Date of Birth) I've dug around the archives and KBs, but haven't found anything. We have several instances where dates prior to 1/1/70 are needed in addition to DOB. So, it would be nice to know how others have tackled this. Thanks! Jamie Blodgett Rinker Materials Corp. Remedy Application Support CONFIDENTIALITY: The information contained in this transmission may contain privileged and confidential information. It is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication, and the information contained in it, is strictly prohibited. If you are not the intended recipient, please contact the sender and immediately destroy all copies of the original message. ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it___
Re: Suggestions - DOB
** You did not mention your ARS version but a Date field can hold a date that goes back to BC dates. A date\time field is limited to 12/31/1969On 7/18/06, Blodgett, Jamie [EMAIL PROTECTED] wrote:How are other's handling dates needed in ARS prior to 1/1/70?(such as Date of Birth) I've dug around the archives and KBs, but haven't found anything. We have several instances where dates prior to 1/1/70 are needed in addition to DOB.So, it would be nice to know how others have tackled this.Thanks!Jamie BlodgettRinker Materials Corp.Remedy Application Support CONFIDENTIALITY:The information contained in this transmission may contain privileged and confidential information. It is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication, and the information contained in it, is strictly prohibited. If you are not the intended recipient, please contact the sender and immediately destroy all copies of the original message. ___UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org -- Frank CarusoSpecific Integration, Inc.Senior Remedy Engineerwww.specificintegration.com703-376-1249 __20060125___This posting was submitted with HTML in it___
Re: Suggestions - DOB
Well, for starters, you could use Date fields instead of Date/Time fields. Those go back before any of us (except for Dick Clark) were born. Rick -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Blodgett, Jamie Sent: Tuesday, July 18, 2006 7:51 AM To: arslist@ARSLIST.ORG Subject: Suggestions - DOB How are other's handling dates needed in ARS prior to 1/1/70? (such as Date of Birth) I've dug around the archives and KBs, but haven't found anything. We have several instances where dates prior to 1/1/70 are needed in addition to DOB. So, it would be nice to know how others have tackled this. Thanks! Jamie Blodgett Rinker Materials Corp. Remedy Application Support CONFIDENTIALITY: The information contained in this transmission may contain privileged and confidential information. It is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication, and the information contained in it, is strictly prohibited. If you are not the intended recipient, please contact the sender and immediately destroy all copies of the original message. ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Suggestions - DOB
** So sorry . . . I didn't mention the version . . . ARS 5.0 (yes, we are unsupported and in process of upgrading now . . . on a test box) Oracle 8.1 HPUX 11 -Original Message-From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]On Behalf Of Frank CarusoSent: Tuesday, July 18, 2006 11:17 AMTo: arslist@ARSLIST.ORGSubject: Re: Suggestions - DOB** You did not mention your ARS version but a Date field can hold a date that goes back to BC dates. A date\time field is limited to 12/31/1969 On 7/18/06, Blodgett, Jamie [EMAIL PROTECTED] wrote: How are other's handling dates needed in ARS prior to 1/1/70?(such as Date of Birth) I've dug around the archives and KBs, but haven't found anything. We have several instances where dates prior to 1/1/70 are needed in addition to DOB.So, it would be nice to know how others have tackled this.Thanks!Jamie BlodgettRinker Materials Corp.Remedy Application Support CONFIDENTIALITY:The information contained in this transmission may contain privileged and confidential information. It is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication, and the information contained in it, is strictly prohibited. If you are not the intended recipient, please contact the sender and immediately destroy all copies of the original message. ___UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org-- Frank CarusoSpecific Integration, Inc.Senior Remedy Engineerwww.specificintegration.com703-376-1249 __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: Suggestions - DOB
** Ah, well then that would be a problem. You could displaythe DDMMYY elementsas discrete integer fields (ordrop-down lists)or as a single character field, but data validation and enforcing a single format might be difficult on that. But if you're upgrading anyway, it might not be worth re-doing not only the code, but the data, once you upgrade and can use Date fields. That's your call. Rick From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Blodgett, JamieSent: Tuesday, July 18, 2006 8:58 AMTo: arslist@ARSLIST.ORGSubject: Re: Suggestions - DOB ** So sorry . . . I didn't mention the version . . . ARS 5.0 (yes, we are unsupported and in process of upgrading now . . . on a test box) Oracle 8.1 HPUX 11 -Original Message-From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]On Behalf Of Frank CarusoSent: Tuesday, July 18, 2006 11:17 AMTo: arslist@ARSLIST.ORGSubject: Re: Suggestions - DOB** You did not mention your ARS version but a Date field can hold a date that goes back to BC dates. A date\time field is limited to 12/31/1969 On 7/18/06, Blodgett, Jamie [EMAIL PROTECTED] wrote: How are other's handling dates needed in ARS prior to 1/1/70?(such as Date of Birth) I've dug around the archives and KBs, but haven't found anything. We have several instances where dates prior to 1/1/70 are needed in addition to DOB.So, it would be nice to know how others have tackled this.Thanks!Jamie BlodgettRinker Materials Corp.Remedy Application Support CONFIDENTIALITY:The information contained in this transmission may contain privileged and confidential information. It is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication, and the information contained in it, is strictly prohibited. If you are not the intended recipient, please contact the sender and immediately destroy all copies of the original message. ___UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org-- Frank CarusoSpecific Integration, Inc.Senior Remedy Engineerwww.specificintegration.com703-376-1249 __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: Suggestions - DOB
** Then there is not much you can do on your current version of the ARS as that version backwards wasnt compatible to hold dates below the epoch date range.. The closest you could get is developing a calender functionality using 3 display only fields one for the date the other for the month and the last for the year - I think that might be possible by building some logic to consider the date ranges for specific months and leap year considerations... Using the inputs from these three strings you could build a date string.. Off course this date string would be only useful as a string and you would be very limited to manupulations possible on this string... Regards Joe D'Souza Remedy Developer / Consultant, BearingPoint, Time Warner Cable Project, Virginia. - Original Message From: "Blodgett, Jamie" [EMAIL PROTECTED]To: arslist@ARSLIST.ORGSent: Tuesday, July 18, 2006 11:57:38 AMSubject: Re: Suggestions - DOB** So sorry . . . I didn't mention the version . . . ARS 5.0 (yes, we are unsupported and in process of upgrading now . . . on a test box) Oracle 8.1 HPUX 11 -Original Message-From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]On Behalf Of Frank CarusoSent: Tuesday, July 18, 2006 11:17 AMTo: arslist@ARSLIST.ORGSubject: Re: Suggestions - DOB** You did not mention your ARS version but a Date field can hold a date that goes back to BC dates. A date\time field is limited to 12/31/1969 On 7/18/06, Blodgett, Jamie [EMAIL PROTECTED] wrote: How are other's handling dates needed in ARS prior to 1/1/70?(such as Date of Birth) I've dug around the archives and KBs, but haven't found anything. We have several instances where dates prior to 1/1/70 are needed in addition to DOB.So, it would be nice to know how others have tackled this.Thanks!Jamie BlodgettRinker Materials Corp.Remedy Application Support CONFIDENTIALITY:The information contained in this transmission may contain privileged and confidential information. It is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication, and the information contained in it, is strictly prohibited. If you are not the intended recipient, please contact the sender and immediately destroy all copies of the original message. ___UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org-- Frank CarusoSpecific Integration, Inc.Senior Remedy Engineerwww.specificintegration.com703-376-1249 __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: Suggestions - DOB
** Jamie, Another approach isto use a character field to hold the formatted DOB that you display, and an integer field to hold the number of seconds from today. The integer field could be used for sorting, searching (ie. people with a birthday next month) or performing math (ie. schedule 90-day review from hire date). To set the integer field with Set Fields SQL (for SQL 2000): SELECT DATEDIFF(s, '$DOB Char$', GETDATE()) Whereas, $DOB Char$ would contain something like "07/18/1980". For validating dates typed in by usersrun the Set Fields SQL: SELECT ISDATE('$DOB Char$') If the date is valid then 1 is returned, else 0. HTH Stephen From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouzaSent: Tuesday, July 18, 2006 1:05 PMTo: arslist@ARSLIST.ORGSubject: Re: Suggestions - DOB ** Then there is not much you can do on your current version of the ARS as that version backwards wasnt compatible to hold dates below the epoch date range.. The closest you could get is developing a calender functionality using 3 display only fields one for the date the other for the month and the last for the year - I think that might be possible by building some logic to consider the date ranges for specific months and leap year considerations... Using the inputs from these three strings you could build a date string.. Off course this date string would be only useful as a string and you would be very limited to manupulations possible on this string... Regards Joe D'Souza Remedy Developer / Consultant, BearingPoint, Time Warner Cable Project, Virginia. - Original Message From: "Blodgett, Jamie" [EMAIL PROTECTED]To: arslist@ARSLIST.ORGSent: Tuesday, July 18, 2006 11:57:38 AMSubject: Re: Suggestions - DOB** So sorry . . . I didn't mention the version . . . ARS 5.0 (yes, we are unsupported and in process of upgrading now . . . on a test box) Oracle 8.1 HPUX 11 -Original Message-From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]On Behalf Of Frank CarusoSent: Tuesday, July 18, 2006 11:17 AMTo: arslist@ARSLIST.ORGSubject: Re: Suggestions - DOB** You did not mention your ARS version but a Date field can hold a date that goes back to BC dates. A date\time field is limited to 12/31/1969 On 7/18/06, Blodgett, Jamie [EMAIL PROTECTED] wrote: How are other's handling dates needed in ARS prior to 1/1/70?(such as Date of Birth) I've dug around the archives and KBs, but haven't found anything. We have several instances where dates prior to 1/1/70 are needed in addition to DOB.So, it would be nice to know how others have tackled this.Thanks!Jamie BlodgettRinker Materials Corp.Remedy Application Support CONFIDENTIALITY:The information contained in this transmission may contain privileged and confidential information. It is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication, and the information contained in it, is strictly prohibited. If you are not the intended recipient, please contact the sender and immediately destroy all copies of the original message. ___UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org-- Frank CarusoSpecific Integration, Inc.Senior Remedy Engineerwww.specificintegration.com703-376-1249 __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it_20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___