SCCM Logs infromation – specific logs are required either in log file or database table

Hello Team,

please help me get Below are the specific logs are required either in log file or database table.

1. Authentication logs : Any success or failure attempt on SCCM application. User details along with source should be captured.
2. Audit logs: Configuration Changes on SCCM application by admins should be captured.
3. Client Logs : which are the patches deployment status on endpoints successful, failed, pending etc.

If logs are present in database we need table name/view name, database name, database IP database etc.

pls help here asap.

thanks

Dinesh