Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

How to get data from History field

Highlighted
Kris De Caluwe
Acclaimed Contributor

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
Honored 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
Honored 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
Esteemed 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
//Add this to "OnDomLoad" event