This operation has been restricted due to restrictions in effect on this computer. Please contact your system administrator.

Today when I started my day in office, I found that some applications we not working as they used to be. And when tried to start them, I got an error dialog box with a message "This operation has been restricted due to restrictions in effect on this computer. Please contact your system administrator.". It seems that IT dept has made some restrictions for applications.

Command Prompt: searching port status and killing a process

Today, while working with Glassfish server, I encounted a weird issue that I restarted Glassfish server but Glassfish failed to start and the most annoying thing was, I found nothing in it's logs. Tried to restart Glassfish from windows service several time but all in vain.
Then I tried to check all the ports used in Glassfish. Ports used by Glassfish can be checked from domain.xml file. Search "http-listner" and make a list of ports.

VMware: Prepare list of VMs with snapshots using PowerShell

VMware snapshots plays important role for VM backup. It is recommended to remove old snapshots as they consume space and may create problems if somebody revert the VM with old snapshot. If you have handsome amount of Virtual Machines, then it will be difficult and time consuming for you to manage those snapshots manually. 

Calculating MySQL Database size.

So Guys, how do you calculate the size of your databases on db server using a simple & single query..
.
.
.
Well this thing is easily achievable by a simple query. For this you need to query information_schema, which will result you the database size and other information.

   SELECT table_schema "DB Name", ROUND(SUM(data_length + index_length) / 1024 / 1024 / 1024, 1) "DB Size in GB" 
   FROM   information_schema.tables GROUP  BY table_schema;

:)

Removing James as windows service

In previous post, you checked how to configure James as windows service but there may be a situation when you have to remove James as Windows service. To remove James service or any other service, follow below mentioned steps:

MySQL: Query to calculate database size.

So Guys, how do you calculate the size of your databases on db server using a simple & single query..
.
.
.
Well this thing is easily achievable by a simple query. For this you need to query information_schema, which will result you the database size and other information.

   SELECT table_schema "DB Name", ROUND(SUM(data_length + index_length) / 1024 / 1024 / 1024, 1) "DB Size in GB" 
   FROM   information_schema.tables GROUP  BY table_schema;

:)

NSClient - ERROR: Could not get data for 5 perhaps we don't collect data this far back?

Error : NSClient - ERROR: Could not get data for 5 perhaps we don't collect data this far back? 
This is the error I received a notification from my monitoring tool Nagios for a host against CPU Usage, which is quite annoying to deal with. I made some research around it and finally got a solution to fix this issue.

Explanation: This issue is around the performance counter of the server. Somehow Nagios is not able to read those performance counter.

Managing Old logs on server using Windows batch script

Most of the time system administrators are dealing with old log files like backing up the old logs manually and removing the original logs. To reduce their headache, here we have a small script, which provides flexibility to manage those old logs in very handy manner. Administrators just need to set the variables in the script as per there requirement and let the script do the magic.

About the script: This script takes the backup of all the log files older then specified number of days and after backup, it automatically deletes the original files and spare the disk space. 
A job can be schedules either on daily or weekly basis to execute this script and manage old log files on the server.

Configuring James as Windows Service

We have gone through about James server in previous post. In this post, we'll see how we can configure Apache James as windows service.
After putting Apache James at specified location, you can start James using run.bat (location: apache-james3.0\bin\run.bat). Run.bat file will start the James server but will not configure it as windows service.