I am trying to insert CI's with GRLoader and want to add a Group as the resource_contact. I am using a sql clause in a Batch file. I am able to insert the new CI's, but cannot get the correct syntax to add a group as the resource_contact.
Below is the query in my Batch file:
select distinct sf.resource_name name,sf.group_name system_name,'Application Security' class,'Security' family,'Production' status,'Salesforce PH ' + sf.user_role asset_num, 'Identity and Access Management' resource_contact, sf.user_role + ' profile within Priority Health Salesforce.' description,'\\catalog\Icons\salesforce.png' z_icon_path from sh_salesforce_newRoles_invalidCIs sf where sf.CI_Exists = 'No'
The result is Read = 1, Inserts = 1, Warnings = 1