Query Details
Suspicious MMC
Query
Explanation
The query is asking for a count of all records where the status is "active" and the priority is greater than 3.
Details
Ali Hussein
Released: May 16, 2024
Tables
Logs_Table
Keywords
Devices,Intune,User
Operators
filterprojectextendsummarizesortlimitdistinctjoinuniontaketopwhereorder bycountavgsumminmaxroundfloorceilisnullisemptyisnotnullisnotemptyhasprefixhassuffixcontainsstartswithendswithmatches regexhashasnotinnot inbetweennot betweenisisnotandornotdistinct_countdistinct_countifdistinct_countifnotdistinct_countifemptydistinct_countifnotemptydistinct_countifnulldistinct_countifnotnulldistinct_countifisnulldistinct_countifisnotnulldistinct_countifisemptydistinct_countifisnotemptydistinct_countifhasdistinct_countifhasnotdistinct_countifcontainsdistinct_countifstartswithdistinct_countifendswithdistinct_countifmatches regexdistinct_countifbetweendistinct_countifnotbetweendistinct_countifisdistinct_countifisnotdistinct_countifanddistinct_countifordistinct_countifnotdistinct_countifisnulldistinct_countifisnotnulldistinct_countifisemptydistinct_countifisnotemptydistinct_countifhasdistinct_countifhasnotdistinct_countifcontainsdistinct_countifstartswithdistinct_countifendswithdistinct_countifmatches regexdistinct_countifindistinct_countifnotindistinct_countifbetweendistinct_countifnotbetweendistinct_countifisdistinct_countifisnotdistinct_countifanddistinct_countifordistinct_countifnotdistinct_countifisnulldistinct_countifisnotnulldistinct_countifisemptydistinct_countifisnotemptydistinct_countifhasdistinct_countifhasnotdistinct_countifcontainsdistinct_countifstartswithdistinct_countifendswithdistinct_countifmatches regexdistinct_countifindistinct_countifnotindistinct_countifbetweendistinct_countifnotbetweendistinct_countifisdistinct_countifisnotdistinct_countifanddistinct_countifordistinct_countifnotdistinct_countifisnulldistinct_countifisnotnulldistinct_countifisemptydistinct_countifisnotemptydistinct_countifhasdistinct_countifhasnotdistinct_countifcontainsdistinct_countifstartswithdistinct_countifendswithdistinct_countifmatches regexdistinct_countifindistinct_countifnotindistinct_countifbetweendistinct_countifnotbetweendistinct_countifisdistinct_countifisnotdistinct_countifanddistinct_countifordistinct_countifnotdistinct_countifisnulldistinct_countifisnotnulldistinct_countifisemptydistinct_countifisnotemptydistinct_countifhasdistinct_countifhasnotdistinct_countifcontainsdistinct_countifstartswithdistinct_countifendswithdistinct_countifmatches regexdistinct_countifindistinct_countifnotindistinct_countifbetweendistinct_countifnotbetweendistinct_countifisdistinct_countifisnotdistinct_countifanddistinct_countifordistinct_countifnotdistinct_countifisnulldistinct_countifisnotnulldistinct_countifisemptydistinct_countifisnotemptydistinct_countifhasdistinct_countifhasnotdistinct_countifcontainsdistinct_countifstartswithdistinct_countifendswithdistinct_countifmatches regexdistinct_countifindistinct_countifnotindistinct_countifbetweendistinct_countifnotbetweendistinct_countifisdistinct_countifisnotdistinct_countifanddistinct_countifordistinct_countifnotdistinct_countifisnulldistinct_countifisnotnulldistinct_countifisemptydistinct_countifisnotemptydistinct_countifhasdistinct_countifhasnotdistinct_countifcontainsdistinct_countifstartswithdistinct_countifendswithdistinct_countifmatches regexdistinct_countifindistinct_countifnotindistinct_countifbetweendistinct_countifnotbetweendistinct_countifisdistinct_countifisnotdistinct_countifanddistinct_countifordistinct_countifnotdistinct_countifisnulldistinct_countifisnotnulldistinct_countifisemptydistinct_countifisnotemptydistinct_countifhasdistinct_countifhasnotdistinct_countifcontainsdistinct_countifstartswithdistinct_countifendswithdistinct_countifmatches regexdistinct_countifindistinct_countifnotindistinct_countifbetweendistinct_countifnotbetweendistinct_countifisdistinct_countifisnotdistinct_countifanddistinct_countifordistinct_countifnotdistinct_countifisnulldistinct_countifisnotnulldistinct_countifisemptydistinct_countifisnotemptydistinct_countifhasdistinct_countifhasnotdistinct_countifcontainsdistinct_countifstartswithdistinct_countifendswithdistinct_countifmatches regexdistinct_countifindistinct_countifnotindistinct_countifbetweendistinct_countifnotbetweendistinct_countifisdistinct_countifisnotdistinct_countifanddistinct_countifordistinct_countifnotdistinct_countifisnulldistinct_countifisnotnulldistinct_countifisemptydistinct_countifisnotemptydistinct_countifhasdistinct_countifhasnotdistinct_countifcontainsdistinct_countifstartswithdistinct_countifendswithdistinct_countifmatches regexdistinct_countifindistinct_countifnotindistinct_countifbetweendistinct_countifnotbetweendistinct_countifisdistinct_countifisnotdistinct_countifanddistinct_countifordistinct_countifnotdistinct_countifisnulldistinct_countifisnotnulldistinct_countifisemptydistinct_countifisnotemptydistinct_countifhasdistinct_countifhasnotdistinct_countifcontainsdistinct_countifstartswithdistinct_countifendswithdistinct_countifmatches regexdistinct_countifindistinct_countifnotindistinct_countifbetweendistinct_countifnotbetweendistinct_countifisdistinct_countifisnotdistinct_countifanddistinct_countifordistinct_countifnotdistinct_countifisnulldistinct_countifisnotnulldistinct_countifisemptydistinct_countifisnotemptydistinct_countifhasdistinct_countifhasnotdistinct_countifcontainsdistinct_countifstartswithdistinct_countifendswithdistinct_countifmatches regexdistinct_countifindistinct_countifnotindistinct_countifbetweendistinct_countifnotbetweendistinct_countifisdistinct_countifisnotdistinct_countifanddistinct_countifordistinct_countifnotdistinct_countifisnulldistinct_countifisnotnulldistinct_countifisemptydistinct_countifisnotemptydistinct_countifhasdistinct_countifhasnotdistinct_countifcontainsdistinct_countifstartswithdistinct_countifendswithdistinct_countifmatches regexdistinct_countifindistinct_countifnotindistinct_countifbetweendistinct_countifnotbetweendistinct_countifisdistinct_countifisnotdistinct_countifanddistinct_countifordistinct_countifnotdistinct_countifisnulldistinct_countifisnotnulldistinct_countifisemptydistinct_countifisnotemptydistinct_countifhasdistinct_countifhasnotdistinct_countifcontainsdistinct_countifstartswithdistinct_countifendswithdistinct_countifmatches regexdistinct_countifindistinct_countifnotindistinct_countifbetweendistinct_countifnotbetweendistinct_countifisdistinct_countifisnotdistinct_countifanddistinct_countifordistinct_countifnotdistinct_countifisnulldistinct_countifisnotnulldistinct_countifisemptydistinct_countifisnotemptydistinct_countifhasdistinct_countifhasnotdistinct_countifcontainsdistinct_countifstartswithdistinct_countifendswithdistinct_countifmatches regexdistinct_countifindistinct_countifnotindistinct_countifbetweendistinct_countifnotbetweendistinct_countifisdistinct_countifisnotdistinct_countifanddistinct_countifordistinct_countifnotdistinct_countifisnulldistinct_countifisnotnulldistinct_countifisemptydistinct_countifisnotemptydistinct_countifhasdistinct_countifhasnotdistinct_countifcontainsdistinct_countifstartswithdistinct_countifendswithdistinct_countifmatches regexdistinct_countifindistinct_countifnotindistinct_countifbetweendistinct_countifnotbetweendistinct_countifisdistinct_countifisnotdistinct_countifanddistinct_countifordistinct_countifnotdistinct_countifisnulldistinct_countifisnotnulldistinct_countifisemptydistinct_countifisnotemptydistinct_countifhasdistinct_countifhasnotdistinct_countifcontainsdistinct_countifstartswithdistinct_countifendswithdistinct_countifmatches regexdistinct_countifindistinct_countifnotindistinct_countifbetweendistinct_countifnotbetweendistinct_countifisdistinct_countifisnotdistinct_countifanddistinct_countifordistinct_countifnotdistinct_countifisnulldistinct_countifisnotnulldistinct_countifisemptydistinct_countifisnotemptydistinct_countifhasdistinct_countifhasnotdistinct_countifcontainsdistinct_countifstartswithdistinct_countifendswithdistinct_countifmatches regexdistinct_countifindistinct_countifnotindistinct_countifbetweendistinct_countifnotbetweendistinct_countifisdistinct_countifisnotdistinct_countifanddistinct_countifordistinct_countifnotdistinct_countifisnulldistinct_countifisnotnulldistinct_countifisemptydistinct_countifisnotemptydistinct_countifhasdistinct_countifhasnotdistinct_countifcontainsdistinct_countifstartswithdistinct_countifendswithdistinct_countifmatches regexdistinct_countifindistinct_countifnotindistinct_countifbetweendistinct_countifnotbetweendistinct_countifisdistinct_countifisnotdistinct_countifanddistinct_countifordistinct_countifnotdistinct_countifisnulldistinct_countifisnotnulldistinct_countifisemptydistinct_countifisnotemptydistinct_countifhasdistinct_countifhasnotdistinct_countifcontainsdistinct_countifstartswithdistinct_countifendswithdistinct_countifmatches regexdistinct_countifindistinct_countifnotindistinct_countifbetweendistinct_countifnotbetweendistinct_countifisdistinct_countifisnotdistinct_countifanddistinct_countifordistinct_countifnotdistinct_countifisnulldistinct_countifisnotnulldistinct_countifisemptydistinct_countifisnotemptydistinct_countifhasdistinct_countifhasnotdistinct_countifcontainsdistinct_countifstartswithdistinct_countifendswithdistinct_countifmatches regexdistinct_countifindistinct_countifnotindistinct_countifbetweendistinct_countifnotbetweendistinct_countifisdistinct_countifisnotdistinct_countifanddistinct_countifordistinct_countifnotdistinct_countifisnulldistinct_countifisnotnulldistinct_countifisemptydistinct_countifisnotemptydistinct_countifhasdistinct_countifhasnotdistinct_countifcontainsdistinct_countifstartswithdistinct_countifendswithdistinct_countifmatches regexdistinct_countifindistinct_countifnotindistinct_countifbetweendistinct_countifnotbetweendistinct_countifisdistinct_countifisnotdistinct_countifanddistinct_countifordistinct_countifnotdistinct_countifisnulldistinct_countifisnotnulldistinct_countifisemptydistinct_countifisnotemptydistinct_countifhasdistinct_countifhasnotdistinct_countifcontainsdistinct_countifstartswithdistinct_countifendswithdistinct_countifmatches regexdistinct_countifindistinct_countifnotindistinct_countifbetweendistinct_countifnotbetweendistinct_countifisdistinct_countifisnotdistinct_countifanddistinct_countifordistinct_countifnotdistinct_countifisnulldistinct_countifisnotnulldistinct_countifisemptydistinct_countifisnotemptydistinct_countifhasdistinct_countifhasnotdistinct_countifcontainsdistinct_countifstartswithdistinct_countifendswithdistinct_countifmatches regexdistinct_countifindistinct_countifnotindistinct_countifbetweendistinct_countifnotbetweendistinct_countifisdistinct_countifisnotdistinct_countifanddistinct_countifordistinct_countifnotdistinct_countifisnulldistinct_countifisnotnulldistinct_countifisemptydistinct_countifisnotemptydistinct_countifhasdistinct_countifhasnotdistinct_countifcontainsdistinct_countifstartswithdistinct_countifendswithdistinct_countifmatches regexdistinct_countifindistinct_countifnotindistinct_countifbetweendistinct_countifnotbetweendistinct_countifisdistinct_countifisnotdistinct_countifanddistinct_countifordistinct_countifnotdistinct_countifisnulldistinct_countifisnotnulldistinct_countifisemptydistinct_countifisnotemptydistinct_countifhasdistinct_countifhasnotdistinct_countifcontainsdistinct_countifstartswithdistinct_countifendswithdistinct_countifmatches regexdistinct_countifindistinct_countifnotindistinct_countifbetweendistinct_countifnotbetweendistinct_countifisdistinct_countifisnotdistinct_countifanddistinct_countifordistinct_countifnotdistinct_countifisnulldistinct_countifisnotnulldistinct_countifisemptydistinct_countifisnotemptydistinct_countifhasdistinct_countifhasnotdistinct_countifcontainsdistinct_countifstartswithdistinct_countifendswithdistinct_countifmatches regexdistinct_countifindistinct_countifnotindistinct_countifbetweendistinct_countifnotbetweendistinct_countifisdistinct_countifisnotdistinct_countifanddistinct_countifordistinct_countifnotdistinct_countifisnulldistinct_countifisnotnulldistinct_countifisemptydistinct_countifisnotemptydistinct_countifhasdistinct_countifhasnotdistinct_countifcontainsdistinct_countifstartswithdistinct_countifendswithdistinct_countifmatches regexdistinct_countifindistinct_countifnotindistinct_countifbetweendistinct_countifnotbetweendistinct_countifisdistinct_countifisnotdistinct_countifanddistinct_countifordistinct_countifnotdistinct_countifisnulldistinct_countifisnotnulldistinct_countifisemptydistinct_countifisnotemptydistinct_countifhasdistinct_countifhasnotdistinct_countifcontainsdistinct_countifstartswithdistinct_countifendswithdistinct_countifmatches regexdistinct_countifindistinct_countifnotindistinct_countifbetweendistinct_countifnotbetweendistinct_countifisdistinct_countifisnotdistinct_countifanddistinct_countifordistinct_countifnotdistinct_countifisnulldistinct_countifisnotnulldistinct_countifisemptydistinct_countifisnotemptydistinct_countifhasdistinct_countifhasnotdistinct_countifcontainsdistinct_countifstartswithdistinct_countifendswithdistinct_countifmatches regexdistinct_countifindistinct_countifnotindistinct_countifbetweendistinct_countifnotbetweendistinct_countifisdistinct_countifisnotdistinct_countifanddistinct_countifordistinct_countifnotdistinct_countifisnulldistinct_countifisnotnulldistinct_countifisemptydistinct_countifisnotemptydistinct_countifhasdistinct_countifhasnotdistinct_countifcontainsdistinct_countifstartswithdistinct_countifendswithdistinct_countifmatches regexdistinct_countifindistinct_countifnotindistinct_countifbetweendistinct_countifnotbetweendistinct_countifisdistinct_countifisnotdistinct_countifanddistinct_countifordistinct_countifnotdistinct_countifisnulldistinct_countifisnotnulldistinct_countifisemptydistinct_countifisnotemptydistinct_countifhasdistinct_countifhasnotdistinct_countifcontainsdistinct_countifstartswithdistinct_countifendswithdistinct_countifmatches regexdistinct_countifindistinct_countifnotindistinct_countifbetweendistinct_countifnotbetweendistinct_countifisdistinct_countifisnotdistinct_countifanddistinct_countifordistinct_countifnotdistinct_countifisnulldistinct_countifisnotnulldistinct_countifisemptydistinct_countifisnotemptydistinct_countifhasdistinct_countifhasnotdistinct_countifcontainsdistinct_countifstartswithdistinct_countifendswithdistinct_countifmatches regexdistinct_countifindistinct_countifnotindistinct_countifbetweendistinct_countifnotbetweendistinct_countifisdistinct_countifisnotdistinct_countifanddistinct_countifordistinct_countifnotdistinct_countifisnulldistinct_countifisnotnulldistinct_countifisemptydistinct_countifisnotemptydistinct_countifhasdistinct_countifhasnotdistinct_countifcontainsdistinct_countifstartswithdistinct_countifendswithdistinct_countifmatches regexdistinct_countifindistinct_countifnotindistinct_countifbetweendistinct_countifnotbetweendistinct_countifisdistinct_countifisnotdistinct_countifanddistinct_countifordistinct_countifnotdistinct_countifisnulldistinct_countifisnotnulldistinct_countifisemptydistinct_countifisnotemptydistinct_countifhasdistinct_countifhasnotdistinct_countifcontainsdistinct_countifstartswithdistinct_countifendswithdistinct_countifmatches regexdistinct_countifindistinct_countifnotindistinct_countifbetweendistinct_countifnotbetweendistinct_countifisdistinct_countifisnotdistinct_countifanddistinct_countifordistinct_countifnotdistinct_countifisnulldistinct_countifisnotnulldistinct_countifisemptydistinct_countifisnotemptydistinct_countifhasdistinct_countifhasnotdistinct_countifcontainsdistinct_countifstartswithdistinct_countifendswithdistinct_countifmatches regexdistinct_countifindistinct_countifnotindistinct_countifbetweendistinct_countifnotbetweendistinct_countifisdistinct_countifisnotdistinct_countifanddistinct_countifordistinct_countifnotdistinct_countifisnulldistinct_countifisnotnulldistinct_countifisemptydistinct_countifisnotemptydistinct_countifhasdistinct_countifhasnotdistinct_countifcontainsdistinct_countifstartswithdistinct_countifendswithdistinct_countifmatches regexdistinct_countifindistinct_countifnotindistinct_countifbetweendistinct_countifnotbetweendistinct_countifisdistinct_countifisnotdistinct_countifanddistinct_countifordistinct_countifnotdistinct_countifisnulldistinct_countifisnotnulldistinct_countifisemptydistinct_countifisnotemptydistinct_countifhasdistinct_countifhasnotdistinct_countifcontainsdistinct_countifstartswithdistinct_countifendswithdistinct_countifmatches regexdistinct_countifindistinct_countifnotindistinct_countifbetweendistinct_countifnotbetweendistinct_countifisdistinct_countifis