Solved

update notes field in DL

Posted on 2014-09-24
17
143 Views
Last Modified: 2014-09-30
Hi,

I have this code;

import-module activedirectory
GC C:\temp\group.txt | ?{$_}|%{
set-group -Notes "Created - 24/08/2014  
Required - permanent
Owners - user1,user2”
}

Can you please correct this code so that it can see my txt file named as group.txt which contains list of my Distribution groups needs updating in Notes field.

I have tested this single line of code and it worked fine and now need to do over 100 of DLs.

Set-Group –identity G_test –Notes “For chess lovers!”
0
Comment
Question by:kuzum
  • 11
  • 6
17 Comments
 
LVL 12

Expert Comment

by:Steven Wells
Comment Utility
Have oh tried the get-content method in power shell?

http://technet.microsoft.com/en-us/library/ee176843.aspx

It will be a bit easer to use
0
 

Author Comment

by:kuzum
Comment Utility
did iyou mean this

import-module activedirectory
GC C:\temp\group.txt | ?{$_}|%{ foreach-object {set-group -Notes "Created - 24/08/2014  
Required - Permanent  
Owners - user1, user2”
}
}
0
 
LVL 12

Expert Comment

by:Steven Wells
Comment Utility
What message do you get when you run what you have?
0
 

Author Comment

by:kuzum
Comment Utility
An empty pipe element is not allowed.
At line:2 char:33
0
 
LVL 12

Expert Comment

by:Steven Wells
Comment Utility
This should work
GC C:\temp\group.txt | % {Set-ADGroup $_ -replace @{info="Created - 24/08/2014"}}
0
 
LVL 12

Expert Comment

by:Steven Wells
Comment Utility
The above was run using powershell command Set-ADGroup rather than set-group. Not sure what server you are running this from.
0
 

Author Comment

by:kuzum
Comment Utility
thanks, running it on my windows 7 machine, also any reason why SEt-AD group? I did a test and works perfect?
0
 
LVL 12

Expert Comment

by:Steven Wells
Comment Utility
I did my test for you from a server 2008 domain controller. What ever works for you.  There will be differences in the version of powershell modules
0
Wish Marketing would stop bothering you?

Is your marketing department constantly asking for new email signature updates? Are they requesting a different design for every department? Do they need yet another banner added? Don’t let it get you down! There is an easy way to manage all of these requests...

 

Author Comment

by:kuzum
Comment Utility
thanks, I have to run it on my windows 7 machine, but test it on DC 2008 and had the same error

Set-ADGroup : Cannot find an object with identity: 'XXXX' under: 'DC=mydomain,DC=domain,DC=com'.

Is there any way you amend my original code to work againts my txt file? Because I am not having any issues with that.
" @{info"  is  shown as "notes" field. are we sure about this?  I could be wrong so apoligies in advanced

thanks
0
 
LVL 12

Expert Comment

by:Steven Wells
Comment Utility
Can you post the text file? It should just have the name of the group in list format.  What happens if you run on the server?

Can you post the exact command you are running?
0
 
LVL 12

Expert Comment

by:Steven Wells
Comment Utility
My tests were done with a simple text file with a list of normal group names. Running the command from the active directory for powershell shortcut on a 2008 r2 server. The command was on one line.  The @notes thing is needed as the noted field can't be directly accessed using the set Ad-group command.   What version of exchange are you using too?
0
 

Author Comment

by:kuzum
Comment Utility
2010
0
 
LVL 12

Expert Comment

by:Steven Wells
Comment Utility
Ok. Same as me.
0
 
LVL 12

Expert Comment

by:Steven Wells
Comment Utility
Result of Command
This is what it looks like running on server.
0
 
LVL 12

Expert Comment

by:Steven Wells
Comment Utility
ok I know what you are doing now.

You are using the powershell for exchange.

In that case, this works

GC C:\temp\group.txt | Set-group  -Notes "Created - 24/08/2014"
0
 

Author Comment

by:kuzum
Comment Utility
Ok thanks, I got it working on a single DL in my txt file but had issues for the whole list and it is because of the spaces in the list. can you please change this avoid space between DLs. they are listed as;

dl name1

dlname2   etc.

GC C:\temp\group.txt | ?{$_}%{Set-ADGroup $_ -replace @{info="Created - 23/07/2012
Required - Permanent
Owners - user1, user2"}}
0
 
LVL 12

Accepted Solution

by:
Steven Wells earned 500 total points
Comment Utility
Ok, lets treat this with two commands.

1. Open Powershell for Exchange 2010

2. run this command to create a new file with no spaces or empty lines.

 
(gc C:\TEMP\Group.txt) | Foreach {$_.TrimEnd()} | where {$_ -ne ""} | Set-Content C:\temp\inputfile.txt

Open in new window


3. Then run this command to use the inputfile.txt, which will have correctly formatted lines.

GC C:\temp\inputfile.txt | set-group -Notes "What ever you want your notes to be "

Open in new window


Ensure that all your groups actually exist.

This should work correctly.
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

ADCs have gained traction within the last decade, largely due to increased demand for legacy load balancing appliances to handle more advanced application delivery requirements and improve application performance.
A procedure for exporting installed hotfix details of remote computers using powershell
To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
This video discusses moving either the default database or any database to a new volume.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now