rgiroux,

Your going to want to join the label and machine label join tables to the report.

Give the sql a shot and post what you have.

If you post an attempt, well help with the rest.

Hi GillySpy,
Thanks for you explanation. At the moment I can create the report for a computer, thanks your help.
Now, I'm trying to do the same for a computer group.
I already have a Label and I need to change the cod you give to me for use this label.
Where I need to change?
Best regards,
Rildo

I just realized I had your question confused with another post.  Regardless of where the label came from (ldap , smart, etc) you could incorporate a label. Don't have time to illustrate atm

Yes you can do something similar with labels. In your kbox there is an example ldap label called "MemberOfBuildingA"that should help

Many Thanks GillySpy.
Work very good.
Sorry for take your time but i still have a question:
I have a Computer Label and this label is connected to a LDAP Label.
It is possible to do the same for my Label Computer Group?
Best regards,
Rildo

Duplicate the canned report called "Software on computer". Then modify it for a specific machine:
e.g.   

Select CONCAT(MACHINE.NAME, "\\", MACHINE.SYSTEM_DESCRIPTION) as MACHINE_NAME, DISPLAY_NAME,   
  DISPLAY_VERSION, PUBLISHER from (SOFTWARE, MACHINE_SOFTWARE_JT, MACHINE) where MACHINE.ID = 
  MACHINE_SOFTWARE_JT.MACHINE_ID and SOFTWARE.ID = MACHINE_SOFTWARE_JT.SOFTWARE_ID and not IS_PATCH
  and MACHINE.NAME = 'enter machine name here'
  order by MACHINE_NAME, DISPLAY_NAME