Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 7 of 7 total |
Access the Log File |
Mon, Jun 4 2018 1:16 AM | Permanent Link |
Ian Branch | 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 |
Mon, Jun 4 2018 2:38 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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 |
Mon, Jun 4 2018 3:31 AM | Permanent Link |
Ian Branch | Hi Roy,
Ahhh. Fie on me. Didn't realise I had that source. Shall investigate. Regards & Tks, Ian |
Mon, Jun 4 2018 2:51 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Mon, Jun 4 2018 5:08 PM | Permanent Link |
Ian Branch | Ahhhh. As easy as that.
Tks Tim. Regards, Ian |
Tue, Jun 5 2018 9:13 AM | Permanent Link |
Adam Brett Orixa Systems | 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. |
Tue, Jun 5 2018 5:18 PM | Permanent Link |
Ian Branch | Thanks Adam,
Appreciated. Regards, Ian |
This web page was last updated on Wednesday, May 15, 2024 at 08:40 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |