SCCM Report to check Video card information G. 08:45 Report, SCCM 2007 No comments 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 Share This: Facebook Twitter Google+ Stumble Digg Email ThisBlogThis!Share to XShare to Facebook Related Posts:Adobe Products SCCM ReportReport that shows you all Adobe products filtred by machine name and AD site: SELECT SYS.Netbios_Name0 AS Computer_Name, SYS.AD_Site_Name0 AS… Read MoreLast Successful Site Server Backup DateSELECT stat.MachineName AS ServerName,stat.SiteCode AS SiteCode,MAX(stat.Time) AS LastBackUpTime FROM (SELECT a.… Read MorePatch Compliance Progression Reportselect CS.Name0, CS.UserName0,casewhen (sum(case when UCS.status=2 then 1 else 0 end))>… Read MoreSCCM Empty collectionsThis report will show all the empty collection in your SCCM: select C.Collectionid, C.Name from dbo.v_Co… Read MoreSCCM 2007 Spyware ReportSELECT DISTINCT RSYS.Name0 AS 'Computer', RSYS.User_Name0 As 'Last User ID', SF.FileName As 'File Name', &… Read More
0 commenti:
Post a Comment
Give me you feedback!