Forum Discussion

Mukeshkumar20's avatar
Mukeshkumar20
Icon for Joining the Conversation rankJoining the Conversation
9 days ago

Mismatch in User Count: Cato Report vs GraphQL API Output

This is to update that we are encountering an issue with the User GraphQL query. For example, when we generate a manual report from Cato, we receive approximately 1,750 users. However, when fetching...
michaelsaw's avatar
michaelsaw
Icon for Cato Professional Services rankCato Professional Services
5 days ago

Hi Mukeshkumar20, 

Appreciate the feedback.

It seems there is a difference on the numbers. 
Could the additional numbers possibly be as a result of duplicates?
By doing a sample check on the manual report, can we double-check if there are duplicates found?

Cheers

  • Mukeshkumar20's avatar
    Mukeshkumar20
    Icon for Joining the Conversation rankJoining the Conversation
    5 days ago

    Hello,

    I have already checked on that side there is no duplicate entries into manual report.

    • michaelsaw's avatar
      michaelsaw
      Icon for Cato Professional Services rankCato Professional Services
      2 days ago

      Hi Mukeshkumar20,

      Got it.
      Understand you mentioned about "users with active Cato connection".
      Can we check the timeline and the filters used? ___
      Is there an assigned Cato Rep/engineer assisting you on this? ___

      Cheers

      • Mukeshkumar20's avatar
        Mukeshkumar20
        Icon for Joining the Conversation rankJoining the Conversation
        2 days ago

        Hi michaelsaw​ 

        Below is the GrphQL we are using to get the data. Please suggest if we are on right path , if need any refinement for complete data please guide with updated Query. 

        Yes we have a open case with Cato request (#1113817) who has redirected our issue to Cato community . 

         graphqlQuery = `

                    query accountSnapshot($accountID: ID!) {

                        accountSnapshot(accountID: $accountID) {

                            users {

                                connectivityStatus

                                connectedInOffice

                                name

                                deviceName

                            }

                            timestamp

                        }

                    }

                `;