Windchill system data statistics dashboard

[航楚_10467481]

I am using Windchill PDMLink Release 12.0 and Datecode with CPS 12.0.0.2

How to view process and user data in Windchill system. For example:
1. Extract the number of user visits and user name information after 20:00 on Fridays in the past six months
2. The approval time of each node in the statistical process

Translated by Andra Chirila using Google Translate on April 21st, 2023
-----------------------------------------------------------------------------------------------
如何查看windchill系统中流程、用户的数据。例如：
1、提取系统近半年周五20：00以后用户访问量，以及用户名信息
2、统计流程各节点的审批时长

[avillanueva]

If you've enabled them, your best bet for this data is the Security Audit Reports at the bottom of the site utilities tab.

[joe_morton]

Look into using Query Builder: https://support.ptc.com/help/wnc/r12.0.2.0/en/index.html#page/Windchill_Help_Center%2FQBQueryBuilderOview.html%23

It is possible to create reports for those things, but it is more difficult to get those reports into a true dashboard.

[Marco_Tosin]

Take a look also at this old discussion

https://community.ptc.com/t5/Windchill/DOES-ANYONE-KNOWS-QUERY-TO-CHECK-LAST-LOGIN-OF-A-USER-INACTIVE/td-p/399956