Use Powerbi to analyze our mail and send logs!

Before reading the article, let's have a bowl of chicken soup:

There is a time to see Lu Yu about the program, interview Gao Xiaosong, then Gao Xiaosong said such a passage:

Used to think that 40 perplexed means, to the 40-year-old, you understand everything, to 40-year-old, found completely not the meaning, 40 perplexed means you do not understand the matter, you do not want to understand, do not take the time to toss, but in the young, you always want to understand this thing, around the people, things, Include this era, you want to understand, but when you are older, you find this is impossible, perhaps in your side, even if the person sitting opposite you, you may not understand.

Now near perplexed, it is very reasonable to find that he says so, because a lot of people really do. Many people to the age of 30 years after the beginning will not be updating the knowledge, more immersed in their own is already a master of narcissism, in a word, many people died 20 years old, but 70-year-old burial. In fact, in this time of our life, the information is too much, but most of the people's way of thinking is already too old, we must be prepared enough to carry out our information iteration, to keep up with this era.

Return to the theme, we come today to tell you today's theme, today's theme is what? Analyze our data logs with Powerbi to analyze our current server health. If not healthy, where is not healthy? is not healthy because of God horse reason? This may be what we are trying to figure out in our hearts.

What tools did we use to analyze the problem before we did it in most of the way? Most may be analyzed by log parse, or by a chart generated by PowerShell.

Today we bring a chart analysis artifact,-----PowerBI.

Many people can not understand, why Powerbi used to analyze the log, then how to analyze? And listen to my slow way:

1. First we download the Powerbi website, as follows:

https://powerbi.microsoft.com/zh-cn/

2. Next we download and then install the icon on the desktop:

3. Next we copy the logs we need to analyze from the server. Everybody look at these are God horse logs? One is the message tracking log, one is the RPC connection log, and the other is the mail send log. Finally, we have the IIS logs, and we analyze the 4 logs accordingly.

4. Because these logs are too large, we need to use other software open, such as Notepad, or UltraEdit to open our log to see, we first open the next message tracking log, we found that the delimiter is a comma, so we can be separated based on the number:

5. Next we open our Powerbi and click Get CSV in the data:

6. Select our message track for analysis:

7. We are able to find that the data has been formatted, confirm that basically no problem, we can click OK:

8. We followed the analysis of the status of the mail, we are very able to clearly see our e-mail problems, the failure rate of mail is quite high:

9. Next we carry out the email sender's analysis, we found that postmaster's message failure rate is quite high:

10. Next we will analyze the recipient message scale:

11. Next, we will put our data in the lower part of our presentation page, we can see our data, there are three columns:

12. In fact, the current four of our presentation data have been linked, here we have a certain correlation of these data, and now I look at postermaster send more, we have to point postermaster analysis, the results found that there is a large number of spam, We should buy anti-spam equipment:

Use Powerbi to analyze our mail and send logs!