Finding Recently Logged on Users



I have several servers and I want to find the last dozen or so users
that logged in. I can query on event log ID 528 in the security log,
but I want to exclude the nt authority \ network service, nt authority
\ local service and nt authority \ system info from showing up. I
use the following WMI Query.:

"SELECT * FROM Win32_NTLogEvent WHERE LogFile = 'Security' AND " & _
"EventCode = 528 AND User <> 'NT Authority\\Network Service

The above excludes NT Authority \Network Service, but I'm not sure how
to query and exclude the other user ID's.

Of course if someone already has a better way of going about this,
feel I'm more than willing to try that.

.



Relevant Pages

  • Re: How to combine existing collections to include or exclude...
    ... Here is a working query: ... machines to exclude, the primary collection would be modified as well. ... Servers you want minus the ones you don't want ... Add computers you don't want to show up in Collection B ...
    (microsoft.public.sms.admin)
  • RE: filter for values in another table
    ... But you indicated that you wanted to exclude all of the values where the ID ... SELECT TableA.* ... Would I just enter all of the ids into the parenthesis? ... runs is to create a query that some people call a "frustrated outer join". ...
    (microsoft.public.access.queries)
  • Safe(?) .ida vuln. testing for IIS 4.0
    ... Subject: Safe.ida vuln. ... vulnerability in IIS 4.0. ... Nothing in the event log. ... Error 0xc0000005 caught while processing the query ...
    (Bugtraq)
  • Re: Help with counting only one time
    ... You want to exclude all but the first row for each order? ... In the following example, I will assume there is a primary key field named ID, and the table is called Table1. ... but I am clueless on what to do in the query even ...
    (microsoft.public.access.queries)
  • Re: Criteria & <>
    ... "Ken Snell MVP" wrote: ... created a query where I had to put the same basic criteria in both fields. ... exclude certain records. ...
    (microsoft.public.access.queries)