What Websites are we Monitoring with SCOM?

Even though I love using Windows PowerShell, sometimes you just can’t beat diving into the database even for quick and dirty tasks.

Today I was asked to get a list of all the Websites running on Windows 2008, so since I had a connection open to my Operational Database server, I decided to use that.

 

use OperationsManager
select [Path], [Description_7FEEF780_F4BD_AF93_ED3F_F026EEAAEAEA], [LogFileDirectory_0499BCD1_1959_14CC_AEB8_0A5CC9AC09D3], [Path_21E71E34_E24F_B3EC_B0EB_4670B79C9382] from dbo.MT_Microsoft$Windows$InternetInformationServices$2008$WebSite as IIS
Inner Join BaseManagedEntity as BME on IIS.BaseManagedEntityId = BME.BaseManagedEntityId

 

Now if you’re only interested in finding out what websites a specific server monitors, then just add on a simple Where Clause…

use OperationsManager
select [Path], [Description_7FEEF780_F4BD_AF93_ED3F_F026EEAAEAEA], [LogFileDirectory_0499BCD1_1959_14CC_AEB8_0A5CC9AC09D3], [Path_21E71E34_E24F_B3EC_B0EB_4670B79C9382] from dbo.MT_Microsoft$Windows$InternetInformationServices$2008$WebSite as IIS
Inner Join BaseManagedEntity as BME on IIS.BaseManagedEntityId = BME.BaseManagedEntityId
where [Path] = ‘SERVERNAME.YOURDOMAIN.COM’

 
Comments

No comments yet.

Leave a Reply