LS 4.0 - Need to run a software report on a specific OU

[ESIT]

I need help running a report software report on a OU. Would like the normal software output (vendor, version, etc.) but would also like the serial number of the software if at all possible.

This if for a Audit from Adobe at one of our sites so this would be very helpful right now.

Thanks!

[ESIT]

Found my error, missed a level in the OU structure.

Thanks a ton for your help with this!

[ESIT]

Ok,found my mistake, so now I have the code like this:

Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique, tblComputers.Domain, tblADComputers.OU, tblSoftware.softwareName, tblSoftware.softwareVersion From tblComputers Inner Join tblADComputers On tblComputers.Computername = tblADComputers.Computername Inner Join tblSoftware On tblComputers.Computername = tblSoftware.ComputerName Where tblADComputers.OU = 'OU=Computers,OU=blah,OU=AMER,DC=blahblah,DC=com'


I saved it just fine, but when I try to see the output I get nothing.

[ESIT]

Thank you, but I have a dumb question.

Can I just paste this on the bottom section of a New report and save and run? Do I have to still add tables and etc? I'm not good with SQL at all other than creating SQL Server Clusters, lol.

I tried and entered the OU where you said (ex. OU=Computers,OU=blah,OU=AMER,DC=blahblah,DC=com), but just get line errors when trying to save.

Thanks and I appreciate the help.

[Hemoco]

Select tblComputers.Computername, tblComputers.ComputerUnique,
  tblComputers.Domain, tblADComputers.OU, tblSoftware.softwareName,
  tblSoftware.softwareVersion
From tblComputers Inner Join                               
  tblADComputers On tblComputers.Computername = tblADComputers.Computername
  Inner Join
  tblSoftware On tblComputers.Computername = tblSoftware.ComputerName
Where tblADComputers.OU = 'the ou you want'

[Hemoco]

The software table and serialnumber tables are two separate things, you can't match them.

I suggest creating 2 different reports for this.

[ESIT]

Lansweeper wrote:
The software table and serialnumber tables are two separate things, you can't match them.

I suggest creating 2 different reports for this.

Ok so scratch the serial number. I still don't know how to run a software report on a specific OU. Could you help with that. Looking for just Adobe software but will take all software and sort if needed. Just need to know how to run reports on a specific OU.