Jon Gurgul's Blog

Category: Powershell

  • SQL Server Instance Security: Scripting Permissions

    —

    by

    Jon Gurgul
    in

    Another How-To post and this time focusing on scripting permissions. Here is how to script User(s), Object(s), Role(s), Server Role(s) and Server Object(s) Permissions. Beginning with the simple way via SSMS, before showing a custom script solution that I have written. Scripting SQL Server Security: Simple Solution In order to script the security settings for…

  • List Installed Software aka Get-InstalledSoftware

    —

    by

    Jon Gurgul
    in

    I needed a script to check for installed software on local and remote machines that did not rely on the Win32_Product WMI class as this will only return software that the windows installer knows about. One way to do this is via the visual basic script List All Installed Software (Microsoft) on script center, but…

  • WMI Classes Via Powershell

    —

    by

    Jon Gurgul
    in

    I wrote this a while ago to bring back the contents of a particular wmi class using powershell. It was orginally only developed to have a quick look at some wmi class settings. However as I continue to find it useful I have decided to repost the latest version. (I had posted this before back…