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

Report of all the assets with a particular submitter

We need to pull a report of all the assets with a particular submitter(not owner). Is there any way to get such a report(probably by querying the database)?

0 votes



3 answers

Permanent link
Hi,

What is your definition of submitter:

a) The person who originally submitted the asset, and thereby created
it. This would be the original owner. The ownership may of been changed
since the original submission.

b) The people who have "submitted" updates to the asset since the
creation (original submission) of the asset, including just changing states.

c) The last person who "submitted" an update to the asset or changed the
state of the asset.

--
Rich Kulp
Rational Asset Manager developer

0 votes


Permanent link
Using the search input field, you can search for assets from a submitter using:
{_submitter_:(USER NAME)

For instance, searching for assets I have submitted:
{_submitter_:(Matthew J. Vestal)


You can then use the search shortcut to use the reporting URLs to get the asset data:
/reporting/asset:shortcut=ramSearch:(1txt%2C{_submitter_%3A(Matthew+J.+Vestal))

0 votes


Permanent link
Matt,

To be clear, the definition of "submitter" that you are using here is
someone who submitted OR updated an asset? Or is it just the original
submission?

--
Rich Kulp
Rational Asset Manager developer

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.

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: Nov 03 '10, 1:19 p.m.

Question was seen: 6,698 times

Last updated: Nov 03 '10, 1:19 p.m.

Confirmation Cancel Confirm