PowerShell script to check WDS Service status against of List of servers.

Below is a PowerShell script, this will list WDS Service status against of List of servers.

Below is a powershell script will list WDS Service status againest of List of servers.

$InPutComputersList = get-content "c:\MyScripts\list.txt"
$OutPutFile = "c:\MyScripts\WDS_ServiceStatus.csv"
$NotReachble = "c:\MyScripts\NonPingSystems.csv"
$listResult = @()
foreach($ForEverComputerIntheTextFilelinebyLine in $InPutComputersList) {
if (test-path \$ForEverComputerIntheTextFilelinebyLine\c$\windows\write.exe)
{
$objService = Get-Service WDSServer -ComputerName $ForEverComputerIntheTextFilelinebyLine | select machinename, status, name, displayname

$objResult = New-Object PSObject -Property @{
ComputerName = $ForEverComputerIntheTextFilelinebyLine
ServiceStatus = $objService.Status
ServiceDisplayName = $objService.DisplayName
ServiceName = $objService.Name

}
$listResult += $objResult
}
Else
{
Write-Output "$ForEverComputerIntheTextFilelinebyLine,NotReachable" | out-file $NotReachble -append
}
}
$listResult| Export-Csv -Path $OutPutFile

SCCM 2012 Replication – What is replicated in each type From where to where

There are TWO types of replication can happen

1) Database Replication
2) File-Based Replication

Database Replication Includes Global Data & Site Data

Global data that replicates by using database replication.

Site data that replicates by using database replication.

Note:- Apart from above two there is local data this is just to specific to the local site.

Global data includes below : these are flow from CAS to below the Hierarchy

Alert rules

Client discovery

Collections rules and count

Configuration Items metadata

Deployments

Operating system images (boot images and driver packages)

Package metadata

Program metadata

Site control file

Site security objects (security roles and security scopes)

Software updates metadata

System Resource List (site system servers)

Site Data Replication: These are from Client to reporting/assigned Site

Alert messages

Asset Intelligence client access license (CAL) tracking data

Client Health data

Client Health history

Collection membership results

Component and Site Status Summarizers

Hardware inventory

Software distribution status details

Software inventory and metering

Software updates site data

Status messages

Status summary data

File-Based Replication: Earlier products there was only one type of Replication and this is file type. Now with SCCM 2012 this was limited two below types, Mainly used for Software packages and software updates.

File content that replicates by using file-based replication.

File based Data	To the Destination
Package files used by deployments	Sent to primary and secondary sites.
Data from secondary sites	Sent to the primary site (parent) of the secondary site.
Fallback status point state messages	Forwarded to the assigned site when only a single fallback status point is in use.
Discovery data records	Forwarded to the assigned site when not processed at the site where they are generated.

SCCM 2012 Client Push – Pre Requirement (HotFix)

The hotfix described in KB2552033 must be installed on site servers that run Windows Server 2008 R2 when client push installation is enabled.

For package pre-stage in 2012

On dp take the check box as pre stage

From package right click create "prestage content file" to create the package
This will create the .pkgx file.
Get the file extractcontent.exe from bin/x64

Run the below command

extractcontent.exe /p:e:\path of .pkgx files /s

These two steps will distribute the package as pre-stage method

Setupwpf.exe /script

Configmgrautosave.ini

Script to check the drive space in the server against the threshold value and triggers an alert

Script to check Disk Space
#Purpose: Script to check the drive space in the server against the threshold value and triggers an alert
#powershell script for disk space monitoring

$computer = get-content -path .\list.txt #get-content env:computername; #Get the server name
$percentWarning = 50; # Store the percentage warning threshold
$disks = Get-WmiObject -ComputerName $computer -Class Win32_LogicalDisk -Filter "DriveType = 3";
$mailbody = "The following drive(s) have less than $percentWarning% free sapce in Server,Please cleanup: $computer`n`n";
$mailbody+="Drive`t`tTotalspace(GB)`t`t`Freespace(GB)`n ________________________________________________________________________ `n";
$drivedata="";
$emailsubject="$computer - Low Disk Space Alert!";

# Code to send email to the File Server Owners
function SendEmail([string]$msg)
{
$SMTPClient = new-object System.Net.Mail.smtpClient;
$SMTPClient.host = "smtp.Domain.com"
$MailMessage = new-object System.Net.Mail.MailMessage;
$MailMessage.Subject = $emailsubject;
$MailMessage.Body = $msg;
$MailMessage.From = "SCOMN_No_Reply@Domain.com";
$MailMessage.To.add("ToJhon@Domain.com");
$SMTPClient.Send($MailMessage);
}

#The following block performs the core functionality
foreach($disk in $disks)
{
$deviceID = $disk.DeviceID;
[float]$size = $disk.Size;
[float]$freespace = $disk.FreeSpace;
$percentFree = [Math]::Round(($freespace / $size) * 100, 2);
$sizeGB = [Math]::Round($size / 1073741824, 2);
$freeSpaceGB = [Math]::Round($freespace / 1073741824, 2);
if($percentFree -lt $percentWarning)
{
$drivedata += "$deviceID`t`t $sizeGB`t`t`t$freeSpaceGB`n";
}
}
#Email to be sent only if any drive has free space less than threshold value
if($drivedata.length -gt 0)
{
$msg=$mailbody+$drivedata;
SendEmail($msg);
}

Source:- http://www.sharepointdiary.com/2012/11/drive-space-monitoring-using-powershell.html

Migrate reports from SCCM 2007 to SCCM 2012

