Need a dump from probsummary with data from screlation as well - Micro Focus Community

Maurice vd Drie · ‎2012-10-03

All,

I need to create a daily dump of incidents, so from the probsummary file, as a cvs file. But, I need info as well about the incident and if it has related records: interactions, problems, changes. So during the dump, I need to check screlation as well and get the data in the dump.

Can that be achieved?

Thanks

Maurice

Piku · ‎2012-10-03

Yes it is achievable but how are you creating dump?

____________________________________
Assign Kudo, if found post useful and mark it accepted if solves the issue.

Maurice vd Drie · ‎2012-10-03

I was thinking about a search , modify the columns I need and export it on a regular basis ..

or you have a better option in mind?

cheers

Maurice

Piku · ‎2012-10-11

Hi Maurice,

It is possible to schedule the export on predefined query and you can easily tailor your query using JS to fit your requirement.
You can export only data from single file (like probsummary, incidents etc) at a time. Can not merge data in data from two files in single one.
You have to query the incidents then fetch the related incident from screlation then combining all off these incident numbers and build the final query. (Will be easy)

And here data will export to server side not on client.

Two way to export data,
1) http://h30499.www3.hp.com/t5/Service-Manager-Support-Customer/Shedule-Archive-export-to-excel/m-p/5662019#M1253
2) http://h30499.www3.hp.com/t5/HP-Service-Manager-Service/HPSM-records-archival/m-p/4690379#M46590

hth,

____________________________________
Assign Kudo, if found post useful and mark it accepted if solves the issue.