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