If you need to see when a computer last logged onto your domain, here is a quick command to achieve that using PowerShell Active Directory shell: Get-ADComputer -identity [COMPUTER NAME] -Properties * | FT Name, LastLogonDate To look at all computers in your network. Change the -Identity switch for the -Filter switch: Get-ADComputer -Filter *…
Read more
Partition Assistant – Manage your Space
If you are in need of increasing space on any drive (mainly in regards to servers), I highly recommend this tool: AOMEI Partition Assistant (PA) A great tool that is easy to use and works! Just a few notes: MAKE A BACKUP OF ALL DRIVES BEFORE STARTING! - DO THIS, don't be lazy and regret…
Read more
Microsoft Office 2016, crashing, freezing issues
If you have Microsoft Office 2016 and are having crashing, freezing issues (mainly with Word or Outlook), 99% of the time it's due to not getting Office updates. Especially if you bought the office suite with your computer. UPDATE: If you have ANY other version of Office installed (Ex: Office 2010, 2013, etc.) this is…
Read more
PicNet Table Filter, jQuery Plugin, HTML Table
If you are looking for a quick way to add a jQuery table sorter to any HTML table here you are: PicNet Table Filter, jQuery Plugin, HTML PDF Enjoy.
Read more
Insert data into two tables of different databases on same instance
If both databases reside on the SAME MySQL server (and use the same user and password to connect). You simply establish the connection without picking a database, then put the name of the database in front of the table name like: INSERT INTO myDBname.myTableName (myKey) VALUES (myValue); If you have a connection to one database…
Read more
SSH zip only certain types of files recursively on Linux
If you are looking for a command to run via ssh that ZIPs all files (of a certain type) recursively here you go: 1 - Switch into the website folder, then run zip -R YOURZIPFILENAME '*.php' '*.html' '*.js' '*.css' 2 - You can also run this from outside the website folder: zip -r YOURZIPFILENAME website_folder…
Read more
Windows Installer and Dell Trusted Device Manager Error
If you recently (or whenever) gotten errors in regards to the Dell Trusted Device Manger due to Windows Updates, I have found a fix that might work for you. Here was my problem: I recently upgraded my Windows 10 machine to the latest release (1709 - Creators Update); upon computer restart the Windows Installer would…
Read more
AWS CLOSE_WAIT socket problems!
A buildup of sockets in CLOSE_WAIT state may indicate an application programming error. A CLOSE_WAIT socket is a socket in which the connection has received a FIN and has yet to be closed by the application. In this state, it is the responsibility of the application to close the socket, although the operating system will…
Read more
Excel – Lookup value in column and return value from another column
You can build a lookup that allows you to specify the lookup column and return value column completely independently, and also control of the nature of the approximate match, if not exact. Here is the full function: =INDEX(Return_value_range, MATCH(Lookup_value, Lookup_value_range, Match_type)) Return_value_range – The range that holds the return values Lookup_value – The value you…
Read more
Go Daddy and PHP.ini file.
If you are using GoDaddy and hosting Linux with them, you may be needing to modify the PHP.ini configuration file. The PHP initialization files can manage form, server, and environmental variables as well as server-side cookies, temporary directories, error display, and error logging. First, you need to know how to modify it (or where to…
Read more
Linux Helpful Commands
Here is a list of some helpful Linux commands (all these commands assume you are a ROOT user): Need to search all your files, on your server for a word(s)? grep -r "SEARCH WORDS HERE" . Add on "-l" if you want to return ONLY the file that search word is in. Add on "-i"…
Read more
How to clone a hard drive to a new solid state disk (SSD)
Installing a solid-state drive (SSD) is one of the best upgrades you can make to your computer, but migrating your Windows installation can be tricky, because your data might not all fit on the drive. UPDATE: If you are doing lots of cloning, make it easy and simply buy a offline clone device from Amazon:…
Read more