Previous Next

Thread: First time user need help with parsing log

Last post 07-24-2008 7:08 PM by fmora. 2 replies.

Average Rating Rate It (5)

RSS

Page 1 of 1 (3 items)

Sort Posts:

  • 07-24-2008, 4:02 PM

    • fmora
    • Not Ranked
    • Joined on 07-24-2008, 3:47 PM
    • Posts 2

    First time user need help with parsing log

    I'm running Logparser against the System log.  I'm trying to get a list of the users that are printing to this print server.  I'd like to pull a list of the usernames and the printer names they are printing too.  Does anyone know if this is possible?  I've been trying to pull this information but I haven't had any luck.  I would appreciate any help or suggestions.

     Thanks!

  • 07-24-2008, 4:14 PM In reply to

    Re: First time user need help with parsing log

    I am assuming this is just one print server?

    select
     substr( TO_STRING( TimeWritten, 'MM-dd-yyyy' ), 0, 10 ) As Date,
     extract_token(Strings,2,'|') As SSID,
     extract_token(Strings,3,'|') As PrinterName,
     extract_token(Strings,5,'|') As Size,
     extract_token(Strings,6,'|') As PageCount,
     extract_token(Strings,1,'|') As DocumentPrinted
    into PrintAudit.csv
    from \\printserver\system
    where (EventID = 10)
    and (SourceName = 'Print')
    --change date range if you need
    and (TimeGenerated > to_localtime( sub( system_timestamp(), timestamp('0000-01-31', 'yyyy-MM-dd') ) ))

     

  • 07-24-2008, 7:08 PM In reply to

    • fmora
    • Not Ranked
    • Joined on 07-24-2008, 3:47 PM
    • Posts 2

    Re: First time user need help with parsing log

    You're the best, just want I was looking for.

    Thank you!

Page 1 of 1 (3 items)
Page view counter