RE: [EXTERNAL] Re: Old Remedy 6.3 data

2019-08-16 Thread Ken Pritchard via ARSList
Can’t speak to the other systems you mentioned, but as you said above the last 
line – it’s not unique to Remedy – ServiceNow also has the ability to build 
whatever tables / applications you want.

 

From: ARSList  On Behalf Of Jason Miller
Sent: Friday, August 16, 2019 11:02 AM
To: ARSList 
Subject: Re: [EXTERNAL] Re: Old Remedy 6.3 data

 

Regarding where to put the historical Remedy data... I once took an 
organization from Remedy ITSM to newly developed homegrown Remedy application. 
Similarly they needed to keep their ITSM Change Requests (Work Info, Audit, 
Tasks, etc.) for regulatory purposes. Like Carina suggested, in the homegrown 
system I made a few shell forms (copies of the ITSM forms and imported the defs 
into the new server) with no code except a few active links to open some 
windows and a filter to prevent submit/modify.

 

In Claire's case, her new system is not Remedy so this is not exactly an 
option. But let's say she moved to ServiceNow, can you build custom 
forms/tables/whatever SN calls them, import the data, and provide something 
similar to what Carina and I have done in the past? This would give her users a 
view of the data in the tool they are using on a daily basis.

 

What if the system is Cherwell? Jira? Ivanti (Heat), Track-It? 

 

Or is this one of the unique strengths of Remedy; the ability to build whatever 
you need?

 

Jason

 

On Fri, Aug 16, 2019 at 8:38 AM Kelly Logan mailto:kelly.lo...@raptek.com> > wrote:

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 mailto: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/> http://www.open.ac.uk

 

From: ARSList mailto:arslist-boun...@arslist.org> 
> 

RE: [EXTERNAL] Re: Old Remedy 6.3 data

2019-08-16 Thread Ben Chernys
Hi All,

 

Our product, Meta-Archive 
<http://www.softwaretoolhouse.com/product/SthArch/index.html> , will produce 
html pages of all Remedy data, drilling down to any detail you’d like, with 
links to attachments - all through a configurable spreadsheet.  Customizations 
and bespoke apps are trivial to configure in that sheet.  Will handle any 
release of Remedy and ITSM including 32 bit.  Will also build hierarchical 
indexes and record the URLs and searchable data on ServiceNow forms.  All data 
into CSVs, html files including indexes.

 

Interested in learning more?  Take a look at the sample ITSM output 
<http://www.softwaretoolhouse.com/product/SthArch/sample/index.html>  on the 
web.  If interested in learning more, send us an email off-list.  

 

Cheers

Ben Chernys

 


Cheers,

Ben Chernys
Senior Software Architect
  

Canada / Deutschland
Mobile:+49 171 380 2329   GMT - 7+ [ DST ]

Mobile +1 403  554 0887
Email:   ben.cher...@softwaretoolhouse.com 
<mailto:ben.cher...@softwaretoolhouse.com> 
Web:  <http://www.softwaretoolhouse.com/> www.softwaretoolhouse.com

We are a BMC Technology Alliance Partner

 

 

 <http://www.softwaretoolhouse.com/> http://www.softwaretoolhouse.com/ 

 

Check out Software Tool House's free Diary Editor and our  Freebies Section for 
BMC ITSM & ServiceNow Forms and Fields spreadsheets.

Meta-Update <http://www.softwaretoolhouse.com/product/SthMupd/index.html> , our 
premium ARS and ServiceNow Data tool, lets you automate your imports, 
migrations, in no time at all, without programming, without staging forms, 
without merge workflow. 

 

Meta-Archive <http://www.softwaretoolhouse.com/product/SthArch/index.html>  
does ITSM Archiving your way: your forms and multi-tenant rules, treating each 
root request as a complete tree and checking associations.  Archive to 
different servers, CSV files, HTML pages with links to attachments or archive 
forms.  Our HTML version can write URL links and seartchable values in an ARS 
or ServiceNow form.  Includes Restore abiliy. 

 

Meta-Databot <http://www.softwaretoolhouse.com/product/Databot/index.html>  is 
an automated, extensibl,e BMC Data Wizard.  It reads a file of data changes and 
sports an Undo feature.

 

 

 

 

 

 

From: ARSList mailto:arslist-boun...@arslist.org> 
> On Behalf Of Sanford, Claire
Sent: August-15-19 1:21 PM
To: ARSList mailto:arslist@arslist.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 mailto:arslist-boun...@arslist.org> 
> On Behalf Of LJ LongWing
Sent: Thursday, August 15, 2019 2:04 PM
To: ARSList mailto:arslist@arslist.org> >
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 mailto: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 mailto:arslist-boun...@arslist.org> 
> On Behalf Of LJ LongWing
Sent: Thursday, August 15, 2019 1:36 PM
To: ARSList mailto:arslist@arslist.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 levelif you want to use the Remedy Application, 
you need the Remedy application though.

 

