SCCM SQL Query : SQL Query for Client Count per AD Site

Get link
Facebook
Twitter
Pinterest
Email
Other Apps

By San - June 02, 2016

SELECT

R.AD_Site_Name0,

Count(SMS_Installed_Sites0) AS 'Count'

From

v_R_System R

JOIN v_RA_System_SMSInstalledSites SIS ON R.ResourceID = SIS.ResourceID

Group By

R.AD_Site_Name0

Get link
Facebook
Twitter
Pinterest
Email
Other Apps

Comments

SCCM SQL Query : To List Machines With IIS , FTP Or Telnet Installed

By San - September 21, 2014

Select SD.Name0 ‘Machine Name’, SD.Operating_System_Name_and0 NOS, SS.Name0 ‘Service Name’, SS.DisplayName0 ‘Display Name’, SS.StartMode0 ‘Start Type’, SS.Started0 Started, SS.State0 State, SS.Status0 Status From System_DISC SD Join Services_DATA SS on SS.MachineID = SD.ItemKey Where SS.Name0 In (‘W3SVC’, ‘MsFtpSvc’, ‘TlntSvr’) Order By ‘Machine Name’

SCCM SQL Query : To Gather Video Card Memory Information

By San - September 21, 2014

Select SD.Name0 ‘Machine Name’, VC.Name0 ‘Video Card’, Convert(VarChar, VC.AdapterRam0 / 1024) + ‘ MB’ From v_R_System SD Join v_Gs_Video_Controller VC on SD.ResourceID = VC.ResourceID Where VC.Name0 <> ‘ConfigMgr Remote Control Driver’ Order By SD.Name0

SCCM SQL Query : To Get Members Of A Specified Collection

By San - September 21, 2014

Select Members.Name ‘Collection Members:’ From CollectionMembers Members Join Collections Coll on Members.SiteID = Coll.SiteID Where Coll.CollectionName = ‘All Systems’

Search This Blog

SystemCenter Titans