Exclude servers from client push installation in SCCM

REF : http://technet.microsoft.com/en-us/library/bb693996.aspx

When you add a computer to the ExcludeServers list, it is flagged with a status of installed, which prevents the client from reinstalling by using the automatic site-wide client push installation method. If you later remove the computer from the exclude list, this flag remains. To change this status to uninstalled, you must run the clear install flag task. You can view the install status for a client on the General tab of the Resource Properties dialog box. To open this dialog box, right-click a computer in the Configuration Manager console, and then click Properties. The item Client in the Discovery data list indicates the install status of the client.

Use the following procedures to add computers to the exclude list and to run the clear install flag task if this task is necessary.

To add computers to the exclude list to prevent client software from being installed using automatic site-wide client push

1. Open the Windows Registry Editor on the Configuration Manager 2007 site server that hosts the site that you want to exclude a computer from joining.
2. Locate the SMS_DISCOVERY_DATA_MANAGER sub-key by browsing to the following path:
   • For a 32-bit operating system: HKEY_LOCAL_MACHINE/Software/Microsoft/SMS/Components/SMS_DISCOVERY_DATA_MANAGER
     
   • For a 64-bit operating system: HKEY_LOCAL_MACHINE/Software/Wow6432Node/Microsoft/SMS/Components/SMS_DISCOVERY_DATA_MANAGER
     
3. To enter the name of the computers you want to exclude, double-click the key ExcludeServers to open the Edit Multi-String window.
4. In the Edit Multi-String window, specify the NetBIOS name of each computer you want to exclude. Press the Enter key after typing each computer name to ensure that each computer name appears on a separate line.
5. After you have entered the computer names of computers you wish to exclude, click OK. Close the Registry Editor window.

To clear the Install Flag so that client software will install

1. In the Configuration Manager console, navigate to System Center Configuration Manager /Site Database/ Site Management / <site code> - <site name>/ Site Settings / Site Maintenance / Tasks.
2. Double-click Clear Install Flag to open the Clear Install Flag Properties dialog box.
3. In the Clear Install Flag Properties dialog box, specify the following:
   • Select the checkbox to enable the clear install flag task.
     
   • Set the schedule to control how often the task runs.
     
4. Click OK to close the Clear Install Flag Properties dialog box.

HTTP 500 Internal Server Error when accessing SCCM Reports

If you are receiving HTTP 500 Internal Server Error when accessing SCCM Reports via web browser, check the following settings:

1. Make sure that you are not hitting the limit of maximum rows returned by a report query. By default, report viewer in SCCM 2007 is configured to limit the results returned by a report query to 10 000 rows.

32 bit : To change the number of rows returned by a report query, create theRowcount DWORD value under theHKEY_LOCAL_MACHINE\Software\Microsoft\SMS\Reportingregistry key.

        64 Bit : On reporting points that run on a 64-bit operating system, navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\SMS\Reporting.

Create new DWORD (32 bit ) value as shown in picture.

Set its value to the number of rows that you want returned in the report query. If you want to return all rows, set the value to 0xffffffff, which is the hexadecimal equivalent of –1.

For more information, refer to the following TechNet article: How to Configure the Maximum Rows Returned by a Report Query, available at the: http://technet.microsoft.com/en-us/library/bb680885.aspx

2. Increase the ASP response buffer limit size (aspbufferinglimit).

In IIS 6.0 change has been introduced which limits a default ASP response buffer to 4 MB. Increasing the buffer limit might help you in resolving this problem. To increase the buffer limit, follow these steps:

• Click Start, click Run, type cmd, and then click OK.
• Type the following command, and then press ENTER:

cd /d %systemdrive%\inetpub\adminscripts

• Type the following command, and then press ENTER:

cscript.exe adsutil.vbs SET w3svc/aspbufferinglimit LimitSize

LimitSize represents the buffering limit size in bytes. For example, the number 67108864 sets the buffering limit size to 64 MB.

To confirm that the buffer limit is set correctly, follow these steps:

•   Click Start, click Run, type cmd, and then click OK.
• Type the following command, and then press ENTER:

cd /d %systemdrive%\inetpub\adminscripts

• Type the following command, and then press ENTER:

cscript.exe adsutil.vbs GET w3svc/aspbufferinglimit

In my case, setting the limit to the value of 12582912 (12 MB) did the trick in the Configuration Manager environment of approximately 10 000 managed devices (SCCM Clients).

For more information about the ASP response buffer limit, refer to the following article: Error message when a Web browser sends a request for an active server page to a Web server that is running IIS 6.0: “Response buffer limit exceeded”, available at the:http://support.microsoft.com/kb/925764

MP Issue : FATAL MSI Error – mp msi could not be installed. ( server 2008 R2 )

MP ISSUE : FATAL MSI Error – mp msi could not be installed. ( server 2008 R2 )

Cause :  There is problem with bits installation, verify SMS_MP_CONTROL_MANAGER component error,

Solution : 

Open -> server manager -> add feautures -> under background intelligent transfer services ( BITS ) installed,

Verify and enable check box -> IIS Server Extension ( installed ) and confirm, as shown in picture below,

Now

Reset IIS service -> cmd -> iisreset, once iis reset is done,

Re-install Management point again, now verify mpsetup.log (C:\Program Files (x86)\Microsoft Configuration Manager\Logs\mpsetup.log )

Useful SCCM Reporting

Query to get all report in console :

SQL Query : 


