Common Powershell Commands

get-service

Get-Help
Get-Help -Name Get-*
Get-Command –Name *IP*
Set-ExecutionPolicy
Get-ExecutionPolicy
Get-Service
ConvertTo-HTML
Export-CSV
Get-Service | Export-CSV c:\service.csv
Select-Object
Get-Service | Select-Object Name, Status | Export-CSV c:\service.csv
Get-EventLog
Get-Process
Stop-Process
gwmi Win32_USBControllerDevice
Get-Process | Where-Object {$_.Name –eq “iexplore”}

Top 10 Cmdlets to Start Using Immediately
Get-Command retrieves a list of all available cmdlets.
Get-Help displays help information about cmdlets and concepts.
Get-WMIObject retrieves management information by using WMI.
Get-EventLog retrieves Windows event logs.
Get-Process retrieves a single or list of active processes.
Get-Service retrieves a Windows service.
Get-Content reads in text files, treating each line as a child object.
Add-Content appends content to a text file.
Copy-Item copies files, folders, and other objects.
Get-Acl retrieves access control lists (ACLs).

Command alias

Cmdlet name

Description of command

%

ForEach-Object

Performs an operation against each item in a collection of input objects.

?

Where-Object

Selects objects from a collection based on their property values.

ac

Add-Content

Appends content, such as words or data, to a file.

asnp

Add-PSSnapIn

Adds one or more Windows PowerShell snap-ins to the current session.

cat

Get-Content

Gets the contents of a file.

cd

Set-Location

Sets the current working location to a specified location.

chdir

Set-Location

Sets the current working location to a specified location.

clc

Clear-Content

Deletes the contents of an item, but does not delete the item.

clear

Clear-Host

Clears the display in the host program.

clhy

Clear-History

Deletes entries from the command history.

cli

Clear-Item

Deletes the contents of an item, but does not delete the item.

clp

Clear-ItemProperty

Deletes the value of a property but does not delete the property.

cls

Clear-Host

Clears the display in the host program.

clv

Clear-Variable

Deletes the value of a variable.

cnsn

Connect-PSSession

Reconnects to disconnected sessions

compare

Compare-Object

Compares two sets of objects.

copy

Copy-Item

Copies an item from one location to another.

cp

Copy-Item

Copies an item from one location to another.

cpi

Copy-Item

Copies an item from one location to another.

cpp

Copy-ItemProperty

Copies a property and value from a specified location to another location.

curl

Invoke-WebRequest

Gets content from a webpage on the Internet.

cvpa

Convert-Path

Converts a path from a Windows PowerShell path to a Windows PowerShell provider path.

dbp

Disable-PSBreakpoint

Disables the breakpoints in the current console.

del

Remove-Item

Deletes files and folders.

diff

Compare-Object

Compares two sets of objects.

dir

Get-ChildItem

Gets the files and folders in a file system drive.

dnsn

Disconnect-PSSession

Disconnects from a session.

ebp

Enable-PSBreakpoint

Enables the breakpoints in the current console.

echo

Write-Output

Sends the specified objects to the next command in the pipeline. If the command is the last command in the pipeline, the objects are displayed in the console.

epal

Export-Alias

Exports information about currently defined aliases to a file.

epcsv

Export-Csv

Converts objects into a series of comma-separated (CSV) strings and saves the strings in a CSV file.

epsn

Export-PSSession

Imports commands from another session and saves them in a Windows PowerShell module.

erase

Remove-Item

Deletes files and folders.

etsn

Enter-PSSession

Starts an interactive session with a remote computer.

exsn

Exit-PSSession

Ends an interactive session with a remote computer.

fc

Format-Custom

Uses a customized view to format the output.

fl

Format-List

Formats the output as a list of properties in which each property appears on a new line.

foreach

ForEach-Object

Performs an operation against each item in a collection of input objects.

ft

Format-Table

Formats the output as a table.

fw

Format-Wide

