Query Model/Serial No. of Dell machine

[Packie]

Hi,

 

I have this query to retreive machine model & S/N.

select SMS_G_System_PC_BIOS.SerialNumber, SMS_R_System.Name, SMS_R_System.LastLogonUserName, SMS_G_System_COMPUTER_SYSTEM.Manufacturer, SMS_G_System_COMPUTER_SYSTEM.Model from  SMS_R_System inner join SMS_G_System_PC_BIOS on SMS_G_System_PC_BIOS.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId where System.Name = ##PRM:SMS_R_System.Name##

 

but it does not return any result

but how do i make it to prompt for particular machine hostname only?

 

thanks in advanced

[Eswar Koneti]

You will have to create collection under quiries section to prompt for hostname,btw,where are you creating this ?

 

Try creating this collection/report:

 

http://wmug.co.uk/bl...n-computer.aspx

 

and here is summary of computer information http://eskonr.wordpr...cm-web-reports/

 

Moving this post under collection section.

[Packie]

You will have to create collection under quiries section to prompt for hostname,btw,where are you creating this ?

 

Try creating this collection/report:

 

http://wmug.co.uk/bl...n-computer.aspx

 

and here is summary of computer information http://eskonr.wordpr...cm-web-reports/

 

Moving this post under collection section.

select SMS_G_System_COMPUTER_SYSTEM.Manufacturer, SMS_G_System_PC_BIOS.SerialNumber, SMS_G_System_COMPUTER_SYSTEM.Model, SMS_R_System.LastLogonUserName from  SMS_R_System inner join SMS_G_System_PC_BIOS on SMS_G_System_PC_BIOS.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_R_System.Name = ##PRM:SMS_R_System.Name##

 

awesome... this code is now working for me

thank you