Skip to main content

Posts

Showing posts from January, 2015

PowerShell Test Password complexity

Checking password whether it meets complexity using PowerShell. Tweak or modify the script according to your own standard. This can be used to check password complexity, on Active Directory user password. The only thing it will not check whether the user account is also included on the string. But the script will test the following: - Check if the password is at least 9 characters in length - Check if the password is alphanumeric - Check if the password has upper case and lower case combination - Check if the password has at least 1 special character on it And the script will also display what are the missing characters it needs to meet the password complexity. For example:   if the password does not contain numbers, or it does not contain special characters. The script will display the error/s on what the user needs to do to meet a complex password. Copy and paste the script to PowerShell ISE for testing. Here’s the script: ======

Unable to connect wireless network

 A computer with Windows 8 or Windows 8.1 or even windows 7, is not able to connect to a particular wireless network but is working fine on other wireless network   Then it could be the wireless security type mismatch on the computer and the wireless router. To solved the issue. Go to "Control Panel" Select “Set up a new connection or Network” Then click on "Manually connect to a Wireless Network" See pic below: On the new window, key in the details of the wireless network. If not sure of the details for the wireless network, get the info from the wireless administrator.  Key in:          Network name - network name is the Wireless SSID or the Wireless network name         Security Type - select WPA2-Enterprise, WPA2-Personal or check with the wireless administrator about the security type setup on the wireless router         Encryption Type - select AES or TKIP         Security Key - this will be the wirel

Clear or Remove comments in Excel

Need to clear or remove all comments in a workbook? If time is not a constraint, comments can be deleted manually. To do it manually, is to right click on the cell that has a comment and click "delete comment." It’s not so hard, right? What if there are 10 worksheets, in the workbook and every worksheet has 20 or more comments? Deleting the comments manually, would not be fun. VBA is an ideal way to clear or remove comments the easy and quick way. Here's a simple VBA code to do it. Don't run the code on production, and if the workbook and the comments are quite important. But if you exactly know what you are doing, go ahead. Or save a copy of the workbook and do the test. Once the comments are deleted it cannot be undone. Copy and paste the code to the VBA editor. ================================= Sub Delete_all_comments() 'VBA code below will delete all the comments 'For loop statement

Linux sort output of 'ls' by last modified date

Sorting 'ls' command output in Linux by last modified date. To dig further type: man ls Here's a quick guide on how to sort or display the output by its modified ate. ls -lt command: Last modified date results shown at the top, bottom the oldest files. ls -lt sample output: -rwxrwxrwx 1 root root 1715357811 Jan 16 15:19 My_File_Year_2015Z.3.zip -rwxrwxrwx 1 root root 2131315323 Jan 12 07:36 Another_File_Year_2015Z.zip . . . drwxrwxrwx 1 root root       4096 Mar 11  2013 Extras -rwxrwxrwx 2 root root    4223936 Sep  7  2012 My Apps Setup.exe  - - - - - - ls-ltr command: Newest file or new modified files result shown at the bottom, top results the oldest files. ls-ltr sample output: drwxrwxrwx 1 root root       4096 Mar 11  2013 Extras -rwxrwxrwx 2 root root    4223936 Sep  7  2012 My Apps Setup.exe . . . -rwxrwxrwx 1 root root 1715357811 Jan 16 15:19 My_File_Year_2015z.3.zip -rwxrwxrwx 1 root root 2131315323 Jan 12 07:36 Another_File_Year_20