So I don’t have to spend 2 hours searching for this yet again:
sp_change_users_login @Action = 'Report'

And, for those using WSUS looking for some nifty queries:
SELECT [LastReportedStatusTime],
[IPAddress],
[FullDomainName],
[ComputerModel],
[BiosVersion]
FROM [SUSDB].[dbo].[tbComputerTarget] order by ComputerModel, BiosVersion

SELECT COUNT([IPAddress]),
[ComputerModel],
[BiosVersion]
FROM [SUSDB].[dbo].[tbComputerTarget] group by ComputerModel, BiosVersion order by ComputerModel


Update 08/29/2005:
SELECT COUNT([LastReportedStatusTime]) AS Number,
[FullDomainName]
FROM [SUSDB].[dbo].[tbComputerTarget] group by FullDomainName order by Number DESC

Looks like MS had some issues with the initial release of the Win2k SP4 Rollup package. They have expired the original update and released a new one, so if you think you’ve approved it, you haven’t.

It only took me 10 minutes of searching around on the web to figure out that I wasn’t going insane.

If you are integrating the Update Rollup 1 for Windows 2000 SP4 into a network share to install from a DOS boot floppy, you are going to get
Setup was unable to copy the following files:
errors for several files. The way to fix this, according to knowledge base article 890206 is to edit DOSNET.INF and remove all the lines in the [Files] section that have d1,UNIPROC in them. You might also want to remove the lines that have d1,wms.
You’d think someone would have tested this before shipping this out the door….

Why is it that the A/C never dies at a good time?

Those are internal server temps, so it’s not all that bad but it did have to happen just before the end of the day, after the HVAC service guy had left for the day. He came back in and fixed things up, so we owe him a favor or two.

Time to get a standby A/C installed there.

Even farther back.
I was a senior at Hoopeston Area High School, my boss was installing wiring for CITES (then CCSO), the guy who I replaced in my current position was the “original nettech”.
A year and a half later, 18 Oct 1995, here were the counts of active URHNet connections:

The latest tally of total (active) URHnet connections, as counted
from the bootp tables:
Allen 101
CRH 386 (six contiguous Champaign halls)
FAR 168
ISR 301
LAR 20
PAR 131
Triad 12
TVD 50
TOTAL 1,169
At this time last year, the total was 391: an increase of 299%

Last fall, we probably passed that total within a few hours of opening.

Every once in a great while, you must say thank you to people like Tim Skirvin for archiving those things that later on turn out to be quite funny. Thank you for being a never ending pack rat, Tim.

(This won’t be funny to anyone outside Housing, without some explanation, but that’s fine with me.)

I love simple SQL.

select COUNT(id) as Count,FROM_UNIXTIME(MIN(oob_time_sec)) as MIN,FROM_UNIXTIME(MAX(oob_time_sec)) as MAX,INET_NTOA(ip_saddr), tcp_dport, udp_dport,icmp_type from ulog where FROM_UNIXTIME(oob_time_sec) > DATE_SUB(CURDATE(), INTERVAL 28 DAY) group by ip_saddr,tcp_dport,udp_dport order by ip_saddr;