Feeds:
Posts
Comments

Archive for the ‘Uncategorized’ Category

SQL jilid 2016

Selamat pagi menuju siang dan makan nasi disiang hari …

Sederhana tapi lumayan … 😀

Tergelitik sedikit dari seorang teman yang memposting di medsos untuk hanya menjumlahkan beberapa baris saja dengan kumpulan data dibawah ini :

13782035_10154762010673912_3683660849283429470_n
Ternyata ini SQL membuat saya tertantang untuk membuatnya, dan inilah step nya:

  1. Kita lihat dulu total data yang ada seperti dibawah ini
    Screen Shot 2016-08-01 at 12.45.41 PM
  2. Kemudian, saya pikirkan gimana caranya untuk mendapatkan kriteria yang dimaksud, dalam hal ini ‘Aktiva’, berikut SQL nya:
    Screen Shot 2016-08-01 at 12.46.32 PM
  3. Coba dilihat data tersebut ada sub-detail dari Bank, jadi saya harus mengambil data Bank nya:
    Screen Shot 2016-08-01 at 12.47.52 PM
  4. Karena langkah ke-2 menghasilkan query beberapa row, tapi ini dijadikan acuan untuk mengambil data Bank dengan menggunakan fungsi IN pada WHERE condition, SQL:
    Screen Shot 2016-08-01 at 12.48.37 PM
  5. Gabungkan langkah ke-2 dan langkah ke-4
    Screen Shot 2016-08-01 at 12.49.22 PM
  6. Tujuan utama untuk menjumlahkan semua record yang bersifat ‘Aktiva’ dalam hal ini, maka saya buatkan kembali query sum untuk sub-query nya, SQL nya :
    Screen Shot 2016-07-29 at 2.43.02 PM

Itu saja dulu.

Kalau di embed ke stored procedure atau ke query apapun, lebih baik kriteria dimasukkan sebagai parameter saja, agar mudah jika dilakukan perubahan.

Semoga bermanfaat!

Cheers,
😎
Man’z

Advertisements

Read Full Post »

Hallo again ..

Sekarang sudah pakai Qubes kan … nah bagaimana kalau copy file banyak / per directory dari dom0 ke appVM ?

Ada beberapa contoh :

1.Copy semua file yang ada nama snapshot*.jpg ke appVM

dom0 ~] tar -cvf – snapshot*.jpeg | qvm-run -p appVM ‘tar -xf -‘

2. Copy semua file di directory

dom0 ~] tar -cvf – namadirectory | qvm-run -p appVM ‘tar -xf -‘

3. Pindahkan semua file yang kamu mau

dom0 ~] tar –remove-files -cvf – namadirectory | qvm-run -p appVM ‘tar -xf -‘

 

Next issue adalah bagaimana mengubah PDF file ke secure-PDF format secara banyak file :

~] for p in *.pdf; do qvm-convert-pdf “$p”; done

 

qrexec timeout for windows7 hvm

Ini gara gara setelah install qubes-tools-windows trus ada error: Cannot execute qrexec-daemon!

Setting qrexec_timeout secara default dari qubes adalah 60 seconds jadi kita perlu menaikkan agar lebih lama dari itu, kenapa ? karena untuk Windows loading disknya lebih lama daripada system linux, lakukan hal ini di domain dom0

dom0 ~] qvm-prefs win7 -s qrexec_timeout 120

more formal statements:

qvm-prefs <appVM> -s qrexec_timeout <higher-value-in-seconds>

 

Nantikan tricky – tricky yang saya kumpulkan dilain waktu.

 

Salam,
Man’z
😎

Read Full Post »

New Achievement

Dear All,

Long time not posting anything … because i’m concentration for :

no other comments, just awaiting one of another proof of certification at below one :

Ec-Council Disaster Recovery Professional

😎

Read Full Post »

Dear All,

Get back again on post the blogs … Now, How to run SAP GUI at Linux in Virtualizing Mode ?

Short ways :

1. Download the latest (at this blogs wroted) PlatinGUI at : ftp://ftp.sap.com/pub/sapgui/java/710r10
What is PlatinGUI ? SAP GUI that run on Platform Independent … so … this application is Java Version.
2. Download the latest (at this blogs wroted) JRE at : http://www.java.com/en/download/index.jsp
3. Extract / Install this latest of JRE ( if not installed yet ), how to check that Java has been install or not ?
simply, type at the shell of linux : java -version

terminalon this screen-shots that the Java has been installed.

Don’t forget to set the JAVA_HOME at /etc/bash.bashrc files, (for ubuntu example)
rachman@manz-ubuntu:~$ sudo gedit /etc/bash.bashrc

