Duplicate output records are discarded. These are simple queries, but they are good example that this log tool is more powerful for analyzing syslog events than any other event log viewer.

For more samples, you can always look in examples provided with the program. There are many additional resources for learning about and using Log Parser on the Internet. Please check the following links. SquaredUp Dashboard Server allows connecting and aggregating data from just about any data source and presenting the information in As with previous releases, VMware vSphere 7 has kept alarm management. The vSphere 7 alarms are useful for day-to-day Pulseway enables you to monitor, manage, and control their environments with a cloud-based solution.

This post looks at new In this review of VirtualMetric, we take a look at the features that allow monitoring, inventory management, change control, AdRem Software's NetCrunch solution is a compelling monitoring solution that provides many great features to monitor your environment. Are you looking for a way to ensure that your business doesn't end up in tomorrow's headlines due to As a powerful tool, PowerShell is not only of interest for admins but also for hackers.

To detect suspicious NetCrunch is an easy-to-use and configure enterprise-grade monitoring solution. Your email address will not be published. Notify me of followup comments via e-mail.

You can also subscribe without commenting. Receive new post notifications. Will you deploy Windows 11 to end users in your organization in ?

View Results. Member Leaderboard — Month. Member Leaderboard — Year. Author Leaderboard — 30 Days. Author Leaderboard — Year. The new protocol is all about performance and security. Leos Marek posted an update 4 hours, 2 minutes ago. Leos Marek posted an update 4 hours, 3 minutes ago. Paolo Maffezzoli posted an update 8 hours, 57 minutes ago. Paolo Maffezzoli posted an update 8 hours, 58 minutes ago.

Paolo Maffezzoli posted an update 8 hours, 59 minutes ago. Please ask IT administration questions in the forums. Any other messages are welcome. Fortunately there is an example called Distinct Users that is almost exactly what I was looking for. It will just need a few tweaks. I brought the Distinct Users query up, copied it and pasted it into my new query. Those of you that have done any SQL queries will recognize the format immediately. They are standard TSQL queries.

This query works out of the box, but it needs some tweaking for my situation. First I needed to change what was being counted. The example looks for the number of distinct values in cs-username. Since this is a blog that is read anonymously, that column will always be empty.

Instead, I'm using the c-ip column, which is the client IP address. If you're running these queries in a collaboration environment, using cs-username might make more sense. Since I'm restricting my query to a single month of logs, I need to change my query to reflect that. I changed the FROM line to this:. This tells Log Parser to parse all the logs from September of If your IIS logs are in a different directory you'll have to adjust this line accordingly.

Next I needed to add a WHERE command to filter out all the logs from other parts of my web site that are not part of my blog. I don't want to pad my stats, after all. I added the following line to the bottom:. Now my whole query looks like this:.

To run it, I clicked Generate you can also hit F5 in the toolbar. Here's what the results looked like:. The results show that in the month of September 11, distinct IP addresses accessed my blog. To expand the months included, alter the FROM command.

I'll also through a command in to sort the IP addresses. The new query would look like this:. Like I mentioned before, in a collaboration environment usernames are probably more important than IP addresses. To get a sorted list of users that have hit your site, replace c-ip with cs-username.

This could be very useful to determine which users are hitting a site or even a specific document, like an HR document. Let's look at some of the other queries I ran. The next was how many people are subscribed to my blog.

This is just a modified version of my previous query. The query looks like this:. Next was which IPs were hitting my site the most. It's just a further extension of the stuff I had already done. I used the following query:. No real surprises, the IP addresses I get the most hits from are search engines and aggregators. As a corollary I wanted to see what the sites that referred others to me were. This query gave me that information:. For my blog the main referrers were other posts in my blog, and a few posts from other people's blogs.

Another related query is which URLs are hit the most on my site. Altering my query a little I came up with this:. My next question was how much data have I served up? Here's what I used:. The IIS logs saves the sc-bytes data as bytes. That's really not much help to me, so I divided it by twice to go from bytes to kilobytes to megabytes. The results looked like this:. This was mainly just to see if there s.

Again LPL came to the rescue. It had a query I could already use.