• Products
    • DESIGN MODELS AND DATABASES
      • ER/Studio Data Modeling Tools
      • DB PowerStudio
      • Aqua Data Studio
      • All DESIGN Products >>
    • MONITOR DATABASE PERFORMANCE
      • SQL Diagnostic Manager for SQL Server
      • SQL Diagnostic Manager for MySQL
      • Precise for Oracle, Db2, and Sybase
      • All MONITOR Products >>
    • PROTECT DATABASE INTEGRITY
      • SQL Compliance Manager
      • SQL Secure
      • SQL Safe Backup
      • ALL PROTECT Products >>
  • Free Tools
    • DESIGN DATABASES
      • SQL Data Profiler
      • Rapid Database Extractor
    • PROTECT DATABASE INTEGRITY
      • SQL Permissions Extractor
      • SQL Column Search
    • MANAGE DATABASES
      • PowerShell Scripts for SQL Server
      • PowerShell Plus
      • Free Tool Support
    • MONITOR DATABASE PERFORMANCE
      • SQL Check
      • SQL Query Store Optimizer
  • Solutions
    • FOR ENTERPRISES
      • Database Monitoring
      • Diagnostics Solutions
      • Security Solutions
      • Data Governance
      • Compliance
      • IT Performance
    • FOR DATABASES
      • SQL Server
      • Oracle
      • Sybase
      • DB2
      • MySQL
      • Multi Platforms
    • FOR CLOUD SERVICES
      • Cloud
      • Amazon RDS & S3
      • Azure SQL Database & Blob Storage
      • Google Database Service
      • Oracle MySQL Cloud Service
      • Snowflake
    • FOR APPLICATIONS
      • Application Performance
      • .NET(including SharePoint)
      • PeopleSoft
    • FOR DATA FABRIC
      • ER/Studio
      • Wherescape
      • Qubole
  • Resources
    • SUPPORT
      • Support Plans
      • Product Support
      • Product Documentation
      • Trial Support
      • Legal
    • RESOURCES
      • Resource Center
      • Blog
      • News
      • Partners
    • EVENTS
      • All Events >>
      • Newsletter Signup
  • Contact Sales
  • Customer
  • BUY NOW
  • FREE TRIALS


Retrieve Yesterday’s Error Events

by ps1Nov 1, 2011

To retrieve all error events from a system log that occurred yesterday, here is how to calculate the start and stop times:

PS> $end = Get-Date -Hour 0 -Minute 0 -Second 0
PS> $start = $end.AddDays(-1)
PS> Get-EventLog -LogName System -EntryType Error -Before $end -After $start

Twitter This Tip!
ReTweet this Tip!

Tags

Aqua Data Studio cloud compliance data architect data architecture database database administration database management database monitoring database performance database tools data governance data modeling DBA DBArtisan diagnostics ER/Studio ER/Studio Data Architect ER/Studio Enterprise Team Edition events IDERA interbase Microsoft SQL Server monitoring Monyog MySQL news Oracle performance Precise product updates Rapid SQL Release releases SQL SQL Compliance Manager SQL Diagnostic Manager SQL Diagnostic Manager for MySQL SQL Diagnostic Manager for SQL Server SQL Doctor SQL Safe Backup SQL Secure SQL Server Uptime Infrastructure Monitor webinar
Products

Store

Support

Resources

Legal

Privacy Policy

About Us

Idera, Inc

Customer

Partner

Contact Sales

Newsletter Signup

Join our email list and receive the latest case studies, event updates, product news, and much more.

  • 
  • 
  • 
  • 

Copyright © 2004-2023 IDERA, Inc.