Api query for fiixlet whose name contains unsupported

1

Hello,

In the patches for Windows site if you search the console for Microsoft Unsupported: Windows you will get a list of Windows operating systems that are no longer supported. I would like help with a api query I could use to send this info into our asset management tool. Has anyone done this type of thing before. Tried Https:/servername:52311/api/fixlets/external/patches for windows whose (name of it contains “unsupported”) but got a error message. Any ideas would be appreciated

2

Does this work for you? This ran ok in the session relevance tester.

(names of it, ids of it) of bes fixlets whose ((name of site of it = "Enterprise Security") AND ((name of it as string as lowercase contains "unsupported")))

3

When you use the /api/fixlets endpoint you cannot use a Session Relevance query.

Instead you need to use /api/query?relevance=

And send a url-encoded version of @SLB’s relevance as the “relevance” parameter value.

1 Like
4

Thank you very much for the help. So the query works well, but fails to return the number of relevant computers. For example 'Microsoft Unsupported Windows 10 version 1809 (non-LTSC) and 6 computers would be relevant for that fixlet as displayed in the console

5

You need to craft the session relevance query to retrieve the data you need…try

(names of it, ids of it, number of applicable computers of it) of bes fixlets whose ((name of site of it = "Enterprise Security") AND (name of it as string as lowercase contains "unsupported"))