One of the common questions we get from the application development team was
How many tickets were created last night for my application team?
Or
The manager of Infrastructure team wants a report of all tickets assigned to his team for last 7 days?
The solution is to run macros and give them the txt output OR teach them how to run macros or use remedy user client. The task is always time consuming or needs a dedicated resource.
Then the concept of Generic Remedy Reporter Module was born……………………….
Note – This Module is not supported by Remedy.
What is Remedy Reporter Module? And how do we develop it?
Take one spoon of ASP script with some Crystal knowledge & mix it with a store procedure and you have it.
In technical terms -
You need the Remedy Developer – who can give you details on the fields and the tables for different remedy forms.
Create store procedures to get information from the database.
Create a website in ASP connected to crystal reports accepting pre-defined queries.
The concept is pretty simple. Database -> ASP -> Crystal -> PDF output.
Some of the major concerns of this Generic application were –
Remedy Server Performance., Complex Stored procedures, where will the application reside?
The concerns were valid; moreover you didn’t want to touch the remedy core database infrastructure. The way to approach to this was keep the website separate from the Mid-tier client. All the stored procedures created were kept in a separate database/schema on the same instance. So the basic concerns are addressed – now for server performance – run the application on the DR database which is read-only in most organization and gets synced periodically. Create predefined query forms with pre-defined time interval – this will give you optimized stored procedure. Lastly create simple stored procedures. Let Crystal report handle mathematical and display functions. Stored procedures should on display data.
If you need any more information on how to work on this model feel free to drops a note.
No comments:
Post a Comment