Here you will find the steps necessary to set or configure ConfigMgr 2007 Web Reports or ConfigMgr 2007 R2 Reporting options to open the selected reports within the console or with Internet Explorer.
1. Open the Configuration Manager console "System Center Configuration Manager"
2. Right mouse click on your "Site Database (Site_Code – Server_Name, Description) and from the context menu select "Report Options"
3. Then select “Open reports in a new window”
Note: This configuration change is console specific meaning that if you make the change on the site server it will not be set on your workstation console. Simply follow the same steps above provided you upgraded your workstation console to ConfigMgr 2007 R2 to open the reports in Internet Explorer.
Tip: From the Report Options dialog box you can also find the ConfigMgr Web Reports web page link (URL) and copy and pasted the link into your Internet browser to access the reports from IE. You can also see the Report Server NetBIOS name as well as set options to “Use Reporting Services Reports for Admin console report links”.
For additional information select “Help” on the “Report Options” dialog box.
The SQL Query here will allow you to retrieve information from your SQL Server installation pertaining to your TCP Endpoints.
SQL Query:
Select
Name 'Endpoint Name',
'Protocol' = Case
When Protocol = 1 Then 'HTTP'
When Protocol = 2 Then 'TCP'
When Protocol = 3 Then 'Name Pipes'
When Protocol = 4 Then 'Shared memory'
When Protocol = 5 Then 'Virtual Interface Adapter'
End,
Port,
'Type' = Case
When Type = 1 Then 'SOAP'
When Type = 2 Then 'TSQL'
When Type = 3 Then 'Service Broker'
When Type = 4 Then 'Database Mirroring'
'State' = Case
When State = 1 Then 'Stopped'
When State = 2 Then 'Disabled'
Else 'Started'
'Administrative Endpoint' = Case
When Is_Admin_Endpoint = 0 Then 'No'
When Is_Admin_Endpoint = 1 Then 'Yes'
IP_Address
From Sys.TCP_Endpoints
In the January 2010 Issue of TechNet Magazine Microsoft’s Steve Rachui has a great write up on System Center Configuration Manager: SQL Server Reporting Services and System Center Configuration Manager.
Check it out and drop by his blog page too.
SQL Server Reporting Services and System Center Configuration Manager
http://technet.microsoft.com/en-us/magazine/ee914611.aspx
Steve Rachui's Manageability blog - ConfigMgr/OpsMgr
http://blogs.msdn.com/steverac