I have a functioning compliance report however when you export it you also get the compliant machines as well which makes my report 257 pages. Is there a way to report only non-compliant machines so I could E-mail that report to designated IT staff within my organization? This would be easy if my compliance was only based on one attribute such as DAT version but I consider non-compliant machines to be ones that have a DAT that is 3 versions older than my repository AND/OR McAfee Agent is not agent version 4.5 AND/OR VSE is less than 8.7. It seems as though the OR part is hard to come by because if I filter the results it has to be with AND's between the properties.
I feel your pain, you can't report on seperate categories at the same time. What I do is run 4 seperate queries, export them to csv then by external means (powershell) construct a html report based on that data.