Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. macubergeek

    removing parens

    when I do arp -a I get this kind of output: (192.168.1.1) (192.168.1.5) (192.168.1.100) (192.168.1.101) (192.168.1.255) All I want to do is to remove the parens and keep the ip address. I've tried this with sed and gotten nowhere. sed 's/\(//g'
  2. macubergeek

    Left Join?

    I have this query against database nessus table results: select count(risk) as "Subtotals:",risk as "Risk Level" from results group by risk; select count(risk) as "Subtotals:",risk as "Risk Level" from results group by risk; and it returns: Subtotals: Risk Level 36 2 304...
  3. macubergeek

    Want to make a small tweak

    I currently have a script that works fine. It loads file A into an array. It then searches for each line in @A in file B. It then reports back to me which lines in @A that id DOESN'T find in file B. I'm printing out these results with: print FH (@aonly, $item); ------------------------- The...
  4. macubergeek

    Delete every row

    I'm trying to figure out the sql syntax to delete every row from a specified table. I don't want to drop the table just clean out every row... I've tried: DELETE * FROM TABLE_NAME; DELETE * FROM TABLE_NAME WHERE id NOT NULL; no luck. Can someone give me a shove in the right direction?
  5. macubergeek

    mysql on macos x

    I'm having trouble adding records to a database in mysql on macos x. Just some background: I loaded the database from a mysqldump file taken off a windows box. database is named lookup with tables: ports, icmp and icmpcode. I have two users jamesk and root here are the grants...
  6. macubergeek

    $ARGV[0] in mysql query

    I'm having a problem with line 26. As you can see I'm trying to pass the value of Port as $ARGV[0] on the command line: ------------ CODE 1 #!/usr/bin/perl 2 ################ 3 ## 4 ################ 5 use DBI; 6 use strict; 7 8 ###############...
  7. macubergeek

    SQL placeholder passed on command line in Perl

    I'm having a problem with line 26. As you can see I'm trying to pass the value of Port as $ARGV[0] on the command line: ------------ 1 #!/usr/bin/perl 2 ################ 3 ## 4 ################ 5 use DBI; 6 use strict; 7 8 ############### 9...
  8. macubergeek

    data load formatting problem.

    Hi all I did a data load from infile to load a bunch of records into a database from a text file. They all loaded ok but I've run into this weird formatting glitch: mysql> select * from ports where description like "%SQL*Net 1%"; +----------+------+--------------------------+ | Protocol | Port |...
  9. macubergeek

    Union Problem.

    Here is my original query: USE nessus; SELECT count(risk) AS "Serious Risk:" FROM results WHERE risk = 1; SELECT count(risk) AS "High Risk:" FROM results WHERE risk = 2; SELECT count(risk) AS "Medium Risk:" FROM results WHERE risk = 3; SELECT count(risk) AS "Medium Low Risk:" FROM results WHERE...
  10. macubergeek

    Grepping a file for patterns in an array.

    I have a file which contains a series of strings, with a comma seperated value like 0 or 1 or enabled, disabled. 1. I am loading this file into an array like so: open(STUFF, "stuff.txt") || die("Could not open file!"); my @master=<STUFF>; close <STUFF>; 2. stuff.txt has the following text...
  11. macubergeek

    Creating Custom Template

    Hello all I've been creating a custom security template and I've had no problems following the instructions and creating one. I've been able to find and configure all the settings EXCEPT for the ones listed below. I'll be darned if I can find them in the mmc console (under the template I've been...
  12. macubergeek

    User Rights and File Permissions

    I'm trying to automate the auditing of Win2003 User Rights and File Permissions. Can anyone point me in the direction of tools/commands/scripts to do this?
  13. macubergeek

    column width problem

    Currently I have a database where one column is at maximum width about 255 bytes. That column comes out as one single looooong line. I'd like to reformat this column in SELECT statements to output with the contents line wrapped at say 50 bytes. I've been reading the Dubois book and the mysql...
  14. macubergeek

    printing column from an array

    I've read a file into an array this way: open(DAT, "combined.nbe") || die("Could not open file!"); my @nessusdata=<DAT>; close DAT; The array consists of a thousand lines with 7 fields each line, deliminated with the pipe "|" symbol. How do I print column 2 and 5 from this array?
  15. macubergeek

    Parse::Nessus::NBE

    Hi all I'm trying to write a script using the above perl module and am having difficulties. I'm trying to read a file "combined.nbe" into array @mynessusdata then parse it using this perl module. ----------------my code------------------- #!/usr/bin/perl open(DAT...
  16. macubergeek

    dumping User rights and file permissions from Windows 2003

    Hello all I'm trying to figure out how to dump the User Rights section and File Permissions out of the Security policy of Windows 2003 server. I thing there is a flag to the secpol command that will dump them out but can some one give me the syntax to dump out the above two sections to a text file?
  17. macubergeek

    configure factory-default

    I have a 501 Pix firewall with 3DES support. My question is if I run this command will I blow away my 3des support key in addition to resetting the box to factory defaults? If it will, how do I dump the 3des license key beforehand and how would I reenter it afterwards?

Part and Inventory Search

Back
Top