SAP CPQ User Report

[VasanthaK]

Hello SAP CPQ Community,

We are looking for a way to generate a report in SAP CPQ that provides a list of all active users, along with the date their account was created and the date of their last login.

Our goal is to effectively manage our user licenses and identify users who may no longer need access based on their inactivity. Comparing the 'creation date' and 'last login date' will be crucial for this analysis.

Specifically, we are interested in knowing:

Is there a standard report available in SAP CPQ that includes this information? If so, what is the name of the report and how can it be accessed?
If a standard report doesn't exist, what are the possible methods to extract this data? For example, are there specific APIs, data tables, or reporting tools within SAP CPQ that we can leverage?
Could a custom report be created to achieve this? If so, what would be the general steps or considerations for building such a report?
Are there any best practices or recommended approaches within SAP CPQ for monitoring user activity and managing licenses effectively?
We are using 2503 SAP CPQ version, Any guidance or suggestions would be greatly appreciated.

Thank you for your time and assistance."

[Sergey_L]

If you are still on the Quote 1.0 engine, you could use the Report Module to create a custom report. 
The USERS table has columns LastLoginTime and DateCreated. A little bit of SQL will give you what you need. 

You can even add Year and Month separately, in order to display it on a column chart, like so: 

,DATENAME(year, ISNULL(u.LastLoginTime,u.DateCreated)) AS LastActivity_Year
,CAST(MONTH(ISNULL(u.LastLoginTime,u.DateCreated)) AS INT) AS LastActivity_Month
,CASE WHEN u.LastLoginTime IS NULL THEN 'Logged in' ELSE 'Created, never logged in' END AS LastActivityType

Note, the third line will give you a column that you can then filter based on whether they've ever logged in or not.


If you are already on the Quote 2.0 engine - I do not know. I know that the Report Module is not available there. I'm also assuming that the underlying database is structured differently, so even with the script workbench, you'd have to navigate the database to find the names of relevant tables and their columns. If you find out or anyone else knows, I'd love to know, because we're planning on transitioning to 2.0.