It's all about the answers!

Ask a question

JRS Adv SQL Query - Troubleshooting


Mahari Hill (4861167230) | asked 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.

One answer



permanent link
Mahari Hill (4861167230) | answered 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.

Your answer


Register or 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.