Is there a way to know the number of users with ac...
# generale
Edgar Valdes
09/12/2024, 6:56 PMIs there a way to know the number of users with access, in a given point in time?
I'm interested in a report / query that shows the number of occupied seats in may / jun / jul etc...
t
tdietrich
09/13/2024, 10:39 AMThis isn't exactly what you're asking for, but here goes...
With SuiteQL, you can query to get the number of users that currently have been given access using this:
Copy code
SELECT COUNT(*) FROM Employee WHERE giveAccess = 'T'tdietrich
09/13/2024, 10:40 AMAnd if you want to see who those users are, you can use this.
Copy code
SELECT
LastName,
FirstName
FROM
Employee
WHERE
giveAccess = 'T'
ORDER BY
LastName,
FirstNametdietrich
09/13/2024, 10:41 AMAs far as being able to see how many users had access in the past, I don't think that's possible.
tdietrich
09/13/2024, 10:42 AMIn theory, you could query the LoginAudit table to see how many users logged in during a certain date range. For example...
Copy code
SELECT DISTINCT
LoginAudit.User
FROM
LoginAudit
WHERE
( LoginAudit.Date BETWEEN TO_DATE( '20240911', 'YYYYMMDD' ) AND TO_DATE( '20240913', 'YYYYMMDD' ) )tdietrich
09/13/2024, 10:43 AMI say "in theory" because getting permissions right to query that table is challenging. You'll likely only be able to see the activity of your own employee record.
e
Edgar Valdes
09/13/2024, 3:48 PMThanks @tdietrich!!!
I will have to create a query to see when each user was granted access and when this access was removed. Then some Excel buffonery fb laugh
10 Views