Link to home
Start Free TrialLog in
Avatar of shyam pothini
shyam pothini

asked on

exporting PC names from excel to group policy

Hello all,

We have about 50 computer names in excel, and we want to exclude form group policy.
We already have 20 PC excluded from group policy using wmi filter in AD
So is there any script that can include more 50 PC's to wmi filter?

Thanks
Avatar of Shaun Vermaak
Shaun Vermaak
Flag of Australia image

Yes, add them to a group and exclude the group vi WMI filter, item filter or security filter
Avatar of shyam pothini
shyam pothini

ASKER

Thanks Shaun,

is there a script to put the pc names from excel to wmi filter?
You can literally add ; to entries in Excel and copy it to the group add dialogue
=A1 & ";"

Open in new window

Thanks

I am confused

I am using
SELECT NAME FROM Win32_ComputerSystem WHERE NOT (Name LIKE 'comp1-%')
I am including all pc names there, but there are 50-100 coming in. I don't want to add one by one
is there any work around?
ASKER CERTIFIED SOLUTION
Avatar of Shaun Vermaak
Shaun Vermaak
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial