How to get list of groups user belongs to . Hello Manikandan, I work in Dallas and I thank you for writing this blog post. Open the copy of the file with a text editor such as Microsoft Notepad. Right-click the Apache Tomcat for BI 4 and click. is it possible to query the comments solution table to get the context which was using for each front end tool to apply the comment ? Check this video to start understand Business Objects Admin-~-~~-~~~-~~-~-Please watch: "Power BI Bookmark & Selection Pane Features | PBI Desktop" https://w. Terms of use | 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. 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'). BI, 4.1, 4.2, 4.3, Excel, xlsx, xls, all folders, rights, list out, display . See, Right-click the Suite database alias folder, and select, Expand the Bridgeway folder, right-click on the database alias folder, and select, Expand the database alias folder, right-click on the Analysis Center folder, and select, Expand the Analysis Center folder, right-click on a user folder, and select, Expand the user folder, right-click on the eCounsel (or Secretariat) folder, and select, In the Analysis Center folder, right-click on the Shared Reports folder, and select, Expand the Shared Reports folder, right-click on the eCounsel (or Secretariat) folder, and select, Right-click on the Bridgeway folder, and select, Expand the Shared Reports folder, right-click the eCounsel (or Secretariat) folder, and select, In the Servers List, right-click the Connection Server and select, For each of the following servers, right-click the server, select, Copyright 2023 Mitratech Success Center. Is it possible to list users who have refresh and save the report in Favorite Folders?. By using this website, you agree with our Cookies Policy. SAP BusinessObjects Business Intelligence platform 4.2 ; SAP BusinessObjects Business Intelligence platform 4.3 Keywords. 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. Each field can be blank except for the first two fields. The View Business Objects table displays all the business objects supported by HCM Data Loader.. meilleures sries 2020 inrocks. You can use one of the following methods to add users and groups in the Central Management Console: The BusinessObjects Central Management Console contains tools that allow you to create a root folder that can be used to store all Suite reports and Analysis Center reports. To list the top level Groups, which are at the root level in Group Hierarchy: To list the Groups where there are no users and no subgroups, use the following query: To list the Groups where there are no subgroups, use the following query: To list the Groups where there are no users, use the following query: And here is JAVA SDK code sample, which you can refer and fine tune according to your needs. 11 positions QA Automation Test Lead (Must have Lead experience), H1 OK Atlanta (JOBID: PRA1004), 10/4/12. I am executing the below query but separately.But not sure how to find the relation between the user and the user group. Dear All, I need the list of BO users and the User Groups to which the users are part of. The script will go through all the users in the CSV file. Thanks for contributing an answer to Stack Overflow! This can be viewed in the screen given below . Terms of use | Mitratech partners with you to deliver success, empowering clients so they can focus on delivering innovation and excellence in legal and compliance. Full-Time. As you can see below Figure the SAP BusinessObjects BI portfolio consists of three main categories: Discovery and Analysis. you may use KB 2369779 How to unlock the CMS database with new data access driver for BI 4.2 SP3 [VIDEO]. If you have a limited number of concurrent usage licenses, changing the timeout values can release licenses sooner than the default of 60 minutes. We make use of First and third party cookies to improve our user experience. Hi, For 1 of my requirement, this query is very useful. SI_SCHEDULE_INTERVAL_NTHDAY, SI_SCHEDULEINFO. I don't know if you're going to get a lot of help on here. xp_logininfo 'MyDomain\WindowsGroupName', members. Can anyone please help me with the query that i should execute in Query builder to get the user and the group. Experience of Agile culture and squad mentality. After troops ran out of the cookie flavor within hours of their debut, the online-only exclusive cookies started selling for upwards of $100 on eBay as resellers sought a profit from overwhelming . WHERE SI_KIND = WEBI AND SI_INSTANCE = 0 AND SI_ANCESTOR = [SI_ID OF THE FOLDER]. 2965905-How to get a list of Subgroups and Users for a particular Group with the BI platform CMS sample universe. SELECT SI_ID, SI_NAME, SI_SCHEDULEINFO.SI_SCHEDULE_TYPE, SI_SCHEDULEINFO.SI_SCHEDULE_INTERVAL_NDAYS, SI_SCHEDULEINFO. the default limit for returning objects would be 1000 objects normally. Yes. Visit SAP Support Portal's SAP Notes and KBA Search. 3: In case you do not have write access on C: Drive, change the path of the output excel file to the location where your User credential has access on that box. This will be handy for those who searching for Query Builder Queries. https://wiki.scn.sap.com/wiki/display/BOBJ/Unlock+the+CMS+database+with+new+data+access+driver+for+BI+4.2+SP3. 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. Navigate to Azure Active Directory (aad.portal.azure.com) and select 'Groups'. In the application, on the home page, click My Client Groups > Data Exchange. How to List User Groups For a specific user From Query Builder? Use -ldapfilter (objectCategory=group) (best filter article). How to export the user list with the below information to excel file using Java SDK : ID User name User fullname Email address Last logon Creation date User group Last update time Aliases Enabled / Disabled . 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. Can you please let me know what might have gone wrong? Change the path to the scripts folder and run Add-ADUsers.ps1 PowerShell script to bulk add AD users to group. 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. Are you asking if you can retrieve the SQL of WebI reports? 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 . Need format changes to the expected output excel and additional field values (Last Logon time). This will be handy for those who searching for Query Builder Queries. 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. Hi Ram, You can use the following command to list out all the users from an AD group. Note : The user has to be logged into the system at leastonce. Is it possible to query reports utilizing a specific element from a specific universe? operational data models. One record can define either a group, user, or user profile. -Run the following query to get a list of all Groups: SELECT SI_NAME FROM CI_SYSTEMOBJECTS WHERE SI_KIND = 'USERGROUP', I want to share the final result that I received thanks to his advice. GO. . Why is this the case? 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. link in the left pane to list all users in the right pane. Please suggest me. 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. On the BI platform, there is a REST API for this kind of operations, It is well documented in their own documentation, but you could also for a starter, take a look at my blog post her https://blogs.sap.com/2016/02/08/use-microsoft-powershell-to-manage-your-bi-platform/ and check out the example I've made in GitHub https://github.com/Verakso/BO-PowerShell. 2: You will need to change CMS name, port and Administrator password. To modify group properties, select group Manage Properties. Staging Ground Beta 1 Recap, and Reviewers needed for Beta 2, Sync Data between SAP and DataModels in Django, How to find a list of all User Security principals (users/user groups) for each folder in a SAP BusinesObject 3.1 envirnoment, Data Access in BusinessObjects through Active Directory Groups, pull and update data to SAP business one using PHP. By the way, it would be better to specify another filter on an indexed column (like SI_NAME, SI_KIND, SI_CREATION_TIME ) to avoid unnecessary work by CMS. Query Builder - Business Intelligence (BusinessObjects) - SCN Wiki . Is there a BO4 version of these SQL examples ? Prepare the text file for import as follows: The format for a user record is as follows: Profile values must be enclosed in quotation marks. According to this doc, Intune comes with "pre-created" All Users and All Devices groups to which I can assign policies and apps. Your assistance is much appreciated. On BO 4, I find that the following SQL runs fine. It will recursively scans through all the groups and its subgroups to print the number users and subgroups inside each. Overview | Guided Tour . 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. 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. it was not working for me as well, but just corrected some formatting like single codes, semi colon, equalto sign, etc and then it worked. CI_APPOBJECTS: Contains objects that represent Business Objects Enterprise applications, such as universe, universe folder. Reviewing Supported Objects. Please suggest me. business objects list users in group keyt news anchor missing June 10, 2022. carnation company website 7:32 am 7:32 am , and wait until the status changes to Running. Currently, we are having 1K report on LaunchPad, and Need a tool that accepts the table's name. Russian media reports say unidenified object was spotted near Pulkovo Airport. . But it is throwing errors. End users and data analysts can analyze data from list pages directly in the client without the need to open the page in Excel or run a report. The name Paula Sanderson and the e-mail address of psanders@Acme.com would be associated with this account name. Can you suggest a query to get the successful instance countwithin specific folder and for specific date. That is not the actual situation! Your best bet might be SCN (scn.sap.com). How to handle a hobby that makes income in US. Position Title: SAP Security Engineer. Design and Develop SAP BI Universes (BI 4.3 SP1) using . Community News; Get Started; Introduce Yourself . | SAP Blogs . To list the Groups where there are no users and no subgroups, use the following query: Find centralized, trusted content and collaborate around the technologies you use most. 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 . Where can I get the list of services that allows me to access the 'users and groups' ? Click your name at the bottom of the sidebar, click Preferences , then click Directory Sync . 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. Affordable solution to train a team and make them project ready. I am trying to find the right SQL to return the SI_User field contents from the SI_Prompts of Crystal Reports. Hope the above queries might be useful to those who start digging in to Business Objects repository. I tried your query, "To extract all the report names from specific folder". I recommend you to delete it and recreate it again after checking the status of SYSVOL replication between all domain controllers in the domain. Title: SAP Business Objects. BusinessObjects User Group Meetings. but this SQL (which worked fine with BO3.x)fails miserably with a "Not a valid query." Managing and supervising Process CAD/BIM staff across Canada. This thread already has a best answer. The information below is intended to describe the minimal permissions needed for a user to begin working with Analysis Center. SELECT Top 2000 * FROM CI_INFOOBJECTS where Si_KIND='WebI'. Get-AppxPackage -Name "*music*". colAdminUsers) and create a variable (e.g. Privacy | On the Central Management Console, select Users and Groups from the CMC Home menu. Press and hold the key and then click the user names to add to a group. I just adjusted this. Either way you could export the list and pull the file path in for the script to refer against, though you may want to avoid that altogether. Optionally, type a freeform comment to describe the purpose of the group. SAP BusinessObjects Business Intelligence platform 4.3 Keywords. S. It seems that this GPO are deleted or created but not replicated to other domain controller. 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. Enjoy unlimited access on 5500+ Hand Picked Quality Video Courses. The third command, Select-Object displayname of all ad users from . I can not find the table that contains the groups. how to get the Data security profile name from AdminTools query. Connect and share knowledge within a single location that is structured and easy to search. Group Objects can also be used to organize similar types of Business Objects. Formulate and define business and/or systems scope and objectives based on both user needs and a good understanding of applicable industry requirements. You can accomplish this by accessing the Query Builder on your CABI Server: http://localhost:port/AdminTools/querybuilder/query.jsp. Legal Disclosure | I can get the number of Data. The correct way is to get this detail from CMS DB. When you need to assign same permissions to set of users, groups can be created, and users can be added to provide similar permissions. Could you please help to find out that info using query builder or cms database. Basics So, this will be captured as an event and the user & their associated user groups detail will get recorded in the Auditing DB. Primary Job Purpose. SiteMinder authenticates with Suite during initial login. Coordinate with other Team Leads, Project Managers and North American Discipline Lead to manage your team's weekly workload. How could I got a list of users with their actual assigned groups correctly? 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 . Once new group is created, you can add users, subgroups, and assign group memberships. Part IV covers entities, domains, attributes, key groups, validation rules, default rules, and subject areas, along . Need format changes to the expected output excel and additional field values (Last Logon time). 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. You already have the user and user group infoobjects. The imported user accounts are disabled by default. To obtain the list of users, the following query must be executed: SELECT SI_ID, SI_NAME,SI_ENT_USERFULLNAME,SI_DESCRIPTION,SI_OBTYPE FROM CI_SYSTEMOBJECTS WHERE SI_OBTYPE = 19, The result is presented in blocks and not in rows, I leave the query to obtain the list of groups, SELECT SI_ID, SI_NAME,SI_ENT_USERFULLNAME,SI_DESCRIPTION,SI_OBTYPE FROM CI_SYSTEMOBJECTS WHERE SI_OBTYPE = 20. Find Windows Appx Package names using PowerShell. Creating a Root BusinessObjects Directory, dialog box, type the name for the folder, and click. Always make sure Single & Double quotes involved in the queries as expected by the standard format. Wait until the service completely stops. -Use your Administrator credentials to log in here. I am using below query: SELECT SI_ID,SI_NAME, LAST_RUN_TIME FROM CI_INFOOBJECTS WHERE SI_PARENT_FOLDER = 5698. China Floor Machine catalog of Dynamic New Design Electric Walk Behind Floor Grinder (DY-680), Walk Behind Ground Electric Polishing Machine Floor Grinder (DY-680) provided by China manufacturer - Shanghai Jiezhou Engineering & Mechanism Co., Ltd., page2. error. You can view a list of the upcoming meetings and view the location, check out the agenda details, and register for them by following the links below. Knowledge of relevant BI tools to deliver data to users: Excellent working knowledge of SQL SSMS, SSIS, SSRS. BusinessObjects (BO) is a Business intelligence (BI) software from SAP to create interactive ad-hoc reports for users on SAP and non-SAP data sources. To list the top level Groups, which are at the root level in Group Hierarchy: SELECT si_id, si_cuid, si_name, si_group_members, si_subgroups, si_usergroups FROM CI_SYSTEMOBJECTS WHERE SI_KIND='UserGroup' and si_usergroups is null . It is correct that you can access this kind of data, from a WebService. How to avoid duplicate records ? Thanks toMatthew Shawfor his wonderful blog from where I got this little idea andBharath B N for pointing me to the right direction. SAP BusinessObjects Business Intelligence platform 4.x. 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. I dont believe there is any type of export button there. How to display the list of user groups, the folders they have access to and the associate access levels? With group management, you can change the permissions of whole group instead of making changes to individual users. Each row in the text file defines a single record. Choose 'Security' as the preferred Group Type and choose 'Dynamic user' as the membership type. SAP BO Administration - Introduction. Text files must be saved in UTF-8 (UCS Transformation Format 8-bit) format. Change logontoken.enabled=false to logontoken.enabled=true. This Java sample demonstrates logging on and off of Business Objects Enterprise XI R2 as well as scheduling, renaming, and viewing reports. Optionally, type the users e-mail address. Analysis mode is a new way of interacting with data on list pages. I think it's not possible from CMS query at all. All Rights Reserved. . Once SAP BusinessObjects BI Platform 4.2 SP7is installed, you can create a subdirectory for all Suite standard and Analysis Center reports and configure individual BusinessObjects user accounts: Creating groups for the types of user accounts and then assigning the groups to the user accounts aids in maintaining the security rights and privileges for the user accounts. 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. How do I get a list of Parameter Names, and their Types (string or numeric) using SQL ? Then in the OnStart you would pull that list into a collection (e.g. BI, 4.2, bi, java, sdk, export, excel, csv, xls, xlsx, list all users. Press and hold the <Ctrl> key and then click the user names to add to a group. Query Builder Blog series. rev2023.3.3.43278. what i am asking, one of our developer had used "image from address" in Appearance option in format cell. You can select any user from left side and use arrow key to add the user to selected group. Can you please let me know what might have gone wrong? I am having the same question, Can you recommend a tool or a way to get the report's query. Some of the Query builder queries to explore the BusinessObjects repository. and return a list of reports those are using this table in their query. If any errors are listed, resolve them and click, . Under Google Workspace Sync section, carefully read the Account Conflict message, then click Resolve. SAP BO tool comes with large number of inbuilt tools . --EXEC MASTER..XP_CMDSHELL 'dsquery group -name "Group_Name" | dsget group -members -expand -c | dsget user -samid -c'. Devise or modify procedures to solve complex problems considering business and/or system limitations, operating time, and form . A good understanding of Microsoft VBA. For example, one method that you can use on business object Employee is to "check for the employee's existence". Is it possible to create a concave light? Participate in staff's business goals and career development discussions. What is the variable to use to select users whose accounts have been disabled (Disabled option checked) ? Which users having access to which reports. If the conflicting accounts are identical to . SAP BusinessObjects Business Intelligence Platform (BI) 4.x. To review the members of a group, click the Group Hierarchy link in the left pane, and double-click the group to view the users who are members of the selected group. We are trying to run this code in BO 4 but not able to run,could you please check your script file again. Is it possible to find embedded image properties in webi report with admin query. Learn about the key capabilities and features of Dynamics 365 Business Central and experience some of the new features. Hello All, We have been play around with the Query Builder a bit and noticed an oddity I guess. User who belong to this group are granted access to the. At The Hackett Group, we have an environment where people with passion, commitment and insight work together to . Once new group is created, you can add users, subgroups, and assign group memberships. How to delete bulk users in BusinessObjects Enterprise from a text file using Java SDK? gvIsAdmin) and set the value (true/false) by checking if the current user is listed in colAdminUsers. Participate in staff selection, training, evaluations, and performance management. How to display the list of user groups, the folders they have access to and the associate access levels? "Nearly 90 percent of the land in the Tahoe Basin is owned and managed by public agencies like the USDA Forest Service, state park agencies, and land conservancies," said Kira Smith, Senior Planner with the Tahoe Regional Planning Agency . Thank you very much. Good experience with Business Intelligence tools and Decision Support Systems; Strong data analysis skills using Hive , Spark , Python , R , Microstrategy and Tableau. Alerting is not available for unauthorized users. 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. If I have a customer with 5 orders the report returns 5 lines and I want to group it somehow to have only one line with the name of the customer . 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. All I changed is theSI_ID of the folder and it didn't work. To subscribe to this RSS feed, copy and paste this URL into your RSS reader. it looks like you are in the 64bit machine and you need to run the command like this: C:\Windows\SysWOW64\cscript.exe c:\UserGroupList.vbs, Getting an error saying that Invalid Character line1 char 1. using this one I'm only able to view the list of users and the group EVERYONE and ADMINISTRATORS (the standard ones).. why i'm not getting also my custom groups? Also known as a "semantic layer", the Business Objects Universe is an intermediary layer between a database or data source and dependent reports, queries, or dashboards. Site design / logo 2023 Stack Exchange Inc; user contributions licensed under CC BY-SA. Not the answer you're looking for?