Skip to main content
P
pmuthuramalinga10-Marble
10-Marble
February 11, 2014
Question

Fetch idle PDMLink Users' list

  • February 11, 2014
  • 9 replies
  • 3714 views

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

B
BenLoosli23-Emerald III
23-Emerald III
February 11, 2014
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.


L
Lohbauer1-Visitor
1-Visitor
February 11, 2014
You could parse the data from the PTC Windchill Usage tool.

A
Anonymous
February 11, 2014

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

J
jv83421-Visitor
1-Visitor
February 11, 2014
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
M
MikeLockwood22-Sapphire I
22-Sapphire I
February 11, 2014
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
P
pmuthuramalinga10-MarbleAuthor
10-Marble
February 12, 2014

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
J
JohnGloor1-Visitor
1-Visitor
February 12, 2014
From a few years ago (January 2012):



P
pcnelson1-Visitor
1-Visitor
February 12, 2014
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


M
MikeLockwood22-Sapphire I
22-Sapphire I
February 12, 2014
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.
Terms & ConditionsAccessibility statement