Change all packages from software library that are set to "Package Servers Individual" to "All Package Servers"
Article ID: 176315
IT Management Suite
Customer has replicated some software packages from Company A to Company B. Now in company B's NS, we have list of all software packages. But some of them are assigned to all Package Servers, and some just to Specific Sites.
Run the following Query
To make sure, please get a back up of your database first.
After running the query, run Package Refresh task.
declare @packageGuid uniqueidentifier
declare Modify_Package CURSOR FOR
where State like '%<packageServers autoAssignToSites="False" method="individual" />%'
and ProductGuid <> 'B1338338-5575-4A27-9808-23BEC40D79FA'
FETCH NEXT FROM Modify_Package Into @packageGuid
WHILE @@FETCH_STATUS = 0
SET [State] = replace(cast([State] as nvarchar(max)),