Author: Trevor Jones

Checking for Updated Secure Boot Certificates

Posted on by Trevor Jones in Compliance, Intune, Powershell, Reporting, Security, Software Updates

A couple of months back Microsoft published a blog about Secure Boot certificates expiring in June 2026 and of the potential need to take action. It would appear that as long as Secure Boot is enabled, your OEM firmware is up-to-date, you are sending the right diagnostic data, and Windows updates are enabled, devices should … Continue reading Checking for Updated Secure Boot Certificates →

Next Generation Data Analysis – Connecting AI to your Database

Posted on by Trevor Jones in AI, ConfigMgr, Intune, PowerBI, Reporting, SCCM, SQL

Back when our company decided to migrate endpoint management workloads to Microsoft Intune from Microsoft Configuration Manager, I quickly realized we would be missing some key capabilities. Not least of which is comprehensive hardware inventory data which, to this day, is still sorely lacking in Intune. Having in-depth, customizable inventory on our Windows endpoints is … Continue reading Next Generation Data Analysis – Connecting AI to your Database →

QuietShell – Executing PowerShell without a Console Window

Posted on by Trevor Jones in C#, Powershell

For some time I've used a simple VBScript wrapper in code projects and scheduled tasks to allow silent execution of PowerShell scripts in the user context without displaying a console window: p = CreateObject("Scripting.FileSystemObject").GetParentFolderName(WScript.ScriptFullName) location = p &"\"& WScript.Arguments(0) command = "powershell.exe -nologo -ExecutionPolicy Bypass -File """ &location &"""" set shell = CreateObject("WScript.Shell") shell.Run command,0 … Continue reading QuietShell – Executing PowerShell without a Console Window →

Create a Catalog of Windows Update Data using Microsoft Graph

Posted on by Trevor Jones in Compliance, Intune, Powershell, Reporting, Security, Software Updates

For some time I have run my own reporting solution for Windows Updates since I've never really been happy with the canned reports Microsoft have created in Intune and Windows Update for Business reports, even to this day. As part of this solution I have had to gather data on Windows Updates, such as versions, … Continue reading Create a Catalog of Windows Update Data using Microsoft Graph →

Harnessing AI in PowerShell: Prompting like a Pro

Posted on by Trevor Jones in AI, Powershell

Understanding Effective AI Prompting: Core PrinciplesClarity and SpecificityContext is KingStructured Problem PresentationIterative RefinementError Message InclusionVersion and Environment DetailsPerformance RequirementsSecurity ContextCode GenerationCode Review and OptimizationBest Practices ImplementationThe Art of Iterative PromptingStarting with a Basic PromptRefining Your PromptFollowing UpExtended PowerShell-Specific ExamplesScenario 1: Active Directory User ManagementScenario 2: Performance OptimizationUnderstanding AI's Problem-Solving ApproachAdvanced Prompting TechniquesRole-Based PromptingComparative PromptingEducational PromptingThe … Continue reading Harnessing AI in PowerShell: Prompting like a Pro →

Harnessing AI in PowerShell: Create a TimeZone Script for Windows Autopilot with AI

Posted on by Trevor Jones in AI, Intune, Powershell

Get time zone from geolocation dataConvert IANA time zone to Windows time zoneAdd logging, error handling and create a summaryConclusion In this post I want to walk through a real-world example of creating a useable PowerShell script simply by prompting an AI model in conversation. The goal for this script is: to determine the appropriate … Continue reading Harnessing AI in PowerShell: Create a TimeZone Script for Windows Autopilot with AI →

Harnessing AI in PowerShell: Comparing Generative AI Models

Posted on by Trevor Jones in AI, Powershell

IntroductionAI Model TESTSTEST 1: Generate a simple function that solves a specific logic problemTEST 2: Create an advanced function with more complex requirementsTEST 3: Convert text output to an ordered PowerShell objectTEST 4: Debug PowerShell codeTEST 5: Improve poorly written PowerShell codeSummaryOpenAIAnthropicGoogleX AIPerplexityConclusion Introduction Whilst having access to several different AI models is a cool … Continue reading Harnessing AI in PowerShell: Comparing Generative AI Models →

Harnessing AI in PowerShell: Create a multi-model command-line AI assistant (Part 2)

Posted on by Trevor Jones in AI, Powershell

Prepare the PowerShell scriptScript parametersModel and API parametersModel parametersAPI parametersSet Az ContextUpdate your PowerShell profile scriptLet's chat!Use the defaultsOutput to browserUse different AI modelsInclude token statisticsReview session statisticsStart a new chatReview your chat historyIncrease the max tokens countProvide a context fileSearch the internet with AIChange the system promptSend multiple promptsChange the temperatureConclusion In our last … Continue reading Harnessing AI in PowerShell: Create a multi-model command-line AI assistant (Part 2) →

Harnessing AI in PowerShell: Create a multi-model command-line AI assistant (Part 1)

Posted on by Trevor Jones in AI, Azure, Powershell

Azure AICreate a projectAdd AI modelsGrant role permissionsMonitoring cost and usageAnthropic AIOpenAIGoogle AIX AIPerplexity AIStoring your API keys in Azure KeyVaultConclusion AI is virtually inescapable these days. From annoying website chat bots to the assimilation of the Microsoft product portfolio by Copilot, AI has been busy spreading its tentacles every which way it can. I … Continue reading Harnessing AI in PowerShell: Create a multi-model command-line AI assistant (Part 1) →