Formats objects as a wide table that displays only one property of each object.

gal

Get-Alias

Gets the aliases for the current session.

gbp

Get-PSBreakpoint

Gets the breakpoints that are set in the current session.

gc

Get-Content

Gets the contents of a file.

gci

Get-ChildItem

Gets the files and folders in a file system drive.

gcm

Get-Command

Gets all commands.

gcs

Get-PSCallStack

Displays the current call stack.

gdr

Get-PSDrive

Gets drives in the current session.

ghy

Get-History

Gets a list of the commands entered during the current session.

gi

Get-Item

Gets files and folders.

gjb

Get-Job

Gets Windows PowerShell background jobs that are running in the current session.

gl

Get-Location

Gets information about the current working location or a location stack.

gm

Get-Member

Gets the properties and methods of objects.

gmo

Get-Module

Gets the modules that have been imported or that can be imported into the current session.

gp

Get-ItemProperty

Gets the properties of a specified item.

gps

Get-Process

Gets the processes that are running on the local computer or a remote computer.

group

Group-Object

Groups objects that contain the same value for specified properties.

gsn

Get-PSSession

Gets the Windows PowerShell sessions on local and remote computers.

gsnp

Get-PSSnapIn

Gets the Windows PowerShell snap-ins on the computer.

gsv

Get-Service

Gets the services on a local or remote computer.

gu

Get-Unique

Returns unique items from a sorted list.

gv

Get-Variable

Gets the variables in the current console.

gwmi

Get-WmiObject

Gets instances of Windows Management Instrumentation (WMI) classes or information about the available classes.

h

Get-History

Gets a list of the commands entered during the current session.

history

Get-History

Gets a list of the commands entered during the current session.

icm

Invoke-Command

Runs commands on local and remote computers.

iex

Invoke-Expression

Runs commands or expressions on the local computer.

ihy

Invoke-History

Runs commands from the session history.

ii

Invoke-Item

Performs the default action on the specified item.

ipal

Import-Alias

Imports an alias list from a file.

ipcsv

Import-Csv

Creates table-like custom objects from the items in a CSV file.

ipmo

Import-Module

Adds modules to the current session.

ipsn

Import-PSSession

Imports commands from another session into the current session.

irm

Invoke-RestMethod

Sends an HTTP or HTTPS request to a RESTful web service.

ise

powershell_ise.exe

Explains how to use the PowerShell_ISE.exe command-line tool.

iwmi

Invoke-WMIMethod

Calls Windows Management Instrumentation (WMI) methods.

iwr

Invoke-WebRequest

Gets content from a web page on the Internet.

kill

Stop-Process

Stops one or more running processes.

lp

Out-Printer

Sends output to a printer.

ls

Get-ChildItem

Gets the files and folders in a file system drive.

man

help

Displays information about Windows PowerShell commands and concepts.

md

mkdir

Creates a new item.

measure

Measure-Object

Calculates the numeric properties of objects, and the characters, words, and lines in string objects, such as files of text.

mi

Move-Item

Moves an item from one location to another.

mount

New-PSDrive

Creates temporary and persistent mapped network drives.

move

Move-Item

Moves an item from one location to another.

mp

Move-ItemProperty

Moves a property from one location to another.

mv

Move-Item

Moves an item from one location to another.

nal

New-Alias

Creates a new alias.

ndr

New-PSDrive

Creates temporary and persistent mapped network drives.

ni

New-Item

Creates a new item.

nmo

New-Module

Creates a new dynamic module that exists only in memory.

npssc

New-PSSessionConfigurationFile

Creates a file that defines a session configuration.

nsn

New-PSSession

Creates a persistent connection to a local or remote computer.

nv

New-Variable

Creates a new variable.

ogv

Out-GridView

Sends output to an interactive table in a separate window.

oh

Out-Host

Sends output to the command line.

popd

Pop-Location

Changes the current location to the location most recently pushed to the stack. You can pop the location from the default stack or from a stack that you create by using the Push-Location cmdlet.

