How to Create Collections for the Upgrade Assessment Tool

 

Updated: March 24, 2016

Applies To: System Center 2012 Configuration Manager SP2, System Center 2012 R2 Configuration Manager SP1, System Center Configuration Manager (current branch)

This topic provides instructions to create collections for the System Center Configuration Manager Upgrade Assessment Tool that are based on upgrade assessment query rules.

To create collections that are based on upgrade assessment query rules

1. In the Configuration Manager console, click Assets and Compliance.

2. In the Assets and Compliance workspace, click Device Collections, and then on the Home tab, click Create and then click Create Device Collection.

3. In the Membership Rules page of the Create Device Collection Wizard, click Add Rule, and then select Query Rule.

4. In the Query Rule Properties dialog box, click Edit Query Statement.

5. In the Query Statement Properties dialog box, specify a query statement that is based on the Upgrade Assessment System attribute class and its attributes. For example, to assess an upgrade to a Windows 8 32-bit operating system deployment, the following query statement queries all devices that meet the minimum system requirement, have a device status of either Available Inbox or Available in Catalog, and have a my app rating of works:

   Select SMS_R_System.Name, SMS_R_System.SMSAssignedSites, SMS_R_System.IPAddresses, SMS_R_System.IPSubnets, SMS_R_System.OperatingSystemNameandVersion, SMS_R_System.ResourceDomainORWorkgroup, SMS_R_System.LastLogonUserDomain, SMS_R_System.LastLogonUserName, SMS_R_System.SMSUniqueIdentifier, SMS_R_System.ResourceId, SMS_R_System.ResourceType, SMS_R_System.NetbiosName, SMS_R_System.ClientType from  SMS_R_System inner join SMS_G_System_Upgrade_Assessment on SMS_G_System_Upgrade_Assessment.ResourceId = SMS_R_System.ResourceId where SMS_G_System_Upgrade_Assessment.DeviceStatus <= 2 and SMS_G_System_Upgrade_Assessment.OSName = "Windows 8 32-Bit" and SMS_G_System_Upgrade_Assessment.AppMyRating <= 1 and SMS_G_System_Upgrade_Assessment.SysReqRating >= 1.

6. Complete the wizard.

The following table shows the values and descriptions for the Upgrade Assessment Application Rating attribute:

App My Rating	Description	Status in Upgrade Assessment Summary reports
1	Works	Ready
2	Works with minor issues or has solution	Minor Issue
3	Does not work	Major Issue
4	No data	Unknown

The following table shows the values and descriptions for the CPU rating for the Upgrade Assessment Operating System Requirement rating:

CPU rating	Description
0	Does not meet minimum requirement
1	Meets minimum requirement
2	Meets recommended requirement

The following table shows the values and descriptions 64-bit capability for the Upgrade Assessment Operating System Requirement rating:

Is 64-Bit capable	Description
0	Not 64-Bit Capable (Cannot install Windows 64-Bit SKU)
1	64-Bit Capable

The following table shows the values and descriptions for the memory rating for the Upgrade Assessment Operating System Requirement rating:

Memory rating	Description
0	Does not meet minimum requirement
1	Meets minimum requirement
2	Meets recommended requirement

The following table shows the values and descriptions for the hard disk rating for the Upgrade Assessment Operating System Requirement rating:

Hard disk rating	Description
0	Does not meet minimum requirement
1	Meets minimum requirement
2	Meets recommended requirement

The following table shows the values and descriptions system requirement rating for the Upgrade Assessment Operating System Requirement rating:

System requirement rating	Description	Status in Upgrade Assessment Summary reports
0	CPU Rating does not meet minimum requirement Or not 64-Bit Capable for Windows 64-Bit SKU Or Memory Rating does not meet minimum requirement Or Hard disk Rating does not meet minimum requirement	Major
1	CPU Rating meets minimum requirement AND Memory Rating meets minimum requirement AND Hard disk Rating meets minimum requirement AND 64-Bit Capable for Windows 64-Bit SKU	Minor
2	CPU Rating meets recommended requirement AND Memory Rating meets recommended requirement AND Hard disk Rating meets recommended requirement AND 64-Bit Capable for Windows 64-Bit SKU	Ready

The following table shows the values and descriptions for the device status attribute:

Device Status	Description	Status in Upgrade Assessment Summary reports
1	Available inbox	Ready
2	Available in Catalog. If the driver for the device is not available with Windows, a compatible driver is found in the System Center Configuration Manager 2012 driver catalog.	Ready
3	Available with Dynamic Update	Minor Issue
4	Available on Windows Update	Minor Issue
5	Available from vendor	Minor Issue
6	Compatible with unknown driver	Minor Issue
7	Incompatible	Major Issue
8	Unknown	Unknown

See Also

Operations and Maintenance for the Upgrade Assessment Tool