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

2012-02-16 Thread Brian Pancia
omers. Brian From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Hari Vishwakarma Sent: Monday, February 13, 2012 1:33 PM To: arslist@ARSLIST.ORG Subject: How to create an archival server in remedy in windows platform!!! ** Hi All, I wa

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

2012-02-16 Thread Jose Huerta
I assume that you'll access your archived data at two cases: - To check a particular past value from mid-tier (not common) - For reporting (common) What tool do you plan for reporting? I assume that it will be external to ARS, (like BOXI, pentahoo, or other), that will access the db, so no use

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

2012-02-16 Thread Hari Vishwakarma
Hi Joe, My intention is to reduce the load on the production and to use that archived data for reporting and audit purpose. If this archiving can be achieved on an database level with much ease and without any complexity,then, can you please suggest me the plan of approach so that i can opt for th

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

2012-02-16 Thread Jason Miller
You mentioned Meta-Update previously. I am thinking more and more this is one of the better routes for Hari to take. It would take a little bit of effort to identify all of the forms/relationships and plan out what you want to archive. Once all of relationships/dependencies are mapped and accoun

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

2012-02-16 Thread Jose Huerta
One question. Why do you want archiving to take place on a different server? I mean, the archived tables can reside on the same database engine. It's up to the dba to tune the database and place those table on a different volume. Regards, Jose Huerta http://theremedyforit.com/ On Thu, Feb 16,

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

2012-02-16 Thread Hari Vishwakarma
Hi All, @Allen, Thanks Allen for your well guided and motivated approach.I will keep all suggestions in mind and accordingly implement the same. Thanks & Regards Hari hsvishwaka...@gmail.com +91-9923490040 On Thu, Feb 16, 2012 at 10:58 PM, Elry wrote: > Now I have a clearer picture of what

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

2012-02-16 Thread Elry
Now I have a clearer picture of what you are trying to do... The key to your success will be in understanding the underlying data dictionary (not in the traditional sense either).  You will need some help in this area.  You may want to ask Joe D. for help. 1. ITSM is very complex system and diffi

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

2012-02-15 Thread Hari Vishwakarma
Hi All, @Allen, Thanks for your valuable suggestions. But out of the available options, i think i need to choose the best otherwise i will be playing with fire. I am looking to archive the data in the following way: 1. Selective archiving( with conditions such as all the tickets which are closed

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

2012-02-14 Thread Elry
Hey Hari... Some quick opinions : 1. Looks like you will be doing selective archiving & not fixed archiving. What this means for us is that you will be selecting criteria for tickets that will be archived as opposed to archiving all tickets for a fixed time period. This means that you will have

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

2012-02-14 Thread Hari Vishwakarma
Hi, We are planning to have archiving server with the following strategies in place: 1. We will be moving our production server data to the newly created archiving server with certain conditions like incident=closed or cancelled, and we will be archiving the data on an interval of 2-3 months. He

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

2012-02-13 Thread Elry
Well Hari... We currently just finishing up the creation of an archival server. I guess my key questions would be: 1. Do you have any Archive Policies in place (i.e. Incident Tickets will be automatically closed after 90 Days). 2. What applications are you running (i.e. ITSM or Custom Applicatio

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

2012-02-13 Thread Hari Vishwakarma
Hi All, I want to create an archival server which will offload my production server load & improves my production server performance Can anyone suggest what are all the prerequisites for the required archival server.And what need to be kept in mind while configuring this. Also will it require any