SELECT [ReportID]
      ,[SecurityKey]
      ,[Name]
      ,[Comment]
      ,[Category]
      ,[SQLQuery]
      ,[GraphType]
      ,[GraphCaption]
      ,[GraphXCol]
      ,[XColLabel]
      ,[GraphYCol]
      ,[YColLabel]
      ,[DrillThroughReportID]
      ,[MachineDetail]
      ,[MachineSource]
      ,[RefreshInterval]
      ,[DrillThroughURL]
      ,[StatusMessageDetailSource]
  FROM [SCCM2007R3].[dbo].[v_Report]
------------------------------------------------------------------------------------------
Workstation UP Time :


SQL Query :


SELECT     TOP (100) PERCENT os.Caption0 AS 'Operating System', cs.Name0 AS Name, DATEDIFF(hour, os.LastBootUpTime0, ws.LastHWScan) AS 'Uptime (in Hours)',
                      CONVERT(varchar(20), os.LastBootUpTime0, 100) AS 'Last Reboot Date/Time', CONVERT(varchar(20), ws.LastHWScan, 100) AS 'Last Hardware Inventory'
FROM         dbo.v_GS_WORKSTATION_STATUS AS ws LEFT OUTER JOIN
                      dbo.v_GS_OPERATING_SYSTEM AS os ON ws.ResourceID = os.ResourceID INNER JOIN
                      dbo.v_GS_COMPUTER_SYSTEM AS cs ON cs.ResourceID = os.ResourceID
WHERE     (ws.LastHWScan <> 0) AND (cs.Name0 IS NOT NULL) AND (os.Caption0 LIKE '%xp%') OR
                      (os.Caption0 LIKE '%7%') OR
                      (os.Caption0 LIKE '%vista%')
ORDER BY Name


---------------------------------------------------------------------------------------------

Report to find Non-Compliance software's in Organisation :


SQL Query,

This report will show you application list other than what you specified in this query,i added compliance software's MS Office,Adobe Air, etc.,


SELECT DISTINCT
  v_R_System.Netbios_Name0,
  ARP.DisplayName0,
  ARP.Version0,
  ARP.InstallDate0,
  ARP.ProdID0,
  HWSCAN.LastHWScan as "Last SCCM Hardware Scan"
FROM
  v_R_System
  JOIN v_GS_ADD_REMOVE_PROGRAMS ARP on v_R_System.ResourceID = ARP.ResourceID
  JOIN v_FullCollectionMembership on v_R_System.ResourceID =

v_FullCollectionMembership.ResourceID
  LEFT JOIN v_GS_WORKSTATION_STATUS HWSCAN on v_R_System.ResourceID =

HWSCAN.ResourceID
WHERE
  v_FullCollectionMembership.CollectionID = @CollID and
  (ARP.DisplayName0 Not like '%Microsoft Office%')and
  (ARP.DisplayName0 Not like '%Adobe AIR%')  and
  (ARP.DisplayName0 Not like '%Configuration Manager Client%')and
  (ARP.DisplayName0 Not like '% Mozilla Firefox%')and
  (ARP.DisplayName0 Not like '%LiveUpdate %')and
  (ARP.DisplayName0 Not like '%Skype%')
ORDER BY v_R_System.Netbios_Name0

Note : Set promt for select collection,

-------------------------------------------------------------------------------------------
SCCM Report to find Torrent installed machines list :


SQL Query : 


SELECT DISTINCT
RSYS.Name0 AS 'Computer',
RSYS.User_Name0 As 'Last User ID',
SF.FileName As 'File Name',
SF.FileDescription As 'File Description',
SF.FilePath As 'File Path',
SF.FileSize As 'File Size',
SF.FileVersion As 'File Version'
FROM
V_R_SYSTEM RSYS
INNER JOIN V_GS_SoftwareFile SF
ON RSYS.ResourceID = SF.ResourceID
AND (
SF.FileName Like '%Azureus%'
Or SF.FileName Like '%BitComet%'
Or SF.FileName Like '%BitLord%'
Or SF.FileName Like '%BitPump%'
Or SF.FileName Like '%BitTornado%'
Or SF.FileName Like '%BitTorrent%'
Or SF.FileName Like '%Shareaza%'
Or SF.FileName Like '%Utorrent%'
)
ORDER BY
RSYS.Name0

Output :

--------------------------------------------------------------------------------------------------

SCCM Report to get Primary partition less than 1GB on C: drive

SQL Query :


Select
SD.Name0 'Machine Name',
SD.User_Name0 'User Name',
LD.FreeSpace0 'Free Space'
From v_R_System SD
Join v_Gs_Logical_Disk LD on SD.ResourceId = LD.ResourceId
Where LD.DeviceId0 = 'C:'
And LD.FreeSpace0 < 1024
And SD.Client0 = 1

Tag : Web Report

Report to get Hostname and Username using SCCM

Query :

SELECT distinct sys.Netbios_Name0 ComputerName, sys.user_name0,ipsub.IP_Subnets0, ip.defaultIPGateway0, sys.AD_site_name0 ADSite
from v_R_system sys inner join v_GS_Network_Adapter_Configur IP on sys.ResourceID=IP.ResourceID inner join v_RA_System_IPSubnets ipsub on sys.ResourceID=ipsub.ResourceID
where sys.resource_domain_or_workgr0 = 'OM' and sys.obsolete0=0 and ip.defaultIPGateway0 is not NULL and ipsub.IP_Subnets0 is not NULL;

Output :

How to create boundaries in Protected mode - SCCM

Site Database -> Site Management -> Site code -> Site Settings -> Site Systems -> server name -> Configmgr Site system -> properties

Select boundary range and OK.