Jump to content

Martin Stevnhoved

Members
  • Posts

    205
  • Joined

  • Last visited

Posts posted by Martin Stevnhoved

  1. Have you looked in to this?

    It looks like a very easy quickfix for you, and would help us a lot.

    Put two new options in SQL Server config. One for how old a full/differential backup is allowed to be, and one for how old the log backup is allowed to be.

    Then loop through the databases (except tempdb)  and check for last backup time for all databases and last log backup for databases not in "simple" recovery mode.

    Last full or differential backup (for model db as an example)

    SELECT        TOP (1) database_name, backup_finish_date
    FROM            msdb.dbo.backupset
    WHERE        (type IN ('D', 'I')) AND (database_name = N'model')
    ORDER BY backup_finish_date DESC

    Last log backup (for model db as an example)

    SELECT        TOP (1) database_name, backup_finish_date
    FROM            msdb.dbo.backupset
    WHERE        (type = 'L') AND (database_name = N'model')
    ORDER BY backup_finish_date DESC

    You could also look at the databases create time, so we don't get notified because the first backup hasn't run yet.

  2. Hi.

    When receiving the notification "The computer 'XXX' in group 'XXX' is shutting down" I am always wondering who is shutting down the server.

    Could it be possible to add information about which user initiated the shutdown? I know that Windows write it to the eventlog, so the information should be available. 

    If it could possible to match the users with RDP connections, so we also can see what client the user was connected from, it would something near perfect.

    • The computer 'XXX' in group 'XXX' is shutting down by user 'XXX' logged on interactively.
    • The computer 'XXX' in group 'XXX' is shutting down by user 'XXX' logged on remotely from client 'XXX'.
  3. Hi Paul.

    Perhaps you could give me a quick example.

    I have the same challenge with DateTimeInputItem.

    System.DateTime datelocal = System.DateTime.Now;
    System.DateTime dateutc = datelocal.ToUniversalTime();
    
    Groups result = new Groups();
    Group group = new Group("More Information");
    group.Items.Add(new DateTimeInputItem("local", datelocal.ToString()));
    group.Items.Add(new DateTimeInputItem("utc", dateutc.ToString()));
    result.Add(group);

    When running the above on a server in UTC+8 and showing it on a mobile device in UTC+1 it gives me the attached result.

    I would like a function that converts the time to the mobile device Time Zone.

    Annotation 1 is my phones local time (UTC+1)
    Annotation 2 is the servers local time (UTC+8)
    Annotation 3 is the servers universal time (UTC)

    Br, Martin.

     

     

    2016-11-12 13_44_25-2016-11-12 13.38.21.png

  4. #4 is for sanity check. We have came to a volume, where we would like to have a dispacher monitoring the notification list. It would be nice to have him decide when to raise a ticket.

    One example is that when we do windows update patching we have 100+ notifications that we don't want to be created as zendesk tickets. The servers are in maintenace mode durring the update, but in the hour after there is an increased cpu, memory and disk activity that creates a lot of obsolete notifications.

    Br, Martin.

  5. We have ended up by designing a plugin, that gets the time for the last successfully backup in the event log.

    It then raises a notification, if the timespand exceeds our threshold.

    Even though it works fine, we would like to see it as a native module in Pulseway.

  6. Hi,

    We are using the Zendesk-integration, and have some ideas that would improve the integration.

    1. Notify that ticket creation fails. If password is changed or any other things result in Zendesk ticket not being created, we miss it.

    2. Save ticket id on notification. It would be nothing more than fantastic if the notification list in Pulseway would visually show that a ticket was created. If it were possible to se the ticket number, you could also link directly to the Zendesk web app. Did I mention that this would be amazing?!!!

    3. Global Zendesk settings. Today we set up Zendesk account for every server og group. I would be nice if the Zendesk account were a global setting, and that we could just define requester email-address (and notification levels pr. server/group). It would make it a lot easier to update the account settings, and setup new servers or groups.

    4. On demand ticket creation. Today all notification that match the level filter are created as ticket. It would be nice if the settings could differentiate between "automatic" and "manually". Automatic would be the current way, and manually would allow to select "Create ticket" on the notifications in apps and dashboard. 

  7. Are there any way to export the notification archive to a CSV-file from the Enterprise Server.

    Can the support do it for us?

    On ‎26‎-‎08‎-‎2016 at 4:49 PM, Paul said:

    Hi Martin,

    Unfortunately there are no plans on exposing the SQL Servers to the public for security purposes. Check out our REST API documented here, it may already expose the information you're looking for.

    -Paul

    So the only way is to change to an on-premise Enterprise Server? 

  8. Hi,

    I think I have asked for it before, but can not find it. I think it would be very easy for you to implement :-)

    For CPU-notifications we can provide a timespan, but not for memory.
    This gives us a lot of notifications on memory peaks. We would like also to provide a timespan for memory.

    Please consider this a feature request.

    Br, Martin.

    Capture.PNG

  9. When monitoring free space, we are currently using these baselines:

    Disks < 130 GB : Elevated at 15% and Critical at 5%
    Disks > 130 GB : Elevated at 15GB and Critical at 5GB

    Currently that is a manual process, and we need to set it up again if we add new disks.

    We are thinking of implementing a plugin to automatic configure levels for new disks.

    Capture.PNG

×
×
  • Create New...