Getting list users and groups in AIX

Posted: August 31, 2015 in HowTo
Tags: , , ,

Run the following command to get the list of users and associated groups in AIX environment

$ lsuser ALL
Advertisements

Compare two tables in Oracle

Posted: July 30, 2015 in HowTo
Tags: , ,

Use the following SQL to compare two tables in Oracle

-- rows in table1 that are not in table2
(
  select * from  
    minus
  select * from 
) 
union all
-- rows in table2 that are not in table1
( 
  select * from  
    minus
  select * from 
) 

Run the following command in command prompt to find the domain groups that you are in. This applies to Windows operating system.

c:\> gpresult /r

Finding the Apache version

Posted: July 23, 2015 in HowTo
Tags: , , ,

Run the following command to find the version of Apache that is installed on Unix based systems. Please note, depending how Apache is installed you may need super user access to run this command.

# httpd -v

or

$ sudo httpd -v

How to change logo in Tableau

Posted: March 2, 2015 in HowTo
Tags: ,

Open command prompt as an Administrator and switch directory

cd <Installation Tableau directory>\Tableau Server\<version>\bin

 

Change the logo using the following command. The “logo image” can be up to 160 x 160 px but not smaller than 32 x 32 px. The image can be a .png, jpg, or .gif file.

tabadmin customize logo <logo image>

 

Change the small logo using the following command. The “small logo image” can be less than 32 x 32 px. The image can be a .png, jpg, or .gif file.

tabadmin customize smalllogo <small logo image>

 

Restart the server for the change to take effect by typing:

tabadmin restart

Run the following command to check if port is in use

# netstat -an | grep <port number>

If above returns the connection, then run the following command to get the address of the port number

# netstat -Aan | grep <port number>

Once you have the address of the port number, run the following command to get the process id that is using the port.

# rmsock <address of port number> tcpcb

Example

# netstat -an | grep 30767
tcp4       0      0  *.30767                *.*                    LISTEN
# netstat -Aan | grep 30767
f100060001b2f398 tcp4       0      0  *.30767            *.*                LISTEN
# rmsock f100060001b2f398 tcpcb
The socket 0x1b2f008 is being held by proccess 942150 (vcs_agent).

Finding the process that locks a dll

Posted: October 29, 2013 in HowTo
Tags: , ,

Run this command line to find the process that locks a specific dll.

c:\>tasklist /m locked.dll

Please note this would work only in Windows XP or 2003 or above.