type :
JAVA_HOME=”Path_Java_Installation”
export JAVA_HOME

save and exit.

4. Install PlatinGUI :
rachman@manz-ubuntu:~$ java -jar PlatinGUI-Linux-710r10.jar
then, click Install and follow the instructions

5. After finish the installation, set the configuration setting with running the SAPGUI logon at :
rachman@manz-ubuntu:~$ /opt/SAPClients/SAPGUI/bin/guilogon

Screenshot-SAPGUI for JavaIn that screen-shot, has a one entry of SAP Production server … how to be set like that ?

Click New Button, and will be show the new dialog box :

Screenshot-Add New Connection

First, type your description of your server, and leave the connection type with R/3, and then goto Advanced Tab, don’t forget to click the Expert Mode … wow … some Expert play in here .. :mrgreen:

Type :

conn=/H/<<your SAP Application Server Address>>/S/<<type your SID / System Identifier>>

/H means : host server to connect, you can bind your IP or FQDN

for example: 192.168.1.1 ( IP Based ), manz-ubuntu.virtualize.com ( FQDN / Fully Qualified Domain Name )

/S means : SID ( System Identifier ), for this example we use 00 for SID, but why become 3200 ?

based on information that i’m get, the SAP use some port to access their application server, here we are the ports :

sapdp##  32##/tcp # SAP Dispatcher.       3200 + System-Number
sapgw##  33##/tcp # SAP Gateway.          3300 + System-Number
sapsp##  34##/tcp #                       3400 + System-Number
sapms##  36##/tcp # SAP Message Server.   3600 + System-Number
sapdp##s 47##/tcp # SAP Secure Dispatcher 4700 + System-number
sapgw##s 48##/tcp # SAP Secure Gateway    4800 + System-Number

sapgw97  3397/tcp # SAP Oss
sapgw98  3398/tcp # SAPcomm
sapgw99  3399/tcp # SAP EPS
sapdp99  3299/tcp # SAProuter

this ports will be mapped into VirtualBox extradata settings.

After that, click save to saving your connection.

Now, before you can run…

Goto hosts OS first and then set the extradata on hosts OS like this :

VBoxManage setextradata Ubuntu “VBoxInternal/Devices/pcnet/0/LUN#0/Config/sapdp/HostPort” 3200
VBoxManage setextradata Ubuntu “VBoxInternal/Devices/pcnet/0/LUN#0/Config/sapdp/GuestPort” 3200
VBoxManage setextradata Ubuntu “VBoxInternal/Devices/pcnet/0/LUN#0/Config/sapdp/Protocol” TCP

 

VBoxManage setextradata Ubuntu “VBoxInternal/Devices/pcnet/0/LUN#0/Config/sapgw/HostPort” 3300
VBoxManage setextradata Ubuntu “VBoxInternal/Devices/pcnet/0/LUN#0/Config/sapgw/GuestPort” 3300
VBoxManage setextradata Ubuntu “VBoxInternal/Devices/pcnet/0/LUN#0/Config/sapgw/Protocol” TCP

VBoxManage setextradata Ubuntu “VBoxInternal/Devices/pcnet/0/LUN#0/Config/sapsp/HostPort” 3400
VBoxManage setextradata Ubuntu “VBoxInternal/Devices/pcnet/0/LUN#0/Config/sapsp/GuestPort” 3400
VBoxManage setextradata Ubuntu “VBoxInternal/Devices/pcnet/0/LUN#0/Config/sapsp/Protocol” TCP

VBoxManage setextradata Ubuntu “VBoxInternal/Devices/pcnet/0/LUN#0/Config/sapms/HostPort” 3600
VBoxManage setextradata Ubuntu “VBoxInternal/Devices/pcnet/0/LUN#0/Config/sapms/GuestPort” 3600
VBoxManage setextradata Ubuntu “VBoxInternal/Devices/pcnet/0/LUN#0/Config/sapms/Protocol” TCP

VBoxManage setextradata Ubuntu “VBoxInternal/Devices/pcnet/0/LUN#0/Config/sapdp#s/HostPort” 4700
VBoxManage setextradata Ubuntu “VBoxInternal/Devices/pcnet/0/LUN#0/Config/sapdp#s/GuestPort” 4700
VBoxManage setextradata Ubuntu “VBoxInternal/Devices/pcnet/0/LUN#0/Config/sapdp#s/Protocol” TCP

