Advertisement status tracking

How to read the advertisement reports:-

Accepted – Software can be installed in few mins, as it will start downloading the software from remote /local system

No Status - Systems are not online or has issue with SMS Agent, or not received the policy, if the system is online then this status must change in one hour time (if the status not changed then you may

     Suspect the issue with SMS / SCCM agent )

Accepted - No Further Status – Back end installation may be running and need to wait for some time to get the actual status

Failed – Software installation failed, you need to re push once again this advertisement.

Succeeded – Software installed successfully without any issues

SQL Reporting Services: SRS

SQL Reporting services have some benefits over the current reporting solution:

• Provide best in class reporting capability by integrating SQL Reporting Services, with the leading change and configuration management product: SCCM 2007
• Enable Ad-hoc reporting - Make it easy for both SCCM administrators, and non administrators to find the information they need to make the right decisions for their business
• Support alternative databases as the reporting database, such as a replicated or backup database
• Allow custom report creation via a report authoring wizard.
• Enable report browsing and viewing via the SRS Report Viewer.
• Take advantage of rendering in all supported SRS formats, report caching, and subscriptions.

This article will explain setting up SRS with Configuration Manager based on SQL 2008. I’ve taken most of the steps from this article (many thanks to Michael Wiles). I’ve added some screenshots and applied it to SQL 2008, while the original article discusses SQL 2005. If you need more background info on SRS check out that link.

Install and configure SQL Reporting Services in SQL 2008

 

Be sure to check Reporting Services as part of your SQL installation

At step 21 of this part of this guide the setup provides you with three choices:

• Native mode default configuration
• SharePoint mode default configuration
• Unconfigured Reporting Services installation

You should select Unconfigured Reporting Services installation at this point.

After the installation finishes you should configure SRS for the use with Configuration Manager 2007.

1. In the start menu select Microsoft SQL Server 2008 / Configuration Tools, then click Reporting Services Configuration Manager.

2. In the Reporting Services Configuration Connection select the Server Name and the Report Server Instance, then select Connect.

3. In the Report Server Status verify that the Service Status is set to Running. If it is not, click Start, and then click Apply.

4. Select Web Service URL and make sure you specify the name you want to call the virtual directory created by Reporting Services (or use the default ReportServer). Optionally you can select the IP-address you want to use, the port and SSL setting. When done click Apply.

5. Select Database, select Create a new report server database in the Report Server Database Configuration Wizard and click Next

6. Select the Database Server Name and Authentication Type that matches your SQL server and credentials.

7. Supply the Database Name and Language. Be sure to select Native Mode for Report Server Mode. Click Next.

8. Select the proper credentials from the drop list for Authentication Type

9. In the Summary screen review your settings and Click Next.

10. Review your database in the Report Server Database screen.

11. Select Report Manager URL and make sure you specify the name you want to call the virtual directory created by Reporting Services (or use the default Reports). Optionally you can select the IP-address you want to use, the port and SSL setting. When done click Apply.

12. Email settings are not mandatory to setup, but can be configured appropiately if necessary.

13. Execution Account is necessary to configure if you will be running unattended reports. Optionally apply credentials and Click Apply.

20. Click Exit to close Reporting Services Configuration Manager.

Configure Configuration Manager 2007

SQL Reporting Services need the configuration of a Reporting Services Point role.

1. In the Configuration Manager console, navigate to System Center Configuration Manager / Site Database / Site Management / <site code>-<site name> / Site Settings / Site Systems.

2. In this guide I will add the reporting services point site role to the existing site system. Right-click the site system name, and click New Roles. On the General page of the New Site Role Wizard, configure the general settings for this site system, then click Next.

3. On the System Role Selection page of the wizard, select Reporting Services point (don’t select Reporting Point by mistake, which is the traditional reporting functionality), then click Next.

5. On the Reporting Services Point page, specify the folder that will be created on the report server to contain the SQL Reporting Services reports used in Configuration Manager and then click Next.

6. Review the information shown on the Summary page, then click Next.

7. Click Close to exit the wizard.

8. In the Configuration Manager console, navigate to System Center Configuration Manager / Site Database / Computer Management / Reporting / Reporting Services, and expand the node.

9. Right-click the reporting services point server you want to configure, then click Properties.

10. On the Data Source Settings tab of the Report Server Properties dialog box, specify the Configuration Manager 2007 database server and database name (not the one create earlier for reporting!) to be used as the data source for SQL Reporting Services reports. Click the test button to verify that you have correct data entered.

11. On the Data Source Authentication tab of the Report Server Properties dialog box, specify the credentials used to access reports on the report server. I’ve use Windows Integrated Security here.

12. On the Data Source Security tab of the Report Server Properties dialog box, specify permissions for the users who have access to the data source specified in the Data Source Settings tab.

13. On the Security tab of the Report Server Properties dialog box, specify the users who have access to the selected report server.

14. Click OK to close the Report Server Properties dialog box.

Import standard reports in Reporting Services

The last step in configuring SRS for Configuration Manager 2007 is to convert the standard reports to Reporting Services reports.

1. In the Configuration Manager console, navigate to System Center Configuration Manager / Site Database / Computer Management / Reporting / Reporting Services

2. Right-click the Reporting Services server that the standard reports will be copied to, then click Copy Reports to Reporting Services.

3. On the Data Source Settings page of the Copy Reports Wizard, specify the Configuration Manager 2007 database server and database name from which to copy the reports. Click Next.

4. On the Data Source Authentication page of the Copy Reports Wizard, choose the authentication method required to run the copied reports on the reporting point server. Click Next.

5. On the Select Reports page of the Copy Reports Wizard, select the reports you want to copy to the reporting services point. Select Overwrite existing reports if you want to overwrite any reports that already exist on the reporting services point. Click Next.

6. On the Security page of the Copy Reports Wizard, specify which users can access the copied reports and the roles they must belong to. For more information about the options on this page, see Report Server Properties: Security Tab. Click Next

7. On the Summary page of the Copy Reports Wizard, review the reports that will be created, and then click Next.

8. After the reports are copied, click Next.

9. On the Confirmation page of the Copy Reports Wizard, review the information, and then click Close to exit the wizard.

Reports are now available Site Database / Computer Management / Reporting / Reporting Services / <Site Server> / All Reports

To run a particular report just Right Click the report and select Run.

For finding the 90 days old computers in the AD

 

 

For finding the 90 days old computers in the AD

DSQUERY COMPUTER "DC=MydomainName,DC=COM" -STALEPWD 90 -LIMIT 5000 >> C:\output.csv

for finding the 90 days old computers in the AD & action to delete with the output

DSQUERY COMPUTER "OU=COMPUTERS,DC=LANDESK,DC=COM" -STALEPWD 90 -LIMIT 5000 | DSRM -NOPROMPT >C:\Output.csv

Day to Day Operations SCCM / ConfigMgr 2007 Reports

I recommend below ConfigMgr Reports to be familiar and these might be useful in day to day operations

 

Asset Intelligence:-

License 03A - Count of licenses by license status
Hardware 07A - USB devices by manufacturer

Software 02C - Software by Category and Family

Software 01A - Summary of installed software in a specific collection

This report provides a summary of installed software ordered by the number of instances found from inventory.

Desired Configuration Management – Compliance

Summary compliance for a collection by computer

Hardware

Count physical disk configurations

