Taking report to know 'view' only access user's last login time

[Vignesh_AJ_77]

I am using Windchill PDMLink Release 12.1 and Datecode with CPS 12.1.2.0

I need to take a report from windchill to see user's who has only 'view' access, their last login time to windchill. Is there way a to extract this information?

[joe_morton]

Probably the easiest way to get some data is to go to Site -> License Management, then go to the Report tab. You can run a report on the period you specify. It gives some data that might get you close to what you're looking for.

[Vignesh_AJ_77]

Thanks. But I could not find License management option under site in windchill. I have database access. Do you know any table where I could pull this information: View access user's last login time. 

[avillanueva]

Combined with the reports provided by @Marco_Tosin , you can export the PTC View and Print Only License group. You can do this from the partipants administrator. Select on the group and export to CSV. The two Excel extracts can be joined by the username to give you what you want.

[Vignesh_AJ_77]

As I don't have admin level access, I could not access the report management section. I used the database query given in one of the links which @Marco_Tosin provided :

Through which i was able to extract users' last login date, but still I need one more column which would show each users access levels (view or write). Do you know how to merge that info with this query? 

[avillanueva]

Strange that you have DB level access but not site admin level access. That should be fixed since this could have been done in 5 mins, Much more complex at DB level but here you go. This is a simplier query and if you do not like the name how the audit record records it, replace with U.name instead of A0.userName. This also is simplier since if there was an audit record of some event, the user must have been logged in so any event will do. Filtering on login events will show you the start of their session, not the end. the View and Print group are your read only users by policy unless you have another definition of read only is.

SELECT DISTINCT A0.userName,MAX(TO_DATE(A0.createStampA2)) 
FROM AuditRecord A0,WTGROUP G, MEMBERSHIPLINK M, WTUSER U
WHERE
M.IDA3A5 = G.IDA2A2 AND
M.IDA3B5 = U.IDA2A2 AND
U.IDA2A2 = A0.IDB5 AND
G.name like 'PTC View and Print Only License'
GROUP BY A0.userName

[avillanueva]

What is your ultimate goal? Is this a one time extract or something you need to run many times? There should be a report of active users and their last logins. If you do not have that, let me know since I can extract QML for that. Now to know if they are a View and Print iser, only have view access, you just need to extract that group. Should be able to cross merge those extracts in Excel to get what you need. Note that this does not say anything about the user's access over time. A user could have been removed from the View and Print group or recently added. All you can tell is that they are currently in that group now. Let me know if you need further help.

[Vignesh_AJ_77]

Thanks for the response. My goal is to extract the list of users who has only view access and their last login time. This is a one time report I need. I have database access. Do you know any table where I could pull this information: View access user's last login time. 

[Marco_Tosin]

Report to fetch "last logged in" of users

How to display user's last login time in a query builder report

Last Login by user (Mike Lockwood)

[Vignesh_AJ_77]

I used the database query given in one of the links which you provided :

Through which i was able to extract users' last login date, but still I need one more column which would show each users access levels (view or write). Do you know how to merge that info with this query? 

[Marco_Tosin]

Take a look at these articles

How to generate a QueryBuilder report showing to which license groups users are assigned

How to generate the Query Builder report which lists the user with its associated profile

How to report all the Profiles a user is directly associated with

[avillanueva]

Reading your last note and my last reply, It is way more complicated than what you originally asked for to report out the user's access level.  That's different than what you said initially. Its also not specific. One can look at license groups as access level. Another way is to look at the contexts they are a part of and what role they are in that area. All of that depends on your interpretation. For example, a user can have a Windchill Base license but not be only a Guest of a context which limits them to read only. 

If we take a look at just licenses, a user can have many licenses assigned. Ideally, if they are in the View and Print group, they should not be in another license group. For users not in V&P, there is Windchill Base, Windchill Advanced, Windchill Premium, plus all the module specific groups. You admin should be able to provide a list of group names tied to each license and you can take what I provided to alter the group call out.