| Author | 
         | 
         
      
        
         
         mdsmith Newbie 
          
 
  Joined: April 24 2019 Location: United States
 Online Status: Offline Posts: 14
          | 
        
         
          
           | Posted: October 19 2021 at 16:14 | IP Logged
		     | 
                    
            		  
           | 
           
          
           
  | 
           
          
Is there a way to retrieve data from the Event log to  
 variables i.e. ph_command? Or any other way?
         | 
       
       
        | Back to Top | 
         
          
         | 
       
       
       
        |   | 
      
        
         
         dhoward Admin Group 
          
  
  Joined: June 29 2001 Location: United States
 Online Status: Offline Posts: 4447
          | 
        
         
          
           | Posted: October 19 2021 at 22:36 | IP Logged
		     | 
                    
            		  
           | 
           
          
           
  | 
           
          
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 | 
         
          
          
         | 
       
       
       
        |   | 
      
        
         
         mdsmith Newbie 
          
 
  Joined: April 24 2019 Location: United States
 Online Status: Offline Posts: 14
          | 
        
         
          
           | Posted: October 20 2021 at 14:51 | IP Logged
		     | 
                    
            		  
           | 
           
          
           
  | 
           
          
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 | 
         
          
         | 
       
       
       
        |   |