To show all MSSQL databases except the normal system databases.
select * from sys.databases WHERE name NOT IN ('master', 'tempdb', 'model', 'msdb');
To show all MSSQL databases except the normal system databases.
select * from sys.databases WHERE name NOT IN ('master', 'tempdb', 'model', 'msdb');
For en liste over alle mail adresse
Get-recipient -resultsize unlimited | select name -expand emailaddresses | select name,smtpaddress
For en liste over alle mail adresse på et given domæne
Get-Recipient | Where{$_.EmailAddresses -match "it-grp.dk"} | select name -expand emailaddresses | select name,smtpaddress | where {$_ -match "kennethdalbjerg.dk"}