Report - 5 or more users created on 1 Account

[MStritt]

I'm trying to create a report on the customer_contact table, that shows which Accounts had 5 or more users created/registered against the Account yesterday. Grouped by Account/Company.

[Its_Azar]

Hi there @MStritt 

Create a New Report by navigating to the reporting module in ServiceNow and create a new report.

Select the needed  table as the base table for your report.

Set the filter criteria to include only records where the creation date is yesterday.

You can use a filter condition like "Created On" is yesterday.

Configure the report to group the results by the Account or Company field.

Add an aggregation to count the number of users created for each Account.

Select the "Count" aggregation function and choose the user field (e.g.,sys createf byu  or any other relevant field that represents a user) to count the number of users created.

Customize the columns displayed in the report to include relevant information such as Account/Company name and the count of users created.

If this helps kindly accept the response thanks much.

[MStritt]

Hi!

Will this allow me to only display Accounts where 5 or more Contacts/Users were created 'yesterday'? Right now, I'm using a List View report. I can group by Account and it will show how many users were registered on that Account 'yesterday'. But I only want to show Accounts where 5 or more users were registered 'yesterday'.