<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: export/view information about Windows endpoints missing with KB in Cortex XDR Discussions</title>
    <link>https://live.paloaltonetworks.com/t5/cortex-xdr-discussions/export-view-information-about-windows-endpoints-missing-with-kb/m-p/529978#M3563</link>
    <description>&lt;P&gt;Thanks for the info. I'll try it.&lt;/P&gt;</description>
    <pubDate>Mon, 06 Feb 2023 11:29:30 GMT</pubDate>
    <dc:creator>haimmiller</dc:creator>
    <dc:date>2023-02-06T11:29:30Z</dc:date>
    <item>
      <title>export/view information about Windows endpoints missing with KB</title>
      <link>https://live.paloaltonetworks.com/t5/cortex-xdr-discussions/export-view-information-about-windows-endpoints-missing-with-kb/m-p/529921#M3560</link>
      <description>&lt;P&gt;Hi,&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;I'd like to know how I can export/view information about Windows endpoints that do not apply with specific KB by specific ENDPOINT GROUPS. I can only filter by CVES or ENDPOINTS from the Vulnerability Assessment but not with KBs.&lt;/P&gt;
&lt;P&gt;My second question is there a way to query if, for example, a Windows endpoint is not applied with the latest cumulative KB/older KBs?&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Thanks&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Sun, 05 Feb 2023 13:29:54 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/cortex-xdr-discussions/export-view-information-about-windows-endpoints-missing-with-kb/m-p/529921#M3560</guid>
      <dc:creator>haimmiller</dc:creator>
      <dc:date>2023-02-05T13:29:54Z</dc:date>
    </item>
    <item>
      <title>Re: export/view information about Windows endpoints missing with KB</title>
      <link>https://live.paloaltonetworks.com/t5/cortex-xdr-discussions/export-view-information-about-windows-endpoints-missing-with-kb/m-p/529971#M3562</link>
      <description>&lt;P&gt;Hi&amp;nbsp;&lt;a href="https://live.paloaltonetworks.com/t5/user/viewprofilepage/user-id/271877"&gt;@haimmiller&lt;/a&gt;&amp;nbsp;,&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Thank you for writing to Live Community!&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Cortex XDR vulnerability assessment shows you the list of KBs installed on the endpoints. However, it does not show the comparative analysis or assessment for latest KBs as KBs are provided by the vendors and we do not fetch the latest serials into XDR. However, you can list the KBs in couple of ways as listed below:&lt;/P&gt;
&lt;OL&gt;
&lt;LI&gt;&lt;STRONG&gt;Using Script Execution&lt;/STRONG&gt;: If you do not have host insights license but have Cortex XDR Pro license enabled on endpoints, you can use the Cortex XDR script execution. Under category of "Execute Commands" you can run the following cmdline params "wmic qfe get HotfixID" you can also use "find" at the end of this command to filter by date/month/year or the latest KB number as per your choice(example below):. You can also get the result output of the script in form of a report.&lt;BR /&gt;
&lt;TABLE border="1" width="100%"&gt;
&lt;TBODY&gt;
&lt;TR&gt;
&lt;TD width="100%"&gt;
&lt;P&gt;&lt;FONT size="2" color="#0000FF"&gt;&lt;STRONG&gt;wmic qfe get HotFixID | find "3004365"&lt;/STRONG&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;/TD&gt;
&lt;/TR&gt;
&lt;/TBODY&gt;
&lt;/TABLE&gt;
&lt;BR /&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="neelrohit_0-1675680734329.png" style="width: 999px;"&gt;&lt;img src="https://live.paloaltonetworks.com/t5/image/serverpage/image-id/47673iB4FE686A413067AA/image-size/large/is-moderation-mode/true?v=v2&amp;amp;px=999" role="button" title="neelrohit_0-1675680734329.png" alt="neelrohit_0-1675680734329.png" /&gt;&lt;/span&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;/LI&gt;
&lt;LI&gt;&amp;nbsp;&lt;STRONG&gt;Using host insights based license and XQL&lt;/STRONG&gt;: You can use the traditional host insights based dataset to query the list of installed KBs on endpoints using the following XQL query&lt;BR /&gt;
&lt;TABLE border="1" width="100%"&gt;
&lt;TBODY&gt;
&lt;TR&gt;
&lt;TD width="100%"&gt;&lt;LI-CODE lang="java"&gt;dataset = host_inventory 
| arrayexpand kbs 
| filter host_name != null and os_type != ENUM.OS_LINUX 
| alter hotfix = json_extract(kbs , "$.name")
| alter date = json_extract(kbs , "$.installation_date")
| alter header = json_extract(kbs , "$.title")
| fields host_name, hotfix, date, header&lt;/LI-CODE&gt;&lt;/TD&gt;
&lt;/TR&gt;
&lt;/TBODY&gt;
&lt;/TABLE&gt;
&lt;/LI&gt;
&lt;/OL&gt;
&lt;P&gt;You can add filters of your choice under this to query the data for specific hostnames and also create a visual graph for the list of KBs as per your choice. (Example screenshot below)&lt;/P&gt;
&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screenshot 2023-02-06 at 6.30.37 PM.png" style="width: 999px;"&gt;&lt;img src="https://live.paloaltonetworks.com/t5/image/serverpage/image-id/47672iA62F53ECBDD79821/image-size/large/is-moderation-mode/true?v=v2&amp;amp;px=999" role="button" title="Screenshot 2023-02-06 at 6.30.37 PM.png" alt="Screenshot 2023-02-06 at 6.30.37 PM.png" /&gt;&lt;/span&gt;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Hope this helps!&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Please mark the response as "Accept as Solution" if it was able to resolve your query.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Regards&lt;/P&gt;</description>
      <pubDate>Mon, 06 Feb 2023 10:52:34 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/cortex-xdr-discussions/export-view-information-about-windows-endpoints-missing-with-kb/m-p/529971#M3562</guid>
      <dc:creator>neelrohit</dc:creator>
      <dc:date>2023-02-06T10:52:34Z</dc:date>
    </item>
    <item>
      <title>Re: export/view information about Windows endpoints missing with KB</title>
      <link>https://live.paloaltonetworks.com/t5/cortex-xdr-discussions/export-view-information-about-windows-endpoints-missing-with-kb/m-p/529978#M3563</link>
      <description>&lt;P&gt;Thanks for the info. I'll try it.&lt;/P&gt;</description>
      <pubDate>Mon, 06 Feb 2023 11:29:30 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/cortex-xdr-discussions/export-view-information-about-windows-endpoints-missing-with-kb/m-p/529978#M3563</guid>
      <dc:creator>haimmiller</dc:creator>
      <dc:date>2023-02-06T11:29:30Z</dc:date>
    </item>
  </channel>
</rss>

