• Custom Dashboards and Reports in Foglight 7

    Foglight 6 development switched to using Angular for UI components. Examples of these are Alarm Templates, Notification Channels, Audit Log and the fantastic enterprise SQL view Query Insights.

    One thing that is not in the new UI is the ability to create…

  • Alerting when Foglight Data Collection has a Problem

    I was asked recently if there are any alerts when Foglight has a problem collecting data.

    The answer is, there are several ways.

    For SQL Server, there is a rule named "DBSS-Collection Status" that can be managed via alarm templates and notification channels…

  • Setting Different Thresholds for Tablespaces

    We're often asked how to create an alarm threshold exception for certain types of objects. Using the Databases -> Configure Alarms dashboard, you can change thresholds at the instance level. That works great when there is a 1:1 relation between the instance…

  • Exploring User Level Access for Databases

    I recently worked with a customer on the following use case. They've successfully integrated Active Directory logins with Foglight and wish to match up an AD Group with a group on the Databases dashboard in order to implement User Level Access (ULA).…

  • Getting the "All Clear" from Foglight

    A customer asked how to implement and email that indicates an alarm has been cleared. In Foglight, there are typically several ways to do that. 

    In this post, we'll look at creating a new rule that fires when an alarm event occurs. The event we'll focus…

  • Automating Alarm Blackouts in Foglight

    There are two ways to manage blackouts in Foglight - from the UI and from the command line. The options are generally the same. The command line provides us the ability to automate the blackout by using the command line utility in our maintenance scripts…

  • Can you believe this Administration?!

    What’s that you say? You think it may not be appropriate that a technology blog dive into politics?

    Agreed. Instead, this blog highlights the breadth of Administration capabilities available in Foglight for Postgres.

    Administration options are available…

  • Introduction to UI Queries in Foglight

    Think of a UI Query as a shortcut to data that you can use in a report, dashboard, service definition, etc. This post will show how to get started building queries. 

    The example today will be to get a list of all SQL Server Agent Jobs, regardless of the…

  • Groovy, groovier, grooviest: Getting metrics collected by Foglight

    What if you could get a list of all metrics and observations collected by Foglight, and have the ability to filter/sort by cartridge and topology type? That would be groovy.

    My colleague developed the script below. To run it, navigate to Administration…

  • My Foglight License Expired - Now What?

    In some cases, you might need to update or add in a new license key for Foglight. It's really easy to do, but you'll need to be a Foglight administrator.

    Start by navigating to the Administration dashboard, and select Licenses. 

    Next select "Install…