KNOWN ISSUE: Right-click Action Create Installed Software Filter returns All Systems

Article:TECH41835  |  Created: 2009-04-13  |  Updated: 2009-11-04  |  Article URL http://www.symantec.com/docs/TECH41835
NOTE: If you are experiencing this particular known issue, we recommend that you Subscribe to receive email notification each time this article is updated. Subscribers will be the first to learn about any releases, status changes, workarounds or decisions made.
Article Type
Technical Solution


Issue



When right-clicking on a Software Component or Software Resource and choosing the option Create Installed Software Filter, the resulting filter returns all systems whether they have the software or not.

Environment



Software Management Framework 7.0 SP1
Software Management Solution 7.0

Cause



The SQL generated for the filter is not functioning as expected, resulting in all systems that have data in the Inv_InstalledSoftware table to be returned.

Solution



This issue was resolved in the 7.0 SP2 release of Software Management Framework. Upgrade to resolve this issue, or if you can't update follow the steps below to work around the issue: 

As a work-around, the SQL needs to be modified to fix the issue.  This will require a manual fix for each Filter created in this way.  Follow these steps after you've created the Filter:

  1. Browse to the new filter, usually found under Manage > Filters > Software Filters (you may want to make a clone before editing just in case...).
  2. Once loaded, Click the Edit button. in the upper right.
  3. Take the text in red from the Fixed example and copy it over to the SQL in your filter, replacing the section shown in red under the Original example.  (NOTE: the Guid will be different depending on what Software Component/Resource was used to create it):
    Original:

    SELECT DISTINCT

                                        [vri1_Computer].[Guid] AS [_ResourceGuid]

                                     FROM

                                        [vRM_Computer_Item] AS [vri1_Computer]

                                        INNER JOIN [Inv_InstalledSoftware] AS [dca2_InstalledSoftware]

                                           ON [vri1_Computer].[Guid] = [dca2_InstalledSoftware].[_ResourceGuid]

                                        INNER JOIN [vComputerResource] AS [ajs3_vComputerResource]

                                           ON [vri1_Computer].[Guid] = [ajs3_vComputerResource].[Guid]

                                     WHERE

                                        (

                                           (

                                            ([ajs3_vComputerResource].[IsManaged] = 1) AND EXISTS(SELECT _SoftwareComponentGuid, InstallFlag FROM Inv_InstalledSoftware WHERE InstallFlag = 1 AND (_SoftwareComponentGuid = '17ad7aa8-87f0-4594-888b-3491eb5b03da')))

                                        )

    Fixed:

    SELECT DISTINCT

                                        [vri1_Computer].[Guid] AS [_ResourceGuid]

                                     FROM

                                        [vRM_Computer_Item] AS [vri1_Computer]

                                        INNER JOIN [Inv_InstalledSoftware] AS [dca2_InstalledSoftware]

                                           ON [vri1_Computer].[Guid] = [dca2_InstalledSoftware].[_ResourceGuid]

                                        INNER JOIN [vComputerResource] AS [ajs3_vComputerResource]

                                           ON [vri1_Computer].[Guid] = [ajs3_vComputerResource].[Guid]

                                     WHERE

                                        (

                                           (

                                            ([ajs3_vComputerResource].[IsManaged] = 1) AND _ResourceGuid IN (SELECT _ResourceGuid FROM Inv_InstalledSoftware WHERE InstallFlag = 1 AND (_SoftwareComponentGuid = '17ad7aa8-87f0-4594-888b-3491eb5b03da')))

                                        )

  4. Once you've made the changes to the SQL as detailed above click Save Changes.
  5. This will properly return only systems that have the desired Software Component.

Supplemental Materials

SourceDEFECT
ValueLB 77501
DescriptionLogged in Littlebuggy (Altiris - Lindon, Plymouth) database

Legacy ID



46576


Article URL http://www.symantec.com/docs/TECH41835


Terms of use for this information are found in Legal Notices