AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

Forums
AUG Forums
Acumatica Generic I...
GI for Active Users
 
Notifications
Clear all

Questions GI for Active Users

 
Acumatica Generic Inquiries & Pivot Tables
Last Post by Kurt Bauer 4 years ago
2 Posts
2 Users
1 Reactions
1,599 Views
RSS
Kurt Keating
Posts: 27
 Kurt Keating
Topic starter
May 5, 2022 11:29 am
(@kkeating)
Trusted Member
Joined: 4 years ago

Hello,
I was trying to develop a report that will provide me all the email addresses for Active users (i.e. not disabled). 

Easy enough to pull first name, last name and Email from the user table, but the the 'Status' field is no where to be found.

image

Says it's in the Users Table...but I can't seem to find it, there is a PseudonymizationStatus field in the users table but that doesn't seem to yield the results I need:

image
image

Help is appreciated!


1 Reply
Kurt Bauer
Posts: 45
 Kurt Bauer
May 5, 2022 3:33 pm
(@kurtybauer)
Trusted Member
Joined: 6 years ago

The state field can be used where the state is active or online.  I have a client where we disable/enable users between 7pm and 7am based on the state field.

Thanks

Kurt


Reply
Tim Rodman reacted
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,526 Topics
  • 10.9 K Posts
  • 39 Online
  • 2,410 Members
Our newest member: thollings
Latest Post: Attribute Input Mask
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

  • Steven Fuller
Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2025 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×