Making a Report / Pulling specific information from a collection of computers

[xerxes2985]

Hi all,

I need to create a report that will pull some simple information (ComputerName, SerialNumber, BiosVersion and BiosName) from a collection of computers. 

Manually, I can go to Resource Explorer and expand hardware, and PC BIOS, and get the information, but was wondering if I could extrapolate this easier?

 

Thanks

[GarthMJ]

What do you have for a query already? what isn't working for you? 

[xerxes2985]

I found a query that works (I added to the queries section in the Monitoring tab). I can get the information I need from there, but I cannot figure out how to take that query and use Report Builder (so I can have a pretty looking report via SSRS)

select distinct SMS_R_System.Name, SMS_G_System_PC_BIOS.SerialNumber, SMS_G_System_PC_BIOS.SMBIOSBIOSVersion, SMS_R_System.IPAddresses, SMS_R_System.MACAddresses from SMS_R_System inner join SMS_G_System_PC_BIOS on SMS_G_System_PC_BIOS.ResourceID = SMS_R_System.ResourceId

[GarthMJ]

To convert this to SQL. I would prefect the query within SQL server Management studio first, before bring it over to report builder. The views that you need are:

SMS_R_System = v_r_system

SMS_G_System_PC_BIOS = v_GS_PC_BIOS

 

[xerxes2985]

Thanks @GarthMJ!