Hi Greg!
GregST: We have been using deployment solution on 8.6 for a month and this issue just came up. the 8.6 DB and NS were built from scratch but some settings., filters, etc. were imported.
IP: Assume that there were used stand-alone replication rules from an old NS and after such replication of items, resources their NS owner became for old NS instead of new NS. To avoid this and make all stand-alone replicated/imported items, resources related to new NS as owner, need to use coresetting "ReplicationOverwriteSourceNS"
1. About "ServerSettingsGuids" sql table output
Is there NSResourceGuid value same as your new NS has (Check in SMA UI on new NS and compare with NSResourceGuid value on pic below)
2. According to your results from ItemNSSource sql table, I suspect that all items, resources belong to old NS (USS....) and in UI of SMP Console you also see that NS Owner of resources isn't your new NS 8.6
This is because most of Items in "ItemNSSource" sql table have value 'OriginNSSourceNSId'=2 or 3 but not 1.
You can check this in SMP Console in "Default" org view, sorting by "Source" column
This can be updated, using simple sql query
(But do not execute this if you don't have a "Symantec_CMDB" database backup available)
UPDATE ItemNSSource
SET OriginNSSourceNSId = 1 WHERE OriginNSSourceNSId != 1
3. For SQL query values from "RM_ResourceComputer" and "RM_ResourceVirtual_Machine" sql tables, I see that they all have single OwnerNSGuid.
Interesting to understand, do they have a new NS ownerNSGuid or from old NS.
Please execute these sql queries to see whether physical & virtual machines have there new NS or old NS OwnerGuid. If they will have guid from old NS, then this should be an answer why after scheduling a job or task it has 'replicated' state.
--/// New NS 8.6 OwnerNSGuid: B37852E7-EC24-4C6A-AB20-8B444B33A3CE
SELECT COUNT(*) OwnerNSGuid FROM RM_ResourceComputer
WHERE OwnerNSGuid='B37852E7-EC24-4C6A-AB20-8B444B33A3CE'
--/// Old NS OwnerNSGuid: 3744CDDD-5827-4FD8-906D-A5082044DCDA
SELECT COUNT(*) OwnerNSGuid FROM RM_ResourceVirtual_Machine
WHERE OwnerNSGuid='B37852E7-EC24-4C6A-AB20-8B444B33A3CE'
--/// New NS 8.6 OwnerNSGuid: B37852E7-EC24-4C6A-AB20-8B444B33A3CE
SELECT COUNT(*) OwnerNSGuid FROM RM_ResourceComputer
WHERE OwnerNSGuid='3744CDDD-5827-4FD8-906D-A5082044DCDA'
--/// Old NS OwnerNSGuid: 3744CDDD-5827-4FD8-906D-A5082044DCDA
SELECT COUNT(*) OwnerNSGuid FROM RM_ResourceVirtual_Machine
WHERE OwnerNSGuid='3744CDDD-5827-4FD8-906D-A5082044DCDA'
Best regards,
IP.