willglynn

PCs have SMBIOS data containing small amount of identifying information. One piece of information in this SMBIOS data is the universally unique identifier. Some PC and motherboard manufacturers fail to set this, often leaving the UUID set to 03000200-0400-0500-0006-000700080009.

If your system uses an AMI firmware (sometimes called AMIBIOS), you may be able to use AMI utilities to reset the UUID. Obtain AMIDEEFIx86.efi and an EFI shell executable, such as from inside m1ujt73usa.zip for the Lenovo ThinkStation P330 Tiny download center.

Once you have those two files, create USB drive with the FAT32 filesystem and the following structure:

\
  \AMIDEEFIx86.efi
  \efi

Brainiarc7

silly gist hack, why do we need you? :(

niun

sudo nmap -sP 192.168.0.0/24 | awk '/^Nmap/{ip=$NF}/B8:27:EB/{print ip}'

sergiitk

OS X terminal tips an tricks

Shell tools

System

• sw_vers — Print Mac OS X operating system version information
• system_profiler — Reports system hardware and software configuration.
• system_profiler SPHardwareDataType — Hardware overview.
• hostinfo — Host information.
• nvram -p — Print all of the firmware variables.
• getconf DARWIN_USER_CACHE_DIR — Retrieve standard configuration variables
• /usr/libexec/path_helper — Helper for constructing PATH environment variable

petehamilton

Dashboards

• Team Dashboard - http://fdietz.github.io/team_dashboard/
• Geckoboard - http://www.geckoboard.com/ - Slick data dashboards.
• Leftronic - https://www.leftronic.com/ - Similar, doesn't seem quite as organised looking
• Dashing - http://shopify.github.io/dashing/ - Simple metric dashboards by Shopify. Widget list

Charting

• HighCharts - http://www.highcharts.com/ Not very inspiring but very widely used & performant
• Google Charts - https://developers.google.com/chart/ Again, not very inspiring but can be customised
• Flot - http://www.flotcharts.org/ Gorgeous slick HTML5 graphs

rgreenjr

-- show running queries (pre 9.2)
SELECT procpid, age(clock_timestamp(), query_start), usename, current_query 
FROM pg_stat_activity 
WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%' 
ORDER BY query_start desc;

-- show running queries (9.2)
SELECT pid, age(clock_timestamp(), query_start), usename, query 
FROM pg_stat_activity 
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'