2018年1月8日 星期一

MSSQL 顯示 TABLE 中的欄位名稱

MSSQL 顯示 TABLE 中的欄位名稱

USE [DB NAME]
SELECT COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'TABLE NAME'

exec sp_columns [TABLE NAME]

2018年1月4日 星期四

AIX 查 RAM,CPU,HD,IP

AIX UNIX RAM
# prtconf -m
# bootinfo -r
# lsattr -El sys0 -a realmem
# lsattr -El mem0

Show CPU
# prtconf -s
# pmcycles -m
# lsdev -Cc processor

# bindprocessor -q

Show Hard disks/Capacity
# lsdev -Cc disk
# lspv
# bootinfo -s hdisk0

Show IP Addresses
# ifconfig -a | grep inet
# lsattr -El en0 -a netaddr

paging space
lsps -a

參考來源:http://www.unixmantra.com/2013/09/aix-listing-cpu-memory-ram-harddisks-ip-address.html

2017年11月17日 星期五

Google Apps (suite) 用 SDK 切主網域

Change of Primary Domain in Google Apps
  1. Login to your Google Apps Control Panel.
  2. Browse to Google Apps API Page where you change customer information. Make sure you see your Admin email address in to right corner.
  3. Click “Try it now” link.
  4. In “customerKey” field enter “my_customer“.
  5. In “fields” field enter “customerDomain“.
  6. Click “Request body” field, a drop down box will appear & select “customerDomain“.
  7. In the newly appear field, enter your Secondary Domain which you want to change to Primary Domain.
  8. Finally click the blue “AUTHORIZE AND EXECUTE” button.
  9. When the process is done, your secondary domain is converted to Primary Domain and vise versa.
參考:https://www.internetearnings.com/how-to-change-primary-domain-in-google-apps/