Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

How can audit history of Requirements be exported to excel?

Questions
Tags
Users
Badges
Jeffrey Burke
(31●26●37) Jan 26 '15, 1:34 p.m.
How can audit history of Requirements be exported to excel?

I see how to export audit history to pdf (via a report). And I can export the Requirements record (but only certain attributes) to excel. But don't see how to export the audit history of a Requirements record to an excel file.

Thanks!

0 votes

3 answers
4,204 views
0 votes

3 answers

Permanent link
Erica Tran
JAZZ DEVELOPER (1.4k●7) Jan 28 '15, 2:28 p.m.
Hi Jeffrey,
There is no feature that exports audit history to Excel. 
You can get history to return in the form of a feed using the URL below.
https://{host:port}/rm/revisions?accept=*&private=true&url=https://{host:port}/rm/resources/{UUID}

0 votes

Comments
Jeffrey Burke
Jan 29 '15, 8:41 a.m.

Thanks Erica!

Permanent link
Edgar Ignacio Velazquez Mar
JAZZ DEVELOPER (722●5) Jan 28 '15, 2:58 p.m.
 You can probably export to HTML and import to Excel from that, tho it will require some manual copy paste or some scripting 

0 votes

Comments
Jeffrey Burke
Jan 29 '15, 8:42 a.m.

Thanks Edgar!

Permanent link
Bob 3
(153●20●70) Jun 29 '17, 1:20 p.m.

@Erica Tran: I tried your approach using DNG 6.0.3 on a DNG artifact with lots of changes, and this is all I receive in the feed. Does this technique still work? If so, any idea what I did wrong?


<?xml version="1.0" encoding="utf-8"?><feed xmlns="http://www.w3.org/2005/Atom"> 
  <title>https://myurl.com:9443/rm/history</title>
  <id>urn:uuid:_opFpYFzuEeeoVevQThs3UQ</id>
  <updated>2017-06-29T17:16:05.750Z</updated>
   <link rel="self" href="https://myurl.com:9443/rm/history" type="application/atom+xml;type=feed"/>
  <generator>Jazz Resource Services</generator>
  <entry>
    <title>https://myurl.com:9443/rm/resources/CAV_8bafe9609d874b93a52c6551a17b0b13?revision=_2s1awFxbEeeGUdNHpU1MHg</title>
    <author><name>https://myurl.com:9443/jts/users/bp3</name></author>
    <summary/>
    <id>urn:uuid:_opFpYVzuEeeoVevQThs3UQ</id>
    <updated>2017-06-28T23:45:24.174Z</updated>
    <link rel="alternate" href="https://myurl.com:9443/rm/resources/CAV_8bafe9609d874b93a52c6551a17b0b13?revision=_2s1awFxbEeeGUdNHpU1MHg"/>
    <link rel="self" href="https://myurl.com:9443/rm/resources/CAV_8bafe9609d874b93a52c6551a17b0b13?revision=_2s1awFxbEeeGUdNHpU1MHg"/>
<content type="application/rdf+xml" src="https://myurl.com:9443/rm/resources/CAV_8bafe9609d874b93a52c6551a17b0b13?revision=_2s1awFxbEeeGUdNHpU1MHg"/>
  </entry>
</feed>

0 votes

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details

Question asked: Jan 26 '15, 1:34 p.m.

Question was seen: 4,204 times

Last updated: Jun 29 '17, 1:20 p.m.

Confirmation Cancel Confirm