Mismatch in User Count: Cato Report vs GraphQL API Output

Question

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 data via the API, we are only getting around 768 users.

It appears that the API is returning only users with an active Cato connection. We are not receiving data for assets or users that are currently not connected.

Could you please confirm if this is an expected limitation of the API, or if there is a way to retrieve all users, including those that are not currently not connected?

mukeshkumar20 · Answer

Hi michaelsaw​&nbsp;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.&nbsp;Yes we have a open case with Cato request (#1113817) who has redirected our issue to Cato community .&nbsp;&nbsp;graphqlQuery = `&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; query accountSnapshot($accountID: ID!) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; accountSnapshot(accountID: $accountID) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; users {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; connectivityStatus&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; connectedInOffice&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; name&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; deviceName&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; timestamp&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; `;

michaelsaw · Answer

Hi&nbsp;Mukeshkumar20,&nbsp;
Appreciate the feedback.It seems there is a difference on the numbers.&nbsp;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 · Answer

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

michaelsaw · Answer

Hi&nbsp;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

michaelsaw · Answer

Hi&nbsp;Mukeshkumar20,&nbsp;
Noted on the snapshot Cato API syntax.Because it is a snapshot, the users is based on a certain instance of time.The report would give a duration-based information.Can we check if a snapshot-based or a duration-based report is required?
Cheers

Forum Discussion

Mismatch in User Count: Cato Report vs GraphQL API Output

5 Replies

Recent Discussions

Mismatch in User Count: Cato Report vs GraphQL API Output

I could use some help with a Powershell script for the events feed.

Custom Category creation via API/Terraform

Getting the DHCP Pools information via API

Using Graphql to query statistic of LastMilePacketLoss