Posted in
Windows Powershell |
No Comment | 2,448 views | 21/03/2015 12:28
These are IIS Website Binding Information properties that you can get using CIM via PowerShell.
1
2
3
4
5
6
7
8
| # Get WebSites
$WebSites = Get-CimInstance -Namespace "root\MicrosoftIISv2" -ClassName "IIsWebServerSetting" -OperationTimeoutSec 15 -EA Stop
$WebSite = $WebSites[0];
# WebSite Default Document Information
[string]$WebSiteEnableDefaultDoc = $WebSite.EnableDefaultDoc
[array]$WebSiteDefaultDocs = $WebSite.DefaultDoc.Split(",") |
# Get WebSites
$WebSites = Get-CimInstance -Namespace "root\MicrosoftIISv2" -ClassName "IIsWebServerSetting" -OperationTimeoutSec 15 -EA Stop
$WebSite = $WebSites[0];
# WebSite Default Document Information
[string]$WebSiteEnableDefaultDoc = $WebSite.EnableDefaultDoc
[array]$WebSiteDefaultDocs = $WebSite.DefaultDoc.Split(",")
You can find more properties in my blog.
Posted in
Windows Server |
No Comment | 2,710 views | 04/03/2015 10:36
If you want to see SQL Server Shrink status, you can use following query:
SELECT
percent_complete,
total_elapsed_time,
start_time,
status,
estimated_completion_time
FROM
sys.dm_exec_requests
WHERE
command = 'DbccFilesCompact' |
SELECT
percent_complete,
total_elapsed_time,
start_time,
status,
estimated_completion_time
FROM
sys.dm_exec_requests
WHERE
command = 'DbccFilesCompact'
You can execute this query via SQL PowerShell cmdlet.
This is also a reminder for me :)
home
projects
about
contact
follow
feed
settings
