cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Fetch idle PDMLink Users' list

Highlighted

Fetch idle PDMLink Users' list

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.


Thanks


M Pavundoss

9 REPLIES 9
Highlighted

Fetch idle PDMLink Users' list

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.


Highlighted

Fetch idle PDMLink Users' list

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

Highlighted

RE: Fetch idle PDMLink Users' list

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

Highlighted

Fetch idle PDMLink Users' list

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
Highlighted

Fetch idle PDMLink Users' list

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
Highlighted

RE: Fetch idle PDMLink Users' list

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
Highlighted

Fetch idle PDMLink Users' list

From a few years ago (January 2012):



Highlighted

Fetch idle PDMLink Users' list

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


Highlighted

Fetch idle PDMLink Users' list

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.
Announcements