MS Office Report and Compliance

[dwieszczak]

I would like to generate a report with specific office versions, how many licenses I have and how many I need to be compliant just like the WUI shows. I want to export this to xls.

[dwieszczak]

Do you know the SQL query for the OS compliance used in the WUI?

[Hemoco]

dwieszczak wrote:
Do you know the SQL query for the OS compliance used in the WUI?

That's the one, but the build report editor does not understand specific mssql instructions.
In sql server management studio you should get it to work.

[dwieszczak]

I get a error in the report builder: Invalid token 'NULL' at position 64 line 3.
I cannot run the report.

[Hemoco]

This view is used to generate the licensing report, you can alter it to your needs:

SELECT     TOP 100 PERCENT dbo.tblLicenses.softwareName, dbo.tblLicenses.softwareVersion, dbo.web30repUsedSoftware.SoftwarePublisher AS Publisher, 
                      dbo.web30repUsedSoftware.[number in use], dbo.tblLicenses.Nrlicenses, dbo.tblLicenses.Priceperlicense, CASE WHEN ([number in use] > nrlicenses) 
                      THEN ([number in use] - nrlicenses) ELSE NULL END AS Missing, CASE WHEN ([number in use] > nrlicenses) THEN ([number in use] - nrlicenses) 
                      * priceperlicense ELSE NULL END AS Price
FROM         dbo.web30repUsedSoftware INNER JOIN
                      dbo.tblLicenses ON dbo.web30repUsedSoftware.softwareName = dbo.tblLicenses.softwareName AND 
                      dbo.web30repUsedSoftware.softwareVersion = dbo.tblLicenses.softwareVersion
ORDER BY CASE WHEN ([number in use] > nrlicenses) THEN ([number in use] - nrlicenses) * priceperlicense ELSE NULL END DESC, 
                      dbo.tblLicenses.softwareName, dbo.tblLicenses.softwareVersion