ps

Get-Process

Gets the processes that are running on the local computer or a remote computer.

pushd

Push-Location

Adds the current location to the top of a location stack.

pwd

Get-Location

Gets information about the current working location or a location stack.

r

Invoke-History

Runs commands from the session history.

rbp

Remove-PSBreakpoint

Deletes breakpoints from the current console.

rcjb

Receive-Job

Gets the results of the Windows PowerShell background jobs in the current session.

rcsn

Receive-PSSession

Gets results of commands in disconnected sessions.

rd

Remove-Item

Deletes files and folders.

rdr

Remove-PSDrive

Deletes temporary Windows PowerShell drives and disconnects mapped network drives.

ren

Rename-Item

Renames an item in a Windows PowerShell provider namespace.

ri

Remove-Item

Deletes files and folders.

rjb

Remove-Job

Deletes a Windows PowerShell background job.

rm

Remove-Item

Deletes files and folders.

rmdir

Remove-Item

Deletes files and folders.

rmo

Remove-Module

Removes modules from the current session.

rni

Rename-Item

Renames an item in a Windows PowerShell provider namespace.

rnp

Rename-ItemProperty

Renames a property of an item.

rp

Remove-ItemProperty

Deletes the property and its value from an item.

rsn

Remove-PSSession

Closes one or more Windows PowerShell sessions (PSSessions).

rsnp

Remove-PSSnapin

Removes Windows PowerShell snap-ins from the current session.

rujb

Resume-Job

Restarts a suspended job

rv

Remove-Variable

Deletes a variable and its value.

rvpa

Resolve-Path

Resolves the wildcard characters in a path, and displays the path contents.

rwmi

Remove-WMIObject

Deletes an instance of an existing Windows Management Instrumentation (WMI) class.

sajb

Start-Job

Starts a Windows PowerShell background job.

sal

Set-Alias

Creates or changes an alias (alternate name) for a cmdlet or other command element in the current Windows PowerShell session.

saps

Start-Process

Starts one or more processes on the local computer.

sasv

Start-Service

Starts one or more stopped services.

sbp

Set-PSBreakpoint

Sets a breakpoint on a line, command, or variable.

sc

Set-Content

Replaces the contents of a file with contents that you specify.

select

Select-Object

Selects objects or object properties.

set

Set-Variable

Sets the value of a variable. Creates the variable if one with the requested name does not exist.

shcm

Show-Command

Creates Windows PowerShell commands in a graphical command window.

si

Set-Item

Changes the value of an item to the value specified in the command.

sl

Set-Location

Sets the current working location to a specified location.

sleep

Start-Sleep

Suspends the activity in a script or session for the specified period of time.

sls

Select-String

Finds text in strings and files.

sort

Sort-Object

Sorts objects by property values.

sp

Set-ItemProperty

Creates or changes the value of a property of an item.

spjb

Stop-Job

Stops a Windows PowerShell background job.

spps

Stop-Process

Stops one or more running processes.

spsv

Stop-Service

Stops one or more running services.

start

Start-Process

Starts one or more processes on the local computer.

sujb

Suspend-Job

Temporarily stops workflow jobs.

sv

Set-Variable

Sets the value of a variable. Creates the variable if one with the requested name does not exist.

swmi

Set-WMIInstance

Creates or updates an instance of an existing Windows Management Instrumentation (WMI) class.

tee

Tee-Object

Saves command output in a file or variable and sends it down the pipeline.

trcm

Trace-Command

Configures and starts a trace of the specified expression or command.

type

Get-Content

Gets the contents of a file.

wget

Invoke-WebRequest

Gets content from a webpage on the Internet.

where

Where-Object

Selects objects from a collection based on their property values.

wjb

Wait-Job

Suppresses the command prompt until one or all of the Windows PowerShell background jobs running in the session are complete.

write

Write-Output

Sends the specified objects to the next command in the pipeline. If the command is the last command in the pipeline, the objects are displayed in the console.

