March 18, 2022
Announcements!
AsBuiltReport.Microsoft.AD v0.7.0!
(github.com)
Check out what's new!
By: AsBuiltReport submitted:Jun 16 2022
Check out what's new!
By: AsBuiltReport submitted:Jun 16 2022
Blogs, Articles, and Posts
A great discussion on Twitter about when to use PowerShell vs C#
(twitter.com)
Whenever I review PowerShell from someone who is really good at it, I'm always envious. But
By: David Pine submitted:Jun 16 2022
Whenever I review PowerShell from someone who is really good at it, I'm always envious. But
sometimes, when there is a lot of code...I think to myself, this would be better in a .NET app, for testability
By: David Pine submitted:Jun 16 2022
Building a Discord Bot in PowerShell and Azure Functions
(blog.dcrich.net)
I like using Discord to accomplish stuff. But I'm no programmer. That leaves me with little space to
By: Devin Rich submitted:Jun 16 2022
I like using Discord to accomplish stuff. But I'm no programmer. That leaves me with little space to
operate in; making a Discord bot is hardT. I've made some scripts for my own usage that integrate with Discord bots, but they've always been for my own use only.
By: Devin Rich submitted:Jun 16 2022
Convert Dynamic Distribution Lists to Teams
(office365itpros.com)
After writing about the recent revamp of Exchange Online dynamic distribution lists, I was asked if
By: Tony Redmond submitted:Jun 16 2022
After writing about the recent revamp of Exchange Online dynamic distribution lists, I was asked if
it was possible to create a team from the membership of a dynamic distribution list. The answer is that the steps are straightforward to create a static Microsoft 365 group. Things get more complicated if you contemplate using a dynamic Microsoft 365 group.
By: Tony Redmond submitted:Jun 16 2022
Creating and publishing PowerShell Modules to Azure Artifacts with Azure DevOps YAML Pipelines
(faun.pub)
PowerShell Modules are very useful and can save a lot of time if well designed and created. Check on
By: Wesley Camargo submitted:Jun 16 2022
PowerShell Modules are very useful and can save a lot of time if well designed and created. Check on
this post how to create and pack a basic PowerShell Module, and publish it into Azure Artifact using Azure DevOps YAML Pipelines.
By: Wesley Camargo submitted:Jun 16 2022
Get-CIMInstance Vs Get-WMIObject: What’s The Difference?
(networkadm.in)
Sysadmins have been using WMI for years, and then Microsoft gave us data access via CIM with the
By: Mike Kanakos submitted:Jun 16 2022
Sysadmins have been using WMI for years, and then Microsoft gave us data access via CIM with the
rollout of PowerShell v3.0. What's the difference between these management interfaces? Which one should you use, and why?
By: Mike Kanakos submitted:Jun 16 2022
Quickly Open PowerShell for Folder
(community.idera.com)
In Windows Explorer, when you navigate to a folder, you can easily open a classic cmd or a
By: Idera submitted:Jun 16 2022
In Windows Explorer, when you navigate to a folder, you can easily open a classic cmd or a
PowerShell console with the current folder set as current path.
By: Idera submitted:Jun 16 2022
Variable name with a space in it? O_o
(reddit.com)
For those who have ever had to deal with this.
By: u/bee_administrator submitted:Jun 16 2022
For those who have ever had to deal with this.
By: u/bee_administrator submitted:Jun 16 2022
Projects, Scripts, and Modules
Introducing PSProjectStatus
(jdhitsolutions.com)
I write a lot of PowerShell modules. And probably like you, I am working on more than one project at
By: Jeff Hicks submitted:Jun 16 2022
I write a lot of PowerShell modules. And probably like you, I am working on more than one project at
a time. I was finding it difficult to keep track of what I was working on and what I might be neglecting. So I turned to PowerShell and created a tool that I use to keep on top of my projects.
By: Jeff Hicks submitted:Jun 16 2022
Invoke-ParameterisedSqlQuery.ps1
(gist.github.com)
Invoke-SqlCmd doesn't support parameterised queries, so you have to resort to magic strings, and
By: Neil Barnwell submitted:Jun 16 2022
Invoke-SqlCmd doesn't support parameterised queries, so you have to resort to magic strings, and
possibly leave yourself open to SQL injection attacks. While you may be the only one using your script, it's likely that you're using values you're getting from a database, file, or some other external source. So I finally got around to writing a function that supports parameterised queries, and thought I'd offer it up in case others find it useful.
By: Neil Barnwell submitted:Jun 16 2022
Windows security event log backup to SQL Server Express with PowerShell
(4sysops.com)
My ADSecurityLogArchivingManager PowerShell module is a custom monitoring data retrieval tool that
By: Krishnamoorthi Gopal submitted:Jun 16 2022
My ADSecurityLogArchivingManager PowerShell module is a custom monitoring data retrieval tool that
allows you to export security event logs to SQL Server Express, which Windows cleans from the system after a certain number of days. The tool enables you to create an offline Event Viewer for a specific computer.
By: Krishnamoorthi Gopal submitted:Jun 16 2022
Do you have a suggestion for PowerShell Weekly? Do you know something that should be included? Let me know in the comments below, or on
twitter.