AC 7.1 Sp2 - The "Software Releases" saved search does not show valid software releases when there is an entry in the Inv_AddRemoveProgram table.
| Article:TECH195369 | | | Created: 2012-08-22 | | | Updated: 2012-08-24 | | | Article URL http://www.symantec.com/docs/TECH195369 |
Problem
The "Software Releases" saved search does not show valid software releases when there is an entry in the Inv_AddRemoveProgram table. This entry excludes it from the vAC_VisibleSoftware view and makes it invisible for the Software Releases saved search.
Error
N/A
Environment
ITMS 7.1 Sp2
Cause
KNOWN ISSUE
Solution
vAC_VisibleSoftware excludes any software that has Hidden = 1 in Inv_AddRemoveProgram. It does not filter out everything in Inv_AddRemoveProgram. This is by design as most software marked as Hidden in AddRemove Programs on PC's is "irrelevant" software.
Below is a modified Activity Center view to show also Software Releases hidden in Add/Remove Programs. Make a full backup of the Symantec_CMDB database before applying this change to the Symantec_CMDB database.
ALTER View [dbo].[vAC_DeliverableSoftware]
As
SELECT vs.Guid, vs.Name
FROM vRM_Software_Component_Item vs
WHERE vs.Attributes & 1 <> 1
AND
(vs.Guid in
(
(select ChildResourceGuid
from ResourceAssociation
where ResourceAssociationTypeGuid = '4486DFB2-D504-4493-B5B0-DF950352AB05'--Software Package Installs Software Component
)
)
OR
(vs.Guid in
(select ChildResourceGuid
from ResourceAssociation
where ResourceAssociationTypeGuid = '2d12146f-8aa9-4a41-b7db-577892ef8692'--Software Program Installs Software Component
)
)
)
NOTE: Please note that this change is provided as is and at your responcebility to make a full backup of the Symantec_CMDB database. This version of the view has not completed the full product quality testing cycles.
|
|
| Source | ETrack |
| Value | 2906115 |
Article URL http://www.symantec.com/docs/TECH195369
Terms of use for this information are found in Legal Notices
Thank you.