Turn on PHP error reporting

To display error messages caused by your PHP script you can include these lines of code:

ini_set('display_errors',1); 
 error_reporting(E_ALL);

Another way to do it is to edit your php.ini file and include this option:

error_reporting = E_ALL

To turn error reporting off for a single document, include this line:

error_reporting(0);
Posted in PHP

Time and Date w. Linux

View Time
To view the current date and time, the following command will be enough

date

Set Time
To change time means to set a new time. To set time in Ubuntu (or any Linux), just run the following command
sudo date newdatetimestring where newdatetimestring has to follow the format nnddhhmmyyyy.ss which is described below:

  • nn is a two digit month, between 01 to 12
  • dd is a two digit day, between 01 and 31, with the regular rules for days according to month and year applying
  • hh is two digit hour, using the 24-hour period so it is between 00 and 23
  • mm is two digit minute, between 00 and 59
  • yyyy is the year; it can be two digit or four digit: your choice. I prefer to use four digit years whenever I can for better clarity and less confusion
  • ss is two digit seconds. Notice the period ‘.’ before the ss.

Let’s say you want to set your computer’s new time to December 6, 2007, 22:43:55, then you would use:

sudo date 120622432007.55

MySQL Date Math

SELECT DATE_SUB(CURDATE(), INTERVAL 30 DAY);
SELECT DATE_SUB(CURDATE(), INTERVAL 1 MONTH)
SELECT DATE_SUB(CURDATE(), INTERVAL 3 MONTH)
SELECT DATE_SUB(CURDATE(), INTERVAL 6 MONTH)
SELECT DATE_SUB(CURDATE(), INTERVAL 12 MONTH)
SELECT DATE_SUB(CURDATE(), INTERVAL 18 MONTH)

SELECT DATE_SUB(CURDATE(), INTERVAL 24 MONTH)
SELECT DATE_SUB(CURDATE(), INTERVAL 10 YEAR)
SELECT DATE_SUB(CURDATE(), INTERVAL 100 YEAR)

1997-11-01

SELECT COUNT( `WB1` ) FROM `PB` WHERE `WB1` =  15 and `DDate` >= DATE_SUB(CURDATE(), INTERVAL 10 MONTH)



CURDATE()
  • Returns the current date as a value in 'YYYY-MM-DD' or YYYYMMDD format, depending on whether the function is used in a string or numeric context.
    mysql> SELECT CURDATE();
            -> '2008-06-13'
    mysql> SELECT CURDATE() + 0;
            -> 20080613

How To Create a SSL Certificate on Apache for Ubuntu 14.04

https://www.digitalocean.com/community/articles/how-to-create-a-ssl-certificate-on-apache-for-ubuntu-14-04

How To Create a SSL Certificate on Apache for Ubuntu 14.04
ntroduction

TLS, or transport layer security, and its predecessor SSL, secure sockets layer, are secure protocols created in order to place normal traffic in a protected, encrypted wrapper.

These protocols allow traffic to be sent safely between remote parties without the possibility of the traffic being intercepted and read by someone in the middle. They are also instrumental in validating the identity of domains and servers throughout the internet by establishing a server as trusted and genuine by a certificate authority.

In this guide, we’ll cover how to create a self-signed SSL certificate for Apache on an Ubuntu 14.04 server, which will allow you to encrypt traffic to your server. While this does not provide the benefit of third party validation of your server’s identity, it fulfills the requirements of those simply wanting to transfer information securely.
Prerequisites

Before you begin, you should have some configuration already taken care of.

We will be operating as a non-root user with sudo privileges in this guide. You can set one up by following steps 1-4 in our Ubuntu 14.04 initial server setup guide.

You are also going to need to have Apache installed. If you don’t already have that up and running, you can quickly fix that by typing:
sudo apt-get update
sudo apt-get install apache2
Step One — Activate the SSL Module

