1 2 Previous Next 12 Replies Latest reply on Apr 23, 2013 4:49 AM by epository

    How to create DLPPATCH 1440 Query

    regcoles

      Hi All,

       

      I am busy rolling out the DLPPATCH 1440 and I cannot create a query to see how many systems on my network have the hotfix installed. I can manually go to a system and see if patch installed. When I try and create a query there is no option for the DLPPATCH 1440. Is there a way of creating a custom report to show information.

       

      Regards

      Reg  

        • 1. Re: How to create DLPPATCH 1440 Query
          Laszlo G

          Hi regcoles, the attached one should do the trick

          1 of 1 people found this helpful
          • 2. Re: How to create DLPPATCH 1440 Query
            regcoles

            Hi Ulyses,

             

            Thanks for that, is this a ePO 4.6 report as I have ePO v4.5 (sorry forgot to mention this) and I can import it but it will not run and I cannot edit it? I had a look at the coding and the part in bold could be the problem.

             

            - <queries>

            - <query>

            <name language="es">DLPPATCH1440</name>

            <description language="es" />

            <property name="target">EPOLeafNode</property>

            <property name="tableURI">query:table?orion.table.columns=EPOLeafNode.LastUpdate%3AEPOLeafNode.NodeName%3A EPOBranchNode.NodeName&orion.table.order=az&orion.table.order.by=EPOLeafNode.Las tUpdate%3AEPOLeafNode.NodeName%3AEPOBranchNode.NodeName</property>

            <property name="conditionURI">query:condition?orion.condition.sexp=</property>

            <property name="summaryURI">query:summary?bool.show.criteria=false&orion.query.type=pie.bool&orion.sum.query =true&bool.red.text=No+conforme&bool.green.text=Conforme&show.percentage=false&b ool.green.criteria=%28+where+%28+contains+EPOProductPropertyProducts.Products+%22DLPPATCH1440%22+%29+%29&orion.sum.aggregation=count&orion.sum.aggregation.sh owTotal=true</property>

            </query>

            </queries>

             

            This query cannot be executed or edited because of the reasons listed below.

            • The table for a query criteria column does not exist: EPOProductPropertyProducts.Products

             

            Regards

            Reg

            • 3. Re: How to create DLPPATCH 1440 Query
              Laszlo G

              Hi regcoles you're right, this will only work with ePO 4.6

               

              Unfortunately I haven't seen any field you can use on ePO 4.5 queries to show an installed product without having its extension installed (this patch does not have an extension so you don't have specific fields for it) so I don't know how to build a query for this

              • 4. Re: How to create DLPPATCH 1440 Query
                regcoles

                Hi Ulyses,

                 

                Thanks for trying, this will give me more levarage to get our epo Ugraded to v4.6

                 

                Regards

                Reg

                • 5. Re: How to create DLPPATCH 1440 Query

                  Create a new query using a Boolean Pie Chart on the left

                  On the right, choose "Configure Criteria"

                  Add "Product Code" from the Product Protection group

                   

                  Product Code equals DLPPATCH1440

                   

                  Click OK

                  Type whatever labels for your matching and non-matching slice

                  Check the box next to "Show Percentage" - THIS IS IMPORTANT

                  Click Next

                  Choose your columns you want, click Next

                  On the filter, add Product Code" from the Product Protection group again

                   

                  Product Code CONTAINS dlppatch1440 OR CONTAINS dataloss

                   

                  Click Run

                   

                  That should work, let me know if you have any issues.

                  • 6. Re: How to create DLPPATCH 1440 Query
                    greatscott

                    Still having problems with this. Anyone running 4.5 unable to get a good query working?

                    • 7. Re: How to create DLPPATCH 1440 Query
                      regcoles

                      Hi,

                       

                      I have tried to create this report but not working.

                      Firstly I cannot find 'Product code from Product Protection Group' - I have looked a few times and nothing. I have used 'Data Loss Prevention' andf product version but it will not allow it. The 'OK' button stays greyed out.

                      Any chance you could post your query here as i can import it into my ePO and see if it works.

                      • 8. Re: How to create DLPPATCH 1440 Query
                        pankajs

                        Go to quey

                        Select new query

                        select mange option.

                        select boolean pie chart option.

                        select configure option below the chart.

                        on the left hand side select go to dlp section & select Hotfix option.

                        in the option select equal and specifiy the hotfix vrsion that is 1440 or 14.40

                         

                        save the query & run.

                        • 9. Re: How to create DLPPATCH 1440 Query
                          greatscott

                          Have to query SQL to get an accurate look...

                          1 2 Previous Next