JRS Adv SQL Query - Troubleshooting

Mahari Hill

(486●1●184●230) Apr 12 '18, 9:33 p.m.

CLM 602
Oracle 11.x

We need to create a SQL query to prevent starting back up Cognos to create this. We need, for a given project ID

Name, UserID, Email, (active/inactive)

Seems simple, and I think we need to access "the resource table" but not sure.

0 votes

1 answer

3,029 views

0 votes

One answer

Permanent link

Mahari Hill

(486●1●184●230) Apr 25 '18, 7:32 a.m.

I was able to obtain the information needed from support. I was not aware that there were views that could be used.

1 vote

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.

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

rational-team-concert

× 42,898

usage

× 12,019

troubleshooting

× 6,038

reporting

× 481

jrs

× 360

sql

× 37

Question asked: Apr 12 '18, 9:33 p.m.

Question was seen: 3,029 times

Last updated: Apr 25 '18, 7:32 a.m.

JRS Adv SQL Query - Troubleshooting

Mahari Hill

1 answer

3,029 views

0 votes

One answer

Mahari Hill

Your answer

Follow this question

Question details

Related questions