This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Report On Nodes Without Particular Application Template Assigned

Hi All,

How can I configure filters in reports to be able to get a list of all Nodes without specific application template being assigned (I just want to occasionally check to ensure all nodes have particular template assigned for compliance reasons)

I am using web-based reporting in SAM 6.0

Thanks,

Alex

  • I would use a Custom Property for the nodes and use that Property in the report criteria.

  • This basic report criteria defined below will list all nodes that don't have an application template that contains the word "Windows" assigned.

    Report Fields.png

    Report Filter.png

  • Thank you aLTeReGo,

    The above will work only if one application template is assigned per node. If node has more than 1 template assigned this will return all those nodes as well.

    I can see the logic behind how filtering works, but I can't quite figure out how to workaround it to report on what I need. Maybe there are some other ways of making sure all nodes are compliant, i.e. have specific template assigned?

    Thanks,

    Alex

  • Touche alexslv. You are correct. What seemed like a simple problem with a fairly straightforward solution is indeed more complex. The only way I can see accomplishing such a report would be to write it in SQL. You may want to consider posting this question in the Report Lab. There are some sharp peeps that frequent that forum, itching to get their SQL skills on. emoticons_happy.png

  • if you use the Advanced SQL

                   pastedImage_15.png

    1) All nodes do not have an application template containing the word «Windows»

    ---------------------------------------------------------   

        SELECT DISTINCT NodeID, Caption

        FROM Nodes

        Where NodeID not in (SELECT Nodes.NodeID FROM Nodes, APM_CurrentStatusOfApplication

                                          Where Nodes.NodeID = APM_CurrentStatusOfApplication.NodeID and

                                          APM_CurrentStatusOfApplication.ApplicationName LIKE '%Windows%' )

    ---------------------------------------------------------

    2) All nodes have an application template but do not have a template containing the word «Windows»

    ---------------------------------------------------------

         SELECT DISTINCT Nodes.NodeID as NodeID, Caption 

         FROM Nodes, APM_CurrentStatusOfApplication

         Where Nodes.NodeID = APM_CurrentStatusOfApplication.NodeID

                   and Nodes.NodeID not in (SELECT Nodes.NodeID FROM Nodes, APM_CurrentStatusOfApplication

                                                         Where Nodes.NodeID = APM_CurrentStatusOfApplication.NodeID and

                                                         APM_CurrentStatusOfApplication.ApplicationName LIKE '%Windows%'  )

    ---------------------------------------------------------

  • Hi avn

    Thank you for your reply. I have tried both of them, they work ok, but not quite what I was looking for. I am looking to get a list of windows nodes (Machine Type Like %windows%) which do not have Application Template assigned, say ApplicationName LIKE %TEST%. Would you please be able to help with this one?

    Thanks,

    Alex

  • avn,

    I have adjusted report a little bit, so, it now does what it should be doing. Thank you so much for your help

    SELECT DISTINCT NodeID, Caption 

        FROM Nodes 

        Where NodeID not in (SELECT Nodes.NodeID FROM Nodes, APM_CurrentStatusOfApplication 

                                          Where Nodes.NodeID = APM_CurrentStatusOfApplication.NodeID and 

                                          APM_CurrentStatusOfApplication.ApplicationName LIKE '%Basic Windows Server Checks%')

        And Nodes.MachineType LIKE '%windows%'

    --

    Alex

  • Screenshot - 26.11.2013 , 16_15_30.png

    if not in the spelling davayas sql code


    1)------------------------------------------------------------

       SELECT DISTINCT NodeID, Caption 

        FROM Nodes 

        Where NodeID not in (SELECT Nodes.NodeID FROM Nodes, APM_CurrentStatusOfApplication 

                                          Where Nodes.NodeID = APM_CurrentStatusOfApplication.NodeID and 

                                          APM_CurrentStatusOfApplication.ApplicationName LIKE '%Test%' )

             and   Vendor like '%Windows%'

    2)------------------------------------------------------------

    SELECT DISTINCT Nodes.NodeID as NodeID, Caption   

    FROM Nodes, APM_CurrentStatusOfApplication 

    Where Nodes.NodeID = APM_CurrentStatusOfApplication.NodeID 

              and Nodes.NodeID not in (SELECT Nodes.NodeID FROM Nodes, APM_CurrentStatusOfApplication 

                                                      Where Nodes.NodeID = APM_CurrentStatusOfApplication.NodeID and 

                                                      APM_CurrentStatusOfApplication.ApplicationName LIKE '%Test%'  )

              and   Nodes.Vendor like '%Windows%'

    ---------------------------------------------------------------

  • avn - thank you, thank you, thank you

  • FormerMember
    0 FormerMember in reply to avn

    Any one have a suggestion to tweak the query so it will report on multiple missing templates?

    For example if Server1 needs templates A, B, C and if it's missing one or more templates, how can I report on that?


    I tried adding another or statement to the query above, but it didn't come back with all the results. It only came back with servers missing both templates, but didn't include servers that was only missing one of the templates.

    Thanks.