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>
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
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
Thanks for trying, this will give me more levarage to get our epo Ugraded to v4.6
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
Type whatever labels for your matching and non-matching slice
Check the box next to "Show Percentage" - THIS IS IMPORTANT
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
That should work, let me know if you have any issues.
Still having problems with this. Anyone running 4.5 unable to get a good query working?
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.
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.
Have to query SQL to get an accurate look...