Absent Member.. Absent Member..
Absent Member..
437 views

Need a dump from probsummary with data from screlation as well

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

 

 

0 Likes
3 Replies
Absent Member.
Absent Member.

Yes it is achievable but how are you creating dump?
____________________________________
Assign Kudo, if found post useful and mark it accepted if solves the issue.
Absent Member.. Absent Member..
Absent Member..

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

0 Likes
Absent Member.
Absent Member.

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.
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.