• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 946
  • Last Modified:

logparser select from security does not work on vista ???

    to_date(timegenerated) AS Date,
    quantize(to_time(timegenerated), 3600) AS Hour,
    Count(*) AS Number_of_Events
FROM Security
WHERE EventID=528
    AND date='2004-09-01 00:00:00'
GROUP BY date,

W:\sqlparser>logparser.exe file:DetailingUserLogins.sql -i:EVT -o:datagrid
Task aborted.
Cannot open <from-entity>: Error opening event log "Security": Dem Client
  fehlt ein erforderliches Recht.

Elements processed: 0
Elements output:    0
Execution time:     0.01 seconds

  • 2
1 Solution
Dem Client fehlt ein erforderliches Recht.  translated to English The client is missing a required legal

Run the command prompt as administrator.  

the user calling logparser does not have proper permissions to read the events, try with user administrator (as usual in windoze:)
hgraesslin1Author Commented:
well, I do not found any administrator on my vista box. Unfortúnately my login user is Administrator, or lets say belongs to the administrator group. I think the security model in vista has changed, so I need to run a command shell using the runas command in cmd.
runas /user:Administrator cmd
Geben Sie das Kennwort für "Administrator" ein:
Es wird versucht, cmd als Benutzer "HANS-SENYO\Administrator" zu starten...
RUNAS-FEHLER: cmd kann nicht ausgeführt werden
1327: Anmeldung fehlgeschlagen: Benutzerkontenbeschränkung. Mögliche Ursachen hierfür: leere Kennwörter sind nicht zuläs
sig, Anmeldezeitbeschränkungen, oder eine Richtlinienbeschränkung wurde angewendet.

I just changed the password of the administrator ???
Yes the security model has changed.  Even a user in the adminstrators group must be 'elevated' to adminsitrative label while running.  

Start / All Programs / Accessors / Right click on Administrator
Click Run as Administrator


Featured Post

The Lifecycle Approach to Managing Security Policy

Managing application connectivity and security policies can be achieved more effectively when following a framework that automates repeatable processes and ensures that the right activities are performed in the right order.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now