topic Re: CPViewInsights in API / CLI Discussion

CPViewInsights

Joshua_Hatter — Tue, 30 Jul 2019 06:53:49 GMT

#####

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=&solutionid=sk125092&partition=General&product=CPInfo%22

Thanks for all the support to date!

#####

Re: CPViewInsights

XavierBens — Thu, 03 May 2018 14:46:56 GMT

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 !

Re: CPViewInsights

Joshua_Hatter — Thu, 03 May 2018 16:04:15 GMT

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.

Re: CPViewInsights

David_Ojunga — Mon, 07 May 2018 17:24:33 GMT

Great work!!!! Very helpful

Re: CPViewInsights

JozkoMrkvicka — Wed, 26 Sep 2018 14:35:28 GMT

Windows 8.1 Pro.

Re: CPViewInsights

Joshua_Hatter — Wed, 26 Sep 2018 14:44:31 GMT

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

Re: CPViewInsights

JozkoMrkvicka — Thu, 27 Sep 2018 06:37:37 GMT

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).

Re: CPViewInsights

KennyManrique — Thu, 18 Oct 2018 19:48:03 GMT

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.

Re: CPViewInsights

Joshua_Hatter — Fri, 19 Oct 2018 01:37:04 GMT

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.

Re: CPViewInsights

Joshua_Hatter — Fri, 19 Oct 2018 14:52:51 GMT

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

Re: CPViewInsights

KennyManrique — Fri, 19 Oct 2018 21:26:13 GMT

Thank you Joshua Hatter‌!

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

Regards.

Re: CPViewInsights

Nicolas_Boisse — Wed, 24 Oct 2018 12:24:36 GMT

Nice tool Joshua 🙂

Re: CPViewInsights

Sven_Glock — Wed, 31 Oct 2018 19:35:27 GMT

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

Re: CPViewInsights

Joshua_Hatter — Wed, 31 Oct 2018 20:46:27 GMT

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.

Re: CPViewInsights

Solbom_Du — Thu, 01 Nov 2018 09:00:07 GMT

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.

Re: CPViewInsights

Benoit_Verove — Tue, 12 Feb 2019 08:15:37 GMT

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

Re: CPViewInsights

Joshua_Hatter — Tue, 12 Feb 2019 13:27:01 GMT

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

Re: CPViewInsights

Prachachart_Sta — Tue, 11 Jun 2019 07:24:44 GMT

Hi Joshua,

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

Prachachart.S