I'd like to create a report which ONLY lists computers which have a Windows Server OS installed (2003, 2008, 2008 R2, 2012, 2012 R2, etc). All I really need to have is the asset name, and the OS version installed. The pre-defined asset lists always...
When I exclude one the code isWhere tsysAssetTypes.AssetTypename != 'Monitor' And tblState.Statename = 'Active'Order By AssetType, tblAssets.AssetNameAnd it excludes MonitorBut when I add another one more to the Or.. it looks likeWhere (tsysAssetTy...
I have a report that is supposed to list all the windows 10 machines in our environment. We have two new windows 10 machines that are not showing up on that report, but are showing up on the new computers detected. The report (See below) is filtered ...
Trying to setup a generic report query, where i am able to punch in the specific KB's to determine which assets are missing the KB's with their OS version. We are running version 6.0.100.x and currently trying to report on (CVE Microsoft Equation Ed...
Hello, I´m desperate with a report I´m trying to generate:My goal is to list all portable windows-devices which does NOT have a specific software installed (In this case Sophos Safeguard client).I have created the below report, but it returns about 4...
You can edit this one for servers as well... i'm too lazy to change the query aliases Add the following to file/registry scanning:%windir%\CCMSetup\ccmsetup.exeHKLM/SOFTWARE\Microsoft\CCM\CcmEval LastEvalTimeHKLM/SOFTWARE\Microsoft\CCM\CcmEval Las...
