Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Tools Development

User login

Frontpage Sponsor

Main

Poll
What do you expect from your SI Implementation partner for the success of ERP implementation.
Bring best practices - Not to offer more CR's Leveraging standard functions
0%
Need more honesty to work with the Users until their processes are fully mapped & Users are trained
100%
Focus on process automation/ integrations/ Real time data/ BI analytics
0%
Stick to basics
0%
Total votes: 1

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 1st September 2022, 02:32
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,696
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
Baan 4c4 Question and Splunk software for compliance
Baan: Other/Unknown
C/S: None/Unknown

Does anybody use this Splunk Software with 4c4? As far as I can tell this tool wants sql queries to ready log file tables in our oracle database. As far as I know all our log files are basically in $BSE/log. They want us to monitor for privileged activity - like changing parameters, system setup or changes. I know we could audit some tools tables - but again the activity goes out to a file on the unix system - and I really do not want to turn that one for more tables.
__________________
Mark

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
Sponsored Links
  #2  
Old 7th September 2022, 21:03
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,696
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
Well infor said 4c4 was not supported and we can try it on our own. I think they use queries to reach in and pull log information from tables - not sure I see a way to easily do that.
__________________
Mark

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
  #3  
Old 20th September 2022, 09:13
OmeLuuk's Avatar
OmeLuuk OmeLuuk is offline
Guru
 
Join Date: Mar 2002
Location: Belgium
Posts: 1,219
OmeLuuk is on a distinguished road
Baan: Infor LN 6.1 10.2.1 > 10.7 - DB: MS SQL2017 - OS: VM WindowsServer2016
Quote:
Originally Posted by mark_h View Post
... wants sql queries to read log file tables ...
I suppose they are talking about transaction logs within the database? There you could retrieve all database transactions and monitor selected tables. IMHO, with knowledge of auditing, ttaad4100 log and 4c4/LN I would say: use the available tools. Downside is that backdoor changes (within Oracle) cannot be monitored.
__________________
Also read Luke 24:4-8
Reply With Quote
  #4  
Old 20th September 2022, 14:04
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,696
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
Well the DBA's have back door access covered. If I logged into the database using pl/sql using like BSP oracle they would know it and track it. Then one of my managers would have to say it is okay. With SPLUNK they are looking for me to write a query and put it in splunk. Assuming I got this right - this query would pull across records like - last login attempt, invalid logins, anything a privilege's accounts changed on application setup or users. Things like that.

So I could turn on table logging for like baan users, I could write a session that would run and read the audit file and pull certain things into a table. But all of that is over kill in my mind for a 90% read only system - we still have 2 more years to process 2017, 2018 via Billable cost reports. Once that is done I have a feeling baan itself would disappear and all the records would move to a warehouse.
__________________
Mark

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +2. The time now is 01:19.


©2001-2022 - Baanboard.com - Baanforums.com