My company does not have a Windows Server with Splunk Enterprise so I cannot use the Splunk Add-on for SCOM to ingest the data. I would like to use the database instead but I dont know what data from tables to send like the add-on performs. Can someone help?
Direct reads from SCOM Database was introduced in Splunk Add-on for Microsoft SCOM 4.3.0 (https://docs.splunk.com/Documentation/AddOns/released/MSSCOM/Direct)
@trifonesplunk For collecting from database tables you can use DB Connect App (https://splunkbase.splunk.com/app/2686/).
But I don't have much idea about SCOM database tables and what tables to bring in.
But with DB Connect you can run SQL queries to find out what tables a database contains and what tables could be useful to you, etc.