slow queries for microsoft.applications

[vjeffrey]

• microsoft.applications.all( certificates != empty )
• microsoft.applications.length

both of these queries have been found to be slow at scale, we need to investigate how to make them more performant

[afiune]

RFR #5161

microsoft.applications.length

[afiune]

For:

microsoft.applications.all( certificates != empty )

I would do this:

microsoft.applications(withCertificates: true).all()

[afiune]

After researching about how to fetch applications only with/without certificates I found out that it is not supported, even though it is listed in the documentation that it should work, it does not

https://learn.microsoft.com/en-us/graph/api/resources/application?view=graph-rest-1.0

We need to find a better way to make this query more performant 🤔 still researching but open to ideas.

[afiune]

I am unable to find a way to filter by empty certificates, we should probably split this issue for now.