Sort of OT: Question for timezone experts out there..
Hello, Starting from the position that databases are a relic of the 1980s, and date/time/timezone fields are a persistent nightmare, don't use them. Store all your dates as a number of seconds or milliseconds since 1970 (ie epoch), and then display them appropriately. The timezone element is only ever relevant when rendering the date, and Mid Tier should know the user's timezone via a preference or the browser. I've lost count of the number of projects I've been involved in where there are timezone hacks around daylight savings, etc. John ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: DevStudio Tool
Guillaume, I know that Remedy development is very different from structured or object programming. But my point is about the quality and possibilities of their development tools. I will explain in detail what I consider essential: ONLINE DEBUG: There is a tool in Remedy that allows you to debug step by step. But it's text based. I want to log in in debug mode, that executes normally. Set breakpoints at some filters. When these filters arrive stop execution, see the fields values at this particular moment, and continue executing filters step by step. If this can be done by text, Why is it not possible to do through dev studio? UNITARY TEST: Configure some actions (like creating a request with some values or call a service action with some values) and program the expected behavior. So when you run the unitary test the system checks it. Maintaining a library of unitary tests on your system and reexecuting them at every change, you get more control. I do it now, with some very complex situations, but I need to use SOAPUI to call a web service and get the response, checking it to see if it is valid. GRAPHICAL ENHANCEMENTS LIKE BLOCKING OR HIDDING: Set some elements in a view and group them in layers. Then you can easily hide a layer, but only when editing. Or you can block a layer, to be sure you can't select it. ENFORCEMENT OF BEST PRACTICES: Have a set of best practices configured (like naming convention) and the system automatically checks them. So if you brake a best practice the system warms you. WORK WITH FIELDS NOT IN VIEW: If you want to reconfigure or change a field that is not present in any view, then you must add it (where you can't search it from the fieldid, only by the name) to a view, change it and remove it again from the view. ENHANCED SEARCH: I can only search elements from one criteria. And the available criteria is not enough. If I want to list all filters with some word in the name that are part of a particular application, this is not possible. If I want to know which filters are used in a particular form, this is not possible (I can only search for the primary form, but not shared). I want to list all filters that use a particular field in the qualification, this is not possible. I have a Remedy form that feeds from the Remedy's data dictionary that can perform all these searches. Under my point of view, the developer studio has the minimum set of feature to allow developing, but it is far from being a good tool. Regards, Jose Huerta http://theremedyforit.com/ On Thu, Mar 29, 2012 at 15:55, Guillaume Rheault guilla...@dcshq.comwrote: ** Jose, I think some of the points you mention are not applicable in the ARS world, since as you very well know, ARS is not a 3rd generation language like java or .net. The general consensus is that ARS is greater than a 4th generation language, it's either 4.5 or 5th generation. As a point of reference PL/SQL and T-SQL are 4th generation languages. Therefore you cannot really compare the developer tool of a of 5th generation language with the developer tool of a 3rd generation language. We need to compare apples to apples and oranges to oranges to make an objective and rational comparison. So... if you are familiar with a 5th generation language's developer tool and want to compare it with Developer Studio, please go ahead and share your analysis, the community values them, and hopefully BMC will incorporate new features in future versions. Guillaume -- *From:* Action Request System discussion list(ARSList) [ arslist@ARSLIST.ORG] on behalf of Jose Huerta [jose.hue...@sm2baleares.es] *Sent:* Thursday, March 29, 2012 8:27 AM *To:* arslist@ARSLIST.ORG *Subject:* Re: DevStudio Tool ** I think that Developer Studio is not as good as it must be. You all talk about the great leap made from the admin tool to the developer studio. But under my point of view it's is like going from a very bad application to a bad application. Have you seen other developer studios (like the Microsot's one)? There are a lot of features missing in the current version that are the basis of other development environments like: - Online debugging - Unitary test - Graphical blocking of elements (to block some elements and work with others). - Enforcement of best practices. - Search objects: To answer the next questions: What are the active links that can change one particular field? What filters are associated with a form (not only the main form, but also as a secondary form)? It is not a good tool. And the prove of it is that a lot of partners are providing parallel tools to make things that the developer studio would had to do. I work with a 24 panoramic monitor + 22 4:3 monitor + the 15 laptop monitor. And I use all three when using the developer studio. For me there is a waste of space when displaying a filter. All this information can be reorganized better way. _attend
Re: Sort of OT: Question for timezone experts out there..
You could use the database session info within your trigger to find out which server process is generating the deletes. That will at least let you confirm that it's an arserverd in your server group or not. e.g. select sys_context('USERENV', 'HOST') from dual; select process, program from v$session where sid = ( select sid from v$mystat where rownum=1 ); You'll need access to v$ views for that last bit though. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Book on Remedy...
Has anyone heard of a book on Remedy or the AR system? If so, can you provide details? Thanks. 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 attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Book on Remedy...
Hi, Do you mean Remedy for Dummies? It's a given best seller ;-) Best Regards - Misi, RRR AB, http://rrr.se Has anyone heard of a book on Remedy or the AR system? If so, can you provide details? Thanks. 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 attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Book on Remedy...
I would love to see a book like that! Judy C. Dowell Manager of Server Operations Academic Computing Wake Forest School of Medicine (336) 713-7386 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: Friday, March 30, 2012 8:16 AM To: arslist@ARSLIST.ORG Subject: Re: Book on Remedy... Hi, Do you mean Remedy for Dummies? It's a given best seller ;-) Best Regards - Misi, RRR AB, http://rrr.se Has anyone heard of a book on Remedy or the AR system? If so, can you provide details? Thanks. 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 attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Application not accessible through BMC Remedy Administrator
Hi Folks, Hope someone can help me in this issue. First I want to inform you that we are on a very old release. Our env. is: AR-Server: 7.0.01 patch 2 OS: HP-UX B.11.11 DB: Oracle 10.2.0.5.0 64bit MidTier: Version 7.0.01 Patch 002 200703132023 OS: Windows 2003 Server Now to describe the issue. Since 2 weeks we've got a couple timeout errors in Midtier. After enabling SQL/API logs we have found that the problem should be in one of our applications. But when I try to open the application in BMC Remedy Administrator it says Application does not exists. If I try to right click on it (to delete it), Remedy Administrator closes automatically. So it seems that I need to remove it on DB level but have not enough knowledge about DB structure. There are all custom applications. No ITSM. I have found the name of the application in table arcontainer but I am not sure if I delete the record from there will not destroy the DB consistency. Unfortunately I have no test environment where I can try this. We are only with a production one and need to be very careful in all these changes. Thanks in advance for everyone spending a time for me. Kind Regards, Georgi Paunov Remedy Administration Tel.: +359 675 30200 E-mail: Remedy-Administrator mailto:remedy-administra...@idealstandard.com @IdealStandard.com mailto:n...@idealstandard.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Book on Remedy...
Richard, In case you didn't understand Misi's humor, there isn't any published books on the AR System or the BMC/Remedy ITSM Suite. Dave -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: Friday, March 30, 2012 8:16 AM To: arslist@ARSLIST.ORG Subject: Re: Book on Remedy... Hi, Do you mean Remedy for Dummies? It's a given best seller ;-) Best Regards - Misi, RRR AB, http://rrr.se Has anyone heard of a book on Remedy or the AR system? If so, can you provide details? Thanks. 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 attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Book on Remedy...
There was a Remedy developer book that I saw at Barnes and Noble when I first got involved with ARS Release 4. -Original Message- From: Shellman, David dave.shell...@te.com To: arslist arslist@ARSLIST.ORG Sent: Fri, Mar 30, 2012 8:51 am Subject: Re: Book on Remedy... Richard, In case you didn't understand Misi's humor, there isn't any published books on he AR System or the BMC/Remedy ITSM Suite. Dave -Original Message- rom: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] n Behalf Of Misi Mladoniczky ent: Friday, March 30, 2012 8:16 AM o: arslist@ARSLIST.ORG ubject: Re: Book on Remedy... Hi, Do you mean Remedy for Dummies? It's a given best seller ;-) Best Regards - Misi, RRR AB, http://rrr.se Has anyone heard of a book on Remedy or the AR system? If so, can you provide details? Thanks. 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 attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ NSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 ww.wwrug12.com ARSList: Where the Answers Are ___ NSUBSCRIBE or access ARSlist Archives at www.arslist.org ttend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Book on Remedy...
no longer printed, just PDFs, the last book I had was version 5.x. you can find them in BMC Support Store.. jejeje, Friday's humor On 3/30/12, Roger Justice rjust2...@aol.com wrote: There was a Remedy developer book that I saw at Barnes and Noble when I first got involved with ARS Release 4. -Original Message- From: Shellman, David dave.shell...@te.com To: arslist arslist@ARSLIST.ORG Sent: Fri, Mar 30, 2012 8:51 am Subject: Re: Book on Remedy... Richard, In case you didn't understand Misi's humor, there isn't any published books on he AR System or the BMC/Remedy ITSM Suite. Dave -Original Message- rom: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] n Behalf Of Misi Mladoniczky ent: Friday, March 30, 2012 8:16 AM o: arslist@ARSLIST.ORG ubject: Re: Book on Remedy... Hi, Do you mean Remedy for Dummies? It's a given best seller ;-) Best Regards - Misi, RRR AB, http://rrr.se Has anyone heard of a book on Remedy or the AR system? If so, can you provide details? Thanks. 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 attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ NSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 ww.wwrug12.com ARSList: Where the Answers Are ___ NSUBSCRIBE or access ARSlist Archives at www.arslist.org ttend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: DevStudio Tool
Hola Jose Thanks for the clarification, you make interesting points. We know that David Easter monitors the ARS list, so maybe he can chime in on what he thinks about this Guillaume From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] on behalf of Jose Huerta [jose.hue...@sm2baleares.es] Sent: Friday, March 30, 2012 5:14 AM To: arslist@ARSLIST.ORG Subject: Re: DevStudio Tool ** Guillaume, I know that Remedy development is very different from structured or object programming. But my point is about the quality and possibilities of their development tools. I will explain in detail what I consider essential: ONLINE DEBUG: There is a tool in Remedy that allows you to debug step by step. But it's text based. I want to log in in debug mode, that executes normally. Set breakpoints at some filters. When these filters arrive stop execution, see the fields values at this particular moment, and continue executing filters step by step. If this can be done by text, Why is it not possible to do through dev studio? UNITARY TEST: Configure some actions (like creating a request with some values or call a service action with some values) and program the expected behavior. So when you run the unitary test the system checks it. Maintaining a library of unitary tests on your system and reexecuting them at every change, you get more control. I do it now, with some very complex situations, but I need to use SOAPUI to call a web service and get the response, checking it to see if it is valid. GRAPHICAL ENHANCEMENTS LIKE BLOCKING OR HIDDING: Set some elements in a view and group them in layers. Then you can easily hide a layer, but only when editing. Or you can block a layer, to be sure you can't select it. ENFORCEMENT OF BEST PRACTICES: Have a set of best practices configured (like naming convention) and the system automatically checks them. So if you brake a best practice the system warms you. WORK WITH FIELDS NOT IN VIEW: If you want to reconfigure or change a field that is not present in any view, then you must add it (where you can't search it from the fieldid, only by the name) to a view, change it and remove it again from the view. ENHANCED SEARCH: I can only search elements from one criteria. And the available criteria is not enough. If I want to list all filters with some word in the name that are part of a particular application, this is not possible. If I want to know which filters are used in a particular form, this is not possible (I can only search for the primary form, but not shared). I want to list all filters that use a particular field in the qualification, this is not possible. I have a Remedy form that feeds from the Remedy's data dictionary that can perform all these searches. Under my point of view, the developer studio has the minimum set of feature to allow developing, but it is far from being a good tool. Regards, Jose Huerta http://theremedyforit.com/ On Thu, Mar 29, 2012 at 15:55, Guillaume Rheault guilla...@dcshq.commailto:guilla...@dcshq.com wrote: ** Jose, I think some of the points you mention are not applicable in the ARS world, since as you very well know, ARS is not a 3rd generation language like java or .net. The general consensus is that ARS is greater than a 4th generation language, it's either 4.5 or 5th generation. As a point of reference PL/SQL and T-SQL are 4th generation languages. Therefore you cannot really compare the developer tool of a of 5th generation language with the developer tool of a 3rd generation language. We need to compare apples to apples and oranges to oranges to make an objective and rational comparison. So... if you are familiar with a 5th generation language's developer tool and want to compare it with Developer Studio, please go ahead and share your analysis, the community values them, and hopefully BMC will incorporate new features in future versions. Guillaume From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] on behalf of Jose Huerta [jose.hue...@sm2baleares.esmailto:jose.hue...@sm2baleares.es] Sent: Thursday, March 29, 2012 8:27 AM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: DevStudio Tool ** I think that Developer Studio is not as good as it must be. You all talk about the great leap made from the admin tool to the developer studio. But under my point of view it's is like going from a very bad application to a bad application. Have you seen other developer studios (like the Microsot's one)? There are a lot of features missing in the current version that are the basis of other development environments like: - Online debugging - Unitary test - Graphical blocking of elements (to block some elements and work with others). - Enforcement of best practices. - Search objects: To answer the next questions: What are the active links that
Re: DevStudio Tool
For ENHANCED SEARCH of filters to any form try the following Make a working list of all directly related items to a form and then use the filtering options against that. Fred From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jose Huerta Sent: Friday, March 30, 2012 4:15 AM To: arslist@ARSLIST.ORG Subject: Re: DevStudio Tool ** Guillaume, I know that Remedy development is very different from structured or object programming. But my point is about the quality and possibilities of their development tools. I will explain in detail what I consider essential: ONLINE DEBUG: There is a tool in Remedy that allows you to debug step by step. But it's text based. I want to log in in debug mode, that executes normally. Set breakpoints at some filters. When these filters arrive stop execution, see the fields values at this particular moment, and continue executing filters step by step. If this can be done by text, Why is it not possible to do through dev studio? UNITARY TEST: Configure some actions (like creating a request with some values or call a service action with some values) and program the expected behavior. So when you run the unitary test the system checks it. Maintaining a library of unitary tests on your system and reexecuting them at every change, you get more control. I do it now, with some very complex situations, but I need to use SOAPUI to call a web service and get the response, checking it to see if it is valid. GRAPHICAL ENHANCEMENTS LIKE BLOCKING OR HIDDING: Set some elements in a view and group them in layers. Then you can easily hide a layer, but only when editing. Or you can block a layer, to be sure you can't select it. ENFORCEMENT OF BEST PRACTICES: Have a set of best practices configured (like naming convention) and the system automatically checks them. So if you brake a best practice the system warms you. WORK WITH FIELDS NOT IN VIEW: If you want to reconfigure or change a field that is not present in any view, then you must add it (where you can't search it from the fieldid, only by the name) to a view, change it and remove it again from the view. ENHANCED SEARCH: I can only search elements from one criteria. And the available criteria is not enough. If I want to list all filters with some word in the name that are part of a particular application, this is not possible. If I want to know which filters are used in a particular form, this is not possible (I can only search for the primary form, but not shared). I want to list all filters that use a particular field in the qualification, this is not possible. I have a Remedy form that feeds from the Remedy's data dictionary that can perform all these searches. Under my point of view, the developer studio has the minimum set of feature to allow developing, but it is far from being a good tool. Regards, Jose Huerta http://theremedyforit.com/ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Guillaume Rheault Sent: Friday, March 29, 2012 3:55 PM To: arslist@ARSLIST.ORG Subject: Re: DevStudio Tool ** Jose, I think some of the points you mention are not applicable in the ARS world, since as you very well know, ARS is not a 3rd generation language like java or .net. The general consensus is that ARS is greater than a 4th generation language, it's either 4.5 or 5th generation. As a point of reference PL/SQL and T-SQL are 4th generation languages. Therefore you cannot really compare the developer tool of a of 5th generation language with the developer tool of a 3rd generation language. We need to compare apples to apples and oranges to oranges to make an objective and rational comparison. So... if you are familiar with a 5th generation language's developer tool and want to compare it with Developer Studio, please go ahead and share your analysis, the community values them, and hopefully BMC will incorporate new features in future versions. Guillaume From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] on behalf of Jose Huerta Sent: Thursday, March 29, 2012 8:27 AM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: DevStudio Tool ** I think that Developer Studio is not as good as it must be. You all talk about the great leap made from the admin tool to the developer studio. But under my point of view it's is like going from a very bad application to a bad application. Have you seen other developer studios (like the Microsot's one)? There are a lot of features missing in the current version that are the basis of other development environments like: - Online debugging - Unitary test - Graphical blocking of elements (to block some elements and work with others). - Enforcement of best practices. - Search objects: To answer the next questions: What are the active links
Re: DevStudio Tool
Hi, The Work with fields not in view can be done today. 1) Open the form that has the field in it that you want to change. 2) Open the Outline (Window - Show View - Outline) 3) In the top right, one of the Icons is Show Fields not in View 4) Select the field that you would like to change 5) From here, you can Open the Properties (go to Window - Show View - Properties) or right-click and Create Overlay 6) Once you open the Properties, you can see all the Properties of that field even though it is not in the view and you can make changes to it. Thanks! Greg From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Guillaume Rheault Sent: Friday, March 30, 2012 8:49 AM To: arslist@ARSLIST.ORG Subject: Re: DevStudio Tool ** Hola Jose Thanks for the clarification, you make interesting points. We know that David Easter monitors the ARS list, so maybe he can chime in on what he thinks about this Guillaume From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] on behalf of Jose Huerta [jose.hue...@sm2baleares.es] Sent: Friday, March 30, 2012 5:14 AM To: arslist@ARSLIST.ORG Subject: Re: DevStudio Tool ** Guillaume, I know that Remedy development is very different from structured or object programming. But my point is about the quality and possibilities of their development tools. I will explain in detail what I consider essential: ONLINE DEBUG: There is a tool in Remedy that allows you to debug step by step. But it's text based. I want to log in in debug mode, that executes normally. Set breakpoints at some filters. When these filters arrive stop execution, see the fields values at this particular moment, and continue executing filters step by step. If this can be done by text, Why is it not possible to do through dev studio? UNITARY TEST: Configure some actions (like creating a request with some values or call a service action with some values) and program the expected behavior. So when you run the unitary test the system checks it. Maintaining a library of unitary tests on your system and reexecuting them at every change, you get more control. I do it now, with some very complex situations, but I need to use SOAPUI to call a web service and get the response, checking it to see if it is valid. GRAPHICAL ENHANCEMENTS LIKE BLOCKING OR HIDDING: Set some elements in a view and group them in layers. Then you can easily hide a layer, but only when editing. Or you can block a layer, to be sure you can't select it. ENFORCEMENT OF BEST PRACTICES: Have a set of best practices configured (like naming convention) and the system automatically checks them. So if you brake a best practice the system warms you. WORK WITH FIELDS NOT IN VIEW: If you want to reconfigure or change a field that is not present in any view, then you must add it (where you can't search it from the fieldid, only by the name) to a view, change it and remove it again from the view. ENHANCED SEARCH: I can only search elements from one criteria. And the available criteria is not enough. If I want to list all filters with some word in the name that are part of a particular application, this is not possible. If I want to know which filters are used in a particular form, this is not possible (I can only search for the primary form, but not shared). I want to list all filters that use a particular field in the qualification, this is not possible. I have a Remedy form that feeds from the Remedy's data dictionary that can perform all these searches. Under my point of view, the developer studio has the minimum set of feature to allow developing, but it is far from being a good tool. Regards, Jose Huerta http://theremedyforit.com/ On Thu, Mar 29, 2012 at 15:55, Guillaume Rheault guilla...@dcshq.commailto:guilla...@dcshq.com wrote: ** Jose, I think some of the points you mention are not applicable in the ARS world, since as you very well know, ARS is not a 3rd generation language like java or .net. The general consensus is that ARS is greater than a 4th generation language, it's either 4.5 or 5th generation. As a point of reference PL/SQL and T-SQL are 4th generation languages. Therefore you cannot really compare the developer tool of a of 5th generation language with the developer tool of a 3rd generation language. We need to compare apples to apples and oranges to oranges to make an objective and rational comparison. So... if you are familiar with a 5th generation language's developer tool and want to compare it with Developer Studio, please go ahead and share your analysis, the community values them, and hopefully BMC will incorporate new features in future versions. Guillaume From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] on behalf of Jose Huerta
Re: DevStudio Tool
That's actually one of the things the DevStudio makes easy that was much harder in the Admin Tool. It is another one of those tools that you MUST have when working with the ITSM Suite, where MOST of the fields have been hidden in the user-facing forms. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Greg Donalson Sent: Friday, March 30, 2012 9:17 AM To: arslist@ARSLIST.ORG Subject: Re: DevStudio Tool ** Hi, The Work with fields not in view can be done today. 1) Open the form that has the field in it that you want to change. 2) Open the Outline (Window - Show View - Outline) 3) In the top right, one of the Icons is Show Fields not in View 4) Select the field that you would like to change 5) From here, you can Open the Properties (go to Window - Show View - Properties) or right-click and Create Overlay 6) Once you open the Properties, you can see all the Properties of that field even though it is not in the view and you can make changes to it. Thanks! Greg From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Guillaume Rheault Sent: Friday, March 30, 2012 8:49 AM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: DevStudio Tool ** Hola Jose Thanks for the clarification, you make interesting points. We know that David Easter monitors the ARS list, so maybe he can chime in on what he thinks about this Guillaume From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] on behalf of Jose Huerta [jose.hue...@sm2baleares.es] Sent: Friday, March 30, 2012 5:14 AM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: DevStudio Tool ** Guillaume, I know that Remedy development is very different from structured or object programming. But my point is about the quality and possibilities of their development tools. I will explain in detail what I consider essential: ONLINE DEBUG: There is a tool in Remedy that allows you to debug step by step. But it's text based. I want to log in in debug mode, that executes normally. Set breakpoints at some filters. When these filters arrive stop execution, see the fields values at this particular moment, and continue executing filters step by step. If this can be done by text, Why is it not possible to do through dev studio? UNITARY TEST: Configure some actions (like creating a request with some values or call a service action with some values) and program the expected behavior. So when you run the unitary test the system checks it. Maintaining a library of unitary tests on your system and reexecuting them at every change, you get more control. I do it now, with some very complex situations, but I need to use SOAPUI to call a web service and get the response, checking it to see if it is valid. GRAPHICAL ENHANCEMENTS LIKE BLOCKING OR HIDDING: Set some elements in a view and group them in layers. Then you can easily hide a layer, but only when editing. Or you can block a layer, to be sure you can't select it. ENFORCEMENT OF BEST PRACTICES: Have a set of best practices configured (like naming convention) and the system automatically checks them. So if you brake a best practice the system warms you. WORK WITH FIELDS NOT IN VIEW: If you want to reconfigure or change a field that is not present in any view, then you must add it (where you can't search it from the fieldid, only by the name) to a view, change it and remove it again from the view. ENHANCED SEARCH: I can only search elements from one criteria. And the available criteria is not enough. If I want to list all filters with some word in the name that are part of a particular application, this is not possible. If I want to know which filters are used in a particular form, this is not possible (I can only search for the primary form, but not shared). I want to list all filters that use a particular field in the qualification, this is not possible. I have a Remedy form that feeds from the Remedy's data dictionary that can perform all these searches. Under my point of view, the developer studio has the minimum set of feature to allow developing, but it is far from being a good tool. Regards, Jose Huerta http://theremedyforit.com/ On Thu, Mar 29, 2012 at 15:55, Guillaume Rheault guilla...@dcshq.commailto:guilla...@dcshq.com wrote: ** Jose, I think some of the points you mention are not applicable in the ARS world, since as you very well know, ARS is not a 3rd generation language like java or .net. The general consensus is that ARS is greater than a 4th generation language, it's either 4.5 or 5th generation. As a point of reference PL/SQL and T-SQL are 4th generation languages. Therefore you cannot really compare the developer tool of a of 5th
Re: DevStudio Tool
I think that among all your ideas, the one I like best is WORK WITH FIELDS NOT IN VIEW. And possibly with minimum code change to the DS as it stands right now.. All it would take is instead of populating the Field Properties pane only on clicking on the field, to have the ability to switch that properties pane in a search mode and type out the DB Name of fields not in view, and fetch their properties.. Gray out the areas of properties where fields not in view do not get set any values so the user cannot change those.. Its would be a simple query to the meta-data to fetch that information.. Great idea.. I like it.. Love it actually... Maybe you should submit an RFE for this.. In the RFE the obvious advantage you can state is that you do not have to dirty a form or its view by bringing it in view just to view that fields property. It’s a big seller.. Everyone would benefit by this and not just a small group of people so it should be something that should get a good consideration.. I also like the ONLINE DEBUG. This however has been something that we as a community have been suggesting ever since I was new to this whole Remedy world.. and that’s more than a decade.. If it still hasn’t happened, I don’t see it happening anytime too soon. It must have come on their tables as an RFE 10 times over already and has been turned down or probably deferred indefinitely.. Joe From: Grooms, Frederick W Sent: Friday, March 30, 2012 10:05 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: DevStudio Tool ** For ENHANCED SEARCH of filters to any form try the following Make a working list of all directly related items to a form and then use the filtering options against that. Fred From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jose Huerta Sent: Friday, March 30, 2012 4:15 AM To: arslist@ARSLIST.ORG Subject: Re: DevStudio Tool ** Guillaume, I know that Remedy development is very different from structured or object programming. But my point is about the quality and possibilities of their development tools. I will explain in detail what I consider essential: ONLINE DEBUG: There is a tool in Remedy that allows you to debug step by step. But it's text based. I want to log in in debug mode, that executes normally. Set breakpoints at some filters. When these filters arrive stop execution, see the fields values at this particular moment, and continue executing filters step by step. If this can be done by text, Why is it not possible to do through dev studio? UNITARY TEST: Configure some actions (like creating a request with some values or call a service action with some values) and program the expected behavior. So when you run the unitary test the system checks it. Maintaining a library of unitary tests on your system and reexecuting them at every change, you get more control. I do it now, with some very complex situations, but I need to use SOAPUI to call a web service and get the response, checking it to see if it is valid. GRAPHICAL ENHANCEMENTS LIKE BLOCKING OR HIDDING: Set some elements in a view and group them in layers. Then you can easily hide a layer, but only when editing. Or you can block a layer, to be sure you can't select it. ENFORCEMENT OF BEST PRACTICES: Have a set of best practices configured (like naming convention) and the system automatically checks them. So if you brake a best practice the system warms you. WORK WITH FIELDS NOT IN VIEW: If you want to reconfigure or change a field that is not present in any view, then you must add it (where you can't search it from the fieldid, only by the name) to a view, change it and remove it again from the view. ENHANCED SEARCH: I can only search elements from one criteria. And the available criteria is not enough. If I want to list all filters with some word in the name that are part of a particular application, this is not possible. If I want to know which filters are used in a particular form, this is not possible (I can only search for the primary form, but not shared). I want to list all filters that use a particular field in the qualification, this is not possible. I have a Remedy form that feeds from the Remedy's data dictionary that can perform all these searches. Under my point of view, the developer studio has the minimum set of feature to allow developing, but it is far from being a good tool. Regards, Jose Huerta http://theremedyforit.com/ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Guillaume Rheault Sent: Friday, March 29, 2012 3:55 PM To: arslist@ARSLIST.ORG Subject: Re: DevStudio Tool ** Jose, I think some of the points you mention are not applicable in the ARS world, since as you very well know, ARS is
Re: DevStudio Tool
thanks for the tip, works great Guillaume From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] on behalf of Grooms, Frederick W [frederick.w.gro...@xo.com] Sent: Friday, March 30, 2012 10:05 AM To: arslist@ARSLIST.ORG Subject: Re: DevStudio Tool ** For ENHANCED SEARCH of filters to any form try the following Make a working list of all directly related items to a form and then use the filtering options against that. Fred From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jose Huerta Sent: Friday, March 30, 2012 4:15 AM To: arslist@ARSLIST.ORG Subject: Re: DevStudio Tool ** Guillaume, I know that Remedy development is very different from structured or object programming. But my point is about the quality and possibilities of their development tools. I will explain in detail what I consider essential: ONLINE DEBUG: There is a tool in Remedy that allows you to debug step by step. But it's text based. I want to log in in debug mode, that executes normally. Set breakpoints at some filters. When these filters arrive stop execution, see the fields values at this particular moment, and continue executing filters step by step. If this can be done by text, Why is it not possible to do through dev studio? UNITARY TEST: Configure some actions (like creating a request with some values or call a service action with some values) and program the expected behavior. So when you run the unitary test the system checks it. Maintaining a library of unitary tests on your system and reexecuting them at every change, you get more control. I do it now, with some very complex situations, but I need to use SOAPUI to call a web service and get the response, checking it to see if it is valid. GRAPHICAL ENHANCEMENTS LIKE BLOCKING OR HIDDING: Set some elements in a view and group them in layers. Then you can easily hide a layer, but only when editing. Or you can block a layer, to be sure you can't select it. ENFORCEMENT OF BEST PRACTICES: Have a set of best practices configured (like naming convention) and the system automatically checks them. So if you brake a best practice the system warms you. WORK WITH FIELDS NOT IN VIEW: If you want to reconfigure or change a field that is not present in any view, then you must add it (where you can't search it from the fieldid, only by the name) to a view, change it and remove it again from the view. ENHANCED SEARCH: I can only search elements from one criteria. And the available criteria is not enough. If I want to list all filters with some word in the name that are part of a particular application, this is not possible. If I want to know which filters are used in a particular form, this is not possible (I can only search for the primary form, but not shared). I want to list all filters that use a particular field in the qualification, this is not possible. I have a Remedy form that feeds from the Remedy's data dictionary that can perform all these searches. Under my point of view, the developer studio has the minimum set of feature to allow developing, but it is far from being a good tool. Regards, Jose Huerta http://theremedyforit.com/ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Guillaume Rheault Sent: Friday, March 29, 2012 3:55 PM To: arslist@ARSLIST.ORG Subject: Re: DevStudio Tool ** Jose, I think some of the points you mention are not applicable in the ARS world, since as you very well know, ARS is not a 3rd generation language like java or .net. The general consensus is that ARS is greater than a 4th generation language, it's either 4.5 or 5th generation. As a point of reference PL/SQL and T-SQL are 4th generation languages. Therefore you cannot really compare the developer tool of a of 5th generation language with the developer tool of a 3rd generation language. We need to compare apples to apples and oranges to oranges to make an objective and rational comparison. So... if you are familiar with a 5th generation language's developer tool and want to compare it with Developer Studio, please go ahead and share your analysis, the community values them, and hopefully BMC will incorporate new features in future versions. Guillaume From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] on behalf of Jose Huerta Sent: Thursday, March 29, 2012 8:27 AM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: DevStudio Tool ** I think that Developer Studio is not as good as it must be. You all talk about the great leap made from the admin tool to the developer studio. But under my point of view it's is like going from a very bad application to a bad application. Have you seen other developer studios (like the Microsot's one)? There are a lot of features missing in the
Re: DevStudio Tool
AL and Filter properties- Display AL or Filter Guides in which active link or filter belongs In AL and Filter Message actions-Allow alpha numeric values in the Number field Escalations List- Display the interval setting in a column and/or provide a filtering option for interval values or date\times Allow the use of the IN operator Introduce SQL editor formatting to the Run If Qualification Provide a way to store documents in a packing list -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Friday, March 30, 2012 10:06 AM To: arslist@ARSLIST.ORG Subject: Re: DevStudio Tool ** For ENHANCED SEARCH of filters to any form try the following Make a working list of all directly related items to a form and then use the filtering options against that. Fred From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jose Huerta Sent: Friday, March 30, 2012 4:15 AM To: arslist@ARSLIST.ORG Subject: Re: DevStudio Tool ** Guillaume, I know that Remedy development is very different from structured or object programming. But my point is about the quality and possibilities of their development tools. I will explain in detail what I consider essential: ONLINE DEBUG: There is a tool in Remedy that allows you to debug step by step. But it's text based. I want to log in in debug mode, that executes normally. Set breakpoints at some filters. When these filters arrive stop execution, see the fields values at this particular moment, and continue executing filters step by step. If this can be done by text, Why is it not possible to do through dev studio? UNITARY TEST: Configure some actions (like creating a request with some values or call a service action with some values) and program the expected behavior. So when you run the unitary test the system checks it. Maintaining a library of unitary tests on your system and reexecuting them at every change, you get more control. I do it now, with some very complex situations, but I need to use SOAPUI to call a web service and get the response, checking it to see if it is valid. GRAPHICAL ENHANCEMENTS LIKE BLOCKING OR HIDDING: Set some elements in a view and group them in layers. Then you can easily hide a layer, but only when editing. Or you can block a layer, to be sure you can't select it. ENFORCEMENT OF BEST PRACTICES: Have a set of best practices configured (like naming convention) and the system automatically checks them. So if you brake a best practice the system warms you. WORK WITH FIELDS NOT IN VIEW: If you want to reconfigure or change a field that is not present in any view, then you must add it (where you can't search it from the fieldid, only by the name) to a view, change it and remove it again from the view. ENHANCED SEARCH: I can only search elements from one criteria. And the available criteria is not enough. If I want to list all filters with some word in the name that are part of a particular application, this is not possible. If I want to know which filters are used in a particular form, this is not possible (I can only search for the primary form, but not shared). I want to list all filters that use a particular field in the qualification, this is not possible. I have a Remedy form that feeds from the Remedy's data dictionary that can perform all these searches. Under my point of view, the developer studio has the minimum set of feature to allow developing, but it is far from being a good tool. Regards, Jose Huerta http://theremedyforit.com/ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Guillaume Rheault Sent: Friday, March 29, 2012 3:55 PM To: arslist@ARSLIST.ORG Subject: Re: DevStudio Tool ** Jose, I think some of the points you mention are not applicable in the ARS world, since as you very well know, ARS is not a 3rd generation language like java or .net. The general consensus is that ARS is greater than a 4th generation language, it's either 4.5 or 5th generation. As a point of reference PL/SQL and T-SQL are 4th generation languages. Therefore you cannot really compare the developer tool of a of 5th generation language with the developer tool of a 3rd generation language. We need to compare apples to apples and oranges to oranges to make an objective and rational comparison. So... if you are familiar with a 5th generation language's developer tool and want to compare it with Developer Studio, please go ahead and share your analysis, the community values them, and hopefully BMC will incorporate new features in future versions. Guillaume From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] on behalf of Jose Huerta Sent: Thursday, March 29, 2012 8:27 AM
Re: DevStudio Tool
The WORK WITH FIELDS NOT IN VIEW works great with 7.6.04 SP2. Not sure if it works well with 7.6.03, so we can scratch that of the list, can't we? From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] on behalf of Joe Martin D'Souza [jdso...@shyle.net] Sent: Friday, March 30, 2012 10:46 AM To: arslist@ARSLIST.ORG Subject: Re: DevStudio Tool ** I think that among all your ideas, the one I like best is WORK WITH FIELDS NOT IN VIEW. And possibly with minimum code change to the DS as it stands right now.. All it would take is instead of populating the Field Properties pane only on clicking on the field, to have the ability to switch that properties pane in a search mode and type out the DB Name of fields not in view, and fetch their properties.. Gray out the areas of properties where fields not in view do not get set any values so the user cannot change those.. Its would be a simple query to the meta-data to fetch that information.. Great idea.. I like it.. Love it actually... Maybe you should submit an RFE for this.. In the RFE the obvious advantage you can state is that you do not have to dirty a form or its view by bringing it in view just to view that fields property. It’s a big seller.. Everyone would benefit by this and not just a small group of people so it should be something that should get a good consideration.. I also like the ONLINE DEBUG. This however has been something that we as a community have been suggesting ever since I was new to this whole Remedy world.. and that’s more than a decade.. If it still hasn’t happened, I don’t see it happening anytime too soon. It must have come on their tables as an RFE 10 times over already and has been turned down or probably deferred indefinitely.. Joe From: Grooms, Frederick Wmailto:frederick.w.gro...@xo.com Sent: Friday, March 30, 2012 10:05 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: DevStudio Tool ** For ENHANCED SEARCH of filters to any form try the following Make a working list of all directly related items to a form and then use the filtering options against that. Fred From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jose Huerta Sent: Friday, March 30, 2012 4:15 AM To: arslist@ARSLIST.ORG Subject: Re: DevStudio Tool ** Guillaume, I know that Remedy development is very different from structured or object programming. But my point is about the quality and possibilities of their development tools. I will explain in detail what I consider essential: ONLINE DEBUG: There is a tool in Remedy that allows you to debug step by step. But it's text based. I want to log in in debug mode, that executes normally. Set breakpoints at some filters. When these filters arrive stop execution, see the fields values at this particular moment, and continue executing filters step by step. If this can be done by text, Why is it not possible to do through dev studio? UNITARY TEST: Configure some actions (like creating a request with some values or call a service action with some values) and program the expected behavior. So when you run the unitary test the system checks it. Maintaining a library of unitary tests on your system and reexecuting them at every change, you get more control. I do it now, with some very complex situations, but I need to use SOAPUI to call a web service and get the response, checking it to see if it is valid. GRAPHICAL ENHANCEMENTS LIKE BLOCKING OR HIDDING: Set some elements in a view and group them in layers. Then you can easily hide a layer, but only when editing. Or you can block a layer, to be sure you can't select it. ENFORCEMENT OF BEST PRACTICES: Have a set of best practices configured (like naming convention) and the system automatically checks them. So if you brake a best practice the system warms you. WORK WITH FIELDS NOT IN VIEW: If you want to reconfigure or change a field that is not present in any view, then you must add it (where you can't search it from the fieldid, only by the name) to a view, change it and remove it again from the view. ENHANCED SEARCH: I can only search elements from one criteria. And the available criteria is not enough. If I want to list all filters with some word in the name that are part of a particular application, this is not possible. If I want to know which filters are used in a particular form, this is not possible (I can only search for the primary form, but not shared). I want to list all filters that use a particular field in the qualification, this is not possible. I have a Remedy form that feeds from the Remedy's data dictionary that can perform all these searches. Under my point of view, the developer studio has the minimum set of feature to allow developing, but it is far from being a good tool. Regards, Jose Huerta http://theremedyforit.com/
Re: Application not accessible through BMC Remedy Administrator
Hi Georgi, first I would not do a change like this in a production system. I would try it in dev environment, but only after getting the feedback from BMC Support. If you cannot get a knowledgeable tech support guy, escalate until you get somebody that knows this well The other table that you need to take a look at is arreference, that links the application with the forms. take a look at it. Still even if you are able to figure out all this, I would not try it first in a production system, I would try it in a cloned system that you can mess up and blow-away at will. Also, when you try whatever fix BMC Support gives you, before you make any change to production, make sure you have a reliable database backup. Guillaume From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] on behalf of Remedy-Administrator (ISI) [remedy-administra...@idealstandard.com] Sent: Friday, March 30, 2012 8:49 AM To: arslist@ARSLIST.ORG Subject: Application not accessible through BMC Remedy Administrator ** Hi Folks, Hope someone can help me in this issue. First I want to inform you that we are on a very old release. Our env. is: AR-Server: 7.0.01 patch 2 OS: HP-UX B.11.11 DB: Oracle 10.2.0.5.0 64bit MidTier: Version 7.0.01 Patch 002 200703132023 OS: Windows 2003 Server Now to describe the issue. Since 2 weeks we’ve got a couple timeout errors in Midtier. After enabling SQL/API logs we have found that the problem should be in one of our applications. But when I try to open the application in BMC Remedy Administrator it says “Application does not exists”. If I try to right click on it (to delete it), Remedy Administrator closes automatically. So it seems that I need to remove it on DB level but have not enough knowledge about DB structure. There are all custom applications. No ITSM. I have found the name of the application in table “arcontainer” but I am not sure if I delete the record from there will not destroy the DB consistency. Unfortunately I have no test environment where I can try this. We are only with a production one and need to be very careful in all these changes. Thanks in advance for everyone spending a time for me. Kind Regards, Georgi Paunov Remedy Administration Tel.: +359 675 30200 E-mail: Remedy-Administratormailto:remedy-administra...@idealstandard.com@IdealStandard.commailto:n...@idealstandard.com _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: DevStudio Tool
Damn!!! I hadn’t seen that.. Like I said I have not read any docs on the new version.. all my knowledge so far is by using it directly.. Thanks for that tip.. One more for the ‘panel’... Joe From: Greg Donalson Sent: Friday, March 30, 2012 10:17 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: DevStudio Tool ** Hi, The “Work with fields not in view” can be done today. 1) Open the form that has the field in it that you want to change. 2) Open the Outline (Window - Show View - Outline) 3) In the top right, one of the Icons is “Show Fields not in View” 4) Select the field that you would like to change 5) From here, you can Open the Properties (go to Window - Show View - Properties) or right-click and Create Overlay 6) Once you open the Properties, you can see all the Properties of that field even though it is not in the view and you can make changes to it. Thanks! Greg From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Guillaume Rheault Sent: Friday, March 30, 2012 8:49 AM To: arslist@ARSLIST.ORG Subject: Re: DevStudio Tool ** Hola Jose Thanks for the clarification, you make interesting points. We know that David Easter monitors the ARS list, so maybe he can chime in on what he thinks about this Guillaume From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] on behalf of Jose Huerta [jose.hue...@sm2baleares.es] Sent: Friday, March 30, 2012 5:14 AM To: arslist@ARSLIST.ORG Subject: Re: DevStudio Tool ** Guillaume, I know that Remedy development is very different from structured or object programming. But my point is about the quality and possibilities of their development tools. I will explain in detail what I consider essential: ONLINE DEBUG: There is a tool in Remedy that allows you to debug step by step. But it's text based. I want to log in in debug mode, that executes normally. Set breakpoints at some filters. When these filters arrive stop execution, see the fields values at this particular moment, and continue executing filters step by step. If this can be done by text, Why is it not possible to do through dev studio? UNITARY TEST: Configure some actions (like creating a request with some values or call a service action with some values) and program the expected behavior. So when you run the unitary test the system checks it. Maintaining a library of unitary tests on your system and reexecuting them at every change, you get more control. I do it now, with some very complex situations, but I need to use SOAPUI to call a web service and get the response, checking it to see if it is valid. GRAPHICAL ENHANCEMENTS LIKE BLOCKING OR HIDDING: Set some elements in a view and group them in layers. Then you can easily hide a layer, but only when editing. Or you can block a layer, to be sure you can't select it. ENFORCEMENT OF BEST PRACTICES: Have a set of best practices configured (like naming convention) and the system automatically checks them. So if you brake a best practice the system warms you. WORK WITH FIELDS NOT IN VIEW: If you want to reconfigure or change a field that is not present in any view, then you must add it (where you can't search it from the fieldid, only by the name) to a view, change it and remove it again from the view. ENHANCED SEARCH: I can only search elements from one criteria. And the available criteria is not enough. If I want to list all filters with some word in the name that are part of a particular application, this is not possible. If I want to know which filters are used in a particular form, this is not possible (I can only search for the primary form, but not shared). I want to list all filters that use a particular field in the qualification, this is not possible. I have a Remedy form that feeds from the Remedy's data dictionary that can perform all these searches. Under my point of view, the developer studio has the minimum set of feature to allow developing, but it is far from being a good tool. Regards, Jose Huerta http://theremedyforit.com/ On Thu, Mar 29, 2012 at 15:55, Guillaume Rheault guilla...@dcshq.com wrote: ** Jose, I think some of the points you mention are not applicable in the ARS world, since as you very well know, ARS is not a 3rd generation language like java or .net. The general consensus is that ARS is greater than a 4th generation language, it's either 4.5 or 5th generation. As a point of reference PL/SQL and T-SQL are 4th generation languages. Therefore you cannot really compare the developer tool of a of 5th generation language with the developer tool of a 3rd generation language. We need to compare apples to apples and oranges to oranges to make an objective and rational comparison.
BMC Analytics Report Question - Report of Multiple Associations to Almost All of the ITSM Apps
Hello, I haven't used Analytics and I need to know if a particular report is even possible to be generated. Here is the back ground: We have a process that a ordinary business user will submit a request via SRM (Service Request Management). Management will either Approve or Reject the Request. Once the Request is approved, it will generate a Work Order. The Work Order will be the holding bin for the Request and it is prioritized and analyzed. After determining this Request is ready to be put into Production, the support group will generate a Change Request and relate the Work Order. There can be 2 paths for the Change Request - 1) Only a Change Request or 2) A Change Request with a Release. (The Release must be related to the Work Order) So essentially the Work Order becomes the Parent Record with all other Relationships tied to it. WO-- (PARENT) INC -- (RELATED TO WO. This is another optional relationship, not noted above) CRQ -- (RELATED TO WO) RLM -- (RELATED TO WO) Here is what I need for a Report out of Analytics - I need a report that has all of the Related records from the Work Order (INC, CRQ, RLM, AAS, TSK, etc). This report should show me the basic information of each Record (Record ID #, Assignment, Customer, Summary, Status, Status History, Target Dates, Scheduled Dates, etc) --- I have looked into creating a report outside of Analytics with using Joins (WOI:Associations + WOI:WorkOrder), however to get to the basic level of information for the main apps, I would need to create joins to at least 7 levels, ouch! Please, let me know if Analytics can handle this type of reporting as it is critical to our management and support staff. Thanks, Andre ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: DevStudio Tool
Actually it doesn’t work in 7.6.03.. I just tried it on a form that has some fields not in view.. and when I click the ‘Show Fields Not In Any View’ doesn’t work.. Shows me a blank list when I actually do have fields not in view.. I wonder if it strictly shows fields not in ANY view.. meaning if they are not in any view at all.. In that case I would have liked if it did show fields not in the current view but might be present in other views.. I tried it with a field that is not in ANY view and it does work for that.. so it’s a functionality that looks like is partially implemented.. And by the name of it, its something that BMC can definitely claim to be working as designed.. What Jose was requesting for is the other set of fields as well.. which are not in the current view.. The only property information on these fields that are in other views and not in the current view that could be grayed out or not displayed is view specific information such as positioning.. Joe From: Guillaume Rheault Sent: Friday, March 30, 2012 10:51 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: DevStudio Tool ** The WORK WITH FIELDS NOT IN VIEW works great with 7.6.04 SP2. Not sure if it works well with 7.6.03, so we can scratch that of the list, can't we? From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] on behalf of Joe Martin D'Souza [jdso...@shyle.net] Sent: Friday, March 30, 2012 10:46 AM To: arslist@ARSLIST.ORG Subject: Re: DevStudio Tool ** I think that among all your ideas, the one I like best is WORK WITH FIELDS NOT IN VIEW. And possibly with minimum code change to the DS as it stands right now.. All it would take is instead of populating the Field Properties pane only on clicking on the field, to have the ability to switch that properties pane in a search mode and type out the DB Name of fields not in view, and fetch their properties.. Gray out the areas of properties where fields not in view do not get set any values so the user cannot change those.. Its would be a simple query to the meta-data to fetch that information.. Great idea.. I like it.. Love it actually... Maybe you should submit an RFE for this.. In the RFE the obvious advantage you can state is that you do not have to dirty a form or its view by bringing it in view just to view that fields property. It’s a big seller.. Everyone would benefit by this and not just a small group of people so it should be something that should get a good consideration.. I also like the ONLINE DEBUG. This however has been something that we as a community have been suggesting ever since I was new to this whole Remedy world.. and that’s more than a decade.. If it still hasn’t happened, I don’t see it happening anytime too soon. It must have come on their tables as an RFE 10 times over already and has been turned down or probably deferred indefinitely.. Joe From: Grooms, Frederick W Sent: Friday, March 30, 2012 10:05 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: DevStudio Tool ** For ENHANCED SEARCH of filters to any form try the following Make a working list of all directly related items to a form and then use the filtering options against that. Fred From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jose Huerta Sent: Friday, March 30, 2012 4:15 AM To: arslist@ARSLIST.ORG Subject: Re: DevStudio Tool ** Guillaume, I know that Remedy development is very different from structured or object programming. But my point is about the quality and possibilities of their development tools. I will explain in detail what I consider essential: ONLINE DEBUG: There is a tool in Remedy that allows you to debug step by step. But it's text based. I want to log in in debug mode, that executes normally. Set breakpoints at some filters. When these filters arrive stop execution, see the fields values at this particular moment, and continue executing filters step by step. If this can be done by text, Why is it not possible to do through dev studio? UNITARY TEST: Configure some actions (like creating a request with some values or call a service action with some values) and program the expected behavior. So when you run the unitary test the system checks it. Maintaining a library of unitary tests on your system and reexecuting them at every change, you get more control. I do it now, with some very complex situations, but I need to use SOAPUI to call a web service and get the response, checking it to see if it is valid. GRAPHICAL ENHANCEMENTS LIKE BLOCKING OR HIDDING: Set some elements in a view and group them in layers. Then you can easily hide a layer, but only when editing. Or you can block a layer, to be sure you can't select it. ENFORCEMENT OF BEST PRACTICES: Have a set of best
Re: DevStudio Tool
You know you get your registration fee taken care of if you present!! :) Something to think about! Thanks! Lisa From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Wednesday, March 28, 2012 10:49 PM To: arslist@ARSLIST.ORG Subject: Re: DevStudio Tool ** Yes a Panel is a great idea.. Where you as an audience can ask the how to type questions and we as a panel of users who are more friendlier with the Studio can answer if there is an answer to it and share our views.. Maybe we could as a panel share our experiences first, which may answer majority of the how to questions, and then have a open question answer session in the end.. Joe From: Susan Palmermailto:suzanpal...@gmail.com Sent: Wednesday, March 28, 2012 10:39 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: DevStudio Tool ** Joe ... maybe a panel situation would be more comfortable for you. I think having a projection of the tool and then showing what you're talking about would be great. Especially when answering questions. Skip the slides, we want the real tool in action. I know the wwrug team likes 'presentations' but maybe this would be an option for this type of group. I don't think you'd even have to prepare more than a couple points already mentioned here (choose mine please) and the rest will generate from the crowd. On Wed, Mar 28, 2012 at 9:34 PM, Joe Martin D'Souza jdso...@shyle.netmailto:jdso...@shyle.net wrote: ** Importing and exporting workflow can chew up memory fast. The default heap settings are next to nothing and you need a minimum of 2Gig to run Devstudio. Admin tool could get by with 1Gig or less. Have you increased the heap on the import ini configuration file? There are more files than just the development studio's ini file where you can adjust your heap size. I hate 2 and 3 too.. experienced those things myself as well where after what seems like you selected the field it just disappears and the 2nd time you select it, it sticks... So yea Rod actually managed to point 2 things that I find to be clumsy too.. But the advantages outweigh these so these few quirks just seem to be overshadowed.. Thank you for pointing these up and I think if BMC is watching, they ought to do something about these things.. Joe From: Rod Harrismailto:r...@smapps.com.au Sent: Wednesday, March 28, 2012 10:22 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: DevStudio Tool ** Hi Dan, Joe and everyone, I've been using Dev Studio since 7.5 first came out and I would never consider going back to the old admin tool. Whilst you certainly need a high resolution screen and you should go 64bit and up your heap from the default there are plenty of huge upsides in dev studio. My favourites are: 1. The Outline View and the ability to sort fields by ID or by label or by name to find the field you need quickly. 2. Once you find the field the show relationships feature will enable you to drill in to the right workflow quickly and to be confident that you have captured all of the impacts. 3. If you need to bulk change a whole bunch of fields, active links or anything else you can usually select the objects and use the properties page to do a bulk update. 4. Autocomplete, built in help and syntax checking are nice especially now that the bugs seem to have been removed. There were some nasty ones in the early 7.5 releases The bad things 1. Importing and exporting workflow can chew up memory fast. The default heap settings are next to nothing and you need a minimum of 2Gig to run Devstudio. Admin tool could get by with 1Gig or less. 2. I miss the ease of moving around a bunch of fields using the arrow keys. This feature is there but it doesn't seem to work as well. There also seems to be some bugs with group moving/resizing fields in devstudio still 3. Sometimes I select fields to add to a setfields or push fields and they don't take. I have to select the field again. This bug has been around since day 1 and I'm not sure it has been fixed. So on the whole I love devstudio. Fix the bugs, extend the syntax help to the run process commands, improve the memory utilisation and I'll be even happier. I'm loving my new laptop with the full HD screen and 8 Gig too. Rod Harris On 29 March 2012 09:59, Joe Martin D'Souza jdso...@shyle.netmailto:jdso...@shyle.net wrote: Yea I like that one too.. And that you can switch between an AL list and a Filter list without waiting for a coffee break or a cigarette break to get your session back - especially since I have stopped drinking coffee and reduced my smoking to almost nothing! -Original Message- From: bullcreek.comhttp://bullcreek.com/ Sent: Wednesday, March 28, 2012 9:28 PM Newsgroups: public.remedy.arsystem.general
Re: DevStudio Tool
That being said, one of the best kept secrets of the Texas Remedy User's Group (TRUG) is our Panel discussion typically held at the end of the meeting which has always beena big hit. We have had such Remedy Brain Trust participants as Dr. Christopher Strauss, ARnold Noche, and others. Even if we have a presentation from Joe or others, there is always the Birds of a Feather(BOF) session series after the Technical/Breakout Sessions at WWRUG where you can sign up to host a BOF and use the same rooms, microphones, podium etc. that the sessions do and there is essentially not a 45 minute time limitation as there are in the sessions. Jus' sayin' :-) Phil Bautista President / CEO Bull Creek Data Corporation www.bullcreek.com Remedy Approved Consultant (RAC) http://www.wwrug.com/contact_phil.html 512-731-0304 -Original message- From: Kemes, Lisa lisa.ke...@te.com Date: Fri, 30 Mar 2012 11:44:47 -0400 To: arslist@ARSLIST.ORG Subject: Re: DevStudio Tool You know you get your registration fee taken care of if you present!! :) Something to think about! Thanks! Lisa From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIS T.ORG] On Behalf Of Joe Martin D'Souza Sent: Wednesday, March 28, 2012 10:49 PM To: arslist@ARSLIST.ORG Subject: Re: DevStudio Tool ** Yes a Panel is a great idea.. Where you as an audience can ask the how to t ype questions and we as a panel of users who are more friendlier with the S tudio can answer if there is an answer to it and share our views.. Maybe we could as a panel share our experiences first, which may answer maj ority of the how to questions, and then have a open question answer session in the end.. Joe From: Susan Palmermailto:suzanpal...@gmail.com Sent: Wednesday, March 28, 2012 10:39 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: DevStudio Tool ** Joe ... maybe a panel situation would be more comfortable for you. I th ink having a projection of the tool and then showing what you're talking ab out would be great. Especially when answering questions. Skip the slides, we want the real tool in action. I know the wwrug team likes 'presentatio ns' but maybe this would be an option for this type of group. I don't think you'd even have to prepare more than a couple points already mentioned here (choose mine please) and the rest will generate from the cro wd. On Wed, Mar 28, 2012 at 9:34 PM, Joe Martin D'Souza jdso...@shyle.netmail to:jdso...@shyle.net wrote: ** Importing and exporting workflow can chew up memory fast. The default heap settings are next to nothing and you need a minimum of 2Gig to run Devstud io. Admin tool could get by with 1Gig or less. Have you increased the heap on the import ini configuration file? There are more files than just the development studio's ini file where you can adjus t your heap size. I hate 2 and 3 too.. experienced those things myself as well where after wh at seems like you selected the field it just disappears and the 2nd time yo u select it, it sticks... So yea Rod actually managed to point 2 things that I find to be clumsy too. . But the advantages outweigh these so these few quirks just seem to be ove rshadowed.. Thank you for pointing these up and I think if BMC is watching, they ought to do something about these things.. Joe From: Rod Harrismailto:r...@smapps.com.au Sent: Wednesday, March 28, 2012 10:22 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: DevStudio Tool ** Hi Dan, Joe and everyone, I've been using Dev Studio since 7.5 first came out and I would never consi der going back to the old admin tool. Whilst you certainly need a high reso lution screen and you should go 64bit and up your heap from the default th ere are plenty of huge upsides in dev studio. My favourites are: 1. The Outline View and the ability to sort fields by ID or by label or b y name to find the field you need quickly. 2. Once you find the field the show relationships feature will enable you to drill in to the right workflow quickly and to be confident that you hav e captured all of the impacts. 3. If you need to bulk change a whole bunch of fields, active links or an ything else you can usually select the objects and use the properties page to do a bulk update. 4. Autocomplete, built in help and syntax checking are nice especially no w that the bugs seem to have been removed. There were some nasty ones in th e early 7.5 releases The bad things 1. Importing and exporting workflow can chew up memory fast. The default heap settings are next to nothing and you need a minimum of 2Gig to run Dev studio. Admin tool could get by with 1Gig or less. 2. I miss the ease of moving around a bunch of fields
Re: DevStudio Tool
Yup Dan wrote me that on an offline and its something I’m considering.. Travel may not cost me much as I can leverage my frequent flyer benefits to get ‘free’ stuff... I’ll need to check what is scheduled during that period at the customer site I am at right now.. Joe From: Kemes, Lisa Sent: Friday, March 30, 2012 11:44 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: DevStudio Tool ** You know you get your registration fee taken care of if you present!! :) Something to think about! Thanks! Lisa From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Wednesday, March 28, 2012 10:49 PM To: arslist@ARSLIST.ORG Subject: Re: DevStudio Tool ** Yes a Panel is a great idea.. Where you as an audience can ask the how to type questions and we as a panel of users who are more friendlier with the Studio can answer if there is an answer to it and share our views.. Maybe we could as a panel share our experiences first, which may answer majority of the how to questions, and then have a open question answer session in the end.. Joe From: Susan Palmer Sent: Wednesday, March 28, 2012 10:39 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: DevStudio Tool ** Joe ... maybe a panel situation would be more comfortable for you. I think having a projection of the tool and then showing what you're talking about would be great. Especially when answering questions. Skip the slides, we want the real tool in action. I know the wwrug team likes 'presentations' but maybe this would be an option for this type of group. I don't think you'd even have to prepare more than a couple points already mentioned here (choose mine please) and the rest will generate from the crowd. On Wed, Mar 28, 2012 at 9:34 PM, Joe Martin D'Souza jdso...@shyle.net wrote: ** “Importing and exporting workflow can chew up memory fast. The default heap settings are next to nothing and you need a minimum of 2Gig to run Devstudio. Admin tool could get by with 1Gig or less. “ Have you increased the heap on the import ini configuration file? There are more files than just the development studio’s ini file where you can adjust your heap size. I hate 2 and 3 too.. experienced those things myself as well where after what seems like you selected the field it just disappears and the 2nd time you select it, it sticks... So yea Rod actually managed to point 2 things that I find to be clumsy too.. But the advantages outweigh these so these few quirks just seem to be overshadowed.. Thank you for pointing these up and I think if BMC is watching, they ought to do something about these things.. Joe From: Rod Harris Sent: Wednesday, March 28, 2012 10:22 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: DevStudio Tool ** Hi Dan, Joe and everyone, I've been using Dev Studio since 7.5 first came out and I would never consider going back to the old admin tool. Whilst you certainly need a high resolution screen and you should go 64bit and up your heap from the default there are plenty of huge upsides in dev studio. My favourites are: 1.. The Outline View and the ability to sort fields by ID or by label or by name to find the field you need quickly. 2.. Once you find the field the show relationships feature will enable you to drill in to the right workflow quickly and to be confident that you have captured all of the impacts. 3.. If you need to bulk change a whole bunch of fields, active links or anything else you can usually select the objects and use the properties page to do a bulk update. 4.. Autocomplete, built in help and syntax checking are nice especially now that the bugs seem to have been removed. There were some nasty ones in the early 7.5 releases The bad things 1.. Importing and exporting workflow can chew up memory fast. The default heap settings are next to nothing and you need a minimum of 2Gig to run Devstudio. Admin tool could get by with 1Gig or less. 2.. I miss the ease of moving around a bunch of fields using the arrow keys. This feature is there but it doesn't seem to work as well. There also seems to be some bugs with group moving/resizing fields in devstudio still 3.. Sometimes I select fields to add to a setfields or push fields and they don't take. I have to select the field again. This bug has been around since day 1 and I'm not sure it has been fixed. So on the whole I love devstudio. Fix the bugs, extend the syntax help to the run process commands, improve the memory utilisation and I'll be even happier. I'm loving my new laptop with the full HD screen and 8 Gig too. Rod Harris On 29 March 2012 09:59, Joe Martin D'Souza jdso...@shyle.net wrote: Yea I
ADDM
Hi, I'm totally new to ADDM and have been requested to run a report to find instances of a product called pointsec. I've been asked to provide: Computer Name/Make/Model/OS/IP Address/Path and the path the software instance is found. I was given the following information about the product location for a file called *.rec: Windows XP: Documents and Settings\All Users\Application Data\Pointsec Documents and Settings\All Users\Application Data\Pointsec\Pointsec for PC Windows Vista/7: C:\Users\All Users\Pointsec for PC I am not a programmer and have no idea how to get this information into a report. I can see the instances of pointsec under discovered service, but don't know how to get the needed information and columns. Can anyone help? Thanks. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Can remedy code push cause DB crash, etc?
Hi All, Very recently I performed Remedy code push on our production server. This involved importing some new forms and related workflow and also modifying existing forms like HelpDesk and Change forms.(Using ARAdmin tool) I tested this same on our Dev and QA Servers and the code push was a success without any issues. But when I performed this on our Production server, it caused DB crash and brought down Remedy. The outage was caused by the fact that the database became unresponsive. After we brought back Remedy, we noticed some of the DB view needed to be recompiled. As we are still investigating if it has to do with issues in non remedy components but we couldn't find any solid clues and ultimately brings it back to Remedy code push. Here are the logs : -- Wed Mar 28 01:09:59 2012 Distrib : AR System Distributed Server terminated when a signal was received by the server (ARDSNOTE 3000) Wed Mar 28 01:09:59 2012 15 Wed Mar 28 01:09:59 2012 Distrib : AR System Distributed Server terminated when a signal was received by the server (ARDSNOTE 3000) Wed Mar 28 01:09:59 2012 15 Wed Mar 28 01:11:23 2012 390600 : Requested database table not found. Please check the spelling (table name is case-sensitive) (ARERR 481) Wed Mar 28 01:29:29 2012 390620 : Failure while trying to connect to the SQL database. Please ensure the SQL database is running or contact the Database Administrator for help (ARERR 550) Wed Mar 28 01:29:29 2012 ORA-12535: TNS:operation timed out Wed Mar 28 01:29:29 2012 390620 : Cannot initialize contact with SQL database (ARERR 551) Wed Mar 28 01:29:29 2012 Thread 67 not handling connection --- At this point, I would like to understand from experts in here to see if anything like the above mentioned is possible? If yes, what could be the reasons and what can I look into to find the root cause. Thanks, Raj ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Can remedy code push cause DB crash, etc?
Sorry, missed the environment info: Server : 5.01.02 Patch 1313 Hardware : sun4u OS: SunOS 5.10 DB: SQL -- Oracle DB Version : 0.2.0.5.0 - 64bi On Mar 30, 11:30 am, Raj ravi6...@gmail.com wrote: Hi All, Very recently I performed Remedy code push on our production server. This involved importing some new forms and related workflow and also modifying existing forms like HelpDesk and Change forms.(Using ARAdmin tool) I tested this same on our Dev and QA Servers and the code push was a success without any issues. But when I performed this on our Production server, it caused DB crash and brought down Remedy. The outage was caused by the fact that the database became unresponsive. After we brought back Remedy, we noticed some of the DB view needed to be recompiled. As we are still investigating if it has to do with issues in non remedy components but we couldn't find any solid clues and ultimately brings it back to Remedy code push. Here are the logs : -- Wed Mar 28 01:09:59 2012 Distrib : AR System Distributed Server terminated when a signal was received by the server (ARDSNOTE 3000) Wed Mar 28 01:09:59 2012 15 Wed Mar 28 01:09:59 2012 Distrib : AR System Distributed Server terminated when a signal was received by the server (ARDSNOTE 3000) Wed Mar 28 01:09:59 2012 15 Wed Mar 28 01:11:23 2012 390600 : Requested database table not found. Please check the spelling (table name is case-sensitive) (ARERR 481) Wed Mar 28 01:29:29 2012 390620 : Failure while trying to connect to the SQL database. Please ensure the SQL database is running or contact the Database Administrator for help (ARERR 550) Wed Mar 28 01:29:29 2012 ORA-12535: TNS:operation timed out Wed Mar 28 01:29:29 2012 390620 : Cannot initialize contact with SQL database (ARERR 551) Wed Mar 28 01:29:29 2012 Thread 67 not handling connection --- At this point, I would like to understand from experts in here to see if anything like the above mentioned is possible? If yes, what could be the reasons and what can I look into to find the root cause. Thanks, Raj ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org attend wwrug12www.wwrug12.comARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Can remedy code push cause DB crash, etc?
Typo ; DB Version : 10.2.0.5.0 - 64bi On Mar 30, 11:33 am, Raj ravi6...@gmail.com wrote: Sorry, missed the environment info: Server : 5.01.02 Patch 1313 Hardware : sun4u OS: SunOS 5.10 DB: SQL -- Oracle DB Version : 0.2.0.5.0 - 64bi On Mar 30, 11:30 am, Raj ravi6...@gmail.com wrote: Hi All, Very recently I performed Remedy code push on our production server. This involved importing some new forms and related workflow and also modifying existing forms like HelpDesk and Change forms.(Using ARAdmin tool) I tested this same on our Dev and QA Servers and the code push was a success without any issues. But when I performed this on our Production server, it caused DB crash and brought down Remedy. The outage was caused by the fact that the database became unresponsive. After we brought back Remedy, we noticed some of the DB view needed to be recompiled. As we are still investigating if it has to do with issues in non remedy components but we couldn't find any solid clues and ultimately brings it back to Remedy code push. Here are the logs : -- Wed Mar 28 01:09:59 2012 Distrib : AR System Distributed Server terminated when a signal was received by the server (ARDSNOTE 3000) Wed Mar 28 01:09:59 2012 15 Wed Mar 28 01:09:59 2012 Distrib : AR System Distributed Server terminated when a signal was received by the server (ARDSNOTE 3000) Wed Mar 28 01:09:59 2012 15 Wed Mar 28 01:11:23 2012 390600 : Requested database table not found. Please check the spelling (table name is case-sensitive) (ARERR 481) Wed Mar 28 01:29:29 2012 390620 : Failure while trying to connect to the SQL database. Please ensure the SQL database is running or contact the Database Administrator for help (ARERR 550) Wed Mar 28 01:29:29 2012 ORA-12535: TNS:operation timed out Wed Mar 28 01:29:29 2012 390620 : Cannot initialize contact with SQL database (ARERR 551) Wed Mar 28 01:29:29 2012 Thread 67 not handling connection --- At this point, I would like to understand from experts in here to see if anything like the above mentioned is possible? If yes, what could be the reasons and what can I look into to find the root cause. Thanks, Raj ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org attend wwrug12www.wwrug12.comARSList:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org attend wwrug12www.wwrug12.comARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Can remedy code push cause DB crash, etc?
Depending on what you were doing ... Yes the application could become unresponsive (Especially if users were still using the system). Did you put your system into Admin mode before doing the change? Since you are on ARS 5.01.02, If you were doing anything like changing the size of a column or deleting a column on an existing form the system has to rename the table and copy the data over to a new table (with the new structure). Newer versions of the ARS server no longer need to do this (ARS 5.01.02 is from like 2005). Also ... Does your non production system have the same number of records in the table being changed (more records will of course result in an increased time for a change). Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Raj Sent: Friday, March 30, 2012 1:34 PM To: arslist@ARSLIST.ORG Subject: Re: Can remedy code push cause DB crash, etc? Sorry, missed the environment info: Server : 5.01.02 Patch 1313 Hardware : sun4u OS: SunOS 5.10 DB: SQL -- Oracle DB Version : 10.2.0.5.0 - 64bi On Mar 30, 11:30 am, Raj ravi6...@gmail.com wrote: Hi All, Very recently I performed Remedy code push on our production server. This involved importing some new forms and related workflow and also modifying existing forms like HelpDesk and Change forms.(Using ARAdmin tool) I tested this same on our Dev and QA Servers and the code push was a success without any issues. But when I performed this on our Production server, it caused DB crash and brought down Remedy. The outage was caused by the fact that the database became unresponsive. After we brought back Remedy, we noticed some of the DB view needed to be recompiled. As we are still investigating if it has to do with issues in non remedy components but we couldn't find any solid clues and ultimately brings it back to Remedy code push. Here are the logs : -- Wed Mar 28 01:09:59 2012 Distrib : AR System Distributed Server terminated when a signal was received by the server (ARDSNOTE 3000) Wed Mar 28 01:09:59 2012 15 Wed Mar 28 01:09:59 2012 Distrib : AR System Distributed Server terminated when a signal was received by the server (ARDSNOTE 3000) Wed Mar 28 01:09:59 2012 15 Wed Mar 28 01:11:23 2012 390600 : Requested database table not found. Please check the spelling (table name is case-sensitive) (ARERR 481) Wed Mar 28 01:29:29 2012 390620 : Failure while trying to connect to the SQL database. Please ensure the SQL database is running or contact the Database Administrator for help (ARERR 550) Wed Mar 28 01:29:29 2012 ORA-12535: TNS:operation timed out Wed Mar 28 01:29:29 2012 390620 : Cannot initialize contact with SQL database (ARERR 551) Wed Mar 28 01:29:29 2012 Thread 67 not handling connection --- At this point, I would like to understand from experts in here to see if anything like the above mentioned is possible? If yes, what could be the reasons and what can I look into to find the root cause. Thanks, Raj ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Can remedy code push cause DB crash, etc?
Been there. Done that. In my case, we ran up against not enough temp space and froze the system. Dave -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Raj Sent: Friday, March 30, 2012 2:36 PM To: arslist@ARSLIST.ORG Subject: Re: Can remedy code push cause DB crash, etc? Typo ; DB Version : 10.2.0.5.0 - 64bi On Mar 30, 11:33 am, Raj ravi6...@gmail.com wrote: Sorry, missed the environment info: Server : 5.01.02 Patch 1313 Hardware : sun4u OS: SunOS 5.10 DB: SQL -- Oracle DB Version : 0.2.0.5.0 - 64bi On Mar 30, 11:30 am, Raj ravi6...@gmail.com wrote: Hi All, Very recently I performed Remedy code push on our production server. This involved importing some new forms and related workflow and also modifying existing forms like HelpDesk and Change forms.(Using ARAdmin tool) I tested this same on our Dev and QA Servers and the code push was a success without any issues. But when I performed this on our Production server, it caused DB crash and brought down Remedy. The outage was caused by the fact that the database became unresponsive. After we brought back Remedy, we noticed some of the DB view needed to be recompiled. As we are still investigating if it has to do with issues in non remedy components but we couldn't find any solid clues and ultimately brings it back to Remedy code push. Here are the logs : -- Wed Mar 28 01:09:59 2012 Distrib : AR System Distributed Server terminated when a signal was received by the server (ARDSNOTE 3000) Wed Mar 28 01:09:59 2012 15 Wed Mar 28 01:09:59 2012 Distrib : AR System Distributed Server terminated when a signal was received by the server (ARDSNOTE 3000) Wed Mar 28 01:09:59 2012 15 Wed Mar 28 01:11:23 2012 390600 : Requested database table not found. Please check the spelling (table name is case-sensitive) (ARERR 481) Wed Mar 28 01:29:29 2012 390620 : Failure while trying to connect to the SQL database. Please ensure the SQL database is running or contact the Database Administrator for help (ARERR 550) Wed Mar 28 01:29:29 2012 ORA-12535: TNS:operation timed out Wed Mar 28 01:29:29 2012 390620 : Cannot initialize contact with SQL database (ARERR 551) Wed Mar 28 01:29:29 2012 Thread 67 not handling connection --- At this point, I would like to understand from experts in here to see if anything like the above mentioned is possible? If yes, what could be the reasons and what can I look into to find the root cause. Thanks, Raj ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org attend wwrug12www.wwrug12.comARSList:Where the Answers Are __ _ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org attend wwrug12www.wwrug12.comARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Can remedy code push cause DB crash, etc?
No, we did not put our system into Admin mode. Should we consider this from now onwards on our future releases? When is this required?( Just trying to understand, when is this required.) My changes involved adding new table,2 new fields(2-buttons) on HPD and CHG forms and also modifying (adding 6 new fields on) some of our existing heavily customized forms. No, our non production server do not have same number of records but very very less compared to our production server. On Mar 30, 11:43 am, Grooms, Frederick W frederick.w.gro...@xo.com wrote: Depending on what you were doing ... Yes the application could become unresponsive (Especially if users were still using the system). Did you put your system into Admin mode before doing the change? Since you are on ARS 5.01.02, If you were doing anything like changing the size of a column or deleting a column on an existing form the system has to rename the table and copy the data over to a new table (with the new structure). Newer versions of the ARS server no longer need to do this (ARS 5.01.02 is from like 2005). Also ... Does your non production system have the same number of records in the table being changed (more records will of course result in an increased time for a change). Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Raj Sent: Friday, March 30, 2012 1:34 PM To: arsl...@arslist.org Subject: Re: Can remedy code push cause DB crash, etc? Sorry, missed the environment info: Server : 5.01.02 Patch 1313 Hardware : sun4u OS: SunOS 5.10 DB: SQL -- Oracle DB Version : 10.2.0.5.0 - 64bi On Mar 30, 11:30 am, Raj ravi6...@gmail.com wrote: Hi All, Very recently I performed Remedy code push on our production server. This involved importing some new forms and related workflow and also modifying existing forms like HelpDesk and Change forms.(Using ARAdmin tool) I tested this same on our Dev and QA Servers and the code push was a success without any issues. But when I performed this on our Production server, it caused DB crash and brought down Remedy. The outage was caused by the fact that the database became unresponsive. After we brought back Remedy, we noticed some of the DB view needed to be recompiled. As we are still investigating if it has to do with issues in non remedy components but we couldn't find any solid clues and ultimately brings it back to Remedy code push. Here are the logs : -- Wed Mar 28 01:09:59 2012 Distrib : AR System Distributed Server terminated when a signal was received by the server (ARDSNOTE 3000) Wed Mar 28 01:09:59 2012 15 Wed Mar 28 01:09:59 2012 Distrib : AR System Distributed Server terminated when a signal was received by the server (ARDSNOTE 3000) Wed Mar 28 01:09:59 2012 15 Wed Mar 28 01:11:23 2012 390600 : Requested database table not found. Please check the spelling (table name is case-sensitive) (ARERR 481) Wed Mar 28 01:29:29 2012 390620 : Failure while trying to connect to the SQL database. Please ensure the SQL database is running or contact the Database Administrator for help (ARERR 550) Wed Mar 28 01:29:29 2012 ORA-12535: TNS:operation timed out Wed Mar 28 01:29:29 2012 390620 : Cannot initialize contact with SQL database (ARERR 551) Wed Mar 28 01:29:29 2012 Thread 67 not handling connection --- At this point, I would like to understand from experts in here to see if anything like the above mentioned is possible? If yes, what could be the reasons and what can I look into to find the root cause. Thanks, Raj ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org attend wwrug12www.wwrug12.comARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Can remedy code push cause DB crash, etc?
Yup exactly, we noticed the same thing. DB ran out of temp space and ultimately crashed. What are your recommendations, how can we avoid this in future? On Mar 30, 11:47 am, Shellman, David dave.shell...@te.com wrote: Been there. Done that. In my case, we ran up against not enough temp space and froze the system. Dave -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Raj Sent: Friday, March 30, 2012 2:36 PM To: arsl...@arslist.org Subject: Re: Can remedy code push cause DB crash, etc? Typo ; DB Version : 10.2.0.5.0 - 64bi On Mar 30, 11:33 am, Raj ravi6...@gmail.com wrote: Sorry, missed the environment info: Server : 5.01.02 Patch 1313 Hardware : sun4u OS: SunOS 5.10 DB: SQL -- Oracle DB Version : 0.2.0.5.0 - 64bi On Mar 30, 11:30 am, Raj ravi6...@gmail.com wrote: Hi All, Very recently I performed Remedy code push on our production server. This involved importing some new forms and related workflow and also modifying existing forms like HelpDesk and Change forms.(Using ARAdmin tool) I tested this same on our Dev and QA Servers and the code push was a success without any issues. But when I performed this on our Production server, it caused DB crash and brought down Remedy. The outage was caused by the fact that the database became unresponsive. After we brought back Remedy, we noticed some of the DB view needed to be recompiled. As we are still investigating if it has to do with issues in non remedy components but we couldn't find any solid clues and ultimately brings it back to Remedy code push. Here are the logs : -- Wed Mar 28 01:09:59 2012 Distrib : AR System Distributed Server terminated when a signal was received by the server (ARDSNOTE 3000) Wed Mar 28 01:09:59 2012 15 Wed Mar 28 01:09:59 2012 Distrib : AR System Distributed Server terminated when a signal was received by the server (ARDSNOTE 3000) Wed Mar 28 01:09:59 2012 15 Wed Mar 28 01:11:23 2012 390600 : Requested database table not found. Please check the spelling (table name is case-sensitive) (ARERR 481) Wed Mar 28 01:29:29 2012 390620 : Failure while trying to connect to the SQL database. Please ensure the SQL database is running or contact the Database Administrator for help (ARERR 550) Wed Mar 28 01:29:29 2012 ORA-12535: TNS:operation timed out Wed Mar 28 01:29:29 2012 390620 : Cannot initialize contact with SQL database (ARERR 551) Wed Mar 28 01:29:29 2012 Thread 67 not handling connection --- At this point, I would like to understand from experts in here to see if anything like the above mentioned is possible? If yes, what could be the reasons and what can I look into to find the root cause. Thanks, Raj ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org attend wwrug12www.wwrug12.comARSList:Where the Answers Are __ _ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org attend wwrug12www.wwrug12.comARSList:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgattend wwrug12www.wwrug12.comARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org attend wwrug12www.wwrug12.comARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: BMC Analytics Report Question - Report of Multiple Associations to Almost All of the ITSM Apps
Yes And no. That kind id report os posible, but not using the out of the box universe. You need to customize the universe or create a new one. The info is at the database and BOXI can handle it. I've done more difficult reports, but always creating a new universe. El viernes 30 de marzo de 2012, Andre Hughes escribió: Hello, I haven't used Analytics and I need to know if a particular report is even possible to be generated. Here is the back ground: We have a process that a ordinary business user will submit a request via SRM (Service Request Management). Management will either Approve or Reject the Request. Once the Request is approved, it will generate a Work Order. The Work Order will be the holding bin for the Request and it is prioritized and analyzed. After determining this Request is ready to be put into Production, the support group will generate a Change Request and relate the Work Order. There can be 2 paths for the Change Request - 1) Only a Change Request or 2) A Change Request with a Release. (The Release must be related to the Work Order) So essentially the Work Order becomes the Parent Record with all other Relationships tied to it. WO-- (PARENT) INC -- (RELATED TO WO. This is another optional relationship, not noted above) CRQ -- (RELATED TO WO) RLM -- (RELATED TO WO) Here is what I need for a Report out of Analytics - I need a report that has all of the Related records from the Work Order (INC, CRQ, RLM, AAS, TSK, etc). This report should show me the basic information of each Record (Record ID #, Assignment, Customer, Summary, Status, Status History, Target Dates, Scheduled Dates, etc) --- I have looked into creating a report outside of Analytics with using Joins (WOI:Associations + WOI:WorkOrder), however to get to the basic level of information for the main apps, I would need to create joins to at least 7 levels, ouch! Please, let me know if Analytics can handle this type of reporting as it is critical to our management and support staff. Thanks, Andre ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are -- Jose M. Huerta Project Manager** Movil: 661 665 088 Telf.: 971 75 03 24 Fax: 971 75 07 94 http://www.sm2baleares.es/ SM2 Baleares S.A. C/Rita Levi Edificio SM2 Parc Bit 07121 Palma de Mallorca http://es-es.facebook.com/pages/SM2-Baleares/158608627954 http://twitter.com/#!/SM2Baleares http://www.linkedin.com/company/sm2-baleares La información contenida en este mensaje de correo electrónico es confidencial. La misma, es enviada con la intención de que únicamente sea leída por la persona(s) a la(s) que va dirigida. El acceso a este mensaje por otras personas no está autorizado, por lo que en tal caso, le rogamos que nos lo comunique por la misma vía, se abstenga de realizar copias del mensaje o remitirlo o entregarlo a otra persona y proceda a borrarlo de inmediato. P Por favor, no imprima este mensaje ni sus documentos adjuntos si no es necesario. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are image002.jpgimage003.jpgimage004.jpgimage001.jpg
Re: Can remedy code push cause DB crash, etc?
The reason is in Fred's note where he talks about If you were doing anything like changing the size of a column or deleting a column on an existing form the system has to rename the table and copy the data over to a new table (with the new structure) It would depend on how much data you have in the system. Some one else on the list would need to tell how to make sure that temp space was setup to be large enough. Dave -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Raj Sent: Friday, March 30, 2012 2:52 PM To: arslist@ARSLIST.ORG Subject: Re: Can remedy code push cause DB crash, etc? Yup exactly, we noticed the same thing. DB ran out of temp space and ultimately crashed. What are your recommendations, how can we avoid this in future? On Mar 30, 11:47 am, Shellman, David dave.shell...@te.com wrote: Been there. Done that. In my case, we ran up against not enough temp space and froze the system. Dave -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Raj Sent: Friday, March 30, 2012 2:36 PM To: arsl...@arslist.org Subject: Re: Can remedy code push cause DB crash, etc? Typo ; DB Version : 10.2.0.5.0 - 64bi On Mar 30, 11:33 am, Raj ravi6...@gmail.com wrote: Sorry, missed the environment info: Server : 5.01.02 Patch 1313 Hardware : sun4u OS: SunOS 5.10 DB: SQL -- Oracle DB Version : 0.2.0.5.0 - 64bi On Mar 30, 11:30 am, Raj ravi6...@gmail.com wrote: Hi All, Very recently I performed Remedy code push on our production server. This involved importing some new forms and related workflow and also modifying existing forms like HelpDesk and Change forms.(Using ARAdmin tool) I tested this same on our Dev and QA Servers and the code push was a success without any issues. But when I performed this on our Production server, it caused DB crash and brought down Remedy. The outage was caused by the fact that the database became unresponsive. After we brought back Remedy, we noticed some of the DB view needed to be recompiled. As we are still investigating if it has to do with issues in non remedy components but we couldn't find any solid clues and ultimately brings it back to Remedy code push. Here are the logs : -- Wed Mar 28 01:09:59 2012 Distrib : AR System Distributed Server terminated when a signal was received by the server (ARDSNOTE 3000) Wed Mar 28 01:09:59 2012 15 Wed Mar 28 01:09:59 2012 Distrib : AR System Distributed Server terminated when a signal was received by the server (ARDSNOTE 3000) Wed Mar 28 01:09:59 2012 15 Wed Mar 28 01:11:23 2012 390600 : Requested database table not found. Please check the spelling (table name is case-sensitive) (ARERR 481) Wed Mar 28 01:29:29 2012 390620 : Failure while trying to connect to the SQL database. Please ensure the SQL database is running or contact the Database Administrator for help (ARERR 550) Wed Mar 28 01:29:29 2012 ORA-12535: TNS:operation timed out Wed Mar 28 01:29:29 2012 390620 : Cannot initialize contact with SQL database (ARERR 551) Wed Mar 28 01:29:29 2012 Thread 67 not handling connection --- At this point, I would like to understand from experts in here to see if anything like the above mentioned is possible? If yes, what could be the reasons and what can I look into to find the root cause. Thanks, Raj __ __ ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org attend wwrug12www.wwrug12.comARSList:Where the Answers Are __ _ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org attend wwrug12www.wwrug12.comARSList:Where the Answers Are __ _ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgattend wwrug12www.wwrug12.comARSList: Where the Answers Are __ _ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org attend wwrug12www.wwrug12.comARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Can remedy code push cause DB crash, etc?
Raj, Turn autoextend on for your temp database, and make sure the disk has sufficient free disk space to allow similar operations in the future. I'm guessing you must have been missing one or both of these? Joe -Original Message- From: Raj Sent: Friday, March 30, 2012 2:52 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Can remedy code push cause DB crash, etc? Yup exactly, we noticed the same thing. DB ran out of temp space and ultimately crashed. What are your recommendations, how can we avoid this in future? On Mar 30, 11:47 am, Shellman, David dave.shell...@te.com wrote: Been there. Done that. In my case, we ran up against not enough temp space and froze the system. Dave -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Raj Sent: Friday, March 30, 2012 2:36 PM To: arsl...@arslist.org Subject: Re: Can remedy code push cause DB crash, etc? Typo ; DB Version : 10.2.0.5.0 - 64bi On Mar 30, 11:33 am, Raj ravi6...@gmail.com wrote: Sorry, missed the environment info: Server : 5.01.02 Patch 1313 Hardware : sun4u OS: SunOS 5.10 DB: SQL -- Oracle DB Version : 0.2.0.5.0 - 64bi On Mar 30, 11:30 am, Raj ravi6...@gmail.com wrote: Hi All, Very recently I performed Remedy code push on our production server. This involved importing some new forms and related workflow and also modifying existing forms like HelpDesk and Change forms.(Using ARAdmin tool) I tested this same on our Dev and QA Servers and the code push was a success without any issues. But when I performed this on our Production server, it caused DB crash and brought down Remedy. The outage was caused by the fact that the database became unresponsive. After we brought back Remedy, we noticed some of the DB view needed to be recompiled. As we are still investigating if it has to do with issues in non remedy components but we couldn't find any solid clues and ultimately brings it back to Remedy code push. Here are the logs : -- Wed Mar 28 01:09:59 2012 Distrib : AR System Distributed Server terminated when a signal was received by the server (ARDSNOTE 3000) Wed Mar 28 01:09:59 2012 15 Wed Mar 28 01:09:59 2012 Distrib : AR System Distributed Server terminated when a signal was received by the server (ARDSNOTE 3000) Wed Mar 28 01:09:59 2012 15 Wed Mar 28 01:11:23 2012 390600 : Requested database table not found. Please check the spelling (table name is case-sensitive) (ARERR 481) Wed Mar 28 01:29:29 2012 390620 : Failure while trying to connect to the SQL database. Please ensure the SQL database is running or contact the Database Administrator for help (ARERR 550) Wed Mar 28 01:29:29 2012 ORA-12535: TNS:operation timed out Wed Mar 28 01:29:29 2012 390620 : Cannot initialize contact with SQL database (ARERR 551) Wed Mar 28 01:29:29 2012 Thread 67 not handling connection --- At this point, I would like to understand from experts in here to see if anything like the above mentioned is possible? If yes, what could be the reasons and what can I look into to find the root cause. Thanks, Raj ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Can remedy code push cause DB crash, etc?
Thanks for all your replies, I discussed this with our DBA. Here' the response when I asked to check the following(1. What is the size of the DB Temp Space? 2. Is Temp Database set to autoextend and If there is sufficient free disk space ?) Response: The problem we have was not the TEMP tablespace it was the /tmp on the unix server got 100% full. Also it was not production server that had problem it was the Datawarehouse server and in the alert log of datawarehouse server, it did point to TEMP tablespace problem but of resource unable and not enough space on the unix system Any comments? On Mar 30, 12:02 pm, Joe Martin D'Souza jdso...@shyle.net wrote: Raj, Turn autoextend on for your temp database, and make sure the disk has sufficient free disk space to allow similar operations in the future. I'm guessing you must have been missing one or both of these? Joe -Original Message- From: Raj Sent: Friday, March 30, 2012 2:52 PM Newsgroups: public.remedy.arsystem.general To: arsl...@arslist.org Subject: Re: Can remedy code push cause DB crash, etc? Yup exactly, we noticed the same thing. DB ran out of temp space and ultimately crashed. What are your recommendations, how can we avoid this in future? On Mar 30, 11:47 am, Shellman, David dave.shell...@te.com wrote: Been there. Done that. In my case, we ran up against not enough temp space and froze the system. Dave -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Raj Sent: Friday, March 30, 2012 2:36 PM To: arsl...@arslist.org Subject: Re: Can remedy code push cause DB crash, etc? Typo ; DB Version : 10.2.0.5.0 - 64bi On Mar 30, 11:33 am, Raj ravi6...@gmail.com wrote: Sorry, missed the environment info: Server : 5.01.02 Patch 1313 Hardware : sun4u OS: SunOS 5.10 DB: SQL -- Oracle DB Version : 0.2.0.5.0 - 64bi On Mar 30, 11:30 am, Raj ravi6...@gmail.com wrote: Hi All, Very recently I performed Remedy code push on our production server. This involved importing some new forms and related workflow and also modifying existing forms like HelpDesk and Change forms.(Using ARAdmin tool) I tested this same on our Dev and QA Servers and the code push was a success without any issues. But when I performed this on our Production server, it caused DB crash and brought down Remedy. The outage was caused by the fact that the database became unresponsive. After we brought back Remedy, we noticed some of the DB view needed to be recompiled. As we are still investigating if it has to do with issues in non remedy components but we couldn't find any solid clues and ultimately brings it back to Remedy code push. Here are the logs : -- Wed Mar 28 01:09:59 2012 Distrib : AR System Distributed Server terminated when a signal was received by the server (ARDSNOTE 3000) Wed Mar 28 01:09:59 2012 15 Wed Mar 28 01:09:59 2012 Distrib : AR System Distributed Server terminated when a signal was received by the server (ARDSNOTE 3000) Wed Mar 28 01:09:59 2012 15 Wed Mar 28 01:11:23 2012 390600 : Requested database table not found. Please check the spelling (table name is case-sensitive) (ARERR 481) Wed Mar 28 01:29:29 2012 390620 : Failure while trying to connect to the SQL database. Please ensure the SQL database is running or contact the Database Administrator for help (ARERR 550) Wed Mar 28 01:29:29 2012 ORA-12535: TNS:operation timed out Wed Mar 28 01:29:29 2012 390620 : Cannot initialize contact with SQL database (ARERR 551) Wed Mar 28 01:29:29 2012 Thread 67 not handling connection --- At this point, I would like to understand from experts in here to see if anything like the above mentioned is possible? If yes, what could be the reasons and what can I look into to find the root cause. Thanks, Raj ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org attend wwrug12www.wwrug12.comARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Can remedy code push cause DB crash, etc?
The /tmp directory is needed by the AR Server process to process some of its internal stuff.. running out of space here is not good too.. Every client connection that is opened up from a client, creates a unique temp file in the /tmp directory and this directory can grow pretty large as well.. The size of that file is directly directly dependent on the operation performed.. The operation you were performing is an expensive AR System operation so I can see that this file could grow pretty large. After the client connection is closed the file is typically purged.. If a file for whatever reason does not get purged after the operation, its usually an indication of some sort of an application problem.. The file is locked so cannot be deleted until you terminate the AR System server process in case that happens.. Also when that happens, you can get this directory fill up with files that are large, and not deleted. Monitoring this directory once in a while may be a good idea.. In short you can't be having a low volume dedicated to the tmp directory on your AR Server.. Joe -Original Message- From: Raj Sent: Friday, March 30, 2012 3:30 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Can remedy code push cause DB crash, etc? Thanks for all your replies, I discussed this with our DBA. Here' the response when I asked to check the following(1. What is the size of the DB Temp Space? 2. Is Temp Database set to autoextend and If there is sufficient free disk space ?) Response: The problem we have was not the TEMP tablespace it was the /tmp on the unix server got 100% full. Also it was not production server that had problem it was the Datawarehouse server and in the alert log of datawarehouse server, it did point to TEMP tablespace problem but of resource unable and not enough space on the unix system Any comments? On Mar 30, 12:02 pm, Joe Martin D'Souza jdso...@shyle.net wrote: Raj, Turn autoextend on for your temp database, and make sure the disk has sufficient free disk space to allow similar operations in the future. I'm guessing you must have been missing one or both of these? Joe -Original Message- From: Raj Sent: Friday, March 30, 2012 2:52 PM Newsgroups: public.remedy.arsystem.general To: arsl...@arslist.org Subject: Re: Can remedy code push cause DB crash, etc? Yup exactly, we noticed the same thing. DB ran out of temp space and ultimately crashed. What are your recommendations, how can we avoid this in future? On Mar 30, 11:47 am, Shellman, David dave.shell...@te.com wrote: Been there. Done that. In my case, we ran up against not enough temp space and froze the system. Dave -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Raj Sent: Friday, March 30, 2012 2:36 PM To: arsl...@arslist.org Subject: Re: Can remedy code push cause DB crash, etc? Typo ; DB Version : 10.2.0.5.0 - 64bi On Mar 30, 11:33 am, Raj ravi6...@gmail.com wrote: Sorry, missed the environment info: Server : 5.01.02 Patch 1313 Hardware : sun4u OS: SunOS 5.10 DB: SQL -- Oracle DB Version : 0.2.0.5.0 - 64bi On Mar 30, 11:30 am, Raj ravi6...@gmail.com wrote: Hi All, Very recently I performed Remedy code push on our production server. This involved importing some new forms and related workflow and also modifying existing forms like HelpDesk and Change forms.(Using ARAdmin tool) I tested this same on our Dev and QA Servers and the code push was a success without any issues. But when I performed this on our Production server, it caused DB crash and brought down Remedy. The outage was caused by the fact that the database became unresponsive. After we brought back Remedy, we noticed some of the DB view needed to be recompiled. As we are still investigating if it has to do with issues in non remedy components but we couldn't find any solid clues and ultimately brings it back to Remedy code push. Here are the logs : -- Wed Mar 28 01:09:59 2012 Distrib : AR System Distributed Server terminated when a signal was received by the server (ARDSNOTE 3000) Wed Mar 28 01:09:59 2012 15 Wed Mar 28 01:09:59 2012 Distrib : AR System Distributed Server terminated when a signal was received by the server (ARDSNOTE 3000) Wed Mar 28 01:09:59 2012 15 Wed Mar 28 01:11:23 2012 390600 : Requested database table not found. Please check the spelling (table name is case-sensitive) (ARERR 481) Wed Mar 28 01:29:29 2012 390620 : Failure while trying to connect to the SQL database. Please ensure the SQL database is running or contact the Database Administrator for help (ARERR 550) Wed Mar 28 01:29:29 2012 ORA-12535: TNS:operation timed out Wed Mar 28 01:29:29 2012 390620 : Cannot initialize contact with SQL database (ARERR 551) Wed Mar 28
Re: ADDM
wrong forum, this one is about Remedy, I suggest to go bmc communities. Peter On 3/30/12, SUBSCRIBE arslist Judy C. Dowell jdow...@wakehealth.edu wrote: Hi, I'm totally new to ADDM and have been requested to run a report to find instances of a product called pointsec. I've been asked to provide: Computer Name/Make/Model/OS/IP Address/Path and the path the software instance is found. I was given the following information about the product location for a file called *.rec: Windows XP: Documents and Settings\All Users\Application Data\Pointsec Documents and Settings\All Users\Application Data\Pointsec\Pointsec for PC Windows Vista/7: C:\Users\All Users\Pointsec for PC I am not a programmer and have no idea how to get this information into a report. I can see the instances of pointsec under discovered service, but don't know how to get the needed information and columns. Can anyone help? Thanks. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Can remedy code push cause DB crash, etc?
Thanks Joe: Here some additional details I gathered from our DBA: It was DataWarehouse that had issues and it was not complaining about TEMP tablespace but the errors in the alert log were pertaining the OS resource problem Wed Mar 28 08:22:30 UTC 2012 Process startup failed, error stack: Wed Mar 28 08:22:31 UTC 2012 ORA-27300: OS system dependent operation:fork failed with status: 11 ORA-27301: OS failure message: Resource temporarily unavailable ORA-27302: failure occurred at: skgpspawn3 Wed Mar 28 08:22:32 UTC 2012 Process q000 died, see its trace file Wed Mar 28 08:22:32 UTC 2012 .. Wed Mar 28 08:49:31 UTC 2012 Process startup failed, error stack: Wed Mar 28 08:49:31 UTC 2012 ORA-27300: OS system dependent operation:fork failed with status: 12 ORA-27301: OS failure message: Not enough space ORA-27302: failure occurred at: .. Wed Mar 28 08:49:31 UTC 2012 Process J001 died, see its trace file So, what are the recommended size, settings? whom should I approach at my end to get these settings in place? On Mar 30, 12:50 pm, Joe Martin D'Souza jdso...@shyle.net wrote: The /tmp directory is needed by the AR Server process to process some of its internal stuff.. running out of space here is not good too.. Every client connection that is opened up from a client, creates a unique temp file in the /tmp directory and this directory can grow pretty large as well.. The size of that file is directly directly dependent on the operation performed.. The operation you were performing is an expensive AR System operation so I can see that this file could grow pretty large. After the client connection is closed the file is typically purged.. If a file for whatever reason does not get purged after the operation, its usually an indication of some sort of an application problem.. The file is locked so cannot be deleted until you terminate the AR System server process in case that happens.. Also when that happens, you can get this directory fill up with files that are large, and not deleted. Monitoring this directory once in a while may be a good idea.. In short you can't be having a low volume dedicated to the tmp directory on your AR Server.. Joe -Original Message- From: Raj Sent: Friday, March 30, 2012 3:30 PM Newsgroups: public.remedy.arsystem.general To: arsl...@arslist.org Subject: Re: Can remedy code push cause DB crash, etc? Thanks for all your replies, I discussed this with our DBA. Here' the response when I asked to check the following(1. What is the size of the DB Temp Space? 2. Is Temp Database set to autoextend and If there is sufficient free disk space ?) Response: The problem we have was not the TEMP tablespace it was the /tmp on the unix server got 100% full. Also it was not production server that had problem it was the Datawarehouse server and in the alert log of datawarehouse server, it did point to TEMP tablespace problem but of resource unable and not enough space on the unix system Any comments? On Mar 30, 12:02 pm, Joe Martin D'Souza jdso...@shyle.net wrote: Raj, Turn autoextend on for your temp database, and make sure the disk has sufficient free disk space to allow similar operations in the future. I'm guessing you must have been missing one or both of these? Joe -Original Message- From: Raj Sent: Friday, March 30, 2012 2:52 PM Newsgroups: public.remedy.arsystem.general To: arsl...@arslist.org Subject: Re: Can remedy code push cause DB crash, etc? Yup exactly, we noticed the same thing. DB ran out of temp space and ultimately crashed. What are your recommendations, how can we avoid this in future? On Mar 30, 11:47 am, Shellman, David dave.shell...@te.com wrote: Been there. Done that. In my case, we ran up against not enough temp space and froze the system. Dave -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Raj Sent: Friday, March 30, 2012 2:36 PM To: arsl...@arslist.org Subject: Re: Can remedy code push cause DB crash, etc? Typo ; DB Version : 10.2.0.5.0 - 64bi On Mar 30, 11:33 am, Raj ravi6...@gmail.com wrote: Sorry, missed the environment info: Server : 5.01.02 Patch 1313 Hardware : sun4u OS: SunOS 5.10 DB: SQL -- Oracle DB Version : 0.2.0.5.0 - 64bi On Mar 30, 11:30 am, Raj ravi6...@gmail.com wrote: Hi All, Very recently I performed Remedy code push on our production server. This involved importing some new forms and related workflow and also modifying existing forms like HelpDesk and Change forms.(Using ARAdmin tool) I tested this same on our Dev and QA Servers and the code push was a success without any issues. But when I performed this on our Production server, it caused DB crash and brought down Remedy. The outage was caused by the fact that the database became
Re: ADDM
Peter, ADDM updates CMDB which is part of ITSM. So one could argue that it would be included in this forum. I'm sure that there a few individuals that could answer the question. Dave On Mar 30, 2012, at 4:03 PM, PCR Remedy pcr...@gmail.com wrote: wrong forum, this one is about Remedy, I suggest to go bmc communities. Peter On 3/30/12, SUBSCRIBE arslist Judy C. Dowell jdow...@wakehealth.edu wrote: Hi, I'm totally new to ADDM and have been requested to run a report to find instances of a product called pointsec. I've been asked to provide: Computer Name/Make/Model/OS/IP Address/Path and the path the software instance is found. I was given the following information about the product location for a file called *.rec: Windows XP: Documents and Settings\All Users\Application Data\Pointsec Documents and Settings\All Users\Application Data\Pointsec\Pointsec for PC Windows Vista/7: C:\Users\All Users\Pointsec for PC I am not a programmer and have no idea how to get this information into a report. I can see the instances of pointsec under discovered service, but don't know how to get the needed information and columns. Can anyone help? Thanks. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Can remedy code push cause DB crash, etc?
Yes in my previous email I was talking about the /tmp directory on the OS and files created there too.. The files created there are done by AR process that are a result of an operation from a client.. in your case the client was a import operation from the DS (the new toy for us adults from Remedyville). I do no think in this case its your TEMP database which we thought it may be earlier. Your DBA's information directs us to the OS. Running out of volume space on the where the /tmp is equally critical. Check this directory to see if there are a lot of files owned by the AR System OS user after you shut down the AR System process.. It might be an indication of an application level problem.. Without shutting down the processes, you will be unable to delete the files that are owned by the AR System OS user.. These files will be locked if created after the process was last started.. Joe -Original Message- From: Raj Sent: Friday, March 30, 2012 4:04 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Can remedy code push cause DB crash, etc? Thanks Joe: Here some additional details I gathered from our DBA: It was DataWarehouse that had issues and it was not complaining about TEMP tablespace but the errors in the alert log were pertaining the OS resource problem Wed Mar 28 08:22:30 UTC 2012 Process startup failed, error stack: Wed Mar 28 08:22:31 UTC 2012 ORA-27300: OS system dependent operation:fork failed with status: 11 ORA-27301: OS failure message: Resource temporarily unavailable ORA-27302: failure occurred at: skgpspawn3 Wed Mar 28 08:22:32 UTC 2012 Process q000 died, see its trace file Wed Mar 28 08:22:32 UTC 2012 .. Wed Mar 28 08:49:31 UTC 2012 Process startup failed, error stack: Wed Mar 28 08:49:31 UTC 2012 ORA-27300: OS system dependent operation:fork failed with status: 12 ORA-27301: OS failure message: Not enough space ORA-27302: failure occurred at: .. Wed Mar 28 08:49:31 UTC 2012 Process J001 died, see its trace file So, what are the recommended size, settings? whom should I approach at my end to get these settings in place? On Mar 30, 12:50 pm, Joe Martin D'Souza jdso...@shyle.net wrote: The /tmp directory is needed by the AR Server process to process some of its internal stuff.. running out of space here is not good too.. Every client connection that is opened up from a client, creates a unique temp file in the /tmp directory and this directory can grow pretty large as well.. The size of that file is directly directly dependent on the operation performed.. The operation you were performing is an expensive AR System operation so I can see that this file could grow pretty large. After the client connection is closed the file is typically purged.. If a file for whatever reason does not get purged after the operation, its usually an indication of some sort of an application problem.. The file is locked so cannot be deleted until you terminate the AR System server process in case that happens.. Also when that happens, you can get this directory fill up with files that are large, and not deleted. Monitoring this directory once in a while may be a good idea.. In short you can't be having a low volume dedicated to the tmp directory on your AR Server.. Joe -Original Message- From: Raj Sent: Friday, March 30, 2012 3:30 PM Newsgroups: public.remedy.arsystem.general To: arsl...@arslist.org Subject: Re: Can remedy code push cause DB crash, etc? Thanks for all your replies, I discussed this with our DBA. Here' the response when I asked to check the following(1. What is the size of the DB Temp Space? 2. Is Temp Database set to autoextend and If there is sufficient free disk space ?) Response: The problem we have was not the TEMP tablespace it was the /tmp on the unix server got 100% full. Also it was not production server that had problem it was the Datawarehouse server and in the alert log of datawarehouse server, it did point to TEMP tablespace problem but of resource unable and not enough space on the unix system Any comments? On Mar 30, 12:02 pm, Joe Martin D'Souza jdso...@shyle.net wrote: Raj, Turn autoextend on for your temp database, and make sure the disk has sufficient free disk space to allow similar operations in the future. I'm guessing you must have been missing one or both of these? Joe -Original Message- From: Raj Sent: Friday, March 30, 2012 2:52 PM Newsgroups: public.remedy.arsystem.general To: arsl...@arslist.org Subject: Re: Can remedy code push cause DB crash, etc? Yup exactly, we noticed the same thing. DB ran out of temp space and ultimately crashed. What are your recommendations, how can we avoid this in future? On Mar 30, 11:47 am, Shellman, David dave.shell...@te.com wrote: Been there. Done that. In my case, we ran up against not enough temp space and froze the system. Dave -Original Message- From: Action Request System
Re: ADDM
When you run a query in ADDM, you should have an icon under the title but above the table displaying the results that says, (+) Customize. You can use that to add or remove columns in the list, including columns based on the relationships. I haven't looked into the specifics that you are talking about but I know by default on the software instances you get the hostname, so it should be fairly simple to pull in the rest of the data. Once you have your query displaying the way you want, you can click Actions and then Export as CSV and manipulate the data to show up however you want. BMC does cover this and reporting extensively in their class, so if you are responsible for ADDM definitely get at least the first two ADDM classes to be able to maneuver around in the application. Thanks, Shawn Pierson Remedy Developer | Southern Union -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of SUBSCRIBE arslist Judy C. Dowell Sent: Friday, March 30, 2012 12:04 PM To: arslist@ARSLIST.ORG Subject: ADDM Hi, I'm totally new to ADDM and have been requested to run a report to find instances of a product called pointsec. I've been asked to provide: Computer Name/Make/Model/OS/IP Address/Path and the path the software instance is found. I was given the following information about the product location for a file called *.rec: Windows XP: Documents and Settings\All Users\Application Data\Pointsec Documents and Settings\All Users\Application Data\Pointsec\Pointsec for PC Windows Vista/7: C:\Users\All Users\Pointsec for PC I am not a programmer and have no idea how to get this information into a report. I can see the instances of pointsec under discovered service, but don't know how to get the needed information and columns. Can anyone help? Thanks. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are Private and confidential as detailed here: http://www.sug.com/disclaimers/default.htm#Mail . If you cannot access the link, please e-mail sender. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: ADDM
Indeed, ADDM is quite often used with the BMC Atrium, although there are instances as Tideway that were Not part of the BMC world at all, and therefore if it is part of the BMC/Remedy world the questions are fine here. Although I have done two ADDM installations I don't know the answer because all reporting was from the Remedy side. I am hoping that we will get some ADDM papers and participation at WWRUG12. Daniel -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Shellman, David Sent: March 30, 2012 4:08 PM To: arslist@ARSLIST.ORG Subject: Re: ADDM Peter, ADDM updates CMDB which is part of ITSM. So one could argue that it would be included in this forum. I'm sure that there a few individuals that could answer the question. Dave On Mar 30, 2012, at 4:03 PM, PCR Remedy pcr...@gmail.com wrote: wrong forum, this one is about Remedy, I suggest to go bmc communities. Peter On 3/30/12, SUBSCRIBE arslist Judy C. Dowell jdow...@wakehealth.edu wrote: Hi, I'm totally new to ADDM and have been requested to run a report to find instances of a product called pointsec. I've been asked to provide: Computer Name/Make/Model/OS/IP Address/Path and the path the software instance is found. I was given the following information about the product location for a file called *.rec: Windows XP: Documents and Settings\All Users\Application Data\Pointsec Documents and Settings\All Users\Application Data\Pointsec\Pointsec for PC Windows Vista/7: C:\Users\All Users\Pointsec for PC I am not a programmer and have no idea how to get this information into a report. I can see the instances of pointsec under discovered service, but don't know how to get the needed information and columns. Can anyone help? Thanks. _ __ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are __ _ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: ADDM
I agree with David.. there are an increasing number of sites that now use ADDM with CMDB and with both being owned by BMC after ADDM was bought over from Tideway (just like RKM now which arguably a few years ago wasn’t a part of BMC Remedy suite..).. I am only partially exposed to ADDM so can't quite answer this question but was watching this thread to absorb info coming out of it.. Joe -Original Message- From: Shellman, David Sent: Friday, March 30, 2012 4:08 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: ADDM Peter, ADDM updates CMDB which is part of ITSM. So one could argue that it would be included in this forum. I'm sure that there a few individuals that could answer the question. Dave On Mar 30, 2012, at 4:03 PM, PCR Remedy pcr...@gmail.com wrote: wrong forum, this one is about Remedy, I suggest to go bmc communities. Peter On 3/30/12, SUBSCRIBE arslist Judy C. Dowell jdow...@wakehealth.edu wrote: Hi, I'm totally new to ADDM and have been requested to run a report to find instances of a product called pointsec. I've been asked to provide: Computer Name/Make/Model/OS/IP Address/Path and the path the software instance is found. I was given the following information about the product location for a file called *.rec: Windows XP: Documents and Settings\All Users\Application Data\Pointsec Documents and Settings\All Users\Application Data\Pointsec\Pointsec for PC Windows Vista/7: C:\Users\All Users\Pointsec for PC I am not a programmer and have no idea how to get this information into a report. I can see the instances of pointsec under discovered service, but don't know how to get the needed information and columns. Can anyone help? Thanks. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: DevStudio Tool
I’ll agree to be a very co-operating victim of kidnap with all that free beer and all going on in the evenings where I’d be held :-) Joe From: Jason Miller Sent: Friday, March 30, 2012 4:17 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: DevStudio Tool ** Uh Joe, if you say you're not making it we are going kidnap you and bring you there against your will. You might as well plan on being there :) Jason On Fri, Mar 30, 2012 at 9:42 AM, Joe Martin D'Souza jdso...@shyle.net wrote: ** Yup Dan wrote me that on an offline and its something I’m considering.. Travel may not cost me much as I can leverage my frequent flyer benefits to get ‘free’ stuff... I’ll need to check what is scheduled during that period at the customer site I am at right now.. Joe From: Kemes, Lisa Sent: Friday, March 30, 2012 11:44 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: DevStudio Tool ** You know you get your registration fee taken care of if you present!! :) Something to think about! Thanks! Lisa -- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Wednesday, March 28, 2012 10:49 PM To: arslist@ARSLIST.ORG Subject: Re: DevStudio Tool ** Yes a Panel is a great idea.. Where you as an audience can ask the how to type questions and we as a panel of users who are more friendlier with the Studio can answer if there is an answer to it and share our views.. Maybe we could as a panel share our experiences first, which may answer majority of the how to questions, and then have a open question answer session in the end.. Joe From: Susan Palmer Sent: Wednesday, March 28, 2012 10:39 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: DevStudio Tool ** Joe ... maybe a panel situation would be more comfortable for you. I think having a projection of the tool and then showing what you're talking about would be great. Especially when answering questions. Skip the slides, we want the real tool in action. I know the wwrug team likes 'presentations' but maybe this would be an option for this type of group. I don't think you'd even have to prepare more than a couple points already mentioned here (choose mine please) and the rest will generate from the crowd. On Wed, Mar 28, 2012 at 9:34 PM, Joe Martin D'Souza jdso...@shyle.net wrote: ** “Importing and exporting workflow can chew up memory fast. The default heap settings are next to nothing and you need a minimum of 2Gig to run Devstudio. Admin tool could get by with 1Gig or less. “ Have you increased the heap on the import ini configuration file? There are more files than just the development studio’s ini file where you can adjust your heap size. I hate 2 and 3 too.. experienced those things myself as well where after what seems like you selected the field it just disappears and the 2nd time you select it, it sticks... So yea Rod actually managed to point 2 things that I find to be clumsy too.. But the advantages outweigh these so these few quirks just seem to be overshadowed.. Thank you for pointing these up and I think if BMC is watching, they ought to do something about these things.. Joe From: Rod Harris Sent: Wednesday, March 28, 2012 10:22 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: DevStudio Tool ** Hi Dan, Joe and everyone, I've been using Dev Studio since 7.5 first came out and I would never consider going back to the old admin tool. Whilst you certainly need a high resolution screen and you should go 64bit and up your heap from the default there are plenty of huge upsides in dev studio. My favourites are: 1.. The Outline View and the ability to sort fields by ID or by label or by name to find the field you need quickly. 2.. Once you find the field the show relationships feature will enable you to drill in to the right workflow quickly and to be confident that you have captured all of the impacts. 3.. If you need to bulk change a whole bunch of fields, active links or anything else you can usually select the objects and use the properties page to do a bulk update. 4.. Autocomplete, built in help and syntax checking are nice especially now that the bugs seem to have been removed. There were some nasty ones in the early 7.5 releases The bad things 1.. Importing and exporting workflow can chew up memory fast. The default heap settings are next to nothing and you need a minimum of 2Gig to run Devstudio. Admin tool could get by with 1Gig or less. 2.. I miss the ease of moving around a bunch of fields using the arrow keys. This feature is there but it
Re: DevStudio Tool
I'll be part of the kidnapping ring.. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: ADDM
+1 for Dan, Joe and David: ADDM and CMDB are part of the BMC Atrium Platform, platform is fully leveraged by BMC Remedy (and many other BMC brands). I don't have the answer to your specific question, but can point you to good ADDM resources posted by Zoe and other ex-Tideway friends (and that may address this topic): on https://communities.bmc.com/communities/community/bmcdn/bmc_atrium_and_foundation_technologies, check the blog posts (several informative videos), and of course the Discovery (ADDM) sub-community. As you might have seen in the past weeksmonths, RD is engaging more and more, posting public resources. What main area would you like them to focus on? - a specific product/capability: Dev Studio plugins, mid-tier, user directory sync, CMDB datamodeling, SLM, SRM, other? - a specific tech topic: HA, DRP, upgrade, perf, troubleshooting, other? Have a great week-end, ~ Matt Laurenceau Senior Community Ambassador, BMC Communities matthieu_laurenc...@bmc.com Follow me @Matt_L Skype: matt.laurenceau On 30 mars 2012, at 22:19, Joe Martin D'Souza jdso...@shyle.net wrote: I agree with David.. there are an increasing number of sites that now use ADDM with CMDB and with both being owned by BMC after ADDM was bought over from Tideway (just like RKM now which arguably a few years ago wasn’t a part of BMC Remedy suite..).. I am only partially exposed to ADDM so can't quite answer this question but was watching this thread to absorb info coming out of it.. Joe -Original Message- From: Shellman, David Sent: Friday, March 30, 2012 4:08 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: ADDM Peter, ADDM updates CMDB which is part of ITSM. So one could argue that it would be included in this forum. I'm sure that there a few individuals that could answer the question. Dave On Mar 30, 2012, at 4:03 PM, PCR Remedy pcr...@gmail.com wrote: wrong forum, this one is about Remedy, I suggest to go bmc communities. Peter On 3/30/12, SUBSCRIBE arslist Judy C. Dowell jdow...@wakehealth.edu wrote: Hi, I'm totally new to ADDM and have been requested to run a report to find instances of a product called pointsec. I've been asked to provide: Computer Name/Make/Model/OS/IP Address/Path and the path the software instance is found. I was given the following information about the product location for a file called *.rec: Windows XP: Documents and Settings\All Users\Application Data\Pointsec Documents and Settings\All Users\Application Data\Pointsec\Pointsec for PC Windows Vista/7: C:\Users\All Users\Pointsec for PC I am not a programmer and have no idea how to get this information into a report. I can see the instances of pointsec under discovered service, but don't know how to get the needed information and columns. Can anyone help? Thanks. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: DevStudio Tool
This is fun! Would be more fun if there was beer and/or warm saki and sushi at the kidnapping party! -Original Message- From: Carin Grobler Sent: Friday, March 30, 2012 4:29 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: DevStudio Tool I'll be part of the kidnapping ring.. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: ADDM
+5 for Matt :-) Sorry, I should have mentioned communities, It is where I went/go to post purely ADDM side questions or comments. (had some lively discussions too, it was great). Daniel -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Matt Laurenceau Sent: March 30, 2012 5:01 PM To: arslist@ARSLIST.ORG Subject: Re: ADDM +1 for Dan, Joe and David: ADDM and CMDB are part of the BMC Atrium Platform, platform is fully leveraged by BMC Remedy (and many other BMC brands). I don't have the answer to your specific question, but can point you to good ADDM resources posted by Zoe and other ex-Tideway friends (and that may address this topic): on https://communities.bmc.com/communities/community/bmcdn/bmc_atrium_and_foundation_technologies, check the blog posts (several informative videos), and of course the Discovery (ADDM) sub-community. As you might have seen in the past weeksmonths, RD is engaging more and more, posting public resources. What main area would you like them to focus on? - a specific product/capability: Dev Studio plugins, mid-tier, user directory sync, CMDB datamodeling, SLM, SRM, other? - a specific tech topic: HA, DRP, upgrade, perf, troubleshooting, other? Have a great week-end, ~ Matt Laurenceau Senior Community Ambassador, BMC Communities matthieu_laurenc...@bmc.com Follow me @Matt_L Skype: matt.laurenceau On 30 mars 2012, at 22:19, Joe Martin D'Souza jdso...@shyle.net wrote: I agree with David.. there are an increasing number of sites that now use ADDM with CMDB and with both being owned by BMC after ADDM was bought over from Tideway (just like RKM now which arguably a few years ago wasn t a part of BMC Remedy suite..).. I am only partially exposed to ADDM so can't quite answer this question but was watching this thread to absorb info coming out of it.. Joe -Original Message- From: Shellman, David Sent: Friday, March 30, 2012 4:08 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: ADDM Peter, ADDM updates CMDB which is part of ITSM. So one could argue that it would be included in this forum. I'm sure that there a few individuals that could answer the question. Dave On Mar 30, 2012, at 4:03 PM, PCR Remedy pcr...@gmail.com wrote: wrong forum, this one is about Remedy, I suggest to go bmc communities. Peter On 3/30/12, SUBSCRIBE arslist Judy C. Dowell jdow...@wakehealth.edu wrote: Hi, I'm totally new to ADDM and have been requested to run a report to find instances of a product called pointsec. I've been asked to provide: Computer Name/Make/Model/OS/IP Address/Path and the path the software instance is found. I was given the following information about the product location for a file called *.rec: Windows XP: Documents and Settings\All Users\Application Data\Pointsec Documents and Settings\All Users\Application Data\Pointsec\Pointsec for PC Windows Vista/7: C:\Users\All Users\Pointsec for PC I am not a programmer and have no idea how to get this information into a report. I can see the instances of pointsec under discovered service, but don't know how to get the needed information and columns. Can anyone help? Thanks. __ _ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: DevStudio Tool
Did anybody say there wouldn't be? Although now we are encouraging you to be difficult and make us come after you. On Fri, Mar 30, 2012 at 2:01 PM, Joe Martin D'Souza jdso...@shyle.netwrote: This is fun! Would be more fun if there was beer and/or warm saki and sushi at the kidnapping party! -Original Message- From: Carin Grobler Sent: Friday, March 30, 2012 4:29 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: DevStudio Tool I'll be part of the kidnapping ring.. __**__** ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: DevStudio Tool
I think the panel was my idea to begin with, so front row people should also get treats! On Fri, Mar 30, 2012 at 3:21 PM, Joe Martin D'Souza jdso...@shyle.netwrote: ** I’ll agree to be a very co-operating victim of kidnap with all that free beer and all going on in the evenings where I’d be held :-) Joe *From:* Jason Miller jason.mil...@gmail.com *Sent:* Friday, March 30, 2012 4:17 PM *Newsgroups:* public.remedy.arsystem.general *To:* arslist@ARSLIST.ORG *Subject:* Re: DevStudio Tool ** Uh Joe, if you say you're not making it we are going kidnap you and bring you there against your will. You might as well plan on being there :) Jason On Fri, Mar 30, 2012 at 9:42 AM, Joe Martin D'Souza jdso...@shyle.netwrote: ** Yup Dan wrote me that on an offline and its something I’m considering.. Travel may not cost me much as I can leverage my frequent flyer benefits to get ‘free’ stuff... I’ll need to check what is scheduled during that period at the customer site I am at right now.. Joe *From:* Kemes, Lisa lisa.ke...@te.com *Sent:* Friday, March 30, 2012 11:44 AM *Newsgroups:* public.remedy.arsystem.general *To:* arslist@ARSLIST.ORG *Subject:* Re: DevStudio Tool ** You know you get your registration fee taken care of if you present!! :) Something to think about! Thanks! Lisa -- *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Joe Martin D'Souza *Sent:* Wednesday, March 28, 2012 10:49 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: DevStudio Tool ** Yes a Panel is a great idea.. Where you as an audience can ask the how to type questions and we as a panel of users who are more friendlier with the Studio can answer if there is an answer to it and share our views.. Maybe we could as a panel share our experiences first, which may answer majority of the how to questions, and then have a open question answer session in the end.. Joe *From:* Susan Palmer suzanpal...@gmail.com *Sent:* Wednesday, March 28, 2012 10:39 PM *Newsgroups:* public.remedy.arsystem.general *To:* arslist@ARSLIST.ORG *Subject:* Re: DevStudio Tool ** Joe ... maybe a panel situation would be more comfortable for you. I think having a projection of the tool and then showing what you're talking about would be great. Especially when answering questions. Skip the slides, we want the real tool in action. I know the wwrug team likes 'presentations' but maybe this would be an option for this type of group. I don't think you'd even have to prepare more than a couple points already mentioned here (choose mine please) and the rest will generate from the crowd. On Wed, Mar 28, 2012 at 9:34 PM, Joe Martin D'Souza jdso...@shyle.netwrote: ** “Importing and exporting workflow can chew up memory fast. The default heap settings are next to nothing and you need a minimum of 2Gig to run Devstudio. Admin tool could get by with 1Gig or less. “ Have you increased the heap on the import ini configuration file? There are more files than just the development studio’s ini file where you can adjust your heap size. I hate 2 and 3 too.. experienced those things myself as well where after what seems like you selected the field it just disappears and the 2nd time you select it, it sticks... So yea Rod actually managed to point 2 things that I find to be clumsy too.. But the advantages outweigh these so these few quirks just seem to be overshadowed.. Thank you for pointing these up and I think if BMC is watching, they ought to do something about these things.. Joe *From:* Rod Harris r...@smapps.com.au *Sent:* Wednesday, March 28, 2012 10:22 PM *Newsgroups:* public.remedy.arsystem.general *To:* arslist@ARSLIST.ORG *Subject:* Re: DevStudio Tool ** Hi Dan, Joe and everyone, I've been using Dev Studio since 7.5 first came out and I would never consider going back to the old admin tool. Whilst you certainly need a high resolution screen and you should go 64bit and up your heap from the default there are plenty of huge upsides in dev studio. My favourites are: 1. The *Outline View *and the ability to sort fields by ID or by label or by name to find the field you need quickly. 2. Once you find the field the *show relationships* feature will enable you to drill in to the right workflow quickly and to be confident that you have captured all of the impacts. 3. If you need to *bulk change* a whole bunch of fields, active links or anything else you can usually select the objects and use the properties page to do a bulk update. 4. *Autocomplete*, built in help and syntax checking are nice especially now that the bugs seem to have been removed. There were some nasty ones in the early 7.5 releases The bad things 1. Importing and exporting workflow can chew up memory fast. The default heap settings are next to nothing and you need a
Re: ADDM
Thanks to all of you for responding. We do have the entire suite of products; however, I am running ADDM alone at this time and will connect it soon to CMDB. I will post in communities as suggested. Have a great weekend! Judy From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] on behalf of arslist [arsl...@danielbloom.ca] Sent: Friday, March 30, 2012 5:16 PM To: arslist@ARSLIST.ORG Subject: Re: ADDM +5 for Matt :-) Sorry, I should have mentioned communities, It is where I went/go to post purely ADDM side questions or comments. (had some lively discussions too, it was great). Daniel -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Matt Laurenceau Sent: March 30, 2012 5:01 PM To: arslist@ARSLIST.ORG Subject: Re: ADDM +1 for Dan, Joe and David: ADDM and CMDB are part of the BMC Atrium Platform, platform is fully leveraged by BMC Remedy (and many other BMC brands). I don't have the answer to your specific question, but can point you to good ADDM resources posted by Zoe and other ex-Tideway friends (and that may address this topic): on https://communities.bmc.com/communities/community/bmcdn/bmc_atrium_and_foundation_technologies, check the blog posts (several informative videos), and of course the Discovery (ADDM) sub-community. As you might have seen in the past weeksmonths, RD is engaging more and more, posting public resources. What main area would you like them to focus on? - a specific product/capability: Dev Studio plugins, mid-tier, user directory sync, CMDB datamodeling, SLM, SRM, other? - a specific tech topic: HA, DRP, upgrade, perf, troubleshooting, other? Have a great week-end, ~ Matt Laurenceau Senior Community Ambassador, BMC Communities matthieu_laurenc...@bmc.com Follow me @Matt_L Skype: matt.laurenceau On 30 mars 2012, at 22:19, Joe Martin D'Souza jdso...@shyle.net wrote: I agree with David.. there are an increasing number of sites that now use ADDM with CMDB and with both being owned by BMC after ADDM was bought over from Tideway (just like RKM now which arguably a few years ago wasn t a part of BMC Remedy suite..).. I am only partially exposed to ADDM so can't quite answer this question but was watching this thread to absorb info coming out of it.. Joe -Original Message- From: Shellman, David Sent: Friday, March 30, 2012 4:08 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: ADDM Peter, ADDM updates CMDB which is part of ITSM. So one could argue that it would be included in this forum. I'm sure that there a few individuals that could answer the question. Dave On Mar 30, 2012, at 4:03 PM, PCR Remedy pcr...@gmail.com wrote: wrong forum, this one is about Remedy, I suggest to go bmc communities. Peter On 3/30/12, SUBSCRIBE arslist Judy C. Dowell jdow...@wakehealth.edu wrote: Hi, I'm totally new to ADDM and have been requested to run a report to find instances of a product called pointsec. I've been asked to provide: Computer Name/Make/Model/OS/IP Address/Path and the path the software instance is found. I was given the following information about the product location for a file called *.rec: Windows XP: Documents and Settings\All Users\Application Data\Pointsec Documents and Settings\All Users\Application Data\Pointsec\Pointsec for PC Windows Vista/7: C:\Users\All Users\Pointsec for PC I am not a programmer and have no idea how to get this information into a report. I can see the instances of pointsec under discovered service, but don't know how to get the needed information and columns. Can anyone help? Thanks. __ _ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: DevStudio Tool
There's always Twinkies. On Mar 30, 2012, at 5:26 PM, Susan Palmer suzanpal...@gmail.commailto:suzanpal...@gmail.com wrote: ** I think the panel was my idea to begin with, so front row people should also get treats! On Fri, Mar 30, 2012 at 3:21 PM, Joe Martin D'Souza jdso...@shyle.netmailto:jdso...@shyle.net wrote: ** I’ll agree to be a very co-operating victim of kidnap with all that free beer and all going on in the evenings where I’d be held :-) Joe From: Jason Millermailto:jason.mil...@gmail.com Sent: Friday, March 30, 2012 4:17 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: DevStudio Tool ** Uh Joe, if you say you're not making it we are going kidnap you and bring you there against your will. You might as well plan on being there :) Jason On Fri, Mar 30, 2012 at 9:42 AM, Joe Martin D'Souza jdso...@shyle.netmailto:jdso...@shyle.net wrote: ** Yup Dan wrote me that on an offline and its something I’m considering.. Travel may not cost me much as I can leverage my frequent flyer benefits to get ‘free’ stuff... I’ll need to check what is scheduled during that period at the customer site I am at right now.. Joe From: Kemes, Lisamailto:lisa.ke...@te.com Sent: Friday, March 30, 2012 11:44 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: DevStudio Tool ** You know you get your registration fee taken care of if you present!! :) Something to think about! Thanks! Lisa From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Wednesday, March 28, 2012 10:49 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: DevStudio Tool ** Yes a Panel is a great idea.. Where you as an audience can ask the how to type questions and we as a panel of users who are more friendlier with the Studio can answer if there is an answer to it and share our views.. Maybe we could as a panel share our experiences first, which may answer majority of the how to questions, and then have a open question answer session in the end.. Joe From: Susan Palmermailto:suzanpal...@gmail.com Sent: Wednesday, March 28, 2012 10:39 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: DevStudio Tool ** Joe ... maybe a panel situation would be more comfortable for you. I think having a projection of the tool and then showing what you're talking about would be great. Especially when answering questions. Skip the slides, we want the real tool in action. I know the wwrug team likes 'presentations' but maybe this would be an option for this type of group. I don't think you'd even have to prepare more than a couple points already mentioned here (choose mine please) and the rest will generate from the crowd. On Wed, Mar 28, 2012 at 9:34 PM, Joe Martin D'Souza jdso...@shyle.netmailto:jdso...@shyle.net wrote: ** “Importing and exporting workflow can chew up memory fast. The default heap settings are next to nothing and you need a minimum of 2Gig to run Devstudio. Admin tool could get by with 1Gig or less. “ Have you increased the heap on the import ini configuration file? There are more files than just the development studio’s ini file where you can adjust your heap size. I hate 2 and 3 too.. experienced those things myself as well where after what seems like you selected the field it just disappears and the 2nd time you select it, it sticks... So yea Rod actually managed to point 2 things that I find to be clumsy too.. But the advantages outweigh these so these few quirks just seem to be overshadowed.. Thank you for pointing these up and I think if BMC is watching, they ought to do something about these things.. Joe From: Rod Harrismailto:r...@smapps.com.au Sent: Wednesday, March 28, 2012 10:22 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: DevStudio Tool ** Hi Dan, Joe and everyone, I've been using Dev Studio since 7.5 first came out and I would never consider going back to the old admin tool. Whilst you certainly need a high resolution screen and you should go 64bit and up your heap from the default there are plenty of huge upsides in dev studio. My favourites are: 1. The Outline View and the ability to sort fields by ID or by label or by name to find the field you need quickly. 2. Once you find the field the show relationships feature will enable you to drill in to the right workflow quickly and to be confident that you have captured all of the impacts. 3. If you need to bulk change a whole bunch of fields, active links or anything else you can usually select the objects and use the properties page to do a bulk update. 4. Autocomplete, built in help and syntax checking are nice especially now that the bugs
Re: DevStudio Tool
I make Sushi. Rolls, Nigiri, Sashimi, etc. Sent from my Android phone - autocorrect mistakes are Google's fault ! :-) - Reply message - From: Joe Martin D'Souza jdso...@shyle.net Date: Fri, Mar 30, 2012 4:01 pm Subject: DevStudio Tool To: arslist@ARSLIST.ORG This is fun! Would be more fun if there was beer and/or warm saki and sushi at the kidnapping party! -Original Message- From: Carin Grobler Sent: Friday, March 30, 2012 4:29 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: DevStudio Tool I'll be part of the kidnapping ring.. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: JOB: Immediate opening with CSC for a Remedy Developer with active TS in Quantico, VA
I'm kinda curious. I have the S+ and the ars experience and Am working on the Redhat and MSITS/dba certs. What are you offering? Thanks, John From: Steven J. Pattie spat...@csc.com To: arslist@ARSLIST.ORG Sent: Monday, March 5, 2012 3:15 PM Subject: JOB: Immediate opening with CSC for a Remedy Developer with active TS in Quantico, VA CSC is seeking an experienced Remedy Systems Administrator to work at Quantico VA. Candidates must possess a current DoD Top Secret security clearance and meet minimum DoD 8570.1 certification requirements. DoD 8570.1 Certification requirements: CompTIA Security+ Plusses: Microsoft Certified Database Administrator (MCDBA) Essential Job Functions: • Performs complex product design, system analysis and programming activities on application software to ensure that company technology needs are met. • Performs design, implementation and maintenance of complex multiple product modules/subsystems or on lower level issues of multiple products to ensure proper functioning of products. Participates in product design meeting to ensure that design concepts are transferred into application development successfully. • Analysis, design, development, deployment, installation, configuration, customization, troubleshooting tuning of Remedy Action Request System from version 6.0 to 7.x. • Performs complex bug verification, release testing and beta support for assigned products; researches problems discovered by quality analysts or product support to ensure that appropriate solutions are developed. • Coordinates with appropriate management personnel in implementing changes. • Supports complex data/media recoverability through system backups and database archive operations. Plans, coordinates and directs appropriate level data refresh strategies. • Gather and document requirements and support the design of implementation of additional Remedy services, such as CMDB and Remedy Dashboards. • Develop and maintain user documentation, including user manuals, quick references, and training documentation. • Works with technical staff to understand problems with software to ensure that they are resolved in a timely manner. • Diagnose and repair problems within the Remedy system. For more info please email me at spat...@csc.com or go to: http://www.csc.com/careersus/flx/16177-job_opportunities Search for Job # 12001FJ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: BMC Analytics Report Question - Report of Multiple Associations to Almost All of the ITSM Apps
BOXI could do it but would be very difficult. You should take a look at using Yurbi (http://www.yurbi.com). You could build those relationships and get the report pretty easy via one of our AnyDB apps. You can check out this video for a high level of that process - http://yurbi.tv/index.php?p=263 We have an out of the box connection to Remedy that is much easy than Analytics, you can learn more about that here - http://yurbi.tv/index.php?p=216 But due to the complexity I would recommend you try to achieve this query from the out of the box Yurbi for BMC Remedy app but rather build it with AnyDB.The cool thing is with Yurbi you could tie the report from Remedy with other data sources in your environment that may have supporting info for your managemenet, like a ERP, accounting, inventory, etc, system. thanks, David On Fri, Mar 30, 2012 at 11:22 AM, Andre Hughes neo1...@yahoo.com wrote: Hello, I haven't used Analytics and I need to know if a particular report is even possible to be generated. Here is the back ground: We have a process that a ordinary business user will submit a request via SRM (Service Request Management). Management will either Approve or Reject the Request. Once the Request is approved, it will generate a Work Order. The Work Order will be the holding bin for the Request and it is prioritized and analyzed. After determining this Request is ready to be put into Production, the support group will generate a Change Request and relate the Work Order. There can be 2 paths for the Change Request - 1) Only a Change Request or 2) A Change Request with a Release. (The Release must be related to the Work Order) So essentially the Work Order becomes the Parent Record with all other Relationships tied to it. WO-- (PARENT) INC -- (RELATED TO WO. This is another optional relationship, not noted above) CRQ -- (RELATED TO WO) RLM -- (RELATED TO WO) Here is what I need for a Report out of Analytics - I need a report that has all of the Related records from the Work Order (INC, CRQ, RLM, AAS, TSK, etc). This report should show me the basic information of each Record (Record ID #, Assignment, Customer, Summary, Status, Status History, Target Dates, Scheduled Dates, etc) --- I have looked into creating a report outside of Analytics with using Joins (WOI:Associations + WOI:WorkOrder), however to get to the basic level of information for the main apps, I would need to create joins to at least 7 levels, ouch! Please, let me know if Analytics can handle this type of reporting as it is critical to our management and support staff. Thanks, Andre ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are -- *David A. Ferguson *Yurbi® - Bring Your Data to Life http://www.yurbi.com* * Work: 571-354-0515 begin_of_the_skype_highlighting571-354-0515 end_of_the_skype_highlighting 571-354-0515 Fax: 703-991-5935 Email: david.fergu...@5kfish.com http://www.linkedin.com/in/davferg http://www.twitter.com/davferg5000 5000fish, Inc. http://www.5kfish.com 2850 W. Horizon Ridge Parkway Suite 200 Henderson, NV 89052 http://www.linkedin.com/in/davferg ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: DevStudio Tool
You’re my best friend! I bought a sushi kit, yet to try to make any.. Did you learn to make it yourself? Or did you go for some cooking classes? I saw a few online video’s to learn to DIY and it looks pretty simple.. Got to love the internet.. Learnt today to clean my camera SLR sensors – something that a decade ago I might have spent 100 dollars to get done at a shop.. Joe From: bauti...@bullcreek.com Sent: Friday, March 30, 2012 7:34 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: DevStudio Tool ** I make Sushi. Rolls, Nigiri, Sashimi, etc. Sent from my Android phone - autocorrect mistakes are Google's fault ! :-) - Reply message - From: Joe Martin D'Souza jdso...@shyle.net Date: Fri, Mar 30, 2012 4:01 pm Subject: DevStudio Tool To: arslist@ARSLIST.ORG This is fun! Would be more fun if there was beer and/or warm saki and sushi at the kidnapping party! -Original Message- From: Carin Grobler Sent: Friday, March 30, 2012 4:29 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: DevStudio Tool I'll be part of the kidnapping ring.. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: DevStudio Tool
No classes, no internet. Just imagination amp; creativitykind of like Remedy :-) Maybe I can male Sushi in the back of the room while you present on DS. I am sure I won't be able to keep quiet if I am in the room anyway! Happy Friday, Everyone. Sent from my Android phone - autocorrect mistakes are Google's fault ! :-) - Reply message - From: Joe Martin D'Souza jdso...@shyle.net Date: Fri, Mar 30, 2012 9:20 pm Subject: DevStudio Tool To: arslist@ARSLIST.ORG You’re my best friend! I bought a sushi kit, yet to try to make any.. Did you learn to make it yourself? Or did you go for some cooking classes? I saw a few online video’s to learn to DIY and it looks pretty simple.. Got to love the internet.. Learnt today to clean my camera SLR sensors – something that a decade ago I might have spent 100 dollars to get done at a shop.. Joe From: bauti...@bullcreek.com Sent: Friday, March 30, 2012 7:34 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: DevStudio Tool ** I make Sushi. Rolls, Nigiri, Sashimi, etc. Sent from my Android phone - autocorrect mistakes are Google's fault ! :-) - Reply message - From: Joe Martin D'Souza jdso...@shyle.net Date: Fri, Mar 30, 2012 4:01 pm Subject: DevStudio Tool To: arslist@ARSLIST.ORG This is fun! Would be more fun if there was beer and/or warm saki and sushi at the kidnapping party! -Original Message- From: Carin Grobler Sent: Friday, March 30, 2012 4:29 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: DevStudio Tool I'll be part of the kidnapping ring.. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: DevStudio Tool
Joe, Sounds like the WWRUG staff has your number. I'll kick in a beer or two. Dave On Mar 30, 2012, at 5:20 PM, Jason Miller jason.mil...@gmail.commailto:jason.mil...@gmail.com wrote: ** Did anybody say there wouldn't be? Although now we are encouraging you to be difficult and make us come after you. On Fri, Mar 30, 2012 at 2:01 PM, Joe Martin D'Souza jdso...@shyle.netmailto:jdso...@shyle.net wrote: This is fun! Would be more fun if there was beer and/or warm saki and sushi at the kidnapping party! -Original Message- From: Carin Grobler Sent: Friday, March 30, 2012 4:29 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: DevStudio Tool I'll be part of the kidnapping ring.. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.orghttp://www.arslist.org attend wwrug12 www.wwrug12.comhttp://www.wwrug12.com ARSList: Where the Answers Are _attend WWRUG12 www.wwrug.comhttp://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