Generate Computer Software reports

[dwieszczak]

I would like to generate a report that is similar to what is displayed in the web interface when clicking on License compliance and then the software name. I am a SQL rookie and need some help. Where can I find the queries within the web configuration?

In other words I click on Microsoft Office 2003 and display all the computers that it is installed on. Where do I get that query? or can someone post it for me? Thanks.

[Hemoco]

SELECT     dbo.tblComputers.Computername, dbo.tblComputers.Domain, dbo.tblComputers.Userdomain, dbo.tblComputers.Username, 
                      dbo.tblOperatingsystem.Description, dbo.tblSoftware.Lastchanged, dbo.tblSoftware.softwareName
FROM         dbo.tblComputers INNER JOIN
                      dbo.tblOperatingsystem ON dbo.tblComputers.Computername = dbo.tblOperatingsystem.Computername INNER JOIN
                      dbo.tblSoftware ON dbo.tblComputers.Computername = dbo.tblSoftware.ComputerName
WHERE     (dbo.tblSoftware.softwareName LIKE '%office%')

you should change the '%office%' part

[dwieszczak]

What is the SQL query? I would like to export it to an excel file.

[Hemoco]

When you type in the software name in the software search field you should see all computers with this software installed.

URL should look like this : http://lansweepersite/default.aspx?item=softdetail&soft=Microsoft+Office+2003+Resource+Kit&v=11.0

(just an example)

[dwieszczak]

Computer, Description, domain and logged in user

[Hemoco]

Could you let us know the exact fields you want in your report?