prakaash2109

Just another WordPress.com site

SCCM 2007 SITE SYSTEM ROLES

SCCM 2007 Site System roles

 

  • Site Server – The server on which you install the SCCM software.
  • Site Database Server – The server running SQL and hosting the SCCM Site Database (only required for Primary Sites)
  • Configuration Manager Console – The interface for administering SCCM. Installed by default on Primary Site Servers this role can also be installed on workstations to allow remote administration.
  • SMS Provider – The intermediate Windows Management Instrumentation (WMI), layer that sits between the Configuration Manager Console and the Site Database (the Configuration Manager Console accesses the Site Database via the SMS Provider). Only required for Primary Sites.
  • Component Server – All SCCM Site System roles (except for the Distribution Point (DP)), requires SCCM-specific software to be installed in order for the Site System role to function.  When such software is installed on a computer that computer becomes a Component Server.
  • Distribution Point (DP) – Stores SCCM Packages from where Clients can access them to install them.  Only required for the Software Distribution, Software Updates, and Advertised Task Sequences functions of SCCM.
  • [NEW] Fallback Status Point – A “catch all” Site System for Clients that cannot be installed because of various issues such as assignment, or their inability to communicate with their Management Point (MP).  Not required by default, but recommended to help with Client installation issues.
  • Management Point (MP) – SCCM Clients do not communicate directly with the SCCM Site Server and vice versa.  Instead all communication is facilitated via the Management Point.  A Default Management Point needs to be defined in every Site that has Intranet Clients.
  • [NEW] Pre-boot Execution Environment (PXE) Service Point – The Site System that responds to any computers requesting deployment of their Operating System (OS), via a PXE request.  Only required if Operating System Deployments (OSD), are going to take place using PXE boot requests.
  • Reporting Point (RP) – Hosts the Report Viewer component that provides the web-based reporting functionality of SCCM. Only required if Reports need to be run on a particular Primary Site.
  • Server Locator Point (SLP) –  Responsible for informing SCCM Clients which MP they should access in order to install the SCCM Client software. Only required in some Client Deployment scenarios.
  • [NEW] Software Update Point (SUP) – Assigned to the computer running Windows Server Update Services (WSUS).  Only required if the Software Updates feature is going to be used.
  • [NEW] State Migration Point (SMP) – Stores the user’s state migration data when a computer’s OS is migrated.  Only required if the OSD feature is going to be used.
  • [NEW] System Health Validator Point (SHVP) – This role is assigned to the computer running the Network Policy Service.  Only required if the Network Access Protection (NAP) feature is going to be used.
Leave a comment »

AFTER DATABASE MIGRATION FROM SQL 2005 TO SQL 2008 CLUSTER SERVER, ERROR & SOLUTION

After database migration from sql 2005 to sql 2008 Cluster server, we are getting following error.

 

   
ERROR :   
   
  2012-02-21 19:46:00.110 Logon        Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: 172.16.28.114]
  2012-02-21 19:46:01.780 Logon        Error: 18456, Severity: 14, State: 11.
   
   
