Skip to main content

Posts

Showing posts from July, 2015

ffmpeg - How to get video duration in seconds?

How can I get video duration in seconds? What I've tried: ffmpeg -i file.flv 2>&1 | grep "Duration" Duration: 00:39:43.08, start: 0.040000, bitrate: 386 kb/s mediainfo file.flv | grep Duration Duration : 39mn 43s This what close, but it's not so accurate, 2383 is 39.71 minutes ffmpeg -i file.flv 2>&1 | grep "Duration"| cut -d ' ' -f 4 | sed s/,// | sed 's@\..*@@g' | awk '{ split($1, A, ":"); split(A[3], B, "."); print 3600*A[1] + 60*A[2] + B[1] }' 2383 Answer To get minutes, you have to divide 2383 seconds by 60. 39.7167 and then multiply the fractional part .7167 by 60 to get the remaining seconds. 43.002 So it's 39 minutes, 43 seconds. The application appears to be giving you an accurate value.

windows xp - How do I select a set of specific cells and then copy their entire row?

Okay this is hard to explain. I have a massive spreadsheet with sets of data in it. Each set has 'type' column (eg: system, memory, video card, etc). I need to be able to search within this column for a specific type and then be able to copy the entire row. I need this to work with multiple cells selected and then copy the multiple rows. Basically, there's around 10 rows, all listing parts of a computer with its serial number, part number, date of purchase, etc, and I need to be able to extract only a few of those rows and put them in a new spreadsheet. I am using Excel Office XP (2002) on Windows XP SP3. Here is an example of the data from the spreadsheet: ( http://imgur.com/GdKo2.png ) Answer Not sure I completely understand from your explanation, but I think what you need is to Filter. Try selecting your full data set and then goto Data|Filter. That will give you a drop down on your column headings and allow you to chooose only those Items that you're interested

sync - What could I use to keep files synced between my computers without cloud storage limitations?

Possible Duplicate: Keeping folders synced between several machines I am wondering if there is such a thing as software that: Synchronizes user-specified folders between my four (Windows) computers Syncs over LAN if possible and internet if not Does not use cloud storage or a third-party server to sync Cloud storage is costly and limits the volume of data I can sync. It also slows down the synchronization to uploading data to an unnecessary fifth computer, especially when I'm just syncing over LAN and that computer would be remote. (As far as offsite backup goes, I'm already running a cross backup with a friend, so I don't even want additional cloud space.) I would like it to be fast if possible since I have a gigabit LAN in mind. I've looked and looked at various software. Everything seems to be geared towards more conventional cloud backup or is restricted to LAN or has some other usage constraints. It's getting so that I'm feeling like writing my own sync sof

keyboard shortcuts - How can I move around the bash commandline efficiently?

So I use the up in my shell (Bash on OSX or Ubuntu, mostly) but some of the time I know that I want the stuff after the cursor's current location. Is there any way to have the line I'm on complete with the line above? Hitting up and then left is annoying. Any other tricks would be cool too, except for tab , which we all now about :) Here's an example (per ~quack's request): I type mkdir /where/the/hell/is/that/thing and then I want to cd into the same directory. But now I know about meta-b :) Answer Try this: mkdir /where/the/hell/is/that/thing then press alt + . depending on your OS and terminal you might have to type esc then . You can also press alt + 1 + . to pick a specific prior argument. This is much better than !! or !$ because you can actually see what you are about to run, and it takes less keystrokes anyway. edit: strictly speaking it is meta not alt , so it might also work with the "windows" key depending on how your keyboard is setup..

windows - How to clear Chocolatey cache in the free version?

Installation-file-cleaning is currently only available in the licensed edition of Chocolatey ( $96 a year ) and the developers seemingly have no plans to offer cache-cleaning support for the free version . The package installation files can easily take gigabytes of storage space and to my knowledge they only increase in size as the user updates packages and installs new software, with only your hard drive capacity as the upper limit. I don't know if Chocolatey stores cache in one central location — something is saved to ~\AppData\Local\Temp but the majority is located in the lib * folders in ~\ProgramData\chocolatey . Also the log files in the logs folder total to over 100 MB on my system. Is there any way to fully clear Chocolatey cache without manually deleting directories? Answer You may use for cleaning the cache the unofficial but approved package of choco-cleaner . The installed package creates a Windows Scheduled Task to run Choco-Cleaner.ps1 every Sunday at 11:00 PM.

apache http server - Wordpress Permalinks not working in Nginx