Computers with low free disk space (less than specified MB free)

Computers with low free disk space (less than specified % free)

Count memory configurations

Computers with low memory (less than or equal to specified MB)

Computers with a specific amount of memory

Memory information for a specific computer

Network

Count IP addresses by subnet

IP - Information for a specific computer

NAP

List of NAP-capable and NAP-upgradable computers

List of Network Access Protection policies

Operating System

Windows Server computers

Computers with a specific operating system and service pack

Computers with a specific operating system

Count operating systems and service packs

Count operating system versions

Services - Computers running a specific service

SMS/SCCM Client

Count SMS client versions

Servers with no client Installed

Client Deployment Failure Report

Client Deployment Success Report

Client Deployment Status Details

Client Assignment Failure Details

Count clients assigned and installed for each site

Computers with a specific SMS client version

Count clients for each site

Computers with duplicate MAC addresses

Computers that may share the same SMS Unique ID

Clients that have not reported recently (Collection)

& Clients that have not reported recently (in a specified number of days)

Site TO Site Reports:

Sites by hierarchy with time of last site status update

Computers in a specific site
Status messages for a branch distribution point
Site system roles and servers for a specific site

Software Inventory

Software registered in Add Remove Programs for a specific collection
Computers with specific software registered in Add Remove Programs
Computers with a specific product
Count of all instances of software registered with Add or Remove Programs
Computers with a specific product name and version
Count computers with a specific filename

Software Distribution:-

Status of a specific advertisement
All advertisements for a specific collection
All advertisements
Distribution status of a specific package
All packages on a specific distribution point
All distribution points
All active package distributions

Patching:-

Compliance 1 - Overall Compliance
Compliance 4 - Deployment (per update)
Compliance 3 - Update list (per update)
Compliance 4 - Deployment (per update)
Management 1 - Updates required but not deployed
Management 2 - Updates in a deployment
States 1 - Enforcement states for a deployment
States 2 - Evaluation states for a deployment
Scan 1 - Last scan states by collection
Scan 2 - Last scan states by site

Auditing

All audit messages for a specific user
All Task Sequence Advertisements
Deployment status of all task sequence advertisements
Progress of a running task sequence
Progress of OS deployment task sequences
Status of all unknown computers
Computers for a specific user name
WOL

All sites that are enabled for Wake On LAN
All computers targeted for Wake On LAN activity
All objects pending wake-up activitiy

Customized reports:

All computers based on AD site:

SELECT DISTINCT SYS.Name0,SYS.AD_Site_Name0,

SYS.User_Domain0,SYS.User_Name0,

SYS.Operating_System_Name_and0

FROM v_R_System SYS

WHERE SYS.AD_Site_Name0 LIKE @variable

ORDER BY SYS.AD_Site_Name0, SYS.Name0

--Prompt Query

SELECT DISTINCT SYS.Name0,SYS.AD_Site_Name0,

SYS.User_Domain0,SYS.User_Name0,

SYS.Operating_System_Name_and0

FROM v_R_System SYS

WHERE SYS.AD_Site_Name0 LIKE @variable

ORDER BY SYS.AD_Site_Name0, SYS.Name0

Lins with reports =è Hardware - General - Computer information for a specific computer; below is the screenshot

Also I prefer one to have below custom reports

Compliance - Detailed list - specific collection

Computer Information - specific collection

Computer information for a collection of computers

Computers with specific software

Distribution Points in All DP Group

Missing Patches

Network settings

Network settings for a specific collection

Servers with SCCM Client version
All Workstation Patching compliance reports
All Desktops & Laptops model & make reports

HTTP 500 Internal Server Error when accessing SCCM Reports

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

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

To change the number of rows returned by a report query, create the Rowcount DWORD value under the HKEY_LOCAL_MACHINE\Software\Microsoft\SMS\Reporting registry key.

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

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

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

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

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

cd /d %systemdrive%\inetpub\adminscripts

• Type the following command, and then press ENTER:

cscript.exe adsutil.vbs SET w3svc/aspbufferinglimit LimitSize

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

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

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

cd /d %systemdrive%\inetpub\adminscripts

• Type the following command, and then press ENTER:

cscript.exe adsutil.vbs GET w3svc/aspbufferinglimit

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

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

to find out linked report ID in all reports

SELECT     TOP (100) PERCENT ReportID, Name, Category, DrillThroughReportID
FROM       dbo.v_Report
WHERE      (NOT (DrillThroughReportID IS NULL))
ORDER BY   ReportID

Reports: Search keys- SCCM 2007 Search keys in the reports more than %

SCCM 2007 Search keys in the reports more than %

