I am running into some issues with my queries showing in accurate data. When viewing the SLM web UI I show certain data in regards to compliance EX: license requirements , Licenses Used
When I run the following
select * from [dbo].[tblComplianceSummary] c
inner join dbo.tblApplication a on c.ApplicationID= a.ApplicationID
where a.Name = '.net Reflector 10.0'
I get multiple .net Reflectors in the output all showing different Licenses requirements. In the web UI I am only seeing one. Is there a primary compliance table that I should be using when running compliance queries?