This project took significantly longer to develop than expected, but I’m proud to share my thoughts and process in developing this applet. The code evolved into a two-part tool that can be run from the command line or as a daemon. The code collects system information, reports it back to an API, and stores the […]
Query to determine machines less than a Pentium
select distinct ServerName,vss.percentfree, vss.status, dp.sitecode, dp.bitsenabled, vss.DownSince,vss.TimeReported from vSummarizer_SiteSystem as vss left join v_DistributionPointInfo as dp on vss.SiteSystem = dp.NALPath where vss.role = ‘SMS Distribution Point’ and vss.status > 0 order by servername, downsince
So, Let’s say you need to see all machines that contain a specific software package, you can use sccm’s gui, or you can do it in SQL, where you can act on the results: declare @LookupString as nvarchar set @LookupString = ‘%’ SELECT vrs.Name0 FROM v_r_system AS vrs JOIN v_GS_INSTALLED_SOFTWARE AS VIS ON […]