4 Replies Latest reply on Nov 26, 2013 6:30 AM by alexslv

    SELECT * FROM NODES WHERE APPLICATION_TEMPLATE <> BLA_BLA_BLA (for compliance reasons)

    alexslv

      Attention! Challenge Below!

       

      As suggested by aLTeReGo, in response to my question in general SAM forum - Report On Nodes Without Particular Application Template Assigned  - I am posting this question now here in hope that some of you may help me to come up with SQL query.

       

      Basically I have set-up a couple templates and I just need to make sure that all windows based machines have this template assigned. We have servers being added to SolarWinds quite often and it is useful to know if any newly added machines are not yet fully compliant and need additional monitoring templates.

       

      It would also be great to make this query more universal so that it can be used for other type of nodes. I would say if we can define Node Type as CONST1 and Template Name as CONST2 - that would probably do

       

      Thank you all for your help and good luck with SQLing

       

      --

      Alex