Auditing using WinAudit

Hello:

I'm using WinAudit to audit 4000 machines in my district. I'm trying
to audit it using an SQL db. I don't want to have to use a File DSN,
but if I have to I will. I've tried the command line
winaudit /r=g /o=ODBC /f=DRIVER=SQL Server;SERVER=<servername>;uid=inv
;DATABASE=<database>; /l=log.txt

But checking the log, I error out with an application error. Anyone
else having this problem that might be using WinAudit?

S
Wed Jun 20 12:03:47 CDT 2007

im curious... when you saw that the name of this group was VBSCRIPT, what
made you continue to post?



<milnesy@gmail.com> wrote in message
news:1182356343.576665.193020@n60g2000hse.googlegroups.com...
> Hello:
>
> I'm using WinAudit to audit 4000 machines in my district. I'm trying
> to audit it using an SQL db. I don't want to have to use a File DSN,
> but if I have to I will. I've tried the command line
> winaudit /r=g /o=ODBC /f=DRIVER=SQL Server;SERVER=<servername>;uid=inv
> ;DATABASE=<database>; /l=log.txt
>
> But checking the log, I error out with an application error. Anyone
> else having this problem that might be using WinAudit?
>

milnesy
Wed Jun 20 13:44:05 CDT 2007

On Jun 20, 1:03 pm, "S Moran" <s...@moran.com> wrote:
> im curious... when you saw that the name of this group was VBSCRIPT, what
> made you continue to post?
>
> <miln...@gmail.com> wrote in message
>
> news:1182356343.576665.193020@n60g2000hse.googlegroups.com...
>
>
>
> > Hello:
>
> > I'm using WinAudit to audit 4000 machines in my district. I'm trying
> > to audit it using an SQL db. I don't want to have to use a File DSN,
> > but if I have to I will. I've tried the command line
> > winaudit /r=g /o=ODBC /f=DRIVER=SQL Server;SERVER=<servername>;uid=inv
> > ;DATABASE=<database>; /l=log.txt
>
> > But checking the log, I error out with an application error. Anyone
> > else having this problem that might be using WinAudit?- Hide quoted text -
>
> - Show quoted text -

Because there is a thread in this newsgroup that references
WinAudit. And since that thread was active (last reply June 2nd) I
was hoping that those who posted would read this post and then I could
bring it offline. And then, on top of that, I Was hoping to
transition this into vbscript for logons.

So, next time you want to chastise me for posting to this newsgroup, I
would appreciate it that you ask me offline and not in the usenet
group so you don't look like an ass.

S
Wed Jun 20 14:36:40 CDT 2007

you should make yourself clear then. you should have explained all of that
in your original post then maybe YOU wouldnt have looked like the ass.



<milnesy@gmail.com> wrote in message
news:1182365045.412298.180110@o61g2000hsh.googlegroups.com...
> On Jun 20, 1:03 pm, "S Moran" <s...@moran.com> wrote:
>> im curious... when you saw that the name of this group was VBSCRIPT, what
>> made you continue to post?
>>
>> <miln...@gmail.com> wrote in message
>>
>> news:1182356343.576665.193020@n60g2000hse.googlegroups.com...
>>
>>
>>
>> > Hello:
>>
>> > I'm using WinAudit to audit 4000 machines in my district. I'm trying
>> > to audit it using an SQL db. I don't want to have to use a File DSN,
>> > but if I have to I will. I've tried the command line
>> > winaudit /r=g /o=ODBC /f=DRIVER=SQL Server;SERVER=<servername>;uid=inv
>> > ;DATABASE=<database>; /l=log.txt
>>
>> > But checking the log, I error out with an application error. Anyone
>> > else having this problem that might be using WinAudit?- Hide quoted
>> > text -
>>
>> - Show quoted text -
>
> Because there is a thread in this newsgroup that references
> WinAudit. And since that thread was active (last reply June 2nd) I
> was hoping that those who posted would read this post and then I could
> bring it offline. And then, on top of that, I Was hoping to
> transition this into vbscript for logons.
>
> So, next time you want to chastise me for posting to this newsgroup, I
> would appreciate it that you ask me offline and not in the usenet
> group so you don't look like an ass.
>

milnesy
Wed Jun 20 15:34:50 CDT 2007

On Jun 20, 3:36 pm, "S Moran" <s...@moran.com> wrote:
> you should make yourself clear then. you should have explained all of that
> in your original post then maybe YOU wouldnt have looked like the ass.
>
> <miln...@gmail.com> wrote in message
>
> news:1182365045.412298.180110@o61g2000hsh.googlegroups.com...
>
>
>
> > On Jun 20, 1:03 pm, "S Moran" <s...@moran.com> wrote:
> >> im curious... when you saw that the name of this group was VBSCRIPT, what
> >> made you continue to post?
>
> >> <miln...@gmail.com> wrote in message
>
> >>news:1182356343.576665.193020@n60g2000hse.googlegroups.com...
>
> >> > Hello:
>
> >> > I'm usingWinAuditto audit 4000 machines in my district. I'm trying
> >> > to audit it using an SQL db. I don't want to have to use a File DSN,
> >> > but if I have to I will. I've tried the command line
> >> >winaudit/r=g /o=ODBC /f=DRIVER=SQL Server;SERVER=<servername>;uid=inv
> >> > ;DATABASE=<database>; /l=log.txt
>
> >> > But checking the log, I error out with an application error. Anyone
> >> > else having this problem that might be usingWinAudit?- Hide quoted
> >> > text -
>
> >> - Show quoted text -
>
> > Because there is a thread in this newsgroup that references
> >WinAudit. And since that thread was active (last reply June 2nd) I
> > was hoping that those who posted would read this post and then I could
> > bring it offline. And then, on top of that, I Was hoping to
> > transition this into vbscript for logons.
>
> > So, next time you want to chastise me for posting to this newsgroup, I
> > would appreciate it that you ask me offline and not in the usenet
> > group so you don't look like an ass.- Hide quoted text -
>
> - Show quoted text -

I could continue this "debate" of who's an ass or not, but honestly I
don't care. I asked for help, and you've provided nothing. So I
appreciate it. Really. I do. Now if you don't have anything
constructive to say, I'd appreciate you not continuing this thread.
Thanks.

mycow
Wed Jun 20 20:29:00 CDT 2007

<milnesy@gmail.com> wrote in message
news:1182356343.576665.193020@n60g2000hse.googlegroups.com...
> Hello:
>
> I'm using WinAudit to audit 4000 machines in my district. I'm trying
> to audit it using an SQL db. I don't want to have to use a File DSN,
> but if I have to I will. I've tried the command line
> winaudit /r=g /o=ODBC /f=DRIVER=SQL Server;SERVER=<servername>;uid=inv
> ;DATABASE=<database>; /l=log.txt
>
> But checking the log, I error out with an application error. Anyone
> else having this problem that might be using WinAudit?
>

I'll provide you some help.... I tried your command and got the same
Application Error.

When I included the string "PWD=;" in the connection string it worked.

Even if your password is blank you still have to provide the definition in
your connection string.

Also, the user you logon with must have CREATE TABLE privileges if the table
WinAudi2 is missing or if the table has already been created then the user
must have SELECT and INSERT privileges.