Hello,I have 'Intune v2' scanning target setup and it is discovering my mobile devices (iOS, android), but it is not discovering the workstations that are managed by intune. Specifically, the ones that are NOT domain joined and only managed by intune...
I smashed this together pretty quickly, but thought I'd share.As part of SCCM OSD I have a vbs script that writes environment variables to the registry.Then I collect those with LS.Add scanning HKLM registry entries to LSSOFTWARE\_IT\SCCM\OSD'Install...
Uses windows event log Microsoft-Windows-WER-SystemErrorReporting and code 1001Select Distinct Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tblADusers.Displayname, tblAssets.OScode, tblNtlog.Eventcode, Max(tblNtlog.TimeGenerated) As LastO...
This report was to help identify computer that were experiencing a large number of unexpected reboots.Uses Windows Event: Microsoft-Windows-Kernel-Power event code 41 to identify occurrences.Select Distinct Top 1000000 tblAssets.AssetID, tblAssets.A...
comtcjm wrote:Getting the following error:Error: The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value.Am I missing something?thanksI was missing something:Where tblQuickFixEngineering.InstalledOn Like '%/%'...
Error while saving: "There was an error parsing the query. [ Token line number = 1,Token line offset = 530,Token in error = Left ]After making the edits on October 19, Change line 14 from Left(tblADComputers.OU, CharIndex(',', tblADComputers.OU) - ...
Expressions in the ORDER BY list cannot contain aggregate functions.That would be it complaining about the the count aggregate functions in line 60 & 61 in order by.Change Order By Count(tblNtlog.TimeGenerated) Desc,LastOccurrence Desc,to Order By
Error: There was an error parsing the query. [ Token line number = 1,Token line offset = 137,Token in error = Left ]I'm pretty sure the line you're having problems with is the 5th line under select: Left(tblADComputers.OU, CharIndex(',', tblADCompute...
Getting the following error:Error: The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value.You're getting that error because something in your database's dbo.tblQuickFixEngineering InstalledOn field isn't bein...