Copiere parola utilizator SAP de la alt utilizator

Pentru copierea parolei utilizatorului GEORGE.S din clientul 300 peste acelasi utilizator din clientul 200 se poate utiliza urmatorul sql query:

UPDATE
    T200
SET
    T200.BCODE = T300.BCODE,
    T200.PASSCODE = T300.PASSCODE
FROM
    lid.USR02 AS T200
    INNER JOIN lid.USR02 AS T300 ON (T200.BNAME = T300.BNAME AND T300.MANDT = '300')
WHERE
    T200.MANDT = '200' AND T200.BNAME = 'GEORGE.S';

 

Scanare gratuita/online antivirus/antispyware

Scanere online sau gratuite
Trend Micro Housecall – scanare si curatare
BitDefender Antivirus Free Edition – scanare si curatare
ESet (NOD32) Online Scanner – scanare si curatare
Kaspersky Online Scan – doar scanare
Panda Activescan – doar scanare
McAfee FreeScan – doar scanare
Symantec Security Check – scanare si curatare
Dr.Web Online Check – scanarea unui fisier uploadat

Scanare troieni
TrojanScan by WindowsSecurity.com

Spyware Scanners
Malwarebytes AntiMalware

Instalare si utilizare qmHandle

Instalare:

[root]# cd /opt
[root]# wget http://jaist.dl.sourceforge.net/sourceforge/qmhandle/qmhandle-1.3.2.tar.gz
[root]# tar -xzf qmhandle-1.3.2.tar.gz
[root]# cd qmhandle-*/
[root]# mv qmHandle /var/qmail/bin/
[root]# /var/qmail/bin/qmHandle -s

Parametri:

-a: try to send queued messages now (qmail must be running)
-l: list message queues
-L: list local message queue
-R: list remote message queue
-s: show some statistics
-mN: display message number N
-dN: delete message number N
-fsender: delete message from sender
-f're': delete message from senders matching regular expression re
-Stext: delete all messages that have/contain text as Subject
-h're': delete all messages with headers matching regular expression re (case insensitive)
-b're': delete all messages with body matching regular expression re (case insensitive)
-H're': delete all messages with headers matching regular expression re (case sensitive)
-B're': delete all messages with body matching regular expression re (case sensitive)
-t're': flag messages with recipients in regular expression 're' for earlier retry (note: this lengthens the time message can stay in queue)
-D: delete all messages in the queue (local and remote)
-V: print program version

Parametri aditionali (optionali):

-c: display colored output
-N: list message numbers only
(to be used either with -l, -L or -R)

Pot fi vizualizate/sterse mai multe mesaje simultan: -d123 -v456 -d567

Instalare SAPGUI for Java in Ubuntu

  1. Se verifica daca este instalat Java
lorand@ubuntu:~$ java -version

2. Se adauga repository-ul pentru instalarea Java si apoi se instaleaza Java:

lorand@ubuntu:~$ sudo add-apt-repository ppa:webupd8team/java
lorand@ubuntu:~$ sudo apt-get update
lorand@ubuntu:~$ sudo apt-get install oracle-java8-installer

4. Se instaleaza SAPGUI (poate fi descarcat de aici:  7.40 sau 7.50):

lorand@ubuntu:~$ sudo java -jar /home/lorand/Desktop/PlatinGUI740Linux_4.JAR

5. Se ruleaza SAPGUI

lorand@ubuntu:~$ cd /opt/SAPClients/SAPGUI7.40rev4/bin
lorand@ubuntu:~$ ./guilogon

6. Se configureaza conexiunea la server (tab-ul Advanced)

conn=/H/xxx.xxx.xxx.xxx/S/3200

7. Pentru dezinstalare se foloseste comanda

java -jar /home/lorand/Desktop/PlatinumGUI740Linux_4.JAR uninstall

 

Probleme listare SAP

In ultimele zile au aparut cateva probleme la printarea din SAP, in special la colegii care listeaza mai multe tipuri de documente pe imprimante diferite. De asemenea, problemele au aparut si la colegii care utilizeaza Windows 10. Pentru a rezolva problema au fost facute cateva teste si configurari la imprimantele din SAP.

Read More

Ascundere utilizatori din ecranul de login

Din Local Group Policy se poate restrictiona un utilizator sa se logheze local.

Se porneste editorul Local Group Policy din linie de comanda: gpedit.msc

Computer Configuration > Windows Settings > Security Settings > Local Policies > User Rights Assignment. Aici se gaseste politica Deny log on locally. Grupurile sau utilizatorii adaugati in aceasta politica nu se vor putea autentifica local si nu vor apare in ecranul de login.

Dezinstalare update din linie de comanda in Windows 7

Dupa instalarea unor update-uri in Windows 7, pe unele calculatoare nu au mai rulat anumite fisiere executabile. Eroarea afisata era:

