Query Builder not giving proper count

[Former Member]

Hi Gurus,

I need to fetch no of webi,user ,groups through query builder ..not giving the right count ,please advise and let me know the exact query..i am using 4.2 .

Thanks in advance

[DellSC]

Please define what you mean by "not giving the right count." Is the count higher, lower, or non-existent? Thanks!

[rajdeep_marathe]

what is the query you are running:

check:

SELECT SI_ID, SI_NAME FROM ci_systemobjects WHERE SI_KIND = 'user'

[former_member230921]

https://wiki.scn.sap.com/wiki/display/BOBJ/Query+Builder

https://answers.sap.com/questions/5571094/how-to-get-a-count-of-report-instances.html

Please share the query which you are using in Querybuilder.