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 TouchToneTommy 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: *

  • Users: itsmythg
  • Content: Threads
  • Order by date
  1. itsmythg

    Write record for empty AD Group

    I have this VBscript that searchs AD for specific AD Groups. what it does is list users in group it suppose to print the group name [fh.writeline ";;;Groupname"'] if the group is empty but its printing group name for every group. I'm lost as to how to get it only to print when group is empty...
  2. itsmythg

    Access 2007 send email using FORM record

    I currently have a 2007 Access db i use to audit VPN user information. At this time i call a module that opens a report running a query tat requests ID# then opens a word doc with user information and instructions. Trying to eliminate some steps. I would like to after entering my form...
  3. itsmythg

    VB Script adding text to end of line of output from AD Query

    The script below queries Active directory looking for a specific security group it works great, but what i want is for it to write the name of the group to the end of every line it creates. EXAMPLE Hoffa, Jim xxxxxxx myadgroup1 the myadgroup1 i want to add to every line of this group query...
  4. itsmythg

    Access 2007 shortcut MAM

    Trying to create Shortcut MAM with Access 2007 Macro to run thru Task scheduler. I have done this a 1000 times in access 2003, cannot figure it out in 2007. Any help would be greatly appreciated. Thanks Roxanne
  5. itsmythg

    Query to Break Table Data down into more fields

    I have a table that has data i want to parse out part of for a separate column in the query. THE LINE READS; IPSec ESP Tunnel Inb: Packet authentication failed username: xxxxxx\xxxxxx SPI: ttttttt. Dump of failed hash follows. I WROTE; IIf(InStr([Detail1],"authentication...
  6. itsmythg

    using outlook form fields in email

    ok i have stolen enought code to get to the place i can create an email with a custome message but i am stuck at trying to add some information from some of the fields in my database. I need to add the data in field called networkid and others. Private Sub Command20_Click() Dim...
  7. itsmythg

    format email sender info

    i am sending this email all is working but i want it to always send from this spcific email address. i cannot seem to get the format right. SenderEmailAddress = myname.company@com
  8. itsmythg

    How do i create multipule lines in body of html VBA email

    ok I am stuck here and i am sure this is something so simple i am missing it. I would really appreciate some input. I am creating an email i send out of a access database to notify users of acces. I can get it to work with one exception, only get one line of data. i would like to have 2...
  9. itsmythg

    Send report via email not as attchment using email address in table.

    this problem may have already been addressed but after hours of looking thru these posts, I havn't found one that is clear enough for me to understand, being that i am a little slow about understanding unless i see my field names in the code. i have decided to post my question. i have an Report...
  10. itsmythg

    time calculation in access

    i have a log that i am running reports against it has a field, "Time" data is import as date/time shows in table as 01:00:00 i need to run a report only showing the last 24 hours of activity. I would really appreciate help with this.
  11. itsmythg

    vbscript to parse data out of file

    ok this site has been so helpful in the past will ask for help again. I am trying to a log from our cisco concentrator and parse out the information looking for all failed logon attemps. years ago i wrote pearl scripts like this but the cobwebs won't clear and since i am using a access...
  12. itsmythg

    Help parsing data sql code needed

    I am trying to read some vpn logs, I import the date but only get 3 columns because of the limitation of importing into access. I don't want to use excel to parse because I would like to automate the process for reports. I need to parse the information in the 3rd column. I think what i need...
  13. itsmythg

    Using Left in a query to compare data in 2 Tables

    =Left([Employee]![FirstName],4)=Left([Earthlink]![FirstName],4) I am trying to pull information from 2 tables to create a new combined data Table. this returns no data and that I know is wrong.
  14. itsmythg

    Mapping Drive Thru Cisco VPN and Sygate Firewall

    I connect to my company over a Broadband direct connection on xp, (problem existed on 98 too). We use Cisco VPN to connect with company servers. I can logon too Unix, IBM Main Frame and get my mail via Outlook. I can ping the public server, but cannot map to any folders. I get the message...
  15. itsmythg

    How do I modify what the kernel writes to the pacct files

    I am doing system utilization analysis on Sun Solaris 2.5 and 2.6. The accounting system provides good data but it does not give ppid and pid information. The accounting system makes a seperate entry for every command entered. I need to be able to group these commands by jobs/scripts. I...
  16. itsmythg

    repeating ps command every 10 secs

    I am writing a script to collect system usage data. I want to repeat the ps command every 10 seconds. How can I do that? open (out, &quot;> system_util.txt&quot;); open(PSEF_PIPE,&quot;ps -ef|&quot;); while (<PSEF_PIPE>) { chomp; @psefField = split(' ', $_, 8); $pid[$i]...
  17. itsmythg

    Why do I only get 1 line of data output

    I am working on collecting system usage data. I have the following perl script that works, except it only reports the last line of data only. sub getPsefData { open(PSEF_PIPE,&quot;ps -ef |&quot;); $i=0; while (<PSEF_PIPE>) { chomp; @psefField = split(' '...
  18. itsmythg

    Need to subtotal columns of a file

    My problem is I am an administrator not code writer, but I need to total the columns in some data I am pulling out of the system accounting files. Basicly I am cutting out those processes I am interested in and writing to a file i need to total colum 5 and 6 of the files to total processor time...
  19. itsmythg

    How do I add a date to a unix file that is yesterday's date?

    I need to modify the name of a file to the variable of the date of the file, that date is always the day before the file was created as part of cron started job. this is the script I am using. echo `date '+%m%d'`| read mydate cat pac | sed &quot; s/$/ ${mydate} /g&quot; > /xxxxx/pacct${mydate}

Part and Inventory Search

Back
Top