SSL support actually comes standard in the Ubuntu 14.04 Apache package. We simply need to enable it to take advantage of SSL on our system.

Enable the module by typing:
sudo a2enmod ssl

After you have enabled SSL, you’ll have to restart the web server for the change to be recognized:
sudo service apache2 restart

With that, our web server is now able to handle SSL if we configure it to do so.
Step Two — Create a Self-Signed SSL Certificate

Let’s start off by creating a subdirectory within Apache’s configuration hierarchy to place the certificate files that we will be making:
sudo mkdir /etc/apache2/ssl

Now that we have a location to place our key and certificate, we can create them both in one step by typing:
sudo openssl req -x509 -nodes -days 365 -newkey rsa:2048 -keyout /etc/apache2/ssl/apache.key -out /etc/apache2/ssl/apache.crt

Let’s go over exactly what this means.
openssl: This is the basic command line tool provided by OpenSSL to create and manage certificates, keys, signing requests, etc.
req: This specifies a subcommand for X.509 certificate signing request (CSR) management. X.509 is a public key infrastructure standard that SSL adheres to for its key and certificate managment. Since we are wanting to create a new X.509 certificate, this is what we want.
-x509: This option specifies that we want to make a self-signed certificate file instead of generating a certificate request.
-nodes: This option tells OpenSSL that we do not wish to secure our key file with a passphrase. Having a password protected key file would get in the way of Apache starting automatically as we would have to enter the password every time the service restarts.
-days 365: This specifies that the certificate we are creating will be valid for one year.
-newkey rsa:2048: This option will create the certificate request and a new private key at the same time. This is necessary since we didn’t create a private key in advance. The rsa:2048 tells OpenSSL to generate an RSA key that is 2048 bits long.
-keyout: This parameter names the output file for the private key file that is being created.
-out: This option names the output file for the certificate that we are generating.

When you hit “ENTER”, you will be asked a number of questions.

The most important item that is requested is the line that reads “Common Name (e.g. server FQDN or YOUR name)”. You should enter the domain name you want to associate with the certificate, or the server’s public IP address if you do not have a domain name.

The questions portion looks something like this:
Country Name (2 letter code) [AU]:US
State or Province Name (full name) [Some-State]:New York
Locality Name (eg, city) []:New York City
Organization Name (eg, company) [Internet Widgits Pty Ltd]:Your Company
Organizational Unit Name (eg, section) []:Department of Kittens
Common Name (e.g. server FQDN or YOUR name) []:your_domain.com
Email Address []:your_email@domain.com

The key and certificate will be created and placed in your /etc/apache2/ssl directory.
Step Three — Configure Apache to Use SSL

Now that we have our certificate and key available, we can configure Apache to use these files in a virtual host file. You can learn more about how to set up Apache virtual hosts here.

Instead of basing our configuration file off of the 000-default.conf file in the sites-available subdirectory, we’re going to base this configuration on the default-ssl.conf file that contains some default SSL configuration.

Open the file with root privileges now:
sudo nano /etc/apache2/sites-available/default-ssl.conf

With the comments removed, the file looks something like this:
<IfModule mod_ssl.c>
<VirtualHost _default_:443>
ServerAdmin webmaster@localhost
DocumentRoot /var/www/html
ErrorLog ${APACHE_LOG_DIR}/error.log
CustomLog ${APACHE_LOG_DIR}/access.log combined
SSLEngine on
SSLCertificateFile /etc/ssl/certs/ssl-cert-snakeoil.pem
SSLCertificateKeyFile /etc/ssl/private/ssl-cert-snakeoil.key
<FilesMatch “\.(cgi|shtml|phtml|php)$”>
SSLOptions +StdEnvVars
</FilesMatch>
<Directory /usr/lib/cgi-bin>
SSLOptions +StdEnvVars
</Directory>
BrowserMatch “MSIE [2-6]” \
nokeepalive ssl-unclean-shutdown \
downgrade-1.0 force-response-1.0
BrowserMatch “MSIE [17-9]” ssl-unclean-shutdown
</VirtualHost>
</IfModule>

