Hi
mwysocki!
Computers which have a 'Altiris Server' role in their basic inventory data class "Inv_AeX_AC_Roles" detected as Notification Server and for such resource 'delete' action in right click menu is not available to avoid existing NS machines deletion.
If mouse right click on this computer from SMP Console and check "Properties", you will see there 'Attribute' value which is 'NoDelete' for Notification Server role computers
Workaround to delete required computer resource which by default has 'NoDelete' attribute in database:
1. Open SQL management studio for SQL Server Instance where "Symantec_CMDB" database is running
2. From SMP Console, find required computer -> mouse right click on it -> properties -> copy its "Guid" value
3. Go back to already opened SQL management studio and execute this SQL query:
SELECT * FROM RM_ResourceComputer WHERE Guid='Put here your computer GUID' --Check that this is really required for deletion computer resource
4. Now need to execute this SQL query to change current 'NoDelete' attribute to 'Normal' to allow deletion of this computer from SMP Console via right click menu:
UPDATE RM_ResourceComputer
SET Attributes = 0 WHERE Guid='Put here your computer GUID'
5. Go back to SMP Console, find required computer for deletion -> mouse right click on it and 'Delete'.
Thanks,
IP.
------------------------------
Software QA Engineer
Broadcom Inc.
------------------------------
Original Message:
Sent: 09-18-2020 02:05 PM
From: Mark Wysocki
Subject: Delete Old SMP Server
I recently upgrade from 7.6 to 8.1 and to make the move faster and easier i took a copy of my 7.6 DB and used it for the new 8.1 SMP install.
The issue i need help with is that the old 7.6 server is showing in the computers list but i have no option to delete it.
I am hoping someone has a query to force this system out from the new server.
------------------------------
PAREXEL Informatics
------------------------------