How to create Custom Report SQL Server
It is the first time that I use this site, I apologize if I am posting it in a wrong place.
So, I need to create a Custom Report of SQL Server but just logs coming from Windows Event Logs because I am collecting just Windows Event Logs from this server.
Anybody can help me?
Hi Mr. Manzo,
Really don't care how the LOG's are coming. You can filter the data according to your needs. Before you construct your query in report, you can test it in ANALYSIS-->QUERY
For MSSQL data in Windows LOG, you can search in Windows Level Table and filter by EventLog = Application and EventSource = like 'MSSQL%' as you can see below.
You must get something like:
Even, you can refine the search as you need.
When you get the information what you are looking for, then use that info in the Query field of the report.