Each Analysis Center user must have a unique, corresponding BusinessObjects user account/password with privileges to create ad-hoc reports and access BusinessObjects BI Launch Pad. select * from CI_APPOBJECTS where SI_ID =<<-->>, https://blogs.sap.com/2013/07/26/businessobjects-query-builder-whats-new-in-bi-40/. The following permissions must be set for designers to design and run reports in Analysis Center and run public Analysis Center reports, as well as run Crystal Reports from the Reports module: The following permissions must be set for users to run public Analysis Center reports, as well as run Crystal Reports from the Reports module: The following permissions must be set (in addition to the above) for users to import Crystal Reports templates in Suite Manager: When BusinessObjects reports are run from the Reports module in Suite and/or Analysis Center is accessed by multiple users, BusinessObjects concurrent usage licenses are used for each session. and includes a section listing Process Info (including the report's parameter names, etc). Experience of Agile culture and squad mentality. Job Description. This person will be responsible for the administration and support of multiple SAP BusinessObjects Enterprise . Change the path to the scripts folder and run Add-ADUsers.ps1 PowerShell script to bulk add AD users to group. Terms of use | The third command, Select-Object displayname of all ad users from . CI_SYSTEMOBJECTS: Contains objects that are often used by administrator, includes internal system objects, such as servers, events, and user groups. The name Paula Sanderson and the e-mail address of psanders@Acme.com would be associated with this account name. commencer nouveau travail pendant pravis As you can see below Figure the SAP BusinessObjects BI portfolio consists of three main categories: Discovery and Analysis. I just adjusted this. If I try to search for it, I get no results. The following permissions are not intended as a best practice for configuring users, but as a primer to creating a test user that can access and use Analysis Center quickly: This section describes the minimum permissions to be configured when integrating Suite with SAP BusinessObjects Business Intelligence Platform 4.2 SP7. https://wiki.scn.sap.com/wiki/display/BOBJ/Unlock+the+CMS+database+with+new+data+access+driver+for+BI+4.2+SP3. SAP Knowledge Base Article - Preview. There is no keyword to remove duplicate in CMS query syntax, since by design CMS cannot return an infoobject more than once for a query. What is the variable to use to select users whose accounts have been disabled (Disabled option checked) ? In the Join Group: username dialog box, add the new user group to the Destination Group list We offer highly responsive customized as well as pre-packaged SAP Business Objects users mailing list that helps you target the right audience. The set of methods associated with a business object represents the object's behavior. If no errors in formatting are found, the, button is enabled. How to delete bulk users in BusinessObjects Enterprise from a text file using Java SDK? Hi All, I am searching for the scripts which gives details about Last access date of universe Universes and last date access of Webi reports and Related universe name.I trying to achieve my requirement through Excel Macro(scripts) not with Query Builder.Could you help in this? I believe that SAP allows the data access via webservices. You can join them in the cycle without querying the groups again. Copyright | since this script has been written for testing purpose only, ************ USE THIS SCRIPT AT YOUR OWN RISK ************, Set oSessionMgr = CreateObject(CrystalEnterprise.SessionMgr), Set oEnterpriseSession = oSessionMgr.Logon(UserId, Pwd, CMS, Auth), Set oInfoStore = oEnterpriseSession.Service(,InfoStore), strXlsFileName = c:\BusinessObjects Users.xls, Set objExcel = CreateObject(Excel.Application), Set objWorkbook = objExcel.Workbooks.Add(), Set objSheet = objExcel.ActiveWorkbook.Worksheets(1), Set listOfGroups = oInfoStore.Query(SELECT TOP 100000 * FROM CI_SYSTEMOBJECTS WHERE SI_KIND=UserGroup'), Set oInfoObjects = oInfoStore.Query(SELECT TOP 100000 * FROM CI_SYSTEMOBJECTS WHERE SI_KIND=User'), We will start writing user alias data from row 2 in MS Excel file, Set user = oInfoObjects.Item(iterator).PluginInterface(), objSheet.Cells(intRow, 1).Value = user.title, Set groups = oInfoStore.Query(SELECT SI_NAME FROM CI_SYSTEMOBJECTS &_, WHERE SI_KIND=UserGroup AND SI_ID IN & clause), Write group names for the user to the MS Excel row, If groups.item(i).title = listOfGroups.item(j).title Then, objSheet.Cells(intRow, j+1).Value = groups.item(i).title, For intColumn = 1 to listOfGroups.Count+1. Click the Actions menu, and select Join Group. SELECT Top 2000 * FROM CI_INFOOBJECTS where Si_KIND='WebI'. . The second command uses the Get-ADUser cmdlet to get ad users from a list of ad users and returns the display name. When SiteMinder is enabled and Analysis Center is launched, Suite looks for the SMSESSION cookie and obtains the value associated with that cookie name. but this SQL (which worked fine with BO3.x)fails miserably with a "Not a valid query." Minimising the environmental effects of my dyson brain, About an argument in Famine, Affluence and Morality. Community News; Get Started; Introduce Yourself . How to show that an expression of a finite type must be one of the finitely many possible values? Published on www.kitjob.in 06 Feb 2023. BusinessObjects Enterprise Java SDK Feature Samples. gvIsAdmin) and set the value (true/false) by checking if the current user is listed in colAdminUsers. I am executing the below query but separately.But not sure how to find the relation between the user and the user group. Money no object when you want the best in the business is RCB's watchword It won an intense bidding war with Mumbai Indians to pick Smriti; added overseas stars Perry, Schutt and Devine along . Privacy | SELECT SI_ID, SI_NAME, SI_SCHEDULEINFO.SI_SCHEDULE_TYPE, SI_SCHEDULEINFO.SI_SCHEDULE_INTERVAL_NDAYS, SI_SCHEDULEINFO. Mitratech recommends creating user groups for which the permissions can be configured and users assigned to the groups. On the Central Management Console, select Users and Groups from the CMC Home menu. Managing BO environment in a large enterprise is one of biggest challenge for System Administrators. ). The Suite/BusinessObjects integration supports SiteMinder with LDAP (Lightweight Directory Access Protocol). When a method is executed on a business object, the method can change the object's internal state, that is, the object's data. But when a NON-Administrator runs the same query in Query Builder only the Users that are designated as Administrators and the User that runs the query are returned. In addition, each user who will run Analysis Center reports published to the Reports module must have a BusinessObjects user account/password. Open the copy of the file with a text editor such as Microsoft Notepad. Change the value to 10. Retrieve a list of user objects.. I am able to run this query successfully. The category Discovery and Analysis is about providing your business users the tools which they need to leverage the information, analyze the data, finding outliers and trends, and use from . S. It seems that this GPO are deleted or created but not replicated to other domain controller. The following changes need to be applied using the Central Management Console on the BusinessObjects server: To modify the BIlaunchpad.properties file: To create a backup of the custom configuration, store a copy of all the custom configuration files in a separate location or network drive. Type: Contract. Currently, Petal Search offers services to users from over 170 countries and regions, supports more than 70 languages, and complies with the local General Data Protection Regulation (GDPR) standard. User groups; Info Center. Right-click on the Server Intelligence Agent, click, Installing BusinessObjects Business Intelligence Platform 4.2, Configuring Minimum Permissions for Named Accounts, Configuring Permissions for Report Template Import, To Change Values in the Central Management Console, To Deploy the Web Applications (war files), Import groups/users with a Comma Separated Value (CSV) file, Assign the group the appropriate rights and privileges. Press and hold the <Ctrl> key and then click the user names to add to a group. Dashboards and Apps. Location: India, Chennai. Visit SAP Support Portal's SAP Notes and KBA Search. Trademark, SAP BusinessObjects Business Intelligence platform 4.1 ; SAP BusinessObjects Business Intelligence platform 4.2 ; SAP BusinessObjects Business Intelligence platform 4.3, BI, 4.1, 4.2, 4.3, Excel, xlsx, xls, all folders, rights, list out, display, access level, view, user groups, java SDK, java code. E.g. The following user groups help maintain the security rights and privileges for the types of users who have accounts in BusinessObjects: For Suite Analysis Center users, each user account in Suite must be associated with a unique BusinessObjects user account/password. Find centralized, trusted content and collaborate around the technologies you use most. The imported user accounts are disabled by default. Symptom. For example, one method that you can use on business object Employee is to "check for the employee's existence". ; Click View Business Objects. Contains JSP sample code pages that highlight features of the BusinessObjects Enterprise SDK, including authentication, scheduling, publishing, server . who had been write external web url. Making statements based on opinion; back them up with references or personal experience. SAP BusinessObjects Business Intelligence platform 4.0 ; SAP BusinessObjects Business Intelligence platform 4.1 ; SAP BusinessObjects Business Intelligence platform 4.2 ; SAP BusinessObjects Enterprise XI 3.1 . The only way to do something like this at this time is to create a list with the admin users. SAP Knowledge Base Article - Preview . By clicking Post Your Answer, you agree to our terms of service, privacy policy and cookie policy. Replacing broken pins/legs on a DIP IC package. colAdminUsers) and create a variable (e.g. How do I get a list of Parameter Names, and their Types (string or numeric) using SQL ? The Hackett Group, a leading global strategy and operations consulting firm, helps clients generate more value from their Oracle applications through business advisory consulting, world-class implementations, and post go live support. If the conflicting accounts are identical to . Can you suggest a query to get the successful instance countwithin specific folder and for specific date. Query for users: Is it possible to list users who have refresh and save the report in Favorite Folders?. What video game is Charlie playing in Poker Face S01E07? Please don't forget to mark the correct answer, to help others who have the same issue. Optionally, type a freeform comment to describe the user. # Export a list of all Windows Apps. Can anyone please help me with the query that i should execute in Query builder to get the user and the group. SAP BusinessObjects Business Intelligence platform 4.3 Keywords. Reporting. car accident fort smith, ar today; what is the avery code for labels? Dynamics 365 Business Central 2023 Wave (v22) release introduces a new Analyze view mode in list pages directly on browser. BI, 4.1, 4.2, 4.3, Excel, xlsx, xls, all folders, rights, list out, display . With more options still available in the Audit DB like this, we have to deep dive in to get more things out of the Audit Universe which can really reduce work of BO Admin. Devise or modify procedures to solve complex problems considering business and/or system limitations, operating time, and form . Yes. Optionally, type a freeform comment to describe the purpose of the group. Why is this the case? Job Description. In order for the integration to work properly, you must also configure SSO with the Suite server prior to configuring the integration in Suite Manager. Click your name at the bottom of the sidebar, click Preferences , then click Directory Sync . Click the right arrow button to assign the users to the selected group. I know that we can easily fetch these details from Query builder, but having these details in a webi report will be very handy for auditing purpose. If you haven't changed the default query timeout limit (of nine minutes), then that's probably the cause of your errors. SELECT * FROM CI_SYSTEMOBJECTS WHERE SI_ID=4, To get BO File Repository Server Information, WHERE SI_KIND = SERVER AND SI_NAME LIKE %FILEREPOSITORY%, To get the all the public folders (Non System Folders), WHERE SI_PARENTID=23 AND SI_NAME!=REPORT CONVERSION TOOL AND, SI_NAME!= ADMINISTRATION TOOLS AND SI_NAME!= AUDITOR, To list all the WebI reports with prompts. Your best bet might be SCN (scn.sap.com). 2965905-How to get a list of Subgroups and Users for a particular Group with the BI platform CMS sample universe. It will recursively scans through all the groups and its subgroups to print the number users and subgroups inside each. Primary Job Purpose. Under Google Workspace Sync section, carefully read the Account Conflict message, then click Resolve. This CAL is then applied to the group, with the group as the principal. One of the following permissions is required to call this API. Thanks for contributing an answer to Stack Overflow! link in the left pane to list all users in the right pane. list, retrieve, all, users, in, group, how, to, query, builder biqb boxi bi bip 3.1 3 . Mitratech includes configuration to use a single account from which to run Crystal Reports from the Reports module or to specify individual accounts to run Crystal Reports from within the eCounsel/Secretariat user preferences. To modify group properties, select group Manage Properties. The user name psanders would be member of the group AC_Users and would be assigned the profile Manager with the profile value of West Region. operational data models. Does anyone have any input on this behavior, as we would like to have Non-Administrators Run some of these Reports. Wait until the service completely stops. CI_APPOBJECTS: Contains objects that represent Business Objects Enterprise applications, such as universe, universe folder. This can be viewed in the screen given below . SAP BusinessObjects - Known Issues & FAQs. But it is throwing errors. pneu abim sur le flanc contrle technique. Site design / logo 2023 Stack Exchange Inc; user contributions licensed under CC BY-SA. This is time and server resource consuming process. Alerting is not available for unauthorized users. business objects list users in group keyt news anchor missing June 10, 2022. carnation company website 7:32 am 7:32 am error. And we are finding the same issue when running a Report using the data Access driver that when an Administrator Runs a Report All users are returned as expected, and when a NON-Administrator runs the same Report only the Users that are designated as Administrators and the User runs the report are returned in the report. Go through each members property, and emit any members that are in the groups hash table Are you asking if you can retrieve the SQL of WebI reports? 1: In order to run this script on a windows platform, you need to have Microsoft Excel and BusinessObjects Client Tools installed on that box. As Barclays Product Control Manager, you will take full ownership of IPV cycle for FX and some risk products including FX Vol, FX correlation, Interest Rate Swaps, Swaptions, Cross Currency Swaps, STIRTS. Note : The user has to be logged into the system at leastonce. Is this an SAP Business Objects question or an SAP Business One question? SI_PROCESSINFO.SI_WEBI_PROMPTS, SI_PROCESSINFO.SI_FILES, SI_PROCESSINFO.SI_PROMPTS FROM CI_INFOOBJECTS, WHERE SI_KIND = WEBI and SI_INSTANCE = 0 and, To extract all the report names from specific folder, SELECT SI_ID,SI_NAME,SI_PARENT_FOLDER,SI_FILES, FROM CI_INFOOBJECTS WHERE SI_KIND = WEBI AND SI_INSTANCE = 0 AND SI_ANCESTOR = [SI_ID OF THE FOLDER], To get Reports those are spanning multiple universes, SELECT SI_ID, SI_KIND, SI_NAME FROM CI_INFOOBJECTS WHERE SI_UNIVERSE.SI_TOTAL>1, To list all the events and corresponding event file location, SELECT SI_ID, SI_NAME, SI_FEATURES FROM CI_SYSTEMOBJECTS WHERE SI_KIND= Event, To list all Scheduled reports based on event, SELECT SI_NAME, SI_SCHEDULEINFO FROM CI_INFOOBJECTS, WHERE SI_RUNNABLE_OBJECT = 1 AND SI_SCHEDULEINFO.SI_DEPENDENCIES.SI_TOTAL > 0, SELECT SI_NAME, SI_OWNER, SI_AUTHOR, SI_SCHEDULEINFO, SI_PARENT_FOLDER FROM CI_INFOOBJECTS WHERE SI_KIND = WEBI AND SI_CHILDREN = 0 AND SI_SCHEDULEINFO.SI_SCHED_NOW = 0, To get the list of all reports scheduled daily excluding Paused. Managing and supervising Process CAD/BIM staff across Canada. For your requirement, auditing will also have record s of the associations in between the user-usergroup from the past, that doesnt exist anymore. I noticed this behavior when you use this in Mac. The correct way is to get this detail from CMS DB. Location: Houston, TX. --EXEC MASTER..XP_CMDSHELL 'dsquery group -name "Group_Name" | dsget group -members -expand -c | dsget user -samid -c'. I am having the same question, Can you recommend a tool or a way to get the report's query. If there is a change in the user group for a user, then the change will get updated in the DB once the user logs into BO again and we will be having the . Now, from BO 4.2 SP 5 onward, we can fetch the users list along with their associated user groups from Audit Universe also. Enjoy unlimited access on 5500+ Hand Picked Quality Video Courses. Not the answer you're looking for? Find Windows Appx Package names using PowerShell. How could I got a list of users with their actual assigned groups correctly? . How to prove that the supernatural or paranormal doesn't exist? Trademark, SAP BusinessObjects Business Intelligence platform 4.0 ; SAP BusinessObjects Business Intelligence platform 4.1 ; SAP BusinessObjects Business Intelligence platform 4.2 ; SAP BusinessObjects Enterprise XI 3.1. # Get Windows App where the name contains music. I can not find the table that contains the groups. The Project Information and Innovation Management (PIIM) team will include an Insights and Analytics team responsible for aggregating and analyzing project data, developing automated reporting processes and client-required reports, maintaining high quality and insightful analytics, and assisting with the managing records across the project. Create the AzureAD group. Please see the following links that I think will solve your issue: BusinessObjects Query builder queries | SAP Blogs, BusinessObjects Query builder queries Part II | SAP Blogs, Query Builder - Business Intelligence (BusinessObjects) - SCN Wiki, How To Fetch User Group Details From SAP Business Intelligence/Objects 4.1/4.2 Servers. xp_logininfo 'MyDomain\WindowsGroupName', members. This directory name will be specified in Suite Manager when configuring the BusinessObjects integration for Suite. These licenses are released based on the timeout values specified for the BusinessObjects server and the Java application server used by BusinessObjects for BI Launch Pad. Have sampel auditing report but wonder if quick/easy way from CMC? Is there a BO4 version of these SQL examples ? tHANJKS Skip to Content How can I get the list of users and groups of Central Management Console, Re: How can I get the list of users and groups of Central Management Console. 11 positions QA Automation Test Lead (Must have Lead experience), H1 OK Atlanta (JOBID: PRA1004), 10/4/12. SELECT SI_ID, SI_KIND, SI_NAME, SI_PROCESSINFO.SI_HAS_PROMPTS. You already have the user and user group infoobjects. SiteMinder authenticates with Suite during initial login. I want to extract the user security information of a folder or an universe to find out the parent level user rights which has rights to access it. Now that gvIsAdmin is set you can use . Mitratech partners with you to deliver success, empowering clients so they can focus on delivering innovation and excellence in legal and compliance. If a SSO other than SiteMinder is used, the cookie does not exist and Suite cannot obtain the value that it needs to continue its authentication process. what i am asking, one of our developer had used "image from address" in Appearance option in format cell. I recommend you to delete it and recreate it again after checking the status of SYSVOL replication between all domain controllers in the domain. $56 Hourly. Please suggest me. Contains objects that are often used by users, such as folders and reports. To subscribe to this RSS feed, copy and paste this URL into your RSS reader. SAP BusinessObjects Administrator will serve as an important member of LabCorp's Analytics team and will be focused on supporting Tier 1 Business Intelligence (BI) server administration. Is the table correct? user 01ABCDE has 5 assigned user groups but return list displays 19(!) Creating a Root BusinessObjects Directory, dialog box, type the name for the folder, and click. And Last but not the least, if you are planning to run it in a production environment and if you have a lot of Users and Groups in your environment, you might want to run it in a non-load time to avoid any unnecessary load on the CMS. Some of the Query builder queries to explore the BusinessObjects repository. The term "Broadcom" refers to Broadcom Inc. and/or its subsidiaries. Learn more, Members of this group can perform all task in all of the BI platform applications(CMC, CCM, Publishing Wizard, and BI launch pad). Follow Up: struct sockaddr storage initialization by network format-string, Is there a solutiuon to add special characters from software and how to do it. As the on-premise BI layer for SAP's Business Technology Platform, it transforms data into useful insights, available anytime, anywhere. Please suggest me. \SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.2\wdeploy\conf. Note: This request might have replication delays for users that were recently created, updated, or deleted. I dont believe there is any type of export button there. list, retrieve, all, users, in, group, how, to, query, builder biqb boxi bi bip 3.1 3.x 4.2 4.1 4.0 4.x subgroup , KBA , BI-BIP-ADM , BI Servers, security, Crystal Reports in Launchpad , BI-BIP-QB , Query Builder , Problem. Very nice blog and you have explained everything on query builder. You should go with SI_PARENTID instead if you are interested only in documents. To extract all the users from specific user group. dialog box, click a user name in the Available users/groups list, click the right- arrow button, and click, dialog box, click on a user name in the Available users/groups list, click the right- arrow button, and click, dialog box, click on the name of the group of designers in the Available users/groups list, click the right-arrow button, and click. SAP BusinessObjects Business Intelligence platform 4.2 Keywords. for more information concerning security. Each field must have separator between it and the next field. How to display the list of user groups, the folders they have access to and the associate access levels? meilleures sries 2020 inrocks. GetByKey() not working in some users in SAP B1, SAP B1 Choose from list employee but show name instead of code, Bulk update symbol size units from mm to map units in rule-based symbology. If there is a change in the user group for a user, then the change will get updated in the DB once the user logs into BO again and we will be having the updated Users list in the Webi report. This will work well for all groups with less than 1500 members. You may be able to do it by writing a query Hello Thanks for answer I found the table that contains the users. | SAP Blogs . How to find a list of all User Security principals (users/user groups) for each folder in a SAP BusinesObject 3.1 envirnoment 0 Data Access in BusinessObjects through Active Directory Groups If you are an SAP BusinessObjects BI Platform Administrator and looking to find out Empty Groups, or List Sub Groups and Users inside groups, following are the queries which will help in that aspect. Can you please let me know what might have gone wrong? by | Jun 10, 2022 | tropico 6 dlc, festival | haiti harrison death 2015 | Jun 10, 2022 | tropico 6 dlc, festival | haiti harrison death 2015 Hi Bsharper, If your AD group is mapped to the server then you able to see all the users belong to the group by running the command. Participate in staff's business goals and career development discussions. Can you please let me know what might have gone wrong? 4: Copy this highlighted content in a text file and rename it to UserGroupList.vbs and run it (right click >> Open) from the box as per prerequisites mentioned in. I'm not sure about 4.0, but I've done this in XI3 and BI4.1. If you have a limited number of concurrent usage licenses, changing the timeout values can release licenses sooner than the default of 60 minutes. The script will go through all the users in the CSV file. -Use your Administrator credentials to log in here. SELECT SI_ID, SI_NAME, SI_KIND, SI_USERGROUPS FROM CI_SYSTEMOBJECTS WHERE DESCENDANTS("SI_NAME='USERGROUP-USER'", "SI_NAME='ADMINISTRATORS'") Hope the above queries might be useful to those who start digging in to Business Objects repository. I can get the number of Data. How To Fetch User Group Details From SAP Business Intelligence/Objects 4.1/4.2 Servers. In the application, on the home page, click My Client Groups > Data Exchange. Hi, I created a report in BO XI in which 2 of the columns represent customers and orders of customers. In BusinessObjects Enterprise XI 3.1, it was possible to create Enterprise groups and user accounts by importing a TXT file via the Import Wizard. This vbs script was given to me by a senior colleague. Is it possible to find embedded image properties in webi report with admin query. The File Name column displays the name of the file you must use when supplying data for that object. Hello, unfortunatly the list returns multiple assignments of user-usergroup although user does not have to much assigned groups. It's included in RSAT and Server 2008/2012. We are finding that when an Administrator logs in and uses the Query Builder mentioned in this post All users are returned as expected.. I'm trying to apply an app protection policy to all my users (no exceptions), but no "All Users" group appears in my list of choices. Currently, we are having 1K report on LaunchPad, and Need a tool that accepts the table's name. How to avoid duplicate records ? Division: ASSA ABLOY Global Solutions. Could you please help to find out that info using query builder or cms database. We make use of First and third party cookies to improve our user experience. How to get list of groups user belongs to . Some of the Query builder queries to explore the BusinessObjects repository. Alerting is not available for unauthorized users, Right click and copy the link to share this comment, 4: Copy this highlighted content in a text file and rename it to. To learn more, including how to choose permissions, see Permissions. but you can see AD group users. Group by business objects Posted by previous_toolbox_user 2009-10-13T11:54:00Z. Wait until the service completely stops. The airspace over a St Petersburg airport was temporarily closed on Tuesday morning amid unconfirmed reports that an . The strategy released serves as a blueprint for a connected and accessible dirt trail network for Tahoe. Members of this group have access to the Translation Manager application. Need format changes to the expected output excel and additional field values (Last Logon time). By default, the, Members of this group have access to Query as a Web Service. When SiteMinder is enabled and a user logs in, Suite calls upon an external SiteMinder agent that validates the user, creates a cookie named SMSESSION, and returns that cookie back to the Suite application. How to access Users and Groups data from SAP BO 4.1, https://blogs.sap.com/2016/02/08/use-microsoft-powershell-to-manage-your-bi-platform/, How Intuit democratizes AI development across teams through reusability. Hi, What is best way to get list of groups and users in those groups? . SI_SCHEDULE_INTERVAL_MONTHS, WHERE SI_SCHEDULE_STATUS !=8 AND SI_RECURRING = 1, To get the list of reports scheduled by a particular user, WHERE SI_OWNER = AND SI_RECURRING = 1, SELECT SI_NAME, SI_WEBI FROM CI_APPOBJECTS, WHERE SI_KIND=Universe AND SI_WEBI.SI_TOTAL > 0, To retrieve all Web Intelligence reports connected to a Universe, SELECT * FROM CI_INFOOBJECTS, CI_SYSTEMOBJECTS, CI_APPOBJECTS WHERE PARENTS(SI_NAME=WEBI-UNIVERSE',SI_NAME =EFASHION), To Show all universes using a specific connection, SELECT SI_ID, SI_NAME, SI_OWNER FROM CI_APPOBJECTS, WHERE CHILDREN(SI_NAME=DATACONNECTION-UNIVERSE , SI_NAME=TEST'), To list all Webi reports that uses the connection (multiple universes), SELECT * FROM CI_APPOBJECTS, CI_INFOOBJECTS WHERE PARENTS(SI_NAME=WEBI-UNIVERSE', CHILDREN(SI_NAME=DATACONNECTION-UNIVERSE , SI_NAME=TEST )) AND SI_KIND=WEBI, SELECT SI_NAME,SI_GROUP_MEMBERS FROM CI_SYSTEMOBJECTS, WHERE SI_KIND = USERGROUP AND SI_NAME=ADMINISTRATORS, To extract all the users from specific user group, SELECT SI_ID, SI_NAME, SI_KIND, SI_USERGROUPS FROM CI_SYSTEMOBJECTS WHERE DESCENDANTS(SI_NAME=USERGROUP-USER', SI_NAME=ADMINISTRATORS'). nkotb tour dates 1989, community fibre cgnat, norse deities associated with spiders,