Related to code

[SM_11005334]

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

My code runs with particular username it's self-working, but i want whole list of user more than 90days inactive user list and last login time both.

Here are the errors that I faced
My code runs with particular username it's self-working, but i want whole list of user more than 90days inactive user list and last login time both.

[avillanueva]

This is not clear at all? What does the code do? Can you share more information?

[d_graham]

@avillanueva ,

I think he’s asking that his code be able to list all users that have been inactive for 90 days or more.

[SM_11005334]

Yes, you are correctly understanding my Question, can you share for that you have any solution.  

[SM_11005334]

Yes, you are correctly understanding my Question, can you share for that you have any solution. 

[Marco_Tosin]

The solution without customization is the one proposed by @joe_morton 

Create a report query builder and make a data monitor.

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

[Knowledge Hub] Windchill PLM Data Monitor

How can a report be run on a schedule and emailed to a user?

[SM_11005334]

This code collects the inactive user list and then send a mail to user's mail. e.g. your account is going deactivated soon.  

[olivierlp]

Hi @SM_11005334 

Thanks for entrusting your question to the PTC Community. Though it looks like you replicated one line in your question, perhaps by mistake. 

To reinforce what @avillanueva and @d_graham said, it will be easier to get help if you give more details upfront about your use case, what you are trying to do and possibly some screenshots and piece of code to look at. Otherwise, other members will not know how to approach the problem. Here is some guidance: How to Ask a Good Question - PTC Community

Looking forward to getting more details soon!

[joe_morton · Accepted solution]

Have you considered using query builder and adding a data monitor? As others stated, it would be helpful to understand what the end goal is. If you just need a report of inactive users, that can be done with query builder.

[d_graham]

I wrote a sql query to get users that have been inactive for X days.

I also created Query Report per Joe's suggestion.

The sql code is simple.

The Query Report is quite decent as well, although familiarity with the Query Builder's UI is necessary.

But you might want to do this in Java depending upon your end game.

Speaking of end game, what is the end game?