On Thu, Aug 15, 2019 at 12:12 PM Sanford, Claire 
mailto: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 

Re: [EXTERNAL] Re: Old Remedy 6.3 data

2019-08-16 Thread Jason Miller
Regarding where to put the historical Remedy data... I once took an
organization from Remedy ITSM to newly developed homegrown Remedy
application. Similarly they needed to keep their ITSM Change Requests (Work
Info, Audit, Tasks, etc.) for regulatory purposes. Like Carina suggested,
in the homegrown system I made a few shell forms (copies of the ITSM forms
and imported the defs into the new server) with no code except a few active
links to open some windows and a filter to prevent submit/modify.

In Claire's case, her new system is not Remedy so this is not exactly an
option. But let's say she moved to ServiceNow, can you build custom
forms/tables/whatever SN calls them, import the data, and provide something
similar to what Carina and I have done in the past? This would give her
users a view of the data in the tool they are using on a daily basis.

What if the system is Cherwell? Jira? Ivanti (Heat), Track-It?

Or is this one of the unique strengths of Remedy; the ability to build
whatever you need?

Jason

On Fri, Aug 16, 2019 at 8:38 AM Kelly Logan  wrote:

> 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 
> 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  on behalf of "Sanford,
>

RE: [EXTERNAL] Re: Old Remedy 6.3 data

2019-08-16 Thread Ken Pritchard via ARSList
I’ve actually done a migration of the data using web services.  Built a web 
service to get the records from Remedy and then built ‘read-only’ archive 
tables in the new system, pulled the data across into those tables.  

 

Attachments are a bit of a different story – used outbound email to transfer 
those across to the new system.  Need a bit of info in the email body to 
identify what the attachment relates to.

 

It’s really a cost matter – whether it’s less costly to keep the database / 
data around and accessible or just archive it in the new system (In a db that’s 
already being maintained) vs building the web services to extract / consume the 
records.

 

From: ARSList  On Behalf Of Jason Miller
Sent: Friday, August 16, 2019 9:56 AM
To: ARSList 
Subject: Re: [EXTERNAL] Re: Old Remedy 6.3 data

 

Regarding attachments, LJ built a tool for that :)

 

http://remedylegacy.com/tools/db-attachments/ 

 

Jason 

 

On Fri, Aug 16, 2019 at 8:38 AM Kelly Logan mailto:kelly.lo...@raptek.com> > wrote:

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 mailto: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/> http://www.open.ac.uk

 

From: ARSList mailto:arslist-boun...@arslist.org> 
> on behalf of "Sanford, Claire" 
Reply to: ARSList mailto:arslist@arslist.org> >
Date: Thursday, 15 August 2019 at 20:23
To: ARSList mailto:arslist@arslist.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.  

Re: [EXTERNAL] Re: Old Remedy 6.3 data

2019-08-16 Thread Jason Miller
Regarding attachments, LJ built a tool for that :)

http://remedylegacy.com/tools/db-attachments/

Jason

On Fri, Aug 16, 2019 at 8:38 AM Kelly Logan  wrote:

