How to add a having clause for my report?

AmbroseW
Kilo Contributor

Hi, I am asked to create a report where showing users that are assigned with two or more computers.I couldn't find the having clause or related list condition. Is there anyway to achieve the desired result? 

1 ACCEPTED SOLUTION

Onkar Pandav
Tera Guru

Hi,

In addition to above reply, you can also give filter condition as per your requirement.

Please refer below screen shot.

find_real_file.png

View solution in original post

5 REPLIES 5

Bhanu Kiran
ServiceNow Employee
ServiceNow Employee

Hello Ambrose,

You can probably use below KB and have something similar set up:

https://hi.service-now.com/kb_view.do?sys_kb_id=9236a053db1d1410d82ffb2439961991

 

Many Thanks,

Bhanu Kiran