Philip Flint

www.philipflint.com

Posts Tagged Tips

How to format GPResult

Apr 6

Posted by Philip Flint in IT, Tips | No Comments

You probably know how to run GPResult to see which policies etc are being applied to an end user workstation or server but did you know for Windows 2008 / R2 and Windows 7 there is now an easy way to format those results ? Just run the command below:

GPResult /H GPResult.html

and the results will be held in a html formatted page. Run the command below and it will display the page automatically for you.

GPResult /H GPResult.html & GPResult.html

Tags:

How to duplicate entries in Excel

Nov 2

Posted by Philip Flint in Tips | No Comments

You know how it is. You are filling out an Excel spreadsheet and you need to copy the value above. Now, everyone knows the two ways to do this (copy /paste and to “drag and fill” the data down). Well, I was shown a third way today and thought I’d share it with you.

Simply select the cell where you want the data to be copied into and press CTRL + D (for Duplicate) and that’s it.

Before and After

Tags:

Piping out to the clipboard

Nov 1

Posted by Philip Flint in Tips | No Comments

We all know how to pipe out to text files, right ? From a command prompt type in your command followed by > and then the name of the file to output the result to.
 
For example
 
ipconfig /all > c:\myfiles\ipconfigresults.txt
 
will put the results of ipconfig /all into a text file called ipconfigresults.txt in the myfiles folder and the more advanced ones among us know how to not only pipe the command out but also open that text file automatically after the command has completed.
 
For example
 
ipconfig /all > c:\myfiles\ipconfigresults.txt & c:\myfiles\ipconfigresults.txt
 
Well, that leaves a permanent file on your hard drive which you might or might not want. Plus, if you want the text in another file you have to open the text file as above, select it all and then copy it to the clipboard.
 
Now, you can doo all of that in one go without leaving that pesky file behind – just pipe the command to the clipboard !
 
For example
 
ipconfig /all | clip
 
will put the output of the ipconfig / all command on your clipboard. You can now either paste it into notepad for a temporary file or paste it into any more permanent file, as part of producing customer documentation for example.

Tags: