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
-
In the Configuration Manager console, click Assets and Compliance.
-
In the Assets and Compliance workspace, click Device Collections, and then on the Home tab, click Create and then click Create Device Collection.
-
In the Membership Rules page of the Create Device Collection Wizard, click Add Rule, and then select Query Rule.
-
In the Query Rule Properties dialog box, click Edit Query Statement.
-
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.
-
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 |