User Profile
marktait19
Copper Contributor
Joined 3 years ago
User Widgets
Recent Discussions
Re: FirstDetected Field - where can I find it in the Defender schema?
Hi - my client hasn't opened up the API for me yet. I only have access to Hunting -> Advanced Hunting. Is the cveFirstSeenTimestamp - only available via the API? Is there an equivalent field I can find in Advanced Hunting? Thanks again, Mark1.3KViews0likes0CommentsList of End of Life OS and Software in MS Defender
Hi. In MS Defender, is it possible to get a report of devices which are End of Life (eg. Windows Server 2003) along with any end of line/out of support software (eg. .net 1.1, or specific apps) , which may be running on any device? I'm aware we can get security recommendations - but are there any more granular reports available, either through the Defender GUI, or via KQL? Thanks for any help, MarkSolved1.7KViews0likes1CommentRe: Security Recommendation - is it available in any table in KQL query editor
Hi - sorry, I wasn't clear - it's just not returning the number of results I'd expect. It should be listing 100's of devices, but I'm only seein 1 device listed in all 118 results. Thanks again, Mark5.4KViews0likes11CommentsRe: Security Recommendation - is it available in any table in KQL query editor
Thank you for your suggestion. When I run this, I'm only getting 1 device returned (with 118 results - I'm looking over the last 30 days), but I can't see anything in the query which would limit the results. I'll keep working with the query you've provided though -it must be a restriction on my end thats limiting it. Cheers, Mark5.6KViews0likes14CommentsFirstDetected Field - where can I find it in the Defender schema?
Hi - in Microsoft 365 Defender, when running Kusto queries - which table will I find the "First Detected" field against a device? I can see it in the Device Summary page, but can't find it in any of the available tables in the schema. Thanks for any advice, MarkRe: Microsoft 365 Defender - where to create a custom list of devices
Thank you - I suspect that may be the issue. What I'm trying to do seems pretty simple (create a list of devices I can update once and use across multiple queries). I'll reach out to the platform support to see if they can recommend the specific permissions required. All the best, Mark2.1KViews2likes0CommentsRe: Microsoft 365 Defender - where to create a custom list of devices
Robina Hi Robina - thank you for your reply. When I select devices on the Devices page, I do not see "Add to custom list", I only see: Manage Tags Initiate Automated Investigation Device Value Exclude Report Inaccuracy I've attached a screenshot. Have I missed something, or is it perhaps that I don't have specific permissions to create custom lists? Thanks again, Mark2.1KViews0likes3CommentsMicrosoft 365 Defender - where to create a custom list of devices
Hi - where in MS 365 Defender can I create a custom list of devices, that I can just update once and reference in multiple KQL queries? I have looked in Settings - there is no option for Microsoft Defender for Endpoint lists. Thanks for any help, MarkSolvedSecurity Recommendation - is it available in any table in KQL query editor
Hi. When in Security Recommendations, I can enter a CVE reference, and there is a column in the display for "Security Recommendation" (please see attached screenshot). So for example, for: CVE-2020-1938 The Security Recommendations advises: Update Apache Tomcat Is there any table available within the KQL editor, that will display that recommendation for a given CVE? I've checked in DeviceTvmSoftwareVulnerabilitiesKB and DeviceTvmSoftwareVulnerabilities - however the Security Recommendations field is not available in either of those. Any help would be much appreciated, Thanks, MarkSolvedKQL to filter by Tags - is it possible?
Hi - is it possible within Advanced Hunting, to filter based on an associated Tag? I have added a "where Tag..." in the KQL below, but I can't actually see where the Tags are held and how to filter. Any help would be appreciated, Thanks, Mark DeviceNetworkInfo | join DeviceTvmSoftwareVulnerabilities on DeviceId | join DeviceTvmSoftwareVulnerabilitiesKB on CveId | where Tag has_any ( "tag1", "tag2" )
Recent Blog Articles
No content to show