Lansweeper logo
Home Download Features Demo Buy now Help Support forum
 
    Most requested support articles:
  Lansweeper troubleshooting guide.
  The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)
  WMI Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))
  How to configure the windows firewall using group policies.
  Support:  
 support@lansweeper.com  
Skype: Lansweeper  
  Mo-Fri 9h-17h CET  
Welcome Guest Search | Active Topics | Log In | Register

Tag as favorite
LS 4.0 - Need to run a software report on a specific OU
Options
Previous Topic Next Topic
ESIT
#1 Posted : Tuesday, May 11, 2010 9:17:42 PM

Rank: Premium user

Groups: Member, Premium Users
Posts: 37
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!
Back to top
Lansweeper
#2 Posted : Wednesday, May 12, 2010 8:40:46 AM

Rank: Administration

Groups: Administration, Premium Users
Posts: 10,369
The software table and serialnumber tables are two separate things, you can't match them.

I suggest creating 2 different reports for this.
Back to top
ESIT
#3 Posted : Wednesday, May 12, 2010 4:00:40 PM

Rank: Premium user

Groups: Member, Premium Users
Posts: 37
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.
Back to top
Lansweeper
#4 Posted : Wednesday, May 12, 2010 5:15:12 PM

Rank: Administration

Groups: Administration, Premium Users
Posts: 10,369
Code:
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'
Back to top
ESIT
#5 Posted : Wednesday, May 12, 2010 5:39:21 PM

Rank: Premium user

Groups: Member, Premium Users
Posts: 37
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.
Back to top
ESIT
#6 Posted : Wednesday, May 12, 2010 6:25:45 PM

Rank: Premium user

Groups: Member, Premium Users
Posts: 37
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.
Back to top
ESIT
#7 Posted : Wednesday, May 12, 2010 6:46:41 PM

Rank: Premium user

Groups: Member, Premium Users
Posts: 37
Found my error, missed a level in the OU structure.

Thanks a ton for your help with this!
Back to top
Users browsing this topic
Guest
Tag as favorite
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Contact: E-mail Lansweeper - Skype : Lansweeper
Copyright 2004 - 2011 © Hemoco bvba