Applies To:
CPQ
Summary:
This guide will show you how to build a report to identify all active users in your environment. From here, you can choose which users to deactivate or remove.
Details:
With the new CPQ user compliance in place, some users may come across the need to do a cleanup of their current users in order to make room for more.
Solution/Workaround:
- Log in to CPQ
- Go to Setup
![](/sap/support/sapnotes/public/services/embedded_image.htm?iv_guid=00109B36D5CA1EDD86ACDE021C976904&iv_key=002075125900001300892022)
- Under the General section, find “Report Module”
![](/sap/support/sapnotes/public/services/embedded_image.htm?iv_guid=00109B36D5CA1EDD86ACDE021C96E904&iv_key=002075125900001300892022)
- In the navigation bar, click Administration
- Click Data Source
![](/sap/support/sapnotes/public/services/embedded_image.htm?iv_guid=00109B36D5CA1EDD86ACDE021C964904&iv_key=002075125900001300892022)
- Click Add
- Select a Display Name (Active Users)
- For Type, select Query
- In the box that shows up, paste the following query below:
select Username, email, name, LASTLOGINTIME, CreatedByUserName, DateCreated
from users
where active = 1
![](/sap/support/sapnotes/public/services/embedded_image.htm?iv_guid=00109B36D5CA1EDD86ACDE021C96A904&iv_key=002075125900001300892022)
- Click save
- In the navigation bar, click New
- Select New Report
![](/sap/support/sapnotes/public/services/embedded_image.htm?iv_guid=00109B36D5CA1EDD86ACDE021C96C904&iv_key=002075125900001300892022)
- Give your report a name (Active Users)
- In Report Data Source, select the table you have just created (Active Users)
- For Report Type, select Table
![](/sap/support/sapnotes/public/services/embedded_image.htm?iv_guid=00109B36D5CA1EDD86ACDE021C966904&iv_key=002075125900001300892022)
- Click Next
- Keep clicking Next until you get to a page that looks like this:
![](/sap/support/sapnotes/public/services/embedded_image.htm?iv_guid=00109B36D5CA1EDD86ACDE021C968904&iv_key=002075125900001300892022)
- Fill it out accordingly:
![](/sap/support/sapnotes/public/services/embedded_image.htm?iv_guid=00109B36D5CA1EDD86ACDE021C970904&iv_key=002075125900001300892022)
- Click Finish
- You will see a table which looks like this:
![](/sap/support/sapnotes/public/services/embedded_image.htm?iv_guid=00109B36D5CA1EDD86ACDE021C974904&iv_key=002075125900001300892022)
- From here, you can export it to Excel/Word/PDF by clicking the little Save Icon at the top
![](/sap/support/sapnotes/public/services/embedded_image.htm?iv_guid=00109B36D5CA1EDD86ACDE021C972904&iv_key=002075125900001300892022)
- Now you can identify which users you can deactivate or remove in order to make room for more active users