The SD package seems to be present in database, but it is not visible in DSM Explorer.
The following query could be used to verify whether the package is present in the database (replace value for @SW_NAME and @SW_VERSION) :
DECLARE @SW_NAME VARCHAR(255)
DECLARE @SW_VERSION VARCHAR(255)
SET @SW_NAME='TEST'
SET @SW_VERSION='60'
SELECT * FROM usd_rsw
WHERE itemname=@SW_NAME and itemversion=@SW_VERSION
Client Automation - All versions.
There are 2 possible causes of package not being visible in the DSM Explorer:
Use this query to find out the rights the user has on the package in question.
Replace @SW_NAME, @SW_VERSION and @USER_NAME with appropriate values
DECLARE @SW_NAME VARCHAR(255)
DECLARE @SW_VERSION VARCHAR(255)
DECLARE @USER_NAME VARCHAR(255)
SET @SW_NAME='TEST'
SET @SW_VERSION='60'
SET @USER_NAME='%Administrator%'
SELECT u.label 'User Name', p.name 'Security Profile', a.ace, a.security_level
FROM ca_object_ace a, ca_security_profile p, ca_link_dis_user_sec_profile l, ca_discovered_user u
WHERE object_def_uuid=(SELECT objectid FROM usd_rsw WHERE itemname=@SW_NAME and itemversion=@SW_VERSION)
and p.security_profile_uuid=a.security_profile_uuid and p.type<100
and l.security_profile_uuid=p.security_profile_uuid and l.user_uuid=u.user_uuid
and u.label like @USER_NAME
See How to decode ace column of table ca_object_ace for explanation about column ace
This query returns the list of packages which have no links to the "All Software" folder:
SELECT r.itemname, r.itemversion
FROM usd_rsw r, usd_swfold f
WHERE f.name='$SOFTWAREFOLDER_%ALLSW%' and r.objectid not in (SELECT sw FROM usd_link_swg_sw WHERE swg=f.objectid)
If this query returns 1 or more rows, contact Broadcom Support in order to get a query to add the lost links in the database.