Hi Guys,
I want to make a stand alone utility to display the Log File.  Read Only.
How do I access the Log File please?
Regards & TIA,
Ian

Ian


I have no idea because I've never looked at EDBManager's code for it. You have the source, to investigate properly you'll need to install Tim's additional components as well.

On my machine the 32bit EDBManager code is at C:\3rdParty\EDBUtils\utils\edbmgr\win32\source and the components (I think) C:\3rdParty\EDBUtils\utilcomps

Roy Lambert

Hi Roy,
Ahhh.  Fie on me.  Didn't realise I had that source.
Shall investigate.
Regards & Tks,
Ian

Ian,

<< I want to make a stand alone utility to display the Log File.  Read Only.
How do I access the Log File please? >>

Just open it or SELECT from it like you would any other table - it's in the special "Configuration" database, so you would query it like this:

SELECT * FROM Configuration.LogEvents

https://www.elevatesoft.com/manual?action=viewtopic&id=edb2sql&topic=LogEvents_Table

Tim Young
Elevate Software
www.elevatesoft.com

Ahhhh.  As easy as that.

Tks Tim.

Regards,
Ian

Ian

You will find it really useful to run the following SQL in EDB Manager with the SESSION highlighted in the left-hand tree-view:

SELECT * FROM Information.Tables
ORDER BY Name

This gives a list of all the system tables, including LogEvents, Users, Roles etc.

The data in these tables can be accessed with the SQL:

SELECT * FROM Configuration.<Add Name of System Table Here>

It is really useful to get your head around the uses of these tables as once you are doing more complex admin functions you may well want to refer to them.

--

Then run the same SQL:

SELECT * FROM Information.Tables
ORDER BY Name

With one of your databases selected. Now you will see all your tables listed, together with their meta data.

The following SQL:

SELECT * FROM Information.TableColumns
ORDER BY TableName

Is similar but drills down to the column level in both cases.

Thanks Adam,
Appreciated.
Regards,
Ian