Community Tip - Learn all about PTC Community Badges. Engage with PTC and see how many you can earn! X
Solved! Go to 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.
This is not clear at all? What does the code do? Can you share more information?
I think he’s asking that his code be able to list all users that have been inactive for 90 days or more.
Yes, you are correctly understanding my Question, can you share for that you have any solution.
Yes, you are correctly understanding my Question, can you share for that you have any solution.
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
[Knowledge Hub] Windchill PLM Data Monitor
How can a report be run on a schedule and emailed to a user?
This code collects the inactive user list and then send a mail to user's mail. e.g. your account is going deactivated soon.
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!
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.
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?