Comments (16)
Be carefull, because you have the time restriction in grafana, it can modify the counter
from glpi_app_grafana.
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.
Ok, I will try to check / reproduce
from glpi_app_grafana.
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.
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.
Hi David,
Did you reproduce the problem? Any progress with this issue?
from glpi_app_grafana.
I planned to work on grafana this friday
from glpi_app_grafana.
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.
You define 'total' in 'stat' field in tab 'options' ?
from glpi_app_grafana.
Yes we did
still wrong number
from glpi_app_grafana.
from glpi_app_grafana.
Hello, can you try with this patch: 21d0b1a
from glpi_app_grafana.
still discrepancy in results :(
from glpi_app_grafana.
is there any progress ? this plugin would be very valuable for us :|
from glpi_app_grafana.
Not had yet time to check, can you see if you have already the problem with version 1.3 ?
from glpi_app_grafana.
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)
- Error Bad Request
- Can't get any data, queries gets the authentication page as an answer HOT 1
- GLPI API Error Response: Bad Request HOT 2
- Failed to fetch Instantiating with Grafana 8 HOT 4
- incorrect values when using url HOT 11
- Cannot configure api on grafana HOT 1
- erro ao tentar instalar HOT 1
- Can't use mixed datasources to merge data from two glpi instance
- ERROR_SESSION_TOKEN_MISSING
- Not Working with Grafana v8.3.3 and GLPI 9.5.7 HOT 7
- Bad Request Grafana 8.5.1 GLPI 9.5.7 HOT 2
- Plugin is not working/page stops responding
- Not Working with Grafana v9.1.7 and GLPI 10.0.3 HOT 30
- Options manquantes
- Options manquantes HOT 1
- Invalid plugin signature
- Datasource not found HOT 2
- Entities
- Query error - failed to fetch
- Angular is deprecated - please migrate to React
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
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.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from glpi_app_grafana.