Skip to content

Instantly share code, notes, and snippets.

ayancey /
Last active Nov 12, 2021
Gets the type of RAM in Windows, with raw SMBIOS data. Works even if Win32_PhysicalMemory.MemoryType is Unknown.
import wmi
import struct
# RAM memory types described in 7.18.2 in SMBIOS Specification
MEMORY_TYPES = {1: 'Other', 2: 'Unknown', 3: 'DRAM', 4: 'EDRAM', 5: 'VRAM', 6: 'SRAM', 7: 'RAM', 8: 'ROM', 9: 'FLASH', 10: 'EEPROM', 11: 'FEPROM', 12: 'EPROM', 13: 'CDRAM', 14: '3DRAM', 15: 'SDRAM', 16: 'SGRAM', 17: 'RDRAM', 18: 'DDR', 19: 'DDR2', 20: 'DDR2 FB-DIMM', 21: 'Reserved', 22: 'Reserved', 23: 'Reserved', 24: 'DDR3', 25: 'FBD2'}
def Get_SMBIOS(w):
SMBIOSTableData = ""
for i in w.query("SELECT * FROM MSSmBios_RawSMBiosTables")[0].SMBiosData:
View RAM Upgrade.vbs
' Purpose: Allows you to easily get the RAM configuration of a computer. LAN Sweeper won't tell you the RAM type, but this utility will. This should be useful for RAM upgrades.
' Requirements: Probably admin in Active Directory
' Written by: Alex Yancey
' Date: September 15, 2016
' More info about SMBIOS can be found in the SMBIOS specification:, and from this article:
computer_name = InputBox("Computer name: ", "RAM Identifier")
View CoffeeMaker.ino
#include <ESP8266WiFi.h>
#include <stdlib.h>
const char* ssid = "MAAQ";
const char* password = "";
WiFiServer server(80);
void setup() {
import ui
import appex
import requests
import json
if appex.is_running_extension():
url = appex.get_url()
url = ''
import records
db = records.Database('mysql://root:a6478a14@')
# Create User table
db.query("""CREATE TABLE `user` (
`first_name` VARCHAR(100) NOT NULL,
`middle_name` VARCHAR(100) NOT NULL,
import records
db = records.Database('mysql://root:a6478a14@')
print('Welcome to the Softbank registration system!')
print('Please tell us the following information...')
first_name = raw_input('First name: ')
middle_name = raw_input('Middle name: ')
last_name = raw_input('Last name: ')
username = first_name.lower()[0] + last_name.lower()
import records
import datetime
db = records.Database('mysql://root:a6478a14@')
print('Welcome to Softbank. Please enter your username and password...')
username = raw_input('Username: ')
password = raw_input('Password: ')
# This SQL library does not immediately run the query and store the results until we tell it to.
View remote_map_drive.vbs
' Purpose: Allows us to remotely map drives without psexec or knowing the user's password
' Requirements: Windows 7 (may support older OSes), Administrator (maybe)
' Written by: Alex Yancey
' Date: December 20, 2016
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objFile = objFSO.CreateTextFile("remotemap.bat")
View external_computer_name.vbs
' Purpose: Allows you to enter the drive letter of an external drive with a copy of Windows on it, returns computer name
' Requirements: Windows 7 (may support older OSes), Administrator (maybe)
' Written by: Alex Yancey
' Date: December 8, 2016
const HKEY_LOCAL_MACHINE = &H80000002
set objshell = CreateObject("")
computer_name = InputBox("OS drive letter: ", "HDD Computer Name")
import os
import time
import datetime
import pickle
import webbrowser
import codecs
import subprocess
import sys
# Quick little function that opens the default web browser and displays the HTML of your choice