0 votes

Good afternoon,

I'm looking to generate a script to allow automation of updating job titles using a spreadsheet.

To do this we would use a spreadsheet generated by another team called "UserExportSpreadsheet" (See attached for sanitized copy). Example of Spreadsheet And basically if a user's job title in the spreadsheet is different from AD (using columns B and O in the spreadsheet for reference against EmployeeID and Job Title in AD).

We would run this command once a month using a scheduled task. But i'm looking for assistance with the proper scripting and in calling the file.

Please let me know if you require any additional information Regards

by (3.6k points)

1 Answer

0 votes
by (189k points)

Hello,

You can use Script 2: Only update existing users from the following article in our repository: https://www.adaxes.com/script-repository/import-new-and-updated-users-from-csv-file-s246.htm. If you need to modify the script but face issues to do so, please, provide all the possible details regarding the desired behavior with live examples and we will help you.

Related questions

0 votes
0 answers

If I wanted to exclude a list of job titles from this report how would I update the script?

asked Nov 18, 2019 by hgletifer (6.8k points)
0 votes
1 answer

We have a property pattern for a user's job title that lists all the aviable titles. I need to be able to add a new constraint to this within a custom command and from Powershell on a differant computer. Would you be able to help?

asked Sep 23 by hgletifer (6.8k points)
0 votes
1 answer

I've got the following script as part of a larger piece where param-members is an AD Object picker list seperated by a ' ; ' currently: New-DistributionGroup -Name ... or convert that to username but I'm struggling to achieve that with multiple Users selected

asked Jan 27 by richarddewis (1.5k points)
0 votes
0 answers

I have created a Custom action to create some "standard" sub OUs to a particular type of OU in our AD. I wanted to create a script to look in the OU you are executing ... 'Users') -or ($child.Name -eq 'Computer Systems')) {$Context.ConditionIsMet = $False } }

asked Aug 31, 2016 by ggallaway (1.2k points)
0 votes
1 answer

Is it possible to update a Propery Pattern using a powershell script? If a new department OU is created, is it possible to automaticly update the User Pattern's Department property to reflect that a new department has been added?

asked Jan 28, 2013 by kjesoo (7k points)
2,352 questions
2,107 answers
5,746 comments
131,012 users