VBoxManage setextradata Ubuntu “VBoxInternal/Devices/pcnet/0/LUN#0/Config/sapgw#s/HostPort” 4800
VBoxManage setextradata Ubuntu “VBoxInternal/Devices/pcnet/0/LUN#0/Config/sapgw#s/GuestPort” 4800
VBoxManage setextradata Ubuntu “VBoxInternal/Devices/pcnet/0/LUN#0/Config/sapgw#s/Protocol” TCP

VBoxManage setextradata Ubuntu “VBoxInternal/Devices/pcnet/0/LUN#0/Config/sapgw97/HostPort” 3397
VBoxManage setextradata Ubuntu “VBoxInternal/Devices/pcnet/0/LUN#0/Config/sapgw97/GuestPort” 3397
VBoxManage setextradata Ubuntu “VBoxInternal/Devices/pcnet/0/LUN#0/Config/sapgw97/Protocol” TCP

VBoxManage setextradata Ubuntu “VBoxInternal/Devices/pcnet/0/LUN#0/Config/sapgw98/HostPort” 3398
VBoxManage setextradata Ubuntu “VBoxInternal/Devices/pcnet/0/LUN#0/Config/sapgw98/GuestPort” 3398
VBoxManage setextradata Ubuntu “VBoxInternal/Devices/pcnet/0/LUN#0/Config/sapgw98/Protocol” TCP

VBoxManage setextradata Ubuntu “VBoxInternal/Devices/pcnet/0/LUN#0/Config/sapgw99/HostPort” 3399
VBoxManage setextradata Ubuntu “VBoxInternal/Devices/pcnet/0/LUN#0/Config/sapgw99/GuestPort” 3399
VBoxManage setextradata Ubuntu “VBoxInternal/Devices/pcnet/0/LUN#0/Config/sapgw99/Protocol” TCP

VBoxManage setextradata Ubuntu “VBoxInternal/Devices/pcnet/0/LUN#0/Config/sapdp99/HostPort” 3299
VBoxManage setextradata Ubuntu “VBoxInternal/Devices/pcnet/0/LUN#0/Config/sapdp99/GuestPort” 3299
VBoxManage setextradata Ubuntu “VBoxInternal/Devices/pcnet/0/LUN#0/Config/sapdp99/Protocol” TCP

And then, run your Ubuntu guests OS…

Devices:

pcnet, this name used for PCNET-PCI or PCNET-fast
e1000, this name used for Intel PRO/1000

Ubuntu name is your virtualbox guests identifications

After all successful steps, we can see the SAP run on Virtualizations …

SAP_Virtualizing

Ok that’s all folks … just do it :mrgreen:

SAP run on Virtualization Ubuntu OS’es with PlatinGUI … so … no matter you will working on Linux …

Cheers,
😎
Man’z

Read Full Post »

Dear barudax STTI – DCI … siapa ajah dah yang suka baca blog ini …

Khusus untuk anak – anak STTI – DCI seluruuuuuhhh angkatan …

Register and Join at : http://sttindonesia.ning.com/ :mrgreen:

Sekedar berjumpa dan menyambung tali silaturahim dengan kawan – kawan lamaaaaaa …

Tengkiu to Akang Ricky … yang udah nyempetin buat nie social community network …

Salam STTI,
😎
Man’z

Read Full Post »

Dear all of my friendz,

Right now after socialization from POLDA Banten and BSA last month (Aug), they do the activities for sweeping the an illegal software. Actually, we didn’t get true evidence for this, but, from the news i heard, some companies surrounding Industrial Estate already audited and get some results.

The results is, some computer has been taken by police to get more deeply check.

We didn’t know, its true story or not, but we still search the evidence that they already sweeped.

For your all of my friendz who already read this blog, please be aware using piracy software even you’re already get some an original software. They sweep all computer one by one.

Just be aware …

Sincerely yours,
😎
Man’z

Read Full Post »

Dear All,

We see on youtube and catch the location of Secret location at Google Earth.

If you didn’t have installed Google Earth Client, you may use the Google Earth on the web, and put this following Location :

27 22’48.47″N 33 37’55.50″E
36 24’22.77″S 174 43’33.60″E
31 1’5.70″N 7 58’31.80″E
53 50’59.55″N 1 58’12.02″W
40 27’15.19″N 93 23’33.75″E
40 27’18.38″N 93 44’21.34″E
33 44’17.45″N 112 38’0.17″W
51 53’14.87″N 176 38’15.18″W

One by one you put that location … and then what you see at the G-Earth ? but if you already install the Google Earth Client, please input that location with format: Longitude and Latitude locations

Cheers,
😎
Man’z

Read Full Post »

Older Posts »