Change AD Computer Description via CSV and Powershell
I'm fairly new to scripting in PowerShell, therefore, please pardon my skill...
I have this mini project to update AD computers descriptions based on the following format from a CSV file I have:
last user logged in, full name of that user, IP address of the machine, Computer manufacturer and model, serial number
jdrit | Joe Dirt | 10.10.10.10 | Dell OptiPlex 380 | 123456
... I searched the internet, but seems that everything needs to be done via WMCI object call. I was able to complie some code
$computers = Get-ADComputer
foreach ($computer in $computers)
{
$vendor = (Get-WMIObject -ComputerName $computer.Name Win32_ComputerSystemProduct).Vendor
$name = (Get-WMIObject -ComputerName $computer.Name Win32_ComputerSystemProduct).Name
$identifyingNumber = (Get-WMIObject -ComputerName $computer.Name Win32_ComputerSystemProduct).IdentifyingNumber
$vendor
$name
$identifyingNumber
Set-ADComputer $computer –Description “$vendor | $name | $identifyingNumber”
}
Would someone help a brother out? or point me in the right direction.
Help is greatly appreciated
powershell active-directory csv wmi wmic
asked Dec 18 '18 at 22:30
Chris
12
add a comment |
I'm fairly new to scripting in PowerShell, therefore, please pardon my skill...
I have this mini project to update AD computers descriptions based on the following format from a CSV file I have:
last user logged in, full name of that user, IP address of the machine, Computer manufacturer and model, serial number
jdrit | Joe Dirt | 10.10.10.10 | Dell OptiPlex 380 | 123456
... I searched the internet, but seems that everything needs to be done via WMCI object call. I was able to complie some code
$computers = Get-ADComputer
foreach ($computer in $computers)
{
$vendor = (Get-WMIObject -ComputerName $computer.Name Win32_ComputerSystemProduct).Vendor
$name = (Get-WMIObject -ComputerName $computer.Name Win32_ComputerSystemProduct).Name
$identifyingNumber = (Get-WMIObject -ComputerName $computer.Name Win32_ComputerSystemProduct).IdentifyingNumber
$vendor
$name
$identifyingNumber
Set-ADComputer $computer –Description “$vendor | $name | $identifyingNumber”
}
Would someone help a brother out? or point me in the right direction.
Help is greatly appreciated
powershell active-directory csv wmi wmic
asked Dec 18 '18 at 22:30
Chris
12
Nice that you posted some code. Where is it going wrong? What error message? Please edit the question and update. Do not reply in the comments.
– DavidPostill♦
Dec 19 '18 at 13:45
There is no error. I just need help completing the script. For example, how do I tell the script to look at a CSV file for the computer name I'm trying to update the description for? I also need help ID the WMI object to get the IP, last user and user full name.
– Chris
Dec 19 '18 at 21:56
add a comment |
I'm fairly new to scripting in PowerShell, therefore, please pardon my skill...
I have this mini project to update AD computers descriptions based on the following format from a CSV file I have:
last user logged in, full name of that user, IP address of the machine, Computer manufacturer and model, serial number
jdrit | Joe Dirt | 10.10.10.10 | Dell OptiPlex 380 | 123456
... I searched the internet, but seems that everything needs to be done via WMCI object call. I was able to complie some code
$computers = Get-ADComputer
foreach ($computer in $computers)
{
$vendor = (Get-WMIObject -ComputerName $computer.Name Win32_ComputerSystemProduct).Vendor
$name = (Get-WMIObject -ComputerName $computer.Name Win32_ComputerSystemProduct).Name
$identifyingNumber = (Get-WMIObject -ComputerName $computer.Name Win32_ComputerSystemProduct).IdentifyingNumber
$vendor
$name
$identifyingNumber
Set-ADComputer $computer –Description “$vendor | $name | $identifyingNumber”
}
Would someone help a brother out? or point me in the right direction.
Help is greatly appreciated
powershell active-directory csv wmi wmic
asked Dec 18 '18 at 22:30
Chris
12
I'm fairly new to scripting in PowerShell, therefore, please pardon my skill...
I have this mini project to update AD computers descriptions based on the following format from a CSV file I have:
last user logged in, full name of that user, IP address of the machine, Computer manufacturer and model, serial number
jdrit | Joe Dirt | 10.10.10.10 | Dell OptiPlex 380 | 123456
... I searched the internet, but seems that everything needs to be done via WMCI object call. I was able to complie some code
$computers = Get-ADComputer
foreach ($computer in $computers)
{
$vendor = (Get-WMIObject -ComputerName $computer.Name Win32_ComputerSystemProduct).Vendor
$name = (Get-WMIObject -ComputerName $computer.Name Win32_ComputerSystemProduct).Name
$identifyingNumber = (Get-WMIObject -ComputerName $computer.Name Win32_ComputerSystemProduct).IdentifyingNumber
$vendor
$name
$identifyingNumber
Set-ADComputer $computer –Description “$vendor | $name | $identifyingNumber”
}
Would someone help a brother out? or point me in the right direction.
Help is greatly appreciated
powershell active-directory csv wmi wmic
powershell active-directory csv wmi wmic
asked Dec 18 '18 at 22:30
Chris
12
asked Dec 18 '18 at 22:30
Chris
12
asked Dec 18 '18 at 22:30
Chris
12
asked Dec 18 '18 at 22:30
Chris
12
asked Dec 18 '18 at 22:30
Chris
12
12
Nice that you posted some code. Where is it going wrong? What error message? Please edit the question and update. Do not reply in the comments.
– DavidPostill♦
Dec 19 '18 at 13:45
There is no error. I just need help completing the script. For example, how do I tell the script to look at a CSV file for the computer name I'm trying to update the description for? I also need help ID the WMI object to get the IP, last user and user full name.
– Chris
Dec 19 '18 at 21:56
add a comment |
Nice that you posted some code. Where is it going wrong? What error message? Please edit the question and update. Do not reply in the comments.
– DavidPostill♦
Dec 19 '18 at 13:45
There is no error. I just need help completing the script. For example, how do I tell the script to look at a CSV file for the computer name I'm trying to update the description for? I also need help ID the WMI object to get the IP, last user and user full name.
– Chris
Dec 19 '18 at 21:56
Nice that you posted some code. Where is it going wrong? What error message? Please edit the question and update. Do not reply in the comments.
– DavidPostill♦
Dec 19 '18 at 13:45
Nice that you posted some code. Where is it going wrong? What error message? Please edit the question and update. Do not reply in the comments.
– DavidPostill♦
Dec 19 '18 at 13:45
There is no error. I just need help completing the script. For example, how do I tell the script to look at a CSV file for the computer name I'm trying to update the description for? I also need help ID the WMI object to get the IP, last user and user full name.
– Chris
Dec 19 '18 at 21:56
There is no error. I just need help completing the script. For example, how do I tell the script to look at a CSV file for the computer name I'm trying to update the description for? I also need help ID the WMI object to get the IP, last user and user full name.
– Chris
Dec 19 '18 at 21:56
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1385720%2fchange-ad-computer-description-via-csv-and-powershell%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1385720%2fchange-ad-computer-description-via-csv-and-powershell%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Nice that you posted some code. Where is it going wrong? What error message? Please edit the question and update. Do not reply in the comments.
– DavidPostill♦
Dec 19 '18 at 13:45
There is no error. I just need help completing the script. For example, how do I tell the script to look at a CSV file for the computer name I'm trying to update the description for? I also need help ID the WMI object to get the IP, last user and user full name.
– Chris
Dec 19 '18 at 21:56