IIS LogParser – Hits in last 7 Days

Here’s an IIS LogParser query I’ve written that will output the top hits for your website within the last 7 days. All you need to do is change the path of the log file location: SELECT COUNT(*) AS Hits, cs-uri-stem AS Page FROM D:LogFilePat*.* WHERE TO_DATE(Date) >= TO_DATE(SUB(SYSTEM_TIMESTAMP(), TO_TIMESTAMP(’01-07′, ‘MM-dd’))) GROUP BY cs-uri-stem ORDER BY…


IIS ODBC Logging Event ID 1016 (error data 80070057)

“The World Wide Web Publishing Service (WWW Service) did not configure logging for site X. The data field contains the error number.” This warning will show up in your System event logs and you custom IIS logging to a SQL database won’t work. Obviously the message is fairly cryptic, however in a facepalm sort of…


Which hotfixes should I apply?

  This is updated as of 10-31-2018   In general – you should evaluate all hotfixes available, and only apply those applicable to your environment.  However, some of these below I have seen impact almost every environment, and should be heavily considered. This list is nothing official…. this is just a general list of the…


PowerShell: Remove Files based on date

I’ve had the need to remove a bunch of differential backup images from my backup server for a short while now – and thought this was the perfect opportunity to crack into powershell. I’m going to post the script and run through the important parts: dir C:BACKUP -recurse -exclude SERVER1,SERVER2,SERVER3,SERVER4,SERVER1.IMG,SERVER2.IMG,SERVER3.IMG,SERVER4.IMG,FileClean.PS1 | where { ((get-date)-$_.creationTime).days -ge…


Changing Company Wide AD mapped Home Drives

This is a quick and easy way to change all of your users mapped home drives without manually editing every user. This is really helpful if your migrating to a new file server. dsquery user “OU=XYZStaff,OU=XYZOU2,OU=XYZOU1,dc=XYZCorp,dc=local” | dsmod user -hmdrv Z -hmdir XYZ-FileServerStaff$USERNAME$ Simply, the dsquery grabs all of the user accounts in the XYZStaff…


Audit User Logon and Logoff

A quick and easy way to audit your users login times (and some other details) is by using this simple login script method. Firstly, you need to build two .BAT file scripts and save them to some sort of Audit share on a server. (I suggest hiding the share with the $ so users can’t…


Deploying Office 2007 Compatibility pack via Group Policy

Since Microsoft released 2007 and the new .*x file format there have been some compatibility problems – sure you can save your documents in the “old” 2003 format – but you loose some of the extra functionality available for 2007 users. Microsoft released an installer to resolve these problems allowing 2003 users to open 2007…


Don’t be afraid of DNS Scavenging. Just be patient.

DNS Scavenging is a great answer to a problem that has been nagging everyone since RFC 2136 came out way back in 1997.  Despite many clever methods of ensuring that clients and DHCP servers that perform dynamic updates clean up after themselves sometimes DNS can get messy.  Remember that old test server that you built…

68

MaxUserPort – what it is, what it does, when it’s important

What can we say about MaxUserPort that hasn’t already been said? Not a lot, it would seem. He’s a beautiful dancer, perhaps? Ahh, such gentle humour, and nary a kitten drowned anywhere. But TCP port shenanigans are fairly frequently misunderstood, so let’s talk about the very basics of MaxUserPort. NB: This is all pre-Vista behaviour…


From crush to product documentation: The story of Squeaky Lobster

When customers first hear about being able to enable extra JET Blue or ESE Database performance counters via adding a “Squeaky Lobster” registry value, they often think it must be a joke or ask you to repeat it.  And invariable the question comes up … _why_ “Squeaky Lobster”?  Various lore or conjecture has surfaced around…