Git Product home page Git Product logo

mde-powerbi-templates's Introduction

About

This repo contains sample Power BI Report templates powered by Microsoft Defender Advanced Threat Protection Advance Hunting Queries. With these sample templates, you can start to experience the integration of Advanced hunting into Power BI. For samples of Advance Hunting queries, visit https://github.com/Microsoft/WindowsDefenderATP-Hunting-Queries

To get started, simply download a template and authenticate to your tenant. For more details on how to authenticate into the Advance Hunting API, visit https://docs.microsoft.com/en-us/windows/security/threat-protection/windows-defender-atp/apis-intro

When sharing Power BI Report templates, please export the template using this process to export without data: click “File –> Export –> Power BI Template” from the main Power BI Desktop window. A Power BI Report Template contains the definition of the Report (pages, visuals, etc.), Data Model definition (schema, relationships, measures, etc.) and Queries definition (collection of queries, including Query Parameters, etc.). In other words, a Power BI Report template includes pretty much everything that a Report file includes, with the exception of the data itself. For more details, visit https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/.

Not using Microsoft Defender ATP? If you haven't yet, experience how you can effectively scale your organization's incident response capabilities by signing up for a free Microsoft Defender ATP trial.

Suggestions and Feedback

We maintain a backlog of suggested sample Power BI templates in the project issues page. Feel free to comment, rate, or provide suggestions. We value your feedback. Let us know if you run into any problems or share your suggestions by adding an entry into the issues section.

Contributing

This project welcomes contributions and suggestions. Most contributions require you to agree to a Contributor License Agreement (CLA) declaring that you have the right to, and actually do, grant us the rights to use your contribution. For details, visit https://cla.microsoft.com.

When you submit a pull request, a CLA-bot will automatically determine whether you need to provide a CLA and decorate the PR appropriately (e.g., label, comment). Simply follow the instructions provided by the bot. You will only need to do this once across all repos using our CLA.

This project has adopted the Microsoft Open Source Code of Conduct. For more information see the Code of Conduct FAQ or contact [email protected] with any additional questions or comments.

mde-powerbi-templates's People

Contributors

abswaroo avatar dominique97 avatar gaburn avatar j0shbregman avatar microsoft-github-policy-service[bot] avatar microsoftopensource avatar msftgits avatar secureitblanket avatar sujitnaray avatar tewchen-zz avatar yongrhee-mde avatar yongrhee-msft avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

mde-powerbi-templates's Issues

V3 Line 604 - Calling wrong function for lnk files?

In version 3 of AddShortcuts.ps1, on line 604:

$lnks += getAllValidExtsForDrive -path $res -drive $drive -prefix "$($profiledir)\Desktop\" -extension ".lnk"  

Should be

$lnks += getAllValidLNKSForDrive -path $res -drive $drive -prefix "$($profiledir)\Desktop\" 

using getAllValidExtsForDrive does not check for the target object's existence

Typo in var name passed to SaveResult

The -HKUAppsFailure parameter passed to SaveResult on line 681 passes the variable named $hku_apps_failure. The variable is $hku_apps_failures (with an 's') on line 677 though so that value won't get logged to the registry correctly.

Recreating public desktop icons

If we add

$lnks += getAllValidLNKsForDrive -path $res -drive $drive -prefix "Users\Public\Desktop\"

after line 483 in v1.1 of the script this would seem to allow retrieval of public desktop icons from VSS

Typo in "About"

"A respository for MDATP PowerBI Templates"
should be
"A repository for MDATP PowerBI Templates"

Excel, Outlook, Word, Power Point does not work

Hello, i ran the script but it didn't work for the microsoft 365 apps for entreprise.

If i repair the applications by hand it works.

Do you have a solution to apply on the script?

Thank you in advance

Multilungual support for known folders

Hi,

After running the script AddShortcuts known folders are now in mixed languages, both Swedish and English - not OK :-(

How do we resolve this issue?

Me and my co-workers are running Swedish Windows 11 22H2.

image

Script only runs on en-US due to localization of group names - use SID well-known instead

Script only runs on en-US due to localizaion of group names - use well-known SID in function instead:

Function CopyAclFromOwningDir($path) {
$base_path = Split-Path -Path $path
$acl = Get-Acl $base_path
$SID = "S-1-5-32-544"
$Group = (New-Object System.Security.Principal.SecurityIdentifier($SID)).Translate([System.Security.Principal.NTAccount])

$acl.SetOwner($group)
Set-Acl $path $acl
}

PowerShell task does not run on assigned user or devices

Hello,

Following the instructions on the page i've setup a powershell script to run on the "TestUser" group which I have created in Microsoft Endpoint Manager. This group consists of 2 users and 2 devices, however despite trying several times, the script to restore the shortcut's deleted by the microsoft defender update still does not run. It simply lists the script as "0 successes, 0 errors on 0 devices".

Trying to run the restore.ps1 script on my device locally throws a "UnauthorizedAccess" error.

How do I fix this? I've searched around and made sure that my device and workaccount are linked/enrolled via Azure AD, yet I still cant make the restore shortcut script run.

Under device status in the script my device is simply listed as "Status: Unknown", yet I can see OS version, device ID and username associated.

Only works with applications specified if the registry key

Great script, but currently only works with applications registered in the specific registry key.

If we were able to specify a full path for apps requiring them and then modify the code to test if a full path is provided, then this would increase flexibility - (scrappily coded) eg:

"KeePass" = "C:\Program Files (x86)\KeePass Password Safe 2\KeePass.exe"

Then modify the code between line 111 and 119 (inclusive)to:

        if ($testFullPath) {
            if (test-path $_.value) {
                $target=$_.value
                #LogAndConsole "Full path specified and exists for $($_.key)"
            }
        } 
        if (-not ($testFullPath -or $target))
        {        
            try { $apppath = Get-ItemPropertyValue $reg_path -Name "Path" -ErrorAction SilentlyContinue } catch {}
            if ($apppath -ne $null)
            {
                $target = $apppath + "\" + $_.Value
            }
            else
            {
                try { $target = Get-ItemPropertyValue $reg_path -Name "(default)" -ErrorAction SilentlyContinue } catch {}
            }
        }

This could allow flexibility to do so with minimal change, albeit this does not allow for custom file locations (or potential 32 bit/64 bit variations).

Not saying this is appropriate in every environment or situation but looks like it will work in ours

Script error: Cannot bind argument to parameter 'Path' because it is null

I get this error:
[+] Starting LNK rescue - Script version: v2
[+] Saved Result: ScriptResult=Failure (1), TimeStamp=2023-01-17T08:51:24.2825358Z, NumLinksFound=0, HKUAppSuccess=0, HKUAppFailure=0, HKLMSuccess=0, HKLMFailure=0, ScriptError=Cannot bind argument to parameter 'Path' because it
is null. in registry HKLM:Software\Microsoft\ASRFix

I am running the script from powershell ISE, elevated as administrator.

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.