{"id":16361,"date":"2010-11-30T00:01:00","date_gmt":"2010-11-30T00:01:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/heyscriptingguy\/2010\/11\/30\/use-powershell-to-export-and-to-import-repetitive-commands\/"},"modified":"2010-11-30T00:01:00","modified_gmt":"2010-11-30T00:01:00","slug":"use-powershell-to-export-and-to-import-repetitive-commands","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/scripting\/use-powershell-to-export-and-to-import-repetitive-commands\/","title":{"rendered":"Use PowerShell to Export and to Import Repetitive Commands"},"content":{"rendered":"

 <\/span><\/p>\n

Summary:<\/span><\/b> Learn how to use Windows PowerShell to import and to export command history and avoid writing scripts.<\/span><\/p>\n

 <\/span><\/p>\n

\"Hey,<\/span><\/span>Hey, Scripting Guy! I have worked with other systems where I was able to keep track of the commands that I typed into the console. The neat thing about that was that I could export my commands, and import them into another console and replay my command history. This was a great way to perform repetitive configuration tasks without having to write a script. Is this something that can be accomplished with Windows PowerShell?<\/span><\/p>\n

— SW<\/span><\/p>\n

 <\/span><\/p>\n

\"Hey,<\/span><\/span>Hello SW, Microsoft Scripting Guy Ed Wilson here. Windows PowerShell has great command history features. By learning how to use the command history features of Windows PowerShell, many repetitive tasks can be automated. <\/span><\/p>\n

<\/span><\/p>\n

Portions of today’s Hey, Scripting Guy! Blog post are adapted from material in my <\/span>Windows PowerShell 2.0 Best Practices book<\/span><\/span><\/i><\/a>, published by Microsoft Press in December 2009. <\/span><\/p>\n

Much administrative work with Windows PowerShell consists of typing a series of commands at the console. Whether it is editing the registry, stopping various processes and services, the configuration work has to be replicated to several different servers to make sure a consistent operating environment. In the past such duplication of effort would require creating scripts. If the commands to be duplicated are a series of commands typed at the console, you can use the command history mechanism to replace the need for a script. To do this, use the Get-History<\/b> cmdlet and export the commands to an xml file as seen here. <\/span><\/p>\n

Get-History | Export-Clixml -Path C:\\fso\\history.xml<\/span><\/span><\/p>\n

 <\/span><\/p>\n

The result is an XML file that represents all the commands which have been typed at the console. The resulting xml file is seen in the following figure.<\/span><\/p>\n

<\/span> <\/span><\/p>\n

<\/span><\/p>\n

<\/span><\/p>\n

<\/span><\/p>\n

After you have created a command history xml file, you can import the commands from the xml file by using the Import-Clixml<\/b> cmdlet. You pipeline the results of the Import-Clixml<\/b> cmdlet to the Add-History<\/b> cmdlet to add the commands back to the command history. The trick is to use the –passthru<\/b> switch  <\/span>so that the commands will go to both the Add-History<\/b> cmdlet and to the ForEach-Object<\/b> cmdlet as well. In the Foreach-Object<\/b> cmdlet you use the Invoke-History<\/b> cmdlet to run each command that is in the history. The commands are shown here, as are the results of running them. <\/span><\/p>\n

PS C:\\> Import-Clixml -Path C:\\fso\\history.xml | Add-History -Passthru |
>> ForEach-Object { Invoke-History }
>>
 <\/span>if(!(test-path -path c:\\fso4)) { new-item c:\\fso4 -ItemType directory }<\/p>\n

    <\/span>Directory: C:\\<\/p>\n

Mode                <\/span>LastWriteTime     <\/span>Length Name
—-                <\/span>————-     <\/span>—— —-
d—-          <\/span>1\/9\/2009  <\/span>12:33 AM            <\/span>fso4
Get-Command >> C:\\fso4\\commands.txt
notepad C:\\fso4\\commands.txt<\/span><\/span><\/p>\n

 <\/span><\/p>\n

This technique will work remotely by using the Invoke-Command<\/b> cmdlet. The thing to keep in mind is that the path statement is relative to the computer that is the target, not the computer that is executing the command. If you do not keep this in mind, then an error such as the one seen in the following figure appears.<\/span><\/p>\n

<\/span> <\/span><\/p>\n

<\/span><\/p>\n

<\/span><\/p>\n

If you copy the file to the target machine first, and adjust your command line, the import and execute history technique works well. The good thing about Windows PowerShell, is that you can use an UNC path with the Copy-Item<\/b> cmdlet. It is this feature that actually makes the technique worthwhile because it enables you to easily move a file to a remote computer. This is shown here. <\/span><\/p>\n

PS C:\\> Copy-Item C:\\fso\\history.xml \\\\berlin\\c$\\fso
PS C:\\> Import-Clixml -Path C:\\fso\\history.xml | Add-History -Passthru | ForEach
-Object { Invoke-History }
 <\/span>if(!(test-path -path c:\\fso4)) { new-item c:\\fso4 -ItemType directory }<\/p>\n

    <\/span>Directory: C:\\<\/p>\n

Mode                <\/span>LastWriteTime     <\/span>Length Name
—-                <\/span>————-     <\/span>—— —-
d—-          <\/span>1\/9\/2009  <\/span>12:40 AM            <\/span>fso4
Get-Command >> C:\\fso4\\commands.txt
notepad C:\\fso4\\commands.txt<\/span><\/span><\/p>\n

 <\/span><\/p>\n

Fan out commands are commands that are launched from a central computer and run against a number of remote computers. One way to perform this technique is to use the Invoke-Command<\/b> cmdlet as seen here. <\/span><\/p>\n

PS C:\\> Invoke-Command -Computer berlin,vista -Script `
>> {“$env:computername $(get-date)” }
>>
VISTA 01\/09\/2009 08:31:42
BERLIN 01\/09\/2009 08:31:47<\/span><\/span><\/p>\n

 <\/span><\/p>\n

You can use fan out commands by specifying an array of computer names for the computername<\/i> parameter for many of the cmdlets. The problem with this approach is the results are almost useless. An example may show the issue that is involved. In the command below, the Get-Service<\/b> cmdlet is used to obtain service configuration information from two computers. The first is a computer named Vista, and the second one is a server named Berlin. As you can see from the partial output, copied here, the results of the command are merged, and there is no column that shows the computer name that the result is associated with. The results are interesting because you can quickly look at the service name between two computers and easily see divergent configurations. The fan out command and a truncated result set is seen here. <\/span><\/p>\n

PS C:\\> Get-Service -ComputerName Vista, Berlin<\/p>\n

Status   <\/span>Name               <\/span>DisplayName
——   <\/span>—-               <\/span>———–
Running  <\/span>1-vmsrvc           <\/span>Virtual Machine Additions Services …
Running  <\/span>1-vmsrvc           <\/span>Virtual Machine Additions Services …
Running  <\/span>AeLookupSvc        <\/span>Application Experience
Stopped  <\/span>AeLookupSvc        <\/span>Application Experience
Stopped  <\/span>ALG                <\/span>Application Layer Gateway Service
Stopped  <\/span>ALG                <\/span>Application Layer Gateway Service
Stopped  <\/span>Appinfo            <\/span>Application Information
Stopped  <\/span>Appinfo            <\/span>Application Information
Stopped  <\/span>AppMgmt            <\/span>Application Management
Stopped  <\/span>AppMgmt            <\/span>Application Management
Stopped  <\/span>AudioEndpointBu… Windows Audio Endpoint Builder
Stopped  <\/span>AudioEndpointBu… Windows Audio Endpoint Builder
Stopped  <\/span>Audiosrv           <\/span>Windows Audio
Stopped  <\/span>Audiosrv           <\/span>Windows Audio
Running  <\/span>BFE                <\/span>Base Filtering Engine
Running  <\/span>BFE                <\/span>Base Filtering Engine
Running  <\/span>BITS               <\/span>Background Intelligent Transfer Ser…
Stopped  <\/span>BITS               <\/span>Background Intelligent Transfer Ser…
Stopped  <\/span>Browser            <\/span>Computer Browser
Running  <\/span>Browser            <\/span>Computer Browser
>>> Results trimmed >>><\/span><\/span><\/p>\n

 <\/span><\/p>\n

You can see from the results of the Get-Service<\/b> command that the AeLookupSvc<\/b> is running on the first computer, and stopped on the second computer. To check this, it is simple to use the Get-Service<\/b> cmdlet to connect to each of the computers, and to check the status of the service.<\/span><\/p>\n

PS C:\\> Get-Service -Name AeLookupSvc -computer vista<\/p>\n

Status   <\/span>Name               <\/span>DisplayName
——   <\/span>—-         <\/span>      <\/span>———–
Stopped  <\/span>AeLookupSvc        <\/span>Application Experience<\/p>\n

PS C:\\> Get-Service -Name AeLookupSvc -computer Berlin<\/p>\n

Status   <\/span>Name               <\/span>DisplayName
——   <\/span>—-               <\/span>———–
Running  <\/span>AeLookupSvc        <\/span>Application Experience<\/span><\/span><\/p>\n

 <\/span><\/p>\n

You might think that the first instance of the service name belongs to the computer that is listed first. As you can see, the AeLookupSvc<\/b> is running on Berlin, but is stopped on Vista. This is the same order that is seen in the original output. However, the Vista computer was listed first in the fan out command. Perhaps this means that the second computer results are listed first, and the first computer results are listed second—a Last In First Out (LIFO) operation. Before assuming such to be the case, you have to check another service. In the output from the original fan out command, the Bits<\/b> service was listed first as running, and second as stopped. To see the status of the Bits<\/b> service on Berlin and on Vista, you can use the following two commands. <\/span><\/p>\n

PS C:\\> Get-Service -Name Bits -computer berlin<\/p>\n

Status   <\/span>Name               <\/span>DisplayName
——   <\/span>—-               <\/span>———–
Stopped  <\/span>BITS               <\/span>Background Intelligent Transfer Ser…<\/p>\n

PS C:\\> Get-Service -Name Bits -computer Vista<\/p>\n

Status   <\/span>Name            <\/span>   <\/span>DisplayName
——   <\/span>—-               <\/span>———–
Running  <\/span>BITS               <\/span>Background Intelligent Transfer Ser…<\/span><\/span><\/p>\n

 <\/span><\/p>\n

You can see that the Bits<\/b> service is stopped on Berlin, and is running on Vista. The results of using Get-Service<\/b> as a fan out command by supplying an array of computer names to the computername<\/i> parameter brings back interesting results, but results that are meaningless when it comes to checking the exact status of a service on a remote computer. As a best practice, you should pipeline the results of the fan out command to a Format-Table<\/b> cmdlet and choose the machineName<\/b> property. The value of displayName<\/b> property is the same value that is seen in the Services MMC in the name column. The command and a truncated output are shown here. <\/span><\/p>\n

PS C:\\> Get-Service -ComputerName berlin,vista | format-table name, status, mach
inename, displayName -AutoSize<\/p>\n

Name                            <\/span>Status MachineName DisplayName
—-                            <\/span>—— ———– ———–
1-vmsrvc           <\/span>            <\/span>Running vista       <\/span>Virtual Machine Additions…
1-vmsrvc                       <\/span>Running berlin      <\/span>Virtual Machine Additions…
AeLookupSvc                    <\/span>Running berlin      <\/span>Application Experience
AeLookupSvc                    <\/span>Stopped vista       <\/span>Application Experience
ALG                            <\/span>Stopped berlin      <\/span>Application Layer Gateway…
ALG                            <\/span>Stopped vista       <\/span>Application Layer Gateway…
Appinfo                        <\/span>Stopped berlin      <\/span>Application Information
Appinfo                        <\/span>Stopped vista       <\/span>Application Information
AppMgmt                        <\/span>Stopped vista       <\/span>Application Management
AppMgmt                        <\/span>Stopped berlin      <\/span>Application Management
AudioEndpointBuilder           <\/span>Stopped berlin      <\/span>Windows Audio Endpoint Bu…
AudioEndpointBuilder           <\/span>Stopped vista       <\/span>Windows Audio Endpoint Bu…
Audiosrv                       <\/span>Stopped berlin      <\/span>Windows Audio
Audiosrv                       <\/span>Stopped vista       <\/span>Windows Audio
BFE                            <\/span>Running vista       <\/span>Base Filtering Engine
BFE                            <\/span>Running berlin      <\/span>Base Filtering Engine
BITS                           <\/span>Stopped berlin      <\/span>Background Intelligent Tr…
BITS             <\/span>              <\/span>Running vista       <\/span>Background Intelligent Tr…
Browser                        <\/span>Running vista       <\/span>Computer Browser
Browser                        <\/span>Stopped berlin      <\/span>Computer Browser<\/span><\/span><\/p>\n

 <\/span><\/p>\n

Because the value of the displayName<\/b> property is frequently quite long, it does not always easily fit within the confines of an 80 column display. If you have it selected early in the order of the properties to be selected by the Format-Table<\/b> cmdlet, you will probably end up with several columns not being displayed. This is shown here. <\/span><\/p>\n

PS C:\\> Get-Service -ComputerName berlin,vista | format-table name, displayname,
 <\/span>status, machinename -AutoSize<\/p>\n

WARNING: 2 columns do not fit into the display and were removed.<\/p>\n

Name                           <\/span>DisplayName
—-   <\/span>                        <\/span>———–
1-vmsrvc                       <\/span>Virtual Machine Additions Services Application
1-vmsrvc                       <\/span>Virtual Machine Additions Services Application
AeLookupSvc                    <\/span>Application Experience
AeLookupSvc                    <\/span>Application Experience<\/span><\/span><\/p>\n

 <\/span><\/p>\n

As you can see, this defeats the purpose of choosing the machineName<\/b> property in the first place, if it is left off because it does not fit on the display. To correct this potential problem, it is a best practice to always select the property that uses the longest values to be displayed for the last position in the command. In this way, you allow Windows PowerShell to truncate the property value rather than filling up the screen with information, you could easily infer from a truncated display. <\/span><\/p>\n

The other solution to the problem of the shrinking display output would be not to use the autosize<\/i> parameter of the Format-Table<\/b> cmdlet. You could use the wrap<\/i> parameter instead. When this parameter is used, single line entries are allowed to wrap and to form multiple lines. Depending on the information that you are looking for, this output can be either helpful, or annoying. Here is an example of using the wrap parameter. <\/span><\/p>\n

PS C:\\> Get-Service -ComputerName berlin,vista | format-table name, displayname,
 <\/span>status, machinename -Wrap<\/p>\n

Name                <\/span>DisplayName                      <\/span>Status MachineName
—-                <\/span>———–                      <\/span>—— ———–
1-vmsrvc            <\/span>Virtual Machine Add             <\/span>Running vista
                    <\/span>itions Services App
                    <\/span>lication
1-vmsrvc            <\/span>Virtual Machine Add             <\/span>Running berlin
                    <\/span>itions Services App
                    <\/span>lication
AeLookupSvc         <\/span>Application Experie          <\/span>   <\/span>Running berlin
                    <\/span>nce
AeLookupSvc         <\/span>Application Experie             <\/span>Stopped vista
                    <\/span>nce<\/span><\/span><\/p>\n

 <\/span><\/p>\n

At this point in the discussion, you may be thinking that you can really resolve this problem of the truncated display output by using both the autosize<\/i> and the wrap<\/i> parameters. This would enable the output to maximize the display real estate (the function of autosize<\/i>) and also to allow for multiline wrapping (the function of wrap). This never works, but does not generate an error. Windows PowerShell will give priority to the autosize<\/i> parameter and ignore the wrap parameter. It does not matter in which order the two parameters are typed; the wrap<\/i> parameter will be ignored. <\/span><\/p>\n

SW, that is all there is to importing and exporting Windows PowerShell command history. To Script or Not to Script week will continue tomorrow when I will talk about how to work with Active Directory Domain Services. <\/span><\/p>\n

I invite you to follow me on <\/span>Twitter<\/span><\/span><\/a> or <\/span>Facebook<\/span><\/span><\/a>. If you have any questions, send email to me at <\/span>scripter@microsoft.com<\/span><\/span><\/a> or post them on the <\/span>Official Scripting Guys Forum<\/span><\/span><\/a>. See you tomorrow. Until then, peace.<\/span><\/p>\n

 <\/span><\/p>\n

Ed Wilson, Microsoft Scripting Guy<\/span><\/b><\/p>\n","protected":false},"excerpt":{"rendered":"

  Summary: Learn how to use Windows PowerShell to import and to export command history and avoid writing scripts.   Hey, Scripting Guy! I have worked with other systems where I was able to keep track of the commands that I typed into the console. The neat thing about that was that I could export […]<\/p>\n","protected":false},"author":595,"featured_media":87096,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[51,3,4,45],"class_list":["post-16361","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-scripting","tag-getting-started","tag-scripting-guy","tag-scripting-techniques","tag-windows-powershell"],"acf":[],"blog_post_summary":"

  Summary: Learn how to use Windows PowerShell to import and to export command history and avoid writing scripts.   Hey, Scripting Guy! I have worked with other systems where I was able to keep track of the commands that I typed into the console. The neat thing about that was that I could export […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/16361","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/users\/595"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/comments?post=16361"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/16361\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media\/87096"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media?parent=16361"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/categories?post=16361"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/tags?post=16361"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}