I would like to do a query to see how many Dell GX620 I have on the network. I would like to know the logged on user as well. How do I do this?

A report would be better but here is a query for you..Looks for all Dell GX620's Gives you the computer name, last user per heartbeat and last user per HW inventory.If you look at the top of the Query after you run it there will bea XXX items found which will give you the total number of machines.------------select SMS_R_System.Name, SMS_G_System_COMPUTER_SYSTEM.UserName, SMS_R_System.LastLogonUserName 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.Model = "OptiPlex GX620"-------------------------http://www.sccm-tools.com http://sms-hints-tricks.blogspot.com