How do i Filter the DHCP Lease information that i export
I just wrote a powershell script that will export dhcp lease information but i want to export specific information like export only IP and mac addresses in the dhcp. Instead of exporting every lease information. The one line of code i have written that exports everything is bellow.
Get-DhcpServerv4Lease -ComputerName "HW2009-11" | Export-Csv -Path ("C:lognew.csv")
powershell powershell-v2.0 powershell-v3.0 dhcp
asked Nov 15 '18 at 11:12
theotheo
116
add a comment |
I just wrote a powershell script that will export dhcp lease information but i want to export specific information like export only IP and mac addresses in the dhcp. Instead of exporting every lease information. The one line of code i have written that exports everything is bellow.
Get-DhcpServerv4Lease -ComputerName "HW2009-11" | Export-Csv -Path ("C:lognew.csv")
powershell powershell-v2.0 powershell-v3.0 dhcp
asked Nov 15 '18 at 11:12
theotheo
116
2
How does the output ofGet-DhcpServerv4Leaselook like? Have you tried some basic things likeGet-DhcpServerv4Lease -ComputerName "HW2009-11" | Select-Object -Property IP, mac-address?
– Paxz
Nov 15 '18 at 11:22
@Paxz Thanks very much i just did DhcpServerv4Lease -ComputerName "HW2009-11" | Select-Object -Property IP, mac-address | Export-Csv -Path ("C:lognew.csv") and it works fine
– theo
Nov 15 '18 at 11:33
add a comment |
I just wrote a powershell script that will export dhcp lease information but i want to export specific information like export only IP and mac addresses in the dhcp. Instead of exporting every lease information. The one line of code i have written that exports everything is bellow.
Get-DhcpServerv4Lease -ComputerName "HW2009-11" | Export-Csv -Path ("C:lognew.csv")
powershell powershell-v2.0 powershell-v3.0 dhcp
asked Nov 15 '18 at 11:12
theotheo
116
I just wrote a powershell script that will export dhcp lease information but i want to export specific information like export only IP and mac addresses in the dhcp. Instead of exporting every lease information. The one line of code i have written that exports everything is bellow.
Get-DhcpServerv4Lease -ComputerName "HW2009-11" | Export-Csv -Path ("C:lognew.csv")
powershell powershell-v2.0 powershell-v3.0 dhcp
powershell powershell-v2.0 powershell-v3.0 dhcp
asked Nov 15 '18 at 11:12
theotheo
116
asked Nov 15 '18 at 11:12
theotheo
116
edited Nov 15 '18 at 11:19
theo
asked Nov 15 '18 at 11:12
theotheo
116
asked Nov 15 '18 at 11:12
theotheo
116
asked Nov 15 '18 at 11:12
theotheo
116
116
2
How does the output ofGet-DhcpServerv4Leaselook like? Have you tried some basic things likeGet-DhcpServerv4Lease -ComputerName "HW2009-11" | Select-Object -Property IP, mac-address?
– Paxz
Nov 15 '18 at 11:22
@Paxz Thanks very much i just did DhcpServerv4Lease -ComputerName "HW2009-11" | Select-Object -Property IP, mac-address | Export-Csv -Path ("C:lognew.csv") and it works fine
– theo
Nov 15 '18 at 11:33
add a comment |
2
How does the output ofGet-DhcpServerv4Leaselook like? Have you tried some basic things likeGet-DhcpServerv4Lease -ComputerName "HW2009-11" | Select-Object -Property IP, mac-address?
– Paxz
Nov 15 '18 at 11:22
@Paxz Thanks very much i just did DhcpServerv4Lease -ComputerName "HW2009-11" | Select-Object -Property IP, mac-address | Export-Csv -Path ("C:lognew.csv") and it works fine
– theo
Nov 15 '18 at 11:33
2
2
How does the output of
Get-DhcpServerv4Lease look like? Have you tried some basic things like Get-DhcpServerv4Lease -ComputerName "HW2009-11" | Select-Object -Property IP, mac-address?– Paxz
Nov 15 '18 at 11:22
How does the output of
Get-DhcpServerv4Lease look like? Have you tried some basic things like Get-DhcpServerv4Lease -ComputerName "HW2009-11" | Select-Object -Property IP, mac-address?– Paxz
Nov 15 '18 at 11:22
@Paxz Thanks very much i just did DhcpServerv4Lease -ComputerName "HW2009-11" | Select-Object -Property IP, mac-address | Export-Csv -Path ("C:lognew.csv") and it works fine
– theo
Nov 15 '18 at 11:33
@Paxz Thanks very much i just did DhcpServerv4Lease -ComputerName "HW2009-11" | Select-Object -Property IP, mac-address | Export-Csv -Path ("C:lognew.csv") and it works fine
– theo
Nov 15 '18 at 11:33
add a comment |
1 Answer
1
active
oldest
votes
To adress only certain properties of an object, you can use Select-Object. This way you can only choose the ipand mac-address like this:
Get-DhcpServerv4Lease -ComputerName "HW2009-11" | Select-Object -Property IP, mac-address
You can then pipe this to Export-Csv and it will create a .csv file with only those properties:
Get-DhcpServerv4Lease -ComputerName "HW2009-11" | Select-Object -Property IP, mac-address | Export-Csv -Path "C:lognew.csv"
If you don't know the specific properties of an object, you can just pipe the command to Get-Member:
Get-DhcpServerv4Lease | Get-Member
answered Nov 15 '18 at 11:51
PaxzPaxz
2,421927
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
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%2fstackoverflow.com%2fquestions%2f53318200%2fhow-do-i-filter-the-dhcp-lease-information-that-i-export%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
To adress only certain properties of an object, you can use Select-Object. This way you can only choose the ipand mac-address like this:
Get-DhcpServerv4Lease -ComputerName "HW2009-11" | Select-Object -Property IP, mac-address
You can then pipe this to Export-Csv and it will create a .csv file with only those properties:
Get-DhcpServerv4Lease -ComputerName "HW2009-11" | Select-Object -Property IP, mac-address | Export-Csv -Path "C:lognew.csv"
If you don't know the specific properties of an object, you can just pipe the command to Get-Member:
Get-DhcpServerv4Lease | Get-Member
answered Nov 15 '18 at 11:51
PaxzPaxz
2,421927
add a comment |
To adress only certain properties of an object, you can use Select-Object. This way you can only choose the ipand mac-address like this:
Get-DhcpServerv4Lease -ComputerName "HW2009-11" | Select-Object -Property IP, mac-address
You can then pipe this to Export-Csv and it will create a .csv file with only those properties:
Get-DhcpServerv4Lease -ComputerName "HW2009-11" | Select-Object -Property IP, mac-address | Export-Csv -Path "C:lognew.csv"
If you don't know the specific properties of an object, you can just pipe the command to Get-Member:
Get-DhcpServerv4Lease | Get-Member
answered Nov 15 '18 at 11:51
PaxzPaxz
2,421927
add a comment |
To adress only certain properties of an object, you can use Select-Object. This way you can only choose the ipand mac-address like this:
Get-DhcpServerv4Lease -ComputerName "HW2009-11" | Select-Object -Property IP, mac-address
You can then pipe this to Export-Csv and it will create a .csv file with only those properties:
Get-DhcpServerv4Lease -ComputerName "HW2009-11" | Select-Object -Property IP, mac-address | Export-Csv -Path "C:lognew.csv"
If you don't know the specific properties of an object, you can just pipe the command to Get-Member:
Get-DhcpServerv4Lease | Get-Member
answered Nov 15 '18 at 11:51
PaxzPaxz
2,421927
To adress only certain properties of an object, you can use Select-Object. This way you can only choose the ipand mac-address like this:
Get-DhcpServerv4Lease -ComputerName "HW2009-11" | Select-Object -Property IP, mac-address
You can then pipe this to Export-Csv and it will create a .csv file with only those properties:
Get-DhcpServerv4Lease -ComputerName "HW2009-11" | Select-Object -Property IP, mac-address | Export-Csv -Path "C:lognew.csv"
If you don't know the specific properties of an object, you can just pipe the command to Get-Member:
Get-DhcpServerv4Lease | Get-Member
answered Nov 15 '18 at 11:51
PaxzPaxz
2,421927
answered Nov 15 '18 at 11:51
PaxzPaxz
2,421927
answered Nov 15 '18 at 11:51
PaxzPaxz
2,421927
answered Nov 15 '18 at 11:51
PaxzPaxz
2,421927
2,421927
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- 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%2fstackoverflow.com%2fquestions%2f53318200%2fhow-do-i-filter-the-dhcp-lease-information-that-i-export%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
2
How does the output of
Get-DhcpServerv4Leaselook like? Have you tried some basic things likeGet-DhcpServerv4Lease -ComputerName "HW2009-11" | Select-Object -Property IP, mac-address?– Paxz
Nov 15 '18 at 11:22
@Paxz Thanks very much i just did DhcpServerv4Lease -ComputerName "HW2009-11" | Select-Object -Property IP, mac-address | Export-Csv -Path ("C:lognew.csv") and it works fine
– theo
Nov 15 '18 at 11:33