Hi, please help me make a query which will prompt for the computer manufacturer (acer, ibm, etc) then list the computers under that manufacturer. thanks

Hi Johan,You can use this one:select distinct SMS_R_System.Name, SMS_G_System_COMPUTER_SYSTEM.Manufacturer, SMS_G_System_COMPUTER_SYSTEM.Model from SMS_R_System inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceId = SMS_R_System.ResourceId where SMS_G_System_COMPUTER_SYSTEM.Manufacturer like ##PRM:SMS_G_System_COMPUTER_SYSTEM.Manufacturer##You can use wildcards in the prompt e.g. Len% for all manufacturers starting with LenKent Agerlund | http://scug.dk/members/Agerlund/default.aspx | The Danish community for System Center products

i copied and paste the statement on sql reports and its giving me a syntax error.

The query is a WQL query that should be used in your query node to work.http://www.sccm-tools.com http://sms-hints-tricks.blogspot.com