Can anyone please tell me how I can get a list of users by project? I opened a support ticket with IBM and their best answer was... "you can't". This would help me tremendously as it takes me 3-4 hours to complile this list manually with Administrator... iterating through each project.
Thanks,
Tony
List Users by Project
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 483
- Joined: Thu Jun 12, 2003 4:47 pm
- Location: St. Louis, Missouri USA
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Their best answer is correct - you can't.
In versions prior to 8.0 you could report via the DS_LICENSE table, but that has now become the login and security service.
Similarly, prior to version 8.0 project roles for DataStage were stored in hidden files in the project (such as .operator.adm and .developer.adm) but, again, this information is now stored in the XMETA database.
Alas the structure of XMETA remains undocumented; you could experiment to see whether there are any tables in there that include ROLE in the table name, and investigate further from there.
In versions prior to 8.0 you could report via the DS_LICENSE table, but that has now become the login and security service.
Similarly, prior to version 8.0 project roles for DataStage were stored in hidden files in the project (such as .operator.adm and .developer.adm) but, again, this information is now stored in the XMETA database.
Alas the structure of XMETA remains undocumented; you could experiment to see whether there are any tables in there that include ROLE in the table name, and investigate further from there.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Out there... where, in la la land?PaulVL wrote:but it's out there.
Tony, I may have an answer for you soon.
Check this nearly-identical post from someone, much like yourself:
viewtopic.php?t=143900
Choose a job you love, and you will never have to work a day in your life. - Confucius
-
- Participant
- Posts: 437
- Joined: Fri Oct 21, 2005 10:00 pm
I believe what PaulVL is saying is that IBM highly discourages the direct access of xmeta. You can access it, but each fixpack or version upgrade may break any functionality that you've spent time and resources to build. There's a reason the xmeta model is not published. Access it at your own risk.
Keith Williams
keith@peacefieldinc.com
keith@peacefieldinc.com
You might take a look at xmeta table ASCLMODEL_USERB1C497CE (or like so)
On oracle:
I didn't figure out how to relate users to projects, because our naming convention takes the project in user name (user-project).
If it works on 8.1, I don't know for other versions.
Eric
On oracle:
Code: Select all
select table_name from all_tables where table_name like 'ASCLMODEL_USER%'
then
select PRINCIPALID_XMETA, LASTNAME_XMETA, FIRSTNAME_XMETA from ASCLMODEL_USERB1C497CE
If it works on 8.1, I don't know for other versions.
Eric
See this topic: viewtopic.php?t=154942
Choose a job you love, and you will never have to work a day in your life. - Confucius