Service Desk Practitioners Forum
cancel

How to get data from History field

Highlighted
Kris De Caluwe
New Member.

How to get data from History field

Hello,

Can you help me on how i can extract data from the history field in HPOV SD 4.5?

I need to extract data to excel but that is the only field that cannot be shown in the views.

Kind regards
Kris
3 REPLIES
George M. Meneg
Acclaimed Contributor.

Re: How to get data from History field

Hello Kris,

To fetch history lines data normally you need a third party report tool like crystal reports or write an sql query.

But there is a nifty workaround, but you need to do this for one service call at a time:

run the following command:

sd_dataform.bat "history line service call" +"Service Call.ID=" -ListAlways

You must substitute with a service call id. A window will be opened. At this window make a right click and select any report style except standard. Then do "Print Preview" and select "Publish". There you can copy-paste to excel!
menes fhtagn
Ruth Porter
Acclaimed Contributor.

Re: How to get data from History field

Hi there,

Another way is to set up an explorer view with a leaf of history; then you can select a call, highlight everything in the leaf and copy/paste to excel. Like George's method, it only works 1 SC at a time.

If you want to do it for several SCs then a reporting tool is probably best.

Hope this helps, Ruth
http://www.teamultra.net
Rajesh Nair
Outstanding Contributor.

Re: How to get data from History field

Hi,

One way of copying history for a particular call would be to open the service call...then click on FILE--->PRINT PREVIEW----->COPY whatever you want & paste it in Excel or Word.

Regards

Rajesh