Archives 2016

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