How to fetch a report with group names and its members

[Community Alums]

How to fetch a report with group names and its members 

[rad2]

You can create a report with list type on 

1. Go to the Navigator - select Reports --> View / Run

2. Select  'Create a report'

3. DATA -  Enter Report Name, Souce Type - Table, Table - Group Member. click Next

4. TYPE - Select List in Other

5. CONFIGURE - Group by - Group. You can also select the columns that you would prefer

6. save it. whenever you need the report, you can export to pdf. an example of how it looks

[Community Alums]

Hi Rad thanks for the above resolution as i am looking at report in form of Excel download as through report we confined to PDF format.is there any way to get this directly into excel format report ..would be really helpful.. thanks Hari Rao 

[rad2]

I could for the moment find these two ways

1. with using this URL you can download it in CSV format - https://<your instance>.service-now.com/incident_list.do?CSV&sysparm_query=priority=1&sysparm_orderb...

2. right click on any column of the table . Export -->

Hope this helps!

[Community Alums]

How did you get an option of the export on the Group and Roles form correct me if i am looking it in different way as i do not see such option on that