Your company's ad could live here and reach over 50,000 people a month!

System Center

Video Card Details v2

For full details please see http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/c42ba8cf-02a5-4e2e-8d20-39b05a4a5740 select distinct R.Netbios_Name0 as 'Name', R.User_Name0 as 'User', CS.Manufacturer0 as 'Manufacturer', CS.Model0 as 'Model', BIOS.SerialNumber0 as 'Serial', SD.Name0 as 'Processor', RAM.TotalPhysicalMemory0 as 'Memory', VC.Name0 as 'Video Card', VC.VCRam as 'Video Card RAM' from dbo.v_R_System R inner join dbo.v_GS_X86_PC_MEMORY RAM on RAM.ResourceID = R.ResourceId inner join dbo.v_GS_COMPUTER_SYSTEM CS on CS.ResourceID = R.ResourceID inner join dbo.v_GS_PC_BIOS BIOS on BIOS.ResourceID =R.ResourceId inner join dbo.v_GS_SYSTEM_DEVICES SD on SD.ResourceID = R.ResourceId left outer ...

Video Card details

For full details please see http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/c42ba8cf-02a5-4e2e-8d20-39b05a4a5740 select distinct R.Netbios_Name0 as 'Name', R.User_Name0 as 'User', CS.Manufacturer0 as 'Manufacturer', CS.Model0 as 'Model', BIOS.SerialNumber0 as 'Serial', SD.Name0 as 'Processor', RAM.TotalPhysicalMemory0 as 'Memory', VC.Name0 as 'Video Card', Convert(VarChar, VC.AdapterRam0 / 1024) + ' MB' as 'Video Card RAM' from dbo.v_R_System R inner join dbo.v_GS_X86_PC_MEMORY RAM on RAM.ResourceID = R.ResourceId inner join dbo.v_GS_COMPUTER_SYSTEM CS on CS.ResourceID = R.ResourceID inner join dbo.v_GS_PC_BIOS BIOS on BIOS.ResourceID =R.ResourceId inner join dbo.v_GS_SYSTEM_DEVICES SD on SD.Res...

Video Card details

For full details please see http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/c42ba8cf-02a5-4e2e-8d20-39b05a4a5740 select distinct R.Netbios_Name0 as 'Name', R.User_Name0 as 'User', CS.Manufacturer0 as 'Manufacturer', CS.Model0 as 'Model', BIOS.SerialNumber0 as 'Serial', SD.Name0 as 'Processor', RAM.TotalPhysicalMemory0 as 'Memory', VC.Name0 as 'Video Card', Convert(VarChar, VC.AdapterRam0 / 1024) + ' MB' as 'Video Card RAM' from dbo.v_R_System R inner join dbo.v_GS_X86_PC_MEMORY RAM on RAM.ResourceID = R.ResourceId inner join dbo.v_GS_COMPUTER_SYSTEM CS on CS.ResourceID = R.ResourceID inner join dbo.v_GS_PC_BIOS BIOS on BIOS.ResourceID =R.ResourceId inner join dbo.v_GS_SYSTEM_DEVICES SD on SD.Res...

  • 1
  • 9
  • 10