Active TopicsActive Topics  Display List of Forum MembersMemberlist  Search The ForumSearch  HelpHelp
  RegisterRegister  LoginLogin
PowerHome General
 PowerHome Messageboard : PowerHome General
Subject Topic: Retrieving data from Event log Post ReplyPost New Topic
Author
Message << Prev Topic | Next Topic >>
mdsmith
Newbie
Newbie


Joined: April 24 2019
Location: United States
Online Status: Offline
Posts: 14
Posted: October 19 2021 at 16:14 | IP Logged Quote mdsmith

Is there a way to retrieve data from the Event log to
variables i.e. ph_command? Or any other way?
Back to Top View mdsmith's Profile Search for other posts by mdsmith
 
dhoward
Admin Group
Admin Group
Avatar

Joined: June 29 2001
Location: United States
Online Status: Offline
Posts: 4447
Posted: October 19 2021 at 22:36 | IP Logged Quote dhoward

Interesting...I was going to say use one of the ph_sql functions but realized that wont work since the eventlog has been moved to it's own
database file. Both the logs and other configuration used to be in the same file (and the functions would work) but people were having issues
with allowing the logs to grow so large the database would be unusable and would lose their configuration.

Ive added a note to the ToDo list to update the ph_sql functions with an overloaded parameter so you can execute SQL against the eventlog vs the
main database. I might also be able to make a dedicated function for extracting information. Can you give me some details on what you're looking
to pull from the eventlog and how you would like to access that data (datetime, keyword, etc)?

Thanks,

Dave.
Back to Top View dhoward's Profile Search for other posts by dhoward Visit dhoward's Homepage
 
mdsmith
Newbie
Newbie


Joined: April 24 2019
Location: United States
Online Status: Offline
Posts: 14
Posted: October 20 2021 at 14:51 | IP Logged Quote mdsmith

Dave,

Well as if you didn’t have enough to do. I’m needing info in
the Event Log to identify which inputs are activated using
Simply Automated UPB Controller and MUI32 I/O device. See new
posting. Here’s a screen shot of the Event Log, raw data
shown shows different data for each input active and not
active.
Can't upload picture getting an error, so see email..
Back to Top View mdsmith's Profile Search for other posts by mdsmith
 

If you wish to post a reply to this topic you must first login
If you are not already registered you must first register

  Post ReplyPost New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum