Products
Solutions
Support & Services
Company
How To Buy
Skip to main content (Press Enter).
Sign in
Skip auxiliary navigation (Press Enter).
Register
Skip main navigation (Press Enter).
Toggle navigation
Search Options
Home
Communities
All Communities
Enterprise Software
Mainframe Software
Symantec Enterprise
Blogs
All Blogs
Enterprise Software
Mainframe Software
Symantec Enterprise
Events
Enterprise Software
Mainframe Software
Symantec Enterprise
VMware
Water Cooler
Education
Groups
Enterprise Software
Mainframe Software
Symantec Enterprise
Clarity
Private Community
Community Home
Threads
Library
Events
Members
Back to discussions
Expand all
|
Collapse all
sort by most recent
sort by thread
Query to find OBS path of OBS unit rights for resources
Anon Anon
Nov 18, 2016 08:21 AM
Every resource have specific Global rights, Instance rights and OBS unit rights. I am looking to write ...
David Morton
Nov 18, 2016 08:43 AM
This old thread contains some SQL ; Reporting: How to get the OBS path of a resource.
1.
Query to find OBS path of OBS unit rights for resources
0
Recommend
Anon Anon
Posted Nov 18, 2016 08:21 AM
Reply
Reply Privately
Options Dropdown
Every resource have specific Global rights, Instance rights and OBS unit rights.
I am looking to write a query that specifies
which resource have OBS unit rights
and
that OBS unit rights belongs to which OBS path
. I have written up to the resources having OBS unit rights(Above letter in Italic) but still unsucessfull to find that OBS unit rights belongs to which OBS path(Above letter in bold).
SELECT CMNU.USER_NAME "USER_NAME",
CMNU.FULL_NAME "FULL_NAME",
'OBS' "RIGHTS_TYPE",
g.group_name "GROUP_NAME"
FROM NIKU.cmn_sec_groups_v g,
NIKU.cmn_sec_assgnd_right ar,
(select rownum,
cmn.id,
cmn.USER_NAME,
cmn.FIRST_NAME||' '||CMN.LAST_NAME "FULL_NAME"
from NIKU.cmn_sec_users cmn
where rownum <= 1000) CMNU
WHERE AR.principal_id = cmnu.id
AND g.language_code = 'en'
AND ar.right_id = g.id
AND (g.is_automatic != 1 OR g.is_automatic IS NULL)
AND g.right_type IS NOT NULL
AND g.is_active = 1
ORDER BY USER_NAME asc;
Any ideas or help would be appreciated.
Thanks
Nityananda#
2.
Re: Query to find OBS path of OBS unit rights for resources
0
Recommend
David Morton
Posted Nov 18, 2016 08:43 AM
Reply
Reply Privately
Options Dropdown
This old thread contains some SQL ;
Reporting: How to get the OBS path of a resource.
×
New Best Answer
This thread already has a best answer. Would you like to mark this message as the new best answer?
Skip Navigation Links
Footer
Copyright 2023. All rights reserved.
Powered by Higher Logic