Derek Murawsky derekmurawsky

## forfiles.bat
REM Deletes files in specified path older than X days.
forfiles -p "C:\path\to\files" -s -m *.* -d -360 -c "cmd /c del @path"

REM Alternate way to do it. Deletes all files in current directory older than X days.
forfiles -s -m *.* -d -360 -c "cmd /c del @path"

## CreateUserAndAddToGroup
net user UserName Password /ADD /FULLNAME:"Full Name" /PASSWORDCHG:Yes /EXPIRES:never /ACTIVE:yes /COMMENT:"Comment"
net localgroup GroupName UserName /add

## gist:7548383
DECLARE @UserName sysname;
DECLARE @NameToAdd sysname;
DECLARE @S nvarchar(1000)

SET @UserName = 'User Name';
SET @NameToAdd = @@SERVERNAME + '\' + @UserName;

-- Create a login using windows auth
--set @s = 'CREATE LOGIN ' + quotename(@NameToAdd) + ' FROM WINDOWS;'
--exec (@S)

## gist:7553658
<?xml version="1.0" encoding="UTF-8"?>
<configuration>
<location path="." inheritInChildApplications="false">
    <system.webServer>
		<rewrite>
			<rules>
                <clear />
                <rule name="Root Hit Redirect" enabled="false" stopProcessing="true">
                    <match url="^$" />
                    <conditions logicalGrouping="MatchAll" trackAllCaptures="false" />

## gist:7582042
# One of the many useful command line options discussed here: http://office.microsoft.com/en-us/outlook-help/command-line-switches-for-outlook-2010-HP010354956.aspx

outlook.exe /resetfoldernames

## gist:7581990
From: http://www.sevenforums.com/tutorials/49819-icon-cache-rebuild.html

ie4uinit.exe -ClearIconCache
taskkill /IM explorer.exe /F
DEL "%localappdata%\IconCache.db" /A
shutdown /r /f /t 00

## gist:7751173
EXEC sp_grantlogin 'BUILTIN\Administrators'
EXEC sp_addsrvrolemember 'BUILTIN\Administrators','sysadmin'

## gist:7751196
sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'clr enabled', 1;
GO
RECONFIGURE;
GO

## gist:7758750
# CertUtil - Key must be in a .KEY file and must have the same base file name as the cert.
certutil –MergePFX certfile.cer certfile.pfx

# Old method, using OpenSSL
openssl pkcs12 -export -inkey MyCert.pem -in MyCert.crt -out MyCert.p12

## gist:7873501
certutil -repairstore my "SerialNumber"
	REM Deletes files in specified path older than X days.
	forfiles -p "C:\path\to\files" -s -m . -d -360 -c "cmd /c del @path"

	REM Alternate way to do it. Deletes all files in current directory older than X days.
	forfiles -s -m . -d -360 -c "cmd /c del @path"
	net user UserName Password /ADD /FULLNAME:"Full Name" /PASSWORDCHG:Yes /EXPIRES:never /ACTIVE:yes /COMMENT:"Comment"
	net localgroup GroupName UserName /add
	DECLARE @UserName sysname;
	DECLARE @NameToAdd sysname;
	DECLARE @S nvarchar(1000)

	SET @UserName = 'User Name';
	SET @NameToAdd = @@SERVERNAME + '\' + @UserName;

	-- Create a login using windows auth
	--set @s = 'CREATE LOGIN ' + quotename(@NameToAdd) + ' FROM WINDOWS;'
	--exec (@S)
	<?xml version="1.0" encoding="UTF-8"?>
	<configuration>
	<location path="." inheritInChildApplications="false">
	<system.webServer>
	<rewrite>
	<rules>
	<clear />
	<rule name="Root Hit Redirect" enabled="false" stopProcessing="true">
	<match url="^$" />
	<conditions logicalGrouping="MatchAll" trackAllCaptures="false" />
	# One of the many useful command line options discussed here: http://office.microsoft.com/en-us/outlook-help/command-line-switches-for-outlook-2010-HP010354956.aspx

	outlook.exe /resetfoldernames
	From: http://www.sevenforums.com/tutorials/49819-icon-cache-rebuild.html

	ie4uinit.exe -ClearIconCache
	taskkill /IM explorer.exe /F
	DEL "%localappdata%\IconCache.db" /A
	shutdown /r /f /t 00
	EXEC sp_grantlogin 'BUILTIN\Administrators'
	EXEC sp_addsrvrolemember 'BUILTIN\Administrators','sysadmin'
	sp_configure 'show advanced options', 1;
	GO
	RECONFIGURE;
	GO
	sp_configure 'clr enabled', 1;
	GO
	RECONFIGURE;
	GO
	# CertUtil - Key must be in a .KEY file and must have the same base file name as the cert.
	certutil –MergePFX certfile.cer certfile.pfx

	# Old method, using OpenSSL
	openssl pkcs12 -export -inkey MyCert.pem -in MyCert.crt -out MyCert.p12