Server Management Suite

 View Only
  • 1.  Maintenance Window Report

    Posted Apr 13, 2013 10:39 PM

    Hello all.  I've seen a few people ask this, but no definitive answers.  Does anyone know how I can retrieve information about existing maintenance windows?  The view (vMaintenanceWindows) contains basic info, but it does not contain the members.  I've seen 1 person recommend custom inventory using the AltirisAgent_MaintenanceWindow WMI class, which seems easy enough for windows, but what about Linux clients?  All I'm really trying to do is identify clients that do NOT have maintenance windows defined, whether it's through the database or anywhere that I can get the info.  Anyone have an easy means of doing this for both windows and linux?  Am I just missing something really obvious right in front of my face?

    Any advice or feedback would be appreciated, thanks!



  • 2.  RE: Maintenance Window Report
    Best Answer

    Posted Apr 14, 2013 04:33 PM

    Hi brp,

    Using the following is posible to query Computers with and without Maintance Windows applied. This query can be adapt to your needs.

    select
    vc.name [Computer Name],
    vc.Domain,
    vc.[IP Address],
    vc.[OS Name],
    vmw.Name [Maintenance Window],
    vmw.Description,
    vpa.[Enabled]
    from vMaintenanceWindows vmw
    join vPolicyAppliesToResource vpa on vmw.Guid = vpa.PolicyGuid
    full outer join vcomputer vc on vpa.ResourceGuid = vc.Guid
    order by vc.Name 

    Regards,

    Fábio Sanches



  • 3.  RE: Maintenance Window Report

    Posted Apr 14, 2013 07:00 PM

    Fábio, this is perfect.  Thank you, I appreciate the help!