sync SSRS report between two report servers:

The built-in migration wizard in ConfigMgr 2012 can migrate most objects but not reports. In ConfigMgr 2012 classical ASP reports (as we know them from earlier versions) are no longer supported.
Migrate the classical reports to SQL Reporting Services in SCCM 2007
Below is a walk thru of how you migrate your existing classical reports to SQL reporting Services in SCCM 2007. Notice that you will still be able to run all classical reports after the migration.

On you SCCM 2007 site server install either SCCM 2007 R2 or SCCM 2007 R3, both will add SQL Reporting Services support for SCCM 2007.
In the ConfigMgr. console, navigate to Site Database, Site Management, A01 (where A01 is the sitecode), Site Systems. Right click the Site system server that will become a Reporting Services Point and click New Roles. Select Reporting Services Point and finish the wizard using the default values.
In the ConfigMgr. console, navigate to Site Database, Computer Management, Reporting, Reporting Services, and expand the node.
Right-click SCCM1 (where SCCM1 is the name of your server), and then click Properties.
On the Data Source Settings tab, specify SCCM1 as the database server and SMS_A01as the database name (where SMS_A01 is the name of your SCCM 2007 database. ClickTest.
On the Data Source Authentication tab, select Windows integrated security.
Click OK.

Copy reports to SQL Reporting Services

Right-click SCCM1, and select Copy Reports to Reporting Services.
On the Data Source Settings page, accept the default settings, and click Next.
On the Data Source Authentication page, accept the default settings, and click Next.
On the Select Reports page, accept the default settings, and click Next.
On the Security page, accept the default settings, and click Next.
On the Summary page, click Next.
On the Progress page - once all of the reports have copied - click Next and then clickClose.

Migrate the SCCM 2007 reports to SCCM 2012
You can’t use the built-in migration tools to migrate reports from SCCM 2007 to SCCM 2012. This leaves you with two choices; 1) Download each RDL file one by one from SCCM 2007 and upload them to SCCM 2012 or 2) Use one of the free community tools that can download multiple folders at the time. In my last project I used this tool – ReportSync - to assist me.

Launch ReportSync
In Source server type in the name of the SCCM 2007 Report server in form of http://CM01/ReportServer. Provide credentials and click Load
In Destination server type in the name of the SCCM 2012 Report server in form of http://CM02/ReportServer. Provide credentials and click Load
Select the folders or individual reports you want to migrate and click Sync
Once the process is finished click OK and your reports are now ready in SCCM 2012.
This tool keeps the old Data source which will generate an error the first time you run the report.
Open the report properties (by clicking on the report link)
Select Data Sources, click Browse and select the shared SCCM 2012 data source. The data source is found in Home\ConfigMgr_Sitecode. The data source is the object with long GUID. Select the data source click OK and Apply.
Run the report and verify that it works. There is no guarantee the all SCCM 2007 reports work out of the box in SCCM 2012.

Download link : http://code.google.com/p/reportsync/downloads/list

All credits goes to Kent.

SCCM 2012 Replication Data

From SCCM 2012 site to site replication is moved to SQL replication, Where as in SCCM 2007 it was file based.

Below chart explains the What kind of Data type will be replicated between sites with Replication Types.

What is there in Global Data & Site Data ?

When do we need a CAS (Central Administration) 2012 Site

If you have more than one Primary Site in a single hierarchy
For Central Reports and administration for your primary sites management.

Question:- Can i install CAS on existing SCCM 2007 Server?

No it is recommended to install on new (hardware) box

When do we need a local Distribution Point? In SCCM 2012?

Below are the three key points to consider a local distribution Point’s

BITS not enough to control the WAN traffic
Multicast for Operating System Deployment
To stream APP-V Applications

Ok.. Now when we do not need a local Distribution points in SCCM 2012?

Below are the key considerations…

Clients are well managed with-in BITIS provided control for WAN traffic
If BranchCache deployed(below points are pre-requirements for BranchCache)
- DP’s on 2008 R2
- Vista Sp2 with KB960568 and above OS’s(windows7 & 8)

Note:- Distribution Point role can be enabled on Client OS or Server OS.
Note:- Branch Distrubution Point Role is removed in SCCM 2012.

When do we need a Secondary Site – SCCM 2012

Below are the three key considerations to setup a secondary site.

To manage Upward-flowing WAN traffic

Tiered content Routing for deep network topologies

No local administrators

When do I need SCCM 2012 Primary Site?

To Manage Clients/Devices
Add More Primary sites for

To scale more than 100,000 Clients
Reduce impact of primary site failures in case of DR(Disaster recovery)
Local Point of Connectivity for Administration & Political Reasons
Content Regulations

Ok….. When you do not need a primary site compared with SCCM 20007 ?

Decentralized administration
Logical data segmentation
Client settings
Language Settings
Content routing for deep hierarchies

What is Empower Users in SCCM 2012

Enabling any device from any where

Changes from SCCM 2012 to SCCM 2012 SP1

Below are the changes from SCCM 2012 to SCCM 2012 SP1

What is Windows To Go?

Windows To Go is a feature in Windows 8 Enterprise that allows Windows 8 Enterprise to boot and run from mass storage devices such as USB flash drives and external hard disk drives.It is a fully manageable corporate Windows 8 environment. Using Group Policy, Windows Store can be enabled for a Windows To Go workspace (limited to one PC) and Store apps can be used on that workspace.

Is windows 8 supported for sccm ?

