# Criteria Query

**URL:** <https://community.squaredup.com/t/criteria-query/801>\
**Category:** Dashboard Server\
**Tags:** criteria\
**Created:** [September 10, 2018, 1:21pm UTC](https://community.squaredup.com/t/criteria-query/801 "2018-09-10T13:21:34Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![caesarson](https://community.squaredup.com/letter_avatar_proxy/v4/letter/c/a3d4f5/32.png) [@caesarson](https://community.squaredup.com/u/caesarson)\
**Post date:** [September 10, 2018, 1:21pm UTC](https://community.squaredup.com/t/criteria-query/801/1 "2018-09-10T13:21:34Z")

</div>

I’m having issues getting the correct criteria for scoping to “about to expire Certificates” within an alert tile. The MP used is the System Center PKI. Within SCOM there is a state view scoped to Certificate Store class and has the expression “IsTimeValid Status and Expires Soon Flag is True”. But I cannot seem to find the correct Criteria Expression Syntax if anyone has any idea.

Thanks

---

<div class="post-metadata">

**Author:** ![jan-e](https://community.squaredup.com/letter_avatar_proxy/v4/letter/j/b2d939/32.png) [@jan-e](https://community.squaredup.com/u/jan-e)\
**Post date:** [September 10, 2018, 1:52pm UTC](https://community.squaredup.com/t/criteria-query/801/2 "2018-09-10T13:52:09Z")

</div>

Hi,

please try this:

CertTimeStatus = ‘IsTimeValid’ and CertExpiresWithin31Days = ‘true’

We don’t have an certificate which will expire in the next 31 days, so i’m not able to verify this.

---

<div class="post-metadata">

**Author:** ![caesarson](https://community.squaredup.com/letter_avatar_proxy/v4/letter/c/a3d4f5/32.png) [@caesarson](https://community.squaredup.com/u/caesarson)\
**Post date:** [September 10, 2018, 1:56pm UTC](https://community.squaredup.com/t/criteria-query/801/3 "2018-09-10T13:56:06Z")

</div>

worked perfect. Thank you