Typical commands and tasks helpfull using Microsoft systems and applications.
Set-EmailAddressPolicy -EnabledEmailAddressTemplates 'smtp:%m@domain.local','SMTP:%g.%s@domain.com','smtp:%g.%s@domain2.com' -identity 'Default Policy' Update-EmailAddressPolicy -Identity "Default Policy"
domain.com is the default address.
Update the list:
Update-GlobalAddressList -Identity "Default Global Address List"
Configure a dedicated SMTP connector and allow relay on that using:
Get-ReceiveConnector "%NAMEOFCONNECTOR%" | Add-ADPermission -User "NT AUTHORITY\ANONYMOUS LOGON" -ExtendedRights "ms-Exch-SMTP-Accept-Any-Recipient"
French version:
Get-ReceiveConnector "%NAMEOFCONNECTOR%" | Add-ADPermission -User "AUTORITE NT\ANONYMOUS LOGON" -ExtendedRights "Ms-Exch-SMTP-Accept-Any-Recipient"
Since you’re not able to see Administrators mailbox in EMC. You can try from EMS running
Get-Mailbox –Identity <AdministratorsAlias> | fl
and see if you have exchange attributes for administrator account such as ProxyAddress, homeMDB, mail, mailNickname etc..
Disable-Mailbox -Identity %ADMINISTRATORALIAS% Clean-MailboxDatabase %MAILBOXDBNAME%
Now try to enable or create mailbox for administrator account you will be able to see the administrator account in Existing users Add list.
Get-MailboxDatabase "%MAILBOXDBNAME%" | Get-MailboxStatistics | Sort totalitemsize -desc | ft displayname, totalitemsize, itemcount
From the Exchange 2010 server:
.\AddReplicaToPFRecursive.ps1 -server "%EXCHANGE2010SERVER%" -TopPublicFolder "\" -ServerToAdd "%EXCHANGE2010SERVER%"
.\MoveAllReplicas.ps1 -Server "%EXCHANGE2003SERVER%" -NewServer "%EXCHANGE2010SERVER%"
Debugging:
To view a list of the replicas in the public folder hierarchy:
Get-PublicFolder -recurse |fl name,replicas
For System Folders:
Get-PublicFolder -recurse \non_ipm_subtree |fl name, replicas
To compare content replicated between the source and destination servers:
Get-PublicFolderStatistics
sqlcmd -S %SERVER%\%INSTANCENAME% -Q "BACKUP DATABASE [%DBNAME%] TO DISK = N'%PATHANDFILENAME%.bak' WITH NOFORMAT, NOINIT, NAME = N'%DBNAME Full Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10"
BACKUP DATABASE %DBNAME% TO DISK = '%PATHANDFILENAME.bak'
use master go Alter database %DBNAME% modify file (name = tempdev, filename = '%FILELOCATION%\%DBNAME%.mdf') go Alter database %DBNAME% modify file (name = templog, filename = '%FILELOCATION%\%DBNAME%.ldf') go
dbcc checkdb ('%DBNAME%') WITH ALL_ERRORMSGS
sp_who;
SQL SERVER 2005:
EXEC Sp_dtabases;
EXEC Sp_helpdb;
SQL SERVER 2000 - still works in SQL Server 2005:
SELECT name FROM sys.databases SELECT name FROM sys.sysdatabases
SQL Unofficial:
EXEC sp_msForEachDB 'PRINT "?"'
exec sp_MSforeachtable @command1="print '?' exec sp_spaceused '?'"
SELECT
t.NAME AS TableName,
p.rows AS RowCounts,
SUM(a.total_pages) * 8 AS TotalSpaceKB,
SUM(a.used_pages) * 8 AS UsedSpaceKB,
(SUM(a.total_pages) - SUM(a.used_pages)) * 8 AS UnusedSpaceKB
FROM
sys.tables t
INNER JOIN
sys.indexes i ON t.OBJECT_ID = i.object_id
INNER JOIN
sys.partitions p ON i.object_id = p.OBJECT_ID AND i.index_id = p.index_id
INNER JOIN
sys.allocation_units a ON p.partition_id = a.container_id
WHERE
t.NAME NOT LIKE 'dt%'
AND t.is_ms_shipped = 0
AND i.OBJECT_ID > 255
GROUP BY
t.Name, p.Rows
ORDER BY
UsedSpaceKB
select * from sys.dm_exec_sessions where session_id = @@SPID
sp_helpdb;
kill <spid>;
select name from sys.databases;
RESTORE DATABASE %DBNAME% WITH RECOVERY
USE master;
GO
ALTER DATABASE OLFWeb
SET SINGLE_USER
WITH ROLLBACK IMMEDIATE;
GO
dbcc checkdb ('OLFWeb', REPAIR_ALLOW_DATA_LOSS) WITH ALL_ERRORMSGS
ALTER DATABASE OLFWeb
SET MULTI_USER;
GO
RESTORE FILELISTONLY FROM DISK = 'd:\backupfile.bak'
RESTORE DATABASE %DBNAME% FROM DISK = 'drive:\backupfile.bak' with MOVE '%ORIGINALDBDATANAME%' to 'drive:\dbfile.mdf', MOVE '%ORIGINALDBLOGNAME%' to 'drive:\dblogfile.ldf', replace
Update logical name:
alter database %DATABASE% MODIFY FILE (NAME=%OLDLOGICALFILENAME%",NEWNAME=%NEWLOGICALFILENAME%")
use <dbname> DUMP TRANSACTION <dbname> WITH TRUNCATE_ONLY DBCC SHRINKFILE (2, 10);
On MSSQL 2k8:
USE %DBNAME%; DBCC SHRINKFILE(%DBLOGLOGICALNAME%,1);
To get %DBLOGLOGICALNAME%:
USE %DBNAME%; select name from sys.database_files;
If Full recovery model:
USE %DBNAME%; GO ALTER DATABASE %DBNAME% SET RECOVERY SIMPLE; GO DBCC SHRINKFILE (%DBLOGLOGICALNAME%, 1); ALTER DATABASE %DBNAME% SET RECOVERY FULL; GO
Start in single-user mode:
Stop MSSQL server service and run it in single mode:
sqlservr -c -f
Set the file size:
ALTER DATABASE tempdb MODIFY FILE (NAME = 'tempdev', SIZE = %NEWSIZE%) ALTER DATABASE tempdb MODIFY FILE (NAME = 'templog', SIZE = %NEWSIZE%)
Exit single-user mode and restart the MSSQL service
outlook /rpcdiag
outlook /resetfoldernames
netplwiz
powercfg -h off
kernrate -s 10
Go in command prompt and do the following:
set devmgr_show_nonpresent_devices=1 devmgmt.msc
Select View > Show Hidden Devices
Expand the Network Adapters tree
Right-click the dimmed network adapter, and then select Uninstall
Use the DevCon tool from Microsoft Knowledge Base: 311272 (http://support.microsoft.com/kb/311272/en-us)
msizap.exe G!
msizap.exe is in bin directory of Windows SDK or Platform SDK
To full disable hibernate function:
powercfg.exe /h off
Get-ExecutionPolicy
Set-ExecutionPolicy unrestricted
forfiles /p "%DELPATH%" /s /m *.* /d -%DAYS% /c "cmd /c del @path"
set tmp=%* set tmp=%tmp:/=\% echo %tmp
Test-NetConnection -Port %PORT% -computer %HOSTNAME%
To delete unnecessary SP files after install of SP1:
cd c:\Windows\System32\ compcln.exe
To delete recovery of updates:
compcln.exe
change user /INSTALL
change user /EXECUTE
net stop "Windows update" DISM.exe /Online /Cleanup-image /Restorehealth net start "Windows update"
W32tm /config /manualpeerlist:peers /syncfromflags:manual /reliable:yes /update net stop w32time net start w32time
Check synchro:
w32tm /stripchart /computer:%HOSTNAME%
Service tag dell
wmic bios get serialnumber
Reset attributes attrib -s -h -r “C:\Users\exampleusername”
Display open files:
Openfiles /Query
WSUS: Purge / Delete corrupted or Un-needed patches on WSUS Server WSUSDebugtool /tool:purgeunneededfiles
New-RoutingGroupConnector -Name “2010-2003” -SourceTransportServers “Ex2010Hub1.contoso.com” -TargetTransportServers “Ex2003BH1.contoso.com” -Cost 1 -Bidirectional $false -PublicFolderReferralsEnabled $true New-RoutingGroupConnector -Name “2010-2003” -SourceTransportServers “Ex2003BH1.contoso.com” -TargetTransportServers “Ex2010Hub1.contoso.com” -Cost 1 -Bidirectional $false -PublicFolderReferralsEnabled $true
Get-RoutingGroupConnector| FL
pstools \ psexec
for /f "eol=; tokens=1" %%N in (directories.txt) do cacls.exe "d:\data\users\%%N" /T /E /G DOMAIN\%%N:F >> c:\temp\subinacllog.txt
ROBOCOPY.exe \\SERVER\f$\PATH D:\LOCALPATH /e /zb /copyall /r:1 /w:1 /purge /LOG:c:\temp\robocopy.txt
http://www.sqldbpros.com/2010/11/sql-server-rebuild-indexes-the-fastest-way/
web.config connectionStrings encryption:
cd c:\windows\Microsoft.Net\framework\v4.0.XXXX
Encrypt
aspnet_regiis -pef "connectionStrings" "D:\webistes\leDossierDuSiteContenantLeFichierACrypter"
Decrypt
aspnet_regiis -pdf "connectionStrings" "D:\webistes\leDossierDuSiteContenantLeFichierADérypter"
Display IIS worker processes PID %windir%\system32\inetsrv\appcmd list wp
Dump disk or pen drive:
dd.exe --progress if=\\.\Volume{0b1a0cbe-11da-11c0-ab53-003045c00008} of=pendrive.img bs=4096
Check IOPS and accessed files: resmon.exe