Yes from sccm 2012 sp1. The bad news is windows xp no more supported.

Read this related to windows 8 support .... Into

One of the most significant changes is support for Windows 8 for Configuration Manager clients. Configuration Manager SP1 supports Windows 8 in the following ways:

You can install the Configuration Manager client on Windows 8 computers and deploy Windows 8 to new computers or to upgrade previous client operating versions. Configuration Manager also supports Windows To Go.

You can configure user data and profiles configuration items for folder redirection, offline files, and roaming profiles.

You can configure new deployment types for Windows 8 applications, which support stand-alone applications (.appx files) and links to the Windows Store.

Configuration Manager supports Windows 8 features, such as metered Internet connections and Always On Always Connected.

What is not changed in sccm 2012 when compared with sccm 2007 ?

Wake on LAN

Windows Embedded devices

The Active Directory schema extensions for System Center 2012 Configuration Manager are unchanged from those used by Configuration Manager 2007. If you extended the schema for Configuration Manager 2007, you do not need to extend the schema again for System Center 2012 Configuration Manager.

What is Application management in sccm ?

Provides a set of tools and resources that can help you create, manage, deploy, and monitor applications in the enterprise.

Why you want sccm ?

You can perform all below with help of sccm:

Deploy operating systems, software applications, and software updates.

Monitor and remediate computers for compliance settings.

Monitor hardware and software inventory.

Remotely administer computers.

High level Task Sequence Steps for Windwos Xp to 7

These are the some high level steps in the Task Sequence.