This may look a bit complicated, but luckily, we don’t need to worry about most of the options here.

We want to set the normal things we’d configure for a virtual host (ServerAdmin, ServerName, ServerAlias, DocumentRoot, etc.) as well as change the location where Apache looks for the SSL certificate and key.

In the end, it will look something like this. The entries in red were modified from the original file:
<IfModule mod_ssl.c>
<VirtualHost _default_:443>
ServerAdmin admin@example.com
ServerName your_domain.com
ServerAlias www.your_domain.com
DocumentRoot /var/www/html
ErrorLog ${APACHE_LOG_DIR}/error.log
CustomLog ${APACHE_LOG_DIR}/access.log combined
SSLEngine on
SSLCertificateFile /etc/apache2/ssl/apache.crt
SSLCertificateKeyFile /etc/apache2/ssl/apache.key
<FilesMatch “\.(cgi|shtml|phtml|php)$”>
SSLOptions +StdEnvVars
</FilesMatch>
<Directory /usr/lib/cgi-bin>
SSLOptions +StdEnvVars
</Directory>
BrowserMatch “MSIE [2-6]” \
nokeepalive ssl-unclean-shutdown \
downgrade-1.0 force-response-1.0
BrowserMatch “MSIE [17-9]” ssl-unclean-shutdown
</VirtualHost>
</IfModule>

Save and exit the file when you are finished.
Step Four — Activate the SSL Virtual Host

Now that we have configured our SSL-enabled virtual host, we need to enable it.

We can do this by typing:
sudo a2ensite default-ssl.conf

We then need to restart Apache to load our new virtual host file:
sudo service apache2 restart

This should enable your new virtual host, which will serve encrypted content using the SSL certificate you created.
Step Five — Test your Setup

Now that you have everything prepared, you can test your configuration by visiting your server’s domain name or public IP address after specifying the https:// protocol, like this:
https://server_domain_name_or_IP

You will get a warning that your browser cannot verify the identity of your server because it has not been signed by one of the certificate authorities that it trusts.

This is expected since we have self-signed our certificate. While our certificate will not validate our server for our users because it has had no interaction with a trusted certificate authority, it will still be able to encrypt communication.

Since this is expected, you can hit the “Proceed anyway” button or whatever similar option you have in your browser.

You will now be taken to content in the DocumentRoot that you configured for your SSL virtual host. This time your traffic is encrypted. You can check this by clicking on the lock icon in the menu bar:

You can see in the middle green section that the connection is encrypted.
Conclusion

You should now have SSL enabled on your website. This will help to secure communication between visitors and your site, but it will warn each user that the browser cannot verify the validity of the certificate.

If you are planning on launching a public site and need SSL, you will be better off purchasing an SSL certificate from a trusted certificate authority.

If you want to learn more about how to configure Apache, click here. Check out this link for more ideas on how to secure your Linux server.
By Justin Ellingwood

 

Test the SMTP Service

From http://support.microsoft.com/kb/323350

To test the SMTP service, follow these steps:

  1. On a computer running Windows Server 2003, type Telnet at a command prompt, and then press ENTER.
  2. At the telnet prompt, type set LocalEcho, press ENTER, and then type open <machinename> 25, and then press ENTER.The output resembles the following:
    220 computername.microsoft.com ESMTP Server (Microsoft Exchange Internet Mail Service 5.5.2651.58) ready
    
  3. Type helo me, and then press ENTER.The output resembles the following:
    250 OK
    
  4. Type mail from:email@domain.com, and then press ENTER.The output resembles the following:
    250 OK - mail from <email@domain.com>
    
  5. Type rcpt to:youremail@yourdomain.com, and then press ENTER.The output resembles the following:
    250 OK - Recipient <youremail@yourdomain.com>
    
  6. Type Data, and then press ENTER.The output resembles the following:
    354 Send data.  End with CRLF.CRLF
    
  7. Type Subject:This is a test, and then press ENTER two times.
  8. Type Testing, and then press ENTER.
  9. Press ENTER, type a period (.), and then press ENTER.The output resembles the following:
    250 OK
    
  10. Type quit, and then press ENTER.

    The output resembles the following:

    221 Closing Port / Mail queued for delivery
    

