How to collect DNS Settings From Servers With SQL Report

How to collect DNS Settings From Servers With SQL Report  :

1. go to Administration and client Settings ==> Hardware inventory ==> set classes
2. Network Adapter configuration (Win32_NetworkAdapterConfiguration)
3. select   (Wins Secondary server  , Wins Primary server ,DNS Host Name , DNS Server Search order )
4. SQL Report 

SELECT  dbo.v_GS_SYSTEM.Name0 AS [System Name],
 dbo.v_GS_OPERATING_SYSTEM.Caption0 AS [Operating System],
 dbo.v_GS_OPERATING_SYSTEM.CSDVersion0 AS [Service Pack],
        dbo.v_GS_OPERATING_SYSTEM.InstallDate0 AS [Original OS Install Date],
 dbo.v_GS_OPERATING_SYSTEM.LastBootUpTime0 AS [Last Boot Time],
 dbo.v_GS_NETWORK_ADAPTER_CONFIGUR.IPAddress0 AS [IP Address],
 dbo.v_GS_NETWORK_ADAPTER_CONFIGUR.IPSubnet0 AS [Subnet Mask], 
 dbo.v_GS_NETWORK_ADAPTER_CONFIGUR.DefaultIPGateway0 AS [Gateway],
        dbo.v_GS_NETWORK_ADAPTER_CONFIGUR.DNSServerSearchOrder0 AS [DNS Servers],
        dbo.v_GS_NETWORK_ADAPTER_CONFIGUR.WINSPrimaryServer0 AS [Pri WINS],
        dbo.v_GS_NETWORK_ADAPTER_CONFIGUR.WINSSecondaryServer0 AS [Sec WINS],
        dbo.v_GS_PC_BIOS.SMBIOSBIOSVersion0 AS [System ROM Version], dbo.v_GS_PC_BIOS.ReleaseDate0 AS [System ROM Date]
FROM    dbo.v_GS_NETWORK_ADAPTER_CONFIGUR INNER JOIN
        dbo.v_GS_OPERATING_SYSTEM ON
        dbo.v_GS_NETWORK_ADAPTER_CONFIGUR.ResourceID = dbo.v_GS_OPERATING_SYSTEM.ResourceID INNER JOIN
        dbo.v_GS_PC_BIOS ON dbo.v_GS_OPERATING_SYSTEM.ResourceID = dbo.v_GS_PC_BIOS.ResourceID INNER JOIN
        dbo.v_GS_SYSTEM ON dbo.v_GS_PC_BIOS.ResourceID = dbo.v_GS_SYSTEM.ResourceID
where  v_GS_SYSTEM.Name0 LIKE @variable and v_GS_NETWORK_ADAPTER_CONFIGUR.IPaddress0 is Not Null

Prompt

Name: Variable

Prompt Text: Collection ID

Provide a SQL Statement is checked

command = SELECT CollectionID, Name FROM v_Collection

Add New Distribution point & Distribution point Group & Boundary in SCCM 2012

Distribution Point Requirements:

1.            Internet Information Services

2.            Background Intelligent transfer services ( From Add New Features )

Note : downside  20 connections Max

3.            From your SCCM Server ===>administration ====>Site Configuration====>Right click on Servers and Site system Roles ====> Create Site System server

 4 . from browse chose your New DPServer
 5 . chose your site Code

 6 . add account that have administration privilege 

 7. chose Distribution point From System Role Selection

     

8 . Chose install and configure IIs If Required by Configuration Manager

9 . Validate content

helps to prevent content from becoming corrupt

10 . From Boundary Group you can add if you have or create or leave it blank

We will create new one called HQ

11 . Now we add new DP

12 . Boundaries and Boundaries Group 

For Boundaries  Group specify the network speed for each site system server associated to the Boundaries  group 

 13 . In Hierarchy settings 

you can specify a fallback site for client assignment for clients that are not in a Boundaries Group

Good Luck 

Add New management point in SCCM 2012

Management Point Requirements :

1. Internet Information Services
2. Background Intelligent transfer services ( From Add New Features )
3. From your SCCM Server ===>administration ====>Site Configuration====>Right click on Servers and Site system Roles ====> Create Site System server

 4 . from browse chose your New MP Server
 5 . chose your site Code

 6 . add account that have administration privilege 

 7. chose Management Point From System Role Selection

     

 8 . chose Generate alert When the Management Point is not healthy

    

 9 . you Can verify Your MP From the  internet explore write the below link

• For mixed mode clients, use the following: http://<ServerName>/sms_mp/.sms_aut?mplist, where <ServerName> is the NetBIOS name for the management point computer.
• For intranet-based, native mode clients, use the following: https://<ServerName>/sms_mp/.sms_aut?mplist, where <ServerName> is the FQDN for the management point computer if an FQDN is specified in the site system properties or the short name if an FQDN has not been specified.
• For Internet-based clients, use the following: https://<ServerName>/sms_mp/.sms_aut?mplist, where <ServerName> is the Internet FQDN for the Internet-based management point computer.

  Important
  If a site is configured to use a custom Web site, the custom port must also be used, as in the following example: http://<ServerName>:<port>/sms_mp/.sms_aut?mplist.

•  Verify MPsetup.log. Make sure MP is install successfully, if not resolve the problem. If you find any problem in MPSetup.log, then verify MPMSI.log

Regards 

Mohamed gamal 

 

how to test management point sccm 2012

from internet explore write the below link

• For mixed mode clients, use the following: http://<ServerName>/sms_mp/.sms_aut?mplist, where <ServerName> is the NetBIOS name for the management point computer.
• For intranet-based, native mode clients, use the following: https://<ServerName>/sms_mp/.sms_aut?mplist, where <ServerName> is the FQDN for the management point computer if an FQDN is specified in the site system properties or the short name if an FQDN has not been specified.
• For Internet-based clients, use the following: https://<ServerName>/sms_mp/.sms_aut?mplist, where <ServerName> is the Internet FQDN for the Internet-based management point computer.

  Important
  If a site is configured to use a custom Web site, the custom port must also be used, as in the following example: http://<ServerName>:<port>/sms_mp/.sms_aut?mplist.

•  Verify MPsetup.log. Make sure MP is install successfully, if not resolve the problem. If you find any problem in MPSetup.log, then verify MPMSI.log

For More information
http://technet.microsoft.com/en-us/library/bb932118.aspx