CPViewInsights

[Joshua_Hatter]

#####

ANNOUNCEMENT

I have removed this tool from CheckMates.

R&D has provide this functionality inside of the latest DiagnosticsView Release.

https://supportcenter.checkpoint.com/supportcenter/portal?eventSubmit_doGoviewsolutiondetails=&solut...

Thanks for all the support to date!

#####

[XBensemhoun]

Hi Joshua, and thanks for that.

I've tried with the active CPViewdb.dat of a VSX Gateway and I had the following error message:

Maybe should I do something in order to use the actual .dat file ? Is their any Best practices regarding this historization of CPView stats?

For some reason I've an old file and I used it: your tool is really useful!

For example ; and then, just after having press on "Graph" button, a TAB on my preferred web browser is open and sho such result:

Reaaaaaaally cool !

[Joshua_Hatter]

Occasionally if you rip out the cpview database file live, you can create some inconsistencies in the database.

This will lead to this message, it isn't necessarily fully corrupted, just to a point where I can't graph reliably. I opted to not try repairing.

You should always use the following command to obtain the database.

#cpview history export

There are still some scenarios where it will be corrupt, but exporting properly should help in most cases.

[David_Ojunga]

Great work!!!! Very helpful

[JozkoMrkvicka]

Windows 8.1 Pro.

[Joshua_Hatter]

Hmm. Not sure haven't seen this. This is built for 64 bit is your machine 64 bit?

[JozkoMrkvicka]

Yes, 64bit.

I have also problem with SecuRemote on my private machine, so maybe something is wrong with my workstation (or with W8.1 Pro).

[KennyManrique]

Hi Joshua Hatter,

First of all, thanks for the tool, it's very useful.

One couple of things I noticed on Version 2 are the following:

- When working with multiple graphics on the same output, for example CPU cores or Interface drops, it shows vertical lines who extend forever but without information if you make zoom. On the following graphic, the maximum value is 60, but you can see lines above it and even below zero. I tested on three browsers with same results:

- When the data is always the same through time, the graphic output is apparenty 0; but if you put the mouse cursor shows the real value.

I hope you can review this.

Also I really appreciate if you can provide me the first verstion. When I tested at first, did not experienced the problems mentioned above.

Regards.

[Joshua_Hatter]

Thanks! I had literally never seen this before until today. Have another internal user confirming they have spotted it once before as well but after zooming in the data corrects itself, looking into it. 

Hope to release a updated version soon which is compatible with R80.20.

[Joshua_Hatter]

The latest version should correct this. I believe it was an underlying issue with Plotly Scattergl VS Scatter plots, if you still see the issue let me know! Kenny Manrique

[KennyManrique]

Thank you Joshua Hatter‌!

I tested again with same cpview file and now the graphic shows the data correctly!

Regards.

[Nicolas_Boisse]

Nice tool Joshua 🙂

[Sven_Glock]

Nice tool! I like it!

...but I was only able to start it once.

The second time I received this error:

Any ideas?

Thanks in advance.

Cheers

Sven

[Joshua_Hatter]

The python interpreter in the compiled executable ran into an un-handled exception.

I'm constantly working on this project, and the next version will have better logging so that the log file can have some information to work with on these.

If I had to guess, I know there is a bug on second launch of a database that is corrupted. Deleting the settings.json file inside of the zip folder will fix this.

This is cause because the tool saves the last used database and reloads it on next launch.

Also depending on how/where you launch the tool from, it will try to make the log file in the directory you call from, leading to permissions errors.

So for example if you unzipped in C:\Users\username\cpviewinsights\

But you call the exe manually from cmd line in Windows at path C:\

It will try to make the log file in C:\ and this commonly leads to a permission exception.

Other than that I apologize I'm not sure, lookout for next version here probably by next week.

Next version will have better handling for corrupted databases due to improper export from the firewall.

[Solbom_Du]

Hi Joshua Hatter.

There is a time stamp of "CPview History" and a time error shown on the graph.
Ex) 1539216686 -> Oct 11, 2018 01:11:26 ( 1H )

As the time error range increases, other data values differ from the "CPViewDB.dat" value.

Are there any restrictions or settings that I don't know?

Version : R80.10 Take 121

Regards.

[Benoit_Verove]

Hi,

This tool is really great ! So useful.

I have a gateway on wich I exported the db with the command "cpview history export" but the result is always seen as corrupted by the tool.

From command line, navigating in the history with "cpview -t" is working fine.

Do you have any advice ? Is there a way to repair it manually ?

Regards,

Benoit

[Joshua_Hatter]

So sometimes I use DB Browser for SQLite to view the table I'm having issue with to see what the problem is. Many times you will find corrupted characters and or data from other tables in the wrong table even.

Some have attempted a sql dump and insert into new database, but your mileage may very. Have seen bizarre graphs after doing a dump. 

sqlite - How to recover a corrupt SQLite3 database? - Stack Overflow 

[Prachachart_Sta]

Hi Joshua,

Thanks for your great tool, By the way did we have graph for throughput history?

Prachachart.S