1 Reply Latest reply on Oct 1, 2008 4:35 AM by phoffmann

    Easy report editing tool

    Rookie

      Hi all,

       

      I want to run a query where I can see the number of PC's without  certain MS Updates, so far so good, I just use this:

       

      ("Computer"."Security and Patch Definitions"."Vulnerability ID"  =  "MS07-023"    AND
         "Computer"."Security and Patch Definitions"."Detected"  =  "1")    OR
         ("Computer"."Security and Patch Definitions"."Vulnerability ID"  =  "MS07-017"      AND
           "Computer"."Security and Patch Definitions"."Detected"  =  "1")

      and so on.

       

      But to add 20 more MS Updates in the LanDesk Reports Tool is a lot of work. So I tried to export the query, open the XML file (with Excel2007/OpenOffice/notepad/XML editor) add the MS Updates and import the query back into Landesk again. But somehow this all fails. Does anybody know a good working export/import method for queries?

        • 1. Re: Easy report editing tool
          phoffmann SupportEmployee

          I only ever use notepad or notepad++ to edit XML's - too many other things add unwanted/unprintable characters in my experience.

           

          The problem could be that you're asking a little bit too much of the LANDesk query tool. The issue is that the query tool tries and make "something complex look simple" ... which it does reasonably well.

           

          The problem with this is is that this becomes rather problematic for complex queries. For instance, in SQL your query would be quite straight forward with a

           

          select stuff from table where patchname NOT IN ('Patch1', 'Patch2', 'Patch3') AND detected='1'

           

          and so on (if you allow the pseudo-SQL. Now, because we try to do something complex look simple, your actual SQL query will be a LOT trickier, with countless AND statements. And my experience is that too many AND-statements kill off any kind of code (be it SQL or programming) ...

           

          So what you COULD do is to actually hack the SQL for the query straight into the database (if you're brave/good enough for this). Problem with that is that you need to make sure that no one saves/overwrites your query, as this would over-write your "revised" SQL with the default LANdesk SQL and you'd be back to square one.

           

          But if this is an option you're willing to look at, I can give you the table/columns to look at.

           

          Paul Hoffmann

          LANDesk EMEA Technical Lead