Code Monkey home page Code Monkey logo

Comments (16)

ddurieux avatar ddurieux commented on July 24, 2024

Be carefull, because you have the time restriction in grafana, it can modify the counter

from glpi_app_grafana.

zbuk78 avatar zbuk78 commented on July 24, 2024

Yes, changing date range I get different results, but still none of them (even with last 50 years) is the same results in glpi and grafana. What's more, when I run Query Inspector, then I have three different results:
glpi - 1176
Query inspector returns 1099
and on grafana's singlestat I have 1077 machines.
I realize that may not be a bug and I have misconfigured something, but I'm just not able to get results that would be exactly the same.

from glpi_app_grafana.

ddurieux avatar ddurieux commented on July 24, 2024

Ok, I will try to check / reproduce

from glpi_app_grafana.

zbuk78 avatar zbuk78 commented on July 24, 2024

One more strange thing I've noticed is that some queries show good results in Query Inspector and after a while the url changes itself for one searching tickets (even though I paste the url to look for ie. virtual machines) and the request ends up with something like that:

request:Object
method:"GET"
url:"api/datasources/proxy/8/search/ticket?is_deleted=0&criteria[0][field]=12&criteria[0][searchtype]=equals&criteria[0][value]=all&search=Rechercher&itemtype=Ticket&start=0&criteria[1][link]=AND&criteria[1][field]=15&criteria[1][searchtype]=morethan&_select_criteria[1][value]=0&_criteria[1][value]=-49624586&criteria[1][value]=1968-06-05 15:23:34&criteria[2][link]=AND&criteria[2][field]=15&criteria[2][searchtype]=lessthan&_select_criteria[2][value]=0&_criteria[2][value]=1528212214&criteria[2][value]=2018-06-05 15:23:34&forcedisplay[0]=0&giveItems=true&forcedisplay[1]=1&forcedisplay[3]=3&forcedisplay[13]=13&forcedisplay[4]=4&forcedisplay[5]=5&forcedisplay[15]=15&range=2000-2399"
response:Object
totalcount:42630
count:400
sort:1
order:"ASC"

Before that result I have this one:
request:Object
method:"GET"
url:"api/datasources/proxy/8/search/computer?is_deleted=0&criteria[0][field]=5150&criteria[0][searchtype]=morethan&_select_criteria[0][value]=-1WEEK&criteria[0][value]=-1WEEK&criteria[1][link]=AND&criteria[1][field]=40&criteria[1][searchtype]=equals&criteria[1][value]=26&criteria[2][link]=OR&criteria[2][field]=40&criteria[2][searchtype]=equals&criteria[2][value]=15&search=Szukaj&itemtype=Computer&start=0&_glpi_csrf_token=8209811f9da600ba98e78b98dbcc0745&criteria[3][link]=AND&criteria[3][field]=5150&criteria[3][searchtype]=morethan&_select_criteria[3][value]=0&_criteria[3][value]=1370446314&criteria[3][value]=2013-06-05 15:31:54&criteria[4][link]=AND&criteria[4][field]=5150&criteria[4][searchtype]=lessthan&_select_criteria[4][value]=0&_criteria[4][value]=1528212714&criteria[4][value]=2018-06-05 15:31:54&forcedisplay[0]=0&range=0-399"
response:Object
totalcount:337
count:337
sort:1
which is the exact number returned by glpi, but the number displayed on singlestat is 322.

from glpi_app_grafana.

yoshi314 avatar yoshi314 commented on July 24, 2024

also noticing this, simple query for computers that have not been updated with fusioninventory since last week is off by ~100

from glpi_app_grafana.

eprogres avatar eprogres commented on July 24, 2024

Hi David,
Did you reproduce the problem? Any progress with this issue?

from glpi_app_grafana.

ddurieux avatar ddurieux commented on July 24, 2024

I planned to work on grafana this friday

from glpi_app_grafana.

eprogres avatar eprogres commented on July 24, 2024

grafana_screen

nothing better than screenshot
Query inspector in line totalcount:1236 shows correct value, same number in glpi
but in indicator we got 1095 which is wrong. Time range in query is correct (in example last 7 days)

we try to count returned objects - checked option "Count elements"

from glpi_app_grafana.

ddurieux avatar ddurieux commented on July 24, 2024

You define 'total' in 'stat' field in tab 'options' ?

from glpi_app_grafana.

eprogres avatar eprogres commented on July 24, 2024

total

Yes we did
still wrong number

from glpi_app_grafana.

eprogres avatar eprogres commented on July 24, 2024

dashboard.txt

from glpi_app_grafana.

ddurieux avatar ddurieux commented on July 24, 2024

Hello, can you try with this patch: 21d0b1a

from glpi_app_grafana.

eprogres avatar eprogres commented on July 24, 2024

zrzut ekranu z 2018-11-05 14-43-36

still discrepancy in results :(

from glpi_app_grafana.

Marsnet100 avatar Marsnet100 commented on July 24, 2024

is there any progress ? this plugin would be very valuable for us :|

from glpi_app_grafana.

ddurieux avatar ddurieux commented on July 24, 2024

Not had yet time to check, can you see if you have already the problem with version 1.3 ?

from glpi_app_grafana.

kowalskimn avatar kowalskimn commented on July 24, 2024

We're still observing a constant offset between query inspector results and displayed results.

The difference varies every day, but seems fixed when changing time ranges in grafana.

from glpi_app_grafana.

Related Issues (20)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.