Questions[data-extraction](server)

There is a folder that contains many folders and subfolders, and each of these contains any number of password-protected 7zip archives. The password is the same for all of them. These are single-layer archives (no archives within archives).

I am trying to extract all of them in a single command in such a way that:

1. Every file will be extracted to the directory in which its original archive was located without a subfolder being created for it,
2. Each original archive file will be deleted,
3. and the password will be input automatically by the command.

I already know this needs to be some kind of script since the 7zip context menu doesn't allow to do this AFAIK. However, I am not well-versed in command-line usage and would really appreciate if someone could provide a script I could copy-paste...

I already looked through a bunch of answers, including the following that describe a similar situation minus the password aspect:

• https://superuser.com/questions/240853/how-do-i-extract-all-zip-files-in-subfolders-using-7-zip-on-windows-7 (I Don't know how to use this)
• How do I extract all archives in the subdirectories of this folder? (I was able to figure out how to build in the password, but I am not sure how to tell it Y to all overwrites or how to add the delete the archive function)

Using grep to print a keyword in a log to the output file

grep -i -n "application" /app/log1.log > L1.log

Now this gives results if it finds application in the log. But also results empty l1 log file where there are no results.

Would like assistance in creating the l1.log only when there are results.

The oracle 10g DB that is being currently used has exceeded the limit of 4GB. For the application to continue the db needs to be upgraded to 11g. But the upgrade doc requires a data pump export to be done from 10g and then data pump import it to 11g.

But the concern is the 10g exceeding its limit of 4GB and hence will not allow a data pump export to be done. Is there any alternate option to move the data to 11g other than data pump export and import.

Have tried the export with expdp but i get an error saying the database has exceeded th 4gb limit.

Following is my ifconfig output

eth0      Link encap:Ethernet  
          UP BROADCAST MULTICAST  MTU:1500  Metric:1
          RX packets:0 errors:0 dropped:0 overruns:0 frame:0
          TX packets:0 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000 
          RX bytes:0 (0.0 B)  TX bytes:0 (0.0 B)
          Interrupt:28 Base address:0x2000 

eth1      Link encap:Ethernet  
          inet addr:192.168.1.2  Bcast:192.168.1.255  Mask:255.255.255.0
      UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
          RX packets:36497 errors:0 dropped:0 overruns:0 frame:14515
          TX packets:44884 errors:1352 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000 
          RX bytes:20781745 (20.7 MB)  TX bytes:17776225 (17.7 MB)
          Interrupt:17 Base address:0xc000 

lo        Link encap:Local Loopback  
          inet addr:127.0.0.1  Mask:255.0.0.0
          inet6 addr: ::1/128 Scope:Host
          UP LOOPBACK RUNNING  MTU:16436  Metric:1
          RX packets:12 errors:0 dropped:0 overruns:0 frame:0
          TX packets:12 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:0 
          RX bytes:720 (720.0 B)  TX bytes:720 (720.0 B)

virbr0    Link encap:Ethernet  
          inet addr:192.168.122.1  Bcast:192.168.122.255  Mask:255.255.255.0

          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
          RX packets:0 errors:0 dropped:0 overruns:0 frame:0
          TX packets:24 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:0 
          RX bytes:0 (0.0 B)  TX bytes:4416 (4.4 KB)

vmnet1    Link encap:Ethernet 
          inet addr:192.168.185.1  Bcast:192.168.185.255  Mask:255.255.255.0

          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
          RX packets:0 errors:0 dropped:0 overruns:0 frame:0
          TX packets:24 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000 
          RX bytes:0 (0.0 B)  TX bytes:0 (0.0 B)

vmnet8    Link encap:Ethernet  
          inet addr:192.168.207.1  Bcast:192.168.207.255  Mask:255.255.255.0

          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
          RX packets:0 errors:0 dropped:0 overruns:0 frame:0
          TX packets:25 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000 
          RX bytes:0 (0.0 B)  TX bytes:0 (0.0 B)

How do I use grep to extract the IP address corresponding to each LAN card?

Is that possible? How can it be achieved?

I work in the IT support department of a branch of a huge company.

I have to take care of a database with all the users, computers, etc. I'm trying to find a way to automatically update the database as much as possible, but the IT infrastructure guys doesn't give me enough privileges to use Active Directory in order to dump the users, nor they have the time to give me the information that I need.

Some days ago I found Active Directory explorer from Sysinternals that allows me to browse through Active Directory, and I found all the information that I need there (username, real name, date when it was created, privileges, company, etc.). Unfortunately I'm unable to export the data to a human readable format. I'm just able to take a snapshot of the whole database in a machine-readable format. Doing the snapshot takes hours and I'm afraid that the infrastructure guys won't like me doing entire snapshots on a regular basis.

Do you know of any tool (command-line is preferable) that would allow me to retrieve the values of the keys or export it to XML, CSV, etc?