I'm moving my wordpress blog from Apache to Nginx. I've tried multiple tutorials to get permalinks working but nothing is working for me. My website structure is like this: main site -> www.localhost.com wordpress blog -> www.localhost.com/blog Website is in /var/www/html and wordpress is installed in /var/www/html/blog I've read multiple articles and watched multiple videos but nothing seems to be working. Please let me know where I'm going wrong. I've defined two server blocks in /etc/nginx/sites-available/default one for main site and one for the blog. # Default server configuration # server { listen 80 default_server; listen [::]:80 default_server; # SSL configuration # # listen 443 ssl default_server; # listen [::]:443 ssl default_server; # # Note: You should disable gzip for SSL traffic. # See: https://bugs.debian.org/773332 # # Read up on ssl_ciphers to ensure a secure configuration. # See: https://bugs.

desktop customization - Windows 8 Start Screen Wallpaper File Location?

I was wondering if there is a specific file location for all the Windows 8 start screen backgrounds. I'm not interested in modifying the wallpapers, but I want to make an app with these wallpapers available. Is there an available file location, and where can I find it? Are the images copyrighted so that I cannot use them in my app? If all fails, is there a website for Windows 8 resources? Any help would be very much appreciated. Thanks! Answer Is there an available file location, and where can I find it? The Login Screen Wallpaper is stored at (before you log on) C:\Windows\System32\oobe\background.bmp Desktop Wallpapers are stored at (after you have logged on) C:\Windows\Web\Wallpaper\ Are the images copyrighted so that I cannot use them in my app? Yes, they have a copyright. You can't use them in your app even if its a free app. These desktop background (wallpaper) images contain the intellectual property of Microsoft and other third parties. They are offered for download s

How can I add an entry to the Word 2010 Navigation Pane?

I'm writing a book, and I want to have an entry in the Navigation Pane for the primary organizational elements of the book. I'm using styles, of course, so this generally happens automatically, but I'd also like to have an entry in the Navigation Pane for the book's dedication page. I want the entry to say "Dedication", but there will be no text in the book with this word in it. I considered using white text on a white background so it'd be invisible, but I'm concerned that that will lead to problems when the book is published in various digital formats; I don't want searches for the text "dedication" to match anything, nor do I want the word "dedication" to show up if a reader sets the background color to something other than white. What I'm essentially looking for is a way to bookmark the dedication page and to give the bookmark a name that will show up in the Navigation Pane. Is there a way to achieve this effect? Thanks.

What's the Windows equivalent of "/etc/hosts"?