We're all familiar with the "%" wildcard, However if you want more search like google.... then.. here are the tips
Check this out (from the Admin guide):
% (percent sign)Any string of zero or more characters. For example:Mo% searches for all names that begin with the letters mo (Mom, Morgan)
%mo searches for all names that end with mo (Satchmo)
%mo% searches for all names that include mo (Mom, Satchmo, tomorrow).
_ (underscore)Any single character. For example:
_ill searches for any four-letter names ending with the letters ill (mill, Will)
[] (brackets)Any single character within the specified range. For example:
[HD]an[eo]n searches for all names that begin with H or D, then an, then e or o, and then end with n (Hanson, Hansen, Danson, Dansen)
[B-K]enson searches for all names ending with enson that begin with any single letter from B through K (Benson, Jenson)
[^] (caret)Any single character not within the specified range. For example:
M[^c]% searches for all names beginning with the letter M that do not have the letter c as the second letter (MacPherson)
To use the %, _, [], or [^] characters as literal characters rather than as wildcard characters, do the following:
Use square brackets around the percent sign, the underscore, and the open bracket (that is, [%], [_], and [[]).
For example:
5[%] searches for 5%
[_]n searches for _n
[[] searches for [
Use the close bracket by itself. For example:
] searches for ]
Use the dash as the first character inside a set of square brackets. For example:
[-acdf] searches for -,a,c,d, or f

-------------------
Thanks,
http://sccm07.blogspot.com/

Custom Error Codes for Configuration Manager 2007

Client Custom Error Codes

 

Error Code	Description
CCM_ERRORCODE(0x 80040200) NAMENOTFOUND2147746304	Name not found
CCM_ERRORCODE(0x 80040201) BADNAMEFORMAT2147746305	Incorrect name format
CCM_ERRORCODE(0x 80040202) SERVICESHUTDOWN2147746306	Service is shutting down
CCM_ERRORCODE(0x 80040203) DATAEMPTY2147746307	No data supplied
CCM_ERRORCODE(0x 80040204) DATATOOLARGE2147746308	Data too large
CCM_ERRORCODE(0x 80040205) INVALIDPATH2147746309	Invalid path
CCM_ERRORCODE(0x 80040206) INVALIDFILE2147746310	Invalid file
CCM_ERRORCODE(0x 80040207) PARSE2147746311	Parsing error
CCM_ERRORCODE(0x 80040208) INVALIDCOMMAND2147746312	Invalid command
CCM_ERRORCODE(0x 80040209) DATATYPEMISMATCH2147746313	Data type mismatch
CCM_ERRORCODE(0x 80040210) INVALIDTRANSLATOR2147746320	Invalid Translator
CCM_ERRORCODE(0x 80040211) INVALIDADDRESS2147746321	Invalid Address
CCM_ERRORCODE(0x 80040212) CONTEXTCLOSED2147746322	Context is closed
CCM_ERRORCODE(0x 80040213) TIMEOUT2147746323	Timeout occurred
CCM_ERRORCODE(0x 80040214) INVALIDNAMELEN2147746324	Invalid name length
CCM_ERRORCODE(0x 80040215) ITEMNOTFOUND2147746325	Item not found
CCM_ERRORCODE(0x 80040216) INVALIDSERVICEPARAM2147746326	Invalid service parameter. The WMI file could be corrupt or there was a manual change to a site control file.
CCM_ERRORCODE(0x 80040217) DATACORRUPT2147746327	Data is corrupt
CCM_ERRORCODE(0x 80040218) INVALIDSERVICESETTING2147746328	Invalid service settings
CCM_ERRORCODE(0x 80040219) GLOBALSERVICENOTSET2147746329	Global service not set
CCM_ERRORCODE(0x 80040220) INVALIDTYPE2147746336	Invalid type
CCM_ERRORCODE(0x 80040221) INVALIDUSER2147746337	Invalid user. An operation for a user that is not logged on is in process or the user account is invalid.
CCM_ERRORCODE(0x 80040222) CANCELLED2147746338	Operation cancelled
CCM_ERRORCODE(0x 80040223) VERSIONMISMATCH2147746339	Version mismatch
CCM_ERRORCODE(0x 80040224) INVALIDMESSAGE2147746340	Invalid message
CCM_ERRORCODE(0x 80040225) INVALIDADDRESSTYPE2147746341	Invalid address type
CCM_ERRORCODE(0x 80040226) INVALIDPROTOCOL2147746342	Invalid protocol
CCM_ERRORCODE(0x 80040227) DISABLED2147746343	Functionality disabled
CCM_ERRORCODE(0x 80040228) INVALIDENDPOINT2147746344	Invalid endpoint
CCM_ERRORCODE(0x 80040229) GETCREDENTIALS2147746345	Failed to get credentials
CCM_ERRORCODE(0x 80040230) LOGONUSER2147746352	Error logging on as given credentials
CCM_ERRORCODE(0x 80040231) TRANSIENT2147746353	Transient error that could indicate a network problem.
CCM_ERRORCODE(0x 80040232) MESSAGENOTSIGNED2147746354	Message not signed
CCM_E_MESSAGENOTTRUSTED(0X 0x80040233)2147746355	Message not trusted
CCM_ERRORCODE(0x 80040234) INTERNALENDPOINT2147746356	Internal endpoint cannot receive a remote message
CCM_ERRORCODE(0x 80040235) PARSE_SYNTAX2147746357	Syntax error occurred while parsing
CCM_ERRORCODE(0x 80040236) LOWMEMORY2147746358	Low memory.
CCM_ERRORCODE(0x 80040237) REPLYMODE_INCOMPATIBLE2147746359	Reply mode incompatible
CCM_ERRORCODE(0x 80040238) PUBLIC_KEY_NOT_FOUND2147746360	Public key not found
CCM_ERRORCODE(0x 80040239) CLIENT_ID_NOT_FOUND2147746361	Client ID not found
CCM_ERRORCODE(0x 80040240) INSUFFICIENTDISKSPACE2147746368	Insufficient disk space
CCM_ERRORCODE(0x 80040241) DATABASE_CONNECT_FAILED2147746369	Failed to connect to database
CCM_ERRORCODE(0x 80040242) STORED_PROCEDURE_FAILED2147746370	Stored procedure failed
CCM_ERRORCODE(0x 80040243) PUBLIC_KEY_MISMATCH2147746371	Public key mismatch
CCM_E_BAD_HTTP_STATUS_CODE (0x 8004027E) 2147746430	Client communication from the management point failed.
CCM_E_EMPTY_CERT_STORE (0x 80040280) 2147746432	A valid certificate was not found in the certificate store.
CCM_E_NO_CERT_MATCHING_CRITERIA (0x 80040281) 2147746433	No valid certificate could be found using the specified certificate selection.
CCM_E_TOO_MANY_CERTS (0x 080040282) 2147746434	More than one valid certificate was located
CCM_E_MISSING_PRIVATEKEY (0x 080040283) 2147746435	The selected certificate does not have a corresponding private key, which is required for successful communication.
CCM_E_MISSING_SUBJECT_NAME (0x 080040284) 2147746436	The selected certificate does not have a Subject Name defined.
CCM_E_UNKNOWN_SEARCH_CRITERIA (0x 080040285) 2147746436	The certificate selection criteria syntax is invalid.
CCM_E_INVALID_SMS_AUTHORITY (0x 080040286) 2147746437	The certificate does not successfully chain to a trusted root certification authority.
CCM_E_MISSING_SITE_SIGNING_CERT (0x 080040287) 2147746438	Cannot locate the required Configuration Manager site server signing certificate for this site.
HandleRemoteSyncSend failed (0x80040309).2147746569	The 'trust failed'. This happens when the client doesn't trust data from the management point.
CForwarder_Sync::Send failed (0x80040309).2147746569	The 'trust failed'. This happens when the client doesn't trust data from the management point.
CForwarder_Base::Send failed (0x80040309).2147746569	The 'trust failed' This happens when the client doesn't trust data from the management point.
CCM_E_LOCATION_MPREFRESHCCM_ERRORCODE(0x80040300)2147746560	Client trying to refresh management point and it is empty.
CCM_E_LOCATION_NOADCCM_ERRORCODE(0x80040301)2147746561	Client is configured to only read Active Directory Domain Services and couldn't find the requested location (site assignment, management point) data.
CCM_E_LOCATION_NOTASSIGNEDCCM_ERRORCODE(0x80040302)2147746562	Client is trying to do something that requires being assigned to a site and it is not assigned. Only called from NAP when trying to refresh the management point.
CCM_E_LOCATION_INTERNALERRORCCM_ERRORCODE(0x80040303)2147746563	Internal error
CCM_E_LOCATION_BADSERVERCERTCCM_ERRORCODE(0x80040304)2147746564	Management point certification is corrupt from client's perspective, which could be due to network corruption or an attacker.
CCM_E_LOCATION_BADCLIENTCERTCCM_ERRORCODE(0x80040305)2147746565	Client certification is corrupt from site system's perspective, which could be due to network corruption or an attacker.
CCM_E_LOCATION_MPUNREACHABLECCM_ERRORCODE(0x80040306)2147746566	Client failed to connect to management point to make a location services request (MPLIST or MPKEYINFORMATION).
CCM_E_LOCATION_PROXYMPREFRESHCCM_ERRORCODE(0x80040307)2147746567	Client is trying to refresh proxy management point and it's empty. May only be called from NAP when trying to refresh the proxy management point.
CCM_E_LOCATION_LOCALMPREFRESHCCM_ERRORCODE(0x80040308)2147746568	Client is trying to refresh local management point and it's empty. Only called from NAP when trying to refresh proxy management point.
CCM_E_LOCATION_MESSAGEFAILEDCCM_ERRORCODE(0x80040309)2147746569	In most cases this indicates that the in band server authorization failed on a client, usually because the trusted root key does not match the management point certificate.

Desired Configuration Management Custom Error Codes

 

Error Code	Description
0x80040752 E_DCM_DOTNETMISSING	Microsoft .NET Framework 2.0 or later not installed
0x80040756 E_DCM_SDM_REPORTING_FAILED 2147747670	Client failed to report state or status.
0x80040763 E_DCM_CI_INTERNAL_FAILURE 2147747683	WMI corruption or heap corruption
0x80040764 E_DCM_SDM_INTERNAL_FAILURE	WMI corruption, memory corruption, disk corruption
0x80040765 E_DCM_SDM_CLRHOST_LAUNCH_FAILURE	Problem with client installation or.NET Framework 2.0 installation

Inventory Custom Error Codes

 

Error Code	Description
0x80040900	A valid WMI instance inventoried could not be added to the report. The __Path property may be undefined.

Mobile Device Management Custom Error Codes

 

Error Code	Description
-2147220846FFFFFFFF80040292	Unable to compute message signature for in-band authentication.
-2147220843FFFFFFFF80040295	Unable to find a valid client authentication certificate for registration.
11520	Mobile device client deployment action failed. Failed to establish ActiveSync or Mobile Device Center connection to the mobile device.
11521	Mobile device client deployment action failed. Invalid client settings file.
11522	Mobile device client deployment action failed. Error determining running directory for DmClientXfer.exe
11523	Mobile device client deployment action failed. Required ActiveSync libraries missing.
11524	Mobile device client deployment action failed. Could not determine processor type of attached mobile device.
11525	Mobile device client deployment action failed. Could not determine base operating system version of attached mobile device.
11526	Mobile device client deployment action failed. Error determining client version for the attached mobile device.
11527	Mobile device client deployment action failed. Error creating client settings .ini file.
11528	Mobile device client deployment action failed. Failed to copy files to the attached mobile device.
11529	Mobile device client deployment action failed. Failed executing the mobile device client installer program on attached mobile device.
11530	Mobile device client deployment action may have failed. Failed reading status information from the mobile device.
11540	Mobile device client deployment action failed. Error determining running directory for the mobile device client installer program.
11541	Mobile device client deployment action failed. Error executing the pre-install command line.
11542	Mobile device client deployment action failed. Error executing the post-install command line.
11550	Mobile device client installation or upgrade failed. Error during removal of the previous client.
11551	Mobile device client installation or upgrade failed. Invalid client settings file.
11552	Mobile device client installation or upgrade failed. Error installing client CAB file.
11553	Mobile device client installation or upgrade failed. Error starting client service.
11554	Mobile device client installation or upgrade failed. Error updating client settings.
11555	Device Client Deployment failed with unknown error.
11560	Mobile device client verification or repair failed. Error during removal of previous client.
11561	Mobile device client verification or repair failed. Invalid client settings file.
11562	Mobile device client verification or repair failed. Error installing client CAB file.
11563	Mobile device client verification or repair failed. Error starting client service.
11564	Mobile device client verification or repair failed. Error updating client settings.
11565	Mobile device client verification or repair failed. Error restoring required files.
11566	Mobile device client privileged certificate installation failed.
11567	Encountered unknown error installing the device client.
11568	Mobile device client setup failed to launch during install.
11570	Mobile device client removal failed. Error using unload.exe to uninstall the existing client.
11571	Mobile device client install/upgrade failed. Error enforcing new client. Mobile device rolled back to old client (if existed before).
11572	Mobile device client rollback failed during unsuccessful upgrade. Error enforcing old client.
11573	Mobile device client failed to perform post cab install actions. Device client installation failed.

Operating System Deployment Custom Error Codes

 

Error Code	Description
0x80040001	Could not get the client GUID
0x80040101	Network access account is not set
0x80040102	No content location returned for the given package
0x80040103	Could not access package content in the DP
0x80040104	Could not find reference program policy
0x80040105	Could not find CCM_ClientAgentConfig raw policy
MAKE_HRESULT(SEVERITY_ERROR,FACILITY_ITF,1)	An invalid image capture path has been specified.
MAKE_HRESULT(SEVERITY_ERROR,FACILITY_ITF,2)	An invalid image file name extension has been specified.
MAKE_HRESULT(SEVERITY_ERROR,FACILITY_ITF,3)	An invalid image file name extension has been specified.
MAKE_HRESULT(SEVERITY_ERROR,FACILITY_ITF,4)	Image capture path is too long
MAKE_HRESULT(SEVERITY_ERROR,FACILITY_ITF,5)	An invalid image file name extension has been specified.
MAKE_HRESULT(SEVERITY_ERROR,FACILITY_ITF,1)	Timeout waiting for PNP to finish initialization.
MAKE_HRESULT(SEVERITY_ERROR,FACILITY_ITF,2)	Task sequence failed in Windows PE
MAKE_HRESULT(SEVERITY_ERROR,FACILITY_ITF,1)	An invalid network adapter index has been specified
MAKE_HRESULT(SEVERITY_ERROR,FACILITY_ITF,1)	Sysprep is not installed
MAKE_HRESULT(SEVERITY_ERROR,FACILITY_ITF,2)	Sysprep is invalid
MAKE_HRESULT(SEVERITY_ERROR,FACILITY_ITF,3)	Invalid System Partition
MAKE_HRESULT(SEVERITY_ERROR,FACILITY_ITF,4)	Machine is joined to a domain
MAKE_HRESULT(SEVERITY_ERROR,FACILITY_ITF,5)	Machine is domain controller
MAKE_HRESULT(SEVERITY_ERROR,FACILITY_ITF,1)	A default management point has not been assigned for this site.
MAKE_HRESULT(SEVERITY_ERROR,FACILITY_ITF,2)	Certificates for the default management point are not available.
MAKE_HRESULT(SEVERITY_ERROR,FACILITY_ITF,3)	Package {0} is not available on the specified distribution points.
MAKE_HRESULT(SEVERITY_ERROR,FACILITY_ITF,4)	Invalid password for media certificate
MAKE_HRESULT(SEVERITY_ERROR,FACILITY_ITF,5)	The media certificate does not have an associated private key
MAKE_HRESULT(SEVERITY_ERROR,FACILITY_ITF,6)	The certification authority's certificate has not been set for this site.

Remote Tools Custom Error Codes

 

Error Code	Description
MAKE_HRESULT(SEVERITY_ERROR,FACILITY_ITF,1)	Another remote control session is already in progress. Remote Control does not support multiple concurrent remote control sessions.
MAKE_HRESULT(SEVERITY_ERROR,FACILITY_ITF,2)	Level of access allowed is set to "No Access" in the Remote Tools client agent General tab on the site server or in the Remote Control control panel applet.
MAKE_HRESULT(SEVERITY_ERROR,FACILITY_ITF,3)	Remote Control Agent was not properly installed on the client.
MAKE_HRESULT(SEVERITY_ERROR,FACILITY_ITF,4)	No interactive session found on the client.
MAKE_HRESULT(SEVERITY_ERROR,FACILITY_ITF,5)	Remote computer screen is locked.
MAKE_HRESULT(SEVERITY_ERROR,FACILITY_ITF,6)	Failed to create the RDP session.
MAKE_HRESULT(SEVERITY_ERROR,FACILITY_ITF,8)	Remote Tools is disabled.
MAKE_HRESULT(SEVERITY_ERROR,FACILITY_ITF,9)	Failed to launch the Remote Control Agent process.

Software Distribution Custom Error Codes

 

Error Code	Description
E_FAIL_EXECUTION_PENDING 0x80008001	The program cannot be run now from the client UI because : A restart is in progress. or Software Distribution is paused because of a task sequence running or Another program is currently running NOTE: This error code is only returned to the UI and is not present in status messages.
E_FAIL_DUPLICATE_REQUEST 0x80008002	The program cannot be run again from the client UI because it is already pending, an optional (initiated from the UI) run request already exists for it. NOTE: This error code is only returned to the UI and is not present in status messages.
E_SWDIST_POLICY_NOT_FOUND 0x80002004	The software distribution policy was not found.
E_FAIL_PROGRAM_DISABLED 0x80008004	The program cannot run because it is currently disabled.
E_FAIL_INVALID_POLICY 0x80008005	This error code can be returned on the client if policy cannot be found or the policy is not valid to run or cancel the requested program. NOTE: This error code is currently not sent in status messages.
E_FAIL_INVALID_PROGRAM 0x80008006	The requested program is not currently pending. This error code can be returned on the client if the user attempts to continue or cancel the program that is not currently pending. It can also be returned to the task sequence manager (TSM) when TSM requests download locations for packages that are not referenced by the currently running task sequence. NOTE: This error code is not raised in status messages by Software distribution, but could be raised by task sequence.
E_FAIL_SET_CACHEDCONTENTINUSE 0x80008008	Unable to set the CachedContentInUse flag. Failed to indicate the client cache is currently in use.
E_FAIL_WMI_ERROR 0x80008009	Failed to read data from WMI. The program could not continue because a system restart is in progress or there is already a run request for this program that requires a reboot.
E_FAIL_REQUEST_NOT_FOUND 0x80008011	Used for Task Sequence. Failed to reconnect to Task Sequence job because a request cannot be found with the given job ID. NOTE: Not sent in status message by Software Distribution, but may be used by task sequence.
E_FAIL_ACTIVE_REQUEST_NOT_FOUND 0x80008012	There is no program currently running. This error code is returned to task sequence when there is no run request that is currently running, but task sequence tries to get the currently running request.
E_FAIL_DEPENDENCY_NOT_RUN 0x80008013	This program cannot run because it depends on another program that has not run successfully before. This error code is returned to task sequence manager when a task sequence Install Software Action step cannot be run because the step has a child program which has not been run before.
E_FAIL_USER_REQUIRED 0x80008014	This error code is returned to task sequence manager when an "Install Software" step cannot be run because the software distribution program in this step is targeted to a user, requires user input or is set to run in user context
E_FAIL_SWD_NOT_PAUSED 0x80008015	Failed to notify caller that software distribution is paused because the paused state or paused cookie do not match.
E_FAIL_INVALID_HASH 0x80008017	The content hash string or hash versions are empty or incorrect in the software distribution policy or the hash verification failed.
E_FAIL_CANNOT_RUN_ON_INTERNET 0x80008018	The program cannot run at this time because the client is on the internet.
E_FAIL_EXECUTION_NONFATAL 0x80008100	A non fatal error has been encountered while attempting to run the program. The program execution will be retried if the retry count has not been exceeded.
E_FAIL_BAD_ENVIRONMENT_NONFATAL 0x80008103	A non fatal error occurred while preparing to run the program, for example when creating the program execution environment, making a network connection, impersonating the user, determining the file association information, or when attempting to launch the program. This program execution will be retried if the retry count has not been exceeded.
E_FAIL_PROGRAM_NOT_MONITORED 0x80008105	An error was encountered while getting the process information for the launched program and the program execution will not be monitored.
E_FAIL_BAD_ENVIRONMENT_FATAL 0x8000910A	A fatal error occurred while preparing to run the program, for example when creating the program execution environment, making a network connection, impersonating the user, determining the file association information, or when attempting to launch the program. This program execution will not be retried.
E_FAIL_EXECUTION_FATAL 0x80009101	A fatal error has been encountered while attempting to run the program. The program execution will not be retried.
E_FAIL_INVALID_PROGRAM_OBJECT 0x80009102	An error occurred while creating the execution context. This is error code indicates that an error was encountered while creating the internal execution context object. This is most likely not due to configuration errors, but could be because of low memory conditions, COM failures or other external errors.
E_FAIL_INVALID_CMDLINE 0x80009104	The command line for this program is invalid.
E_FAIL_NO_CONTENT 0x80009106	Failed to verify the executable file is valid or to construct the associated command line.
E_FAIL_NO_SOURCE 0x80008107	Failed to access all the provided program locations. This program may retry if the maximum retry count has not been reached.
E_INVALID_CONTENT_REQUEST_HANDLE 0x80008200	This is an internal error. No content request found with the given handle.
E_NO_SPACE_IN_CACHE 0x80008201	The content download cannot be performed because there is not enough available space in cache or the disk is full.
E_CACHE_TOO_SMALL 0x80008202	The content download cannot be performed because the total size of the client cache is smaller than the size of the requested content.
E_CACHE_IN_USE 0x80008203	The client cache is currently in use by a running program or by a download in progress.
E_NO_DP_FOUND 0x80008204	NOTE: this error code is sent at least in status message 10051. No distribution points were found for the requested content.
E_FAIL_LOCATION_REQUEST 0x80008210	Failed to get content locations.
E_FAIL_JOB_PENDING 0x80008250	The computer restart cannot be initiated because a software installation job is in progress.
E_FAIL_INACCESSIBLE_SOURCE 0x80009108	Failed to access all the provided program locations. This program will not retry.
E_FAIL_INVALID_MSI 0x80009109	Failed to verify that the given file is a valid installation package.

Software Updates Custom Error Codes

 

Error Code	Description
E_UPDDEPLOY_APPLY_NOT_REQUIREDCCM_ERRORCODE(0x80040708)2147747592	Software Updates Install not required.
E_MONITOR_RESUME_FAILURECCM_ERRORCODE(0x80040709)2147747593	Failed to resume the monitoring of the process.
E_INVALID_CMDLINECCM_ERRORCODE(0x8004070A)2147747594	Invalid command line
E_CREATEPROCESS_FAILURECCM_ERRORCODE(0x8004070B)2147747595	Failed to create process
E_EXECUTION_TIMEOUTCCM_ERRORCODE(0x8004070C)2147747596	Software update execution timeout
E_UPDATE_FAILED_RESULTCCM_ERRORCODE(0x8004070D)2147747597	Software update failed when attempted
E_EMPTY_COMMANDLINECCM_ERRORCODE(0x8004070E)2147747598	Empty command line specified
E_INVALID_INSTALLER_PATHCCM_ERRORCODE(0x8004070F)2147747599	Invalid updates installer path
E_COMPARE_CREATION_TIMESCCM_ERRORCODE(0x80040710)2147747600	Failed to compare process creation time.
E_DEPLOYMENT_NOT_ACTIVECCM_ERRORCODE(0x80040711)2147747601	Software updates deployment not active yet for example, start time is in future
E_UPDDEPLOY_REBOOT_REQUIREDCCM_ERRORCODE(0x80040712)2147747602	A system restart is required to complete the installation.
E_NO_DETECT_RESULTCCM_ERRORCODE(0x80040713)2147747603	Software updates detection results not received yet.
E_UPDATES_USERINSTALL_RESTART_PENDING CCM_ERRORCODE(0x80040714)2147747604	User based install not allowed as system restart is pending.
E_USERINSTALL_NO_UPDATESCCM_ERRORCODE(0x80040715)2147747605	No applicable updates specified in user install request.
E_NOINTERFACE FFFFFFFF80004002-2147467262	No such interface supported
[DCOM belly up] CAgent::CreateJob failed FFFFFFFF8007000E-2147024882	Not enough storage is available to complete this operation.
ERROR_TIMEOUT FFFFFFFF800705B4-2147023436	This operation returned because the timeout period expired.
[Scan fails on x64vista] OnSearchComplete0x80240032[WU]-2145124302	Failed to end search job [SMS] WU client failed Searching for update with error.
WU_E_PT_WINHTTP_NAME_NOT_RESOLVED Same as -ERROR_WINHTTP_NAME_NOT_RESOLVED FFFFFFFF8024402C-2145107924	The proxy server or target server name cannot be resolved.
FFFFFFFF80040692-2147219822	Group Policy conflict
FFFFFFFF80040693-2147219821	Low WUA version
WU_E_PT_HTTP_STATUS_BAD_GATEWAYFF80244021-2145107935	Same as HTTP status 502. The server, while acting as a gateway or proxy, received an invalid response from the upstream server it accessed in attempting to fulfill the request.
-939523070ERROR_OBJECT_ALREADY_EXISTS FFFFFFFFC8000402	Object already exists
[SA fail if SWD not working] createInstance failed for UpdateServiceManager FFFFFFFF80040154-2147221164	Class not registered
FFFFFFFF800705B4-2147023436	This operation returned because the timeout period expired.
ERROR_INTERNET_TIMEOUT FFFFFFFF80072EE2-2147012894	Internet timeout
ERROR_WINHTTP_CANNOT_CONNECT or ERROR_INTERNET_CANNOT_CONNECT FFFFFFFF80072EFD-2147012867	Internet cannot connect
E_INVALIDSTATE_AFTER_APPLY FFFFFFFF80040668-2147219864	Software update still detected as actionable after apply.
E_EXECUTION_TIMEOUT FFFFFFFF8004070C-2147219700	Software update execution timeout
WU_E_PT_WINHTTP_NAME_NOT_RESOLVED - same as ERROR_WINHTTP_NAME_NOT_RESOLVEDFFFFFFFF8024402C-2145107924	The proxy server or target server name cannot be resolved.
ERROR_PATH_NOT_FOUND FFFFFFFF80070003-2147024893	The system cannot find the path specified.
ERROR_FILE_EXISTS FFFFFFFF80070050-2147024816	The file exists
ERROR_ACCESS_DENIED or E_ACCESS_DENIEDFFFFFFFF80070005-2147024891	Access denied
WU_E_PT_WINHTTP_NAME_NOT_RESOLVED Same as ERROR_WINHTTP_NAME_NOT_RESOLVED FFFFFFFF8024402C-2145107924	The proxy server or target server name cannot be resolved.
ERROR_INAVILD_ENVIROMENT FFFFFFFF8004070D-2147219699	Software update failed when attempted.
Install Errors
-Last Install Error FF8024402C WU_E_PT_WINHTTP_NAME_NOT_RESOLVED - same as ERROR_WINHTTP_NAME_NOT_RESOLVED2145107924	The proxy server or target server name cannot be resolved.
Last Install Error FF8007066F ERROR_PATCH_NOT_APPLIED -2147023249	Can sometimes happen when Windows Installer configuration for an installed application is out of sequence for example, Windows Installer thinks it has more patches applied than is really the case (this sometimes used to happen with roaming profiles).
Last Install ErrorFF8007064 ERROR_INSTALL_FAILURE-2147023293	Generic failure code from Windows Installer installs.
Last Install ErrorFF8007F0F4 STATUS_PREREQUISITE_FAILED-2146963212	Generated by update.exe. People seem to be getting this when they try to install a Service Pack while on battery power.
Last Install ErrorFF8007F0F5 WU_E_DM_INCORRECTFILEHASH-2146963211	The WU Agent's metadata store and the policy received by ccmexec could be out of sync.
Last Install Error FF8007F0F6 ERROR INVALID PARAMETER-2146963212	Failed to start the installation of updates because update is not found
Scan Failures
Last Scan ErrorFF80244021WU_E_PT_HTTP_STATUS_BAD_GATEWAY-2145107935	Possible network connectivity issues
Last Scan ErrorFF8024001DWU_E_INVALID_UPDATE-2145124323	An update contains invalid metadata.
Last Scan ErrorFF80004002E_NOINTERFACE-2147467262	No such interface supported
Last Scan ErrorFFC8000402RECORD TOO BIG-939523070	This seems to be a recoverable error, and possibly due to many Scan Service Packages left around when the 2003 ITMU was used. This is NOT the case.
FF8024400A WU_E_PT_SOAPCLIENT_PARSE1097366519818	Needs update
Last Scan ErrorWU_E_SERVICE_STOPFF8024001E-2145124322	Operation did not complete because the service or system was being shut down.
Last Scan ErrorFF8024400DWU_E_PT_SOAP_CLIENT-2145107955	SOAP client found the message was malformed.
Last Scan ErrorFFC800042DRefreshServerUpdateInfo-939523027	WSUS unable to update software distribution folder. Scans fail.
Last Scan ErrorFF80244022WU_E_PT_HTTP_STATUS_SERVICE_UNAVAIL-2145107934	HTTP status 503. The service is temporarily overloaded.
Last Scan ErrorFF80240032WU_E_INVALID_CRITERIA-2145124302	The search criteria string was invalid.
Last Scan ErrorFF80240013WU_E_DUPLICATE_ITEM-2145124333	Failed to add file to the FileLocationList.
Last Scan ErrorFF8007041DERROR SERVICE REQUEST TIMEOUT-2147023843	The service did not respond to the start or control request in a timely fashion.
E_FAIL_POLICY_NOT_FOUNDCCM_ERRORCODE(0x80040600)2147747328	Scan Tool Policy not found
E_LOCATION_TIMEOUTCCM_ERRORCODE(0x80040602)2147747330	Out of cache space
E_SCANTOOL_POLICY_REMOVEDCCM_ERRORCODE(0x80040603)2147747331	The ScanTool Policy has been removed so cannot complete Scan Operation.
E_SCANTOOL_NOTFOUND_INJOBQUEUECCM_ERRORCODE(0x80040604)2147747332	The ScanTool was not found in the job queue.
E_FAIL_SCAN_TOOL_REMOVEDCCM_ERRORCODE(0x80040605)2147747333	Scan Tool has been Removed
E_FAIL_OFFLINE_SCAN_HISTORY_NOT_FOUNDCCM_ERRORCODE(0x80040606)2147747334	Scan Tool Policy not found
E_CONTENT_NOT_FOUNDCCM_ERRORCODE(0x80040607)2147747335	Out of cache space
E_INVALID_INSTANCE_TYPECCM_ERRORCODE(0x80040608)2147747336	Out of cache space
E_NO_SPACE_IN_CACHE0x800082012147516929	Out of cache space
E_CACHE_TOO_SMALL0x800082022147516930	Cache size is smaller than requested content's size.
Deployments Agent Specific Errors
E_UPDDEPLOY_APPLY_NOT_ALLOWED CCM_ERRORCODE(0x80040700)2147747584	Install not allowed
E_UPDDEPLOY_DOWNLOAD_NOT_ALLOWED CCM_ERRORCODE(0x80040701)2147747585	Download not allowed
E_ASSIGNMENT_POLICY_NOT_FOUNDCCM_ERRORCODE(0x80040702)2147747586	Assignment policy not available
E_ANOTHER_JOB_IN_PROGRESSCCM_ERRORCODE(0x80040703)2147747587	Only one job is allowed at a time
E_HARDREBOOT_PENDINGCCM_ERRORCODE(0x80040704)2147747588	Only one job is allowed at a time.
2147747589E_PAUSE_STATE_REQUIREDCCM_ERRORCODE(0x80040705)	Pause state required
2147747590E_NO_ACTIVE_JOBCCM_ERRORCODE(0x80040706)	No active job exists (while reconnect called).
2147747591E_JOB_ID_MISMATCHCCM_ERRORCODE(0x80040707)

-------------------
Thanks,
http://sccm07.blogspot.com/

Collection: List of all Virtual machines and their Physical host System Name

List of all Virtual machines and their Physical host System Name

 

 

This report lists all the virtual machines and also adds the PhysicalHostName0 property. This tells you the name of the host server the virtual system is sitting on.

Here is the report syntax:

SELECT distinct SYS.Netbios_Name0, Gvm.PhysicalHostName0, SYS.User_Name0,
SYS.Resource_Domain_OR_Workgr0,OPSYS.Caption0 as C054, OPSYS.Version0, ENCL.Manufacturer0,
CSYS.Model0, Processor.MaxClockSpeed0, MEM.TotalPhysicalMemory0, WSTATUS.LastHWScan
FROM v_R_System SYS
LEFT JOIN v_GS_VIRTUAL_MACHINE  gvm ON SYS.ResourceID=gvm.ResourceID
LEFT JOIN v_RA_System_IPAddresses IPAddr on SYS.ResourceID = IPAddr.ResourceID
LEFT JOIN v_GS_X86_PC_MEMORY MEM on SYS.ResourceID = MEM.ResourceID
LEFT JOIN v_GS_COMPUTER_SYSTEM CSYS on SYS.ResourceID = CSYS.ResourceID
LEFT JOIN v_GS_PROCESSOR Processor on Processor.ResourceID = SYS.ResourceID
LEFT JOIN v_GS_OPERATING_SYSTEM OPSYS on SYS.ResourceID=OPSYS.ResourceID
LEFT JOIN v_GS_PC_BIOS BIOS on SYS.ResourceID=BIOS.ResourceID
LEFT JOIN v_GS_SYSTEM_ENCLOSURE ENCL on SYS.ResourceID=ENCL.ResourceID
LEFT JOIN v_GS_WORKSTATION_STATUS wSTATUS on SYS.ResourceID=WSTATUS.ResourceID
LEFT JOIN v_R_User USERS on SYS.User_Name0 = USERS.User_Name0
WHERE OPSYS.Caption0 is not null and CSYS.Model0 = 'Virtual Machine'
ORDER BY SYS.Netbios_Name0, SYS.Resource_Domain_OR_Workgr0

 

Enjoy,
-------------------
Thanks,
http://sccm07.blogspot.com/

Feature Comparison of MSDE and SQL Server 2005 Express

Feature Comparison of MSDE and SQL Server 2005 Express

While the core database capabilities of MSDE and SQL Server 2005 Express are similar, the set of features and database capabilities of MSDE and SQL Server 2005 Express are different. The following table provides a feature comparison between MSDE and SQL Server 2005 Express.

Feature	MSDE	SQL Server 2005 Express Edition
Maximum number of instances	16	16
Maximum # of processors	2	1
Maximum RAM	2 GB	1 GB
Maximum database size	2 GB	4 GB
Workload governor	Yes	No
Graphical management tool	No	Yes
User instances	No	Yes
SQL Agent	Yes	No
DTS runtime	Yes	Yes (Web download)
Replication	Merge only	Merge subscription Snapshot subscription Transactional subscription
BI features (Analysis Services, Integration Services)	No	No
Report Server	No	Yes (Installed with SQL Server 2005 Express with Advanced Services)
Service Broker	No	Client only
Full-text search	No	Yes (Installed with SQL Server 2005 Express with Advanced Services)
Windows 9x support	Yes	No
MDAC Required	Yes	No
Business Intelligence Development Studio (BIDS)	No	Yes (Installed with SQL Server 2005 Express Toolkit)

-------------------
Thanks,
http://sccm07.blogspot.com/

Systems part of what collections?

SELECT v_R_System.Name0, v_Collection.Name FROM v_FullCollectionMembership INNER JOIN v_R_System ON v_FullCollectionMembership.ResourceID = v_R_System.ResourceID INNER JOIN v_Collection ON v_FullCollectionMembership.CollectionID = v_Collection.CollectionID WHERE (v_R_System.Name0 = 'Systemname')

for Webbased reports:--

Here is the main section:
SELECT v_FullCollectionMembership.Name as 'Computer Name', v_Collection.Name as 'Collection Name'
FROM v_Collection v_Collection, v_FullCollectionMembership v_FullCollectionMembership
WHERE v_FullCollectionMembership.CollectionID = v_Collection.CollectionID AND (v_FullCollectionMembership.Name=@prompt)

Here is the "prompt" section:
begin
 if (@__filterwildcard = '')
  SELECT DISTINCT v_FullCollectionMembership.Name from v_FullCollectionMembership
Order by v_FullCollectionMembership.Name
 else
  SELECT DISTINCT v_FullCollectionMembership.Name from v_FullCollectionMembership
  WHERE v_FullCollectionMembership.Name like @__filterwildcard
  Order by v_FullCollectionMembership.Name
end

-------------------
Thanks,
http://sccm07.blogspot.com/

SCCM 2007 with SQL Server 2005 Reporting Services

 

SCCM 2007 with SQL Server 2005 Reporting Services

 

Listen to Adam's podcast on these rules with Greg Low

Duration: 50 minutes 39 seconds
Size: 14.5MB

Watch Adam's video on DNRTV on these rules:

Part A (53:13) - 181MB
Part B (49:12) - 171MB
Part C (42:19) - 158MB

 

Complete covarage can be found in the http://www.ssw.com.au/Ssw/Standards/Rules/RulesToBetterSQLReportingServices.aspx 

-------------------
Thanks,
http://sccm07.blogspot.com/

All the Third-Party Solutions for SCCM & SMS

Web Sites:

MyITForum is the premier online destination for IT professionals responsible for managing their corporations' Microsoft Windows systems; it is especially useful for IT professionals working with Microsoft Systems Management Server. (http://www.myitforum.com)

FAQshop endeavors to provide a "one-stop-shop" for systems management questions, answers, and utilities. (http://www.faqshop.com)

SMS Alliance is a consortium of companies that leverage joint resources to strengthen the capabilities and benefits of SMS. Their mission is to provide organizations with the best-of-breed solutions and services to enhance and extend SMS 2003. (http://www.sms-alliance.com)

1E is one of the founding members of the SMS Alliance, 1E is a company on the cutting edge of systems management. It enhances and extends Microsoft management and deployment technologies, delivering advanced automation and reporting across the enterprise. (www.1e.com)

Macrovision Corporation, another founding member of the SMS Alliance, Macrovision Corporation is a recognized leader in software deployment packaging, software installation, and software updating solutions. They offer one of the best software packaging tools with AdminStudio.
(http://www.macrovision.com/)

PS'SOFT, as a founding member of the SMS Alliance, offers extenders for SMS 2003 that focus on IT asset management. They offer a web-based software cataloging system called SMS Software Requests. (www.pssoft.com)

Vintela, another founding member of the SMS Alliance, Vintela offers a seamless solution to extend security and compliance of Microsoft Active Directory to Unix, Linux, and other platforms and applications. They offer solutions that help IT administrators manage Unix, Linux, and MAC systems using SMS 2003. Vintela is now part of Quest Software. (www.vintela.com)

iAnywhere, the last founding member of the SMS Alliance, iAnywhere offers frontline security and management to SMS and provides extensions to manage your enterprise's mobile and wireless devices through SMS. (www.iAnywhere.com)

AppDeploy is the Internet resource to go to when you need to script or repackage an application for distribution. Among other points of interest at the site is a massive library of applications, sorted by application name and vendor name. For each application listed, you'll find a community-based thread discussing the best practices, links, scripts, and challenges met/overcome with working with the application in regard to installation scripting/repackaging.(http://www.appdeploy.com/)

DesktopEngineer is perhaps one of the best resources in the Windows Installer arena. This site offers a wealth of information on Windows Installer technology, techniques, and troubleshooting tips. I have noticed that he is starting to increase the content related to Microsoft's upcoming PowerShell scripting language. (http://www.desktopengineer.com/)

Tools

SMSView is a utility that is used to extend the functionality of the Microsoft Systems Management Server 2003 advanced client. SMSView allows you to perform the following actions on an SMS advanced client: All nonadmin users to view current mandatory assignments and advertisement status, View advertisement history (past 60 days), View current mandatory assignments, Rerun advertisements, Remote operations (remotely view and manage the SMS client), Display hardware/software inventory status, Display management point/proxy management point, Repair the SMS advanced client. (http://www.smsview.com/)

SMS 2003 Monster MOF is a MOF file that contains several new classes of MOF that will improve SMShardware inventory capabilities. The Monster MOF will enhance inventory data without requiring intimate knowledge of the SMS_DEF.MOF file. (www.smsexpert.com)

SMS 2003 Web Remote Tools assist SMS administrators and allow client administration from a web page. (http://www.myitforum.com/articles/19/view.asp?id=8662)

Corey Becht's Right-Click Tools is one of the best set of tools for all SMS administrators. This tool allows you to right click on any collection or individual PC within the SMS Administrator console and initiate hardware inventory, reassign the site code, restart the SMS Agent Host service, rerun advertisements without modifying the advertisement, perform discovery, initiate software inventory, create file collections, monitor software metering usage, refresh machine policies, evaluate policies, update Windows installer sources,change port number, and change cache size.These tools can run per computer resource or for all the members of a collection.(www.myitforum.com/articles/8/view.asp?id=7099)

Microsoft SMS Toolkit 2: Microsoft released a very nice set of tools for SMS called the SMS Toolkit version 2 . It contains the following tools: IIS Lockdown 2.1 Template, URLScan 2.5 Template, Policy Spy, SMS Trace, Advanced Client and Management Point Cleaner, Advanced Client Spy, Policy Verifier, Send Schedule, Management Point Spy, Set Preferred Distribution Point and CAP, Delete Certificate, Patch Management Evaluation, Delete Group Class, Transfer SMS ID, Package Loader, Management Point Troubleshooter, Client Site Assignment Verifier, Site Boundary Tool, Create Secondary Site Tool, Create SMS Address Tool.(www.microsoft.com/smserver/downloads/2003/tools/toolkit.mspx)

Security Logon Audit Tool (SLAT) extends SMS hardware inventory to include user logon information.This data can be used in web reports and queries. The tool includes the following samplereports: Top users for all systems, User logon information for a specific computer, Systems where the last logged-on user is not the top user, Systems where a specific user has logged on SLAT searches the security event log for the 528 event, which is created when user logon events occur and is enabled via Group Policy. (http://www.systemcentertools)

Enhanced System and User Discovery Tools, out of the box, SMS 2003 does a pretty good job of discovering systems from Active Directory. It's not perfect, though—there are a few gaps in its methods. The Enhanced System Discovery tool, assists in filling these gaps. Out of the box, SMS 2003 does not perform Windows NT 4 domain discovery. This tool solves that by enumerating all machines from a list of NT 4 domains, resolving their IP addresses from DNS or WINS, and creating data discovery records for each system. (http://www.systemcentertools/)

BITS Bandwidth Manager is an SMS Installer script that lets you throttle BITS bandwidthon Windows XP SP2 systems. You do not need to manually adjust any settings. The script takes care of the Registry key manipulation for you.(http://www.myitforum.com/inc/upload/11332BITSManager.zip)

1E SMSWakeUp: this WOL product is able to turn on computers after they have been shut down by users. The wake cycle can be triggered on a regular schedule to power up systems in preparation for the workday, or to perform software deployment activities. (http://www.1e.com/)

1E NightWatchman: Since we are talking about waking systems that have been shut down, it maybe a good practice to examine how best to shut down those systems in the first place. Why dowe want to shut down systems? We do this to enforce reboot cycles and to save energy costs. (http://www.1e.com/)

1E SMSNomad Branch: Some offices may not have the server hardware to allow for a Distribution Point (DP). But those offices may have a substantial number of users and/or be separated from the rest of the network by a low-speed or saturated WAN link, which you would rather not send multiple copies of a package across. SMSNomad Branch acts similar to a peer-to-peer network, allowing other computers to become DPs. If one machine is shutdown, another is selected as the DP. Included in this technology is multicast, increasing its efficiency to reduce network traffic on the local network segment. (http://www.1e.com/)

1E OSD Plus Pack: This is an enhancement to the SMS OSD Feature Pack. It allows you to leverage the SMS OSD Feature Pack in offices that do not have DPs. OSD Plus Pack offers similar functionality to SMSNomad Branch, but also has a few other applications bundledwith it: State Migration Editor, which is an interface for the User State Migration Tool, AppMigrator, which allows the automatic reinstallation of applications after OS imaging, PXE Lite, which is a local PXE server to allow deployment of OS images to bare-metalmachines booted from the network PXE server. (http://www.1e.com/)

SMS Companion 2006: This product provides WOL capabilities, similar to 1E's SMSWakeUp, but leverages slightly different technologies behind the scenes. A key difference is that SMS Companion puts systems in hibernation, rather than powering them off. The following are some of the key applications included with this product:Wake-on-Schedule: Allows clients to come out of a hibernation state. Service Windows: Allows you to restrict the SMS inventory and software distributions from happening during specific time periods, to reduce or eliminate user interruptions. Load Balancing: Allows you to reduce peak network and SMS server loading by making sure that the clients use these resources in a controlled manner. (http://www.smsexpert.com/)

Quest Management Xtensions for SMS: Since Windows platforms are not the only systems in an enterprise, you may need a way tomanage other platforms, such as Unix, Linux, and Mac OS X. These management extensions offer that capability for SMS 2003. One of the unique aspects of this product is its support route: first-level support is handled by Microsoft Product Support Services. (http://www.quest.com/quest-management-xtensions-for-sms)

-------------------
Thanks,
http://sccm07.blogspot.com/