OS license compliance by OU

[Mecanova]

Could someone help or provide the correct report for this kind of thing, so basicly what I need is

Software - OU - License (sum of these for certain software)

Tried doing it myself but can't get the hold on the report builder 😛

[Hemoco]

Which version of the report builder are you using (can be found at the top left of the screen below the lansweeper logo)

[Pollak]

Still getting the syntax error near 'AS' even with your code that you provided.


SELECT TOP 100 PERCENT dbo.tblADComputers.OU, dbo.tblSoftware.softwareName, COUNT(dbo.tblADComputers.Computername) AS Total
FROM dbo.tblADComputers INNER JOIN
dbo.tblComputers ON dbo.tblADComputers.Computername = dbo.tblComputers.Computername INNER JOIN
dbo.tblSoftware ON dbo.tblComputers.Computername = dbo.tblSoftware.ComputerName
GROUP BY dbo.tblADComputers.OU, dbo.tblSoftware.softwareName
ORDER BY dbo.tblADComputers.OU, dbo.tblSoftware.softwareName





Please advise,
Niles

[Hemoco]

I'm pretty sure that this report is correct.
Are you sure that the ADcomputer information for these computers is scanned?

[Pollak]

Getting there. I figured out how to add it to the Dashboard, but I think the data is incorrect. It says that there is only 152 installs of McAfee and only in one OU, when I know we have about 3000 installs across all OUs.

[Pollak]

Okay, I got this to output in the report builder, but two things. One it displays the actual OU path and not a user friendly name for the OU. Two, I do not see it anywhere under the Dashboard.



Please advise,
Niles

[Pollak]

OKkay I imported this script, but I do not see anything seperating by OU.



Thanks,
Niles

[Hemoco]

Pollak wrote:
OKkay I imported this script, but I do not see anything seperating by OU.
Thanks,
Niles

Niles,

Create a new report with the report builder, use this sql code and add the report to your dashboard

[Hemoco]

Try this

SELECT     TOP 100 PERCENT dbo.tblADComputers.OU, dbo.tblSoftware.softwareName, COUNT(dbo.tblADComputers.Computername) AS Total
FROM         dbo.tblADComputers INNER JOIN
                      dbo.tblComputers ON dbo.tblADComputers.Computername = dbo.tblComputers.Computername INNER JOIN
                      dbo.tblSoftware ON dbo.tblComputers.Computername = dbo.tblSoftware.ComputerName
GROUP BY dbo.tblADComputers.OU, dbo.tblSoftware.softwareName
ORDER BY dbo.tblADComputers.OU, dbo.tblSoftware.softwareName

[Mecanova]

Any progress on this one?