Going back to the original description, an archive system that is queried a couple of times a year, I would agree with LJ LongWing that a good fit is to approach this from the database side and switch your Remedy queries to database queries. If you can keep the entire database intact that would be the easiest method. While Remedy is still up I would recommend taking a list of the queries you have run over the past years and take some time learning to duplicate them with direct database queries, in particular noting relationships that are relevant (ticket to work info, tasks, etc) so that you can access all the data your users require easily. If you have a separate reporting solution, you could take the most common queries and create reports based on them to make things easier, perhaps even to the point of publishing the reports with dynamic parameters like Start and End dates so that users can run the reports themselves when they need the information. Or some basic scripting in a handy language you use at your company could do the same job with a web form that runs a set of canned database queries.
Attachments would be an extra challenge. If your archive queries include pulling attached files from old tickets then you'll need to learn how to translate the B/CLOB data to recreate the file. Again, there's info on how to do this and could probably be automated without too much trouble. If you can't keep the entire database and have to work off a smaller set of data, then I would approach this like a regular Remedy archive project - review the forms and data, determine which are necessary and what their relationships are and then export them to a simpler solution (another database, flat file, etc). On Thu, Aug 15, 2019 at 5:51 PM Ian.Trimnell <ian.trimn...@open.ac.uk> wrote: > Hi Claire, > > > > Same here. We had our Remedy system (7.5) on a Windows 2003 server which > had to go. The last supported part of AR System – a custom IT Ordering > System – was moved to a SCSM-based setup earlier this year so I was forced > to shut it all down. (We had been running since 1998 on Windows, moving to > new servers as required, and had stopped paying for maintenance renewal for > about 5 years or more so we couldn’t move to a newer version of AR > System.) The SQL Server was also 2003 so was removed as well. I still > receive requests for records of the old systems, all custom built in house, > and I have migrated a number of sections onto a MySQL server I control. The > worst bit comes in building a suitable interface – nothing seems to beat > the AR System way of doing things! > > > > There was nothing I could find which would fit the job, apart from > converting the database (had both ARX files and an SQL dump) and building > any necessary front-ends. The only one I’ve had to do fully was a user > management system – keeping track of any email addresses and user-ids > allocated to staff. Everything else is handled by database queries > (phpMyAdmin helps as a GUI to MySQL but sometimes using the mysql command > line is eminently suitable! > > > > Sorry, not a lot of help, but good luck in finding something which suits > your particular situation. > > > > *Ian* > > ---------- > > *Ian Trimnell*, Systems Programmer, Information Technology > > The Open University, Milton Keynes, UK > > Phone: 01908 653741 web: http://www.open.ac.uk > > > > *From: *ARSList <arslist-boun...@arslist.org> on behalf of "Sanford, > Claire" <claire.sanf...@memorialhermann.org> > *Reply to: *ARSList <email@example.com> > *Date: *Thursday, 15 August 2019 at 20:23 > *To: *ARSList <firstname.lastname@example.org> > *Subject: *RE: [EXTERNAL] Re: Old Remedy 6.3 data > > > > Yes, we moved to another solution. I enjoy learning the new stuff, but I > miss the comfort of what I knew like the back of my hand. > > > > We have people come back for change records etc for legal things > periodically and have to keep it. > > > > Thank you! > > Claire > > > > *From:* ARSList <arslist-boun...@arslist.org> *On Behalf Of *LJ LongWing > *Sent:* Thursday, August 15, 2019 2:04 PM > *To:* ARSList <email@example.com> > *Subject:* [EXTERNAL] Re: Old Remedy 6.3 data > > > > Carina, > > If I'm not mistaken, they aren't using Remedy anymore (moved to another > solution)....so Remedy for them is just in mothballs wanting/needing as > little time/effort as possible. > > > > On Thu, Aug 15, 2019 at 12:54 PM Burns, Carina <carina.bu...@risd.org> > wrote: > > If it’s a custom app, why not import the defs with Designer Studio then > DDM the records off the old ARSystem with migrator? Just be sure your > database/system can handle that volume of data. > > > > I did that for our legacy custom help desk app (built on 4.3 and upgraded > thru 8.1) and it’s all living happily alongside my > ITSM/ServiceDesk/Smartit/DWP apps on my 19.02 box. I just did a basic > “main menu” with “open form” active link buttons to select the old app > forms. I also created a filter restricting record modifies/submits. > > > > If it’s an old ITSM records, could you maybe still migrate/DDM the data > and put them into archive? I don’t know If they’d be viewable with > whatever level of ITSM you’re currently running. > > > > *From:* ARSList <arslist-boun...@arslist.org> *On Behalf Of *LJ LongWing > *Sent:* Thursday, August 15, 2019 1:36 PM > *To:* ARSList <firstname.lastname@example.org> > *Subject:* Re: Old Remedy 6.3 data > > > > Your option I think is to simply stop using Remedy at that point and just > access the data at the DB level....if you want to use the Remedy > Application, you need the Remedy application though. > > > > On Thu, Aug 15, 2019 at 12:12 PM Sanford, Claire < > claire.sanf...@memorialhermann.org> wrote: > > Hey Old Friends! > > > > We have an old Remedy server that is strictly an archive. We have people > ask for ticket info a few times a year or so. We have been told that we > have to upgrade the server. Since the old server is 32bit and the new one > is 64bit, they are telling me I have to reinstall the apps that are on the > server. > > > > Does anyone have a front end for an old Remedy system that does not entail > reinstalling the apps? > > > > > > > > Claire Sanford > > ISD ITCC Technical Engineering > > Lead Application Analyst > > > > Memorial Hermann, Memorial City > > Medical Plaza North > > 920 Frostwood > > Houston, TX 77024 > > P 713.338.6035 > > *claire.sanf...@memorialhermann.org <claire.sanf...@memorialhermann.org>* > > > > -- > ARSList mailing list > ARSList@arslist.org > https://mailman.rrr.se/cgi/listinfo/arslist > <https://urldefense.proofpoint.com/v2/url?u=https-3A__mailman.rrr.se_cgi_listinfo_arslist&d=DwMFaQ&c=cBOA5YEoZuz9KdLvh38YxdrPtfJt83ckXekfBgq5xB0&r=TjDOQeE84FB3IkKBOKJ7-reBz8qKDLQv4sMWw_GFxq4ypeuVm4ZMlj00hGeKuFbo&m=MALDIa38iVr7jw6M0kmOIiUqkQR7InXApIQLtOgk3So&s=2xi3wUi3t2JqcEMVs33r5X7MTz2H48JjSisFf6Jm8zs&e=> > > -- > ARSList mailing list > ARSList@arslist.org > https://mailman.rrr.se/cgi/listinfo/arslist > <https://urldefense.proofpoint.com/v2/url?u=https-3A__mailman.rrr.se_cgi_listinfo_arslist&d=DwMFaQ&c=cBOA5YEoZuz9KdLvh38YxdrPtfJt83ckXekfBgq5xB0&r=TjDOQeE84FB3IkKBOKJ7-reBz8qKDLQv4sMWw_GFxq4ypeuVm4ZMlj00hGeKuFbo&m=MALDIa38iVr7jw6M0kmOIiUqkQR7InXApIQLtOgk3So&s=2xi3wUi3t2JqcEMVs33r5X7MTz2H48JjSisFf6Jm8zs&e=> > > -- > ARSList mailing list > ARSList@arslist.org > https://mailman.rrr.se/cgi/listinfo/arslist > -- *Kelly Logan* | *Senior Consultant* 313-651-7169 | kelly.lo...@raptek.com *RAPID* Technologies www.raptek.com
-- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist