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

SELECT
    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,
    hour

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.

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



hgraesslin1Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

DebugNTCommented:
Dem Client fehlt ein erforderliches Recht.  translated to English The client is missing a required legal

Run the command prompt as administrator.  


0
ahoffmannCommented:
the user calling logparser does not have proper permissions to read the events, try with user administrator (as usual in windoze:)
0
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.
But...
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 ???
0
DebugNTCommented:
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

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
System Utilities

From novice to tech pro — start learning today.