SQL Query for classification description updating

If you want update description of classification, you have to update field "description" in two tables. Example:

update classstructure set description = 'Description' where classificationid = 'IT010303'
update classification set description = 'Description' where classificationid = 'IT010303'

Maximo Jars for Maximo Java Development

1. maximo\lib\*.jar
2. maximo\lib\j2ee.jar
Extracted from maximo.ear:
3. businessobjects.jar
4. maximouiweb.war\WEB-INF\classes (zipped to maximouiweb.jar)

Simple Excel VBA macros for swapping two rows

Sub SwapRanges()
  Dim ra As Range: Set ra = Selection
  msg1 = "You have to select TWO ranges of cells of the same size"
  msg2 = "You have to select 2 ranges of cells of the SAME size"
  If ra.Areas.Count <> 2 Then MsgBox msg1, vbCritical,"Error":Exit Sub
  If ra.Areas(1).Count <> ra.Areas(2).Count Then MsgBox msg2, vbCritical,"Error":Exit Sub
  Application.ScreenUpdating = False
  arr2 = ra.Areas(2).Value
  ra.Areas(2).Value = ra.Areas(1).Value
  ra.Areas(1).Value = arr2
End Sub

p.s.
And not only rows. You can swap any 2 equal areas:

How to use VBA macros:

Hide the Search panel on the Start center in IBM Control Desk 7.5.3, 7.5.1.2

If you want to hide Search panel on Start center and make expanded by default "Go To Application" menu in IBM Control Desk 7.5.3, 7.5.1.2, you have to do the following steps:

1. Go To > System Configuration > Application Designer
2. Select Action > Export System XML

How to hide the additional search panel in the applications

If you want to hide this new panel, which have been appeared in the latest versions of SmartCloud Control Desk 7.5.3 (7.5.1.2), you have to change System property
mxe.webclient.searchMenubar from 1 to 0.

Before changing:

and the result will be next:

HASH for password "P@ssw0rd"

If you want to reset password to "P@ssw0rd" for any user, for example for maxadmin user, you have to update field "password" in table "maxuser" by value "0xA587F52BA133CA479D56F780F84840BC" using CONVERT function.

use maxdb75;
update maxuser set password =
CONVERT(VARBINARY(128), '0xA587F52BA133CA479D56F780F84840BC', 1) where userid = 'maxadmin';

p.s.
only for maximo internal authorization, SQL Server

VMWare - Guest operating system static IP address

1. Note the MAC of the VM
2. On the host machine open C:\ProgramData\VMware\vmnetdhcp.conf
    a. Or C:\Documents and Settings\All Users\Application Data\VMware\vmnetdhcp.conf
    b. These 2 files are auto synced or mirrored.
    c. Open the editor in Administrator mode. Eg notepad++. Otherwise you will get access denied message
3. Add a new entry at bottom of the configuration file, right before the "# End" marker. MyGuestVM is any unique name. Example below

host sunilW2008Server {
hardware ethernet 00-0C-29-05-2B-A0;
fixed-address 192.168.63.222;
}

3. Shutdown the VM and close the Workstation
4. Re-start the VMWare DHCP and NAT services for changes to take effect (From services.msc)