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 (680 points)

1 Answer

0 votes
by (220k 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
1 answer

Hi Currently we have an Adaxes system set up for our Service Desk staff to log into and manage users / groups etc this is currently assigned by assigning the Service ... there be any limiting factors such as licencing requirements for this? Thanks in advance.

asked Dec 15, 2020 by R_C (70 points)
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 (1.2k 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, 2020 by hgletifer (1.2k points)
0 votes
1 answer

I have an account that I am using as the "run as" account to run PowerShell scripts for several different custom commands. I would like to be able to update the ... a script that updates the credentials used to run a script in an existing custom command?

asked Oct 18, 2021 by KelseaIT (320 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, 2020 by richarddewis (240 points)
2,740 questions
2,474 answers
6,475 comments
1,373,507 users