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
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.
ITMS 7.1 Sp2
This is machine translated content
Login to Subscribe
Please login to set up your subscription.
Didn't find the article you were looking for? Try these resources.