ERROR 2 :   
   
  CTriggerManager::Init – unable to get SQL connection
   
  *** [28000][18456][Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’.
   
  *** Failed to connect to the SQL Server.
   
   
   
Solution :   
   
  CMD -> run -> odbcad32 -> go to System DSN -> configure new database server here -> configuration -> client configuration -> Network libraries -> set to Named Pipes
Leave a comment »

HOW TO CHECK MANAGEMENT POINT STATUS IN SCCM

How to check Management point status in sccm

 

HTTP://<sccm server name>:80/SMS_MP/.SMS_AUT?MPCERT
           
           
HTTP://<sccm server name>:80/SMS_MP/.SMS_AUT?MPLIST
Leave a comment »

DAILY,WEEKLY & MONTLY MAINTENENCE TASKS IN SCCM SERVER.

Daily,Weekly & Montly maintenence tasks in sccm server.

 

Daily Maintenance Tasks
 
Applies To: System Center Configuration Manager 2007,
System Center Configuration Manager 2007 R2,
System Center Configuration Manager 2007 R3,
System Center Configuration Manager 2007 SP1,
System Center Configuration Manager 2007 SP2
 
Performing daily maintenance is important to ensure proper site operations.
 A daily maintenance log should be maintained to document dates that maintenance was conducted,
 by whom, and any maintenance-related comments about the task conducted.
 
Common Daily Maintenance Tasks
 
Some common daily maintenance tasks are listed below. Add any other maintenance tasks as needed to your daily maintenance log:
 
Verify that predefined maintenance tasks scheduled to run daily are running successfully.
 
Check Configuration Manager 2007 site database status.
 
Check site server status.
 
Check Configuration Manager 2007 site system inboxes for backlogs.
 
Check site systems status.
 
Check client status.
 
Check the operating system event logs on site systems.
 
Check the SQL Server error log.
 
Check system performance.
 
 
Weekly Maintenance Tasks
 
Applies To: System Center Configuration Manager 2007, System Center Configuration Manager 2007 R2, System Center Configuration Manager 2007 R3, System Center Configuration Manager 2007 SP1, System Center Configuration Manager 2007 SP2
 
Performing weekly maintenance is important to ensure proper site operations. A weekly maintenance log should be maintained to document dates that maintenance was conducted, by whom, and any maintenance related comments about the task conducted.
 
Common Weekly Maintenance Tasks
 
Some common weekly maintenance tasks are listed below. Add any other maintenance tasks as needed to your weekly maintenance log:
 
Verify that predefined maintenance tasks scheduled to run weekly are running successfully.
 
Delete unnecessary files from site systems.
 
Produce and distribute end-user reports if required.
 
Back up application, security, and system event logs and clear them.
 
Check the site database size and verify that there is enough available disk space on the site database server to allow the site database to grow.
 
Perform SQL Server database maintenance on the site database according to your SQL Server maintenance plan.
 
Check available disk space on all site systems.
 
Run disk defragmentation tools on all site systems.
Periodic Maintenance Tasks
 
Applies To: System Center Configuration Manager 2007, System Center Configuration Manager 2007 R2, System Center Configuration Manager 2007 R3, System Center Configuration Manager 2007 SP1, System Center Configuration Manager 2007 SP2
 
Performing periodic maintenance is important to ensure proper site operations. Some tasks do not need to be performed during daily or weekly maintenance, but are important to ensure overall site health and security and disaster recovery plans are up to date. A periodic maintenance log should be maintained to document dates that maintenance was conducted, by whom, and any maintenance related comments about the task conducted.
 
Common Periodic Maintenance Tasks
 
Some common periodic maintenance tasks are listed below. Add any other maintenance tasks as needed to your periodic maintenance log:
 
Review the security plan for any needed changes.
 
Change accounts and passwords if necessary according to your security plan.
 
Review the maintenance plan to verify that scheduled maintenance tasks are scheduled properly and effectively depending on configured site settings.
 
Review the Configuration Manager 2007 hierarchy design for any needed changes.
 
Check network performance to ensure changes have not been made that affect site operations.
 
Verify Active Directory settings affecting site operations have not changed. For example, you should ensure that subnets assigned to Active Directory sites used as boundaries for a Configuration Manager 2007 site have not changed.
 
Review the disaster recovery plan for any needed changes.
 
Perform a site recovery according to the disaster recovery plan in a test lab using a backup copy of the most recent backup snapshot created by the Backup ConfigMgr Site Server maintenance task.
 
Check hardware for any errors or hardware updates available.
 
Check overall health of site.

REF : http://technet.microsoft.com/en-us/library/bb632564.aspx
Leave a comment »

HOW TO CREATE BOUNDARIES IN PROTECTED MODE – SCCM

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.
Leave a comment »

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 :

Leave a comment »

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 :

Leave a comment »

COMMAND LINE FOR SOME SOFTWARE’S IN SCCM

Command line for some software distribution in SCCM

 
1) RealVNC : vnc-E4_2_9-x86_win32.exe /SP- /VERYSILENT /NORESTART

2) Putty : putty-0.60-installer.exe /sp- /silent

3)SQLYog : SQLyog714_1.exe /S

4) WinSCP : winscp416setup.exe /SILENT /NORESTART

5) Tortoise CVS : TortoiseCVS-1.6.14.exe /verysilent /norestart /sp-

6) Edit Plus : epp312.exe -s -sp-s

7) Apache Tomcat : apache-tomcat-6.0.14.exe /S /D=C:\MyTomcat
Note : /D is directory where tomcat needs to be installed, you can change drive letter as you wish.

8) Mozilla Firefox : “Firefox Setup 9.0.1.exe” -ms

9) WireShark : wireshark-win32-1.6.2.exe /NCRC /S /desktopicon=yes /quicklaunchicon=no /D=C:\Program Files\Foo
Note : /D is directory where tomcat needs to be installed, you can change drive letter as you wish.

These are the command lines you need to specify when creating program in SCCM. keeping in mind that you guys know creation of software distribution in SCCM.

Creating software distribution, refer this link : http://www.windows-noob.com/forums/index.php?/topic/499-how-can-i-deploy-an-application-in-sccm-2007/

Leave a comment »