Possible Duplicate: How do I block certain websites from being accessed through a browser? I can block my little brother from accessing a website on my Mac by adding the following line to my "/etc/hosts" file. 127.0.0.1 someaddictingwebsite.com Do Windows systems have a file analogous to "/etc/hosts"? Can I achieve the same effect on a PC? Answer It's normally under \WINDOWS\system32\drivers\etc (If there isn't one, just create it). (you have not specified OS version, win 8 monitors this file and reverts any changes, see eg. here for discussion: http://www.howtogeek.com/122404/how-to-block-websites-in-windows-8s-hosts-file/ )

macos - Is launchd supposed to pick up "missed" events?

I read that if the computer is sleeping when a launchd event is to occur, then launchd will run the event when the computer wakes up. My question is in regards to a computer that is shut down. If the machine is powered off when a launchd event is to occur, is launchd supposed to run it at the next power-on? I ask because I have created an event (agent?) to run at 09:45am every day. But often the machine is powered off at that time. I am not seeing the output of the event (an email being sent) after I power on the computer. So I am trying to narrow down if this is behavior by design or have I messed something up. Answer It's limited to jobs that were scheduled during sleep (not when shut down) and by a StartCalendarInterval parameter (not StartInterval). Daemons and Services Programming Guide: Scheduling Timed Jobs If you schedule a launchd job by setting the StartCalendarInterval key and the computer is asleep when the job should have run, your job will run when the computer wa

How do I apply two styles in the same line in LibreOffice?

Problem: How do I apply two styles in the same line in LibreOffice? The main problem is that I need two different styles: one for the index and one that is not supposed to appear in the index Example: Table_name - author: john In the index, I only want "table_name". The author should not appear in the index. Answer It seems that there are two different issues combined in this question: Restricting an index entry to a single word, not the complete paragraph; Applying different styles in the same paragraph; To restrict an index entry to a single word, just double-click that word and select (from Menu Insert ) Indexes and Tables -> Entry . In the following dialogue, you can select if the word should appear in the TOC, the alphabetical index, or in a user-defined index. Applying different styles can be done using character styles for the index entries. After creating a character style for those entries (in my screenshot: " Indexed Word "), you will have to assi

windows 10 - Computer keeps restarting and I swear I've tried everything

Computer info at the end. My computer started restarting at seemingly random times yesterday, and I have no clue why. I've tried: Restart the computer Reinstall GPU drivers Virus scan System Restore Reinstall Windows on a different, new drive Run Memtest86 (no errors found) Run the computer with just one of my two RAM sticks (tried with each stick individually, no change) Reseat all PSU cable connections Replace GPU I have no idea what causes it. Sometimes it's when I'm playing games. Sometimes it's when I'm browsing the web. Sometimes it's when the OS is starting after a cold boot. I haven't had any crashes while using the computer in safe mode, but I don't know if that's coincidence or not, because the amount of time it takes for the computer to restart is somewhere between 10 seconds and several hours. I've checked my event logs - nothing. It just says that the computer shut down unexpectedly. I looked for a minidump - nothing. It shuts down t

windows 8 - Is it better to leave on or turn off external hard drive?

Okay here is my situation, I have a 1tb internal hard drive that is plugged in via USB Dock, and has external power, that I use for weekly backups, but my question is, is it better to leave this hard drive on all the time, or turn it it off manually when it is not being used? What is the best case scenario? Answer Turn it off, so the data are less likely to be damaged if you accidentally knock it down. By the way, Debra suggestion on don't move is valid, but aging is actually irrelevant. On modern day electronics. They just have a "designed" life, no matter you used it or not. idea: the drying contacts ink, electronic conduct rubber.

macos - How do I configure custom URL handlers on OS X?

I've been reading a lot online about custom URL handlers / custom protocol handlers such as: I get that you can tell the system that a particular program is able to handle a certain scheme / protocol with the Info.plist file: CFBundleURLTypes CFBundleURLName Local File CFBundleURLSchemes local NSUIElement But if there are multiple applications that are capable of opening the same URL handler, such as mailto: how do you specify which one you want the system to use? There were some references to utilities like the More Internet preference pane which no longer seems to be available from the author's site. I did find it online by Googling but it seems a bit shaky - like it was written for an older OSX - perhaps Tiger. I haven't been able to find information on how to set the URL handler for protocols and custom protocols. I'm assuming there is a plist file somewhere that I can edit - or maybe there is a newer,

macos - Any e-mail client with additional grouping functionality on Mac OS X?

I'm very unhappy with my mail experience. I'm receiving a lot of mails from various clients and projects and need a way to better organize them. I would really love to have additional grouping-functionality with the e-mail client. Currently I'm using Mac OS X's Mail.app, but I am not bound to this. So I am open to any Mail.app-plugin or independent mail application commercial or not for Mac OS X -- should support IMAP, though -- but I think this should not be a problem nowadays? With Mail.app i'm doing the following: group by thread sort by datetime descending What I would love to have is not only additional tagging-functionality for e-mails -- I know, that at least thunderbird and postbox support them. I would love to have some additional grouping functionality for these tags -- inside the main mail window. So maybe I can summarize the important points: "native" Mac OS X mail client (no web-mailer please) automatic-tagging functionality (eg.: auto-apply

command line - Is it possible to recursively list zip file contents with 7 zip without extracting

Similar to this question I have a very large zip file which contains other zip files, folders, and files. I want to use 7-zip to extract a list of file names from it, recursing into subfolders and zip files. 7z l -r is a good start but doesn't recurse into zip files. Questions below come close, but it sounds like this is not possible. Read the contents of a zipped file without extraction? How to list the content of a zip file within another zip file without extraction I am on Windows. Answer No. Although it may be possible to extract the embedded archive to stdout and examine it from there. But probably not.

Linux symbolic links: how to go to the pointed to directory?

I have a project in its own directory: /dir/to/project/ I have a symbolic link to that directory on the desktop: /home/user/Desktop/project/ When I double click on that link, the directory window that opens is: /home/user/Desktop/project/ instead of the real one, /dir/to/project . The same happens with the command line (Bash). Is it possible to get what I wish, i.e. go to the directory pointed to, instead of the symbolic one? Note: the windows environment I am using now is Xfce, but I am also interested in a generic answer. Answer In bash the cd builtin uses -P and -L switches; pwd understands them in the same way: user@host:~$ ln -s /bin foobar user@host:~$ cd -L foobar # follow link user@host:~/foobar$ pwd -L # print $PWD /home/user/foobar user@host:~/foobar$ pwd -P # print physical directory /bin user@host:~/foobar$ cd - # return to previous directory /home/user user@host:~$ cd -P foobar # use physical directory structure user@host:/bin$ pwd -L

apt get - Change the Ubuntu program that runs when a command can't be found

When I type a command not found in a PATH in ubuntu, I get something like this: $ rdesktop The program 'rdesktop' is currently not installed. You can install it by typing: sudo apt-get install rdesktop I believe it's a script that looks up the APT archives and suggest an installation package. I'd like to change it so that it offers me to download it at the press of a 'y'. Two questions: 1) Where is the file located? 2) If I just add the install line in the trivial way, it's going to complain that I'm not a root and will fail (because the rdesktop was ran as a mundane user). How do I make it ask for a password and use it to get root access? Answer When bash encounters a command it cannot find, it looks for a function called command_not_found_handle() and executes it. Under ubuntu, this is defined in /etc/bash.bashrc By default it runs a python script in /usr/lib/command-not-found You could make it do whatever you liked, and this is best done in your o

