CMS query builder

[Former Member]

Hi Experts,

I have downloaded query builder to export to from the below link:

http://biclever.com/software/cms-query-builder/

I am using this query builder to export data to excel, my problem is when I run the same query in the downloaded query builder and query builder on the server, I am not getting the same data. My impression when I downloaded is I get same data except that export to excel in the downloaded version.

I am not able to find why it's different. Can any of you have same issue?

I got the link from one of the forums here.

I really appreciate your help.

[Joe_Peters]

What's different about the results?

[Former Member]

Thanks Denis for your reply. I have not asked the organization, as I got the download link from SAP forums so I posted here thinking some one might already used it. Yesterday I have not used administrator account and got the mismatch. Today I ran the same query and matched the result set except for one record. BO query builder returned one row extra. Ran the below query to find current logged in users:

SELECT TOP 5000 SI_NAME, SI_LASTLOGONTIME FROM CI_SYSTEMOBJECTS WHERE SI_NAME NOT IN ('ADMINISTRATOR','GUEST') AND SI_KIND='USER' AND SI_LASTLOGONTIME > '2017.04.20' ORDER BY SI_NAME

Thanks again Denis.

Regards,

Raji

[former_member185603]

can you share the query you have used?