Skip to Content
avatar image
Former Member

CMS query builder

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Oct 02 at 11:38 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 24, 2017 at 12:44 PM

    can you share the query you have used?

    Add comment
    10|10000 characters needed characters exceeded