tag:blogger.com,1999:blog-72133534674550788182024-02-20T06:59:36.161-08:00Madan's Blog - SCCM,SMSA collection of notes and tips from the field.Madanhttp://www.blogger.com/profile/14459115280044468451noreply@blogger.comBlogger65125tag:blogger.com,1999:blog-7213353467455078818.post-9068840288428589752013-01-17T16:42:00.002-08:002013-01-17T16:42:13.766-08:00Installing 32-bit Java Runtime Environment(JRE) software as SYSTEM in Windows 7 x64 via SCCM/SMS.<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<div class="MsoNormal" style="line-height: 14.4pt; margin-bottom: .0001pt; margin-bottom: 0in; margin-left: 0in; margin-right: 0in; margin-top: 22.5pt; mso-outline-level: 2;">
<span style="font-family: 'Segoe UI', sans-serif; font-size: 10pt;">I
recently ran into an issue updating the Sun Java runtime (JRE) on our x64
machines where 32 version of JRE is installed. We have lot of systems
with JRE 32bit version installed on Windows 7 and XP 64-bit systems. When I
advertised the JRE 32-bit executable on those systems the installation failed on
the systems with 1619 exit code. </span></div>
<div class="MsoNoSpacing">
<br /></div>
<div class="MsoNoSpacing">
<span style="font-family: "Segoe UI","sans-serif"; font-size: 10.0pt;">1619
exit code translates to “This installation package could not be </span><span style="font-family: "Segoe UI","sans-serif"; font-size: 10.0pt; mso-fareast-font-family: "Times New Roman";">opened. Verify that the package exists and </span><span style="font-family: "Segoe UI","sans-serif"; font-size: 10.0pt;">t</span><span style="font-family: "Segoe UI","sans-serif"; font-size: 10.0pt; mso-fareast-font-family: "Times New Roman";">hat you can access it, or contact the</span><span style="font-family: "Segoe UI","sans-serif"; font-size: 10.0pt;"> </span><span style="font-family: "Segoe UI","sans-serif"; font-size: 10.0pt; mso-fareast-font-family: "Times New Roman";">application vendor to verify that this is a valid Windows
Installer package.</span><span style="font-family: "Segoe UI","sans-serif"; font-size: 10.0pt;">”<o:p></o:p></span></div>
<div class="MsoNoSpacing">
<br /></div>
<div class="MsoNoSpacing">
<span style="font-family: "Segoe UI","sans-serif"; font-size: 10.0pt;">Well,
In Windows 7, processes that run as local system have a special profile found
in c:\windows\system32\config\systemprofile.
Unfortunately, on 64-bit systems, there are two system32 folders; one for
64-bit processes, and another (whose name is syswow64) for 32-bit
processes. As a result, there are two separate system profiles; one for
32-bit, one for 64-bit.</span><o:p></o:p></div>
<div class="MsoNoSpacing">
<span style="font-family: "Segoe UI","sans-serif"; font-size: 10.0pt;">The
Sun Java installer unpacks into a subfolder of the LocalLow application data
directory. In this case, the folder in question is C:\windows\system32\config\systemprofile\LocalLow\Sun\Java\jre1.7.0_11\.
Because this is a 32-bit process, though, it is really writing to syswow64
instead of system32.<o:p></o:p></span></div>
<div class="MsoNoSpacing">
<span style="font-family: "Segoe UI","sans-serif"; font-size: 10.0pt;">The Windows Installer, however, is a
64-bit process. So when it is asked to open the MSI file, it’s looking in
the wrong place; hence error code 1619. The file can’t be opened because
it can’t be found.<o:p></o:p></span></div>
<div class="MsoNoSpacing">
<br /></div>
<div class="MsoNoSpacing">
<span style="font-family: "Segoe UI","sans-serif"; font-size: 10.0pt;">As
a workaround you could targeted the 64-bit systems that needs 32-bit JRE by
configuring the program to run under the user context. Well, your end users on
the systems must have admin rights to install when the advert executes on their
system. <o:p></o:p></span></div>
<div class="MsoNoSpacing">
<br /></div>
<div class="MsoNoSpacing">
<span style="font-family: "Segoe UI","sans-serif"; font-size: 10.0pt;">You
can also directly pick the extracted JRE MSI content from C:\windows\system32\config\systemprofile\LocalLow\Sun\Java\jre1.7.0_11\
from any system and use this content to create the package and deploy it. <o:p></o:p></span></div>
</div>
Madanhttp://www.blogger.com/profile/14459115280044468451noreply@blogger.com5tag:blogger.com,1999:blog-7213353467455078818.post-60210651389171797872012-12-19T06:30:00.002-08:002012-12-19T06:34:26.789-08:00Determine Whether Client Computers Are Ready for Native Mode<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="tr_bq">
<span style="font-family: Verdana, sans-serif;">To help you determine if Configuration Manager 2007 client computers have a valid certificate for successful native mode communication before you migrate the site into native mode, run a utility called the Configuration Manager Native Mode Readiness Tool... </span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;"><a href="http://technet.microsoft.com/en-us/library/bb680839.aspx">http://technet.microsoft.com/en-us/library/bb680839.aspx </a></span><br />
<br />
<a href="http://blogs.technet.com/b/wemd_ua_-_sms_writing_team/archive/2008/11/02/native-mode-certificate-selection-criteria-cannot-use-attributes-with-spaces.aspx"><span style="font-family: Verdana, sans-serif;">http://blogs.technet.com/b/wemd_ua_-_sms_writing_team/archive/2008/11/02/native-mode-certificate-selection-criteria-cannot-use-attributes-with-spaces.aspx</span></a></div>
</div>
Madanhttp://www.blogger.com/profile/14459115280044468451noreply@blogger.com0tag:blogger.com,1999:blog-7213353467455078818.post-36542855733647749392012-12-19T06:09:00.001-08:002012-12-19T06:25:13.124-08:00Error signing client message (0x80004005) in ClientAuth.log<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<div style="margin-bottom: .0001pt; margin: 0in;">
<span style="font-family: 'Segoe UI', sans-serif; font-size: 10pt;">Yesterday I come across a native mode client which was not communicating with MP. When I check the Clientauth.log I noticed the following error. </span><br />
<span style="font-family: Segoe UI, sans-serif; font-size: x-small;"></span><br />
<blockquote class="tr_bq">
<span style="font-family: Segoe UI, sans-serif; font-size: x-small;">ClientAuth.log:<br />Error signing client message (0x80004005).<br />ClientIDManagerStartup.log:<br />RegTask: Failed to get certificate. Error: 0x80004005</span></blockquote>
<br />
<span style="font-family: 'Segoe UI', sans-serif; font-size: 10pt;"><br /></span></div>
<div style="margin-bottom: .0001pt; margin: 0in;">
<span style="font-family: 'Segoe UI', sans-serif; font-size: 10pt;">I found that there were two
client authentication certificates which match the certificate selection criteria.
I removed one certificate from the client and the client started working
properly. You can alternatively configure the site or the client installation
properties to select any certificate that matches the creteria to fix this
issue. <o:p></o:p></span></div>
<br />
<br /></div>
Madanhttp://www.blogger.com/profile/14459115280044468451noreply@blogger.com3tag:blogger.com,1999:blog-7213353467455078818.post-88308835636440953272012-11-30T09:25:00.004-08:002012-11-30T09:29:47.056-08:00Get OS type(x32 or x64) information from SCCM report<div dir="ltr" style="text-align: left;" trbidi="on">
<blockquote class="tr_bq">
<span style="font-family: Verdana, sans-serif;"><br />select sys.netbios_name0,<br />case when PROCESSOR.addresswidth0 = 64 then '64bit OS'<br />when PROCESSOR.addresswidth0=32 then '32bit OS'<br />end as [Operating System Type],<br />case when PROCESSOR.addresswidth0=32 and PROCESSOR.DataWidth0=64 then '*'<br />end as [32-bit OS on x64 processor]<br />from v_r_system sys<br />join v_gs_processor PROCESSOR on sys.resourceid=PROCESSOR.resourceid</span></blockquote>
<br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;">All credits to Sherry Kissinger's. Read the original article at - <a href="http://myitforum.com/cs2/blogs/skissinger/archive/2009/06/23/32bit-vs-64bit-report.aspx">http://myitforum.com/cs2/blogs/skissinger/archive/2009/06/23/32bit-vs-64bit-report.aspx</a></span></div>
Madanhttp://www.blogger.com/profile/14459115280044468451noreply@blogger.com1tag:blogger.com,1999:blog-7213353467455078818.post-4333164088040393162012-11-30T04:41:00.003-08:002012-11-30T04:50:34.988-08:00SCCM Client does not show up in console<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: Verdana, sans-serif;">Today, I come across a client which was not showing in the SCCM console and when I looked at the ccmexec.log I noticed the following error logs. </span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<u><span style="font-family: Verdana, sans-serif;">ccmexec.log: </span></u><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<br />
<blockquote class="tr_bq">
<span style="font-family: Verdana, sans-serif;">[CCMHTTP] HTTP ERROR: URL=http://sccmserver.abc.com/ccm_system/request, <b>Port=443</b>, Protocol=https, SSLOptions=1, Code=12029, Text=<b>ERROR_WINHTTP_CANNOT_CONNECT</b><br />HandleRemoteSyncSend failed (0x80040231).<br />CForwarder_Sync::Send failed (0x80040231).<br />CForwarder_Base::Send failed (0x80040231).</span></blockquote>
<div>
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div>
<span style="font-family: Verdana, sans-serif;"><u>Resolution</u>: </span></div>
<div>
<span style="font-family: Verdana, sans-serif;">Make sure the required port are opened on the firewall. In my case it was 443 and port 80 once they are opened my ConfigMgr client shown up with in 15-20 minutes in the SCCM console. </span></div>
</div>
Madanhttp://www.blogger.com/profile/14459115280044468451noreply@blogger.com1tag:blogger.com,1999:blog-7213353467455078818.post-65538263206317429592012-11-29T10:19:00.003-08:002012-11-30T08:06:28.972-08:00Adds support for Windows 8-based client computers in SCCM 2007 SP2<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: Verdana, sans-serif;"><br />
Microsoft has released a hotfix KB2750782 to add support for Windows 8-based client computers in System Center Configuration Manager 2007 SP2. Please refer to the following link for more information on this hotfix and how to apply it. </span><br />
<blockquote class="tr_bq">
<span style="font-family: Verdana, sans-serif;"><a href="http://blogs.technet.com/b/configmgrteam/archive/2012/10/31/update-on-windows-8-and-windows-server-2012-support-in-cm-and-ep.aspx">http://blogs.technet.com/b/configmgrteam/archive/2012/10/31/update-on-windows-8-and-windows-server-2012-support-in-cm-and-ep.aspx</a></span></blockquote>
<blockquote class="tr_bq">
<span style="font-family: Verdana, sans-serif;"><a href="http://support.microsoft.com/kb/2750782">http://support.microsoft.com/kb/2750782</a></span></blockquote>
<blockquote class="tr_bq">
<span style="font-family: Verdana, sans-serif;"><a href="http://blogs.technet.com/b/configurationmgr/archive/2010/12/09/system-center-configuration-manager-2007-hotfix-installation-guidance.aspx">http://blogs.technet.com/b/configurationmgr/archive/2010/12/09/system-center-configuration-manager-2007-hotfix-installation-guidance.aspx </a></span></blockquote>
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;"><u>
How to install KB2750782 HOTfix to SCCM 2007 SP2 Central/Primary Site.</u></span><br />
<span style="font-family: Verdana, sans-serif;"><br />
Download the hotfix from <a href="http://support.microsoft.com/kb/2750782">here</a> and extract and run "SCCM2007-SP2-KB2750782-ENU.msi".</span><br />
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<span style="font-family: Verdana, sans-serif;">Follow the hotfix wizard to complete the installation. </span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-KZhW7-LxXys/ULeqT57yH5I/AAAAAAAABVc/AKI6kBfNSvE/s1600/Hotfix1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em; text-align: center;"><span style="font-family: Verdana, sans-serif;"><img border="0" height="312" src="http://3.bp.blogspot.com/-KZhW7-LxXys/ULeqT57yH5I/AAAAAAAABVc/AKI6kBfNSvE/s400/Hotfix1.png" width="400" /></span></a></div>
<span style="font-family: Verdana, sans-serif;"><br />
</span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-WKmIk_qcL5U/ULeqUvr0clI/AAAAAAAABVk/DleEYF-LoBs/s1600/hotfix2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: Verdana, sans-serif;"><img border="0" height="308" src="http://3.bp.blogspot.com/-WKmIk_qcL5U/ULeqUvr0clI/AAAAAAAABVk/DleEYF-LoBs/s400/hotfix2.png" width="400" /></span></a></div>
<span style="font-family: Verdana, sans-serif;"><br />
</span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-dOF838IpGHY/ULeqVoPXbrI/AAAAAAAABVs/keI4FBh3zgE/s1600/hotfix3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: Verdana, sans-serif;"><img border="0" height="310" src="http://1.bp.blogspot.com/-dOF838IpGHY/ULeqVoPXbrI/AAAAAAAABVs/keI4FBh3zgE/s400/hotfix3.png" width="400" /></span></a></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif;">You get prompted if you want it to create an SCCM package to deploy 2750782 to the clients. If you say Yes, then it saves you the time to create the package (and the SCCM program) yourself. It also creates the file used to install the hotfix on the clients to a subfolder nested in the location where the SCCM client installation files are on the site server. The location is</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif;">\\<siteserver>\sms_<sitecode>\client\i386\hotfix\KB2750782, and the file is</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif;"> sccm2007ac-sp2-kb2698619-x86-enu.msp.</span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-ZrFMcHqHTD0/ULeqWD5luLI/AAAAAAAABV0/_kJ9Fdj5Gvc/s1600/hotfix4.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: Verdana, sans-serif;"><img border="0" height="308" src="http://3.bp.blogspot.com/-ZrFMcHqHTD0/ULeqWD5luLI/AAAAAAAABV0/_kJ9Fdj5Gvc/s400/hotfix4.png" width="400" /></span></a></div>
<span style="font-family: Verdana, sans-serif;"><br />
</span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-x4wqsBH_jrI/ULeqWgJUXRI/AAAAAAAABV8/ORhCF4Q6_Jo/s1600/hotfix5.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: Verdana, sans-serif;"><img border="0" height="307" src="http://4.bp.blogspot.com/-x4wqsBH_jrI/ULeqWgJUXRI/AAAAAAAABV8/ORhCF4Q6_Jo/s400/hotfix5.png" width="400" /></span></a></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-5dC2g14QPow/ULetRiVHuoI/AAAAAAAABWs/4xC0CqDXi_k/s1600/hotfix6.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: Verdana, sans-serif;"><img border="0" height="306" src="http://4.bp.blogspot.com/-5dC2g14QPow/ULetRiVHuoI/AAAAAAAABWs/4xC0CqDXi_k/s400/hotfix6.png" width="400" /></span></a></div>
<span style="font-family: Verdana, sans-serif;"><br />
</span><br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<span style="font-family: Verdana, sans-serif;"><br />
</span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-FnkhdMeVq-U/ULeqX1OUvNI/AAAAAAAABWM/vHQ_V7mTqaw/s1600/hotfix7.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: Verdana, sans-serif;"><img border="0" height="308" src="http://4.bp.blogspot.com/-FnkhdMeVq-U/ULeqX1OUvNI/AAAAAAAABWM/vHQ_V7mTqaw/s400/hotfix7.png" width="400" /></span></a></div>
<span style="font-family: Verdana, sans-serif;"><br />
<br />
</span><br />
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;"><u>Applying hotfixes to Configuration Manager 2007 Clients</u><o:p></o:p></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;">1. In the Configuration Manager console, create a new
package. The "Package Properties" </span><span style="font-family: Verdana, sans-serif;">dialog box appears. In the Name box on the General tab of
the Package Properties dialog box, provide a name that describes it as a hotfix for the ConfigMgr
client and identifies the ID number of the</span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;">associated Knowledge Base article.<o:p></o:p></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;">2. In the "Package Properties" dialog box, on
the "Data Source" tab, in the "Source </span><span style="font-family: Verdana, sans-serif;">directory" box, specify the folder where the hotfix
was installed by the hotfix </span><span style="font-family: Verdana, sans-serif;">installer. The default location is:</span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;">\\<siteserver>\sms_<sitecode>\client\<platform>\hotfix\<updateid><o:p></o:p></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;">Where: </span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;"><siteserver> is
the name of the ConfigMgr site server</span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;"><sitecode> is
the site code of the site</span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;"><platform> is
the processor type, e.g. I386</span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;"><updateid> is
the ID number of the associated Knowledge
Base article</span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;">==========================================<o:p></o:p></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;">Example:<o:p></o:p></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;">\\Server1\SCCM_123\client\I386\hotfix\<o:p></o:p>KB2750782</span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;">Additionally, to ensure accurate status is reported back
for the application of<o:p></o:p></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;">the client hotfix, the MIF file name(SMSAdvancedClient.sccm2007ac-sp2-kb2698619-x86-enu.mif) must be specified in
the "MIF file name" field of the Reporting tab. </span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;"><br />
Alternatively, you could use the following product code in the "Name" field. </span><br />
<span style="font-family: Verdana, sans-serif;">{6D2F87F7-4B2D-491E-8781-FF359FD95243}.</span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-YN2qKeNtbC0/ULfTKGcxa8I/AAAAAAAABW8/txI1KQOqw8w/s1600/hotfix10.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: Verdana, sans-serif;"><img border="0" height="400" src="http://4.bp.blogspot.com/-YN2qKeNtbC0/ULfTKGcxa8I/AAAAAAAABW8/txI1KQOqw8w/s400/hotfix10.png" width="330" /></span></a></div>
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;">Because the application of this hotfix on a client
computer stops and restarts</span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;">the SMS Agent Host service, it cannot monitor for an exit
code from the update and must </span><span style="font-family: Verdana, sans-serif;">rely on finding a matching status MIF after the service
is restarted. </span><span style="font-family: Verdana, sans-serif;">If a matching MIF is not found, the status will be
reported to ConfigMgr as a failure </span><span style="font-family: Verdana, sans-serif;">(1603) even though the update may have completed
successfully.</span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;">3. Click "OK" to accept the other default package settings.<o:p></o:p></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;">4. Under the new package, create a new program. The "Program Properties"
dialog </span><span style="font-family: Verdana, sans-serif;">box appears. On the "General" tab, in the
"Name" box, enter a name that describes it </span><span style="font-family: Verdana, sans-serif;">as a hotfix for the Configuration Manager client.</span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;">5. In the "Program Properties" dialog box, on
the "General" tab, in the "Command line" </span><span style="font-family: Verdana, sans-serif;">box, specify the following:</span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;"><b>Msiexec /p <filename> /L*v <logfile> /q
REINSTALL=ALL REINSTALLMODE=mous</b><o:p></o:p></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;">Where: <filename> is
the file name of the .msp file provided with the hotfix package. Typically, the file </span><span style="font-family: Verdana, sans-serif;">name
is in the form:</span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;">SCCM2007AC-<articleID>-<platform>.msp <logfile> is the path where the results </span><span style="font-family: Verdana, sans-serif;">should
be logged.</span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;">Example:<o:p></o:p></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;">msiexec.exe /p sccm2007ac-sp2-kb2698619-x86-enu.msp /L*v %TEMP%\sccm2007ac-sp2-kb2698619-x86-enu.msp.LOG /q REINSTALL=ALL REINSTALLMODE=mous</span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;">Specify for the program to run minimized and set the
"After running" option to Program </span><span style="font-family: Verdana, sans-serif;">restarts computer.</span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;">6. In the "Program Properties" dialog box, on the "Requirements" tab, set the
"Maximum </span><span style="font-family: Verdana, sans-serif;">allowed run time" to 20 minutes. This will prevent
the installation from blocking </span><span style="font-family: Verdana, sans-serif;">other software distributions if a problem occurs.</span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;">7. In the "Program Properties" dialog box, on the "Requirements" tab, choose
the operating </span><span style="font-family: Verdana, sans-serif;">system version on which you want to install the client
hotfix.</span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;">8. In the "Program Properties" dialog box, on the "Environment" tab, select
program </span><span style="font-family: Verdana, sans-serif;">can run "Whether or not a user is logged on."</span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;">9. Click "OK" to accept the other default program settings.<o:p></o:p></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;">10. Under the new package, select distribution points for the new package.<o:p></o:p></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;">11. In the Configuration Manager console, create a new query
to identify systems </span><span style="font-family: Verdana, sans-serif;">that need the .msp. This is a sample query that you can
adapt to your </span><span style="font-family: Verdana, sans-serif;">environment:</span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;">select * from SMS_R_System inner join
SMS_G_System_SMS_ADVANCED_CLIENT_STATE on
SMS_G_System_SMS_ADVANCED_CLIENT_STATE.ResourceID = SMS_R_System.ResourceId
where SMS_R_System.ClientType = 1 and
SMS_G_System_SMS_ADVANCED_CLIENT_STATE.Name =
"CcmFramework" and
(SMS_G_System_SMS_ADVANCED_CLIENT_STATE.Version < "4.0.6487.2196")</span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;">When you apply the hotfix the component version of some components changes, you can create a dynamic collection based on this data using the above query. </span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-ebv8I6bTtls/ULfTsr07LnI/AAAAAAAABXE/bbPASTGIi5I/s1600/hotfix11.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: Verdana, sans-serif;"><img border="0" height="400" src="http://4.bp.blogspot.com/-ebv8I6bTtls/ULfTsr07LnI/AAAAAAAABXE/bbPASTGIi5I/s400/hotfix11.png" width="357" /></span></a></div>
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;">12. Create a collection based on the query that you created in step 11. Limit this </span><span style="font-family: Verdana, sans-serif;">query to a pilot group of systems.</span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;">13. In the Configuration Manager console, create a new
advertisement. The <o:p></o:p></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;">"Advertisement Properties" dialog box appears.
On the "General" tab, in the <o:p></o:p></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;">"Name" box, enter a name that describes it as a
hotfix for the Configuration Manager client. <o:p></o:p></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;">14. In the "Advertisement Properties" dialog
box, on the "General" tab, <o:p></o:p></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;">select the package that you created in step 1, the
program that you created in <o:p></o:p></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;">step 4, and the pilot collection that you created in step
12. <o:p></o:p></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;">15. In the "Advertisement Properties" dialog
box, on the "Schedule" tab, create </span><span style="font-family: Verdana, sans-serif;">a new mandatory assignment. Assign it to run more
frequently than your hardware </span><span style="font-family: Verdana, sans-serif;">inventory collection schedule. For example, if your
hardware inventory is collected </span><span style="font-family: Verdana, sans-serif;">once per week, use a schedule more frequent than once per week. This will ensure that </span><span style="font-family: Verdana, sans-serif;">the hardware inventory that includes the ConfigMgr client
version information is up </span><span style="font-family: Verdana, sans-serif;">to date.</span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;">16. Click "OK" to accept the other default
advertisement settings.</span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;">17. Test the hotfix deployment to the pilot group.<o:p></o:p></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;">18. When the pilot deployment is successful, expand the
target to deploy <o:p></o:p></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;">to all the clients that require the hotfix.<o:p></o:p></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNoSpacing">
<u><span style="font-family: Verdana, sans-serif;">To deploy the ConfigMgr client .msp by using a method
other than ConfigMgr software <o:p></o:p></span></u></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;"><u>distribution:</u><o:p></o:p></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;">Use the following command line:<o:p></o:p></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;">Msiexec /p <filename> /L*v <logfile> /q
REINSTALL=ALL REINSTALLMODE=mous<o:p></o:p></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;">Where: <filename> is
the file name of the .msp file that is provided with the hotfix package. Typically, the </span><span style="font-family: Verdana, sans-serif;">file
name is in the form:</span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;">SCCM2007AC-<articleID>-<platform>.msp<o:p></o:p></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;"><logfile> is
the path where the results hould
be logged</span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;">Example:<o:p></o:p></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNoSpacing">
<span style="font-family: Verdana, sans-serif;"><o:p></o:p></span></div>
<b><span style="font-family: Verdana, sans-serif;">msiexec.exe /P sccm2007ac-sp2-kb2698619-x86-enu.msp /L*v
%temp%\sccm2007ac-sp2-kb2698619-x86-enu.log /q REINSTALL=ALL REINSTALLMODE=mous </span></b><br />
<span style="font-family: Verdana, sans-serif;"><br />
<span style="text-align: center;">SCCM Client version number changes after you install the hotfix on the SCCM client. </span></span><br />
<span style="font-family: Verdana, sans-serif;"><br />
<a href="http://1.bp.blogspot.com/-BD8O0eBh64Q/ULeqZTHqHLI/AAAAAAAABWc/H5O1C286Cx4/s1600/hotfix9.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em; text-align: center;"><img border="0" height="217" src="http://1.bp.blogspot.com/-BD8O0eBh64Q/ULeqZTHqHLI/AAAAAAAABWc/H5O1C286Cx4/s400/hotfix9.png" width="400" /></a></span></div>
Madanhttp://www.blogger.com/profile/14459115280044468451noreply@blogger.com5tag:blogger.com,1999:blog-7213353467455078818.post-6399807856910616452012-11-28T10:09:00.002-08:002012-11-28T19:05:34.836-08:00Download makecoll.exe to create static collections<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: Trebuchet MS, sans-serif;">The makecoll.exe which was included with SMS 2.0 is no longer available with SMS 2003/SCCM 2007 and 2012.</span><br />
<span style="font-family: Trebuchet MS, sans-serif;">I created a similar collection creator tool which can be downloaded from</span><br />
<blockquote class="tr_bq">
<span style="font-family: Trebuchet MS, sans-serif;"><a href="http://smstools.codeplex.com/">http://smstools.codeplex.com/</a></span></blockquote>
<br /></div>
Madanhttp://www.blogger.com/profile/14459115280044468451noreply@blogger.com1tag:blogger.com,1999:blog-7213353467455078818.post-53820314607048695402012-11-28T09:53:00.002-08:002012-11-30T04:35:11.652-08:00SCCM Client installation fails with "The current OS is not supported" message in ccmsetup.log<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<span style="font-family: Trebuchet MS, sans-serif;"><b>Issue:</b></span><br />
<span style="font-family: Trebuchet MS, sans-serif;"><b>CCMSETUP.LOG:</b></span><br />
<blockquote class="tr_bq">
<br />
<span style="font-family: 'Trebuchet MS', sans-serif;">DetectWindowsEmbeddedFBWF() Detecting OS Version</span><br />
<span style="font-family: Trebuchet MS, sans-serif;">Client OS Version is 6.1, Service Pack Version 0</span><br />
<span style="font-family: Trebuchet MS, sans-serif;">Client OS is not a supported Windows Embedded Platform</span><br />
<span style="font-family: Trebuchet MS, sans-serif;">The current OS is not supported.</span></blockquote>
<span style="font-family: Trebuchet MS, sans-serif;"><br /></span>
<span style="font-family: Trebuchet MS, sans-serif;">Resolution:</span><br />
<blockquote class="tr_bq">
<span style="font-family: Trebuchet MS, sans-serif;"><br /></span>
<span style="font-family: Trebuchet MS, sans-serif;">Make sure "Background Intelligent Transfer Service" is installed. If it not listed in the services, then </span><br />
<span style="font-family: Trebuchet MS, sans-serif;">1) run sfc /scannow</span><br />
<span style="font-family: Trebuchet MS, sans-serif;">2) Open admin command prompt and run <b>SC </b></span><span style="font-family: 'Trebuchet MS', sans-serif;"><b>Create BITS binpath= "c:\windows\system32\svchost.exe -k netsvcs" start= delayed-auto.</b> Then either restart, or go into Services (run: services.msc) and restart it yourself</span><br />
<span style="font-family: Trebuchet MS, sans-serif;">3) Once the service is started, re-attempt the SCCM client installation. </span></blockquote>
<span style="font-family: Trebuchet MS, sans-serif;"><br /></span>
</div>
Madanhttp://www.blogger.com/profile/14459115280044468451noreply@blogger.com0tag:blogger.com,1999:blog-7213353467455078818.post-46842802551990240292012-11-27T04:18:00.002-08:002012-11-27T04:18:57.743-08:00MP does not start and mpcontrol.log shows error code 0x8004100e<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: Trebuchet MS, sans-serif;"><br /></span>
<span style="font-family: Trebuchet MS, sans-serif;">MPControl.log: </span><br />
<blockquote class="tr_bq">
<span style="font-family: Trebuchet MS, sans-serif;">CWmi::Connect(): ConnectServer(Namespace) failed. - 0x8004100e</span><br />
<span style="font-family: Trebuchet MS, sans-serif;">CMPControlManager::WriteToCCMSettings(): pWmi->Connect() failed - 0x8004100e</span><br />
<span style="font-family: Trebuchet MS, sans-serif;">STATMSG: ID=5432 SEV=E LEV=M SOURCE="SMS Server" COMP="SMS_MP_CONTROL_MANAGER" SYS=server123.abc.com SITE=LAB PID=2060 TID=4292 GMTDATE=Mon Nov 26 20:38:52.423 2012 ISTR0="" ISTR1="" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0</span><br />
<span style="font-family: Trebuchet MS, sans-serif;">MPStart(): WriteToCCMSettings() failed - 0x8004100e</span><br />
<span style="font-family: Trebuchet MS, sans-serif;">SMS_MP_CONTROL_MANAGER failed to start with 0x8004100e</span></blockquote>
<span style="font-family: Trebuchet MS, sans-serif;"><br /></span><span style="font-family: Trebuchet MS, sans-serif;">resolution: </span><br />
<span style="font-family: Trebuchet MS, sans-serif;"><br /></span>
<span style="font-family: Trebuchet MS, sans-serif;">Make sure the SCCM client(SMS Agent Host) service is up and running and the client is working properly. </span></div>
Madanhttp://www.blogger.com/profile/14459115280044468451noreply@blogger.com0tag:blogger.com,1999:blog-7213353467455078818.post-88951322601225966392012-11-22T13:37:00.004-08:002012-11-22T13:37:41.272-08:00List of Public KB Articles and Hotfixes for Configuration Manager 2007 SP2<div dir="ltr" style="text-align: left;" trbidi="on">
<blockquote class="tr_bq">
<span style="font-family: Trebuchet MS, sans-serif;"><a href="http://social.technet.microsoft.com/wiki/contents/articles/4505.list-of-public-kb-articles-and-hotfixes-for-configuration-manager-2007-sp2-en-us.aspx">List of Public KB Articles and Hotfixes for Configuration Manager 2007 SP2</a></span></blockquote>
<br /></div>
Madanhttp://www.blogger.com/profile/14459115280044468451noreply@blogger.com0tag:blogger.com,1999:blog-7213353467455078818.post-57348036574699321752012-11-21T08:41:00.003-08:002012-11-21T08:47:28.841-08:00How to easily create a direct membership collection using another collection<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: Verdana, sans-serif;">We can very easily create a static collection by using a makecoll.exe, but this tool does not have an option to add more systems to an existing collection. It might take lot time and require manual efforts to add a large list of systems to an existing static collection(direct membership). The following tip might help you quickly add list of systems to an already existing collection....</span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;">1) Right click on the collection on which you like to add a list of systems that are available in another collection(source collection). Select Properties. </span><br />
<span style="font-family: Verdana, sans-serif;">2) Click on Membership Rules tab and click Next.</span><br />
<span style="font-family: Verdana, sans-serif;">3) Click on Computer icon to start the Create Direct Membership Rule Wizard.</span><br />
<span style="font-family: Verdana, sans-serif;">4) In the Search Resources wizard. </span><br />
<span style="font-family: Verdana, sans-serif;"> Select Resource Class: System Resources</span><br />
<span style="font-family: Verdana, sans-serif;"> Select Atribute Name: Netbios Name</span><br />
<span style="font-family: Verdana, sans-serif;"> in Value: type '%'</span><br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-N44iAwBvm9w/UK0EoGLOk3I/AAAAAAAABU8/ldt3HqVzPJY/s1600/Collection+Rule.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="302" src="http://2.bp.blogspot.com/-N44iAwBvm9w/UK0EoGLOk3I/AAAAAAAABU8/ldt3HqVzPJY/s400/Collection+Rule.png" width="400" /></a></div>
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;"><br /></span>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-hLEz0OXuF-c/UK0BPgBmlOI/AAAAAAAABUY/LVpxW8bN2w8/s1600/Collection+Rule.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: Verdana, sans-serif;"></span></a></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Verdana, sans-serif;">5) Click on next. </span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Verdana, sans-serif;">6) In the "Collection Limiting" wizard, in the search in this collection: type the your source collection name and click next. </span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-B8RSidyGgac/UK0CRu9h27I/AAAAAAAABUk/DkkY9sO-6P4/s1600/collection+rule2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: Verdana, sans-serif;"><img border="0" height="305" src="http://3.bp.blogspot.com/-B8RSidyGgac/UK0CRu9h27I/AAAAAAAABUk/DkkY9sO-6P4/s400/collection+rule2.png" width="400" /></span></a></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Verdana, sans-serif;">7) select the required computers and click Next. </span></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-Qjr8Vn9Vo7Y/UK0D7gTTgPI/AAAAAAAABU0/6zTYV8-k7Dk/s1600/Collection+Rule3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: Verdana, sans-serif;"><img border="0" height="305" src="http://4.bp.blogspot.com/-Qjr8Vn9Vo7Y/UK0D7gTTgPI/AAAAAAAABU0/6zTYV8-k7Dk/s400/Collection+Rule3.png" width="400" /></span></a></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<span style="font-family: Verdana, sans-serif;">8) Follow the wizard to complete it. </span></div>
Madanhttp://www.blogger.com/profile/14459115280044468451noreply@blogger.com3tag:blogger.com,1999:blog-7213353467455078818.post-12015884861218609092012-11-19T10:09:00.001-08:002012-11-20T05:43:49.672-08:00Get Number Of Cores and Logical Processors information in SCCM<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<span style="font-family: Verdana, sans-serif;">The default reporting in System Center Configuration Manager (SCCM) does not track the Number of Cores and Number of Logical Processors for each processor.The Win32_Processor WMI class contains number of cores (NumberOfCores) and logical processors (NumberOfLogicalProcessors) for each processor. It displays a unique DeviceID for each physical process in the system. This information is only available in newer version of OS's like Vista, Windows 7, Windows 2008, etc. For older version of OS like windows XP and Windows 2003 hotfix are available from Microsoft to populate this information </span><span style="font-family: Verdana, sans-serif;">in WMI</span><span style="font-family: Verdana, sans-serif;">. </span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<br />
<blockquote class="tr_bq">
<span style="font-family: Verdana, sans-serif;">Windows XP SP2: <a href="http://support.microsoft.com/kb/936235">http://support.microsoft.com/kb/936235</a></span></blockquote>
<blockquote class="tr_bq">
<span style="font-family: Verdana, sans-serif;">Windows 2003 SP1 or SP2: <a href="http://support.microsoft.com/kb/932370/en-us">http://support.microsoft.com/kb/932370/en-us</a></span></blockquote>
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;">The value for NumberOfLogicalProcessors will be higher than the value for NumberOfCores if the processor supports hyperthreading, which effectively splits a core into two logical processors. The challenge is that the reporting on Win32_Processor isn't enabled in the default sms_def.mof.</span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;">You can look at the information available in Win32_Processor WMI class using the following VB Script. </span><br />
<br />
<blockquote class="tr_bq">
<span style="font-family: Courier New; font-size: 10pt;"><span style="color: blue;">On</span> <span style="color: blue;">Error</span> <span style="color: blue;">Resume</span> <span style="color: blue;">Next</span><br />strComputer = <span style="color: grey;">"."</span><br /><span style="color: blue;">Set</span> objWMIService = <span style="color: blue;">GetObject</span>(<span style="color: grey;">"winmgmts:\\"</span> & strComputer & <span style="color: grey;">"\root\cimv2"</span>)<br /><span style="color: blue;">Set</span> colItems = objWMIService.ExecQuery(<span style="color: grey;">"Select * from Win32_Processor"</span>,,<span style="color: maroon;">48</span>)<br /><br /><span style="color: blue;">Dim</span> objItem <span style="color: green;">'as Win32_Processor</span><br /><span style="color: blue;">For</span> <span style="color: blue;">Each</span> objItem <span style="color: blue;">in</span> colItems<br /> WScript.Echo <span style="color: grey;">"AddressWidth: "</span> & objItem.AddressWidth<br /> WScript.Echo <span style="color: grey;">"Architecture: "</span> & objItem.Architecture<br /> WScript.Echo <span style="color: grey;">"Availability: "</span> & objItem.Availability<br /> WScript.Echo <span style="color: grey;">"Caption: "</span> & objItem.Caption<br /> WScript.Echo <span style="color: grey;">"ConfigManagerErrorCode: "</span> & objItem.ConfigManagerErrorCode<br /> WScript.Echo <span style="color: grey;">"ConfigManagerUserConfig: "</span> & objItem.ConfigManagerUserConfig<br /> WScript.Echo <span style="color: grey;">"CpuStatus: "</span> & objItem.CpuStatus<br /> WScript.Echo <span style="color: grey;">"CreationClassName: "</span> & objItem.CreationClassName<br /> WScript.Echo <span style="color: grey;">"CurrentClockSpeed: "</span> & objItem.CurrentClockSpeed<br /> WScript.Echo <span style="color: grey;">"CurrentVoltage: "</span> & objItem.CurrentVoltage<br /> WScript.Echo <span style="color: grey;">"DataWidth: "</span> & objItem.DataWidth<br /> WScript.Echo <span style="color: grey;">"Description: "</span> & objItem.Description<br /> WScript.Echo <span style="color: grey;">"DeviceID: "</span> & objItem.DeviceID<br /> WScript.Echo <span style="color: grey;">"ErrorCleared: "</span> & objItem.ErrorCleared<br /> WScript.Echo <span style="color: grey;">"ErrorDescription: "</span> & objItem.ErrorDescription<br /> WScript.Echo <span style="color: grey;">"ExtClock: "</span> & objItem.ExtClock<br /> WScript.Echo <span style="color: grey;">"Family: "</span> & objItem.Family<br /> WScript.Echo <span style="color: grey;">"InstallDate: "</span> & objItem.InstallDate<br /> WScript.Echo <span style="color: grey;">"L2CacheSize: "</span> & objItem.L2CacheSize<br /> WScript.Echo <span style="color: grey;">"L2CacheSpeed: "</span> & objItem.L2CacheSpeed<br /> WScript.Echo <span style="color: grey;">"L3CacheSize: "</span> & objItem.L3CacheSize<br /> WScript.Echo <span style="color: grey;">"L3CacheSpeed: "</span> & objItem.L3CacheSpeed<br /> WScript.Echo <span style="color: grey;">"LastErrorCode: "</span> & objItem.LastErrorCode<br /> WScript.Echo <span style="color: grey;">"Level: "</span> & objItem.Level<br /> WScript.Echo <span style="color: grey;">"LoadPercentage: "</span> & objItem.LoadPercentage<br /> WScript.Echo <span style="color: grey;">"Manufacturer: "</span> & objItem.Manufacturer<br /> WScript.Echo <span style="color: grey;">"MaxClockSpeed: "</span> & objItem.MaxClockSpeed<br /> WScript.Echo <span style="color: grey;">"Name: "</span> & objItem.Name<br /> WScript.Echo <span style="color: grey;">"NumberOfCores: "</span> & objItem.NumberOfCores<br /> WScript.Echo <span style="color: grey;">"NumberOfLogicalProcessors: "</span> & objItem.NumberOfLogicalProcessors<br /> WScript.Echo <span style="color: grey;">"OtherFamilyDescription: "</span> & objItem.OtherFamilyDescription<br /> WScript.Echo <span style="color: grey;">"PNPDeviceID: "</span> & objItem.PNPDeviceID<br /> WScript.Echo <span style="color: grey;">"PowerManagementCapabilities: "</span> & objItem.PowerManagementCapabilities<br /> WScript.Echo <span style="color: grey;">"PowerManagementSupported: "</span> & objItem.PowerManagementSupported<br /> WScript.Echo <span style="color: grey;">"ProcessorId: "</span> & objItem.ProcessorId<br /> WScript.Echo <span style="color: grey;">"ProcessorType: "</span> & objItem.ProcessorType<br /> WScript.Echo <span style="color: grey;">"Revision: "</span> & objItem.Revision<br /> WScript.Echo <span style="color: grey;">"Role: "</span> & objItem.Role<br /> WScript.Echo <span style="color: grey;">"SocketDesignation: "</span> & objItem.SocketDesignation<br /> WScript.Echo <span style="color: grey;">"Status: "</span> & objItem.Status<br /> WScript.Echo <span style="color: grey;">"StatusInfo: "</span> & objItem.StatusInfo<br /> WScript.Echo <span style="color: grey;">"Stepping: "</span> & objItem.Stepping<br /> WScript.Echo <span style="color: grey;">"SystemCreationClassName: "</span> & objItem.SystemCreationClassName<br /> WScript.Echo <span style="color: grey;">"SystemName: "</span> & objItem.SystemName<br /> WScript.Echo <span style="color: grey;">"UniqueId: "</span> & objItem.UniqueId<br /> WScript.Echo <span style="color: grey;">"UpgradeMethod: "</span> & objItem.UpgradeMethod<br /> WScript.Echo <span style="color: grey;">"Version: "</span> & objItem.Version<br /> WScript.Echo <span style="color: grey;">"VoltageCaps: "</span> & objItem.VoltageCaps<br /> WScript.Echo <span style="color: grey;">""</span><br /><span style="color: blue;">Next</span></span></blockquote>
<br />
<span style="font-family: Verdana, sans-serif;">To enable this class reporting in SCCM, the guidelines to update sms_def.mof can be found at this <a href="http://myitforum.com/cs2/blogs/skissinger/archive/2009/05/19/numberofcores-mof-edit.aspx">MyITForum</a> post. Aditional information about the Win32_Processors call can be found <a href="http://msdn.microsoft.com/en-us/library/aa394373(VS.85).aspx">here</a>.</span></div>
Madanhttp://www.blogger.com/profile/14459115280044468451noreply@blogger.com1tag:blogger.com,1999:blog-7213353467455078818.post-79854690000134863332012-10-12T02:17:00.000-07:002012-10-12T02:20:04.690-07:00Enabling Debug and Verbose Logging <div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<span style="font-family: 'Trebuchet MS', sans-serif;">To enable debug logging after installation, create the following registry key:</span><br />
<blockquote class="tr_bq">
<span style="font-family: Trebuchet MS, sans-serif;">HKLM\SOFTWARE\Microsoft\CCM\Logging\debuglogging</span></blockquote>
<span style="font-family: Trebuchet MS, sans-serif;">To enable verbose logging after installation, change the following value to 0. You will need to right click on the @Global key and change permissions to allow the current user to change the data in the key.</span><br />
<blockquote class="tr_bq">
<span style="font-family: Trebuchet MS, sans-serif;">HKLM\Software\Microsoft\CCM\Logging\@Global\Loglevel</span></blockquote>
<br />
<br /></div>
Madanhttp://www.blogger.com/profile/14459115280044468451noreply@blogger.com0tag:blogger.com,1999:blog-7213353467455078818.post-39113560706975399042012-02-22T03:36:00.000-08:002012-11-28T10:06:05.024-08:00How install SMS Installer on a workstation<div dir="ltr" style="text-align: left;" trbidi="on">
<div dir="ltr" style="text-align: left;" trbidi="on">
<div dir="ltr" trbidi="on">
<span style="font-family: Trebuchet MS, sans-serif;">Download SMS installer from <a href="http://technet.microsoft.com/en-us/systemcenter//dd408384.aspx">http://technet.microsoft.com/en-us/systemcenter//dd408384.aspx</a> or </span></div>
<div dir="ltr" trbidi="on">
<span style="font-family: Trebuchet MS, sans-serif;"><a href="http://www.microsoft.com/en-us/download/details.aspx?id=15534">http://www.microsoft.com/en-us/download/details.aspx?id=15534</a></span></div>
<div dir="ltr" trbidi="on">
<span style="font-family: Trebuchet MS, sans-serif;"><br /></span></div>
<div dir="ltr" trbidi="on">
<span style="font-family: Trebuchet MS, sans-serif;">If you attempt to install SMS installer, you will get the following error.</span></div>
<div dir="ltr" trbidi="on">
<span style="font-family: Trebuchet MS, sans-serif;"><br /></span></div>
<div dir="ltr" trbidi="on">
<blockquote class="tr_bq">
<span style="font-family: Trebuchet MS, sans-serif;">Setup has detected that this computer is not Microsoft Systems Management Server site server. This installation can only be run on a site server.</span></blockquote>
</div>
<div dir="ltr" trbidi="on">
<span style="font-family: Trebuchet MS, sans-serif;"><br /></span></div>
<div dir="ltr" trbidi="on">
<span style="font-family: Trebuchet MS, sans-serif;">To turn your workstation to Microsoft Systems Management Server site server, add the following registry key ;-)</span></div>
<div dir="ltr" trbidi="on">
<span style="font-family: Trebuchet MS, sans-serif;"><br /></span></div>
<div dir="ltr" trbidi="on">
<blockquote class="tr_bq">
<span style="font-family: Trebuchet MS, sans-serif;">HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Setup\Type</span><span style="font-family: Trebuchet MS, sans-serif;">And change the "Type" Dword from 4 (Workstation) to 1 (Primary Server)</span><span style="font-family: Trebuchet MS, sans-serif;">Re-try the SMS installer installation.</span></blockquote>
</div>
</div>
</div>
Madanhttp://www.blogger.com/profile/14459115280044468451noreply@blogger.com1tag:blogger.com,1999:blog-7213353467455078818.post-76731319415780174442011-09-08T12:03:00.000-07:002011-09-08T12:06:01.693-07:00How to create a collection of all approved clients<div dir="ltr" style="text-align: left;" trbidi="on"><span style="font-family: Verdana, sans-serif;">This collection will allow you to find machines that need approval.</span><br />
<span style="font-family: Verdana, sans-serif;"><br />
</span><br />
<strong><span style="font-family: Verdana, sans-serif;">For Is Approved</span></strong><br />
<span style="font-family: Verdana, sans-serif;"><blockquote><span style="font-family: Verdana, sans-serif;">select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,</span><br />
<span style="font-family: Verdana, sans-serif;">SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,</span><br />
<span style="font-family: Verdana, sans-serif;">SMS_R_SYSTEM.ResourceDomainORWorkgroup,</span><br />
<span style="font-family: Verdana, sans-serif;">SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_CM_RES_COLL_SMS00001 on </span><br />
<span style="font-family: Verdana, sans-serif;">SMS_CM_RES_COLL_SMS00001.ResourceId = SMS_R_System.ResourceId </span><br />
<span style="font-family: Verdana, sans-serif;">where SMS_CM_RES_COLL_SMS00001.IsApproved= '1' </span></blockquote><br />
<span style="font-family: Verdana, sans-serif;">Replace this section for not approved and unknown:</span><br />
<span style="font-family: Verdana, sans-serif;"><strong>For not approved </strong></span><span style="font-family: Verdana, sans-serif;"><br />
</span><br />
<blockquote><span style="font-family: Verdana, sans-serif;">SMS_CM_RES_COLL_SMS00001.IsApproved= '0' </span></blockquote><br />
<span style="font-family: Verdana, sans-serif;"><strong>For Unknown</strong> </span><br />
<blockquote><span style="font-family: Verdana, sans-serif;">SMS_CM_RES_COLL_SMS00001.IsApproved= '2' </span></blockquote><br />
<span style="font-family: Verdana, sans-serif;">I did not write this collection, I will be glade to give credit to whom ever it was :-)</span></span><span style="font-family: Verdana, sans-serif;"><br />
</span></div>Madanhttp://www.blogger.com/profile/14459115280044468451noreply@blogger.com4tag:blogger.com,1999:blog-7213353467455078818.post-20797929371434512932011-09-08T11:42:00.000-07:002011-09-08T11:54:28.433-07:00How to create a collection of all non client systems<div dir="ltr" style="text-align: left;" trbidi="on"><span style="font-family: Verdana, sans-serif;">Here is a query that helps create a collection to list all the non SMS/SCCM clients. </span><br />
<br />
<span style="font-family: Verdana, sans-serif;"></span><br />
<blockquote><span style="font-family: Verdana, sans-serif;">select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,<br />
SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,<br />
SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client<br />
from SMS_R_System where <br />
SMS_R_System.Client is null OR SMS_R_System.Client = 0</span></blockquote></div>Madanhttp://www.blogger.com/profile/14459115280044468451noreply@blogger.com0tag:blogger.com,1999:blog-7213353467455078818.post-66183350419912163282011-02-04T12:33:00.000-08:002011-02-04T12:33:12.855-08:00Solution: OnSearchComplete - Failed to end search job. Error = 0x80072efe<div dir="ltr" style="text-align: left;" trbidi="on"><span style="font-family: "Segoe UI"; font-size: 10pt;">Errror in WUAHandler.log: </span><br />
<div class="MsoNormal" style="margin: 0in 0in 0pt;"><b style="mso-bidi-font-weight: normal;"><span style="font-family: "Segoe UI"; font-size: 10pt;">OnSearchComplete - Failed to end search job. Error = 0x80072efe.<br />
Scan failed with error = 0x80072efe. </span></b></div><br />
<div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: "Segoe UI"; font-size: 10pt;">Step 1: Check background programs. </span></div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: "Segoe UI"; font-size: 10pt;">=======================</span></div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: "Segoe UI"; font-size: 10pt;">Disable firewalls or other Internet browser programs that can affect the Internet connection. The following programs can affect the connection to the Windows Update site and I suggest you remove or disable them: </span></div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><br />
</div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: "Segoe UI"; font-size: 10pt;">McAfee firewall</span></div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: "Segoe UI"; font-size: 10pt;">Norton Internet Security</span></div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: "Segoe UI"; font-size: 10pt;">Zone Alarm Firewall</span></div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: "Segoe UI"; font-size: 10pt;">Panda firewall</span></div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><br />
</div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><br />
</div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: "Segoe UI"; font-size: 10pt;">Step 2: Delete the CatRoot2 folder</span></div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: "Segoe UI"; font-size: 10pt;">=======================</span></div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: "Segoe UI"; font-size: 10pt;">A: Stop Cryptographic Services: </span></div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><br />
</div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: "Segoe UI"; font-size: 10pt;">1. Click Start, click Run, type in "SERVICES.MSC" and press Enter. </span></div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: "Segoe UI"; font-size: 10pt;">2. Double click Cryptographic Services, and then click Stop (if it has been started). </span></div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><br />
</div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: "Segoe UI"; font-size: 10pt;">B: After stopping Cryptographic Service, please delete the "Catroot2" folder: </span></div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><br />
</div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: "Segoe UI"; font-size: 10pt;">1. Locate the "C:\Windows\System32\" folder. </span></div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: "Segoe UI"; font-size: 10pt;">2. Delete the Catroot2 subfolder in System32. </span></div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><br />
</div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: "Segoe UI"; font-size: 10pt;">Note: I am assuming your Windows Vista is installed in C:\Windows. </span></div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><br />
</div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: "Segoe UI"; font-size: 10pt;">C: Re-start Cryptographic Services: </span></div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><br />
</div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: "Segoe UI"; font-size: 10pt;">1. Click Start, click Run, type in "SERVICES.MSC" and press Enter. </span></div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: "Segoe UI"; font-size: 10pt;">2. Double click Cryptographic Services, and then click Start. </span></div></div>Madanhttp://www.blogger.com/profile/14459115280044468451noreply@blogger.com1tag:blogger.com,1999:blog-7213353467455078818.post-57603124620363899052011-01-27T00:14:00.000-08:002011-01-27T00:14:34.829-08:00Last Hardware inventory date for the systems that are assigned to a Site code<div dir="ltr" style="text-align: left;" trbidi="on"><span style="font-family: "Segoe UI"; font-size: 10pt;"> <blockquote><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: "Segoe UI"; font-size: 10pt;">set @SMSSiteCode = (case when IsNULL(@SMSSiteCode,'')='' then '%' else @SMSSiteCode end)</span></div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><br />
</div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: "Segoe UI"; font-size: 10pt;">SELECT DISTINCT SYS.Netbios_Name0, SYS.Operating_System_Name_and0,</span></div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: "Segoe UI"; font-size: 10pt;"><span style="mso-spacerun: yes;"> </span>HWSCAN.LastHWScan, SWSCAN.LastScanDate, SWSCAN.LastCollectedFileScanDate, v_RA_System_SMSAssignedSites.SMS_Assigned_Sites0</span></div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: "Segoe UI"; font-size: 10pt;">FROM v_R_System SYS</span></div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: "Segoe UI"; font-size: 10pt;">LEFT JOIN v_GS_LastSoftwareScan SWSCAN on SYS.ResourceID = SWSCAN.ResourceID</span></div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: "Segoe UI"; font-size: 10pt;">LEFT JOIN v_GS_WORKSTATION_STATUS HWSCAN on SYS.ResourceID = HWSCAN.ResourceID left join v_RA_System_SMSAssignedSites on v_RA_System_SMSAssignedSites.ResourceID = SYS.ResourceID where v_RA_System_SMSAssignedSites.SMS_Assigned_Sites0 like @SMSSiteCode</span></div></blockquote><div class="MsoNormal" style="margin: 0in 0in 0pt;"></div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: "Segoe UI"; font-size: 10pt;">Create a prompt with a variable name - SMSsitecode</span></div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><br />
</div><span style="font-family: "Segoe UI"; font-size: 10pt;"><blockquote><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: "Segoe UI"; font-size: 10pt;">begin<br />
if (@__filterwildcard = '')<br />
select distinct SMS_Assigned_Sites0 as SMSSiteCode From v_RA_System_SMSAssignedSites<br />
else<br />
select distinct SMS_Assigned_Sites0 as SMSSiteCode from v_RA_System_SMSAssignedSites<br />
where ((SMS_Assigned_Sites0 like @__filterwildcard))<br />
order by SMS_Assigned_Sites0<br />
end</span></div></blockquote></span></span><span style="font-family: "Segoe UI"; font-size: 10pt;"></span></div>Madanhttp://www.blogger.com/profile/14459115280044468451noreply@blogger.com0tag:blogger.com,1999:blog-7213353467455078818.post-84789501513368887902011-01-26T14:28:00.000-08:002011-01-26T14:28:35.972-08:00ConfigMgr Report to show available Hard Drive space on machines with its client version<div dir="ltr" style="text-align: left;" trbidi="on"><span style="font-family: "Segoe UI"; font-size: 10pt;"> <blockquote><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: "Segoe UI"; font-size: 10pt;">select </span></div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: "Segoe UI"; font-size: 10pt;">v_R_System.Name0, client_version0,v_GS_LOGICAL_DISK.Name0 as Drive, </span></div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: "Segoe UI"; font-size: 10pt;">v_GS_LOGICAL_DISK.Size0 as Size, </span></div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: "Segoe UI"; font-size: 10pt;">v_GS_LOGICAL_DISk.FreeSpace0 as FreeSpace, size0 as Used</span></div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: "Segoe UI"; font-size: 10pt;">from</span></div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: "Segoe UI"; font-size: 10pt;">v_R_System inner join v_GS_LOGICAL_DISK on v_R_System</span></div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: "Segoe UI"; font-size: 10pt;">.ResourceID = v_GS_LOGICAL_DISK.ResourceID inner join v_FullCollectionMembership on v_FullCollectionMembership.ResourceID=v_R_System</span></div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: "Segoe UI"; font-size: 10pt;">.ResourceID</span></div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: "Segoe UI"; font-size: 10pt;">where</span></div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: "Segoe UI"; font-size: 10pt;">v_GS_LOGICAL_DISK.DriveType0 = 3 and v_FullCollectionMembership.CollectionID = @CollectionID</span></div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: "Segoe UI"; font-size: 10pt;">order</span></div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: "Segoe UI"; font-size: 10pt;">by FreeSpace</span></div></blockquote></span><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: "Segoe UI"; font-size: 10pt;">Create a prompt Query with a variable “CollectionID”</span></div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><br />
</div><span style="font-family: "Segoe UI"; font-size: 10pt;"><blockquote><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: "Segoe UI"; font-size: 10pt;">select CollectionID,Name from v_Collection</span></div></blockquote></span></div>Madanhttp://www.blogger.com/profile/14459115280044468451noreply@blogger.com1tag:blogger.com,1999:blog-7213353467455078818.post-16505762063080194212011-01-22T23:16:00.000-08:002011-01-22T23:19:18.469-08:00ConfigMgr SQL query to list hardware and add/remove programs inventory for a client<div dir="ltr" style="text-align: left;" trbidi="on"><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: "Segoe UI"; font-size: 10pt;">It lists NetBIOS Name, Install Site Code, processor Name, Processor Manufacturer, Model, Total Physical Memory, and Serial Number for a selected client. </span></div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: "Segoe UI"; font-size: 10pt;">It also lists the add remove programs inventory for a client. </span></div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><br />
</div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: "Segoe UI"; font-size: 10pt;">SQL Query: </span></div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: "Segoe UI"; font-size: 10pt;">SELECT V_R_SYSTEM.Name0,v_RA_System_SMSInstalledSites.SMS_Installed_Sites0,v_GS_PROCESSOR.Name0,v_GS_COMPUTER_SYSTEM.Manufacturer0,v_GS_COMPUTER_SYSTEM.Model0,v_GS_COMPUTER_SYSTEM.Name0,v_GS_X86_PC_MEMORY.TotalPhysicalMemory0,v_GS_PC_BIOS.SerialNumber0 from v_r_system inner join v_GS_PROCESSOR on v_R_system.ResourceID=v_GS_PROCESSOR.ResourceID inner join v_GS_COMPUTER_SYSTEM on v_GS_COMPUTER_SYSTEM.ResourceID=v_r_system.ResourceID inner join v_GS_X86_PC_MEMORY on v_GS_X86_PC_MEMORY.ResourceID=v_r_system.ResourceID inner join v_RA_System_SMSInstalledSites on v_RA_System_SMSInstalledSites.ResourceID=v_r_system.ResourceID inner join v_GS_PC_BIOS on v_GS_PC_BIOS.ResourceID=V_r_system.ResourceID where v_r_system.Name0 like @computername</span></div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><br />
</div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: "Segoe UI"; font-size: 10pt;">Select v_Add_Remove_Programs.DisplayName0, v_Add_Remove_Programs.Publisher0, v_Add_Remove_Programs.Version0</span></div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: "Segoe UI"; font-size: 10pt;">FROM v_Add_Remove_Programs </span></div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: "Segoe UI"; font-size: 10pt;">JOIN<span style="mso-spacerun: yes;"> </span>v_R_System ON v_Add_Remove_Programs.ResourceID = v_R_System.ResourceID </span></div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: "Segoe UI"; font-size: 10pt;">WHERE v_R_System.Netbios_Name0 = @computername</span></div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><br />
</div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: "Segoe UI"; font-size: 10pt;">Prompt Query: </span></div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><br />
</div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: "Segoe UI"; font-size: 10pt;">Create a prompt with a variable “<b style="mso-bidi-font-weight: normal;">computername</b>” using the following query. </span></div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><br />
</div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: "Segoe UI"; font-size: 10pt;">begin</span></div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: "Segoe UI"; font-size: 10pt;"><span style="mso-spacerun: yes;"> </span>if (@__filterwildcard = '')</span></div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: "Segoe UI"; font-size: 10pt;"><span style="mso-spacerun: yes;"> </span>SELECT DISTINCT SYS.Netbios_Name0 from v_R_System SYS WHERE SYS.Client0=1 ORDER By SYS.Netbios_Name0</span></div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: "Segoe UI"; font-size: 10pt;"><span style="mso-spacerun: yes;"> </span>else</span></div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: "Segoe UI"; font-size: 10pt;"><span style="mso-spacerun: yes;"> </span>SELECT DISTINCT SYS.Netbios_Name0 from v_R_System SYS WHERE SYS.Client0=1</span></div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: "Segoe UI"; font-size: 10pt;"><span style="mso-spacerun: yes;"> </span>and SYS.Netbios_Name0 like @__filterwildcard</span></div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: "Segoe UI"; font-size: 10pt;"><span style="mso-spacerun: yes;"> </span>ORDER By SYS.Netbios_Name0</span></div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: "Segoe UI"; font-size: 10pt;">end</span></div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><br />
</div></div>Madanhttp://www.blogger.com/profile/14459115280044468451noreply@blogger.com0tag:blogger.com,1999:blog-7213353467455078818.post-39057440021406428322011-01-18T21:57:00.000-08:002011-01-18T21:57:18.351-08:00WQL query list all the systems that does not contain a particular software<span style="font-family: "Segoe UI"; font-size: 10pt;"> <blockquote><span style="font-family: "Segoe UI"; font-size: 10pt;">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 inner join SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SYSTEM.ResourceID not in (select SMS_R_System.Resourceid from SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceId = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = "Symantec Endpoint Protection")</span></blockquote></span>Madanhttp://www.blogger.com/profile/14459115280044468451noreply@blogger.com0tag:blogger.com,1999:blog-7213353467455078818.post-90383946702450503922011-01-16T08:25:00.000-08:002011-01-16T08:26:13.162-08:00Query to list both X64 and X86 system with a program installled.<span style="font-family: "Segoe UI"; font-size: 10pt;">The following query returns all the x64 and x86 systems that are installed with VMWare tools.<span style="mso-spacerun: yes;"> </span>You can replace “VMware Tools” with your program Add Remove Program’s to query for other programs. </span><br />
<br />
<span style="font-family: "Segoe UI"; font-size: 10pt;"><blockquote><span style="font-family: "Segoe UI"; font-size: 10pt;">select SMS_R_System.NetbiosName from SMS_R_System where SMS_R_System.ResourceId in (select SMS_R_System.ResourceID from SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = "VMware Tools") or SMS_R_System.ResourceId in (select SMS_R_System.ResourceID from SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS_64 on SMS_G_System_ADD_REMOVE_PROGRAMS_64.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS_64.DisplayName = "VMware Tools") order by SMS_R_System.NetbiosName</span></blockquote></span><div class="MsoNormal" style="margin: 0in 0in 0pt;"><br />
</div>Madanhttp://www.blogger.com/profile/14459115280044468451noreply@blogger.com3tag:blogger.com,1999:blog-7213353467455078818.post-24169356124290500712011-01-13T00:26:00.000-08:002011-01-13T00:26:37.485-08:00SMS/ConfigMgr SQL query to find the list of systems in a specific IP subnet<span style="font-family: "Segoe UI"; font-size: 10pt;"> <blockquote><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: "Segoe UI"; font-size: 10pt;">SELECT SYS.Netbios_Name0, SYS.User_Domain0, SYS.User_Name0, AIP.IP_Subnets0, SYS.Client_Version0</span></div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: "Segoe UI"; font-size: 10pt;">FROM v_R_System<span style="mso-spacerun: yes;"> </span>as SYS</span></div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: "Segoe UI"; font-size: 10pt;">JOIN v_RA_System_IPSubnets as AIP on SYS.ResourceID=AIP.ResourceID</span></div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: "Segoe UI"; font-size: 10pt;">WHERE AIP.IP_Subnets0 = '192.168.0.0'</span></div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: "Segoe UI"; font-size: 10pt;">Order by SYS.Netbios_Name0</span></div></blockquote><div class="MsoNormal" style="margin: 0in 0in 0pt;"></div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="font-family: "Segoe UI"; font-size: 10pt;">Replace 192.168.0.1 with your IP subnet. </span></div></span><span style="font-family: "Segoe UI"; font-size: 10pt;"></span>Madanhttp://www.blogger.com/profile/14459115280044468451noreply@blogger.com1tag:blogger.com,1999:blog-7213353467455078818.post-48237450678948189332011-01-13T00:22:00.000-08:002011-01-13T00:22:46.842-08:00SMS/ConfigMgr SQL query to list the systems in specific IP subnets<span style="font-family: "Segoe UI"; font-size: 10pt;"> <blockquote><span style="font-family: "Segoe UI"; font-size: 10pt;">SELECT SYS.Netbios_Name0, SYS.User_Domain0, SYS.User_Name0, AIP.IP_Subnets0, SYS.Client_Version0<br />
FROM v_R_System as SYS<br />
JOIN v_RA_System_IPSubnets as AIP on SYS.ResourceID=AIP.ResourceID<br />
WHERE AIP.IP_Subnets0 in ('192.168.0.0','192.168.1.0') <br />
Order by SYS.Netbios_Name0</span></blockquote><br />
<span style="font-family: "Segoe UI"; font-size: 10pt;">Replace '192.168.0.0','192.168.1.0'... with your list of IP Subnets.</span><br />
<div class="MsoNormal" style="margin: 0in 0in 0pt;"><br />
</div></span><span style="font-family: "Segoe UI"; font-size: 10pt;"></span>Madanhttp://www.blogger.com/profile/14459115280044468451noreply@blogger.com0tag:blogger.com,1999:blog-7213353467455078818.post-81839632996013761532011-01-12T07:43:00.000-08:002011-01-12T23:57:21.030-08:00SMS/SCCM SQL Query Netbios Name, Model , CPU name, Memory (Ram) and Sitecode<div style="background: white; line-height: 125%;"><div style="background: white; line-height: 125%;"><span style="color: #333333; font-family: "Segoe UI"; font-size: 10pt; line-height: 125%;"></span><br />
<blockquote><span style="color: #333333; font-family: "Segoe UI"; font-size: 10pt; line-height: 125%;">SELECT V_R_SYSTEM.Name0,v_RA_System_SMSInstalledSites.SMS_Installed_Sites0,v_GS_PROCESSOR.Name0,v_GS_COMPUTER_SYSTEM.Manufacturer0,v_GS_COMPUTER_SYSTEM.Model0,v_GS_COMPUTER_SYSTEM.Name0,v_GS_X86_PC_MEMORY.TotalPhysicalMemory0 from v_r_system inner join v_GS_PROCESSOR on v_R_system.ResourceID=v_GS_PROCESSOR.ResourceID inner join v_GS_COMPUTER_SYSTEM on v_GS_COMPUTER_SYSTEM.ResourceID=v_r_system.ResourceID inner join v_GS_X86_PC_MEMORY on v_GS_X86_PC_MEMORY.ResourceID=v_r_system.ResourceID inner join v_RA_System_SMSInstalledSites on v_RA_System_SMSInstalledSites.ResourceID=v_r_system.ResourceID</span></blockquote></div></div>Madanhttp://www.blogger.com/profile/14459115280044468451noreply@blogger.com3