consolidate empty AD sites

Excellent script to consolidate

http://blogs.technet.com/b/ashleymcglone/archive/2011/02/11/consolidate-all-ad-empty-sites-into-a-single-sitelink-using-powershell.aspx

XenApp 4.5 Summary Database Query stuff

Thanks to XENWIZ for the most of the code, SQL Query which I then export to CSV.

Point to Summary Database
Modify date
Grab important stuff like  appname, server, clientname, username, start time


SELECT LU_APPNAME.APPNAME,LU_SERVERNAME.SERVERNAME, SDB_SESSION.SESSIONSTART, SDB_SESSION.SESSIONEND, LU_CLIENT.CLIENTNAME, LU_USER.USERNAME
FROM
LU_APPNAME, SDB_SESSION, LU_USER, LU_SERVERNAME, LU_SERVER, LU_CLIENT
WHERE
LU_APPNAME.PK_APPNAMEID = SDB_SESSION.FK_APPNAMEID
AND LU_USER.PK_USERID = SDB_SESSION.FK_USERID
AND SDB_SESSION.FK_SERVERID = LU_SERVER.PK_SERVERID
AND LU_SERVERNAME.PK_SERVERNAMEID = LU_SERVER.FK_SERVERNAMEID
AND SDB_SESSION.FK_CLIENTID = LU_CLIENT.PK_CLIENTID
AND LU_CLIENT.CLIENTNAME != 'Console'
AND SDB_SESSION.SESSIONSTART Between '2011-10-27 14:00:00.000' and '2011-10-28 14:00:00.000'
ORDER BY SDB_SESSION.SESSIONSTART

The 'console' connection was causing my stats be a bit loopy.

also get a few blank appnames which I should exclude.

RDP Black Logons

we had a Win2k3 server crashed due to not enough hard disk space.
[HKEY_USERS\.DEFAULT\Control Panel\Colors]
All values for the keys were 0 0 0 (black).

set back to defaults, and we were back working

thanks to esoltan + google for the fix

Windows 7 64bit Network Freezing

So, had a issue where my laptop which is running windows 7 64bit and the network was freezing copying large files.

On the laptop

• ipv4/ipv6
• virutalbox
• citrix access gateway plugin

The symptoms were large copies were freezing with 0kb/s

removed virutalbox and able to copy files again.

If i get time to investigate then look into if issue between CAG plugin and Virutalbox.

Update:

so the problem came back for some reason, also seems my virtualbox didn't uninstall correctly.

1. only did part..

http://answers.microsoft.com/en-us/windows/forum/windows_7-networking/very-slow-200kbsec-file-copy-between-win7-machines/b8736b1b-0a91-4567-ba33-215084ffc906

a. Running as Administrator in Command Prompt, type: "netsh int tcp set heuristics disabled"

b. Next, follow the instructions that Amrita wrote above.

                  First enter: "netsh int tcp set global autotuninglevel=disabled" and reboot.

2. mucked around with the settings in intel network card properties (latest driver)

wmic “Invalid XSL format (or) file name.”

So on my windows 7 box trying to:

wmic product get /format:csv

produces a output:

Invalid XSL format (or) file name.

Located teh csv.xsl file in C:\windows\system32\wbem\en-US

Guessed that it was unable to locate the xsl format file...

so copied it to the local path and it worked !

Confirmed this with Process monitor :-(

It seems to be looking for the correct locale so I added a C:\windows\system32\wbem\en-US to C:\windows\system32\wbem\en-AU

since we all don't live in the US of A... :-|

Alternative options are:

I just copied to C:\windows\system32\wbem\en-US\*.xls to C:\windows\system32

android dhcp loop

Sometime your android's wireless can get stuck in a dhcp address loop

>$ su

# cd /data/misc/dhcp

# rm dhcpd-wlan0.lease

Splunk AD Filtering

...\splunk\etc\system\local

## props.conf

[WMI:WinEventLog:Security]

TRANSFORMS-evtlog = wmi-null,wmi-filter,wmi-filter28user,wmi-filter28SecGrp,wmi-filter28DlGrp

## transforms.conf

[wmi-null]

REGEX = .

DEST_KEY = queue

FORMAT = nullQueue

[wmi-filter]

REGEX=(?msi)^(CategoryString=Account Management)

DEST_KEY = queue

FORMAT = indexQueue

[wmi-filter28user]

REGEX=(?msi)^(CategoryString=User Account Management)

DEST_KEY = queue

FORMAT = indexQueue

[wmi-filter28SecGrp]

REGEX=(?msi)^(CategoryString=Security Group Management)

DEST_KEY = queue

FORMAT = indexQueue

[wmi-filter28DlGrp]

REGEX=(?msi)^(CategoryString=Distribution Group Management)

DEST_KEY = queue

FORMAT = indexQueue