use USMT=>request store=>run additional commands like taking backup of some applications..may be Lotus notesècapture user state/scan state èrelease state storeèdisable bitlocker if activatedèset Migration Flag to MigratedèStart System in PEè Partition Diskèactivate/Enable AHCIèEnable or Set BIOS password è Enable TMP for Bitlocker pre-requirementèRestart Computer èActivate TPMèrestart ComputerèRemove Bios PasswordèApply OSèwindows SettingsèNetwork SettingsèApply Drivers(use WQL or Thin Installer or HP SoftPaq or Dynamic Drivers Apply with CAB File packagesèSetup SCCM ClientèFix any issues related to SCCM Client like run auto discovery of site codeèBIOS version check and updateèrestartèinstall Few Runtime app’s like Adobe Flash/Shockwave/or any softwaresè install other apps like fonts/AV/Adobe/VPNClient/Customise Settings like Branding/look and feelèSet USMT Store options with /config: config.xml fileèRequest state StoreèRestore user storeèrun any custom configs like Lotus Notesèreleases state Storeè Enable Bitlocker encryption/Prepare Bitlocker Partition(c:\windows\system32\bdeHDcfg.exe -target default –quiet)èInstall any updatesèFinal Restart.

WAIK Renamed to Windows ADK

Windows Automated Installation Kit (Windows AIK or WAIK) is a collection of tools
It has renamed to "Windows ADK" New name from Windows 8.

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

PXE-E53: No boot filename received

PXE-E53: No boot filename received

everythink ok.. when checked
- Both the Boot Images are sent to WDS

Found one red Event in the application Events with event ID 258

executed below command to resolve the issue..

wdsutil /initialize-server /REMINST:"E:\remoteinstall"

PXE boot issue : DHCP.......................

We might get the error when trying to boot the client pxe boot as dhcp.......... Lot of dots with no dhcp ip to the pxe client...

Solution would be check the wds windows deployment service status or give a try to restart the service

Disable services on list of servers

Below script will be useful for disabling the services

'create a file called list.Txt
Set Fso = CreateObject("Scripting.FileSystemObject")
Set InputFile = fso.OpenTextFile("list.Txt")
Do While Not (InputFile.atEndOfStream)
sComputer = InputFile.ReadLine
aTargetSvcs= Array("WDSServer")
'For list of services use below...
'arrTargetSvcs = Array("service1", "service2", "service3")

Set oWMIService = GetObject("winmgmts:" & "{impersonationlevel=impersonate}!\\" _
& sComputer & "\root\cimv2")
Set cServices = oWMIService.ExecQuery("SELECT * FROM Win32_Service")

For Each oService In cServices
For Each sTargetSvc In aTargetSvcs
If LCase(oService.Name) = LCase(sTargetSvc) Then

   If oService.State <> "Stopped" Then
    oService.StopService()
   End If
   If oService.StartMode <> "Disabled" Then
    oService.ChangeStartMode("Disabled")
   End If
End If
Next
Next
loop
MsgBox "Done"

Microsoft System Center products list

Microsoft System Center is a set of server products aimed specifically at helping corporate IT administrators manage a network of Windows Server and client desktop systems.

1. System Center Advisor – Software as a service offering that helps change or assess the configuration of Microsoft Servers software over the Internet

2. System Center App Controller - Unified management for public and private clouds, including cloud-based virtual machines and services

3. System Center Configuration Manager – Configuration management, hardware/software asset management, patch deployment tools for Windows desktops (previously Systems Management Server)

4. System Center Data Protection Manager – Continuous data protection and data recovery
System Center Endpoint Protection - Anti-malware and security solutions for Microsoft products

5. System Center Essentials – Combined features of Operations Manager and Windows Software Update Service (WSUS), aimed at small and medium sized businesses
System Center Mobile Device Manager – Mobile device management (PDAs, smartphones, etc.)

6. System Center Opalis - Opalis is an automation platform for orchestrating and integrating IT tools to decrease the cost of datacenter operations while improving the reliability of IT processes. It enables IT organizations to automate best practices, such as those found in Microsoft Operations Framework (MOF) and Information Technology Infrastructure Library (ITIL). Opalis operates through workflow processes that coordinate System Center and other management tools to automate incident response, change and compliance, and service-lifecycle management processes.

7. System Center Orchestrator - (formerly Opalis) for orchestration and automation solutions

8. System Center Operations Manager – Services and application monitoring

9. System Center Reporting Manager

10. System Center Service Manager – Ties in with SCOM, SCCM for asset tracking as well as incident, problem, change and configuration management (code name: Service Desk)

11. System Center Virtual Machine Manager 2008 R2 – Virtual machine management and datacenter virtualization

SMSTS.ini

Debugging for sccm logs with in the winpe to enable... use SMSTS.ini file.

SMSTS.ini

During an OSD Task Sequence, when the PC boots into WinPE from the Boot Image, the SMSTS.log settings are not controlled via the same registry keys as in the full Windows OS. Instead the SMSTS.log settings are controlled via entries in a file called SMSTS.ini file which resides in the Windows directory of WinPE.
In order to change the logging options for the SMSTS.log file while in WinPE, the SMSTS.ini files has to be either created or modified with the appropriate parameters. If no SMSTS.ini file exists in the Windows directory of WinPE, then default values are used. By default, the SMSTS.ini file does not exist in the default Boot Images of ConfigMgr and therefore the default options are used.
The logging options and values that can be modified are:

DEBUGLOGGING
ENABLELOGGING
LOGLEVEL
LOGMAXHISTORY
LOGMAXSIZE

The value names are basically the same as the registry value names from the full OS, but without the preceding CCM prefix. Similar to logging in the full OS, for the purposes of the SMSTS.log and OSD, the only three parameters that usually are changed are LOGLEVEL, LOGMAXHISTORY, LOGMAXSIZE. The value of LOGMAXSIZE is specified in bytes.
To modify the values, in NotePad, create a SMSTS.ini file with a [Logging] section that contains the parameters that need to be modified. The file then needs to be injected in the Windows directory of the Boot Image. The SMSTS.ini file has to be in place BEFORE the Task Sequence begins in WinPE. For this reason, the SMSTS.ini file cannot be added or copied to the appropriate location as part of the Task Sequence.
For example, to change the SMSTS.log file size to 5MB, set the log level to the most verbose level, and increase the amount of rolled over/historical logs to 3, the following would be the contents of the SMSTS.ini file:

[Logging]
LOGLEVEL=0
LOGMAXSIZE=5242880
LOGMAXHISTORY=3

Note: The logging options in the SMSTS.ini file are case sensitive and should be entered in all uppercase.
Injecting the SMSTS.ini file into the Boot Image
ConfigMgr stores files to be injected into the Boot Images under the following two directories on the site server:

x86 Boot Images
\OSD\bin\i386

x64 Boot Image
\OSD\bin\x64

The files located in the above two directories are not necessarily automatically injected into the Boot images. An XML file is used which defines which files need to be injected, where the files are located within the BIN directory, and where they need to be copied to within the WinPE Boot Image. The name of this XML file is osdinjection.xml. It is located in the following directory on the site server:

\bin\i386

Please note that the above directory is NOT the same as where the files to be injected reside. Additionally only one osdinjection.xml file is needed for both x86 and x64 Boot Images.
To inject the SMSTS.ini file into the Boot Images:

Using NotePad, create an SMSTS.ini file with the desired parameters. When saving the file in NotePad, make sure it has the extension of .ini and not .txt.
Copy the SMSTS.ini file created in Step #1 into the appropriate directories on the ConfigMgr site server where the Boot Images are located. The file has to be copied to two separate directories - one for x86 Boot Image and one for x64 Boot Images.

The directories to copy the file to are:

\OSD\bin\i386

and

\OSD\bin\x64
Once the SMSTS.ini file is copied to the appropriate directories on the ConfigMgr site server, navigate to the following directory:

\bin\i386
Create a backup of the file osdinjection.xml located in the \bin\i386 directory.
Open the original osdinjection.xml file in NotePad. Add sections to both the i386 and x64 portions of the osdinjection.xml file specifying to inject the SMSTS.ini file into the Windows directory of the x86 and x64 Boot Image:

For the x86 Boot Image, find the section:

false
bin\i386
sms\bin\i386

Add the following section immediately after the above section but before the line containing :

false
bin\i386
Windows

For the x64 Boot Image, find the section:

false
bin\x64
sms\bin\x64

Add the following section immediately after the above section but before the line containing

:

false
bin\x64
Windows

Save the osdinjection.xml file in NotePad.

In the ConfigMgr 2007 console, navigate to "Site Database" --> "Computer Management" --> "Operating System Deployment" --> "Boot Images".

Right click on the desired Boot Image to be updated with the SMSTS.ini file and choose "Update Distribution Points".

In the "Summary" page of the "Manage Distribution Points Wizard" window, click on the "Next >" button and allow the Boot Image to be rebuilt.

Once the Boot Image is finished rebuilding, in the "Wizard Complete" page of the "Manage Distribution Points Wizard" window, click on the "Close" button.

Repeat Steps 8-10 for each Boot Image in the environment.

Once the Distribution Points have finished updating for each Boot Image, each Boot Image should have the updated log settings for the SMSTS.log.
As an option, instead of using the above process, after the SMSTS.ini has been created, it can be manually injected into the Windows directory of the Boot Image using ImageX or DISM. However using the above process preserves and does not modify the original Boot Image (boot.wim), so it is the preferred method.

read here more for enable http://blogs.technet.com/b/system_center_configuration_manager_operating_system_deployment_support_blog/archive/2011/10/12/how-to-change-logging-options-for-smsts-log-in-system-center-configuration-manager-2007.aspx

location of smsts.log file

Windows PE before HDD format: x:\windows\temp\smstslog\smsts.log

Windows PE after HDD format: x:\smstslog\smsts.log and copied to c:\_SMSTaskSequence\Logs\Smstslog\smsts.log

Full version Windows before SCCM agent installed: c:\_SMSTaskSequence\Logs\Smstslog\smsts.log

Full version Windows after SCCM agent installed: c:\windows\system32\ccm\logs\Smstslog\smsts.log

Full version Windows (x64) after SCCM agent installed: c:\windows\sysWOW64\ccm\logs\Smstslog\smsts.log

After Task Sequence has finished running: c:\windows\system32\ccm\logs\smsts.log

After Task Sequence has finished running (x64): c:\windows\sysWOW64\ccm\logs\smsts.log

How many Days Left to back you?

'PS: Days Left...

Wscript.Echo "Today Date MM-DD-YY: " & Date
Wscript.Echo "Days Until ur Day in Months: " & DateDiff("m", Date, "24/4/2013")
Wscript.Echo "Days Until ur Day in Days: " & DateDiff("D", Date, "24/4/2013")
Wscript.Echo "Days Until ur Day in Weeks: " & DateDiff("w", Date, "24/4/2013")
Wscript.Echo "Hello..."

'write(DateDiff("m",fromDate,toDate,vbMonday))

All the Microsoft Updates Till Date

Here you can download all the list of updates from this link it will show from 1998 to TillDate... Auto Updated this excel sheet by Microsoft
http://go.microsoft.com/fwlink/?LinkID=245778

For more Security related info visit http://technet.microsoft.com/en-us/security/bulletin/

Enjoy..

Bulk SCCM Client Troubleshooting Approch

Site Name	Site 1	Comments
Discovery	What are The OU's Targeted? In AD	Are they missing any in OU's IN AD ??
From AD	In above Ou's Howmany Computers are there? (From AD)	may be a difference in SCCM vs AD
in SCCM	Now List howmany in SCCM	may be a difference in SCCM vs AD
Run the AD stale Computers Command	Use this link http://configmgr2oo7.blogspot.sg/2010/09/for-finding-90-days-old-computers-in-ad.html	Computers that are not connected in network or not logged on more than 90 means computer not there in network and SCCM treats as Stale and it will not discover
Get the difference of computers(AD-StaleAD-in Totall SCCM)	Totall??
Now get the Totall non SCCM Clients show in your clients report and fix by using below two tools
Use these script to install the SCCM Client on remote computers
-remotly install on many systems once by using these scripts	http://configmgr2oo7.blogspot.sg/2009/01/sccm-client-installation-script-batch.html http://sccmcat.codeplex.com/	USE SCCM Client action tools ..need to configure the .ini file as per your requirement check the blog
- Single computer based tool	http://sourceforge.net/projects/smsclictr/	If it is a one computer use this tool
Catagorise the problems lile	Ping Online & offline computers with this script	to get the status of computes use this scrip may be usefull before you start work
WMI & Admin$ issues	http://configmgr2oo7.blogspot.sg/2008/11/wmi-connectivity-check.html	WMI & Admin$ is key to deploy clients
Once the clinet installation completed check the log	CCMsetup.log,execmgr.log, Clientidmanager.log	check the logs
	Check all these case's before start working http://configmgr2oo7.blogspot.sg/2010/03/client-troublshooting-checks-check-list.html

Virtual LAB Microsoft Page

All Virtual LABs http://technet.microsoft.com/en-us/virtuallabs/bb539977

Virtual LABS : System Center 2012 Configuration Manager

System Center 2012 Configuration Manager

To Download the YouTube Play list

To download the YouTube Play list all videos at a time…

The link to the page where you can download “Free youtube Download”.http://www.dvdvideosoft.com/products/dvd/Free-YouTube-Download.htm is really superb ..

Enjoy

Test

Test from TP

is computer is 32 bit or 64 bit ?

--Finding computer is 32 bit or 64 bit is easy from SCCM... here is SQL query............

SELECT Distinct SYS.Netbios_Name0, CS.Model0,CPU.Name0 AS [CPU Name], CASE WHEN CPU.Is64Bit0 = 1
THEN 'Yes' ELSE 'No' END AS [CPU 64-Bit],ROUND(CONVERT(FLOAT,CPU.MaxClockSpeed0), -2)/1000
AS [CPU (GHz)],
ROUND(ROUND(CONVERT(FLOAT,MEM.TotalPhysicalMemory0) / 1048576, 2) , 1)
AS [RAM (GB)],[TPM Chip]=(SELECT v_GS_SYSTEM_DEVICES.Name0
FROM v_GS_SYSTEM_DEVICES WHERE v_GS_SYSTEM_DEVICES.ResourceID=SYS.ResourceID AND
v_GS_SYSTEM_DEVICES.Name0 LIKE '%Trusted Platform%') ,LDISK.DeviceID0,LDISK.Size0/1024
AS [Size (GB)],LDISK.FreeSpace0/1024 AS [Free Space (GB)] FROM v_R_System SYS LEFT JOIN
v_GS_LOGICAL_DISK LDISK on SYS.ResourceID = LDISK.ResourceID LEFT JOIN
v_GS_COMPUTER_SYSTEM CS on SYS.ResourceID = CS.ResourceID LEFT JOIN
v_GS_X86_PC_MEMORY MEM on SYS.ResourceID = MEM.ResourceID LEFT JOIN
v_GS_Processor CPU on SYS.ResourceID = CPU.ResourceID LEFT JOIN
v_GS_SYSTEM_DEVICES DEV on SYS.ResourceID = DEV.ResourceID
WHERE LDISK.DeviceID0 = 'C:' AND CS.Model0 NOT LIKE '%VMWARE%'

ORDER BY SYS.Netbios_Name0

Nomad Branch Agent Fix and re install

echo sTOP sERVICE
Net Stop NomadBranch

Echo uNINSTALL If Nomad Found

Call MsiExec.exe /NoRestart /X{94ADB1B7-6490-4DCD-800D-5214A8516DC6} /QN
Call MsiExec.exe /NoRestart /X{1DBE047F-2734-4F18-BC8A-8721E1866BAC} /QN
Call MsiExec.exe /NoRestart /x{B9AC4CC0-2AAB-42C7-A876-1C552500CD82} /QN

Echo Install Nomad

Call Msiexec.exe /i NomadBranch.msi AUTHENTICATEDUSERS=1 INSTALLDIR="%programfiles%\1E\SMSNomad" STATUSMSGEVENTS="0x2,0x200000" NOMADINHIBITEDSUBNETS="" PIDKEY=COMPkey1-1234-1234-1234-1234 MULTICASTSUPPORT=0 CachePath="%systemdrive%\NomadBranch" Logpath="%systemdrive%\NomadBranch\LogFiles" /log "%systemRoot%\temp\1e.log" /QN

Echo Install Patch"Q11498.msp"

Call Msiexec /p Q11498.msp /qn REBOOT=ReallySuppress /l*v %systemRoot%\Temp\1EQ11498.Log
Call "%ProgramFiles%\1E\SMSNomad\NomadBranch.exe" -relicense=COMPkey1-1234-1234-1234-1234

Echo if service not in auto state set to auto

SC Config NomadBranch start= auto

Net Start NomadBranch

All WQL to info from SQL

All WQL to info from SQL

select * from dbo.v_CollectionRuleQuery

SQL Query for Pathes required systems with the Size

--SQL Query for Pathes required systems with the Size

SELECT DISTINCT
TOP (100) PERCENT SYS.Name0 AS [Machine Name], UCS.Status AS [Patch Status Code], UI.BulletinID, UI.ArticleID, UI.Title,
dbo.v_FullCollectionMembership.ResourceID, dbo.v_Collection.CollectionID, UI.CI_ID, dbo.CI_Contents.SourceSize /(1024.0*1024) AS SizeinMB
FROM dbo.v_UpdateContents INNER JOIN
dbo.v_FullCollectionMembership INNER JOIN
dbo.v_Collection ON dbo.v_FullCollectionMembership.CollectionID = dbo.v_Collection.CollectionID INNER JOIN
dbo.v_R_System AS SYS LEFT OUTER JOIN
dbo.v_Update_ComplianceStatusAll AS UCS ON SYS.ResourceID = UCS.ResourceID INNER JOIN
dbo.v_UpdateInfo AS UI ON UCS.CI_ID = UI.CI_ID ON dbo.v_FullCollectionMembership.ResourceID = UCS.ResourceID ON
dbo.v_UpdateContents.CI_ID = UI.CI_ID INNER JOIN
dbo.CI_Contents ON dbo.v_UpdateContents.Content_ID = dbo.CI_Contents.Content_ID
WHERE (UCS.Status IN ('2')) AND (dbo.v_Collection.CollectionID = 'LAB000FB')
ORDER BY UI.ArticleID

All Systems that have been discovered last night:

SELECT SMS_R_System.ResourceID,SMS_R_System.ResourceType,SMS_R_System.Name,
SMS_R_System.SMSUniqueIdentifier,
SMS_R_System.ResourceDomainORWorkgroup,SMS_R_System.Client
FROM SMS_R_System
WHERE (DateDiff(day, CreationDate, GetDate()) < 1)

Collection - ADVERTISEMENT FAILED systems

SELECT sys.ResourceID,sys.ResourceType,sys.Name,sys.SMSUniqueIdentifier,sys.ResourceDomainORWorkgroup,sys.Client FROM sms_r_system as sys inner join SMS_ClientAdvertisementStatus as offer on sys.ResourceID=offer.ResourceID
WHERE AdvertisementID = 'LAB20089' and LastStateName = "Failed"

All S/w from Add& Remove Programs After some exceptional removing

All S/w from Add& remove Programs

SELECT DISTINCT arp.DisplayName0 AS [Product Name], arp.Publisher0, arp.Version0, dbo.v_R_System.Netbios_Name0, fcm.CollectionID
FROM dbo.v_GS_ADD_REMOVE_PROGRAMS AS arp INNER JOIN
dbo.v_R_System ON arp.ResourceID = dbo.v_R_System.ResourceID CROSS JOIN
dbo.v_Collection INNER JOIN
dbo.v_FullCollectionMembership AS fcm ON dbo.v_Collection.CollectionID = fcm.CollectionID
WHERE (NOT (arp.DisplayName0 LIKE '%update%')) AND (NOT (arp.DisplayName0 LIKE 'para%')) AND (NOT (arp.DisplayName0 LIKE 'Configuration Manager Client')) AND
(NOT (arp.DisplayName0 LIKE 'µTorrent')) AND (NOT (arp.DisplayName0 LIKE '%Service Pack%')) AND (NOT (arp.DisplayName0 LIKE '%Segurança%')) AND
(NOT (arp.DisplayName0 LIKE '%Windows%')) AND (NOT (arp.DisplayName0 LIKE '%Audio Driver%')) AND
(NOT (arp.DisplayName0 LIKE '%C++ 2005 Redistributable%')) AND (NOT (arp.DisplayName0 LIKE '%Viewer%')) AND (NOT (arp.DisplayName0 LIKE '%Hotfix%')) AND
(NOT (arp.DisplayName0 LIKE '%.NET Framework%')) AND (NOT (arp.DisplayName0 LIKE '%google%')) AND (NOT (arp.DisplayName0 LIKE '%MSXML%')) AND
(NOT (arp.DisplayName0 LIKE '%Microsoft Baseline Security Analyzer%')) AND (NOT (arp.DisplayName0 LIKE '%Fax%')) AND (NOT (arp.DisplayName0 LIKE '%GDR%'))
AND (NOT (arp.DisplayName0 LIKE '%HP Array Configuration%')) AND (NOT (arp.DisplayName0 LIKE '%HP Scanjet%')) AND
(NOT (arp.DisplayName0 LIKE '%HP Smart%')) AND (NOT (arp.DisplayName0 LIKE '%hppFaxUtility%')) AND (NOT (arp.DisplayName0 LIKE '%hppFonts%')) AND
(NOT (arp.DisplayName0 LIKE '%HPPhotoSmartExpress%')) AND (NOT (arp.DisplayName0 LIKE 'HPP%')) AND (NOT (arp.DisplayName0 LIKE '%HPProductAssistant%'))
AND (NOT (arp.DisplayName0 LIKE '%WebFldrs XP%')) AND (NOT (arp.DisplayName0 LIKE '%Visual Studio Tools for the Office system 3.0 Runtime%')) AND
(NOT (arp.DisplayName0 LIKE 'VBA%')) AND (NOT (arp.DisplayName0 LIKE '%uTorrentBar%%')) AND (NOT (arp.DisplayName0 LIKE '%Ultimate Extras%')) AND
(NOT (arp.DisplayName0 LIKE '%Runtime Environment%')) AND (NOT (arp.DisplayName0 LIKE '%Toolbox%')) AND (NOT (arp.DisplayName0 LIKE '%IBM Themes%'))
AND (NOT (arp.DisplayName0 LIKE '%hp LaserJet%')) AND (NOT (arp.DisplayName0 LIKE '%GDR%')) AND (NOT (arp.DisplayName0 LIKE '%Fax%')) AND
(NOT (arp.DisplayName0 LIKE '%Adobe Shockwave Playe%')) AND (NOT (arp.DisplayName0 LIKE '%Adobe Reader%')) AND
(NOT (arp.DisplayName0 LIKE '%Adobe Download Manager%')) AND (NOT (arp.DisplayName0 LIKE '%Actualización%')) AND
(NOT (arp.DisplayName0 LIKE '%Active Directory Migration Tool%')) AND (NOT (arp.DisplayName0 LIKE '%Adobe Flash Player%')) AND
(NOT (arp.DisplayName0 LIKE '%Audio%')) AND (NOT (arp.DisplayName0 LIKE '%XML%')) AND (NOT (arp.DisplayName0 LIKE '%Web Part%')) AND
(NOT (arp.DisplayName0 LIKE '%WIMGAPI%')) AND (NOT (arp.DisplayName0 LIKE '%Microsoft Silverlight%')) AND (NOT (arp.DisplayName0 LIKE '%SoundMAX%')) AND
(NOT (arp.DisplayName0 LIKE '%Spelling%')) AND (NOT (arp.DisplayName0 LIKE '%RDC%')) AND (NOT (arp.DisplayName0 LIKE '%Wallpapers%')) AND
(NOT (arp.DisplayName0 LIKE '%WebEx%')) AND (NOT (arp.DisplayName0 LIKE '%Microsoft Office Proof%')) AND (NOT (arp.DisplayName0 LIKE '%MSN Toolbar%'))
AND (NOT (arp.DisplayName0 LIKE '%MSN Toolbar%')) AND (NOT (arp.DisplayName0 LIKE '%google%')) AND (NOT (arp.DisplayName0 LIKE '%SQL Server Native%'))
AND (NOT (arp.DisplayName0 LIKE '%VSS Writer%')) AND (NOT (arp.DisplayName0 LIKE '%XP Themes%')) AND (NOT (arp.Publisher0 LIKE '%Lenovo%')) AND
(NOT (arp.Publisher0 LIKE '%UPEK Inc%')) AND (NOT (arp.Publisher0 LIKE '%AutoIt%')) AND (NOT (arp.Publisher0 LIKE '%Broadcom%')) AND
(NOT (arp.Publisher0 LIKE '%S3 Graphics%')) AND (NOT (arp.Publisher0 LIKE '%Realtek%')) AND (NOT (arp.Publisher0 LIKE '%Seagate%')) AND
(NOT (arp.Publisher0 LIKE '%S3 Graphics%')) AND (NOT (arp.Publisher0 LIKE '%Active Directory Export%')) AND (NOT (arp.Publisher0 LIKE '%TOSHIBA%')) AND
(NOT (arp.Publisher0 LIKE '%Logitech%')) AND (NOT (arp.Publisher0 LIKE '%SCCM%')) AND (NOT (arp.Publisher0 LIKE '%Yahoo%')) AND
(NOT (arp.Publisher0 LIKE '%Canon%')) AND (NOT (arp.Publisher0 LIKE '%ZTE%')) AND (NOT (arp.Publisher0 LIKE '%Dell%')) AND
(NOT (arp.Publisher0 LIKE '%McAfee%')) AND (NOT (arp.Publisher0 LIKE '%Dell%')) AND (NOT (arp.Publisher0 LIKE '%1E%')) AND
(NOT (arp.Publisher0 LIKE '%Mozilla%')) AND (NOT (arp.Publisher0 LIKE '%TOSHIBA%')) AND (NOT (arp.Publisher0 LIKE '%Broadcom%')) AND
(NOT (arp.Publisher0 LIKE '%DivX%')) AND (NOT (arp.Publisher0 LIKE '%InterVideo%')) AND (NOT (arp.Publisher0 LIKE '%UPEK%')) AND
(NOT (arp.Publisher0 LIKE '%Intel%')) AND (NOT (arp.Publisher0 LIKE '%Realtek%')) AND (NOT (arp.Publisher0 LIKE '%REALTEK%')) AND
(NOT (arp.Publisher0 LIKE '%Conexant%')) AND (fcm.CollectionID = 'SMS00001')

Nomad Service issue

If Nomad service is getting stopped automatically as Licensing issue.. then we can re license as below command from the NomadBranch.exe path...

NomadBranch.exe -relicense=Productkey-Abcad-123456-1231231-12312312

ITIL Exams

ITIL Exams:

The Information Technology Infrastructure Library™ (ITIL) offers a systematic approach to the delivery of quality IT services. ITIL was developed in the 1980s and 1990s by CCTA (Central Computer and Telecommunications Agency, now the Office of Government Commerce, OGC), under contract to the UK Government.

Since then, ITIL has provided not only a best practice based framework for IT management, but also an approach and philosophy shared by the people who work with it in practice. ITIL has now been updated twice, the first time in 2000-2002 (V2), and the second time in 2007 (V3).

The ITIL Qualification Scheme uses a system that enables an individual to gain credits for each exam they take. Once candidates have accumulated a sufficient number of credits they can be awarded the ITIL Expert in IT Service Management. There are four levels within the scheme:

§ Foundation Level

§ Intermediate Level (Lifecycle Stream and Capability Stream)

§ ITIL Expert

§ ITIL Master

PXE Client How will find the PXE Server

The process is roughly as below:

1. Client powers on
2. NIC initiates PXE process
3. NIC acquires DHCP address
4. NIC contacts PXE server (WDS)
5. PXE server delivers NBP to client
6. NIC TFTPs boot image (from WDS)

4 This can be couple of different ways. If the DHCP request returned options 66 and 67, then the NIC BIOS will directly use the information in these options to contact the PXE server.

If options 66 & 67 are not specified, then the NIC BIOS will send a broadcast request to find a PXE server.

If the PXE server is not on a local subnet, then something needs to forward the broadcast request to the PXE server: iphelpers (there are other possibilities but this is the primary solution to this).

Once the PXE server is contacted, it sends back the info to the client so the client can directly contact the PXE server.

Open Visual Studio 2010.
Go to File => New => Project.
Select Class Library template, enter the name and click Ok.
Add the following references.
-System.Management.Automation.dll (C:\Program Files (x86)\Reference Assemblies\Microsoft\WindowsPowerShell\v1.0\System.Management.Automation.dll)
-System.Configuration.Install.dll (C:\Windows\Microsoft.NET\Framework\v2.0.50727\System.Configuration.Install.dll
-Microsoft.SharePoint.dll (C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\ISAPI\Microsoft.SharePoint.dll)
-Microsoft.SharePoint.PowerShell.dll (C:\Windows\assembly\GAC_MSIL\Microsoft.SharePoi

PowerShell in Nutshell learn from these steps

Stage 1

WebCast: Scott Hanselman – Developer Productivity Tools Part 3
WebCast: PowerShell Week - Day 2: CmdLets
Tutorial: MS Scripting Center Task-Based Tutorial
PDF Quick Reference: PowerShell Cheat Sheet
Podcast: HanselMinutes – Monad (show 11)
Blog post: Learning PowerShell without leaving the command line

Stage 2

CmdLet Exploration: Try all built-in CmdLets using Get-Command, Get-Help, and Get-Member. Don’t forget the -example param for Get-Help
Podcast: Hanselminutes – Interview with Jeffrey Snover (Powershell Architect)
Podcast: Hanselminutes – Interview with Bruce Payette (Powershell Dev Lead)
Snap-In: Install and learn PSCX (see my last post for overview)
Tool: PowerTab (provides intellisense)
Demo SQL Provider: Download and install info on this Powershell Team Blog post.

Stage 3

Book: Powershell in Action by Bruce Payette
WMI Exploration: If you want to do anything against remote computers, you’ll have to master WMI. Use gwmi -list | ?{$_.name -like ‘win32_*’} to see a list of useful objects and start exploring.
Sample Scripts: Script Center Repository
Blog: Powershell Team
Blog: Keith Hill
Blog: Powershell Guy
Blog: Dmitry

SCCM 2012

Microsoft System Center is a set of server products aimed specifically at helping corporate IT administrators manage a network of Windows Server and client desktop systems.

System Center 2012 Configuration Manager

Attribution

Blog Archive

Labels