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
Article Type
Technical Solution


Environment

Issue



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.


Supplemental Materials

SourceETrack
Value2906115


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


Terms of use for this information are found in Legal Notices