Skip to main content

Posts

Showing posts from 2018

Change Password of Scheduled Tasks in PowerShell

How to change Tasks Scheduler password?
How to set a new password for scheduled tasks in Windows Task Scheduler using a script?
PowerShell is always a friend to cure laziness in an effective and efficient way.
Of course, not all things can be done by automation. Sometimes manual method is more applicable and a secure method on some scenario.
If you have a few servers that has scheduled tasks on it and need to change the password occasionally to comply with cyber security policies, changing tasks manually might be painful and chances are some tasks might be missed.
Changing the password in Task Scheduler using PowerShell is an efficient method if the task has to be done repeatedly on a few servers.
To change the password, the TaskName must be known since it’s an input or a required field for the command used to change the Task password.
To get Tasks Name use the PowerShell code below:
Get-ScheduleTask - TaskPath "\"| Get-ScheduledTaskInfo
The TaskPath refers to location of the Task Na…

SQL delete value in a column

Deleting a value in a column can be done in multiple ways in SQL, mileage will always vary. If you have been working in SQL for quite some time and you were able to get the pinch of SQL then single liner statements can be done easily.
Deleting a single field or a single value in a column that matches a string or data using SQL is a daunting task, so it's better to practice with a dummy data before executing the statement on a production database or else inadvertent consequences  might happen.
One liner statement below will delete a value that matches the variable in query. Below is a PHP statemen that will delete a value in a column that matches the variable supplied on the statement.
The “.”, dot or period is a concatenation operator for strings in PHP.
"DELETE FROM `Table_Name`WHERE column_name = " . " ' " . $variable_query . " ' ";
Replace Table_Name with the actual table name and the column_name also with the actual column name.
The $variable_qu…

Excel filter option cannot be found

Working in a large data set in Excel but filter option cannot be seen or found even clicking the sort and filter option multiple times, the drop-down filtering options is nowhere to be found.
Well, just get back to the very basic steps. If it can’t be seen then it might be hidden, right?
So, when working in a large data set but some other rows is not needed and need to be hidden. Just leave the first row visible and do not hide it, then hide other rows.
The drop down filter option is in row 1, so if it is hidden then of course the drop down filter will also go with it.
To unhide row 1 or cell a1, press Ctrl + G. The go to options window will pop-up, type: A1 to go to cell A1. (see pic below)


Then, press ctrl+shift+9 to unhide the row. Or click on the format menu options and select unhide. (see pic below for excel 2016). Then the filter option will be displayed.



The keyboard shortcut I think will work on other versions of Excel.
If you need the filter option in Excel, row 1 must never be hid…

Symbolic link in windows 10

Ever heard of symbolic links in Linux? Yes, for Linux guys it’s quite common to hear this terminology. But wait, Windows has it also.
Why would you need symbolic links in Windows? It can be used for what purpose?
Onedrive for business or even a free onedrive application, does not support adding custom folders instead you need to save your files to be synced on the onedrive folders provided by the onedrive application of course. It’s on the path c:\users\onedrive\'Desktop', c:\users\onedrive\'Documents', etc.
So, if you need custom folders to be synced to cloud using onedrive, Mklink command in windows which is used to create symbolic links can help on this scenario by creating a directory junction on the onedrive user folder.
That’s one purpose that I can think of that Mklink command, is quite useful.
At command prompt typing, mklink /? will display how the command can be used. (see image below)



What does the help means in laymen definition?
Let’s try to define it in a much s…

Excel footer or header location

How to insert a header or footer in Excel 2016?
How to insert a custom header or footer in Excel 2016?
To insert a custom header or footer with a picture or other sort of customization, can only be done of course using the custom header or footer option.
The easiest way to find header and footer is clicking on Insert on the main menu and selecting or clicking header and footer options on the ribbon tab as shown in the image below.


If the author of the file has inserted a custom footer or header, sometimes the footer it’s either the header or footer will not be shown.
If you need to delete, remove, change or alter the custom footer or custom header, it can be done by the steps below. Steps is shown in the image below. Click on “File”, click “Print”, click “Page setup” a small text found on the bottom right side of the print window. After clicking “Page Setup”, a window will open, then click on “Header/Footer” option.


Cheers, till next time! Hope it helps to make life easier.



=================…

Error in scanning 027-529

Fuji scanning results to an error with a job status of Completed with error Data read failure from SMB server and the error code is 027-529.
There are various reasons why an error or a failure occurs. And for that reason, there are also quite a lot of ways how to resolve the issue.
The description or the message of the error, sometimes will give you a hint on how to solve the error and sometimes it is just a general error message that is not completely related to the actual problem. Therefore, you must be creative and resourceful on how to solve problems.
Of course, if you can keep track of recent changes done on the system. Then there’s a bigger chance that the issue surfaces because of the changes implemented on the system or in your network environment.
027-529 error on a Fuji Xerox machine and with a Windows 10 client, the error message will give you a hint already. The error stated that there’s a data read failure on the SMB server.
When it comes to access rights policy, if the user …

PowerShell Ping IP get status or reply

How to ping sweep a network?
How to ping sweep a subnet?
There’s a lot of ways to ping the whole subnet or do a sweep ping to the whole network, of course download any free software that can do this, or just manually ping the whole network by manually changing the IP address.
Or do an old school method, using a batch file. This link shows how to ping the whole subnet via command line. http://quickbytesstuff.blogspot.sg/2015/11/how-to-ping-whole-subnet-using-batch.html
Since PowerShell is readily available from Windows 7 up to the newer versions of Windows. Then PowerShell is the perfect choice to do this task.
Open PowerShell ISE or the PowerShell command line, then type or copy the commands below:
$ping = New-Object System.Net.Networkinformation.Ping 1..254 | % { $ping.send(“192.168.1.$_”) | select address, status | ft -auto }

Change the IP Address (192.168.X.X) to the IP address range of your network.
What the script does, is to Ping the whole network starting from 1 to 254, basically the w…

Remove startup files in Windows 10

How to delete, remove the files or program during startup in Windows 10?

To disable the startup program in Windows 10, right click on the task bar choose the empty space and select task manager.

On the Window tabs, Processes, Performance, etc. click on "Startup".

Right click on the program you want to manage select "Disable" if you need to disable, or if you need to enable it again select "enable" of course.

There's also an option "Open File location"|, if you need to check the  exact location of the program or file.

If you need to add custom files to start-up folder, the path would be:

C:\Users\\AppData\Roaming\Microsoft\Windows\Start Menu\Programs\Startup

Or open run box, by pressing shortcut key Windows + R and on the run box type: shell:startup

This will open the startup folder path location stated above.



Till next time. Cheers!

================================ Free Android Apps:
Click on links below to find out more:
Catholic Rosary Guide  …

Check PowerShell Version

How to check PowerShell version?

Open PowerShell ISE or PowerShell command line and type: get-host | select version

Sample Output:
Version: 2.0

Why need to check the PowerShell version?

If some commands that you find online is not working, it's either the command is wrong or the command is available for specific versions only.

New commands will work on new version of course, old commands may not work also on newer version if the command is obsolete or deprecated.

As the odds say, "Change is the only permanent thing in this world." and this quote is quite applicable in today's digital world.


Till next time. Cheers!

================================ Free Android Apps:
Click on links below to find out more:
Catholic Rosary Guide  for Android:
https://play.google.com/store/apps/details?id=com.myrosaryapp
http://quickbytesstuff.blogspot.sg/2014/09/how-to-recite-rosary.html
https://play.google.com/store/apps/details?id=soulrefresh.beautiful.prayer
Excel Keyboard shortcuts guide http…