asked on
USE [Dashboard]
DECLARE @ComputerADpath nvarchar(64) = 'LDAP://DC=demo,DC=lab';
DECLARE @ComputerADfilter nvarchar(64) = '(&(objectCategory=*)(objectClass=computer))';
DECLARE @ComputerMembers XML;
INSERT INTO [dbo].[Computers]
EXEC clr_GetADobjects @ComputerADpath, @ComputerADfilter, @ComputerMembers OUTPUT;