Excel – Protect cell formats

Text from http://excelhints.com/2008/10/21/protect-cell-formats/

Format the Sheet

The first thing you want to do is go ahead and format the sheet they way you want it to look.  Add borders, cell shading, bold, italics, anything.  Once you finish this walkthrough, you won’t have to worry about setting it again.

Unlock the Cells
Excel provides an easy way to unlock your cells for editing.

  1. Select all the cells you want users to be able to edit.
  2. Right click and select Format Cells from the right-click menu.
  3. Click on the last tab, “Protection” and uncheck the “Locked” checkbox (it is checked by default.

You cells are now unlocked and you are ready to protect your sheet.

Protect the Sheet
Protecting the sheet can be done in one easy step.  From the main menu, select Tools–>Protection–>Protect Sheet.  If you want the default settings without a password, just hit OK and your formatting is now protected while still being able to change the cells contents.

You’ll notice however there are many other options available for you to choose.  Check the options you want the user to be able to do (You’ll notice “Format Cells” is unchecked by default).

  • Select locked cells (Default: Checked)
  • Select unlocked Cells (Default: Checked)
  • Format Cells (Default: Unchecked)
  • Format Columns (Default: Unchecked)
  • Format Rows (Default: Unchecked)
  • Insert Columns (Default: Unchecked)
  • Insert Rows (Default: Unchecked)
  • Insert Hyperlinks (Default: Unchecked)
  • Delete Columns (Default: Unchecked)
  • Delete Rows (Default: Unchecked)
  • Sort (Default: Unchecked)
  • Use AutoFilter (Default: Unchecked)
  • Use PivotTable report (Default: Unchecked)
  • Edit Objects (Default: Unchecked)
  • Edit Scenarios (Default: Unchecked)

The only other decision left to make is whether you want password protection on the sheet as well.  If you don’t put a password on the sheet protection, any user can turn it off the exact way you turned it on.

CSS Font-Family

Serif Fonts
~~~~~~~~~~
Georgia, serif
“Palatino Linotype”, “Book Antiqua”, Palatino, serif
“Times New Roman”, Times, serif

Sans-Serif Fonts
~~~~~~~~~~~~~~
Arial, Helvetica, sans-serif
“Arial Black”, Gadget, sans-serif
“Comic Sans MS”, cursive, sans-serif
Impact, Charcoal, sans-serif
“Lucida Sans Unicode”, “Lucida Grande”, sans-serif
Tahoma, Geneva, sans-serif
“Trebuchet MS”, Helvetica, sans-serif
Verdana, Geneva, sans-serif

Monospace Fonts
~~~~~~~~~~~~~~~
“Courier New”, Courier, monospace
“Lucida Console”, Monaco, monospace

Run from CMD Prompt

Environment Variable Path
%ALLUSERSPROFILE% C:\ProgramData
%APPDATA% C:\Users\{username}\AppData\Roaming
%COMMONPROGRAMFILES% C:\Program Files\Common Files
%COMMONPROGRAMFILES(x86)% C:\Program Files (x86)\Common Files
%COMSPEC% C:\Windows\System32\cmd.exe
%HOMEDRIVE% C:
%HOMEPATH% C:\Users\{username}
%LOCALAPPDATA% C:\Users\{username}\AppData\Local
%PROGRAMDATA% C:\ProgramData
%PROGRAMFILES% C:\Program Files
%PROGRAMFILES(X86)% C:\Program Files (x86) (only in 64-bit version)
%PUBLIC% C:\Users\Public
%SystemDrive% C:
%SystemRoot% C:\Windows
%TEMP% and %TMP% C:\Users\{username}\AppData\Local\Temp
%USERPROFILE% C:\Users\{username}
%WINDIR% C:\Windows

Run commands

Calc – Calculator
Cfgwiz32 – ISDN Configuration Wizard
Charmap – Character Map
Chkdisk – Repair damaged files
Cleanmgr – Cleans up hard drives
Clipbrd – Windows Clipboard viewer
Cmd – Opens a new Command Window (cmd.exe)
Control – Displays Control Panel
Dcomcnfg – DCOM user security
Debug – Assembly language programming tool
Defrag – Defragmentation tool
Drwatson – Records programs crash & snapshots
Dxdiag – DirectX Diagnostic Utility
Explorer – Windows Explorer
Fontview – Graphical font viewer
Ftp – ftp.exe program
Hostname – Returns Computer’s name
Ipconfig – Displays IP configuration for all network adapters
Jview – Microsoft Command-line Loader for Java classes
MMC – Microsoft Management Console
Msconfig – Configuration to edit startup files
Msinfo32 – Microsoft System Information Utility
Nbtstat – Displays stats and current connections using NetBios over TCP/IP
Netstat – Displays all active network connections
Nslookup – Returns your local DNS server
Odbcad32 – ODBC Data Source Administrator
Ping – Sends data to a specified host/IP
Regedit – registry Editor
Regsvr32 – register/de-register DLL/OCX/ActiveX
Regwiz – Reistration wizard
Sfc /scannow – Sytem File Checker
Sndrec32 – Sound Recorder
Sndvol32 – Volume control for soundcard
Sysedit – Edit system startup files (config.sys, autoexec.bat, win.ini, etc.)
Systeminfo – display various system information in text console
Taskmgr – Task manager
Telnet – Telnet program
Taskkill – kill processes using command line interface
Tskill – reduced version of Taskkill from Windows XP Home
Tracert – Traces and displays all paths required to reach an internet host
Winchat – simple chat program for Windows networks
Winipcfg – Displays IP configuration

Management Consoles

certmgr.msc – Certificate Manager
ciadv.msc – Indexing Service
compmgmt.msc – Computer management
devmgmt.msc – Device Manager
dfrg.msc – Defragment
diskmgmt.msc – Disk Management
fsmgmt.msc – Folder Sharing Management
eventvwr.msc – Event Viewer
gpedit.msc – Group Policy -XP Pro only
iis.msc – Internet Information Services
lusrmgr.msc – Local Users and Groups
mscorcfg.msc – Net configurations
ntmsmgr.msc – Removable Storage
perfmon.msc – Performance Manager
secpol.msc – Local Security Policy
services.msc – System Services
wmimgmt.msc – Windows Management

Shortcuts

access.cpl – Accessibility Options
hdwwiz.cpl – Add New Hardware Wizard
appwiz.cpl – dd/Remove Programs
timedate.cpl – Date and Time Properties
desk.cpl – Display Properties
inetcpl.cpl – Internet Properties
joy.cpl – Joystick Properties
main.cpl keboard – Keyboard Properties
main.cpl – Mouse Properties
ncpa.cpl – Network Connections
ncpl.cpl – Network Properties
telephon.cpl – Phone and Modem options
powercfg.cpl – Power Management
intl.cpl – Regional settings
mmsys.cpl sounds – Sound Properties
mmsys.cpl – Sounds and Audio Device Properties
sysdm.cpl – System Properties
nusrmgr.cpl – User settings
firewall.cpl – Firewall Settings (sp2)
wscui.cpl – Security Center (sp2)

Windows Environment Commands

%ALLUSERSPROFILE% – Open the All User’s Profile
%HomeDrive% – Opens your home drive e.g. C:\
%UserProfile% – Opens you User’s Profile
%temp% Opens – temporary file Folder
%systemroot% – Opens Windows folder

Wupdmgr – Takes you to Microsoft Windows Update