> 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 
> 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  on behalf of "Sanford,
>> Claire" 
>> *Reply to: *ARSList 
>> *Date: *Thursday, 15 August 2019 at 20:23
>> *To: *ARSList 
>> *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  *On Behalf Of *LJ LongWing
>> *Sent:* Thursday, August 15, 2019 2:04 PM
>> *To:* ARSList 
>> *Subject:* [EXTERNAL] Re: Old Remedy 6.3 data
>>
>>
>>
>> Carina,
>>
>> If I'm not mistaken, they aren't using Remedy anymore (moved to another

Re: [EXTERNAL] Re: Old Remedy 6.3 data

2019-08-16 Thread Kelly Logan
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 
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  on behalf of "Sanford,
> Claire" 
> *Reply to: *ARSList 
> *Date: *Thursday, 15 August 2019 at 20:23
> *To: *ARSList 
> *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  *On Behalf Of *LJ LongWing
> *Sent:* Thursday, August 15, 2019 2:04 PM
> *To:* ARSList 
> *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 
> 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 

Re: [EXTERNAL] Re: Old Remedy 6.3 data

2019-08-15 Thread Ian.Trimnell
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<http://www.open.ac.uk/>

From: ARSList  on behalf of "Sanford, Claire" 

Reply to: ARSList 
Date: Thursday, 15 August 2019 at 20:23
To: ARSList 
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  On Behalf Of LJ LongWing
Sent: Thursday, August 15, 2019 2:04 PM
To: ARSList 
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 
mailto: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 mailto:arslist-boun...@arslist.org>> 
On Behalf Of LJ LongWing
Sent: Thursday, August 15, 2019 1:36 PM
To: ARSList mailto:arslist@arslist.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 levelif you want to use the Remedy Application, 
you need the Remedy application though.

On Thu, Aug 15, 2019 at 12:12 PM Sanford, Claire 
mailto: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?

[cid:image001.jpg@01D553BB.B9085B20]


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<mailto:claire.sanf...@memorialhermann.org>

--
ARSList mailing list
ARSList@arslist.org<mailto: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<mailto:ARSList@arslist.org>
https://mailman.rrr.se/cgi/listinfo/arslist<https://urldefense.proofpoint.com/v2/url?u=h

RE: [EXTERNAL] Re: Old Remedy 6.3 data

2019-08-15 Thread Sanford, Claire
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  On Behalf Of LJ LongWing
Sent: Thursday, August 15, 2019 2:04 PM
To: ARSList 
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 
mailto: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 mailto:arslist-boun...@arslist.org>> 
On Behalf Of LJ LongWing
Sent: Thursday, August 15, 2019 1:36 PM
To: ARSList mailto:arslist@arslist.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 levelif you want to use the Remedy Application, 
you need the Remedy application though.

On Thu, Aug 15, 2019 at 12:12 PM Sanford, Claire 
mailto: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?

[Description: Description: 
https://secure1.mhhs.org/branding/CORPORATE_DOWNLOADS/USER_TEMPLATES/SYSTEM/email_signature/MHH_ESIGLogo.jpg]


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<mailto:claire.sanf...@memorialhermann.org>

--
ARSList mailing list
ARSList@arslist.org<mailto: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<mailto: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


Re: Old Remedy 6.3 data

2019-08-15 Thread LJ LongWing
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 
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  *On Behalf Of *LJ LongWing
> *Sent:* Thursday, August 15, 2019 1:36 PM
> *To:* ARSList 
> *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 levelif 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?
>
>
>
> [image: Description: Description:
> https://secure1.mhhs.org/branding/CORPORATE_DOWNLOADS/USER_TEMPLATES/SYSTEM/email_signature/MHH_ESIGLogo.jpg]
>
>
>
>
>
> 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 *
>
>
>
> --
> ARSList mailing list
> ARSList@arslist.org
> https://mailman.rrr.se/cgi/listinfo/arslist
>
> --
> ARSList mailing list
> ARSList@arslist.org
> https://mailman.rrr.se/cgi/listinfo/arslist
>
-- 
ARSList mailing list
ARSList@arslist.org
https://mailman.rrr.se/cgi/listinfo/arslist


RE: Old Remedy 6.3 data

2019-08-15 Thread Burns, Carina
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  On Behalf Of LJ LongWing
Sent: Thursday, August 15, 2019 1:36 PM
To: ARSList 
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 levelif you want to use the Remedy Application, 
you need the Remedy application though.

On Thu, Aug 15, 2019 at 12:12 PM Sanford, Claire 
mailto: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?

[Description: Description: 
https://secure1.mhhs.org/branding/CORPORATE_DOWNLOADS/USER_TEMPLATES/SYSTEM/email_signature/MHH_ESIGLogo.jpg]


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<mailto:claire.sanf...@memorialhermann.org>

--
ARSList mailing list
ARSList@arslist.org<mailto:ARSList@arslist.org>
https://mailman.rrr.se/cgi/listinfo/arslist
-- 
ARSList mailing list
ARSList@arslist.org
https://mailman.rrr.se/cgi/listinfo/arslist


Re: Old Remedy 6.3 data

2019-08-15 Thread LJ LongWing
Your option I think is to simply stop using Remedy at that point and just
access the data at the DB levelif 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?
>
>
>
> [image: Description: Description:
> https://secure1.mhhs.org/branding/CORPORATE_DOWNLOADS/USER_TEMPLATES/SYSTEM/email_signature/MHH_ESIGLogo.jpg]
>
>
>
>
>
> 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 *
>
>
> --
> ARSList mailing list
> ARSList@arslist.org
> https://mailman.rrr.se/cgi/listinfo/arslist
>
-- 
ARSList mailing list
ARSList@arslist.org
https://mailman.rrr.se/cgi/listinfo/arslist