System Center

Joining Users to a PC

Use this query to join Users to PCs Select R.Name0, U.User_Name0, U.Full_User_Name0, U.Unique_User_Name0, U.Mail0 From dbo.v_R_System R INNER JOIN dbo.v_R_User U ON U.Unique_User_Name0 = R.User_Domain0 + ''+ R.User_Name0 .csharpcode, .csharpcode pre { font-size: small; color: black; font-family: consolas, "Courier New", courier, monospace; background-color: #ffffff; /*white-space: pre;*/ } .csharpcode pre { margin: 0em; } .csharpcode .rem { color: #008000; } .csharpcode .kwrd { color: #0000ff; } .csharpcode .str { color: #006080; } .csharpcode .op { color: #0000c0; } .csharpcode .preproc { color: #cc6633; } .csharpcode .asp { background-color: #ffff00; } .csharpcode .html { color: #800000; } .csharpcode .attr { color: #ff0000; } .csharpcode .alt { ...

Joining Users to a PC

Use this query to join Users to PCs Select R.Name0, U.User_Name0, U.Full_User_Name0, U.Unique_User_Name0, U.Mail0 From dbo.v_R_System R INNER JOIN dbo.v_R_User U ON U.Unique_User_Name0 = R.User_Domain0 + ''+ R.User_Name0 .csharpcode, .csharpcode pre { font-size: small; color: black; font-family: consolas, "Courier New", courier, monospace; background-color: #ffffff; /*white-space: pre;*/ } .csharpcode pre { margin: 0em; } .csharpcode .rem { color: #008000; } .csharpcode .kwrd { color: #0000ff; } .csharpcode .str { color: #006080; } .csharpcode .op { color: #0000c0; } .csharpcode .preproc { color: #cc6633; } .csharpcode .asp { background-color: #ffff00; } .csharpcode .html { color: #800000; } .csharpcode .attr { color: #ff0000; } .csharpcode .alt { ...

Joining Users to a PC

Use this query to join Users to PCs Select R.Name0, U.User_Name0, U.Full_User_Name0, U.Unique_User_Name0, U.Mail0 From dbo.v_R_System R INNER JOIN dbo.v_R_User U ON U.Unique_User_Name0 = R.User_Domain0 + ''+ R.User_Name0 .csharpcode, .csharpcode pre { font-size: small; color: black; font-family: consolas, "Courier New", courier, monospace; background-color: #ffffff; /*white-space: pre;*/ } .csharpcode pre { margin: 0em; } .csharpcode .rem { color: #008000; } .csharpcode .kwrd { color: #0000ff; } .csharpcode .str { color: #006080; } .csharpcode .op { color: #0000c0; } .csharpcode .preproc { color: #cc6633; } .csharpcode .asp { background-color: #ffff00; } .csharpcode .html { color: #800000; } .csharpcode .attr { color: #ff0000; } .csharpcode .alt { ...

Video card with Sound card.

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', Sound.Description0 as 'Sound card' 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 ...

Video card with Sound card.

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', Sound.Description0 as 'Sound card' 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 ...

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 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