The application was unable to start correctly (0x0000005)

Solutia a fost dezinstalarea ultimelor update-uri, doar ca nici Installed updates nu putea fi accesat. In schimb, Update history afisa lista de update-uri instalate impreuna cu data instalarii fiecaruia. In felul acesta au fost identificate ultimele update-uri instalate.

Fiecare update a fost dezinstalat folosind comanda:

wusa /uninstall /kb:3127220

Fujitsu ServerView RAID Manager pe un server Fujitsu PRIMERGY RX300 S6

Fujitsu ServerView RAID Manager poate fi descarcat de la adresa http://support.ts.fujitsu.com/, unde se alege versiunea sistemului de operare, apoi se alege SAS RAID, apoi tipul de controller RAID (in cazul meu D2616) si se descarca ServerView RAID Manager.

Dupa instalarea programului, acesta poate fi accesat printr-o interfata web la adresa https://server-addr:3173. Pentru accesarea ServerView RAID Manager este necesara instalarea Java, minim versiunea 7. De asemenea, in firewall trebuie deschis portul 3173.

Daca browser-ul afiseaza mesaje de avertizare cu privire la lipsa unui certificat, se urmeaza instructiunile din documentatia programului, la adresa https://server-addr:3173/public/help/en/index.htm

Informatii suplimentare: http://support.ts.fujitsu.com/WDB/FAQContent.asp?ID=233509936&Info=Fulltext&Sprache=EN&LNG=COM&LNID=1

 

Utilizare 7-Zip din linie de comanda

7za <command> [<switches>...] <archive_name> [<file_names>...] [<@listfiles...>]

Commands:
a : Add files to archive
b : Benchmark
d : Delete files from archive
e : Extract files from archive (without using directory names)
h : Calculate hash values for files
l : List contents of archive
rn : Rename files in archive
t : Test integrity of archive
u : Update files to archive
x : eXtract files with full paths

Switches:
: Stop switches parsing
-ai[r[-|0]]{@listfile|!wildcard} : Include archives
-ax[r[-|0]]{@listfile|!wildcard} : eXclude archives
-bd : Disable percentage indicator
-i[r[-|0]]{@listfile|!wildcard} : Include filenames
-m{Parameters} : set compression Method
-o{Directory} : set Output directory
-p{Password} : set Password
-r[-|0] : Recurse subdirectories
-scs{UTF-8|UTF-16LE|UTF-16BE|WIN|DOS|{id}} : set charset for list files
-sfx[{name}] : Create SFX archive
-si[{name}] : read data from stdin
-slt : show technical information for l (List) command
-so : write data to stdout
-ssc[-] : set sensitive case mode
-ssw : compress shared files
-t{Type} : Set type of archive
-u[-][p#][q#][r#][x#][y#][z#][!newArchiveName] : Update options
-v{Size}[b|k|m|g] : Create volumes
-w[{path}] : assign Work directory. Empty path means a temporary directory
-x[r[-|0]]]{@listfile|!wildcard} : eXclude filenames
-y : assume Yes on all queries

Copie client SAP – remote

  1. Autentificare in sistemul in care se doreste copierea datelor (sistemul destinatie)
  2. Se ruleaza tranzactia SCC9 (Copie client)
  3. Se completeaza informatiile necesare:
    • Profil: SAP_ALL
    • Client sursa: LIPCLNT500
  4. Se completeaza parametrii pentru Parallel Processes
    • Goto -> Parallel Processes
    • Maximum number of processes: 12 (se recomanda cate 2 procese pentru fiecare procesor al bazei de date, iar pentru copia de client remote se pot utiliza cate 3 procese)
    • Logon/Server Group: parallel_generators
  5. Programare executare copie in background
  6. Jurnalul de activitati poate fi consultat in tranzactia SCC3

Important: la momentul inceperii copiei de client, joburile programate de pe clientul sursa vor fi oprite/suspendate automat. Acestea pot fi oprite si manual folosind tranzactia SE38 si ruland programul BTCTRNS1. Dupa efectuarea copiei de client aceste joburi trebuie repornite/reactivate manual ruland programul BTCTRNS2 in tranzactia SE38.

Detalii despre profilele copiei de client:
http://help.sap.com/saphelp_sem40bw/helpdata/en/c2/17e73a86e99c77e10000000a114084/content.htm

Administrare utilizatori in Linux

Adaugare utilizator in unul sau mai multe grupuri:

useradd -G group-name1[,group_name2][,group_name3] username

Adaugare grup:

groupadd group_name

Modificare parola utilizator:

passwd username

Verificare grupuri utilizator:

id username

Adaugare utilizator existent intr-un grup existent:

usermod -a -G group_name username

Modificare grup primar pentru un utilizator:

usermod -g group_name username

Activare acces pentru root via ssh

In fisierul /etc/ssh/sshd_config  se seteaza:

PermitRootLogin yes