Creation of User Resources via CMDB Import

Is creating User Resources without ResourceKeys bad?

The definite answer is Yes. This is the official word from the SMP Development team. Whilst Symantec Support may deny it, creation of User resources without the 'name.domain' Resource Key will most probably result in duplicate User Resources within the CMDB.

Whilst CMDB Import tasks do create 'name.domain' Resource Keys for Computer resources, it does not for User resources. The 'name.domain' Resource Key is a requirement for both Computer and User resources.

My newly created User Resources are being deleted!

Arellia's "User Server Resource Discoverer" discovers User resources which have no required ResourceKey and deletes them to ensure that no duplicates will be created in the CMDB.

To disable the automatic delete of User Resources without resource keys, in the configuration tree:
/Settings/Arellia/Infrastructure/Resource Discovery/Server Discoverers

Disable the "User Server Resource Discoverer"

I cannot rely on my Active Directory for importing User and need to import using the CMDB functionality

Whilst this problem has been acknowledged by Symantec development there is still no current fix to the issue.

There are ways to get around the issue however if the CMDB import populates the "Global Windows User" dataclass with the domain name and user id of the user being imported.

The following three sql scripts will assist with the User Resource import without Resource Keys being populated issue:

Detect Imported Users that are a duplicate

select \* from Inv_Global_Windows_Users GWU
WHERE EXISTS 	(select 1 from ResourceKey RK where RK.KeyName = 'name.domain' and RK.KeyValue= (GWU.UserId + '.' + GWU.Domain) and RK.ResourceGuid != GWU._ResourceGuid)

Detects Users populated with domain details that should have a resource key populated

select \* from Inv_Global_Windows_Users GWU
WHERE NOT EXISTS&nbsp;	(select 1 from ResourceKey RK where RK.KeyName = 'name.domain' and RK.KeyValue= (GWU.UserId + '.' + GWU.Domain))
	AND UserId IS NOT NULL

Inserts ResourceKeys for Users that have Domain details populated, but no corresponding resource Key exists

INSERT INTO ResourceKey(ResourceGuid, KeyName, KeyValue)
select GWU._ResourceGuid, 'name.domain', (GWU.UserId + '.' + GWU.Domain) from Inv_Global_Windows_Users GWU
WHERE NOT EXISTS
(select 1 from ResourceKey RK where RK.KeyName = 'name.domain' and RK.KeyValue= (GWU.UserId + '.' + GWU.Domain))
AND UserId IS NOT NULL