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|
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.
ITMS 7.1 Sp2
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]
SELECT vs.Guid, vs.Name
FROM vRM_Software_Component_Item vs
WHERE vs.Attributes & 1 <> 1
where ResourceAssociationTypeGuid = '4486DFB2-D504-4493-B5B0-DF950352AB05'--Software Package Installs Software Component
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.
Article URL http://www.symantec.com/docs/TECH195369