LOG Parser – IIS LOGS Analysis

In this post I will show some examples how to collect information from IIS Logfiles. For this porpuse I will use LogParser version 2.2.

You can download here – http://www.iis.net/community/default.aspx?tabid=34&g=6&i=1976 and read more about it here http://technet.microsoft.com/en-us/library/bb878032.aspx

From command prompt run LogParser.exe /? for Help menu.

Using Mount Points in a Microsoft SQL Cluster Server Environment

When we use an Cluster for supporting SQL Instances in medium or bigger organizations we will have some TeraByte of data. Our Infra-Structure must be prepared to grow and in some times to grow faster without the possibility of stopping to improve or migrate, so there are some Advantages of using the NTFS volume mount points feature in a Microsoft Cluster Server Environment, such as:

Analysis System Failure: Stop error Reason Code: 0x805000f

I had this problem a few days ago, and this information might help you.

Clear all messages in queue with certain subject

From powershell run this command:

Get-Message | where {$_.Subject -like “Place here the text”} | Remove-Message -WithNDR $false

If you are not shore about the text don’t Forget to type something like this “*LOAN*”, this will include all messages that have the loan word in the subject.

Dsquery List members for all groups

Open Command prompt and use dsquery to export to txt the data to a TXT file.

dsquery * -limit 0 -filter “(&(objectCategory=group))” -attr name member > a.txt

Change default profile folder Location

Some times we can´t control what users have in profiles so we need to avoid that the %systemroot% be with no space available.

We can change the default location to another disk. To do it we can change in registry, “ProfilesDirectory” Location.

HKEY_LOCAL_MACHINE
SOFTWARE\Microsoft\Windows NT\CurrentVersion\ProfileList]

Just change it to the location that you pretend such as “d:\users”.

Hope that this can be useful.

Backup Persistent Routes

Routes added by using the -p option are stored in the registry under the following key:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip \Parameters\PersistentRoutes

To backup you just need to export this Key.

Removing Auto Detect Proxy Settings From GPO.

A few days ago I add to remove proxy settings from Default Domain GPO, this particulary option “Automatically detect configuration settings”.

After enabling this option, we can only choose bettween Enabled or disabled.

The way to get rid of this configuration is simple, you only need to reset proxy settings.

Be carefull where you execute this action, because it will clear everything related to proxy settings, and don’t Forget to backup GPO’s before making any changes.

Hope this can be usefull.