putty - How do you convert an SSH private key to a .ppk on the Windows command line?

I have generated a key pair with ssh-keygen . I now want to use the same key pair with PuTTY-based applications. Because I'm working in a CLI environment, I want to convert the key to the .ppk format from within this environment. Apparently, you can use puttygen openssh_private_key -o output_filename.ppk on UNIX-like environments. But the Windows version of puttygen will just load the key and prompt you to use the GUI to export the key. Batch mode for Windows PuTTYgen suggests that this simply is not currently possible, at least with puttygen . I'd gladly accept and option that uses other means though. How can I convert the key from the command line? Answer WinSCP supports command-line conversion of private keys from the OpenSSH (or ssh.com) format to the PuTTY .ppk format . Use the /keygen switch: winscp.com /keygen mykey.pem /output=mykey.ppk (I'm the author of WinSCP) Or, you can compile/run the Unix command-line puttygen using the Cygwin. Or build your own too

networking - How do I change another computer's network settings from Powershell and/or .NET?

How do I change another computer's network settings from Powershell and/or .NET? Target computers in question are in the same domain as mine and I am an administrator on all machines involved. Any simple answers? Answer I found the answer. We can create a WMI object in PowerShell representing the network settings for IP-enabled adapters on a remote server. $a = Get-WMIObject Win32_NetworkAdapterConfiguration -ComputerName MyServer -Filter IPEnabled=TRUE This object will most likely be an array of network adapter objects of which only one is needed. So we want to point to that one, probably the first object in the array: $a = $a[0] Now we can configure whatever we want, including the IP address. $a.EnableStatic("192.168.42.2", "255.255.255.0") The one thing I couldn't figure out is how to determine the netmask!

iptables - Why can’t I block https?

May I ask why can I not block all https traffic in iptables? I tried: OUTPUT --dport 443 -j DROP And even: OUTPUT --sport 443 -j DROP None of this works. Https webpages are still perfectly accessible. WHY? What kind of PEBKAC have I managed to subject myself to this time?

Have local admin privileges on Windows XP, but getting "Error terminating process: Access is denied". How to kill the process?

On one of the Windows XP machines I use regularly, there is a process that starts up periodically. I'd like to be able to kill the process – sometimes – because it occasionally runs when I'm busy doing something machine-intensive. I've already tried dropping the process priority to "Idle" to mitigate the effects, but it isn't the CPU that's the problem. Rather, the process is very disk-intensive and no matter the process priority, it still causes significant disk thrashing when running, impacting everything else I'm doing at the time. Using Process Explorer , I can find the process, right-click, and choose Kill Process , but I always get the message "Error terminating process: Access is denied." This is not an operating system process, but third-party software. What might that process be doing to prevent itself from being terminated? How can I kill such a process? Is there a way for me to modify the process's security or access control li

Windows 7 Registry Settings Documentation

Is there some documentation on the various Windows 7 registry settings, preferably from Microsoft or in some kind of Wiki? E.g., what settings exist for the Taskbar, Start Menu, Explorer, etc? I've found some 'tweak' sites but they usually only offer information for a few features and even that is mostly hidden in reg files and poorly documented. Answer As Harrymc pointed out, you're not going to get every key, but Microsoft does actually offer quite a bit of info on the registry and it's all on support.microsoft.com. Not exactly sure what you're looking for, but you may just be able to find it there. Head over to there , and type "REG: entries" in to the Bing search box and hit enter. You'll get like 5000 results, many like these: • REG: Microsoft Mail Entries, PART 2 (102962) - This is the second of three articles on the MS Mail entries; for the other entries, see "Microsoft Mail Entries, Part 1" and "Microsoft Mail Entries, Part

linux - ACL vs standard file permissions - which are used when accessing file?

ACLs and standard file permissions seem to be synchronized: $ getfacl test.cpp # file: test.cpp # owner: scdmb # group: scdmb user::rw- group::rw- other::r-- $ ls -l test.cpp -rw-rw-r-- 2 scdmb scdmb 173 Jan 1 1970 test.cpp However as I've read there are two locations in inode to save file permissions (i_mode field) and these extended file attributes where ACLs are placed. So when I access file then which file permissions are used - standard or ACLs? Or maybe this is the same thing presented in different ways? Answer From the getfacl manpage : The output format of getfacl is as follows: 1: # file: somedir/ 2: # owner: lisa 3: # group: staff 4: user::rwx 5: user:joe:rwx #effective:r-x 6: group::rwx #effective:r-x 7: group:cool:r-x 8: mask:r-x 9: other:r-x 10: default:user::rwx 11: default:user:joe:rwx #effective:r-

Merge two excel files using a common column

I have two excel sheets. I have to merge the two such that the values in one match with the other. For eg. The first excel, the 2nd excel 1 t 1 tes1 2 5 3 tes3 3 t 4 tes4 4 g Notice that in the first column of the 2nd excel, 2 is missing, so I want the first excel to look like this, 1 tes1 t 2 5 3 tes3 t 4 tes4 g I am new to excel. Any help on this will be highly appreciated. Answer I have placed the data from "the first excel" on Sheet1, and "the 2nd excel" on Sheet2. The key to this solution is the VLOOKUP() function. First we insert a column. We then use the VLOOKUP() function to lookup the value of "1" in Sheet2. We specify 2 as the value of the third parameter, meaning we want the value of the 2nd column in the array. Also notice the use of the $ symbols to fix the array. This will be important when we fill down. Note the contents of Sheet2: When we fill the formula down, we get match

macos - Permanently deleting files on Mac OS

A while back, as relatively new Mac OS X user, I was surprised to learn that you cannot easily delete files . Directly, that is, without moving them to the trash first. On Windows and Linux this can obviously be done with ease, but not so on the Mac. I noticed this when trying clear up files from a USB memory stick — removing the files ("move to trash") does not free up space; that happens only after emptying the whole system-wide Trash. Not particularly convenient! (It seems stupid to have to empty the whole trashcan just to make some space on the USB stick. There might be gigabytes of stuff in there, and this sort of defeats its purpose - what if you'd actually need to restore something from the trash some day.) So, what's your way of getting around this ? Have you bought a 3rd party application like RAW Trash for $16.95 just to delete files, or do you diligently empty the trashcan whenever needed? Or did I miss something? Also, can you convince me that this is ac

keyboard - Permanently disable num lock in Windows?

I like to use the number keys for cursor movement. But every so often I hit NumLock by mistake, and then instead of moving the cursor where I want it, I end up with an input like this: 44444488 How can I permanently disable it? Something compatible with the regedit solution for getting rid of Caps Lock given here would be perfect. Answer Here is a hack to disable both caps lock and num lock: Windows Registry Editor Version 5.00 [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Keyboard Layout] "Scancode Map"=hex: 00,00,00,00,00,00,00,00, 04,00,00,00,3A,00,00,00, 00,00,3A,00,00,00,45,00, 00,00,00,00,00,00,00,00 Here is both hacks combined. Numlock disabled + ctrl swapped with caps lock. Windows Registry Editor Version 5.00 [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Keyboard Layout] "Scancode Map"=hex:00,00,00,00,00,00,00,00,04,00,00,00,3A,00,1D,00,1D,00,3A,00,00,00,45,00,00,00,00,00 OK, here is the a scancode map for disabling Numlock. I looked here

windows - Can I rename my User folder name?

My logon name is royin and hence , I have an appropriate folder in : Can I rename this folder to something else ? ( of course - not just rename , but letting the system know that from now on this is the folder). Related info : The real scenario is that I bought a computer with a user named "Admin" and they installed all the soft under this user. and so , I want to change it to royin .

linux - SSH Advanced Logging

I've installed OpenSUSE on my server and want to set ssh to log every command, which is send to system over it. I've found this in my sshd_config: # Logging # obsoletes QuietMode and FascistLogging #SyslogFacility AUTH #LogLevel INFO I guess that both of those directives has to be uncommented, but I'd like to log every command, not only authorization (login/logout via SSH). I just want to know, if someone breaks into my system, what did he do. Answer history does this automatically, login as the user that was logged into through ssh and execute: history It shows the history of commands executed by that specific user. history > command.log will save the history to the file " command.log " More about history : http://en.wikipedia.org/wiki/History_%28Unix%29 and http://compute.cnr.berkeley.edu/cgi-bin/man-cgi?history Command line history should also be stored in .bash_history (file in the user's home directory) when using bash (properly).

Location for Google search and Firefox wrong

On a workstation I administer when ever the user opens Firefox or use Google to search for something both think I am in the Netherlands rather than the US. I have checked the location and language settings in both Firefox and Windows 7 and both are set correctly for US and English. This oddity started at the same time the user picked up "My Security Shield" malware which I was able to remove. Currently both Antivirus and malware scans show the system as clean. Would like to avoid a reinstalling the OS if I can so any help would be appreciated.

terminology - Why are things like Gnome Terminal called "Terminal Emulators" instead of just "Terminals"?

What are they emulating that keeps them from just being terminals? What does a plain-old "terminal" look like, if they are just emulators? Answer A terminal is the end of a line. So, back in the day when the computer was a mainframe serving many user accounts, what you'd be sitting at with your keyboard and display would be a terminal. A terminal emulator is when you're using a computer (a Turing machine) to provide the function of a terminal in software. This usage would typically come up because the computer would be 'imitating' a particular type of terminal in order to communicate with the mainframe. A very popular terminal is/was the VT100 . So if I telnet right now to the server of the local Freenet (if they still exist) I'd be using VT100 emulation. Source and more explanations are in Terminal or terminal emulator? .

windows xp - my mouse scroll wheel doesn't scroll

It's only a minor thing but i can't solve it. I have a ps2 mouse on win xp sp3. the wheel has stopped scrolling in all apps however in apps that support it i can click the wheel and bring up the scrolling four way arrows and scroll that way. I've tried uninstalling the drivers and changing the wheel settings but to no effect. It obviously recognises the wheel since i can click it. Any ideas super users?! Answer The wheel click and wheel rotation are to completely separate sensors. You've got a broken mouse on your hands.

Moved internal hard drive to external USB 3.0 hard drive. Now I can't boot windows

I recently upgraded to an SSD in my laptop. When I removed the old hdd, I placed it in an external enclosure in case I needed to boot from it and restore data. I would like to pull of my power settings to put on my new hard drive from the old install. Dell sets up some sort of settings that gets me far better battery life than the defaults. However, when I boot windows from the USB, I get a BSoD with the 7B error. From my experience, the 7B error comes when you swap IDE/AHCI in BIOS, but as this is USB, those options aren't available. How can I boot windows from my external, failing that, how can I extract a power plan from a non-booted windows.

get antivirus windows commandline

I was wondering if it is possible to get the name of the currently running anti-virus within windows (xp/7/8) commandline? I could use the tasklist commando to view all running processes, but it would also be handy to know if it is possible to just return the name (not the full path per se) of the active anti-virus. Answer If you are using an anti-virus package that properly reports into Windows' Security Centre you should be able to get its name via WMI. This will return a list of all installed AV products from the local machine: WMIC /Node:localhost /Namespace:\\root\SecurityCenter2 Path AntiVirusProduct Get displayName /Format:List Note: I only tested this on Windows 7, so I'm not sure if it will work on XP as-is (should work on Vista+ though).

microsoft excel - VBA Macro to sort and apply conditional formating to a range of cells with dynamic number of rows

I have a range (the image below). Please note that: Range is generated by another application, so number of rows is ever changing, and is not formatted as an Excel 'table' The number of columns, however, is fixed. There is always a Totals row, which is always the last row (cells beyond this however contains formula evaluating to '') I want help with a VBA Macro that will sort the range using header D as key (ascending): [See link to the sorted table below] Please note that: The Totals row (which is always the last row) should be ignored and not sorted. After this sort, I want the same VBA Macro to apply conditional formatting to the range using the same header D as key - the formatting applies a border around the range where D is the same: Final table is here: http://goo.gl/H118Lx Please note that: I don't want border around unique values in header D i.e rows where the cell-value-count is not greater than 1.

windows xp - How can I force certain applications to use specific network connections?

Let's say I have two active network connections that let me out to the internet. I want certain applications to only use Network Connection 1 , while some others should use Network Connection 2 . Is this possible in Windows XP? If so, how can it be done? Answer ForceBindIP - Bind any Windows application to a specific interface (by IP or GUID). ForceBindIP is a freeware Windows application that will inject itself into another application and alter how certain Windows Sockets calls are made, allowing you to force the other application to use a specific network interface / IP address. This is useful if you are in an environment with multiple interfaces and your application has no such option for binding to a specific interface.

microsoft excel - Using the with cURL command-line tool on Mac, What can I do to this script to ask it to fetch stock data which comes back WITHOUT commas?

cd documents/quoteUpdate while true do curl -o quotes.txt -s "http://download.finance.yahoo.com/d/quotes.csv?s=goog,aapl&f=sl1c1p2pt1" echo UPDATED: date sleep 10 done Answer You could use sed to edit quotes.txt. This example changes all commas to a space character (s/,/ /g). A backup of the original file is named quotes.txt.bak. cd documents/quoteUpdate while true do curl -o quotes.txt -s "http://download.finance.yahoo.com/d/quotes.csv?s=goog,aapl&f=sl1c1p2pt1" sed -i '.bak' 's/,/ /g' quotes.txt # replace commas with spaces echo UPDATED: date sleep 10 done

ffmpeg - Conversion from WebM to MP4 in Ubuntu is slow and bad quality

I have used the command ffmpeg -i input.webm -q:v 10 -c:a copy out.mp4 I also tried using avconv instead of ffmpeg. The conversion is successful but the quality is bad. Also it takes a lot of time. It also does not play with Windows Media Player. (The reason for this is the mpegv1 to which the file is converted.) How do I add an option to convert it to mpegv2? Following is the command line output: avconv version 0.8.16-4:0.8.16-0ubuntu0.12.04.1, Copyright (c) 2000-2014 the Libav developers built on Sep 16 2014 18:33:49 with gcc 4.6.3 [matroska,webm @ 0xe737a0] Estimating duration from bitrate, this may be inaccurate Input #0, matroska,webm, from 'test.webm': Duration: 00:00:08.57, start: 0.000000, bitrate: N/A Stream #0.0: Video: vp8, yuv420p, 1536x768, PAR 1:1 DAR 2:1, 1k fps, 1k tbr, 1k tbn, 1k tbc (default) Stream #0.1: Audio: vorbis, 44100 Hz, stereo, s16 (default) [buffer @ 0xee38e0] w:1536 h:768 pixfmt:yuv420p Output #0, mp4, to 'c2.mp4': Metadata:

Why does Windows keep regenerating unneeded .regtrans-ms files in my user folder?

This is a follow-on question from this one . As concluded in that answer, these files are supposedly registry transaction files - files that should have been merged into the registry at some point and can therefore be safely deleted: Once Windows has determined that it's "safe" to write the change to registry, it does so, and following that, it will then verify that the change has been made, at which time it will delete the file and move onto other OS tasks. When something in this process fails, you end up amassing these files. Once you're done analyzing them, any of these .blf or .regtrans-ms files that were created prior to the last system boot can be safely deleted. There's no way they will (or should) be written to the registry, so they're junk. However, after proceeding to remove these files from my system using Unlocker and then rebooting the PC, I've found that even though Unlocker successfully deleted the files, they were simply regenerated in the

mount - Can I change a disk from drive to mounted?

I added a disk to a W2K8R2 machine, and gave it a drive letter: X I want to change that, and mount it as a folder now. Is that even possible? How? Answer I have no server 2008 available to test it, but this is how you do it in windows 7. (Which is mostly the same) Go to disk management Select the partition you want. Right click, change drive letter and paths Remove your drive letter, press ok Right click, change drive letter and paths (back to the previous screen) Add drive letter or path, select *mount in a following empty NTFS folder" Press OK, done. The pictures below show one way to do it. (I am sure there are others, e.g. using the prompt).

windows - Which network connection is used if connect using multiple interfaces

I'm using Windows 7. I connect to the internet using both my Ethernet port and Wifi. How can I know which interface is Windows using to connect to the internet? What if there are even more interfaces, like an additional USB Wifi adapters? Is there a general rule for this? Answer There are two things you need to look at: The routing table (and its default interface). The preferred network settings in windows. The routing tables are easy. Start a shell and (e.g. start run cmd.exe ) and use the command route print . One of the entries will have network destination 0.0.0.0 (that means every destination not explicitly listed). The IP in the column Interface is the IP belonging to the card use to reach the default interface. IPv4 Route Table ====================================================================== Active Routes: Network Destination Netmask Gateway Interface Metric 0.0.0.0 0.0.0.0 192.168.1.252 192.168.1.12 20 I know this is a bit b

windows 7 - How to bond two different internet connections

I have two internet connection, each with 4mbps bandwidth. I want to join/merge both of them to get 8mbps speed, both routers have WLAN and LAN capability. How to Double my speed using two routers? Can I bond two connections in Windows and double my internet connection speed? Any download manager that accepts two internet connection to download?

performance - Why is VNC on Windows so slow?

In a test, I could stream a full HD movie across our network from my friend's computer, no problem. It's as fast as I could want. But VNC is painfully slow. We've tried Real VNC and Tight VNC, I've played around with the Capture Method settings, but nothing seems to make a difference; it's just so slow. Does anyone have any tips on using VNC, on how to improve the speed, or perhaps any alternatives? Is it the nature of not being able to notice invalidated portions of the screen quickly enough, or is there a network thing slowing it down perhaps? We are both using Windows 7. We need to be able to view and control each other's PCs without locking out the host, so RDP will not work (unless someone knows otherwise).

partitioning - Windows 8 displays linux ext4 partitions as RAW

I installed Linux Mint in 2 partitions: / and /home Windows 8 is under UEFI boot mode. How to hide those linux partitions in Explorer? When I click on them: Answer This says how to hide it: http://www.7tutorials.com/how-hide-or-dismount-partition-windows And you can read those partitions in windows with http://www.diskinternals.com/linux-reader/

boot - Not Loading GRUB After Installing Mint and Ubuntu

On a new computer (less than 3 months), I originally installed Fedora 16 to give it to try. I wasn't all that impressed and un-installed it about a month ago and I'm not exactly sure how it happened but I deleted the partition which had grub installed on it, or at least that's what I think happened because when I rebooted my computer It wasn't able to get into any bootloader. Eventually I was able to run the Windows recovery and repair the MBR and I was able to boot back into Windows. Since then I've installed Linux Mint 14 and Ubuntu 12.04, and I can see using the EaseUS software in Windows that the partitions have been succesfully created and there was no problems during the installation process, however when I start up the computer it just goes straight into Windows and not GRUB. I haven't installed a Linux OS for some time but I'm sure the partition set up I used for both Mint and Ubuntu should work. I have 2 x 500gb hard drives - one is purely for data,

.Net Framework 3.5 SP1 on Windows 7 not recognized by installers

Windows 7 Ultimate RTM already comes with the .Net Framework 3.5 SP1 preinstalled. However, some installers like the Azure tools and SDK 1.1 seem to check for it and fail: Windows Azure Tools for Microsoft Visual Studio requires .NET Framework 3.5 SP1. Since the framework is preinstalled there seems to be no way to reinstall or repair it ( see also ). Installed: VisualStudio 2008 SP (9.0.30729.1) VisualStudio 2010 RC (previosly beta) Windows\Microsoft.NET\Framework contains folders for all 1.0, 1.1, 2.0, 3.0, 3.5, 4.0 Any ideas on how to make the installers recognize the 3.5SP1 framework (without reinstalling the OS), or maybe to somehow reinstall it Answer As described here : The promlem has been fixed after HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\NET Framework Setup\NDP\v3.5\SP was set to 1. More info here too (linked in the page above): Also could you check the following two registry keys and let me know what the values are? HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\NET Fra

graphics card - 570 GTX SLI - Amp requirements per 6pin

I see plenty of information telling my decent 850 watt ( XIGMATEK MC NRP-MC851 850W ) will support SLI with two 570 GTX s. However, it's 12+ rails distribution makes me think otherwise: +12V1@18A , +12V2@18A , +12V3@30A , +12V4@30A . Now I know other items such as my CPU ( i7 950 ) change things. My GTX 570 needs two different six pin +12 connections (38A total recommended). Right now I'm running 12V3 and 12V4 and its probably overkill. However, if I add a second GTX, how many amps do I need PER 6 pin connection? For example if bf3 does not fail I plan to over overboard and get 2 590GTX s. I will need to know how to figure out how many amps per 6 pin , not RAIL. For example, if I have 30 amps on one 6pin#1 and 18 amps on the second and the requirement is 50 amps, I could run a single one but if both need to be 50 amps, finding a power supply with 50 amp rails isn't easy. I know the requirement is based on the system whole but how do I find out the requirement per 6 pin s

How do you enable focus follows mouse in Windows 10

I'd like raise-on-click and sloppy focus-follows-mouse on Windows 10 because this is the setup I've been using on Windows and Linux for years. Under Windows 10, I tried the regedit Xmouse changes mentioned in this link that were originally meant for Windows 8: http://winaero.com/blog/turn-on-xmouse-active-window-tracking-focus-follows-mouse-pointer-feature-in-windows-8-1-windows-8-and-windows-7/ However, I experienced the following issues: When you open the Start Menu by pressing the Windows key, it doesn't receive keyboard input. When you open Start, Search or Notifications by clicking on them, they close before you can interact with them. Is there anyway to get usable focus follows mouse? Is anyone successfully using Win10 like this?

keyboard - Windows 7 - Change Region and Language settings using a script

OS: Windows 7 64-bit I have a machine that has had its "Region and Language" settings all set to "Canada" . What I need to do is change all those settings to revert back to the default of "United States" . Additionally, I want to create a script to do this, as I expect to run into more machines with this issue. I don't want to have to change settings through the GUI on every machine. I need to do these actions on these tabs: Region and Language (Format)- I need "Format" changed to "English (United States)" Region and Language (Location)- I need "Current Location" set to "United States" Region and Language - Text Services and Input Language (General)- I need to delete all keyboard languages except for "English (United States) - US" Region and Language (Administrative)- Here I believe that "non-Unicode programs" will also have to be set to "English (United States)" (I have screensh

linux - emerge complains about blocked packages: what do I do?

We have an old development server running Gentoo at work. I would like to update this system, but I keep running into problems with the packaging system. To me, it seems like there are dependencies on several versions of various packages, and I cannot see how to fix it. The biggest problem is probably relating to Python and Portage. I need a newer portage, but there seems like there are cyclical dependencies going on. I have tried various solutions, but not quite sure to go from here. Any clues that might get me further in fixing it? Further information The following is the (relevant bit of the) output from running emerge --update --newuse --deep @world (lots of normal output ....) [ebuild U ] app-misc/mc-4.7.0.3 [4.6.1-r4] USE="edit%* -slang*" .... [blocks B ] >=dev-lang/python-2.6.6 (">=dev-lang/python-2.6.6" is blocking sys-apps/portage-2.1.6.7) [blocks B ] [blocks B ] * Error: The above package list contains packages which cannot be * ins