Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Reporting: Limiting Number of Records Shown

RobK_GC
Tera Contributor

I'm trying to create a simple report showing a list of active users that are assigned more than one non-retired, operational PC's from table (cmdb_ci_computer). 

 

Once I configure the report to group by "assigned to", I get a list of Users with each of their assigned PC's nested beneath, as expected. No problem up until this point.

 

Now what I want to do is show ONLY those users with results greater than 1.

Again, I do not want to show users assigned only one PC.

So, I have 2 questions:

 

1. How can I filter the list to only show those users with results greater than 1? 

2. Why is this exact functionality only available at the related list level for the same report?

Why not at the base report level? 

 

RobK_GC_1-1761847941304.png

 

Any assistance is greatly appreciated.

Thanks in advance. 

 

5 REPLIES 5

@RobK_GC 

Hope you are doing good.

Did my reply answer your question?

💡 If my response helped, please mark it as correct and close the thread 🔒— this helps future readers find the solution faster! 🙏

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader