Rapid7 Insight Agent Update Fix Discover Script

# Rapid7 Insight Agent Update Fix Discover Script # Rui Qiu # v1.1 # 4/3/2018 $folder = “C:\Program Files\Rapid7\Endpoint Agent” if (test-path $folder) { $content = (get-content config.json | where { $_ -match “smart_ttl_start” } ) # echo $content $key = ‘ “smart_ttl_start”: 128,’ # echo $key if ($content -eq $key) {$Compliance = “Yes”} Else […]

Issues Installing Shavlik (Ivanti Patch)

I didn’t realize a simple issue can cause a big issue with Shavlik: When launching the installer from Shavlik, you have to “Unblock” the file before running the isntaller, otherwise you will get failed to create folder when you are running the Ivanti Patch checker. And when you launch the SCCM console, you have to […]

SCCM SQL Report for All Office Users

Here is the sccm sql report statement to finding out all office users, I have used “Microsoft Office Professional” as the keyword, you can change to any software title you want 🙂   SELECT DISTINCT TOP (100) PERCENT RV.AD_Site_Name0 AS [AD Site], RV.Netbios_Name0 AS [PC Name], RV.Creation_Date0 AS [PC Joined Date], RV.User_Name0 AS [User Name], […]

Another way to check Update Installed via Powershell

I have to check if machine has MS March update installed, and SCCM cannot make my job simpler 🙁 So I created a new compliance rule to check the result, here is the code: $error.clear() try { $Session = New-Object -ComObject “Microsoft.Update.Session” $Searcher = $Session.CreateUpdateSearcher() $historyCount = $Searcher.GetTotalHistoryCount() $Searcher.QueryHistory(0, $historyCount) | Select-Object Title, Description, Date, […]

More Accurate SCCM Software Metering Report

I found out that the sccm table view v_MonthlyUsageSummary is not really accurate, actually v_GS_CCM_RECENTLY_USED_APPS.LastUsedTime0 is the best accurate one to determine user’s application usage by SCCM: here is my SQL query: SELECT DISTINCT TOP (100) PERCENT RV.AD_Site_Name0 AS [AD Site], RV.Netbios_Name0 AS [PC Name], RV.User_Name0 AS [User Name], dbo.v_GS_CCM_RECENTLY_USED_APPS.LastUsedTime0 AS [Last Used Time], dbo.v_GS_CCM_RECENTLY_USED_APPS.OriginalFileName0 […]