topic Fetch idle PDMLink Users' list in Windchill

Fetch idle PDMLink Users' list

pmuthuramalinga — Wed, 02 May 2018 14:00:27 GMT

I am required to fetch users' list who have not logged in to PDMLink system for 90 days. Will it be possible to fetch such report? If yes, please let me know the steps to fetch this report.ThanksM Pavundoss

Fetch idle PDMLink Users' list

BenLoosli — Tue, 11 Feb 2014 14:50:03 GMT

Not sure of the how, but there is no direct report available.

You will need to get a list of who has logged in and compare it to a list of all users.

Fetch idle PDMLink Users' list

Lohbauer — Tue, 11 Feb 2014 14:57:04 GMT

You could parse the data from the PTC Windchill Usage tool.

RE: Fetch idle PDMLink Users' list

atre.shreyas — Tue, 11 Feb 2014 15:10:36 GMT

When user login to Windchill login event is generated and OOTB that is stored in windchill DB. you can query on Windchill DB to get list of user who have not logged.
PFA attached sample QML/Report for getting list of user who have not logged in since 30 days. you can modify criteria as per requirment.

Hope this helps !!!

Thanks
Shreyas

Fetch idle PDMLink Users' list

JIMVANDRAGT — Tue, 11 Feb 2014 15:11:56 GMT

You can have a look in the Oracle tables to find a users last login date:

select max(auditrecord.createstampa2) as LASTLOGINDATE
from auditrecord, wtuser where auditrecord.idb5 = wtuser.ida2a2 and wtuser.name = ‘ab1234’;

Jim Van Dragt
PLM Architect
Information Technology

hermanmiller.com

Fetch idle PDMLink Users' list

MikeLockwood — Tue, 11 Feb 2014 18:18:29 GMT

This info is available here (pulls from auditrecord table):

[cid:image005.png@01CF270A.38AE58A0]

[cid:image006.png@01CF270A.38AE58A0]

Provided configAudit.xml is configured (as it is OTB) with “login” - true

RE: Fetch idle PDMLink Users' list

pmuthuramalinga — Wed, 12 Feb 2014 14:49:54 GMT

Thank you for your suggestions. Your suggestions helped me to fetch needed report from the database.

Thanks

M Pavundoss

In Reply to Mike Lockwood:

This info is available here (pulls from auditrecord table):

[cid:image005.png@01CF270A.38AE58A0]

[cid:image006.png@01CF270A.38AE58A0]

Provided configAudit.xml is configured (as it is OTB) with “login” - true

Fetch idle PDMLink Users' list

JohnGloor — Wed, 12 Feb 2014 15:43:12 GMT

From a few years ago (January 2012):

Fetch idle PDMLink Users' list

pcnelson — Wed, 12 Feb 2014 20:23:35 GMT

That query appears to find all logins for all users during the time
specified. In my case, to search over the last 90 days the report was 20k+
events. Is there a way to reduce it to remove duplicates?
Thanks,
Pete

Fetch idle PDMLink Users' list

MikeLockwood — Wed, 12 Feb 2014 20:26:17 GMT

Probably this UI cannot - it runs a query without "latest" (SQL maximum). Not well-structured or scalable.
Likely have to use the direct database query suggested by others - or similar in a query builder report also suggested by others. We use a direct database query.