How to get Data from Edge History File (SQLite DB)

[SunnySchindler]

Is there a Microsoft App to get Data from Edge History File (SQLite DB ) ? Location shown below:

Why i need it is detailed 

https://answers.microsoft.com/en-us/microsoftedge/forum/msedge_history-msedge_win10/windows-10-edge-... 

Non-Microsoft product needs long approval time (Example: Edge Extension "DB Browser for SQLite" )

[v-eqin-msft]

Hi @SunnySchindler ,

There is an addon called SQLite Reader that help you easily browse, edit and render SQLite database.But this add-on is still in beta and may work as expected. 

Hope these help:

https://www.foxtonforensics.com/browser-history-examiner/microsoft-edge-history-location

https://blog.group-ib.com/forensics_edge

https://www.nirsoft.net/utils/browsing_history_view.html

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[SunnySchindler]

TQ. This app move me forward. What I wish :

1. History for This Page
2. DateTime shown next to Elements 

How to do this ? Thanks Ahead!

[PhilipTreacy]

Hi @SunnySchindler 

Is this a one off thing that you want to do?  If so you could use this site 

SQLite Viewer (inloop.github.io)

and load the History file to it, then export the data you want.

If you want to do this regularly, it looks like you can connect to SQLite using an ODBC driver.  You'd need to first download the ODBC driver and create a DSN

HodentekMSSS: Creating an ODBC DSN for connecting to SQLite database

then configure the ODBC connection in Power BI

Connecting Power BI to SQLite via ODBC Driver (devart.com)

Regards

Phil