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. |
Problem
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:
- Browse to the new filter, usually found under Manage > Filters > Software Filters (you may want to make a clone before editing just in case...).
- Once loaded, Click the Edit button. in the upper right.
- 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')))
)
- Once you've made the changes to the SQL as detailed above click Save Changes.
- This will properly return only systems that have the desired Software Component.
| Source | DEFECT |
| Value | LB 77501 |
| Description | Logged 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
Thank you.