MECM: SQL query for a report by collection, model, count
Wanted to create a SQL query to get a count of every model, per vendor like Dell based on the collection being used for creating a report in SSRS. This is a start. SELECT coll.Name AS [Collection Name], sys.Model0 AS [Model], COUNT(DISTINCT sys.ResourceID) AS [Model Count] FROM v_FullCollectionMembership fcm JOIN v_Collection coll ON fcm.CollectionID =…
Read more
PowerShell: install Oracle Java 21
learning to install silently install Oracle Java 21 SDK Search for a .msi file containing jdk-21 in its name. Install it silently to the target directory. Set JAVA_HOME and update PATH. Handle errors gracefully. # PowerShell Script: Auto-detect and install Oracle Java 21 SDK (64-bit) from local MSI # Requirements: # – Run as Administrator # – MSI file must already…
Read more
PowerShell: Download Tool
Testing a new process for downloading #region Variables $Script:FormWidth = 1080 $Script:FormHeight = 800 $Script:Formicon = “batman.ico” $Script:FormTitle = “Batman Download & Deploy Tool” $Script:FormVersion = “v2026.03.07” $Script:DownloadPath = “C:\Source\Download” $Script:LogPath = “C:\Logs” $Script:ChromeUrl = “https://dl.google.com/chrome/install/googlechromestandaloneenterprise64.msi” $Script:FirefoxUrl = “https://download.mozilla.org/?product=firefox-msi-latest-ssl&os=win64&lang=en-US” $Script:SevenZipUrl = “https://www.7-zip.org/a/7z2600-x64.msi” # Adjust as needed $Script:Notepadplusplusurl = “https://github.com/notepad-plus-plus/notepad-plus-plus/releases/download/v8.9.2/npp.8.9.2.Installer.x64.msi” $Script:FolderDate = Get-Date -Format “yyyyMMdd” $Script:ChromeDest…
Read more